ABAP CDS View

[Former Member]

Hi,

       In which scenario ABAP CDS view and HANA CDS View & AMDP procedure will be used. I would like to know difference between them. 

Regards,

Karthic S 

[former_member182546 · Accepted solution]

Hi Karthic,

Both CDS and AMDP has similar performance .

in CDS - there is not internal table involved for output

in AMDP - we can use internal tables for get the output.

Please refer to below link for further reference .

With regards ,

Sudhir S

[christianlechne]

Hi Karthic,

ABAP Core Data Service Views are the new view type supported since SAP NetWeaver 740 SP05. This view type allows the definition of more sophisticated logic than classical SE11 views e. g. semantically enriched data models. More info can be found in ABAP Keyword Documentation - CDS 7.40 and ABAP Keyword Documentation - CDS 7.50. CDS Views are (except for some exceptions in  7.40) database agnostic and allow a code push-down (pushing your data-intensive calculations to the database)

ABAP Managed Database Procedures (AMDP) is also an option for the Code PushDown but is database specific(!) and currently only supported for SAP HANA as database. These procedures allow the call of SQLScript from ABAP in SAP HANA. See ABAP-Managed Database Procedures (AMDP) - About the ABAP for SAP HANA Development User Guide - SAP L...

In addition, there are so called Table Functions (NW 7.50) that are a "mixture" of CDS Views and AMDPs. See ABAP CDS - Table Functions - ABAP Keyword Documentation 

Hope that helps.

BR

Christian