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.
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
what an awesome explanation all my dought related to Association are clear now great explanation method thank you ganesh
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.
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
Great Explanation 😊
Thank you
Amazing videos Ganesh, are you also take classes
Thank you, and not taking any classes.
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..
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.
Association table is displayed with all the fields when you access the mapping, how to display selected fields from associations?
Welcome!
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.
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..
Thank you🙏
Welcome!
Thank you sir
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
hi Sir, thanks for the videos.
Can CDS views can be debugged?
If so Can you please tell me how?
Welcome! actual CDS cannot be debugged as it is a single SQL. But you can debug if you used any AMDP methodology either table function or procedures.
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,
}