SAP ABAP

  CDS Table Function: @EndUserText.label: 'Prod Order TF' define table function ZVB_TF_PROD_ORD with parameters p_aufnr : aufnr returns { client : abap . clnt ; Prod_order : aufnr ; order_type : auart ; } implemented by method zvb_class_tf => get_ord_details ; AMDP Function: CLASS zvb_class_tf DEFINITION PUBLIC . PUBLIC SECTION. CLASS-METHODS: get_ord_details FOR TABLE FUNCTION ZVB_TF_PROD_ORD . INTERFACES: IF_AMDP_MARKER_HDB . PROTECTED SECTION. PRIVATE SECTION. ENDCLASS . CLASS zvb_class_tf IMPLEMENTATION. METHOD get_ord_details BY DATABASE FUNCTION FOR HDB LANGUAGE SQLSCRIPT OPTIONS read-ONLY USING AUFK . return SELECT mandt as client , aufnr as prod_order , auart as order_type from aufk WHERE aufnr = : p_aufnr ; ENDMETHOD. ENDCLASS.   Execute CDS Table Function ZVB_TF_PROD_ORD        

CLASS zvb_amdp_class1 DEFINITION   PUBLIC   FINAL   CREATE PUBLIC .     PUBLIC SECTION.     TYPES: tt_vbeln TYPE RANGE OF vbeln ,            BEGIN OF ty_vbak ,              mandt TYPE vbak - mandt ,              vbeln TYPE vbak - vbeln ,              erdat TYPE vbak - erdat ,              ernam TYPE vbak - ernam ,            END OF ty_vbak ,            tt_vbak TYPE TABLE OF ty_vbak .       CLASS-METHODS: so_data IMPORTING VALUE( it_vbeln ) TYPE tt_vbeln         ...

1.Which supports the additional functionalities which are not supported by CDS. 2.SQL statements will written and will use SQL functions and methodologies. 3.Table function has optional input parameters and return parameters. 4.Needs class and method to define. -Class:Public, Method:Static 5.The statement Interface:IF_AMDP_MARKER_HDB must be use. 1.Creation of Table Function: Create a Data Definition and select template 'Define Table Function with Parameters' @EndUserText.label: 'Prod Order TF' define table function ZVB_TF_PROD_ORD //with parameters parameter_name : parameter_type returns { client : abap . clnt ; Prod_order : aufnr ; order_type : auart ; } implemented by method zvb_class_tf => get_ord_details ;   2.Creation of Class: CLASS zvb_class_tf DEFINITION PUBLIC . PUBLIC SECTION. CLASS-METHODS: get_ord_details FOR TABLE FUNCTION ZVB_TF_PROD_ORD . INTERFACES: IF_AMDP_MARKER_HDB . PROTECTED SECTION. PRIVATE SECTION. ENDCLASS. ...