CDS and AMDP Interview Questions

CDS and AMDP Interview Questions:
1. Difference between CDS and AMDP ?
CDS AMDP
CDS is a database entity which is used to fetch the data AMDP - is a Data base procedure (ABAP Managed
from DDIC/Standard CDS views or any data sources. It Database procedure) is a Global class with the
also creates the SQL view name in SAP with the name implemented interface (IF_AMDP_MARKER_HDB). It
provided as part of annotation doesn't create any Views in SAP.
@AbapCatalog.sqlViewName
Using CDS Variant - CDS Table function, you can do
AMDP (which is actually called as AMDF -> ABAP
Managed Table function) similar to AMDP.
Very Limited functions like CAST, STRING Functions, AMDP handles the complex logic as AMDP supports only
CURRENCY_CONVERSION, UNIT_CONVERSION, SQL language for Data fetching. Since the AMDP is a
DECIMAL_SHIFT are handled in CDS. Database procedure written at Data base layer (CODE
Less complex logic is handled at CDS level. PUSH DOWN), the performance is much higher than
Supports CODE PUSH DOWN. traditional ABAP ( data fetching is done at Application
server)
Debugging CDS view is not possible Debugging AMDP is possible
CDS supports very limited SQL. AMDP supports 90% of SQL, hence we can use SQL
functions like STRING functions, Window functions etc.
2. Difference between CDS Table function and AMDP ?
CDS Table Function AMDP

CDS Table function creates a CDS view that is AMDP - is a Data base procedure (ABAP Managed
implemented by class method which should implement Database procedure) is a Global class with the
interface IF_AMDP_MARKER HDB. The result set of the implemented interface (IF_AMDP_MARKER_HDB). It
class method is the CDS view. In this case, it is called as doesn't create any Views in SAP. ABAP MANAGED
ABAP MANAGED DATABASE FUNCTION. DATABASE PROCEDURE.
CDS Table function accepts Parameters that should not
exceed 1333 characters. Any ABAP Program that uses
CDS table function as data source must convert the
Select options to the string and pass as a parameter to
CDS Table function.
Debugging is possible. As this is similar to AMDP. Debugging AMDP is possible
We can create normal CDS Basic Views, Composite views AMDP cannot be used with CDS views. AMDP can only
on top of CDS Table function. be used in ABAP logic to get the data (as a global class
method).
3. What is Association in CDS View ?
-> Association is used to join the two or more data sources (CDS views or Tables/Views). By default it is
Left outer join. Association has Cardinality which denotes the relation (0..1), (1..1), (0..N), (1..N).
-> Association is used to create a Foreign Key Relation ship between data sources with annotation
@ObjectModel.Foreignkey.association 'Association alias'.
-> Association is an ON DEMAND JOIN. CDS views will never consume the memory from the associated
view unless the fields from the associated view are exposed as part of the result set of CDS view.
In this example, the memory is consumed only fro Website and

AirlineDistance fields. If the fields are not required then no memory consumption happens.
-> Associations are mainly useful when the extension is carried out on the Standard CDS view, where the
requirement is to have text field from Standard CDS view which has associations.
4. What are the System Variables in CDS view ?
-> $session.system_date, $session.system_language, $session.client, $session.user
5. How do you provide security on CDS Views ?
-> To allow only the authorized users to access CDS Views, We need to create DCL CDS Views. Data
control Language CDS views will be created on top of Basic CDS views with the authorization object.
The highlighted annotation checks for the

security. If the authorized user then he/she can access the data.
Access Control
Views.docx
6. How do you expose CDS data source as ODATA Service ?
-> using annotation @Odata.publish: true and activate the CDS data object in /IWFND/MAINT_SERVICE
transaction code.
7. How to create a Selection screen for the consumption view ?
-> Consumption view is an Analytic Query with annotation @Analytic.query : true

use @Consumption.filter annotation to create selection screen.
8. Can we call any ABAP function module or any abap object in AMDP class ?
-> NO. AMDP is a data base procedure which doesn't support ABAP. It only supports pure SQL.
9. What is the mandatory statement to call class as an AMDP class ?
Implement interface -> IF_AMDP_MARKER_HDB. Hence, class is called as AMDP class.
10. Can we call another AMDP method inside an AMDP method ?
YES.
11. Can we have Normal methods in AMDP class ?
YES.
12. Can we call normal methods in AMDP methods?
NO.

CDS and AMDP Interview Questions

Uploaded by

Copyright:

Available Formats

CDS and AMDP Interview Questions

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

CDS and AMDP Interview Questions

Uploaded by

Copyright:

Available Formats

CDS and AMDP Interview Questions:

1. Difference between CDS and AMDP ?

2. Difference between CDS Table function and AMDP ?

CDS Table Function AMDP

3. What is Association in CDS View ?

In this example, the memory is consumed only fro Website and

4. What are the System Variables in CDS view ?

-> $session.system_date, $session.system_language, $session.client, $session.user

5. How do you provide security on CDS Views ?

The highlighted annotation checks for the

6. How do you expose CDS data source as ODATA Service ?

7. How to create a Selection screen for the consumption view ?

-> Consumption view is an Analytic Query with annotation @Analytic.query : true

9. What is the mandatory statement to call class as an AMDP class ?

Implement interface -> IF_AMDP_MARKER_HDB. Hence, class is called as AMDP class.

10. Can we call another AMDP method inside an AMDP method ?

11. Can we have Normal methods in AMDP class ?

12. Can we call normal methods in AMDP methods?

You might also like