Program guideline - Open SQL, CDS and AMDP

[former_member204244]

Hello Experts,

I am new in HANA and am very keen in learning HANA concepts. From online tutorials, have been able to understand the concepts of Open SQL, CDS and AMDP like how to create them and their purpose.

Request you to please help me in understanding what is the programming guidelines for OPEN SQL, CDS and AMDP - when to use Open SQL , in which scenarios we should go for CDS and when to go for AMDP.

I understand that CDS should be used when query to be created as reusable.

But i am looking for guidelines that we can follow and can make best use of best way.

Thank You.

Ishani

[gasparerdelyi · Accepted solution]

With respect to ABAP CDS I can recommend the Best Practice guides at https://tinyurl.com/ABAP-CDS-inside-S4HANA and https://tinyurl.com/ABAP-CDS-inside-BusinessSuite

CDS views are often used also for the ease of generation of objects (like OData service, Fiori UI, ODP provided, BW query).

Otherwise, the most important principle is keep it as simple as possible -- do not reimplement in AMDP if you can achieve your objectives by transparent SQL optimization or by ABAP CDS, too...

[Jelena_Perfiljeva]

Google -> CDS vs. AMDP site:sap.com -> finds the same question from 2018, which is answered. I believe all that information is still accurate.