ABAP Select data from SAP table OI0_XMCLIKP 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 OI0_XMCLIKP 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 OI0_XMCLIKP. 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 OI0_XMCLIKP 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_OI0_XMCLIKP TYPE STANDARD TABLE OF OI0_XMCLIKP,
      WA_OI0_XMCLIKP TYPE OI0_XMCLIKP,
      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: <OI0_XMCLIKP> TYPE OI0_XMCLIKP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM OI0_XMCLIKP
*  INTO TABLE @DATA(IT_OI0_XMCLIKP2).
*--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_OI0_XMCLIKP INDEX 1 INTO DATA(WA_OI0_XMCLIKP2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_OI0_XMCLIKP ASSIGNING <OI0_XMCLIKP>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<OI0_XMCLIKP>-SUPKZ = 1.
<OI0_XMCLIKP>-MANDT = 1.
<OI0_XMCLIKP>-VBELN = 1.
<OI0_XMCLIKP>-ERNAM = 1.
<OI0_XMCLIKP>-ERZET = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_OI0_XMCLIKP-ERDAT, sy-vline,
WA_OI0_XMCLIKP-BZIRK, sy-vline,
WA_OI0_XMCLIKP-VSTEL, sy-vline,
WA_OI0_XMCLIKP-VKORG, sy-vline,
WA_OI0_XMCLIKP-LFART, sy-vline,
WA_OI0_XMCLIKP-AUTLF, sy-vline.
ENDLOOP. *Add any further fields from structure WA_OI0_XMCLIKP 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_OI0_XMCLIKP 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_OI0_XMCLIKP INTO WA_OI0_XMCLIKP. *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 VBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OI0_XMCLIKP-VBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OI0_XMCLIKP-VBELN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit TMPLA, internal->external for field TSEGTP CALL FUNCTION 'CONVERSION_EXIT_TMPLA_OUTPUT' EXPORTING input = WA_OI0_XMCLIKP-TSEGTP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OI0_XMCLIKP-TSEGTP.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field MCBIW CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OI0_XMCLIKP-MCBIW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OI0_XMCLIKP-MCBIW.
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_OI0_XMCLIKP_STR,
SUPKZ TYPE STRING,
MANDT TYPE STRING,
VBELN TYPE STRING,
ERNAM TYPE STRING,
ERZET TYPE STRING,
ERDAT TYPE STRING,
BZIRK TYPE STRING,
VSTEL TYPE STRING,
VKORG TYPE STRING,
LFART TYPE STRING,
AUTLF TYPE STRING,
KZAZU TYPE STRING,
WADAT TYPE STRING,
LDDAT TYPE STRING,
TDDAT TYPE STRING,
LFDAT TYPE STRING,
KODAT TYPE STRING,
ABLAD TYPE STRING,
INCO1 TYPE STRING,
INCO2 TYPE STRING,
EXPKZ TYPE STRING,
ROUTE TYPE STRING,
FAKSK TYPE STRING,
LIFSK TYPE STRING,
VBTYP TYPE STRING,
KNFAK TYPE STRING,
TPQUA TYPE STRING,
TPGRP TYPE STRING,
LPRIO TYPE STRING,
VSBED TYPE STRING,
KUNNR TYPE STRING,
KUNAG TYPE STRING,
KDGRP TYPE STRING,
STZKL TYPE STRING,
STZZU TYPE STRING,
BTGEW TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
ANZPK TYPE STRING,
BEROT TYPE STRING,
LFUHR TYPE STRING,
GRULG TYPE STRING,
LSTEL TYPE STRING,
TRAGR TYPE STRING,
FKARV TYPE STRING,
FKDAT TYPE STRING,
PERFK TYPE STRING,
ROUTA TYPE STRING,
STAFO TYPE STRING,
KALSM TYPE STRING,
KNUMV TYPE STRING,
WAERK TYPE STRING,
VKBUR TYPE STRING,
VBEAK TYPE STRING,
ZUKRL TYPE STRING,
VERUR TYPE STRING,
COMMN TYPE STRING,
STWAE TYPE STRING,
STCUR TYPE STRING,
EXNUM TYPE STRING,
AENAM TYPE STRING,
AEDAT TYPE STRING,
LGNUM TYPE STRING,
LISPL TYPE STRING,
VKOIV TYPE STRING,
VTWIV TYPE STRING,
SPAIV TYPE STRING,
FKAIV TYPE STRING,
PIOIV TYPE STRING,
FKDIV TYPE STRING,
KUNIV TYPE STRING,
KKBER TYPE STRING,
KNKLI TYPE STRING,
GRUPP TYPE STRING,
SBGRP TYPE STRING,
CTLPC TYPE STRING,
CMWAE TYPE STRING,
AMTBL TYPE STRING,
BOLNR TYPE STRING,
LIFNR TYPE STRING,
TRATY TYPE STRING,
TRAID TYPE STRING,
CMFRE TYPE STRING,
CMNGV TYPE STRING,
XABLN TYPE STRING,
BLDAT TYPE STRING,
WADAT_IST TYPE STRING,
TRSPG TYPE STRING,
TPSID TYPE STRING,
LIFEX TYPE STRING,
TERNR TYPE STRING,
KALSM_CH TYPE STRING,
KLIEF TYPE STRING,
KALSP TYPE STRING,
KNUMP TYPE STRING,
NETWR TYPE STRING,
AULWE TYPE STRING,
WERKS TYPE STRING,
LCNUM TYPE STRING,
ABSSC TYPE STRING,
KOUHR TYPE STRING,
TDUHR TYPE STRING,
LDUHR TYPE STRING,
WAUHR TYPE STRING,
LGTOR TYPE STRING,
LGBZO TYPE STRING,
AKWAE TYPE STRING,
AKKUR TYPE STRING,
AKPRZ TYPE STRING,
PROLI TYPE STRING,
XBLNR TYPE STRING,
HANDLE TYPE STRING,
TSEGFL TYPE STRING,
TSEGTP TYPE STRING,
TZONIS TYPE STRING,
TZONRC TYPE STRING,
CONT_DG TYPE STRING,
VERURSYS TYPE STRING,
KZWAB TYPE STRING,
VLSTK TYPE STRING,
TCODE TYPE STRING,
VSART TYPE STRING,
TRMTYP TYPE STRING,
SDABW TYPE STRING,
VBUND TYPE STRING,
XWOFF TYPE STRING,
DIRTA TYPE STRING,
PRVBE TYPE STRING,
FOLAR TYPE STRING,
PODAT TYPE STRING,
POTIM TYPE STRING,
VGANZ TYPE STRING,
IMWRK TYPE STRING,
SPE_LOEKZ TYPE STRING,
SPE_LOC_SEQ TYPE STRING,
SPE_ACC_APP_STS TYPE STRING,
SPE_SHP_INF_STS TYPE STRING,
SPE_RET_CANC TYPE STRING,
SPE_WAUHR_IST TYPE STRING,
SPE_WAZONE_IST TYPE STRING,
SPE_REV_VLSTK TYPE STRING,
SPE_LE_SCENARIO TYPE STRING,
SPE_ORIG_SYS TYPE STRING,
SPE_CHNG_SYS TYPE STRING,
SPE_GEOROUTE TYPE STRING,
SPE_GEOROUTEIND TYPE STRING,
SPE_CARRIER_IND TYPE STRING,
SPE_GTS_REL TYPE STRING,
SPE_GTS_RT_CDE TYPE STRING,
SPE_REL_TMSTMP TYPE STRING,
SPE_UNIT_SYSTEM TYPE STRING,
SPE_INV_BFR_GI TYPE STRING,
SPE_QI_STATUS TYPE STRING,
SPE_RED_IND TYPE STRING,
SAKES TYPE STRING,
SPE_LIFEX_TYPE TYPE STRING,
SPE_TTYPE TYPE STRING,
SPE_PRO_NUMBER TYPE STRING,
LOC_GUID TYPE STRING,
SPE_BILLING_IND TYPE STRING,
PRINTER_PROFILE TYPE STRING,
MSR_ACTIVE TYPE STRING,
PRTNR TYPE STRING,
STGE_LOC_CHANGE TYPE STRING,
/BEV1/LULEINH TYPE STRING,
/BEV1/RPFAESS TYPE STRING,
/BEV1/RPKIST TYPE STRING,
/BEV1/RPCONT TYPE STRING,
/BEV1/RPSONST TYPE STRING,
/BEV1/RPFLGNR TYPE STRING,
BORGR_GRP TYPE STRING,
OID_EXTBOL TYPE STRING,
OID_MISCDL TYPE STRING,
OIC_TIME TYPE STRING,
OIWATIM TYPE STRING,
OILDTIM TYPE STRING,
OIPIPEVAL TYPE STRING,
OIC_LIFNR TYPE STRING,
OIC_DCITYC TYPE STRING,
OIC_DCOUNC TYPE STRING,
OIC_DREGIO TYPE STRING,
OIC_DLAND1 TYPE STRING,
OIC_OCITYC TYPE STRING,
OIC_OCOUNC TYPE STRING,
OIC_OREGIO TYPE STRING,
OIC_OLAND1 TYPE STRING,
OIC_PORGIN TYPE STRING,
OIC_PDESTN TYPE STRING,
OIC_PTRIP TYPE STRING,
OIC_PBATCH TYPE STRING,
OIC_MOT TYPE STRING,
OIC_AORGIN TYPE STRING,
OIC_ADESTN TYPE STRING,
OIC_TRUCKN TYPE STRING,
OIA_BASELO TYPE STRING,
OICFKARTDI TYPE STRING,
OICSDP_DVERNO TYPE STRING,
OIO_HOLD TYPE STRING,
OIO_HOLD_ORIG TYPE STRING,
HWAER TYPE STRING,
BUKRS TYPE STRING,
LLAND TYPE STRING,
PERIV_CM TYPE STRING,
PKUNAG TYPE STRING,
PKUNWE TYPE STRING,
PKUNRE TYPE STRING,
PKUNRG TYPE STRING,
PSPDNR TYPE STRING,
PVRTNR TYPE STRING,
PLAAG TYPE STRING,
PLAWE TYPE STRING,
PLARE TYPE STRING,
PLARG TYPE STRING,
PLASP TYPE STRING,
PLAVE TYPE STRING,
PABLA TYPE STRING,
PZONE TYPE STRING,
PDUMMY TYPE STRING,
OIPBLP TYPE STRING,
HIEZU01 TYPE STRING,
HIEZU02 TYPE STRING,
HIEZU03 TYPE STRING,
HIEZU04 TYPE STRING,
HIEZU05 TYPE STRING,
HIEZU06 TYPE STRING,
HIEZU07 TYPE STRING,
HIEZU08 TYPE STRING,
HIEZU09 TYPE STRING,
HIEZU10 TYPE STRING,
DUMMY TYPE STRING,
MCBONUS TYPE STRING,
MCFINANZ TYPE STRING,
MCPROJEKT TYPE STRING,
MCKREDIT TYPE STRING,
MCCAS TYPE STRING,
MCKOUPD TYPE STRING,
MCLIPLAN TYPE STRING,
MCWERTKON TYPE STRING,
MCBIW TYPE STRING,END OF T_EKKO_STR. DATA: WA_OI0_XMCLIKP_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_OI0_XMCLIKP_STR-SUPKZ sy-vline
WA_OI0_XMCLIKP_STR-MANDT sy-vline
WA_OI0_XMCLIKP_STR-VBELN sy-vline
WA_OI0_XMCLIKP_STR-ERNAM sy-vline
WA_OI0_XMCLIKP_STR-ERZET sy-vline
WA_OI0_XMCLIKP_STR-ERDAT sy-vline
WA_OI0_XMCLIKP_STR-BZIRK sy-vline
WA_OI0_XMCLIKP_STR-VSTEL sy-vline
WA_OI0_XMCLIKP_STR-VKORG sy-vline
WA_OI0_XMCLIKP_STR-LFART sy-vline
WA_OI0_XMCLIKP_STR-AUTLF sy-vline
WA_OI0_XMCLIKP_STR-KZAZU sy-vline
WA_OI0_XMCLIKP_STR-WADAT sy-vline
WA_OI0_XMCLIKP_STR-LDDAT sy-vline
WA_OI0_XMCLIKP_STR-TDDAT sy-vline
WA_OI0_XMCLIKP_STR-LFDAT sy-vline
WA_OI0_XMCLIKP_STR-KODAT sy-vline
WA_OI0_XMCLIKP_STR-ABLAD sy-vline
WA_OI0_XMCLIKP_STR-INCO1 sy-vline
WA_OI0_XMCLIKP_STR-INCO2 sy-vline
WA_OI0_XMCLIKP_STR-EXPKZ sy-vline
WA_OI0_XMCLIKP_STR-ROUTE sy-vline
WA_OI0_XMCLIKP_STR-FAKSK sy-vline
WA_OI0_XMCLIKP_STR-LIFSK sy-vline
WA_OI0_XMCLIKP_STR-VBTYP sy-vline
WA_OI0_XMCLIKP_STR-KNFAK sy-vline
WA_OI0_XMCLIKP_STR-TPQUA sy-vline
WA_OI0_XMCLIKP_STR-TPGRP sy-vline
WA_OI0_XMCLIKP_STR-LPRIO sy-vline
WA_OI0_XMCLIKP_STR-VSBED sy-vline
WA_OI0_XMCLIKP_STR-KUNNR sy-vline
WA_OI0_XMCLIKP_STR-KUNAG sy-vline
WA_OI0_XMCLIKP_STR-KDGRP sy-vline
WA_OI0_XMCLIKP_STR-STZKL sy-vline
WA_OI0_XMCLIKP_STR-STZZU sy-vline
WA_OI0_XMCLIKP_STR-BTGEW sy-vline
WA_OI0_XMCLIKP_STR-NTGEW sy-vline
WA_OI0_XMCLIKP_STR-GEWEI sy-vline
WA_OI0_XMCLIKP_STR-VOLUM sy-vline
WA_OI0_XMCLIKP_STR-VOLEH sy-vline
WA_OI0_XMCLIKP_STR-ANZPK sy-vline
WA_OI0_XMCLIKP_STR-BEROT sy-vline
WA_OI0_XMCLIKP_STR-LFUHR sy-vline
WA_OI0_XMCLIKP_STR-GRULG sy-vline
WA_OI0_XMCLIKP_STR-LSTEL sy-vline
WA_OI0_XMCLIKP_STR-TRAGR sy-vline
WA_OI0_XMCLIKP_STR-FKARV sy-vline
WA_OI0_XMCLIKP_STR-FKDAT sy-vline
WA_OI0_XMCLIKP_STR-PERFK sy-vline
WA_OI0_XMCLIKP_STR-ROUTA sy-vline
WA_OI0_XMCLIKP_STR-STAFO sy-vline
WA_OI0_XMCLIKP_STR-KALSM sy-vline
WA_OI0_XMCLIKP_STR-KNUMV sy-vline
WA_OI0_XMCLIKP_STR-WAERK sy-vline
WA_OI0_XMCLIKP_STR-VKBUR sy-vline
WA_OI0_XMCLIKP_STR-VBEAK sy-vline
WA_OI0_XMCLIKP_STR-ZUKRL sy-vline
WA_OI0_XMCLIKP_STR-VERUR sy-vline
WA_OI0_XMCLIKP_STR-COMMN sy-vline
WA_OI0_XMCLIKP_STR-STWAE sy-vline
WA_OI0_XMCLIKP_STR-STCUR sy-vline
WA_OI0_XMCLIKP_STR-EXNUM sy-vline
WA_OI0_XMCLIKP_STR-AENAM sy-vline
WA_OI0_XMCLIKP_STR-AEDAT sy-vline
WA_OI0_XMCLIKP_STR-LGNUM sy-vline
WA_OI0_XMCLIKP_STR-LISPL sy-vline
WA_OI0_XMCLIKP_STR-VKOIV sy-vline
WA_OI0_XMCLIKP_STR-VTWIV sy-vline
WA_OI0_XMCLIKP_STR-SPAIV sy-vline
WA_OI0_XMCLIKP_STR-FKAIV sy-vline
WA_OI0_XMCLIKP_STR-PIOIV sy-vline
WA_OI0_XMCLIKP_STR-FKDIV sy-vline
WA_OI0_XMCLIKP_STR-KUNIV sy-vline
WA_OI0_XMCLIKP_STR-KKBER sy-vline
WA_OI0_XMCLIKP_STR-KNKLI sy-vline
WA_OI0_XMCLIKP_STR-GRUPP sy-vline
WA_OI0_XMCLIKP_STR-SBGRP sy-vline
WA_OI0_XMCLIKP_STR-CTLPC sy-vline
WA_OI0_XMCLIKP_STR-CMWAE sy-vline
WA_OI0_XMCLIKP_STR-AMTBL sy-vline
WA_OI0_XMCLIKP_STR-BOLNR sy-vline
WA_OI0_XMCLIKP_STR-LIFNR sy-vline
WA_OI0_XMCLIKP_STR-TRATY sy-vline
WA_OI0_XMCLIKP_STR-TRAID sy-vline
WA_OI0_XMCLIKP_STR-CMFRE sy-vline
WA_OI0_XMCLIKP_STR-CMNGV sy-vline
WA_OI0_XMCLIKP_STR-XABLN sy-vline
WA_OI0_XMCLIKP_STR-BLDAT sy-vline
WA_OI0_XMCLIKP_STR-WADAT_IST sy-vline
WA_OI0_XMCLIKP_STR-TRSPG sy-vline
WA_OI0_XMCLIKP_STR-TPSID sy-vline
WA_OI0_XMCLIKP_STR-LIFEX sy-vline
WA_OI0_XMCLIKP_STR-TERNR sy-vline
WA_OI0_XMCLIKP_STR-KALSM_CH sy-vline
WA_OI0_XMCLIKP_STR-KLIEF sy-vline
WA_OI0_XMCLIKP_STR-KALSP sy-vline
WA_OI0_XMCLIKP_STR-KNUMP sy-vline
WA_OI0_XMCLIKP_STR-NETWR sy-vline
WA_OI0_XMCLIKP_STR-AULWE sy-vline
WA_OI0_XMCLIKP_STR-WERKS sy-vline
WA_OI0_XMCLIKP_STR-LCNUM sy-vline
WA_OI0_XMCLIKP_STR-ABSSC sy-vline
WA_OI0_XMCLIKP_STR-KOUHR sy-vline
WA_OI0_XMCLIKP_STR-TDUHR sy-vline
WA_OI0_XMCLIKP_STR-LDUHR sy-vline
WA_OI0_XMCLIKP_STR-WAUHR sy-vline
WA_OI0_XMCLIKP_STR-LGTOR sy-vline
WA_OI0_XMCLIKP_STR-LGBZO sy-vline
WA_OI0_XMCLIKP_STR-AKWAE sy-vline
WA_OI0_XMCLIKP_STR-AKKUR sy-vline
WA_OI0_XMCLIKP_STR-AKPRZ sy-vline
WA_OI0_XMCLIKP_STR-PROLI sy-vline
WA_OI0_XMCLIKP_STR-XBLNR sy-vline
WA_OI0_XMCLIKP_STR-HANDLE sy-vline
WA_OI0_XMCLIKP_STR-TSEGFL sy-vline
WA_OI0_XMCLIKP_STR-TSEGTP sy-vline
WA_OI0_XMCLIKP_STR-TZONIS sy-vline
WA_OI0_XMCLIKP_STR-TZONRC sy-vline
WA_OI0_XMCLIKP_STR-CONT_DG sy-vline
WA_OI0_XMCLIKP_STR-VERURSYS sy-vline
WA_OI0_XMCLIKP_STR-KZWAB sy-vline
WA_OI0_XMCLIKP_STR-VLSTK sy-vline
WA_OI0_XMCLIKP_STR-TCODE sy-vline
WA_OI0_XMCLIKP_STR-VSART sy-vline
WA_OI0_XMCLIKP_STR-TRMTYP sy-vline
WA_OI0_XMCLIKP_STR-SDABW sy-vline
WA_OI0_XMCLIKP_STR-VBUND sy-vline
WA_OI0_XMCLIKP_STR-XWOFF sy-vline
WA_OI0_XMCLIKP_STR-DIRTA sy-vline
WA_OI0_XMCLIKP_STR-PRVBE sy-vline
WA_OI0_XMCLIKP_STR-FOLAR sy-vline
WA_OI0_XMCLIKP_STR-PODAT sy-vline
WA_OI0_XMCLIKP_STR-POTIM sy-vline
WA_OI0_XMCLIKP_STR-VGANZ sy-vline
WA_OI0_XMCLIKP_STR-IMWRK sy-vline
WA_OI0_XMCLIKP_STR-SPE_LOEKZ sy-vline
WA_OI0_XMCLIKP_STR-SPE_LOC_SEQ sy-vline
WA_OI0_XMCLIKP_STR-SPE_ACC_APP_STS sy-vline
WA_OI0_XMCLIKP_STR-SPE_SHP_INF_STS sy-vline
WA_OI0_XMCLIKP_STR-SPE_RET_CANC sy-vline
WA_OI0_XMCLIKP_STR-SPE_WAUHR_IST sy-vline
WA_OI0_XMCLIKP_STR-SPE_WAZONE_IST sy-vline
WA_OI0_XMCLIKP_STR-SPE_REV_VLSTK sy-vline
WA_OI0_XMCLIKP_STR-SPE_LE_SCENARIO sy-vline
WA_OI0_XMCLIKP_STR-SPE_ORIG_SYS sy-vline
WA_OI0_XMCLIKP_STR-SPE_CHNG_SYS sy-vline
WA_OI0_XMCLIKP_STR-SPE_GEOROUTE sy-vline
WA_OI0_XMCLIKP_STR-SPE_GEOROUTEIND sy-vline
WA_OI0_XMCLIKP_STR-SPE_CARRIER_IND sy-vline
WA_OI0_XMCLIKP_STR-SPE_GTS_REL sy-vline
WA_OI0_XMCLIKP_STR-SPE_GTS_RT_CDE sy-vline
WA_OI0_XMCLIKP_STR-SPE_REL_TMSTMP sy-vline
WA_OI0_XMCLIKP_STR-SPE_UNIT_SYSTEM sy-vline
WA_OI0_XMCLIKP_STR-SPE_INV_BFR_GI sy-vline
WA_OI0_XMCLIKP_STR-SPE_QI_STATUS sy-vline
WA_OI0_XMCLIKP_STR-SPE_RED_IND sy-vline
WA_OI0_XMCLIKP_STR-SAKES sy-vline
WA_OI0_XMCLIKP_STR-SPE_LIFEX_TYPE sy-vline
WA_OI0_XMCLIKP_STR-SPE_TTYPE sy-vline
WA_OI0_XMCLIKP_STR-SPE_PRO_NUMBER sy-vline
WA_OI0_XMCLIKP_STR-LOC_GUID sy-vline
WA_OI0_XMCLIKP_STR-SPE_BILLING_IND sy-vline
WA_OI0_XMCLIKP_STR-PRINTER_PROFILE sy-vline
WA_OI0_XMCLIKP_STR-MSR_ACTIVE sy-vline
WA_OI0_XMCLIKP_STR-PRTNR sy-vline
WA_OI0_XMCLIKP_STR-STGE_LOC_CHANGE sy-vline
WA_OI0_XMCLIKP_STR-/BEV1/LULEINH sy-vline
WA_OI0_XMCLIKP_STR-/BEV1/RPFAESS sy-vline
WA_OI0_XMCLIKP_STR-/BEV1/RPKIST sy-vline
WA_OI0_XMCLIKP_STR-/BEV1/RPCONT sy-vline
WA_OI0_XMCLIKP_STR-/BEV1/RPSONST sy-vline
WA_OI0_XMCLIKP_STR-/BEV1/RPFLGNR sy-vline
WA_OI0_XMCLIKP_STR-BORGR_GRP sy-vline
WA_OI0_XMCLIKP_STR-OID_EXTBOL sy-vline
WA_OI0_XMCLIKP_STR-OID_MISCDL sy-vline
WA_OI0_XMCLIKP_STR-OIC_TIME sy-vline
WA_OI0_XMCLIKP_STR-OIWATIM sy-vline
WA_OI0_XMCLIKP_STR-OILDTIM sy-vline
WA_OI0_XMCLIKP_STR-OIPIPEVAL sy-vline
WA_OI0_XMCLIKP_STR-OIC_LIFNR sy-vline
WA_OI0_XMCLIKP_STR-OIC_DCITYC sy-vline
WA_OI0_XMCLIKP_STR-OIC_DCOUNC sy-vline
WA_OI0_XMCLIKP_STR-OIC_DREGIO sy-vline
WA_OI0_XMCLIKP_STR-OIC_DLAND1 sy-vline
WA_OI0_XMCLIKP_STR-OIC_OCITYC sy-vline
WA_OI0_XMCLIKP_STR-OIC_OCOUNC sy-vline
WA_OI0_XMCLIKP_STR-OIC_OREGIO sy-vline
WA_OI0_XMCLIKP_STR-OIC_OLAND1 sy-vline
WA_OI0_XMCLIKP_STR-OIC_PORGIN sy-vline
WA_OI0_XMCLIKP_STR-OIC_PDESTN sy-vline
WA_OI0_XMCLIKP_STR-OIC_PTRIP sy-vline
WA_OI0_XMCLIKP_STR-OIC_PBATCH sy-vline
WA_OI0_XMCLIKP_STR-OIC_MOT sy-vline
WA_OI0_XMCLIKP_STR-OIC_AORGIN sy-vline
WA_OI0_XMCLIKP_STR-OIC_ADESTN sy-vline
WA_OI0_XMCLIKP_STR-OIC_TRUCKN sy-vline
WA_OI0_XMCLIKP_STR-OIA_BASELO sy-vline
WA_OI0_XMCLIKP_STR-OICFKARTDI sy-vline
WA_OI0_XMCLIKP_STR-OICSDP_DVERNO sy-vline
WA_OI0_XMCLIKP_STR-OIO_HOLD sy-vline
WA_OI0_XMCLIKP_STR-OIO_HOLD_ORIG sy-vline
WA_OI0_XMCLIKP_STR-HWAER sy-vline
WA_OI0_XMCLIKP_STR-BUKRS sy-vline
WA_OI0_XMCLIKP_STR-LLAND sy-vline
WA_OI0_XMCLIKP_STR-PERIV_CM sy-vline
WA_OI0_XMCLIKP_STR-PKUNAG sy-vline
WA_OI0_XMCLIKP_STR-PKUNWE sy-vline
WA_OI0_XMCLIKP_STR-PKUNRE sy-vline
WA_OI0_XMCLIKP_STR-PKUNRG sy-vline
WA_OI0_XMCLIKP_STR-PSPDNR sy-vline
WA_OI0_XMCLIKP_STR-PVRTNR sy-vline
WA_OI0_XMCLIKP_STR-PLAAG sy-vline
WA_OI0_XMCLIKP_STR-PLAWE sy-vline
WA_OI0_XMCLIKP_STR-PLARE sy-vline
WA_OI0_XMCLIKP_STR-PLARG sy-vline
WA_OI0_XMCLIKP_STR-PLASP sy-vline
WA_OI0_XMCLIKP_STR-PLAVE sy-vline
WA_OI0_XMCLIKP_STR-PABLA sy-vline
WA_OI0_XMCLIKP_STR-PZONE sy-vline
WA_OI0_XMCLIKP_STR-PDUMMY sy-vline
WA_OI0_XMCLIKP_STR-OIPBLP sy-vline
WA_OI0_XMCLIKP_STR-HIEZU01 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU02 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU03 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU04 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU05 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU06 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU07 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU08 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU09 sy-vline
WA_OI0_XMCLIKP_STR-HIEZU10 sy-vline
WA_OI0_XMCLIKP_STR-DUMMY sy-vline
WA_OI0_XMCLIKP_STR-MCBONUS sy-vline
WA_OI0_XMCLIKP_STR-MCFINANZ sy-vline
WA_OI0_XMCLIKP_STR-MCPROJEKT sy-vline
WA_OI0_XMCLIKP_STR-MCKREDIT sy-vline
WA_OI0_XMCLIKP_STR-MCCAS sy-vline
WA_OI0_XMCLIKP_STR-MCKOUPD sy-vline
WA_OI0_XMCLIKP_STR-MCLIPLAN sy-vline
WA_OI0_XMCLIKP_STR-MCWERTKON sy-vline
WA_OI0_XMCLIKP_STR-MCBIW sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.