This video is a tutorial on creating CDS table functions and understanding the AMDP framework in SAP. Here’s a summary of the key points:
- CDS Table Function: The presenter explains how to create a CDS table function, which is similar to creating a CDS view. The CDS table function is created in the Data Definition Language Source (DDLS) and can be used as a data source in SQL statements and DDIC-based CDS view entities.
- AMDP Framework: The presenter explains that the AMDP (ABAP Managed Database Procedures) framework manages database procedures and functions. These procedures and functions are created in ABAP and can be consumed in day-to-day programming. The presenter emphasizes that AMDP is currently only supported by SAP HANA.
- AMDP Class and Method: The presenter demonstrates how to create an AMDP class and method. The class is created by implementing the IF_AMDP_MARKER_HDB interface, which converts a normal class into an AMDP class. The method is created by declaring a static method with the FOR TABLE FUNCTION keyword and the name of the CDS table function.
- AMDP Function Implementation: The presenter explains how to implement an AMDP function. The function is implemented in a class method and uses the BY DATABASE FUNCTION keyword. The function is read-only and uses the SQLScript language.
- Demonstration: The presenter demonstrates how to use the CDS table function and AMDP function to retrieve data from a database. He shows how to call the functions in a SELECT statement and how to display the retrieved data.
- Important Points: The presenter discusses some important points about using CDS table functions and the AMDP framework. He explains that CDS table functions can only be created for databases that support AMDP, and that AMDP functions are read-only and need to be called in a SELECT statement in SQLScript. He also emphasizes that AMDP functions can be used to create database procedures and that they can be used in other AMDP procedures or functions.