004 Types of Associations in CDS - Exposed and AdHoc

[@moisted]

I don't think this is correct. Adhoc association does not always create a join. If the UI is asking for only the main table fields, the join will not be created. Only if one of the fields from associated table is requested will the join be done . Am I wrong?

[@ZAPYard]

Thank you Ramin for the clarification.
Team ZAPYard.

[@yadhunandsrinivasan5858]

@@ZAPYard are you agreeing with Ramin's statement, that the Ad-Hoc Association as well will not be executed until the UI requests for that field ?

[@prabhakars.k.5070]

Really more useful information and nice explanation with examples

[@ZAPYard]

Thank you Prabhakar

[@amareshkmishra7909]

Raju sir you are so talented dada.really cleared my doubt between CDs view with join n association

[@ZAPYard]

:)

[@amareshkmishra7909]

wow so nice and informative

[@indrayad]

In Exposed Association , how to you drill down to the the field from the target table ? where do you rt click ? in RSRT ? . Can you please give us an example ?

[@ZAPYard]

sure. we will try to prepare a video and share.

[@groomwithkj5427]

Such nice explaination...many thanks

[@ZAPYard]

Thank you Khusbhu. Glad you find it useful. Please keep visiting.
Team SAPYard.

[@ashutoshthorat9059]

Which association is faster with respect to performance??

[@ZAPYard]

we r not sure of the performance.. but Exposed is better if you do not want the data in the same view but anticipate some other views might need it and if exposed, it comes handy.. re-usable. Also, Exposed do not do Join unless consumed.
Team SAPYard.

[@ashutoshthorat9059]

Sorry for replying a little late but that's a lot of info...Thanks

[@AmanKumar-nk1eb]

m.mara = _plant.mara or m.matnr=_plant.matnr. Please share the correct join condition.

[@ZAPYard]

Dear Aman - Thank you for pointing out the issue.
Yes it should be m.matnr = _Plant.matnr.
Team SAPYard.