ABAP CDS vs OPEN SQL ( What to use )

Q: When we can do almost everything in CDS as well as regular open SQL, why do we go for CDS in the real world?

Playlist

SAP ABAP on HANA course :-

ABAP SAP ABAP 7.4 / 7.5 New Syntax :-

Enhancement in ABAP :-

CDS in ABAP on HANA :-

[calltobharath]

Bhai .. I am extremely thankful to you for making this video. Now its crystal clear to me when we should use CDS.

1) In you video, you have called out a good point that whenever we have some buffered table, we should fetch
the data from this table separately and then use this in select using for all entries. I have made this mistake of
directly using buffered tables in select using join. Going forward, I will make sure not to do this
2) Coming to reusability, my understanding about leveraging this is that for every module, we will have some
frequently used tables. For example, for ISU we have FKKVKP, DFKKOP etc.. When I worked in a ISU project,
I saw that almost every single report was hitting 5-6 tables using template approach. I believe the best thing to do is
to link these tables via exposed association and let the rest of the developers in the team know about this. This way,
everyone can access the same CDS view instead of fetching the data from the individual tables.
3) Access control on select - Usually I have always had authorization object created for the program and then I check
if the user has the auth for executing the program. Select level auth check is interest - I am yet to watch your DCL
series. I will make sure to do that.
4) OData - I have fair understanding. But not extensive work exp. I only knew about the SEGW option. Have not tried the CDS with Odata option so far. Just like your every single video, I am waiting for your Odata series. We understand that you also have to take care of your current client's work and expectations. Still you are managing to find precious
time to educate us. We will patiently wait and learn from your Odata series - Bhai.
5) CDS View extension - I am sure you have this topic planned as a finishing touch to CDS series. We are eagerly waiting.
6) Quantity conversion is only available in CDS but not in Select query - Good point to know. You explained this
in a separate video where you beautifully did unit and qty conversion in CDS. Also you showed us how to achieve
unit conversion in open SQL.
7) CDS is a model for RAP, ODATA and BOPF - Now this reminds me of your very 1st video in CDS series where you
exactly mentioned this point. We can create complex data models using CDS and then reuse it across other
technologies. I see that I have to move from the daily open SQL ABAP to RAP and ODATA driven via CDS.

I am using Eclipse for my developments every day. This is only possible because I learnt Eclipse from you. In every single video of yours, starting from BADI and enhancements all the way till CDS and HANA series, you always used Eclipse for explaining the topics. Not just this, you always tell the shortcuts when you are using it during the video. For example, how to file table type using filters in Eclipse. Ctrl + Shift + A. ABAP and Debug perspectives. Every single point that I know today about Eclipse - I learnt it from your videos only. Initially it was overwhelming for me to remember the shortcuts. After a while, I realized that I am only using a handful of Eclipse shortcuts frequently and now I am really enjoying Eclipse. It took me several weeks to transition to Eclipse completely. Whenever I was thinking - Yaar for debugging let me use GUI. I will watch your video and will get motivated to use Eclipse for everything. You are extremely comfortable with Eclipse which we can see from your videos and that drove me to continue trying Eclipse for all the functions. I can finally say - I love Eclipse so much. Entire credit - Goes to you Bhai.

I am reading SAP Press CDS book and that is when I realized how you have taught us the concept so beautifully. If I had read the book first without watching your videos, 200% I wouldn't have understood anything. Literally in the very 1st chapter, they have used associations and just after seeing that I would have closed the book. But you taught us in your 8th video and you beautifully laid the foundation first. I like the way you plan the order of your videos - Taking the concepts one step at a time so that we can easily understand.

I have only 1 request for you.. Whenever you find time, please keep sharing your SAP learning journey with us. I will be watching every single video that you create as I am learning so much.

[nikhilraut]

This is a most frequently asked question, you explained it very well !!

[calltobharath]

Bhai.. You are absolutely correct with the points that you have called out in this video.
From SAP press book, I can see below content:

ABAP CDS and its annotations can be used to enhance the model with information
that can be optimally integrated into the interfaces for cloud applications
or other user interfaces (UIs) via OData, a model-based protocol.
Therefore, CDS and the programming model based on it form the basis of
SAP Fiori applications, which embody the new standard for the modern
user experience of SAP applications.

[devendrapatel]

What is the difference between Open SQL, native SQL and CDS view entity? How Open SQL and CDS view entity are different?

[sanjayakunar]

Sir this is amazing playlist to learn CDS view devlopment.could you start the playlist of ui5 & foiri for ABAP environment

[abaper]

Hello Sir,

I can not find any video in your playlist for Standard CDS Extension.. Have created any? If yes, please share the link.

Thank you for your guidance through videos. :)

[sanjayakunar]

Please sir make a playlist of ui5 &foiri

[MUNESHKUMAR-jukg]

Hi, Thanks for the vedio .Can you pls start vedio for VDM concepts just like you did for CDS AND AMDP

[madhusapabap]

Hi, Ram, have a good day, thanks for the videos, HANA ALV compare to container, how its differ whats the advantage

[pulkitagrawal]

If select options is needed then we can’t use CDS