ABAP Select data from SAP table FCOS_COPA_CE0A000_CLOUD 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 FCOS_COPA_CE0A000_CLOUD 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 FCOS_COPA_CE0A000_CLOUD. 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 FCOS_COPA_CE0A000_CLOUD 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_FCOS_COPA_CE0A000_CLOUD TYPE STANDARD TABLE OF FCOS_COPA_CE0A000_CLOUD,
      WA_FCOS_COPA_CE0A000_CLOUD TYPE FCOS_COPA_CE0A000_CLOUD,
      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: <FCOS_COPA_CE0A000_CLOUD> TYPE FCOS_COPA_CE0A000_CLOUD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FCOS_COPA_CE0A000_CLOUD
*  INTO TABLE @DATA(IT_FCOS_COPA_CE0A000_CLOUD2).
*--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_FCOS_COPA_CE0A000_CLOUD INDEX 1 INTO DATA(WA_FCOS_COPA_CE0A000_CLOUD2).


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field KUNWE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FCOS_COPA_CE0A000_CLOUD-KUNWE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FCOS_COPA_CE0A000_CLOUD-KUNWE.
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_FCOS_COPA_CE0A000_CLOUD_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,
FKBER TYPE STRING,
SEGMENT TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
HRKFT TYPE STRING,
PLIKZ TYPE STRING,
KSTAR TYPE STRING,
PSPNR TYPE STRING,
COPA_KOSTL 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,
SERVICE_DOC_TYPE TYPE STRING,
SERVICE_DOC_ID TYPE STRING,
SERVICE_DOC_ITEM_ID TYPE STRING,
WTGBTR TYPE STRING,
WOGBTR TYPE STRING,
WKGBTR TYPE STRING,
WKFBTR TYPE STRING,
MEGBTR TYPE STRING,
MEINH TYPE STRING,
QUANT1 TYPE STRING,
QUANT2 TYPE STRING,
QUANT3 TYPE STRING,
QUNIT1 TYPE STRING,
QUNIT2 TYPE STRING,
QUNIT3 TYPE STRING,
KNT_FRM_KZ TYPE STRING,
VALUTYP TYPE STRING,
LSTAR TYPE STRING,
CURTP TYPE STRING,
LOGSYS_SENDER TYPE STRING,
ERKRS_SENDER TYPE STRING,
BELNR_SENDER TYPE STRING,
POSNR_SENDER TYPE STRING,
VRGAR_SENDER TYPE STRING,
BUKRS_SENDER TYPE STRING,
REPROCESSING_STATUS_CODE TYPE STRING,
KDGRP TYPE STRING,
KUNRE TYPE STRING,
KUNWE TYPE STRING,
LAND1 TYPE STRING,
BRSCH TYPE STRING,
MATKL TYPE STRING,
BZIRK TYPE STRING,
DUMMY_MRKT_SGMNT_EEW_PS TYPE STRING,END OF T_EKKO_STR. DATA: WA_FCOS_COPA_CE0A000_CLOUD_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_FCOS_COPA_CE0A000_CLOUD_STR-MANDT sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PALEDGER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-VRGAR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-VERSI sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PERIO sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PAOBJNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PASUBNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-BELNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-POSNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-HZDAT sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-USNAM sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-GJAHR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PERDE sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-WADAT sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-FADAT sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-BUDAT sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-ALTPERIO sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PAPAOBJNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PAPASUBNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KNDNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-ARTNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-FKART sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-FRWAE sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KURSF sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KURSBK sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KURSKZ sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-REC_WAERS sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KAUFN sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KDPOS sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-RKAUFNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-SKOST sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PRZNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-BUKRS sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KOKRS sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-WERKS sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-GSBER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-FKBER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-SEGMENT sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-VKORG sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-VTWEG sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-SPART sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-HRKFT sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PLIKZ sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KSTAR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PSPNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-COPA_KOSTL sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KSTRG sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-RBELN sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-RPOSN sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-STO_BELNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-STO_POSNR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PRCTR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-PPRCTR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-RKESTATU sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-TIMESTMP sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-COPA_AWTYP sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-COPA_AWORG sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-COPA_BWZPT sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-COPA_AWSYS sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-SERVICE_DOC_TYPE sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-SERVICE_DOC_ID sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-SERVICE_DOC_ITEM_ID sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-WTGBTR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-WOGBTR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-WKGBTR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-WKFBTR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-MEGBTR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-MEINH sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-QUANT1 sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-QUANT2 sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-QUANT3 sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-QUNIT1 sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-QUNIT2 sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-QUNIT3 sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KNT_FRM_KZ sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-VALUTYP sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-LSTAR sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-CURTP sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-LOGSYS_SENDER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-ERKRS_SENDER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-BELNR_SENDER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-POSNR_SENDER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-VRGAR_SENDER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-BUKRS_SENDER sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-REPROCESSING_STATUS_CODE sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KDGRP sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KUNRE sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-KUNWE sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-LAND1 sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-BRSCH sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-MATKL sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-BZIRK sy-vline
WA_FCOS_COPA_CE0A000_CLOUD_STR-DUMMY_MRKT_SGMNT_EEW_PS sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.