ABAP Select data from SAP table /DMBE/S_ITEMPLATEPRICINGITE_D into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP /DMBE/S_ITEMPLATEPRICINGITE_D table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to /DMBE/S_ITEMPLATEPRICINGITE_D. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the /DMBE/S_ITEMPLATEPRICINGITE_D table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_/DMBE/S_ITEMPLATEPRICINGITE_D TYPE STANDARD TABLE OF /DMBE/S_ITEMPLATEPRICINGITE_D,
      WA_/DMBE/S_ITEMPLATEPRICINGITE_D TYPE /DMBE/S_ITEMPLATEPRICINGITE_D,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: </DMBE/S_ITEMPLATEPRICINGITE_D> TYPE /DMBE/S_ITEMPLATEPRICINGITE_D.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_/DMBE/S_ITEMPLATEPRICINGITE_D.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /DMBE/S_ITEMPLATEPRICINGITE_D
  INTO TABLE IT_/DMBE/S_ITEMPLATEPRICINGITE_D.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /DMBE/S_ITEMPLATEPRICINGITE_D
*  INTO TABLE @DATA(IT_/DMBE/S_ITEMPLATEPRICINGITE_D2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_/DMBE/S_ITEMPLATEPRICINGITE_D INDEX 1 INTO DATA(WA_/DMBE/S_ITEMPLATEPRICINGITE_D2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/DMBE/S_ITEMPLATEPRICINGITE_D ASSIGNING </DMBE/S_ITEMPLATEPRICINGITE_D>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</DMBE/S_ITEMPLATEPRICINGITE_D>-PRICINGUUID = 1.
</DMBE/S_ITEMPLATEPRICINGITE_D>-DEALUUID = 1.
</DMBE/S_ITEMPLATEPRICINGITE_D>-ITEMINDEX = 1.
</DMBE/S_ITEMPLATEPRICINGITE_D>-PERCENTAGE = 1.
</DMBE/S_ITEMPLATEPRICINGITE_D>-EVENT = 1.
ENDLOOP.

LOOP AT IT_/DMBE/S_ITEMPLATEPRICINGITE_D INTO WA_/DMBE/S_ITEMPLATEPRICINGITE_D.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FIXEDPERIOD, sy-vline,
WA_/DMBE/S_ITEMPLATEPRICINGITE_D-DEEMEDSTARTDATE, sy-vline,
WA_/DMBE/S_ITEMPLATEPRICINGITE_D-DEEMEDENDDATE, sy-vline,
WA_/DMBE/S_ITEMPLATEPRICINGITE_D-OFFSETROUTINE, sy-vline,
WA_/DMBE/S_ITEMPLATEPRICINGITE_D-OFFSETROUTINEQTT, sy-vline,
WA_/DMBE/S_ITEMPLATEPRICINGITE_D-OFFSETROUTINEUOM, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/DMBE/S_ITEMPLATEPRICINGITE_D you want to display... WRITE:/ sy-uline. * Aternatively use generic code to Write field values (and NAME) to screen report DO. ASSIGN COMPONENT sy-index OF STRUCTURE wa_/DMBE/S_ITEMPLATEPRICINGITE_D TO <field>. IF sy-subrc <> 0. EXIT. ENDIF. WRITE:/ 'Field Value', <field>, sy-vline. gd_str = <field> . lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ). lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ). WRITE:/ 'Field Name', lv_fieldname. ENDDO. *Redo loop but convert all fields from internal to out value LOOP AT IT_/DMBE/S_ITEMPLATEPRICINGITE_D INTO WA_/DMBE/S_ITEMPLATEPRICINGITE_D. *Write horizonal line to screen report. WRITE:/ sy-uline. *Convert all fields to display/output versions using conversion routines PERFORM convert_all_field_values CHANGING wa_EKKO. ENDLOOP. *&---------------------------------------------------------------------* *& Form convert_all_field_values *&---------------------------------------------------------------------* FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO. DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.

