Please enable JavaScript.
Coggle requires JavaScript to display documents.
HA400-5 - Code-to-Data with SAP HANA as Primary Database - Coggle Diagram
HA400-5 - Code-to-Data with SAP HANA as Primary Database
ABAP-Managed Database Procedures
Standard ABAP class methods are used as containers for the implementation of AMDPs
Identified with the syntax BY DATABASE PROCEDURE
Database system specified (for example HDB)
Language specified (for example SQL Script)
Can be marked as a READ-ONLY database procedure
List all ABAP Dictionary tables, views and other procedures in the USING clause
Method body implemented using native SQL Script source code
Implement Marker Interface IF_AMDP_MARKER_HDB
AMDP method parameters
Can be importing, exporting or changing parameters
Have to be passed by value
Must be of either table or scalar types
Any table parameter line types can only have elementary components
Use ABAP Development Tools for full AMDP support
AMDP Enhancement
Enhancement Spot and BAdI definition cretaed by Software Provider
BAdI definition marked as AMDP BAdI
Fallback Class required
Debugging ABAP-Managed Database Procedures
The ABAP user executes ABAP application => Usual authorizations
The SAP HANA user debugs DB procedure. He needs authorizations to read HANA Catalog, attach debugger and debug
The SAP<SID> user used by AS ABAP to access database initiates procedure execution and grants permissions to SAP HANA user to attach a debugger to SAP<SID> user sessions