step one
step two
step three
code1CLASS zcl_demo_flight_calculation DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES: if_amdp_marker_hdb. CLASS-METHODS: get_details FOR TABLE FUNCTION ZDEMO_FLIGHT_CDS_TF. PROTECTED SECTION. PRIVATE SECTION.ENDCLASS.CLASS ZCL_DEMO_FLIGHT_CALCULATION IMPLEMENTATION.* <SIGNATURE>---------------------------------------------------------------------------------------+* | Static Public Method ZCL_DEMO_FLIGHT_CALCULATION=>GET_DETAILS* +-------------------------------------------------------------------------------------------------+* +--------------------------------------------------------------------------------------</SIGNATURE> METHOD get_details BY DATABASE FUNCTION FOR HDB LANGUAGE SQLSCRIPT OPTIONS READ-ONLY USING spfli. RETURN SELECT mandt, carrid, connid, countryfr, cityfrom, airpfrom, countryto, cityto, airpto FROM spfli WHERE carrid = iv_carrid;ENDMETHOD.ENDCLASS.code1code 2define table function zdemo_flight_cds_tfwith parameters iv_carrid : s_carr_idreturns { mandt: s_mandt; carrid: s_carr_id; connid: s_conn_id; countryfr: land1; cityfrom: s_from_cit; airpfrom: s_fromairp; countryto: land1; cityto: s_to_city; airpto: s_toairp;}implemented by method zcl_demo_flight_calculation=>get_details;code 2code 3*&---------------------------------------------------------------------**& Report zcds_with_if_amdp*&---------------------------------------------------------------------**&*&---------------------------------------------------------------------*REPORT zcds_with_if_amdp.SELECT * FROM zdemo_flight_cds_tf( iv_carrid = 'LH' ) INTO TABLE @DATA(lt_flight) ##db_feature_mode[amdp_table_function].cl_demo_output=>display_data( EXPORTING value = lt_flight ).code 3