ABAP Keyword Documentation → ABAP − Reference → Processing External Data → ABAP Database Access → ABAP and SAP HANA → Access to Objects in SAP HANA XS → Access to SAP HANA XSC Objects
Database Procedure Proxies for SQLScript Procedures in the SAP HANA Repository
When calling SQLScript procedures in the
SAP HANA Repository, the
Native SQL and
AMDP methods exist alongside the special statement
CALL DATABASE PROCEDURE, which can be used to access the database procedure using a
database procedure
proxy saved in ABAP Dictionary. The database procedure proxy maps the database types of the interface parameters of the database procedures to ABAP data types. A
database procedure interface
is generated for these data types. The calling ABAP program can reference the types of this global interface.
Other versions:
7.31 | 7.40 | 7.54
Notes
- ABAP Managed Database Procedures (AMDP) offers an alternative way of managing and calling database procedures in ABAP. It is far easier to handle database procedures using AMDP than with the calls using database procedure proxies described here, which is why AMDP is recommended whenever the standard database of the current AS ABAP is an SAP HANA database and no secondary connection to another SAP HANA database is needed.
- Calling SQLScript procedures in SAP HANA XS:
- SQLScript procedures in SAP HANA XSC are saved in the SAP HANA Repository can database procedure proxies can be used to call them from ABAP.
- SQLScript procedures in SAP HANA XSA, the successor to SAP HANA XSC, are usually HDI objects for which no database procedure proxies can be created. Alternative methods such as AMDP or ADBC must be used for these calls instead.