The video tutorial is a continuation of a tutorial series on ABAP Managed Database Procedures (AMDP) in SAP. Here’s a summary of the key points:
- AMDP Options: The video discusses the use of AMDP options, specifically the CDS session client option. This option is used when calling a CDS view in an AMDP method. The presenter explains that the CDS session client option is used to set the CDS client value in the global variables of SAP HANA SQLScript.
- Creating an AMDP Method: The presenter demonstrates how to create an AMDP method that calls a CDS view. The method is declared as a static method, which means it can be called directly using the class name. The presenter shows how to pass a client value to the method and how to retrieve data from a CDS view.
- Client Handling in AMDP: The presenter explains that client handling in AMDP is not implicit and must be done explicitly. This means that the client value must be passed as a parameter when calling an AMDP method, and it must be included in the WHERE condition when selecting data from a CDS view.
- CDS Session Client Option: The presenter shows how to use the CDS session client option in an AMDP method. This option is used to set the CDS client value in the global variables of SAP HANA SQLScript. The presenter explains that this value is used when the CDS view is called in the AMDP method.
- Demonstration: The presenter demonstrates how to call the AMDP method from a program. He shows how to pass a client value to the method and how to display the retrieved data. The presenter also shows what happens when the CDS session client option is not used or when a different client value is passed.
- Important Points: The presenter discusses some important points about using the CDS session client option in AMDP. He explains that this option should be used when calling a CDS view or another AMDP method in an AMDP method. He also emphasizes that client handling in AMDP must be done explicitly.