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
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 (,)?
@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
Thank you so much for your videos. U have done a great help to the abap community😊
Welcome!!! nothing big Jay - just my knowledge.
Thanku very much Ganeshji,,!!! great work..
Thank you
Very Useful..can follow easily..Thanks alot for sharing valid info
Thank you
Thanks a lot, Ganesh, your videos are very helpful!
Welcome
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
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 (,)?
Ganesh - Rockstar!
Is it possible to perform an association to view with parameter?
Yes, we can.
Thank you for your videos
Thank you so much ganesh ....
Welcome!!!
@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
I am preparing for a video on this topic, will make is soon.
good! helpful!
Thank you sir
Welcome!