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
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.
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?
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.
what an awesome explanation all my dought related to Association are clear now great explanation method thank you ganesh
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..
Thank you and glad my videos are useful
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
Thank you a lot. The video is very useful and easy to understand. Looking forward to your next videos
Hope you might find the next one as well in the same playlist.
Great Explanation 😊
Thank you
Association table is displayed with all the fields when you access the mapping, how to display selected fields from associations?
Welcome!
Can we publish this same CDS over Odata and get the data as you showed (selecting any order and displaying material and customer associations data )?
Yes, that needs the PULISH option to enable the data from the UI level..
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.
Welcome! Mostly same table record has split into multiple UI screen then association for the same table needs.
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?
I will try to make a video on this to explain..
Amazing videos Ganesh, are you also take classes
Thank you, and not taking any classes.
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.
Thank you sir
Welcome!
Thank you🙏
Welcome!
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.
What is po
@@pavanisweety1840 purchase order
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,
}