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

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP /DMBE/CPRCITMDRD 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/CPRCITMDRD. 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/CPRCITMDRD 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/CPRCITMDRD TYPE STANDARD TABLE OF /DMBE/CPRCITMDRD,
      WA_/DMBE/CPRCITMDRD TYPE /DMBE/CPRCITMDRD,
      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/CPRCITMDRD> TYPE /DMBE/CPRCITMDRD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /DMBE/CPRCITMDRD
*  INTO TABLE @DATA(IT_/DMBE/CPRCITMDRD2).
*--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/CPRCITMDRD INDEX 1 INTO DATA(WA_/DMBE/CPRCITMDRD2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/DMBE/CPRCITMDRD ASSIGNING </DMBE/CPRCITMDRD>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</DMBE/CPRCITMDRD>-MANDT = 1.
</DMBE/CPRCITMDRD>-PRICINGITEMUUID = 1.
</DMBE/CPRCITMDRD>-ACTIVEUUID = 1.
</DMBE/CPRCITMDRD>-PRICINGUUID = 1.
</DMBE/CPRCITMDRD>-DEALUUID = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/DMBE/CPRCITMDRD-ITEMINDEX, sy-vline,
  WA_/DMBE/CPRCITMDRD-ITEMINDEXDESCR, sy-vline,
  WA_/DMBE/CPRCITMDRD-ISDCS, sy-vline,
  WA_/DMBE/CPRCITMDRD-ISBASIS, sy-vline,
  WA_/DMBE/CPRCITMDRD-PERCENTAGE, sy-vline,
  WA_/DMBE/CPRCITMDRD-EVENT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/DMBE/CPRCITMDRD 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/CPRCITMDRD 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/CPRCITMDRD INTO WA_/DMBE/CPRCITMDRD.


*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/CPRCITMDRD-ITEMINDEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/CPRCITMDRD-ITEMINDEX.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field DCSUOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_/DMBE/CPRCITMDRD-DCSUOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/DMBE/CPRCITMDRD-DCSUOM.
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/CPRCITMDRD_STR, 
MANDT TYPE STRING,
PRICINGITEMUUID TYPE STRING,
ACTIVEUUID TYPE STRING,
PRICINGUUID TYPE STRING,
DEALUUID TYPE STRING,
ITEMINDEX TYPE STRING,
ITEMINDEXDESCR TYPE STRING,
ISDCS TYPE STRING,
ISBASIS TYPE STRING,
PERCENTAGE TYPE STRING,
EVENT TYPE STRING,
EVENTDESCR TYPE STRING,
FIXEDPERIOD TYPE STRING,
DEEMEDSTARTDATE TYPE STRING,
DEEMEDENDDATE TYPE STRING,
OFFSETROUTINE TYPE STRING,
OFFSETROUTINEDESCR TYPE STRING,
OFFSETROUTINEQTT TYPE STRING,
OFFSETROUTINEUOM TYPE STRING,
OFFSETROUTINEUOMDESCR TYPE STRING,
OFFSETROUTINEQTTBEFORE TYPE STRING,
OFFSETROUTINEQTTAFTER TYPE STRING,
CLOSEDDAYSROUTINE TYPE STRING,
CLOSEDDAYSROUTINEDESCR TYPE STRING,
SURCHARGERATE TYPE STRING,
SURCHARGECURRENCY TYPE STRING,
SURCHARGECURRENCYDESCR TYPE STRING,
SURCHARGEUOM TYPE STRING,
SURCHARGEUOMDESCR TYPE STRING,
HEELPERCENT TYPE STRING,
BASEDATE TYPE STRING,
PROVISIONPRICING TYPE STRING,
PROVISIONPRICINGKEY TYPE STRING,
PROVISIONPRICINGREFERENCE TYPE STRING,
QUANTITYFROM TYPE STRING,
QUANTITYFROMUOM TYPE STRING,
QUANTITYFROMUOMDESCR TYPE STRING,
QUANTITYTO TYPE STRING,
QUANTITYTOUOM TYPE STRING,
QUANTITYTOUOMDESCR TYPE STRING,
AMOUNT TYPE STRING,
AMOUNTCURRENCY TYPE STRING,
AMOUNTCURRENCYDESCR TYPE STRING,
PERQUANTITY TYPE STRING,
PERQUANTITYUOM TYPE STRING,
PERQUANTITYUOMDESCR TYPE STRING,
TERMGROUP TYPE STRING,
TERMNO TYPE STRING,
MATURITYTYPE TYPE STRING,
MATURITYTYPEDESCR TYPE STRING,
MATURITYKEYDATE TYPE STRING,
MATURITYKEYDATEDESCR TYPE STRING,
ITEMMATURITYKEYDATEDESCR TYPE STRING,
BASISID TYPE STRING,
BASISIDDESCR TYPE STRING,
ESTIMATEDBASISID TYPE STRING,
BASISTYPE TYPE STRING,
BASISTYPEDESCR TYPE STRING,
FIXEDTERMRATE TYPE STRING,
FIXEDTERMCURRENCY TYPE STRING,
FIXEDTERMCURRENCYDESCR TYPE STRING,
FIXEDTERMUOM TYPE STRING,
FIXEDTERMUOMDESCR TYPE STRING,
TERMTYPE TYPE STRING,
PRICINGTERMTYPE TYPE STRING,
MATURITYROUTINE TYPE STRING,
MATURITYROUTINEDESCR TYPE STRING,
PERIODDETERMINATIONRULE TYPE STRING,
PERIODDETERMINATIONRULEDESCR TYPE STRING,
CREATEDBY TYPE STRING,
CREATEDBYDESCR TYPE STRING,
CREATEDAT TYPE STRING,
CHANGEDBY TYPE STRING,
CHANGEDBYDESCR TYPE STRING,
CHANGEDAT TYPE STRING,
DELETED TYPE STRING,
DEALDETAILEFPPRICINGCATEGORY TYPE STRING,
PRICINGHEADERCONDITIONTYPE TYPE STRING,
DETAILCALCPRICINGMETHOD TYPE STRING,
PRICINGCATEGORY TYPE STRING,
PRICETYPE TYPE STRING,
FXEVENT TYPE STRING,
FXEVENTDESCR TYPE STRING,
FXFIXEDPERIOD TYPE STRING,
FXDEEMEDSTARTDATE TYPE STRING,
FXDEEMEDENDDATE TYPE STRING,
FXOFFSETROUTINE TYPE STRING,
FXOFFSETROUTINEDESCR TYPE STRING,
FXOFFSETROUTINEQTT TYPE STRING,
FXOFFSETROUTINEUOM TYPE STRING,
FXOFFSETROUTINEUOMDESCR TYPE STRING,
FXOFFSETROUTINEQTTBEFORE TYPE STRING,
FXOFFSETROUTINEQTTAFTER TYPE STRING,
FXCLOSEDDAYSROUTINE TYPE STRING,
FXCLOSEDDAYSROUTINEDESCR TYPE STRING,
FXSURCHARGERATE TYPE STRING,
FXSURCHARGECURRENCY TYPE STRING,
FXSURCHARGECURRENCYDESCR TYPE STRING,
FXSURCHARGEUOM TYPE STRING,
FXSURCHARGEUOMDESCR 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,
FXQUANTITYFROMUOMDESCR TYPE STRING,
FXQUANTITYTOUOM TYPE STRING,
FXQUANTITYTOUOMDESCR TYPE STRING,
FXAMOUNT TYPE STRING,
FXAMOUNTCURRENCY TYPE STRING,
FXAMOUNTCURRENCYDESCR TYPE STRING,
FXPERQUANTITY TYPE STRING,
FXPERQUANTITYUOM TYPE STRING,
FXPERQUANTITYUOMDESCR TYPE STRING,
FXPERIODDETERMINATIONRULE TYPE STRING,
FXPERIODDETERMINATIONRULEDESCR TYPE STRING,
FXFIXEDTERMRATE TYPE STRING,
FXFIXEDTERMCURRENCY TYPE STRING,
FXFIXEDTERMCURRENCYDESCR TYPE STRING,
FXFIXEDTERMUOM TYPE STRING,
FXFIXEDTERMUOMDESCR TYPE STRING,
EXCHANGERATETYPE TYPE STRING,
EXCHANGERATETYPEDESCRIPTION TYPE STRING,
FXRATEENABLED TYPE STRING,
UOMCONVERSIONENABLED TYPE STRING,
CONVERSIONQUANTITYFROM TYPE STRING,
CONVERSIONUOMFROM TYPE STRING,
CONVERSIONUOMFROMDESCR TYPE STRING,
CONVERSIONQUANTITYTO TYPE STRING,
CONVERSIONUOMTO TYPE STRING,
CONVERSIONUOMTODESCR TYPE STRING,
HEADERTRANSACTIONTYPE TYPE STRING,
DCSUOM TYPE STRING,
DCSQUOTATIONCURRENCY TYPE STRING,
INTERNALCOMPANY TYPE STRING,
BUYINGCOMPANY TYPE STRING,
SELLINGCOMPANY TYPE STRING,
PRODUCTTYPE TYPE STRING,
DEALTYPE TYPE STRING,
TRANSACTIONTYPE TYPE STRING,
DEALBLOCKED TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/DMBE/CPRCITMDRD_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/CPRCITMDRD_STR-MANDT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PRICINGITEMUUID sy-vline 
WA_/DMBE/CPRCITMDRD_STR-ACTIVEUUID sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PRICINGUUID sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DEALUUID sy-vline 
WA_/DMBE/CPRCITMDRD_STR-ITEMINDEX sy-vline 
WA_/DMBE/CPRCITMDRD_STR-ITEMINDEXDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-ISDCS sy-vline 
WA_/DMBE/CPRCITMDRD_STR-ISBASIS sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PERCENTAGE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-EVENT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-EVENTDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FIXEDPERIOD sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DEEMEDSTARTDATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DEEMEDENDDATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-OFFSETROUTINE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-OFFSETROUTINEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-OFFSETROUTINEQTT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-OFFSETROUTINEUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-OFFSETROUTINEUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-OFFSETROUTINEQTTBEFORE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-OFFSETROUTINEQTTAFTER sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CLOSEDDAYSROUTINE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CLOSEDDAYSROUTINEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-SURCHARGERATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-SURCHARGECURRENCY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-SURCHARGECURRENCYDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-SURCHARGEUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-SURCHARGEUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-HEELPERCENT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-BASEDATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PROVISIONPRICING sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PROVISIONPRICINGKEY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PROVISIONPRICINGREFERENCE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-QUANTITYFROM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-QUANTITYFROMUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-QUANTITYFROMUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-QUANTITYTO sy-vline 
WA_/DMBE/CPRCITMDRD_STR-QUANTITYTOUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-QUANTITYTOUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-AMOUNT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-AMOUNTCURRENCY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-AMOUNTCURRENCYDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PERQUANTITY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PERQUANTITYUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PERQUANTITYUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-TERMGROUP sy-vline 
WA_/DMBE/CPRCITMDRD_STR-TERMNO sy-vline 
WA_/DMBE/CPRCITMDRD_STR-MATURITYTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-MATURITYTYPEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-MATURITYKEYDATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-MATURITYKEYDATEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-ITEMMATURITYKEYDATEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-BASISID sy-vline 
WA_/DMBE/CPRCITMDRD_STR-BASISIDDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-ESTIMATEDBASISID sy-vline 
WA_/DMBE/CPRCITMDRD_STR-BASISTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-BASISTYPEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FIXEDTERMRATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FIXEDTERMCURRENCY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FIXEDTERMCURRENCYDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FIXEDTERMUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FIXEDTERMUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-TERMTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PRICINGTERMTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-MATURITYROUTINE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-MATURITYROUTINEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PERIODDETERMINATIONRULE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PERIODDETERMINATIONRULEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CREATEDBY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CREATEDBYDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CREATEDAT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CHANGEDBY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CHANGEDBYDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CHANGEDAT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DELETED sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DEALDETAILEFPPRICINGCATEGORY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PRICINGHEADERCONDITIONTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DETAILCALCPRICINGMETHOD sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PRICINGCATEGORY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PRICETYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXEVENT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXEVENTDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXFIXEDPERIOD sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXDEEMEDSTARTDATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXDEEMEDENDDATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXOFFSETROUTINE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXOFFSETROUTINEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXOFFSETROUTINEQTT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXOFFSETROUTINEUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXOFFSETROUTINEUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXOFFSETROUTINEQTTBEFORE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXOFFSETROUTINEQTTAFTER sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXCLOSEDDAYSROUTINE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXCLOSEDDAYSROUTINEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXSURCHARGERATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXSURCHARGECURRENCY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXSURCHARGECURRENCYDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXSURCHARGEUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXSURCHARGEUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXPROVISIONPRICING sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXPROVISIONPRICINGKEY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXPROVISIONPRICINGREFERENCE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXHEELPERCENT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXBASEDATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXQUANTITYFROM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXQUANTITYTO sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXQUANTITYFROMUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXQUANTITYFROMUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXQUANTITYTOUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXQUANTITYTOUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXAMOUNT sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXAMOUNTCURRENCY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXAMOUNTCURRENCYDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXPERQUANTITY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXPERQUANTITYUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXPERQUANTITYUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXPERIODDETERMINATIONRULE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXPERIODDETERMINATIONRULEDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXFIXEDTERMRATE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXFIXEDTERMCURRENCY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXFIXEDTERMCURRENCYDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXFIXEDTERMUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXFIXEDTERMUOMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-EXCHANGERATETYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-EXCHANGERATETYPEDESCRIPTION sy-vline 
WA_/DMBE/CPRCITMDRD_STR-FXRATEENABLED sy-vline 
WA_/DMBE/CPRCITMDRD_STR-UOMCONVERSIONENABLED sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CONVERSIONQUANTITYFROM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CONVERSIONUOMFROM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CONVERSIONUOMFROMDESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CONVERSIONQUANTITYTO sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CONVERSIONUOMTO sy-vline 
WA_/DMBE/CPRCITMDRD_STR-CONVERSIONUOMTODESCR sy-vline 
WA_/DMBE/CPRCITMDRD_STR-HEADERTRANSACTIONTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DCSUOM sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DCSQUOTATIONCURRENCY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-INTERNALCOMPANY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-BUYINGCOMPANY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-SELLINGCOMPANY sy-vline 
WA_/DMBE/CPRCITMDRD_STR-PRODUCTTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DEALTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-TRANSACTIONTYPE sy-vline 
WA_/DMBE/CPRCITMDRD_STR-DEALBLOCKED sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.