Q. What is the syntax to create AMDP in a class-method? METHOD method_name BY DATABASE PROCEDURE FOR db_name(HDB) LANGUAGE sqlscript OPTIONS READ-ONLY USING dbtab1 dbtab2 amdpname. ….. …. … ENDMETHOD. Q. What is CDS View? Ans. CDS view is basically an abstraction of ABAP to Database layer which allows you to model semantic rich data models ( like Information views on HANA DB ) on ABAP Stack and on activation it leads to creation of corresponding Database View in DB. It is an enhancement of SQL which provides us DDL for defining semantically rich data models (table/view) and user define types in Database. It is an extension of SQL : i.e DDL DQL and DCL St. The objective behind creating CDS Data Model is that , it will be understood by all SAP products viz SAP Fiori, KPI modeler, BO/BI, BOPF, FPM, IDA Native HANA Apps.
