ABAP On HANA

CLASS zcl_amdp_client DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES if_amdp_marker_hdb . TYPES : tt_zcds_sample_01 TYPE TABLE OF zvsql_sample_01 . CLASS-METHODS get_data_cds AMDP OPTIONS CDS SESSION CLIENT iv_clnt IMPORTING VALUE( iv_clnt ) TYPE sy - mandt EXPORTING VALUE( et_so ) TYPE tt_zcds_sample_01 . PROTECTED SECTION. PRIVATE SECTION. ENDCLASS . CLASS zcl_amdp_client IMPLEMENTATION. METHOD get_data_cds BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT USING zcds_sample_01 . et_so = select * from zcds_sample_01 WHERE mandt = : iv_clnt ; * Where mandt = session_context( 'CDS_CLIENT' ); ENDMETHOD. ENDCLASS. ********************************************************************** ********************************************************************** *AMDP does not support implicit clie

CLASS zcl_amdp_class DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES if_amdp_marker_hdb . TYPES: BEGIN OF ty_cust , cust_name TYPE kna1 - name1 , netwr TYPE vbak - netwr , END OF ty_cust , tt_cust TYPE TABLE OF ty_cust . TYPES: BEGIN OF session_variables , client TYPE sy - mandt , cds_client TYPE sy - mandt , uname TYPE sy - uname , langu TYPE sy - langu , datum TYPE sy - datum , END OF session_variables . CLASS-METHODS get_session_variables_amdp AMDP OPTIONS READ-ONLY CDS SESSION CLIENT iv_clnt IMPORTING VALUE( iv_clnt ) TYPE sy - mandt EXPORTING VALUE( clnt ) TYPE session_variables - client VALUE( cds_clnt ) TYPE session_variables - cds_client VALUE( unam ) TYPE session_variables - uname VALUE( lang ) TYPE session_variables - langu

CRUD:- Create Read Update Delete Read -     /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet + GET =>  employeeset_get_entityset.     /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(2) + GET => EMPLOYEESET_GET_ENTITY Create :-     /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet + POST + Payload => employeeset_create_entity Update     /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(6) + PUT + Payload  => 'EMPLOYEESET_UPDATE_ENTITY'  Delete    /sap/opu/odata/sap/ZEMPLOYEE_002_SRV/EmployeeSet(6) + DELETE => 'EMPLOYEESET_DELETE_ENTITY'  ************************************************************************************************************ Access data through navigation    /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderHeaders('4969')/Items    /sap/opu/odata/sap/ZSALESORDER_002_SRV/SalesOrderItems => salesorderitems_get_entityset Read with navigation path /sap/opu/odata/sap/ZSALESORDER_001_SRV/SalesOrderHeaderS + Get      =>salesorderhe