Video - 8 CDS View Association Part 2

[@jaychandran3631]

Thank you so much for your videos. U have done a great help to the abap community😊

[@just2shareji]

Welcome!!! nothing big Jay - just my knowledge.

[@santoshrghag]

Thanku very much Ganeshji,,!!! great work..

[@just2shareji]

Thank you

[@princemishra9255]

Thanks a lot, Ganesh, your videos are very helpful!

[@just2shareji]

Welcome

[@ayeeshask9576]

Very Useful..can follow easily..Thanks alot for sharing valid info

[@just2shareji]

Thank you

[@buvaneswarianguchamy495]

HI Ganesh, Thank you very much for your videos. Its very much helpful. Can you please suggest a sample exercise (any use case in real time) for creation of CDS views

[@rajameenasankar1851]

Hi Ganesh,
Thanks for the videos. they are very helpful and gives a clear picture.
I do have a doubt, What if we need customer name for more than 1 specific customer numbers.should we add those in the same expression using (,)?

[@SAP_USER]

💯

[@just2shareji]

Thank you

[@null-user-null]

Ganesh - Rockstar!

[@iqboladahamjonov9835]

Thank you for your videos

[@mani8931]

Thank you so much ganesh ....

[@just2shareji]

Welcome!!!

[@praveenkrishnapadmanabhan3729]

Is it possible to perform an association to view with parameter?

[@just2shareji]

Yes, we can.

[@sasmitaparida2037]

good! helpful!

[@venkataabhilashdasam6658]

Thank you sir

[@just2shareji]

Welcome!

[@sudhirsud1106]

@ganesh : What is the use of $projection in association, help me with below code differences, in below on BUT000 association I used
projection for first query and where as second query its general inner join way to use.
With Projection
define view ysu_jan_CDS2 as select from vbap association [1] to vbak as _vbak on vbap.vbeln = _vbak.vbeln
association [1] to but000 as _bp on $projection.ernam = _bp.partner {
vbeln, // Check association without key and with key both differences
posnr,
_vbak.erdat,
_vbak.ernam as ernam,
_vbak, //
_bp //
} group by vbeln,posnr,_vbak.erdat,_vbak.ernam
Without projection:
define view ysu_jan_CDS2 as select from vbap association [1] to vbak as _vbak on vbap.vbeln = _vbak.vbeln
association [1] to but000 as _bp on _vbak.ernam = _bp.partner {
vbeln, // Check association without key and with key both differences
posnr,
_vbak.erdat,
_vbak.ernam as ernam,
_vbak, //
_bp //
} group by vbeln,posnr,_vbak.erdat,_vbak.ernam

[@just2shareji]

I am preparing for a video on this topic, will make is soon.