ABAP Select data from SAP table CE1CSTC 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 CE1CSTC 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 CE1CSTC. 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 CE1CSTC 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_CE1CSTC TYPE STANDARD TABLE OF CE1CSTC,
      WA_CE1CSTC TYPE CE1CSTC,
      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: <CE1CSTC> TYPE CE1CSTC.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CE1CSTC
*  INTO TABLE @DATA(IT_CE1CSTC2).
*--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_CE1CSTC INDEX 1 INTO DATA(WA_CE1CSTC2).


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

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CE1CSTC-PAOBJNR, sy-vline,
WA_CE1CSTC-PASUBNR, sy-vline,
WA_CE1CSTC-BELNR, sy-vline,
WA_CE1CSTC-POSNR, sy-vline,
WA_CE1CSTC-HZDAT, sy-vline,
WA_CE1CSTC-USNAM, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CE1CSTC 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_CE1CSTC 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_CE1CSTC INTO WA_CE1CSTC. *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_CE1CSTC-PALEDGER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-PALEDGER.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit PERI7, internal->external for field PERIO CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT' EXPORTING input = WA_CE1CSTC-PERIO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-PERIO.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit PERI7, internal->external for field ALTPERIO CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT' EXPORTING input = WA_CE1CSTC-ALTPERIO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-ALTPERIO.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit AC152, internal->external for field ERLOS CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-ERLOS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-ERLOS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWABLK CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWABLK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWABLK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWABPR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWABPR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWABPR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWBONI CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWBONI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWBONI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWBRUM CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWBRUM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWBRUM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWCATR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWCATR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWCATR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWFOEN CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWFOEN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWFOEN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWFRGR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWFRGR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWFRGR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWFULK CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWFULK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWFULK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWGOHD CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWGOHD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWGOHD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWINSR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWINSR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWINSR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWKDRB CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWKDRB IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWKDRB.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWLOGI CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWLOGI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWLOGI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWMKAD CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWMKAD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWMKAD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWMKPR CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWMKPR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWMKPR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWSKTO CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWSKTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWSKTO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWSMKT CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWSMKT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWSMKT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWSOHD CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWSOHD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWSOHD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWVERW CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWVERW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWVERW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWVKPV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWVKPV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWVKPV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KWVTID CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-KWVTID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-KWVTID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field RABAT CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-RABAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-RABAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field ROHST CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-ROHST IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-ROHST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field VTRGK CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_CE1CSTC-VTRGK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CE1CSTC-VTRGK.
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_CE1CSTC_STR,
MANDT TYPE STRING,
PALEDGER TYPE STRING,
VRGAR TYPE STRING,
VERSI TYPE STRING,
PERIO TYPE STRING,
PAOBJNR TYPE STRING,
PASUBNR TYPE STRING,
BELNR TYPE STRING,
POSNR TYPE STRING,
HZDAT TYPE STRING,
USNAM TYPE STRING,
GJAHR TYPE STRING,
PERDE TYPE STRING,
WADAT TYPE STRING,
FADAT TYPE STRING,
BUDAT TYPE STRING,
ALTPERIO TYPE STRING,
PAPAOBJNR TYPE STRING,
PAPASUBNR TYPE STRING,
KNDNR TYPE STRING,
ARTNR TYPE STRING,
FKART TYPE STRING,
FRWAE TYPE STRING,
KURSF TYPE STRING,
KURSBK TYPE STRING,
KURSKZ TYPE STRING,
REC_WAERS TYPE STRING,
KAUFN TYPE STRING,
KDPOS TYPE STRING,
RKAUFNR TYPE STRING,
SKOST TYPE STRING,
PRZNR TYPE STRING,
BUKRS TYPE STRING,
KOKRS TYPE STRING,
WERKS TYPE STRING,
GSBER TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
HRKFT TYPE STRING,
PLIKZ TYPE STRING,
KSTAR TYPE STRING,
PSPNR TYPE STRING,
KSTRG TYPE STRING,
RBELN TYPE STRING,
RPOSN TYPE STRING,
STO_BELNR TYPE STRING,
STO_POSNR TYPE STRING,
PRCTR TYPE STRING,
PPRCTR TYPE STRING,
RKESTATU TYPE STRING,
TIMESTMP TYPE STRING,
COPA_AWTYP TYPE STRING,
COPA_AWORG TYPE STRING,
COPA_BWZPT TYPE STRING,
COPA_AWSYS TYPE STRING,
ABTNR TYPE STRING,
BONUS TYPE STRING,
BZIRK TYPE STRING,
COPA_KOSTL TYPE STRING,
EKORG TYPE STRING,
KDGRP TYPE STRING,
KMVKBU TYPE STRING,
KMVTNR TYPE STRING,
KTGRM TYPE STRING,
KUNWE TYPE STRING,
MATKL TYPE STRING,
PARTNER TYPE STRING,
VKGRP TYPE STRING,
ABSMG_ME TYPE STRING,
KWSVME_ME TYPE STRING,
VV495_ME TYPE STRING,
ABSMG TYPE STRING,
ERLOS TYPE STRING,
KWABLK TYPE STRING,
KWABPR TYPE STRING,
KWBONI TYPE STRING,
KWBRUM TYPE STRING,
KWCATR TYPE STRING,
KWFOEN TYPE STRING,
KWFRGR TYPE STRING,
KWFULK TYPE STRING,
KWGOHD TYPE STRING,
KWINSR TYPE STRING,
KWKDRB TYPE STRING,
KWLOGI TYPE STRING,
KWMKAD TYPE STRING,
KWMKPR TYPE STRING,
KWSKTO TYPE STRING,
KWSMKT TYPE STRING,
KWSOHD TYPE STRING,
KWSVME TYPE STRING,
KWVERW TYPE STRING,
KWVKPV TYPE STRING,
KWVTID TYPE STRING,
RABAT TYPE STRING,
ROHST TYPE STRING,
VTRGK TYPE STRING,
VV010 TYPE STRING,
VV090 TYPE STRING,
VV140 TYPE STRING,
VV270 TYPE STRING,
VV280 TYPE STRING,
VV290 TYPE STRING,
VV330 TYPE STRING,
VV340 TYPE STRING,
VV350 TYPE STRING,
VV366 TYPE STRING,
VV370 TYPE STRING,
VV390 TYPE STRING,
VV400 TYPE STRING,
VV420 TYPE STRING,
VV495 TYPE STRING,END OF T_EKKO_STR. DATA: WA_CE1CSTC_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_CE1CSTC_STR-MANDT sy-vline
WA_CE1CSTC_STR-PALEDGER sy-vline
WA_CE1CSTC_STR-VRGAR sy-vline
WA_CE1CSTC_STR-VERSI sy-vline
WA_CE1CSTC_STR-PERIO sy-vline
WA_CE1CSTC_STR-PAOBJNR sy-vline
WA_CE1CSTC_STR-PASUBNR sy-vline
WA_CE1CSTC_STR-BELNR sy-vline
WA_CE1CSTC_STR-POSNR sy-vline
WA_CE1CSTC_STR-HZDAT sy-vline
WA_CE1CSTC_STR-USNAM sy-vline
WA_CE1CSTC_STR-GJAHR sy-vline
WA_CE1CSTC_STR-PERDE sy-vline
WA_CE1CSTC_STR-WADAT sy-vline
WA_CE1CSTC_STR-FADAT sy-vline
WA_CE1CSTC_STR-BUDAT sy-vline
WA_CE1CSTC_STR-ALTPERIO sy-vline
WA_CE1CSTC_STR-PAPAOBJNR sy-vline
WA_CE1CSTC_STR-PAPASUBNR sy-vline
WA_CE1CSTC_STR-KNDNR sy-vline
WA_CE1CSTC_STR-ARTNR sy-vline
WA_CE1CSTC_STR-FKART sy-vline
WA_CE1CSTC_STR-FRWAE sy-vline
WA_CE1CSTC_STR-KURSF sy-vline
WA_CE1CSTC_STR-KURSBK sy-vline
WA_CE1CSTC_STR-KURSKZ sy-vline
WA_CE1CSTC_STR-REC_WAERS sy-vline
WA_CE1CSTC_STR-KAUFN sy-vline
WA_CE1CSTC_STR-KDPOS sy-vline
WA_CE1CSTC_STR-RKAUFNR sy-vline
WA_CE1CSTC_STR-SKOST sy-vline
WA_CE1CSTC_STR-PRZNR sy-vline
WA_CE1CSTC_STR-BUKRS sy-vline
WA_CE1CSTC_STR-KOKRS sy-vline
WA_CE1CSTC_STR-WERKS sy-vline
WA_CE1CSTC_STR-GSBER sy-vline
WA_CE1CSTC_STR-VKORG sy-vline
WA_CE1CSTC_STR-VTWEG sy-vline
WA_CE1CSTC_STR-SPART sy-vline
WA_CE1CSTC_STR-HRKFT sy-vline
WA_CE1CSTC_STR-PLIKZ sy-vline
WA_CE1CSTC_STR-KSTAR sy-vline
WA_CE1CSTC_STR-PSPNR sy-vline
WA_CE1CSTC_STR-KSTRG sy-vline
WA_CE1CSTC_STR-RBELN sy-vline
WA_CE1CSTC_STR-RPOSN sy-vline
WA_CE1CSTC_STR-STO_BELNR sy-vline
WA_CE1CSTC_STR-STO_POSNR sy-vline
WA_CE1CSTC_STR-PRCTR sy-vline
WA_CE1CSTC_STR-PPRCTR sy-vline
WA_CE1CSTC_STR-RKESTATU sy-vline
WA_CE1CSTC_STR-TIMESTMP sy-vline
WA_CE1CSTC_STR-COPA_AWTYP sy-vline
WA_CE1CSTC_STR-COPA_AWORG sy-vline
WA_CE1CSTC_STR-COPA_BWZPT sy-vline
WA_CE1CSTC_STR-COPA_AWSYS sy-vline
WA_CE1CSTC_STR-ABTNR sy-vline
WA_CE1CSTC_STR-BONUS sy-vline
WA_CE1CSTC_STR-BZIRK sy-vline
WA_CE1CSTC_STR-COPA_KOSTL sy-vline
WA_CE1CSTC_STR-EKORG sy-vline
WA_CE1CSTC_STR-KDGRP sy-vline
WA_CE1CSTC_STR-KMVKBU sy-vline
WA_CE1CSTC_STR-KMVTNR sy-vline
WA_CE1CSTC_STR-KTGRM sy-vline
WA_CE1CSTC_STR-KUNWE sy-vline
WA_CE1CSTC_STR-MATKL sy-vline
WA_CE1CSTC_STR-PARTNER sy-vline
WA_CE1CSTC_STR-VKGRP sy-vline
WA_CE1CSTC_STR-ABSMG_ME sy-vline
WA_CE1CSTC_STR-KWSVME_ME sy-vline
WA_CE1CSTC_STR-VV495_ME sy-vline
WA_CE1CSTC_STR-ABSMG sy-vline
WA_CE1CSTC_STR-ERLOS sy-vline
WA_CE1CSTC_STR-KWABLK sy-vline
WA_CE1CSTC_STR-KWABPR sy-vline
WA_CE1CSTC_STR-KWBONI sy-vline
WA_CE1CSTC_STR-KWBRUM sy-vline
WA_CE1CSTC_STR-KWCATR sy-vline
WA_CE1CSTC_STR-KWFOEN sy-vline
WA_CE1CSTC_STR-KWFRGR sy-vline
WA_CE1CSTC_STR-KWFULK sy-vline
WA_CE1CSTC_STR-KWGOHD sy-vline
WA_CE1CSTC_STR-KWINSR sy-vline
WA_CE1CSTC_STR-KWKDRB sy-vline
WA_CE1CSTC_STR-KWLOGI sy-vline
WA_CE1CSTC_STR-KWMKAD sy-vline
WA_CE1CSTC_STR-KWMKPR sy-vline
WA_CE1CSTC_STR-KWSKTO sy-vline
WA_CE1CSTC_STR-KWSMKT sy-vline
WA_CE1CSTC_STR-KWSOHD sy-vline
WA_CE1CSTC_STR-KWSVME sy-vline
WA_CE1CSTC_STR-KWVERW sy-vline
WA_CE1CSTC_STR-KWVKPV sy-vline
WA_CE1CSTC_STR-KWVTID sy-vline
WA_CE1CSTC_STR-RABAT sy-vline
WA_CE1CSTC_STR-ROHST sy-vline
WA_CE1CSTC_STR-VTRGK sy-vline
WA_CE1CSTC_STR-VV010 sy-vline
WA_CE1CSTC_STR-VV090 sy-vline
WA_CE1CSTC_STR-VV140 sy-vline
WA_CE1CSTC_STR-VV270 sy-vline
WA_CE1CSTC_STR-VV280 sy-vline
WA_CE1CSTC_STR-VV290 sy-vline
WA_CE1CSTC_STR-VV330 sy-vline
WA_CE1CSTC_STR-VV340 sy-vline
WA_CE1CSTC_STR-VV350 sy-vline
WA_CE1CSTC_STR-VV366 sy-vline
WA_CE1CSTC_STR-VV370 sy-vline
WA_CE1CSTC_STR-VV390 sy-vline
WA_CE1CSTC_STR-VV400 sy-vline
WA_CE1CSTC_STR-VV420 sy-vline
WA_CE1CSTC_STR-VV495 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.