ABAP Select data from SAP table CE7S_CP 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 CE7S_CP 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 CE7S_CP. 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 CE7S_CP 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_CE7S_CP TYPE STANDARD TABLE OF CE7S_CP,
      WA_CE7S_CP TYPE CE7S_CP,
      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: <CE7S_CP> TYPE CE7S_CP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CE7S_CP
*  INTO TABLE @DATA(IT_CE7S_CP2).
*--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_CE7S_CP INDEX 1 INTO DATA(WA_CE7S_CP2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CE7S_CP ASSIGNING <CE7S_CP>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<CE7S_CP>-MANDT = 1.
<CE7S_CP>-PALEDGER = 1.
<CE7S_CP>-ERKRS = 1.
<CE7S_CP>-VRGAR = 1.
<CE7S_CP>-PLIKZ = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CE7S_CP-VERSI, sy-vline,
WA_CE7S_CP-GJAHR, sy-vline,
WA_CE7S_CP-FIELDNAME, sy-vline,
WA_CE7S_CP-KNDNR, sy-vline,
WA_CE7S_CP-ARTNR, sy-vline,
WA_CE7S_CP-FKART, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CE7S_CP 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_CE7S_CP 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_CE7S_CP INTO WA_CE7S_CP. *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 LEDBO, internal->external for field PALEDGER CALL FUNCTION 'CONVERSION_EXIT_LEDBO_OUTPUT' EXPORTING input = WA_CE7S_CP-PALEDGER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-PALEDGER.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field GJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_CE7S_CP-GJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-GJAHR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit EXCRT, internal->external for field KURSF CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_CE7S_CP-KURSF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-KURSF.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ABPSP, internal->external for field PSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_CE7S_CP-PSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-PSPNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSN, internal->external for field COPA_POSID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_CE7S_CP-COPA_POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-COPA_POSID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSN, internal->external for field COPA_CRMID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_CE7S_CP-COPA_CRMID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-COPA_CRMID.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit BEKNZ, internal->external for field BEKNZ CALL FUNCTION 'CONVERSION_EXIT_BEKNZ_OUTPUT' EXPORTING input = WA_CE7S_CP-BEKNZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-BEKNZ.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit SCOPE, internal->external for field SCOPE CALL FUNCTION 'CONVERSION_EXIT_SCOPE_OUTPUT' EXPORTING input = WA_CE7S_CP-SCOPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-SCOPE.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field KMHI03 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CE7S_CP-KMHI03 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE7S_CP-KMHI03.
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_CE7S_CP_STR,
MANDT TYPE STRING,
PALEDGER TYPE STRING,
ERKRS TYPE STRING,
VRGAR TYPE STRING,
PLIKZ TYPE STRING,
VERSI TYPE STRING,
GJAHR TYPE STRING,
FIELDNAME TYPE STRING,
KNDNR TYPE STRING,
ARTNR TYPE STRING,
FKART TYPE STRING,
WAERS TYPE STRING,
PERIV TYPE STRING,
PERFLAG2 TYPE STRING,
FRWAE TYPE STRING,
KURSF TYPE STRING,
KURST TYPE STRING,
ABLEDA TYPE STRING,
KAUFN TYPE STRING,
KDPOS TYPE STRING,
RKAUFNR TYPE STRING,
BUKRS TYPE STRING,
S_BUKRS TYPE STRING,
KOKRS TYPE STRING,
WERKS TYPE STRING,
GSBER TYPE STRING,
S_GSBER TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
KSTRG TYPE STRING,
PSPNR TYPE STRING,
COPA_POSID TYPE STRING,
COPA_CRMID TYPE STRING,
PA_TYPE TYPE STRING,
LEDNR TYPE STRING,
OBJNR TYPE STRING,
WRTTP TYPE STRING,
VERSN TYPE STRING,
KSTAR TYPE STRING,
VRGNG TYPE STRING,
PAROB TYPE STRING,
USPOB TYPE STRING,
BEKNZ TYPE STRING,
TWAER TYPE STRING,
BUPER TYPE STRING,
KOSTL TYPE STRING,
LSTAR TYPE STRING,
PRZNR TYPE STRING,
OWAER TYPE STRING,
KWAER TYPE STRING,
MEINH TYPE STRING,
KTOPL TYPE STRING,
LMONA TYPE STRING,
INUMKR TYPE STRING,
SETKIND TYPE STRING,
BUDAT TYPE STRING,
VNAME TYPE STRING,
RECID TYPE STRING,
ETYPE TYPE STRING,
PRCTR TYPE STRING,
S_PRCTR TYPE STRING,
PPRCTR TYPE STRING,
AUTYP TYPE STRING,
SCOPE TYPE STRING,
LOGSYSTEM TYPE STRING,
TARKZ TYPE STRING,
VKSTA TYPE STRING,
YRATE TYPE STRING,
FIXVO TYPE STRING,
TARKZ_I TYPE STRING,
MANIST TYPE STRING,
AUSFK TYPE STRING,
AUSEH TYPE STRING,
LEINH TYPE STRING,
ERZUO TYPE STRING,
KMBRND TYPE STRING,
KMCATG TYPE STRING,
KMHI01 TYPE STRING,
KMHI02 TYPE STRING,
KMHI03 TYPE STRING,
KMKDGR TYPE STRING,
KMLAND TYPE STRING,
KMMAKL TYPE STRING,
KMNIEL TYPE STRING,
KMSTGE TYPE STRING,
KMVKBU TYPE STRING,
KMVKGR TYPE STRING,
KMVTNR TYPE STRING,END OF T_EKKO_STR. DATA: WA_CE7S_CP_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_CE7S_CP_STR-MANDT sy-vline
WA_CE7S_CP_STR-PALEDGER sy-vline
WA_CE7S_CP_STR-ERKRS sy-vline
WA_CE7S_CP_STR-VRGAR sy-vline
WA_CE7S_CP_STR-PLIKZ sy-vline
WA_CE7S_CP_STR-VERSI sy-vline
WA_CE7S_CP_STR-GJAHR sy-vline
WA_CE7S_CP_STR-FIELDNAME sy-vline
WA_CE7S_CP_STR-KNDNR sy-vline
WA_CE7S_CP_STR-ARTNR sy-vline
WA_CE7S_CP_STR-FKART sy-vline
WA_CE7S_CP_STR-WAERS sy-vline
WA_CE7S_CP_STR-PERIV sy-vline
WA_CE7S_CP_STR-PERFLAG2 sy-vline
WA_CE7S_CP_STR-FRWAE sy-vline
WA_CE7S_CP_STR-KURSF sy-vline
WA_CE7S_CP_STR-KURST sy-vline
WA_CE7S_CP_STR-ABLEDA sy-vline
WA_CE7S_CP_STR-KAUFN sy-vline
WA_CE7S_CP_STR-KDPOS sy-vline
WA_CE7S_CP_STR-RKAUFNR sy-vline
WA_CE7S_CP_STR-BUKRS sy-vline
WA_CE7S_CP_STR-S_BUKRS sy-vline
WA_CE7S_CP_STR-KOKRS sy-vline
WA_CE7S_CP_STR-WERKS sy-vline
WA_CE7S_CP_STR-GSBER sy-vline
WA_CE7S_CP_STR-S_GSBER sy-vline
WA_CE7S_CP_STR-VKORG sy-vline
WA_CE7S_CP_STR-VTWEG sy-vline
WA_CE7S_CP_STR-SPART sy-vline
WA_CE7S_CP_STR-KSTRG sy-vline
WA_CE7S_CP_STR-PSPNR sy-vline
WA_CE7S_CP_STR-COPA_POSID sy-vline
WA_CE7S_CP_STR-COPA_CRMID sy-vline
WA_CE7S_CP_STR-PA_TYPE sy-vline
WA_CE7S_CP_STR-LEDNR sy-vline
WA_CE7S_CP_STR-OBJNR sy-vline
WA_CE7S_CP_STR-WRTTP sy-vline
WA_CE7S_CP_STR-VERSN sy-vline
WA_CE7S_CP_STR-KSTAR sy-vline
WA_CE7S_CP_STR-VRGNG sy-vline
WA_CE7S_CP_STR-PAROB sy-vline
WA_CE7S_CP_STR-USPOB sy-vline
WA_CE7S_CP_STR-BEKNZ sy-vline
WA_CE7S_CP_STR-TWAER sy-vline
WA_CE7S_CP_STR-BUPER sy-vline
WA_CE7S_CP_STR-KOSTL sy-vline
WA_CE7S_CP_STR-LSTAR sy-vline
WA_CE7S_CP_STR-PRZNR sy-vline
WA_CE7S_CP_STR-OWAER sy-vline
WA_CE7S_CP_STR-KWAER sy-vline
WA_CE7S_CP_STR-MEINH sy-vline
WA_CE7S_CP_STR-KTOPL sy-vline
WA_CE7S_CP_STR-LMONA sy-vline
WA_CE7S_CP_STR-INUMKR sy-vline
WA_CE7S_CP_STR-SETKIND sy-vline
WA_CE7S_CP_STR-BUDAT sy-vline
WA_CE7S_CP_STR-VNAME sy-vline
WA_CE7S_CP_STR-RECID sy-vline
WA_CE7S_CP_STR-ETYPE sy-vline
WA_CE7S_CP_STR-PRCTR sy-vline
WA_CE7S_CP_STR-S_PRCTR sy-vline
WA_CE7S_CP_STR-PPRCTR sy-vline
WA_CE7S_CP_STR-AUTYP sy-vline
WA_CE7S_CP_STR-SCOPE sy-vline
WA_CE7S_CP_STR-LOGSYSTEM sy-vline
WA_CE7S_CP_STR-TARKZ sy-vline
WA_CE7S_CP_STR-VKSTA sy-vline
WA_CE7S_CP_STR-YRATE sy-vline
WA_CE7S_CP_STR-FIXVO sy-vline
WA_CE7S_CP_STR-TARKZ_I sy-vline
WA_CE7S_CP_STR-MANIST sy-vline
WA_CE7S_CP_STR-AUSFK sy-vline
WA_CE7S_CP_STR-AUSEH sy-vline
WA_CE7S_CP_STR-LEINH sy-vline
WA_CE7S_CP_STR-ERZUO sy-vline
WA_CE7S_CP_STR-KMBRND sy-vline
WA_CE7S_CP_STR-KMCATG sy-vline
WA_CE7S_CP_STR-KMHI01 sy-vline
WA_CE7S_CP_STR-KMHI02 sy-vline
WA_CE7S_CP_STR-KMHI03 sy-vline
WA_CE7S_CP_STR-KMKDGR sy-vline
WA_CE7S_CP_STR-KMLAND sy-vline
WA_CE7S_CP_STR-KMMAKL sy-vline
WA_CE7S_CP_STR-KMNIEL sy-vline
WA_CE7S_CP_STR-KMSTGE sy-vline
WA_CE7S_CP_STR-KMVKBU sy-vline
WA_CE7S_CP_STR-KMVKGR sy-vline
WA_CE7S_CP_STR-KMVTNR sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.