ABAP Select data from SAP table CRMT_ACS_I_PRE 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 CRMT_ACS_I_PRE 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 CRMT_ACS_I_PRE. 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 CRMT_ACS_I_PRE 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_CRMT_ACS_I_PRE TYPE STANDARD TABLE OF CRMT_ACS_I_PRE,
      WA_CRMT_ACS_I_PRE TYPE CRMT_ACS_I_PRE,
      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: <CRMT_ACS_I_PRE> TYPE CRMT_ACS_I_PRE.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM CRMT_ACS_I_PRE
  INTO TABLE IT_CRMT_ACS_I_PRE.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CRMT_ACS_I_PRE
*  INTO TABLE @DATA(IT_CRMT_ACS_I_PRE2).
*--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_CRMT_ACS_I_PRE INDEX 1 INTO DATA(WA_CRMT_ACS_I_PRE2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CRMT_ACS_I_PRE ASSIGNING <CRMT_ACS_I_PRE>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CRMT_ACS_I_PRE>-AC_INDICATOR = 1.
<CRMT_ACS_I_PRE>-AUFFK0010 = 1.
<CRMT_ACS_I_PRE>-BASIC_TIER = 1.
<CRMT_ACS_I_PRE>-BILL_ORG = 1.
<CRMT_ACS_I_PRE>-BILL_TO_PARTY = 1.

ENDLOOP.

LOOP AT IT_CRMT_ACS_I_PRE INTO WA_CRMT_ACS_I_PRE.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CRMT_ACS_I_PRE-CAMPAIGN_GUID, sy-vline,
  WA_CRMT_ACS_I_PRE-CMP_GUID, sy-vline,
  WA_CRMT_ACS_I_PRE-COUNTRY, sy-vline,
  WA_CRMT_ACS_I_PRE-CPE_CONDTYPE_PR, sy-vline,
  WA_CRMT_ACS_I_PRE-CPE_F_COMBROUT, sy-vline,
  WA_CRMT_ACS_I_PRE-CPE_F_FORCOMMUOM, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CRMT_ACS_I_PRE 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_CRMT_ACS_I_PRE 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_CRMT_ACS_I_PRE INTO WA_CRMT_ACS_I_PRE.


*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 BILL_ORG
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CRMT_ACS_I_PRE-BILL_ORG
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRMT_ACS_I_PRE-BILL_ORG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CGPLP, internal->external for field CAMPAIGN_GUID
CALL FUNCTION 'CONVERSION_EXIT_CGPLP_OUTPUT'
  EXPORTING
    input =                      WA_CRMT_ACS_I_PRE-CAMPAIGN_GUID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRMT_ACS_I_PRE-CAMPAIGN_GUID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CGPLP, internal->external for field CMP_GUID
CALL FUNCTION 'CONVERSION_EXIT_CGPLP_OUTPUT'
  EXPORTING
    input =                      WA_CRMT_ACS_I_PRE-CMP_GUID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRMT_ACS_I_PRE-CMP_GUID.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field TTE_PARTNER_ID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CRMT_ACS_I_PRE-TTE_PARTNER_ID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRMT_ACS_I_PRE-TTE_PARTNER_ID.
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_CRMT_ACS_I_PRE_STR, 
AC_INDICATOR TYPE STRING,
AUFFK0010 TYPE STRING,
BASIC_TIER TYPE STRING,
BILL_ORG TYPE STRING,
BILL_TO_PARTY TYPE STRING,
CAMPAIGN_GUID TYPE STRING,
CMP_GUID TYPE STRING,
COUNTRY TYPE STRING,
CPE_CONDTYPE_PR TYPE STRING,
CPE_F_COMBROUT TYPE STRING,
CPE_F_FORCOMMUOM TYPE STRING,
CPE_F_FORMEVALR TYPE STRING,
CPE_F_FORMID TYPE STRING,
CPE_F_FORMQUANCN TYPE STRING,
CPE_F_QUANSPLITR TYPE STRING,
CPE_F_R3ACCURACY TYPE STRING,
CPE_T_CALCRULE TYPE STRING,
CPE_T_FACTOR1 TYPE STRING,
CPE_T_FACTOR2 TYPE STRING,
CPE_T_PERDETRU_C TYPE STRING,
CPE_T_PERDETRU_Q TYPE STRING,
CPE_T_PROVIS TYPE STRING,
CPE_T_PROVTERMNO TYPE STRING,
CPE_T_QUOTGROUP TYPE STRING,
CPE_T_QUOTNAME TYPE STRING,
CPE_T_QUOTSRC TYPE STRING,
CPE_T_QUOTTYPE TYPE STRING,
CPE_T_REFCOND TYPE STRING,
CPE_T_REFDOC TYPE STRING,
CPE_T_REFDOCCAT TYPE STRING,
CPE_T_REFITEM TYPE STRING,
CPE_T_SURCHARGER TYPE STRING,
CPE_T_TERMGROUP TYPE STRING,
CPE_T_TERMID TYPE STRING,
CPE_T_TERMNO TYPE STRING,
CPE_T_TERMRULE TYPE STRING,
CPE_T_TERMTYPE TYPE STRING,
CPE_T_USERUOM1 TYPE STRING,
CPE_T_USERVAL1 TYPE STRING,
CURRENCY TYPE STRING,
CUSTOMER_TYPE TYPE STRING,
CUST_GROUP TYPE STRING,
CUST_GROUP1 TYPE STRING,
CUST_GROUP2 TYPE STRING,
CUST_GROUP3 TYPE STRING,
CUST_GROUP4 TYPE STRING,
CUST_GROUP5 TYPE STRING,
DET_DEFAULT_TIMESTAMP TYPE STRING,
DISTRICT TYPE STRING,
DIS_CHANNEL TYPE STRING,
DIVISION TYPE STRING,
ETAX_DEPART_CTY TYPE STRING,
ETAX_DEPART_REG TYPE STRING,
ETAX_DEST_CTY TYPE STRING,
ETAX_DEST_REG TYPE STRING,
ETAX_SOURCE TYPE STRING,
HIER_BP_GUID_01 TYPE STRING,
HIER_BP_GUID_02 TYPE STRING,
HIER_BP_GUID_03 TYPE STRING,
HIER_BP_GUID_04 TYPE STRING,
HIER_BP_GUID_05 TYPE STRING,
HIER_BP_GUID_06 TYPE STRING,
HIER_BP_GUID_07 TYPE STRING,
HIER_BP_GUID_08 TYPE STRING,
HIER_BP_GUID_09 TYPE STRING,
HIER_BP_GUID_10 TYPE STRING,
HIER_BP_GUID_11 TYPE STRING,
HIER_BP_GUID_12 TYPE STRING,
HIER_BP_GUID_13 TYPE STRING,
HIER_BP_GUID_14 TYPE STRING,
HIER_BP_GUID_15 TYPE STRING,
HIER_NODE_00 TYPE STRING,
HIER_NODE_01 TYPE STRING,
HIER_NODE_02 TYPE STRING,
HIER_NODE_03 TYPE STRING,
HIER_NODE_04 TYPE STRING,
HIER_NODE_05 TYPE STRING,
HIER_NODE_06 TYPE STRING,
HIER_NODE_07 TYPE STRING,
HIER_NODE_08 TYPE STRING,
HIER_NODE_09 TYPE STRING,
HIER_NODE_10 TYPE STRING,
HIER_NODE_11 TYPE STRING,
HIER_NODE_12 TYPE STRING,
HIER_NODE_13 TYPE STRING,
HIER_NODE_14 TYPE STRING,
HIER_NODE_15 TYPE STRING,
HIER_NODE_GUID TYPE STRING,
HIER_NO_GUID TYPE STRING,
INCOTERMS1 TYPE STRING,
INCOTERMS2 TYPE STRING,
INDUSTRY TYPE STRING,
INVENT_LOC TYPE STRING,
LIFETIME_TIER TYPE STRING,
LOC_DYNKEY1 TYPE STRING,
LOC_DYNKEY2 TYPE STRING,
LOC_DYNKEY3 TYPE STRING,
LOC_PR TYPE STRING,
LOC_SE TYPE STRING,
LOC_SR TYPE STRING,
LOC_TAXCAT TYPE STRING,
LOC_TAXGROUP TYPE STRING,
LOC_TAX_CITYCODE TYPE STRING,
LOC_TAX_REGION TYPE STRING,
LOC_TXRELCLAS TYPE STRING,
LOC_ZEROVAT TYPE STRING,
LOY_POINT_TYPE TYPE STRING,
MDF_ACCMDN_INT TYPE STRING,
MDF_ACCMDN_INT_BO TYPE STRING,
MDF_ACCMDN_INT_CP TYPE STRING,
MDF_BRKFST_INT TYPE STRING,
MDF_BRKFST_INT_BO TYPE STRING,
MDF_BRKFST_INT_CP TYPE STRING,
MDF_EXP_TYPE TYPE STRING,
MDF_INI_GUID TYPE STRING,
MDF_INI_TYPE TYPE STRING,
MDF_PARTNER_PRG TYPE STRING,
MDF_PARTNER_TYPE TYPE STRING,
MDF_PGM_GUID TYPE STRING,
MDF_PGM_TYPE TYPE STRING,
MDF_SPG_GUID TYPE STRING,
MDF_SPG_TYPE TYPE STRING,
NATPERS TYPE STRING,
OTFPTYPE_01 TYPE STRING,
OTFPTYPE_02 TYPE STRING,
PARTNER_FUNCTION TYPE STRING,
PARTNER_GUID TYPE STRING,
PAYER TYPE STRING,
PAYER_IC_GUID TYPE STRING,
PMNTTRMS TYPE STRING,
POINTS_SPENT TYPE STRING,
PRICE_DATE TYPE STRING,
PRICE_GRP TYPE STRING,
PRICE_LIST TYPE STRING,
PROD_SEG_GUID TYPE STRING,
PROSPECT TYPE STRING,
REF_CURRENCY TYPE STRING,
REGION TYPE STRING,
REVERSAL TYPE STRING,
SALES_GROUP TYPE STRING,
SALES_OFFICE TYPE STRING,
SALES_ORG TYPE STRING,
SALES_ORG_ORDER TYPE STRING,
SALES_ORG_RESP TYPE STRING,
SERVICE_ORG TYPE STRING,
SERVICE_ORG_RESP TYPE STRING,
SHIP_COND TYPE STRING,
SHIP_TO_PARTY TYPE STRING,
SOLD_FROM_PARTY TYPE STRING,
SOLD_TO_PARTY TYPE STRING,
SRV_ESCAL TYPE STRING,
SRV_SERWI TYPE STRING,
TAXJURCODE TYPE STRING,
TAXJURCODE_FROM TYPE STRING,
TAX_BUS_PRO_TYPE TYPE STRING,
TAX_DATE TYPE STRING,
TAX_DEPART_CTY TYPE STRING,
TAX_DEPART_REG TYPE STRING,
TAX_DEP_CTY_ISO TYPE STRING,
TAX_DEP_GR_BP_01 TYPE STRING,
TAX_DEP_GR_BP_02 TYPE STRING,
TAX_DEP_GR_BP_03 TYPE STRING,
TAX_DEP_GR_BP_04 TYPE STRING,
TAX_DEP_GR_BP_05 TYPE STRING,
TAX_DEP_GR_BP_06 TYPE STRING,
TAX_DEP_GR_BP_07 TYPE STRING,
TAX_DEP_GR_BP_08 TYPE STRING,
TAX_DEP_GR_BP_09 TYPE STRING,
TAX_DEP_TY_BP_01 TYPE STRING,
TAX_DEP_TY_BP_02 TYPE STRING,
TAX_DEP_TY_BP_03 TYPE STRING,
TAX_DEP_TY_BP_04 TYPE STRING,
TAX_DEP_TY_BP_05 TYPE STRING,
TAX_DEP_TY_BP_06 TYPE STRING,
TAX_DEP_TY_BP_07 TYPE STRING,
TAX_DEP_TY_BP_08 TYPE STRING,
TAX_DEP_TY_BP_09 TYPE STRING,
TAX_DEST_CTY TYPE STRING,
TAX_DEST_CTY_ISO TYPE STRING,
TAX_DEST_REG TYPE STRING,
TAX_GROUP_BP_01 TYPE STRING,
TAX_GROUP_BP_02 TYPE STRING,
TAX_GROUP_BP_03 TYPE STRING,
TAX_GROUP_BP_04 TYPE STRING,
TAX_GROUP_BP_05 TYPE STRING,
TAX_GROUP_BP_06 TYPE STRING,
TAX_GROUP_BP_07 TYPE STRING,
TAX_GROUP_BP_08 TYPE STRING,
TAX_GROUP_BP_09 TYPE STRING,
TAX_LAW TYPE STRING,
TAX_TYPE_BP_01 TYPE STRING,
TAX_TYPE_BP_02 TYPE STRING,
TAX_TYPE_BP_03 TYPE STRING,
TAX_TYPE_BP_04 TYPE STRING,
TAX_TYPE_BP_05 TYPE STRING,
TAX_TYPE_BP_06 TYPE STRING,
TAX_TYPE_BP_07 TYPE STRING,
TAX_TYPE_BP_08 TYPE STRING,
TAX_TYPE_BP_09 TYPE STRING,
TAX_X_DISBAS_NET TYPE STRING,
TAX_X_EU_CTY_FRO TYPE STRING,
TAX_X_EU_CTY_TO TYPE STRING,
TAX_X_TAXBAS_NET TYPE STRING,
TG_BP_GUID TYPE STRING,
TRANS_MOT TYPE STRING,
TTE_LOGSYS TYPE STRING,
TTE_PARTNER_ID TYPE STRING,
USTAX_ACCNT_NO TYPE STRING,
USTAX_COMPANY_CODE TYPE STRING,
USTAX_PRODUCT_CODE TYPE STRING,
VAT_REG_NO TYPE STRING,
VAT_REG_NO_FROM TYPE STRING,
VAT_REG_NO_FROTO TYPE STRING,
VENDOR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CRMT_ACS_I_PRE_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_CRMT_ACS_I_PRE_STR-AC_INDICATOR sy-vline 
WA_CRMT_ACS_I_PRE_STR-AUFFK0010 sy-vline 
WA_CRMT_ACS_I_PRE_STR-BASIC_TIER sy-vline 
WA_CRMT_ACS_I_PRE_STR-BILL_ORG sy-vline 
WA_CRMT_ACS_I_PRE_STR-BILL_TO_PARTY sy-vline 
WA_CRMT_ACS_I_PRE_STR-CAMPAIGN_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-CMP_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-COUNTRY sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_CONDTYPE_PR sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_F_COMBROUT sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_F_FORCOMMUOM sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_F_FORMEVALR sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_F_FORMID sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_F_FORMQUANCN sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_F_QUANSPLITR sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_F_R3ACCURACY sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_CALCRULE sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_FACTOR1 sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_FACTOR2 sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_PERDETRU_C sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_PERDETRU_Q sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_PROVIS sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_PROVTERMNO sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_QUOTGROUP sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_QUOTNAME sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_QUOTSRC sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_QUOTTYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_REFCOND sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_REFDOC sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_REFDOCCAT sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_REFITEM sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_SURCHARGER sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_TERMGROUP sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_TERMID sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_TERMNO sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_TERMRULE sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_TERMTYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_USERUOM1 sy-vline 
WA_CRMT_ACS_I_PRE_STR-CPE_T_USERVAL1 sy-vline 
WA_CRMT_ACS_I_PRE_STR-CURRENCY sy-vline 
WA_CRMT_ACS_I_PRE_STR-CUSTOMER_TYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-CUST_GROUP sy-vline 
WA_CRMT_ACS_I_PRE_STR-CUST_GROUP1 sy-vline 
WA_CRMT_ACS_I_PRE_STR-CUST_GROUP2 sy-vline 
WA_CRMT_ACS_I_PRE_STR-CUST_GROUP3 sy-vline 
WA_CRMT_ACS_I_PRE_STR-CUST_GROUP4 sy-vline 
WA_CRMT_ACS_I_PRE_STR-CUST_GROUP5 sy-vline 
WA_CRMT_ACS_I_PRE_STR-DET_DEFAULT_TIMESTAMP sy-vline 
WA_CRMT_ACS_I_PRE_STR-DISTRICT sy-vline 
WA_CRMT_ACS_I_PRE_STR-DIS_CHANNEL sy-vline 
WA_CRMT_ACS_I_PRE_STR-DIVISION sy-vline 
WA_CRMT_ACS_I_PRE_STR-ETAX_DEPART_CTY sy-vline 
WA_CRMT_ACS_I_PRE_STR-ETAX_DEPART_REG sy-vline 
WA_CRMT_ACS_I_PRE_STR-ETAX_DEST_CTY sy-vline 
WA_CRMT_ACS_I_PRE_STR-ETAX_DEST_REG sy-vline 
WA_CRMT_ACS_I_PRE_STR-ETAX_SOURCE sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_01 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_02 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_03 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_04 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_05 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_06 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_07 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_08 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_09 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_10 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_11 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_12 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_13 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_14 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_BP_GUID_15 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_00 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_01 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_02 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_03 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_04 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_05 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_06 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_07 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_08 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_09 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_10 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_11 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_12 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_13 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_14 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_15 sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NODE_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-HIER_NO_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-INCOTERMS1 sy-vline 
WA_CRMT_ACS_I_PRE_STR-INCOTERMS2 sy-vline 
WA_CRMT_ACS_I_PRE_STR-INDUSTRY sy-vline 
WA_CRMT_ACS_I_PRE_STR-INVENT_LOC sy-vline 
WA_CRMT_ACS_I_PRE_STR-LIFETIME_TIER sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_DYNKEY1 sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_DYNKEY2 sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_DYNKEY3 sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_PR sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_SE sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_SR sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_TAXCAT sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_TAXGROUP sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_TAX_CITYCODE sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_TAX_REGION sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_TXRELCLAS sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOC_ZEROVAT sy-vline 
WA_CRMT_ACS_I_PRE_STR-LOY_POINT_TYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_ACCMDN_INT sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_ACCMDN_INT_BO sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_ACCMDN_INT_CP sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_BRKFST_INT sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_BRKFST_INT_BO sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_BRKFST_INT_CP sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_EXP_TYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_INI_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_INI_TYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_PARTNER_PRG sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_PARTNER_TYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_PGM_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_PGM_TYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_SPG_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-MDF_SPG_TYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-NATPERS sy-vline 
WA_CRMT_ACS_I_PRE_STR-OTFPTYPE_01 sy-vline 
WA_CRMT_ACS_I_PRE_STR-OTFPTYPE_02 sy-vline 
WA_CRMT_ACS_I_PRE_STR-PARTNER_FUNCTION sy-vline 
WA_CRMT_ACS_I_PRE_STR-PARTNER_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-PAYER sy-vline 
WA_CRMT_ACS_I_PRE_STR-PAYER_IC_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-PMNTTRMS sy-vline 
WA_CRMT_ACS_I_PRE_STR-POINTS_SPENT sy-vline 
WA_CRMT_ACS_I_PRE_STR-PRICE_DATE sy-vline 
WA_CRMT_ACS_I_PRE_STR-PRICE_GRP sy-vline 
WA_CRMT_ACS_I_PRE_STR-PRICE_LIST sy-vline 
WA_CRMT_ACS_I_PRE_STR-PROD_SEG_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-PROSPECT sy-vline 
WA_CRMT_ACS_I_PRE_STR-REF_CURRENCY sy-vline 
WA_CRMT_ACS_I_PRE_STR-REGION sy-vline 
WA_CRMT_ACS_I_PRE_STR-REVERSAL sy-vline 
WA_CRMT_ACS_I_PRE_STR-SALES_GROUP sy-vline 
WA_CRMT_ACS_I_PRE_STR-SALES_OFFICE sy-vline 
WA_CRMT_ACS_I_PRE_STR-SALES_ORG sy-vline 
WA_CRMT_ACS_I_PRE_STR-SALES_ORG_ORDER sy-vline 
WA_CRMT_ACS_I_PRE_STR-SALES_ORG_RESP sy-vline 
WA_CRMT_ACS_I_PRE_STR-SERVICE_ORG sy-vline 
WA_CRMT_ACS_I_PRE_STR-SERVICE_ORG_RESP sy-vline 
WA_CRMT_ACS_I_PRE_STR-SHIP_COND sy-vline 
WA_CRMT_ACS_I_PRE_STR-SHIP_TO_PARTY sy-vline 
WA_CRMT_ACS_I_PRE_STR-SOLD_FROM_PARTY sy-vline 
WA_CRMT_ACS_I_PRE_STR-SOLD_TO_PARTY sy-vline 
WA_CRMT_ACS_I_PRE_STR-SRV_ESCAL sy-vline 
WA_CRMT_ACS_I_PRE_STR-SRV_SERWI sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAXJURCODE sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAXJURCODE_FROM sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_BUS_PRO_TYPE sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DATE sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEPART_CTY sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEPART_REG sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_CTY_ISO sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_01 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_02 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_03 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_04 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_05 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_06 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_07 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_08 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_GR_BP_09 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_01 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_02 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_03 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_04 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_05 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_06 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_07 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_08 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEP_TY_BP_09 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEST_CTY sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEST_CTY_ISO sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_DEST_REG sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_01 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_02 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_03 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_04 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_05 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_06 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_07 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_08 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_GROUP_BP_09 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_LAW sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_01 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_02 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_03 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_04 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_05 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_06 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_07 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_08 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_TYPE_BP_09 sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_X_DISBAS_NET sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_X_EU_CTY_FRO sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_X_EU_CTY_TO sy-vline 
WA_CRMT_ACS_I_PRE_STR-TAX_X_TAXBAS_NET sy-vline 
WA_CRMT_ACS_I_PRE_STR-TG_BP_GUID sy-vline 
WA_CRMT_ACS_I_PRE_STR-TRANS_MOT sy-vline 
WA_CRMT_ACS_I_PRE_STR-TTE_LOGSYS sy-vline 
WA_CRMT_ACS_I_PRE_STR-TTE_PARTNER_ID sy-vline 
WA_CRMT_ACS_I_PRE_STR-USTAX_ACCNT_NO sy-vline 
WA_CRMT_ACS_I_PRE_STR-USTAX_COMPANY_CODE sy-vline 
WA_CRMT_ACS_I_PRE_STR-USTAX_PRODUCT_CODE sy-vline 
WA_CRMT_ACS_I_PRE_STR-VAT_REG_NO sy-vline 
WA_CRMT_ACS_I_PRE_STR-VAT_REG_NO_FROM sy-vline 
WA_CRMT_ACS_I_PRE_STR-VAT_REG_NO_FROTO sy-vline 
WA_CRMT_ACS_I_PRE_STR-VENDOR sy-vline      INTO ld_text SEPARATED BY SPACE.

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