ABAP Select data from SAP table CMP_ITEM_DATA 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 CMP_ITEM_DATA 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 CMP_ITEM_DATA. 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 CMP_ITEM_DATA 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_CMP_ITEM_DATA TYPE STANDARD TABLE OF CMP_ITEM_DATA,
      WA_CMP_ITEM_DATA TYPE CMP_ITEM_DATA,
      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: <CMP_ITEM_DATA> TYPE CMP_ITEM_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CMP_ITEM_DATA
*  INTO TABLE @DATA(IT_CMP_ITEM_DATA2).
*--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_CMP_ITEM_DATA INDEX 1 INTO DATA(WA_CMP_ITEM_DATA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CMP_ITEM_DATA ASSIGNING <CMP_ITEM_DATA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<CMP_ITEM_DATA>-FKART = 1.
<CMP_ITEM_DATA>-AUART = 1.
<CMP_ITEM_DATA>-ITEM_TYPE = 1.
<CMP_ITEM_DATA>-DOCTYP = 1.
<CMP_ITEM_DATA>-CHGFLAG = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CMP_ITEM_DATA-CHKFLAG, sy-vline,
WA_CMP_ITEM_DATA-COMPREASTXT, sy-vline,
WA_CMP_ITEM_DATA-SELFLAG, sy-vline,
WA_CMP_ITEM_DATA-DOCNR, sy-vline,
WA_CMP_ITEM_DATA-LDOCNR, sy-vline,
WA_CMP_ITEM_DATA-KUNNR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CMP_ITEM_DATA 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_CMP_ITEM_DATA 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_CMP_ITEM_DATA INTO WA_CMP_ITEM_DATA. *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 AUART, internal->external for field AUART CALL FUNCTION 'CONVERSION_EXIT_AUART_OUTPUT' EXPORTING input = WA_CMP_ITEM_DATA-AUART IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CMP_ITEM_DATA-AUART.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_CMP_ITEM_DATA-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CMP_ITEM_DATA-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATWA CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_CMP_ITEM_DATA-MATWA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CMP_ITEM_DATA-MATWA.
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_CMP_ITEM_DATA_STR,
FKART TYPE STRING,
AUART TYPE STRING,
ITEM_TYPE TYPE STRING,
DOCTYP TYPE STRING,
CHGFLAG TYPE STRING,
CHKFLAG TYPE STRING,
COMPREASTXT TYPE STRING,
SELFLAG TYPE STRING,
DOCNR TYPE STRING,
LDOCNR TYPE STRING,
KUNNR TYPE STRING,
INTPOS TYPE STRING,
LASTINTPOS TYPE STRING,
UPOS TYPE STRING,
CREDITMNG TYPE STRING,
CREDITMEINS TYPE STRING,
PRINTSTATUS TYPE STRING,
RETURNSTATUS TYPE STRING,
CMP_PRICE1 TYPE STRING,
CMP_KPEIN1 TYPE STRING,
CMP_KMEIN1 TYPE STRING,
CMP_KWAEH1 TYPE STRING,
CMP_KWAEH1_INT TYPE STRING,
CMP_KOEIN1 TYPE STRING,
CMP_PRICE2 TYPE STRING,
CMP_KPEIN2 TYPE STRING,
CMP_KMEIN2 TYPE STRING,
CMP_KWAEH2 TYPE STRING,
CMP_KWAEH2_INT TYPE STRING,
CMP_PRICE3 TYPE STRING,
CMP_KPEIN3 TYPE STRING,
CMP_KMEIN3 TYPE STRING,
CMP_KWAEH3 TYPE STRING,
CMP_KWAEH3_INT TYPE STRING,
CMP_PRICE4 TYPE STRING,
CMP_KPEIN4 TYPE STRING,
CMP_KMEIN4 TYPE STRING,
CMP_KWAEH4 TYPE STRING,
CMP_KWAEH4_INT TYPE STRING,
CMP_PRICE5 TYPE STRING,
CMP_KPEIN5 TYPE STRING,
CMP_KMEIN5 TYPE STRING,
CMP_KWAEH5 TYPE STRING,
CMP_KWAEH5_INT TYPE STRING,
CMP_PRICE6 TYPE STRING,
CMP_KPEIN6 TYPE STRING,
CMP_KMEIN6 TYPE STRING,
CMP_KWAEH6 TYPE STRING,
CMP_KWAEH6_INT TYPE STRING,
CMP_MATNR_NEU TYPE STRING,
CMP_FKIMG_NEW TYPE STRING,
CMP_VRKME_NEW TYPE STRING,
CMP_PRICE_NEW TYPE STRING,
VBELN TYPE STRING,
POSNR TYPE STRING,
UEPOS TYPE STRING,
FKIMG TYPE STRING,
VRKME TYPE STRING,
UMVKZ TYPE STRING,
UMVKN TYPE STRING,
MEINS TYPE STRING,
MATNR TYPE STRING,
ARKTX TYPE STRING,
MATKL TYPE STRING,
PSTYV TYPE STRING,
POSAR TYPE STRING,
PRODH TYPE STRING,
WERKS TYPE STRING,
NTGEW TYPE STRING,
BRGEW TYPE STRING,
GEWEI TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
NETWR TYPE STRING,
VBELV TYPE STRING,
POSNV TYPE STRING,
VGBEL TYPE STRING,
VGPOS TYPE STRING,
VGTYP TYPE STRING,
AUBEL TYPE STRING,
AUPOS TYPE STRING,
AUREF TYPE STRING,
SHKZG TYPE STRING,
LGORT TYPE STRING,
KZWI1 TYPE STRING,
KZWI2 TYPE STRING,
KZWI3 TYPE STRING,
KZWI4 TYPE STRING,
KZWI5 TYPE STRING,
KZWI6 TYPE STRING,
MATWA TYPE STRING,
FKLMG TYPE STRING,
SPART TYPE STRING,
COMPREAS TYPE STRING,
WAERK TYPE STRING,
ETENR TYPE STRING,
ZAEHL TYPE STRING,
MSGID TYPE STRING,
MSGNO TYPE STRING,
MSGTY TYPE STRING,
MSGV1 TYPE STRING,
MSGV2 TYPE STRING,
MSGV3 TYPE STRING,
MSGV4 TYPE STRING,
SMART TYPE STRING,
LOEKZ TYPE STRING,
UPOS_CHG TYPE STRING,
MERK_MENG TYPE STRING,
KDREF TYPE STRING,END OF T_EKKO_STR. DATA: WA_CMP_ITEM_DATA_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_CMP_ITEM_DATA_STR-FKART sy-vline
WA_CMP_ITEM_DATA_STR-AUART sy-vline
WA_CMP_ITEM_DATA_STR-ITEM_TYPE sy-vline
WA_CMP_ITEM_DATA_STR-DOCTYP sy-vline
WA_CMP_ITEM_DATA_STR-CHGFLAG sy-vline
WA_CMP_ITEM_DATA_STR-CHKFLAG sy-vline
WA_CMP_ITEM_DATA_STR-COMPREASTXT sy-vline
WA_CMP_ITEM_DATA_STR-SELFLAG sy-vline
WA_CMP_ITEM_DATA_STR-DOCNR sy-vline
WA_CMP_ITEM_DATA_STR-LDOCNR sy-vline
WA_CMP_ITEM_DATA_STR-KUNNR sy-vline
WA_CMP_ITEM_DATA_STR-INTPOS sy-vline
WA_CMP_ITEM_DATA_STR-LASTINTPOS sy-vline
WA_CMP_ITEM_DATA_STR-UPOS sy-vline
WA_CMP_ITEM_DATA_STR-CREDITMNG sy-vline
WA_CMP_ITEM_DATA_STR-CREDITMEINS sy-vline
WA_CMP_ITEM_DATA_STR-PRINTSTATUS sy-vline
WA_CMP_ITEM_DATA_STR-RETURNSTATUS sy-vline
WA_CMP_ITEM_DATA_STR-CMP_PRICE1 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KPEIN1 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KMEIN1 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH1 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH1_INT sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KOEIN1 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_PRICE2 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KPEIN2 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KMEIN2 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH2 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH2_INT sy-vline
WA_CMP_ITEM_DATA_STR-CMP_PRICE3 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KPEIN3 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KMEIN3 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH3 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH3_INT sy-vline
WA_CMP_ITEM_DATA_STR-CMP_PRICE4 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KPEIN4 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KMEIN4 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH4 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH4_INT sy-vline
WA_CMP_ITEM_DATA_STR-CMP_PRICE5 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KPEIN5 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KMEIN5 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH5 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH5_INT sy-vline
WA_CMP_ITEM_DATA_STR-CMP_PRICE6 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KPEIN6 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KMEIN6 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH6 sy-vline
WA_CMP_ITEM_DATA_STR-CMP_KWAEH6_INT sy-vline
WA_CMP_ITEM_DATA_STR-CMP_MATNR_NEU sy-vline
WA_CMP_ITEM_DATA_STR-CMP_FKIMG_NEW sy-vline
WA_CMP_ITEM_DATA_STR-CMP_VRKME_NEW sy-vline
WA_CMP_ITEM_DATA_STR-CMP_PRICE_NEW sy-vline
WA_CMP_ITEM_DATA_STR-VBELN sy-vline
WA_CMP_ITEM_DATA_STR-POSNR sy-vline
WA_CMP_ITEM_DATA_STR-UEPOS sy-vline
WA_CMP_ITEM_DATA_STR-FKIMG sy-vline
WA_CMP_ITEM_DATA_STR-VRKME sy-vline
WA_CMP_ITEM_DATA_STR-UMVKZ sy-vline
WA_CMP_ITEM_DATA_STR-UMVKN sy-vline
WA_CMP_ITEM_DATA_STR-MEINS sy-vline
WA_CMP_ITEM_DATA_STR-MATNR sy-vline
WA_CMP_ITEM_DATA_STR-ARKTX sy-vline
WA_CMP_ITEM_DATA_STR-MATKL sy-vline
WA_CMP_ITEM_DATA_STR-PSTYV sy-vline
WA_CMP_ITEM_DATA_STR-POSAR sy-vline
WA_CMP_ITEM_DATA_STR-PRODH sy-vline
WA_CMP_ITEM_DATA_STR-WERKS sy-vline
WA_CMP_ITEM_DATA_STR-NTGEW sy-vline
WA_CMP_ITEM_DATA_STR-BRGEW sy-vline
WA_CMP_ITEM_DATA_STR-GEWEI sy-vline
WA_CMP_ITEM_DATA_STR-VOLUM sy-vline
WA_CMP_ITEM_DATA_STR-VOLEH sy-vline
WA_CMP_ITEM_DATA_STR-NETWR sy-vline
WA_CMP_ITEM_DATA_STR-VBELV sy-vline
WA_CMP_ITEM_DATA_STR-POSNV sy-vline
WA_CMP_ITEM_DATA_STR-VGBEL sy-vline
WA_CMP_ITEM_DATA_STR-VGPOS sy-vline
WA_CMP_ITEM_DATA_STR-VGTYP sy-vline
WA_CMP_ITEM_DATA_STR-AUBEL sy-vline
WA_CMP_ITEM_DATA_STR-AUPOS sy-vline
WA_CMP_ITEM_DATA_STR-AUREF sy-vline
WA_CMP_ITEM_DATA_STR-SHKZG sy-vline
WA_CMP_ITEM_DATA_STR-LGORT sy-vline
WA_CMP_ITEM_DATA_STR-KZWI1 sy-vline
WA_CMP_ITEM_DATA_STR-KZWI2 sy-vline
WA_CMP_ITEM_DATA_STR-KZWI3 sy-vline
WA_CMP_ITEM_DATA_STR-KZWI4 sy-vline
WA_CMP_ITEM_DATA_STR-KZWI5 sy-vline
WA_CMP_ITEM_DATA_STR-KZWI6 sy-vline
WA_CMP_ITEM_DATA_STR-MATWA sy-vline
WA_CMP_ITEM_DATA_STR-FKLMG sy-vline
WA_CMP_ITEM_DATA_STR-SPART sy-vline
WA_CMP_ITEM_DATA_STR-COMPREAS sy-vline
WA_CMP_ITEM_DATA_STR-WAERK sy-vline
WA_CMP_ITEM_DATA_STR-ETENR sy-vline
WA_CMP_ITEM_DATA_STR-ZAEHL sy-vline
WA_CMP_ITEM_DATA_STR-MSGID sy-vline
WA_CMP_ITEM_DATA_STR-MSGNO sy-vline
WA_CMP_ITEM_DATA_STR-MSGTY sy-vline
WA_CMP_ITEM_DATA_STR-MSGV1 sy-vline
WA_CMP_ITEM_DATA_STR-MSGV2 sy-vline
WA_CMP_ITEM_DATA_STR-MSGV3 sy-vline
WA_CMP_ITEM_DATA_STR-MSGV4 sy-vline
WA_CMP_ITEM_DATA_STR-SMART sy-vline
WA_CMP_ITEM_DATA_STR-LOEKZ sy-vline
WA_CMP_ITEM_DATA_STR-UPOS_CHG sy-vline
WA_CMP_ITEM_DATA_STR-MERK_MENG sy-vline
WA_CMP_ITEM_DATA_STR-KDREF sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.