*Conversion exit ALPHA, internal->external for field ITEMINDEX CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-ITEMINDEX IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-ITEMINDEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DCCUR, internal->external for field SURCHARGERATE CALL FUNCTION 'CONVERSION_EXIT_DCCUR_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-SURCHARGERATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-SURCHARGERATE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field SURCHARGEUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-SURCHARGEUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-SURCHARGEUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field QUANTITYFROMUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-QUANTITYFROMUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-QUANTITYFROMUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field QUANTITYTOUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-QUANTITYTOUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-QUANTITYTOUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DCCUR, internal->external for field AMOUNT CALL FUNCTION 'CONVERSION_EXIT_DCCUR_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field PERQUANTITYUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-PERQUANTITYUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-PERQUANTITYUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PERIODDETERMINATIONRULE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-PERIODDETERMINATIONRULE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-PERIODDETERMINATIONRULE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DCCUR, internal->external for field FIXEDTERMRATE CALL FUNCTION 'CONVERSION_EXIT_DCCUR_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FIXEDTERMRATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FIXEDTERMRATE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field FIXEDTERMUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FIXEDTERMUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FIXEDTERMUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DCCUR, internal->external for field FXSURCHARGERATE CALL FUNCTION 'CONVERSION_EXIT_DCCUR_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXSURCHARGERATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXSURCHARGERATE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field FXSURCHARGEUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXSURCHARGEUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXSURCHARGEUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field FXQUANTITYFROMUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXQUANTITYFROMUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXQUANTITYFROMUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field FXQUANTITYTOUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXQUANTITYTOUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXQUANTITYTOUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DCCUR, internal->external for field FXAMOUNT CALL FUNCTION 'CONVERSION_EXIT_DCCUR_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXAMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field FXPERQUANTITYUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXPERQUANTITYUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXPERQUANTITYUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field FXPERIODDETERMINATIONRULE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXPERIODDETERMINATIONRULE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXPERIODDETERMINATIONRULE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit DCCUR, internal->external for field FXFIXEDTERMRATE CALL FUNCTION 'CONVERSION_EXIT_DCCUR_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXFIXEDTERMRATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXFIXEDTERMRATE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field FXFIXEDTERMUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXFIXEDTERMUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-FXFIXEDTERMUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field CONVERSIONUOMFROM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-CONVERSIONUOMFROM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-CONVERSIONUOMFROM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field CONVERSIONUOMTO CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/DMBE/S_ITEMPLATEPRICINGITE_D-CONVERSIONUOMTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/S_ITEMPLATEPRICINGITE_D-CONVERSIONUOMTO.
WRITE:/ 'New Value:', ld_input.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_/DMBE/S_ITEMPLATEPRICINGITE_D_STR,
PRICINGUUID TYPE STRING,
DEALUUID TYPE STRING,
ITEMINDEX TYPE STRING,
PERCENTAGE TYPE STRING,
EVENT TYPE STRING,
FIXEDPERIOD TYPE STRING,
DEEMEDSTARTDATE TYPE STRING,
DEEMEDENDDATE TYPE STRING,
OFFSETROUTINE TYPE STRING,
OFFSETROUTINEQTT TYPE STRING,
OFFSETROUTINEUOM TYPE STRING,
OFFSETROUTINEQTTBEFORE TYPE STRING,
OFFSETROUTINEQTTAFTER TYPE STRING,
CLOSEDDAYSROUTINE TYPE STRING,
SURCHARGERATE TYPE STRING,
SURCHARGECURRENCY TYPE STRING,
SURCHARGEUOM TYPE STRING,
PROVISIONPRICING TYPE STRING,
PROVISIONPRICINGKEY TYPE STRING,
PROVISIONPRICINGREFERENCE TYPE STRING,
TERMGROUP TYPE STRING,
TERMNO TYPE STRING,
HEELPERCENT TYPE STRING,
BASEDATE TYPE STRING,
QUANTITYFROM TYPE STRING,
QUANTITYTO TYPE STRING,
QUANTITYFROMUOM TYPE STRING,
QUANTITYTOUOM TYPE STRING,
AMOUNT TYPE STRING,
AMOUNTCURRENCY TYPE STRING,
PERQUANTITY TYPE STRING,
PERQUANTITYUOM TYPE STRING,
MATURITYROUTINE TYPE STRING,
PERIODDETERMINATIONRULE TYPE STRING,
MATURITYTYPE TYPE STRING,
MATURITYKEYDATE TYPE STRING,
ITEMMATURITYKEYDATEDESCR TYPE STRING,
BASISID TYPE STRING,
ESTIMATEDBASISID TYPE STRING,
BASISTYPE TYPE STRING,
FIXEDTERMRATE TYPE STRING,
FIXEDTERMCURRENCY TYPE STRING,
FIXEDTERMUOM TYPE STRING,
TERMTYPE TYPE STRING,
PRICINGTERMTYPE TYPE STRING,
FXEVENT TYPE STRING,
FXFIXEDPERIOD TYPE STRING,
FXDEEMEDSTARTDATE TYPE STRING,
FXDEEMEDENDDATE TYPE STRING,
FXOFFSETROUTINE TYPE STRING,
FXOFFSETROUTINEQTT TYPE STRING,
FXOFFSETROUTINEUOM TYPE STRING,
FXOFFSETROUTINEQTTBEFORE TYPE STRING,
FXOFFSETROUTINEQTTAFTER TYPE STRING,
FXCLOSEDDAYSROUTINE TYPE STRING,
FXSURCHARGERATE TYPE STRING,
FXSURCHARGECURRENCY TYPE STRING,
FXSURCHARGEUOM TYPE STRING,
FXPROVISIONPRICING TYPE STRING,
FXPROVISIONPRICINGKEY TYPE STRING,
FXPROVISIONPRICINGREFERENCE TYPE STRING,
FXHEELPERCENT TYPE STRING,
FXBASEDATE TYPE STRING,
FXQUANTITYFROM TYPE STRING,
FXQUANTITYTO TYPE STRING,
FXQUANTITYFROMUOM TYPE STRING,
FXQUANTITYTOUOM TYPE STRING,
FXAMOUNT TYPE STRING,
FXAMOUNTCURRENCY TYPE STRING,
FXPERQUANTITY TYPE STRING,
FXPERQUANTITYUOM TYPE STRING,
FXPERIODDETERMINATIONRULE TYPE STRING,
FXFIXEDTERMRATE TYPE STRING,
FXFIXEDTERMCURRENCY TYPE STRING,
FXFIXEDTERMUOM TYPE STRING,
EXCHANGERATETYPE TYPE STRING,
FXRATEENABLED TYPE STRING,
UOMCONVERSIONENABLED TYPE STRING,
CONVERSIONQUANTITYFROM TYPE STRING,
CONVERSIONUOMFROM TYPE STRING,
CONVERSIONQUANTITYTO TYPE STRING,
CONVERSIONUOMTO TYPE STRING,
CREATEDBY TYPE STRING,
CREATEDAT TYPE STRING,
CHANGEDBY TYPE STRING,
CHANGEDAT TYPE STRING,
ETAG TYPE STRING,
DELETED TYPE STRING,
ACTIVEUUID TYPE STRING,
TEMPLATE TYPE STRING,
EXCHANGERATETYPEDESCRIPTION TYPE STRING,
INTERNALCOMPANY TYPE STRING,
BUYINGCOMPANY TYPE STRING,
SELLINGCOMPANY TYPE STRING,
PRODUCTTYPE TYPE STRING,
DEALTYPE TYPE STRING,
TRANSACTIONTYPE TYPE STRING,
DEALBLOCKED TYPE STRING,
DETAILTRANSACTIONTYPE TYPE STRING,
DCSID TYPE STRING,
DEALDETAILEFPPRICINGCATEGORY TYPE STRING,
PRICINGHEADERCONDITIONTYPE TYPE STRING,
DETAILCALCPRICINGMETHOD TYPE STRING,
PRICINGCATEGORY TYPE STRING,
PRICETYPE TYPE STRING,END OF T_EKKO_STR. DATA: WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR type T_EKKO_STR. DATA: ld_text TYPE string. LOOP AT IT_EKKO INTO WA_EKKO. MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR. CONCATENATE: sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PRICINGUUID sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DEALUUID sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-ITEMINDEX sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PERCENTAGE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-EVENT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FIXEDPERIOD sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DEEMEDSTARTDATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DEEMEDENDDATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-OFFSETROUTINE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-OFFSETROUTINEQTT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-OFFSETROUTINEUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-OFFSETROUTINEQTTBEFORE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-OFFSETROUTINEQTTAFTER sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CLOSEDDAYSROUTINE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-SURCHARGERATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-SURCHARGECURRENCY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-SURCHARGEUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PROVISIONPRICING sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PROVISIONPRICINGKEY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PROVISIONPRICINGREFERENCE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-TERMGROUP sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-TERMNO sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-HEELPERCENT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-BASEDATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-QUANTITYFROM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-QUANTITYTO sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-QUANTITYFROMUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-QUANTITYTOUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-AMOUNT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-AMOUNTCURRENCY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PERQUANTITY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PERQUANTITYUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-MATURITYROUTINE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PERIODDETERMINATIONRULE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-MATURITYTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-MATURITYKEYDATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-ITEMMATURITYKEYDATEDESCR sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-BASISID sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-ESTIMATEDBASISID sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-BASISTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FIXEDTERMRATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FIXEDTERMCURRENCY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FIXEDTERMUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-TERMTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PRICINGTERMTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXEVENT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXFIXEDPERIOD sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXDEEMEDSTARTDATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXDEEMEDENDDATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXOFFSETROUTINE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXOFFSETROUTINEQTT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXOFFSETROUTINEUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXOFFSETROUTINEQTTBEFORE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXOFFSETROUTINEQTTAFTER sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXCLOSEDDAYSROUTINE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXSURCHARGERATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXSURCHARGECURRENCY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXSURCHARGEUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXPROVISIONPRICING sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXPROVISIONPRICINGKEY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXPROVISIONPRICINGREFERENCE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXHEELPERCENT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXBASEDATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXQUANTITYFROM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXQUANTITYTO sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXQUANTITYFROMUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXQUANTITYTOUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXAMOUNT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXAMOUNTCURRENCY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXPERQUANTITY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXPERQUANTITYUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXPERIODDETERMINATIONRULE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXFIXEDTERMRATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXFIXEDTERMCURRENCY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXFIXEDTERMUOM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-EXCHANGERATETYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-FXRATEENABLED sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-UOMCONVERSIONENABLED sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CONVERSIONQUANTITYFROM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CONVERSIONUOMFROM sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CONVERSIONQUANTITYTO sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CONVERSIONUOMTO sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CREATEDBY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CREATEDAT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CHANGEDBY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-CHANGEDAT sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-ETAG sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DELETED sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-ACTIVEUUID sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-TEMPLATE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-EXCHANGERATETYPEDESCRIPTION sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-INTERNALCOMPANY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-BUYINGCOMPANY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-SELLINGCOMPANY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PRODUCTTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DEALTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-TRANSACTIONTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DEALBLOCKED sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DETAILTRANSACTIONTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DCSID sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DEALDETAILEFPPRICINGCATEGORY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PRICINGHEADERCONDITIONTYPE sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-DETAILCALCPRICINGMETHOD sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PRICINGCATEGORY sy-vline
WA_/DMBE/S_ITEMPLATEPRICINGITE_D_STR-PRICETYPE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.