You Rock Ganesh Bhai.. the way of explaining the concepts with examples in system at the same time is so great... makes it easy to handle the real time scenarios..
Excellent bro now I understand Innerjoin executes before f8 and display all data.based on request data from association in output we get required data from associations
Thanks for the video sir! I have a doubt, how the association can be used from UI level? ie, for now only the fields selected from source table would be displayed, but how does the association fields that are made public would be accessed? Can you please explain this?
Hi Sir, Thanks for the wonderful vedio on association in CDS views. wanted to know the best scenario to handle association to same table multiple times. Thanks in Advance.
You have commented out the material association as the condition was on field from association. How to associate in such case when you need condition on field from association
As you know the association is the lazy join, so i have commented and can be accessed on top of the CDS. If you need to add WHERE, then you can add in the base or the final consumption view.
I don't understand why you use an outer join on material and customer and not inner joins. Logically the material and the customer must exist so inner seems more appropriate imo.
There are some scenarios where you can make PO without material, and I am using rental system so data is very less. So i preferred outer join for good volume data.
If you want your Association is to be accessible by another application or CDS View you need to keep it as public. { // Association as public _SItem, _Billing, _Material, _Customer // Here I need key _SHeader.vbeln, _SHeader.vbtyp, }