ABAP Select data from SAP table V_OLR3_EKKX 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 V_OLR3_EKKX 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 V_OLR3_EKKX. 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 V_OLR3_EKKX 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_V_OLR3_EKKX TYPE STANDARD TABLE OF V_OLR3_EKKX,
      WA_V_OLR3_EKKX TYPE V_OLR3_EKKX,
      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: <V_OLR3_EKKX> TYPE V_OLR3_EKKX.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM V_OLR3_EKKX
*  INTO TABLE @DATA(IT_V_OLR3_EKKX2).
*--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_V_OLR3_EKKX INDEX 1 INTO DATA(WA_V_OLR3_EKKX2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_V_OLR3_EKKX ASSIGNING <V_OLR3_EKKX>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<V_OLR3_EKKX>-MANDT = 1.
<V_OLR3_EKKX>-EBELN = 1.
<V_OLR3_EKKX>-BSART = 1.
<V_OLR3_EKKX>-BSAKZ = 1.
<V_OLR3_EKKX>-ERNAM = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_V_OLR3_EKKX-PINCR, sy-vline,
WA_V_OLR3_EKKX-LPONR, sy-vline,
WA_V_OLR3_EKKX-LIFNR, sy-vline,
WA_V_OLR3_EKKX-SPRAS, sy-vline,
WA_V_OLR3_EKKX-ZTERM, sy-vline,
WA_V_OLR3_EKKX-ZBD1T, sy-vline.
ENDLOOP. *Add any further fields from structure WA_V_OLR3_EKKX 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_V_OLR3_EKKX 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_V_OLR3_EKKX INTO WA_V_OLR3_EKKX. *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 EBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OLR3_EKKX-EBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OLR3_EKKX-EBELN.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ISOLA, internal->external for field SPRAS CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_V_OLR3_EKKX-SPRAS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OLR3_EKKX-SPRAS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit NUMCV, internal->external for field REVLV CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_V_OLR3_EKKX-REVLV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OLR3_EKKX-REVLV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit FMCIS, internal->external for field FIPOS CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT' EXPORTING input = WA_V_OLR3_EKKX-FIPOS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OLR3_EKKX-FIPOS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit PERKZ, internal->external for field IPRKZ CALL FUNCTION 'CONVERSION_EXIT_PERKZ_OUTPUT' EXPORTING input = WA_V_OLR3_EKKX-IPRKZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OLR3_EKKX-IPRKZ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field GRANT_NBR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_V_OLR3_EKKX-GRANT_NBR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_V_OLR3_EKKX-GRANT_NBR.
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_V_OLR3_EKKX_STR,
MANDT TYPE STRING,
EBELN TYPE STRING,
BSART TYPE STRING,
BSAKZ TYPE STRING,
ERNAM TYPE STRING,
PINCR TYPE STRING,
LPONR TYPE STRING,
LIFNR TYPE STRING,
SPRAS TYPE STRING,
ZTERM TYPE STRING,
ZBD1T TYPE STRING,
ZBD2T TYPE STRING,
ZBD3T TYPE STRING,
ZBD1P TYPE STRING,
ZBD2P TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
WAERS TYPE STRING,
WKURS TYPE STRING,
KUFIX TYPE STRING,
BEDAT TYPE STRING,
KDATB TYPE STRING,
KDATE TYPE STRING,
BWBDT TYPE STRING,
ANGDT TYPE STRING,
BNDDT TYPE STRING,
GWLDT TYPE STRING,
AUSNR TYPE STRING,
ANGNR TYPE STRING,
IHRAN TYPE STRING,
IHREZ TYPE STRING,
VERKF TYPE STRING,
TELF1 TYPE STRING,
LLIEF TYPE STRING,
ABGRU TYPE STRING,
AUTLF TYPE STRING,
WEAKT TYPE STRING,
RESWK TYPE STRING,
LBLIF TYPE STRING,
KTWRT TYPE STRING,
SUBMI TYPE STRING,
KNUMV TYPE STRING,
KALSM TYPE STRING,
LIFRE TYPE STRING,
EXNUM TYPE STRING,
UNSEZ TYPE STRING,
LOGSY TYPE STRING,
UPINC TYPE STRING,
STAKO TYPE STRING,
FRGGR TYPE STRING,
FRGSX TYPE STRING,
FRGKE TYPE STRING,
FRGZU TYPE STRING,
FRGRL TYPE STRING,
LANDS TYPE STRING,
LPHIS TYPE STRING,
STCEG_L TYPE STRING,
STCEG TYPE STRING,
ABSGR TYPE STRING,
ADDNR TYPE STRING,
KORNR TYPE STRING,
MEMORY TYPE STRING,
PROCSTAT TYPE STRING,
RLWRT TYPE STRING,
REVNO TYPE STRING,
EBELP TYPE STRING,
LOEKZ TYPE STRING,
STATU TYPE STRING,
AEDAT TYPE STRING,
TXZ01 TYPE STRING,
MATNR TYPE STRING,
EMATN TYPE STRING,
BUKRS TYPE STRING,
WERKS TYPE STRING,
LGORT TYPE STRING,
BEDNR TYPE STRING,
MATKL TYPE STRING,
INFNR TYPE STRING,
IDNLF TYPE STRING,
KTMNG TYPE STRING,
MENGE TYPE STRING,
MEINS TYPE STRING,
BPRME TYPE STRING,
BPUMZ TYPE STRING,
BPUMN TYPE STRING,
UMREZ TYPE STRING,
UMREN TYPE STRING,
NETPR TYPE STRING,
PEINH TYPE STRING,
NETWR TYPE STRING,
BRTWR TYPE STRING,
AGDAT TYPE STRING,
WEBAZ TYPE STRING,
MWSKZ TYPE STRING,
BONUS TYPE STRING,
INSMK TYPE STRING,
SPINF TYPE STRING,
PRSDR TYPE STRING,
SCHPR TYPE STRING,
MAHNZ TYPE STRING,
MAHN1 TYPE STRING,
MAHN2 TYPE STRING,
MAHN3 TYPE STRING,
UEBTO TYPE STRING,
UEBTK TYPE STRING,
UNTTO TYPE STRING,
BWTAR TYPE STRING,
BWTTY TYPE STRING,
ABSKZ TYPE STRING,
AGMEM TYPE STRING,
ELIKZ TYPE STRING,
EREKZ TYPE STRING,
PSTYP TYPE STRING,
KNTTP TYPE STRING,
KZVBR TYPE STRING,
VRTKZ TYPE STRING,
TWRKZ TYPE STRING,
WEPOS TYPE STRING,
WEUNB TYPE STRING,
REPOS TYPE STRING,
WEBRE TYPE STRING,
KZABS TYPE STRING,
LABNR TYPE STRING,
KONNR TYPE STRING,
KTPNR TYPE STRING,
ABDAT TYPE STRING,
ABFTZ TYPE STRING,
ETFZ1 TYPE STRING,
ETFZ2 TYPE STRING,
KZSTU TYPE STRING,
NOTKZ TYPE STRING,
LMEIN TYPE STRING,
EVERS TYPE STRING,
ZWERT TYPE STRING,
NAVNW TYPE STRING,
ABMNG TYPE STRING,
PRDAT TYPE STRING,
BSTYP TYPE STRING,
EFFWR TYPE STRING,
XOBLR TYPE STRING,
KUNNR TYPE STRING,
ADRNR TYPE STRING,
EKKOL TYPE STRING,
SKTOF TYPE STRING,
STAFO TYPE STRING,
PLIFZ TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
TXJCD TYPE STRING,
ETDRK TYPE STRING,
SOBKZ TYPE STRING,
ARSNR TYPE STRING,
ARSPS TYPE STRING,
INSNC TYPE STRING,
SSQSS TYPE STRING,
ZGTYP TYPE STRING,
EAN11 TYPE STRING,
BSTAE TYPE STRING,
REVLV TYPE STRING,
GEBER TYPE STRING,
FISTL TYPE STRING,
FIPOS TYPE STRING,
KO_GSBER TYPE STRING,
KO_PARGB TYPE STRING,
KO_PRCTR TYPE STRING,
KO_PPRCTR TYPE STRING,
MEPRF TYPE STRING,
BRGEW TYPE STRING,
VOLUM TYPE STRING,
VOLEH TYPE STRING,
INCO1 TYPE STRING,
INCO2 TYPE STRING,
VORAB TYPE STRING,
KOLIF TYPE STRING,
LTSNR TYPE STRING,
PACKNO TYPE STRING,
FPLNR TYPE STRING,
GNETWR TYPE STRING,
STAPO TYPE STRING,
UEBPO TYPE STRING,
LEWED TYPE STRING,
EMLIF TYPE STRING,
LBLKZ TYPE STRING,
SATNR TYPE STRING,
ATTYP TYPE STRING,
KANBA TYPE STRING,
ADRN2 TYPE STRING,
CUOBJ TYPE STRING,
XERSY TYPE STRING,
EILDT TYPE STRING,
DRDAT TYPE STRING,
DRUHR TYPE STRING,
DRUNR TYPE STRING,
AKTNR TYPE STRING,
ABELN TYPE STRING,
ABELP TYPE STRING,
ANZPU TYPE STRING,
PUNEI TYPE STRING,
SAISO TYPE STRING,
SAISJ TYPE STRING,
EBON2 TYPE STRING,
EBON3 TYPE STRING,
EBONF TYPE STRING,
MLMAA TYPE STRING,
MHDRZ TYPE STRING,
ANFNR TYPE STRING,
ANFPS TYPE STRING,
KZKFG TYPE STRING,
USEQU TYPE STRING,
UMSOK TYPE STRING,
BANFN TYPE STRING,
BNFPO TYPE STRING,
MTART TYPE STRING,
UPTYP TYPE STRING,
UPVOR TYPE STRING,
KZWI1 TYPE STRING,
KZWI2 TYPE STRING,
KZWI3 TYPE STRING,
KZWI4 TYPE STRING,
KZWI5 TYPE STRING,
KZWI6 TYPE STRING,
SIKGR TYPE STRING,
MFZHI TYPE STRING,
FFZHI TYPE STRING,
RETPO TYPE STRING,
AUREL TYPE STRING,
BSGRU TYPE STRING,
LFRET TYPE STRING,
MFRGR TYPE STRING,
NRFHG TYPE STRING,
J_1BNBM TYPE STRING,
J_1BMATUSE TYPE STRING,
J_1BMATORG TYPE STRING,
J_1BOWNPRO TYPE STRING,
J_1BINDUST TYPE STRING,
ABUEB TYPE STRING,
NLABD TYPE STRING,
NFABD TYPE STRING,
KZBWS TYPE STRING,
BONBA TYPE STRING,
FABKZ TYPE STRING,
J_1AINDXP TYPE STRING,
J_1AIDATEP TYPE STRING,
MPROF TYPE STRING,
EGLKZ TYPE STRING,
KZTLF TYPE STRING,
KZFME TYPE STRING,
RDPRF TYPE STRING,
TECHS TYPE STRING,
CHG_SRV TYPE STRING,
CHG_FPLNR TYPE STRING,
MFRPN TYPE STRING,
MFRNR TYPE STRING,
EMNFR TYPE STRING,
NOVET TYPE STRING,
AFNAM TYPE STRING,
TZONRC TYPE STRING,
IPRKZ TYPE STRING,
LEBRE TYPE STRING,
BERID TYPE STRING,
XCONDITIONS TYPE STRING,
APOMS TYPE STRING,
CCOMP TYPE STRING,
GRANT_NBR TYPE STRING,
FKBER TYPE STRING,
STATUS TYPE STRING,
REFSITE TYPE STRING,END OF T_EKKO_STR. DATA: WA_V_OLR3_EKKX_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_V_OLR3_EKKX_STR-MANDT sy-vline
WA_V_OLR3_EKKX_STR-EBELN sy-vline
WA_V_OLR3_EKKX_STR-BSART sy-vline
WA_V_OLR3_EKKX_STR-BSAKZ sy-vline
WA_V_OLR3_EKKX_STR-ERNAM sy-vline
WA_V_OLR3_EKKX_STR-PINCR sy-vline
WA_V_OLR3_EKKX_STR-LPONR sy-vline
WA_V_OLR3_EKKX_STR-LIFNR sy-vline
WA_V_OLR3_EKKX_STR-SPRAS sy-vline
WA_V_OLR3_EKKX_STR-ZTERM sy-vline
WA_V_OLR3_EKKX_STR-ZBD1T sy-vline
WA_V_OLR3_EKKX_STR-ZBD2T sy-vline
WA_V_OLR3_EKKX_STR-ZBD3T sy-vline
WA_V_OLR3_EKKX_STR-ZBD1P sy-vline
WA_V_OLR3_EKKX_STR-ZBD2P sy-vline
WA_V_OLR3_EKKX_STR-EKORG sy-vline
WA_V_OLR3_EKKX_STR-EKGRP sy-vline
WA_V_OLR3_EKKX_STR-WAERS sy-vline
WA_V_OLR3_EKKX_STR-WKURS sy-vline
WA_V_OLR3_EKKX_STR-KUFIX sy-vline
WA_V_OLR3_EKKX_STR-BEDAT sy-vline
WA_V_OLR3_EKKX_STR-KDATB sy-vline
WA_V_OLR3_EKKX_STR-KDATE sy-vline
WA_V_OLR3_EKKX_STR-BWBDT sy-vline
WA_V_OLR3_EKKX_STR-ANGDT sy-vline
WA_V_OLR3_EKKX_STR-BNDDT sy-vline
WA_V_OLR3_EKKX_STR-GWLDT sy-vline
WA_V_OLR3_EKKX_STR-AUSNR sy-vline
WA_V_OLR3_EKKX_STR-ANGNR sy-vline
WA_V_OLR3_EKKX_STR-IHRAN sy-vline
WA_V_OLR3_EKKX_STR-IHREZ sy-vline
WA_V_OLR3_EKKX_STR-VERKF sy-vline
WA_V_OLR3_EKKX_STR-TELF1 sy-vline
WA_V_OLR3_EKKX_STR-LLIEF sy-vline
WA_V_OLR3_EKKX_STR-ABGRU sy-vline
WA_V_OLR3_EKKX_STR-AUTLF sy-vline
WA_V_OLR3_EKKX_STR-WEAKT sy-vline
WA_V_OLR3_EKKX_STR-RESWK sy-vline
WA_V_OLR3_EKKX_STR-LBLIF sy-vline
WA_V_OLR3_EKKX_STR-KTWRT sy-vline
WA_V_OLR3_EKKX_STR-SUBMI sy-vline
WA_V_OLR3_EKKX_STR-KNUMV sy-vline
WA_V_OLR3_EKKX_STR-KALSM sy-vline
WA_V_OLR3_EKKX_STR-LIFRE sy-vline
WA_V_OLR3_EKKX_STR-EXNUM sy-vline
WA_V_OLR3_EKKX_STR-UNSEZ sy-vline
WA_V_OLR3_EKKX_STR-LOGSY sy-vline
WA_V_OLR3_EKKX_STR-UPINC sy-vline
WA_V_OLR3_EKKX_STR-STAKO sy-vline
WA_V_OLR3_EKKX_STR-FRGGR sy-vline
WA_V_OLR3_EKKX_STR-FRGSX sy-vline
WA_V_OLR3_EKKX_STR-FRGKE sy-vline
WA_V_OLR3_EKKX_STR-FRGZU sy-vline
WA_V_OLR3_EKKX_STR-FRGRL sy-vline
WA_V_OLR3_EKKX_STR-LANDS sy-vline
WA_V_OLR3_EKKX_STR-LPHIS sy-vline
WA_V_OLR3_EKKX_STR-STCEG_L sy-vline
WA_V_OLR3_EKKX_STR-STCEG sy-vline
WA_V_OLR3_EKKX_STR-ABSGR sy-vline
WA_V_OLR3_EKKX_STR-ADDNR sy-vline
WA_V_OLR3_EKKX_STR-KORNR sy-vline
WA_V_OLR3_EKKX_STR-MEMORY sy-vline
WA_V_OLR3_EKKX_STR-PROCSTAT sy-vline
WA_V_OLR3_EKKX_STR-RLWRT sy-vline
WA_V_OLR3_EKKX_STR-REVNO sy-vline
WA_V_OLR3_EKKX_STR-EBELP sy-vline
WA_V_OLR3_EKKX_STR-LOEKZ sy-vline
WA_V_OLR3_EKKX_STR-STATU sy-vline
WA_V_OLR3_EKKX_STR-AEDAT sy-vline
WA_V_OLR3_EKKX_STR-TXZ01 sy-vline
WA_V_OLR3_EKKX_STR-MATNR sy-vline
WA_V_OLR3_EKKX_STR-EMATN sy-vline
WA_V_OLR3_EKKX_STR-BUKRS sy-vline
WA_V_OLR3_EKKX_STR-WERKS sy-vline
WA_V_OLR3_EKKX_STR-LGORT sy-vline
WA_V_OLR3_EKKX_STR-BEDNR sy-vline
WA_V_OLR3_EKKX_STR-MATKL sy-vline
WA_V_OLR3_EKKX_STR-INFNR sy-vline
WA_V_OLR3_EKKX_STR-IDNLF sy-vline
WA_V_OLR3_EKKX_STR-KTMNG sy-vline
WA_V_OLR3_EKKX_STR-MENGE sy-vline
WA_V_OLR3_EKKX_STR-MEINS sy-vline
WA_V_OLR3_EKKX_STR-BPRME sy-vline
WA_V_OLR3_EKKX_STR-BPUMZ sy-vline
WA_V_OLR3_EKKX_STR-BPUMN sy-vline
WA_V_OLR3_EKKX_STR-UMREZ sy-vline
WA_V_OLR3_EKKX_STR-UMREN sy-vline
WA_V_OLR3_EKKX_STR-NETPR sy-vline
WA_V_OLR3_EKKX_STR-PEINH sy-vline
WA_V_OLR3_EKKX_STR-NETWR sy-vline
WA_V_OLR3_EKKX_STR-BRTWR sy-vline
WA_V_OLR3_EKKX_STR-AGDAT sy-vline
WA_V_OLR3_EKKX_STR-WEBAZ sy-vline
WA_V_OLR3_EKKX_STR-MWSKZ sy-vline
WA_V_OLR3_EKKX_STR-BONUS sy-vline
WA_V_OLR3_EKKX_STR-INSMK sy-vline
WA_V_OLR3_EKKX_STR-SPINF sy-vline
WA_V_OLR3_EKKX_STR-PRSDR sy-vline
WA_V_OLR3_EKKX_STR-SCHPR sy-vline
WA_V_OLR3_EKKX_STR-MAHNZ sy-vline
WA_V_OLR3_EKKX_STR-MAHN1 sy-vline
WA_V_OLR3_EKKX_STR-MAHN2 sy-vline
WA_V_OLR3_EKKX_STR-MAHN3 sy-vline
WA_V_OLR3_EKKX_STR-UEBTO sy-vline
WA_V_OLR3_EKKX_STR-UEBTK sy-vline
WA_V_OLR3_EKKX_STR-UNTTO sy-vline
WA_V_OLR3_EKKX_STR-BWTAR sy-vline
WA_V_OLR3_EKKX_STR-BWTTY sy-vline
WA_V_OLR3_EKKX_STR-ABSKZ sy-vline
WA_V_OLR3_EKKX_STR-AGMEM sy-vline
WA_V_OLR3_EKKX_STR-ELIKZ sy-vline
WA_V_OLR3_EKKX_STR-EREKZ sy-vline
WA_V_OLR3_EKKX_STR-PSTYP sy-vline
WA_V_OLR3_EKKX_STR-KNTTP sy-vline
WA_V_OLR3_EKKX_STR-KZVBR sy-vline
WA_V_OLR3_EKKX_STR-VRTKZ sy-vline
WA_V_OLR3_EKKX_STR-TWRKZ sy-vline
WA_V_OLR3_EKKX_STR-WEPOS sy-vline
WA_V_OLR3_EKKX_STR-WEUNB sy-vline
WA_V_OLR3_EKKX_STR-REPOS sy-vline
WA_V_OLR3_EKKX_STR-WEBRE sy-vline
WA_V_OLR3_EKKX_STR-KZABS sy-vline
WA_V_OLR3_EKKX_STR-LABNR sy-vline
WA_V_OLR3_EKKX_STR-KONNR sy-vline
WA_V_OLR3_EKKX_STR-KTPNR sy-vline
WA_V_OLR3_EKKX_STR-ABDAT sy-vline
WA_V_OLR3_EKKX_STR-ABFTZ sy-vline
WA_V_OLR3_EKKX_STR-ETFZ1 sy-vline
WA_V_OLR3_EKKX_STR-ETFZ2 sy-vline
WA_V_OLR3_EKKX_STR-KZSTU sy-vline
WA_V_OLR3_EKKX_STR-NOTKZ sy-vline
WA_V_OLR3_EKKX_STR-LMEIN sy-vline
WA_V_OLR3_EKKX_STR-EVERS sy-vline
WA_V_OLR3_EKKX_STR-ZWERT sy-vline
WA_V_OLR3_EKKX_STR-NAVNW sy-vline
WA_V_OLR3_EKKX_STR-ABMNG sy-vline
WA_V_OLR3_EKKX_STR-PRDAT sy-vline
WA_V_OLR3_EKKX_STR-BSTYP sy-vline
WA_V_OLR3_EKKX_STR-EFFWR sy-vline
WA_V_OLR3_EKKX_STR-XOBLR sy-vline
WA_V_OLR3_EKKX_STR-KUNNR sy-vline
WA_V_OLR3_EKKX_STR-ADRNR sy-vline
WA_V_OLR3_EKKX_STR-EKKOL sy-vline
WA_V_OLR3_EKKX_STR-SKTOF sy-vline
WA_V_OLR3_EKKX_STR-STAFO sy-vline
WA_V_OLR3_EKKX_STR-PLIFZ sy-vline
WA_V_OLR3_EKKX_STR-NTGEW sy-vline
WA_V_OLR3_EKKX_STR-GEWEI sy-vline
WA_V_OLR3_EKKX_STR-TXJCD sy-vline
WA_V_OLR3_EKKX_STR-ETDRK sy-vline
WA_V_OLR3_EKKX_STR-SOBKZ sy-vline
WA_V_OLR3_EKKX_STR-ARSNR sy-vline
WA_V_OLR3_EKKX_STR-ARSPS sy-vline
WA_V_OLR3_EKKX_STR-INSNC sy-vline
WA_V_OLR3_EKKX_STR-SSQSS sy-vline
WA_V_OLR3_EKKX_STR-ZGTYP sy-vline
WA_V_OLR3_EKKX_STR-EAN11 sy-vline
WA_V_OLR3_EKKX_STR-BSTAE sy-vline
WA_V_OLR3_EKKX_STR-REVLV sy-vline
WA_V_OLR3_EKKX_STR-GEBER sy-vline
WA_V_OLR3_EKKX_STR-FISTL sy-vline
WA_V_OLR3_EKKX_STR-FIPOS sy-vline
WA_V_OLR3_EKKX_STR-KO_GSBER sy-vline
WA_V_OLR3_EKKX_STR-KO_PARGB sy-vline
WA_V_OLR3_EKKX_STR-KO_PRCTR sy-vline
WA_V_OLR3_EKKX_STR-KO_PPRCTR sy-vline
WA_V_OLR3_EKKX_STR-MEPRF sy-vline
WA_V_OLR3_EKKX_STR-BRGEW sy-vline
WA_V_OLR3_EKKX_STR-VOLUM sy-vline
WA_V_OLR3_EKKX_STR-VOLEH sy-vline
WA_V_OLR3_EKKX_STR-INCO1 sy-vline
WA_V_OLR3_EKKX_STR-INCO2 sy-vline
WA_V_OLR3_EKKX_STR-VORAB sy-vline
WA_V_OLR3_EKKX_STR-KOLIF sy-vline
WA_V_OLR3_EKKX_STR-LTSNR sy-vline
WA_V_OLR3_EKKX_STR-PACKNO sy-vline
WA_V_OLR3_EKKX_STR-FPLNR sy-vline
WA_V_OLR3_EKKX_STR-GNETWR sy-vline
WA_V_OLR3_EKKX_STR-STAPO sy-vline
WA_V_OLR3_EKKX_STR-UEBPO sy-vline
WA_V_OLR3_EKKX_STR-LEWED sy-vline
WA_V_OLR3_EKKX_STR-EMLIF sy-vline
WA_V_OLR3_EKKX_STR-LBLKZ sy-vline
WA_V_OLR3_EKKX_STR-SATNR sy-vline
WA_V_OLR3_EKKX_STR-ATTYP sy-vline
WA_V_OLR3_EKKX_STR-KANBA sy-vline
WA_V_OLR3_EKKX_STR-ADRN2 sy-vline
WA_V_OLR3_EKKX_STR-CUOBJ sy-vline
WA_V_OLR3_EKKX_STR-XERSY sy-vline
WA_V_OLR3_EKKX_STR-EILDT sy-vline
WA_V_OLR3_EKKX_STR-DRDAT sy-vline
WA_V_OLR3_EKKX_STR-DRUHR sy-vline
WA_V_OLR3_EKKX_STR-DRUNR sy-vline
WA_V_OLR3_EKKX_STR-AKTNR sy-vline
WA_V_OLR3_EKKX_STR-ABELN sy-vline
WA_V_OLR3_EKKX_STR-ABELP sy-vline
WA_V_OLR3_EKKX_STR-ANZPU sy-vline
WA_V_OLR3_EKKX_STR-PUNEI sy-vline
WA_V_OLR3_EKKX_STR-SAISO sy-vline
WA_V_OLR3_EKKX_STR-SAISJ sy-vline
WA_V_OLR3_EKKX_STR-EBON2 sy-vline
WA_V_OLR3_EKKX_STR-EBON3 sy-vline
WA_V_OLR3_EKKX_STR-EBONF sy-vline
WA_V_OLR3_EKKX_STR-MLMAA sy-vline
WA_V_OLR3_EKKX_STR-MHDRZ sy-vline
WA_V_OLR3_EKKX_STR-ANFNR sy-vline
WA_V_OLR3_EKKX_STR-ANFPS sy-vline
WA_V_OLR3_EKKX_STR-KZKFG sy-vline
WA_V_OLR3_EKKX_STR-USEQU sy-vline
WA_V_OLR3_EKKX_STR-UMSOK sy-vline
WA_V_OLR3_EKKX_STR-BANFN sy-vline
WA_V_OLR3_EKKX_STR-BNFPO sy-vline
WA_V_OLR3_EKKX_STR-MTART sy-vline
WA_V_OLR3_EKKX_STR-UPTYP sy-vline
WA_V_OLR3_EKKX_STR-UPVOR sy-vline
WA_V_OLR3_EKKX_STR-KZWI1 sy-vline
WA_V_OLR3_EKKX_STR-KZWI2 sy-vline
WA_V_OLR3_EKKX_STR-KZWI3 sy-vline
WA_V_OLR3_EKKX_STR-KZWI4 sy-vline
WA_V_OLR3_EKKX_STR-KZWI5 sy-vline
WA_V_OLR3_EKKX_STR-KZWI6 sy-vline
WA_V_OLR3_EKKX_STR-SIKGR sy-vline
WA_V_OLR3_EKKX_STR-MFZHI sy-vline
WA_V_OLR3_EKKX_STR-FFZHI sy-vline
WA_V_OLR3_EKKX_STR-RETPO sy-vline
WA_V_OLR3_EKKX_STR-AUREL sy-vline
WA_V_OLR3_EKKX_STR-BSGRU sy-vline
WA_V_OLR3_EKKX_STR-LFRET sy-vline
WA_V_OLR3_EKKX_STR-MFRGR sy-vline
WA_V_OLR3_EKKX_STR-NRFHG sy-vline
WA_V_OLR3_EKKX_STR-J_1BNBM sy-vline
WA_V_OLR3_EKKX_STR-J_1BMATUSE sy-vline
WA_V_OLR3_EKKX_STR-J_1BMATORG sy-vline
WA_V_OLR3_EKKX_STR-J_1BOWNPRO sy-vline
WA_V_OLR3_EKKX_STR-J_1BINDUST sy-vline
WA_V_OLR3_EKKX_STR-ABUEB sy-vline
WA_V_OLR3_EKKX_STR-NLABD sy-vline
WA_V_OLR3_EKKX_STR-NFABD sy-vline
WA_V_OLR3_EKKX_STR-KZBWS sy-vline
WA_V_OLR3_EKKX_STR-BONBA sy-vline
WA_V_OLR3_EKKX_STR-FABKZ sy-vline
WA_V_OLR3_EKKX_STR-J_1AINDXP sy-vline
WA_V_OLR3_EKKX_STR-J_1AIDATEP sy-vline
WA_V_OLR3_EKKX_STR-MPROF sy-vline
WA_V_OLR3_EKKX_STR-EGLKZ sy-vline
WA_V_OLR3_EKKX_STR-KZTLF sy-vline
WA_V_OLR3_EKKX_STR-KZFME sy-vline
WA_V_OLR3_EKKX_STR-RDPRF sy-vline
WA_V_OLR3_EKKX_STR-TECHS sy-vline
WA_V_OLR3_EKKX_STR-CHG_SRV sy-vline
WA_V_OLR3_EKKX_STR-CHG_FPLNR sy-vline
WA_V_OLR3_EKKX_STR-MFRPN sy-vline
WA_V_OLR3_EKKX_STR-MFRNR sy-vline
WA_V_OLR3_EKKX_STR-EMNFR sy-vline
WA_V_OLR3_EKKX_STR-NOVET sy-vline
WA_V_OLR3_EKKX_STR-AFNAM sy-vline
WA_V_OLR3_EKKX_STR-TZONRC sy-vline
WA_V_OLR3_EKKX_STR-IPRKZ sy-vline
WA_V_OLR3_EKKX_STR-LEBRE sy-vline
WA_V_OLR3_EKKX_STR-BERID sy-vline
WA_V_OLR3_EKKX_STR-XCONDITIONS sy-vline
WA_V_OLR3_EKKX_STR-APOMS sy-vline
WA_V_OLR3_EKKX_STR-CCOMP sy-vline
WA_V_OLR3_EKKX_STR-GRANT_NBR sy-vline
WA_V_OLR3_EKKX_STR-FKBER sy-vline
WA_V_OLR3_EKKX_STR-STATUS sy-vline
WA_V_OLR3_EKKX_STR-REFSITE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.