ABAP Select data from SAP table KOMLKGN into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP KOMLKGN 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 KOMLKGN. 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 KOMLKGN 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_KOMLKGN TYPE STANDARD TABLE OF KOMLKGN,
      WA_KOMLKGN TYPE KOMLKGN,
      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: <KOMLKGN> TYPE KOMLKGN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM KOMLKGN
*  INTO TABLE @DATA(IT_KOMLKGN2).
*--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_KOMLKGN INDEX 1 INTO DATA(WA_KOMLKGN2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_KOMLKGN ASSIGNING <KOMLKGN>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<KOMLKGN>-MANDT = 1.
<KOMLKGN>-JVBTYP = 1.
<KOMLKGN>-WAERK = 1.
<KOMLKGN>-EKORG = 1.
<KOMLKGN>-KALSM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_KOMLKGN-KNUMV, sy-vline,
  WA_KOMLKGN-ABDAT, sy-vline,
  WA_KOMLKGN-BELNR, sy-vline,
  WA_KOMLKGN-GJAHR, sy-vline,
  WA_KOMLKGN-POPER, sy-vline,
  WA_KOMLKGN-RFBSK, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_KOMLKGN 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_KOMLKGN 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_KOMLKGN INTO WA_KOMLKGN.


*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 BELNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_KOMLKGN-BELNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KOMLKGN-BELNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_KOMLKGN-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_KOMLKGN-MATNR.
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_KOMLKGN_STR, 
MANDT TYPE STRING,
JVBTYP TYPE STRING,
WAERK TYPE STRING,
EKORG TYPE STRING,
KALSM TYPE STRING,
KNUMV TYPE STRING,
ABDAT TYPE STRING,
BELNR TYPE STRING,
GJAHR TYPE STRING,
POPER TYPE STRING,
RFBSK TYPE STRING,
KURRF TYPE STRING,
CPKUR TYPE STRING,
VALTG TYPE STRING,
VALDT TYPE STRING,
LAND1 TYPE STRING,
ZTERM TYPE STRING,
BUKRS TYPE STRING,
MWSKZ TYPE STRING,
NETWR TYPE STRING,
ZUKRI TYPE STRING,
STWAE TYPE STRING,
STCEG TYPE STRING,
AEDAT TYPE STRING,
JSFAKN TYPE STRING,
KURST TYPE STRING,
OBJART TYPE STRING,
KURSK TYPE STRING,
JAUART TYPE STRING,
AUARTGRP TYPE STRING,
ABIMG TYPE STRING,
MEINS TYPE STRING,
SMENG TYPE STRING,
BEILAGEN TYPE STRING,
MEINHBL TYPE STRING,
BRGEW TYPE STRING,
NTGEW TYPE STRING,
MEINHGW TYPE STRING,
GSBER TYPE STRING,
KREWL TYPE STRING,
KREZE TYPE STRING,
KRERS TYPE STRING,
KREAN TYPE STRING,
PRSDT TYPE STRING,
FBUDA TYPE STRING,
VBELV TYPE STRING,
POSNV TYPE STRING,
VGBEL TYPE STRING,
VGPOS TYPE STRING,
VGTYP TYPE STRING,
NO_DIENL TYPE STRING,
DIENL TYPE STRING,
ARKTX TYPE STRING,
POSAR TYPE STRING,
TAXM1 TYPE STRING,
TAXM2 TYPE STRING,
TAXM3 TYPE STRING,
TAXM4 TYPE STRING,
TAXM5 TYPE STRING,
TAXM6 TYPE STRING,
TAXM7 TYPE STRING,
TAXM8 TYPE STRING,
TAXM9 TYPE STRING,
KOWRR TYPE STRING,
PRSFD TYPE STRING,
KOSTL TYPE STRING,
STAFO TYPE STRING,
WAVWR TYPE STRING,
KZWI1 TYPE STRING,
KZWI2 TYPE STRING,
KZWI3 TYPE STRING,
KZWI4 TYPE STRING,
KZWI5 TYPE STRING,
KZWI6 TYPE STRING,
STCUR TYPE STRING,
UVPRS TYPE STRING,
UVALL TYPE STRING,
PRCTR TYPE STRING,
KOKRS TYPE STRING,
PAOBJNR TYPE STRING,
PS_PSP_PNR TYPE STRING,
TXJCD TYPE STRING,
XBEZPOS TYPE STRING,
KNDGRUPPE TYPE STRING,
NACHLFNGNR TYPE STRING,
LFNGNR TYPE STRING,
GP_ERS_ART TYPE STRING,
VERSANDDAT TYPE STRING,
TRAGEZ TYPE STRING,
BEZTYP TYPE STRING,
DRUTAT TYPE STRING,
DRUART TYPE STRING,
PVATAT TYPE STRING,
NORMZG TYPE STRING,
NORMZU TYPE STRING,
WRBMZG TYPE STRING,
WRBMZU TYPE STRING,
NORMDZ TYPE STRING,
NORMDG TYPE STRING,
BEZTAT TYPE STRING,
BEZRTA TYPE STRING,
LFATAT TYPE STRING,
XSCHLGELD TYPE STRING,
XWEGGLDNT TYPE STRING,
XWEGGLDFG TYPE STRING,
XWEGGLDFN TYPE STRING,
XWGGELDPA TYPE STRING,
XFARGLDNT TYPE STRING,
XFARGLDFG TYPE STRING,
XFARGLDFN TYPE STRING,
XFAHRGELD TYPE STRING,
XBEILZUNT TYPE STRING,
XBEILZUFG TYPE STRING,
XBEILZUFN TYPE STRING,
XGEWIZUNT TYPE STRING,
XGEWIZUFG TYPE STRING,
XGEWIZUFN TYPE STRING,
KTFEIERFG TYPE STRING,
KTFEIERFN TYPE STRING,
KTNACHTNT TYPE STRING,
KTNACHTFG TYPE STRING,
KTNACHTFN TYPE STRING,
KTSONN_NT TYPE STRING,
KTSONN_FG TYPE STRING,
KTSONN_FN TYPE STRING,
KTSLGD TYPE STRING,
KTWEGD TYPE STRING,
KTFAGD TYPE STRING,
KTTOPO TYPE STRING,
KTTRAG TYPE STRING,
BEZKT1 TYPE STRING,
BEZKT2 TYPE STRING,
BEZKT3 TYPE STRING,
BEZKT4 TYPE STRING,
BEZKT5 TYPE STRING,
GEWTVA TYPE STRING,
GEWBEI TYPE STRING,
GESGEW TYPE STRING,
ANZBEI TYPE STRING,
MEINHG TYPE STRING,
XFEIERTAG TYPE STRING,
WOTAG_N TYPE STRING,
WOTAG_A TYPE STRING,
XVERGPVAST TYPE STRING,
XVERGPVAPE TYPE STRING,
XVERGPVATD TYPE STRING,
XVERGPVADU TYPE STRING,
XVERGBEZPA TYPE STRING,
DRERZ TYPE STRING,
PVA TYPE STRING,
BZPERF TYPE STRING,
WRBART TYPE STRING,
WRBAKT TYPE STRING,
MINBEZ TYPE STRING,
MINEIN TYPE STRING,
XWKZ TYPE STRING,
POART TYPE STRING,
XEINML TYPE STRING,
XRENDI TYPE STRING,
XPATE TYPE STRING,
XFBLGABR TYPE STRING,
ZLSCH TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
GPAG TYPE STRING,
GPRG TYPE STRING,
BSTDK TYPE STRING,
VBELN TYPE STRING,
POSNR TYPE STRING,
POSEX TYPE STRING,
ETENR TYPE STRING,
GUELTIGVON TYPE STRING,
RECHBEGINN TYPE STRING,
XIMMAT TYPE STRING,
FXMSG TYPE STRING,
JSNABR TYPE STRING,
FKDAT TYPE STRING,
FAKVON TYPE STRING,
FAKBIS TYPE STRING,
OBJART_V TYPE STRING,
UEBERLART TYPE STRING,
KONDA TYPE STRING,
ABRPOS TYPE STRING,
MONBEW TYPE STRING,
SHKZG TYPE STRING,
ANZMONABRE TYPE STRING,
XPROVRUECK TYPE STRING,
PERNR TYPE STRING,
JPROVKDAT TYPE STRING,
ANZET TYPE STRING,
XJSIF TYPE STRING,
XINDART TYPE STRING,
PROVRART TYPE STRING,
DUMMY TYPE STRING,
WERBKZSCHL TYPE STRING,
XNEGOP TYPE STRING,
FKPER TYPE STRING,
ZUSTTYP TYPE STRING,
KTGRD_MA TYPE STRING,
KTGRDVSG TYPE STRING,
WRBMDZ TYPE STRING,
WRBMDG TYPE STRING,
VKORG TYPE STRING,
FAHRKM TYPE STRING,
EFAHRK TYPE STRING,
BBEWRT TYPE STRING,
VERKMITART TYPE STRING,
TAET_KLASS TYPE STRING,
VORGAENGER TYPE STRING,
NACHFOLGER TYPE STRING,
DRERZTRAEG TYPE STRING,
PVATRAEG TYPE STRING,
VERTYP TYPE STRING,
VAUSGB TYPE STRING,
PROMNR TYPE STRING,
PROVPERCNT TYPE STRING,
EVENT TYPE STRING,
XAQUISITION TYPE STRING,
VKONT TYPE STRING,
MATNR TYPE STRING,
MONNRCOMPL TYPE STRING,
MONFACTOR TYPE STRING,
TUENRCOMPL TYPE STRING,
TUEFACTOR TYPE STRING,
WEDNRCOMPL TYPE STRING,
WEDFACTOR TYPE STRING,
THUNRCOMPL TYPE STRING,
THUFACTOR TYPE STRING,
FRINRCOMPL TYPE STRING,
FRIFACTOR TYPE STRING,
SATNRCOMPL TYPE STRING,
SATFACTOR TYPE STRING,
SUNNRCOMPL TYPE STRING,
SUNFACTOR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_KOMLKGN_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_KOMLKGN_STR-MANDT sy-vline 
WA_KOMLKGN_STR-JVBTYP sy-vline 
WA_KOMLKGN_STR-WAERK sy-vline 
WA_KOMLKGN_STR-EKORG sy-vline 
WA_KOMLKGN_STR-KALSM sy-vline 
WA_KOMLKGN_STR-KNUMV sy-vline 
WA_KOMLKGN_STR-ABDAT sy-vline 
WA_KOMLKGN_STR-BELNR sy-vline 
WA_KOMLKGN_STR-GJAHR sy-vline 
WA_KOMLKGN_STR-POPER sy-vline 
WA_KOMLKGN_STR-RFBSK sy-vline 
WA_KOMLKGN_STR-KURRF sy-vline 
WA_KOMLKGN_STR-CPKUR sy-vline 
WA_KOMLKGN_STR-VALTG sy-vline 
WA_KOMLKGN_STR-VALDT sy-vline 
WA_KOMLKGN_STR-LAND1 sy-vline 
WA_KOMLKGN_STR-ZTERM sy-vline 
WA_KOMLKGN_STR-BUKRS sy-vline 
WA_KOMLKGN_STR-MWSKZ sy-vline 
WA_KOMLKGN_STR-NETWR sy-vline 
WA_KOMLKGN_STR-ZUKRI sy-vline 
WA_KOMLKGN_STR-STWAE sy-vline 
WA_KOMLKGN_STR-STCEG sy-vline 
WA_KOMLKGN_STR-AEDAT sy-vline 
WA_KOMLKGN_STR-JSFAKN sy-vline 
WA_KOMLKGN_STR-KURST sy-vline 
WA_KOMLKGN_STR-OBJART sy-vline 
WA_KOMLKGN_STR-KURSK sy-vline 
WA_KOMLKGN_STR-JAUART sy-vline 
WA_KOMLKGN_STR-AUARTGRP sy-vline 
WA_KOMLKGN_STR-ABIMG sy-vline 
WA_KOMLKGN_STR-MEINS sy-vline 
WA_KOMLKGN_STR-SMENG sy-vline 
WA_KOMLKGN_STR-BEILAGEN sy-vline 
WA_KOMLKGN_STR-MEINHBL sy-vline 
WA_KOMLKGN_STR-BRGEW sy-vline 
WA_KOMLKGN_STR-NTGEW sy-vline 
WA_KOMLKGN_STR-MEINHGW sy-vline 
WA_KOMLKGN_STR-GSBER sy-vline 
WA_KOMLKGN_STR-KREWL sy-vline 
WA_KOMLKGN_STR-KREZE sy-vline 
WA_KOMLKGN_STR-KRERS sy-vline 
WA_KOMLKGN_STR-KREAN sy-vline 
WA_KOMLKGN_STR-PRSDT sy-vline 
WA_KOMLKGN_STR-FBUDA sy-vline 
WA_KOMLKGN_STR-VBELV sy-vline 
WA_KOMLKGN_STR-POSNV sy-vline 
WA_KOMLKGN_STR-VGBEL sy-vline 
WA_KOMLKGN_STR-VGPOS sy-vline 
WA_KOMLKGN_STR-VGTYP sy-vline 
WA_KOMLKGN_STR-NO_DIENL sy-vline 
WA_KOMLKGN_STR-DIENL sy-vline 
WA_KOMLKGN_STR-ARKTX sy-vline 
WA_KOMLKGN_STR-POSAR sy-vline 
WA_KOMLKGN_STR-TAXM1 sy-vline 
WA_KOMLKGN_STR-TAXM2 sy-vline 
WA_KOMLKGN_STR-TAXM3 sy-vline 
WA_KOMLKGN_STR-TAXM4 sy-vline 
WA_KOMLKGN_STR-TAXM5 sy-vline 
WA_KOMLKGN_STR-TAXM6 sy-vline 
WA_KOMLKGN_STR-TAXM7 sy-vline 
WA_KOMLKGN_STR-TAXM8 sy-vline 
WA_KOMLKGN_STR-TAXM9 sy-vline 
WA_KOMLKGN_STR-KOWRR sy-vline 
WA_KOMLKGN_STR-PRSFD sy-vline 
WA_KOMLKGN_STR-KOSTL sy-vline 
WA_KOMLKGN_STR-STAFO sy-vline 
WA_KOMLKGN_STR-WAVWR sy-vline 
WA_KOMLKGN_STR-KZWI1 sy-vline 
WA_KOMLKGN_STR-KZWI2 sy-vline 
WA_KOMLKGN_STR-KZWI3 sy-vline 
WA_KOMLKGN_STR-KZWI4 sy-vline 
WA_KOMLKGN_STR-KZWI5 sy-vline 
WA_KOMLKGN_STR-KZWI6 sy-vline 
WA_KOMLKGN_STR-STCUR sy-vline 
WA_KOMLKGN_STR-UVPRS sy-vline 
WA_KOMLKGN_STR-UVALL sy-vline 
WA_KOMLKGN_STR-PRCTR sy-vline 
WA_KOMLKGN_STR-KOKRS sy-vline 
WA_KOMLKGN_STR-PAOBJNR sy-vline 
WA_KOMLKGN_STR-PS_PSP_PNR sy-vline 
WA_KOMLKGN_STR-TXJCD sy-vline 
WA_KOMLKGN_STR-XBEZPOS sy-vline 
WA_KOMLKGN_STR-KNDGRUPPE sy-vline 
WA_KOMLKGN_STR-NACHLFNGNR sy-vline 
WA_KOMLKGN_STR-LFNGNR sy-vline 
WA_KOMLKGN_STR-GP_ERS_ART sy-vline 
WA_KOMLKGN_STR-VERSANDDAT sy-vline 
WA_KOMLKGN_STR-TRAGEZ sy-vline 
WA_KOMLKGN_STR-BEZTYP sy-vline 
WA_KOMLKGN_STR-DRUTAT sy-vline 
WA_KOMLKGN_STR-DRUART sy-vline 
WA_KOMLKGN_STR-PVATAT sy-vline 
WA_KOMLKGN_STR-NORMZG sy-vline 
WA_KOMLKGN_STR-NORMZU sy-vline 
WA_KOMLKGN_STR-WRBMZG sy-vline 
WA_KOMLKGN_STR-WRBMZU sy-vline 
WA_KOMLKGN_STR-NORMDZ sy-vline 
WA_KOMLKGN_STR-NORMDG sy-vline 
WA_KOMLKGN_STR-BEZTAT sy-vline 
WA_KOMLKGN_STR-BEZRTA sy-vline 
WA_KOMLKGN_STR-LFATAT sy-vline 
WA_KOMLKGN_STR-XSCHLGELD sy-vline 
WA_KOMLKGN_STR-XWEGGLDNT sy-vline 
WA_KOMLKGN_STR-XWEGGLDFG sy-vline 
WA_KOMLKGN_STR-XWEGGLDFN sy-vline 
WA_KOMLKGN_STR-XWGGELDPA sy-vline 
WA_KOMLKGN_STR-XFARGLDNT sy-vline 
WA_KOMLKGN_STR-XFARGLDFG sy-vline 
WA_KOMLKGN_STR-XFARGLDFN sy-vline 
WA_KOMLKGN_STR-XFAHRGELD sy-vline 
WA_KOMLKGN_STR-XBEILZUNT sy-vline 
WA_KOMLKGN_STR-XBEILZUFG sy-vline 
WA_KOMLKGN_STR-XBEILZUFN sy-vline 
WA_KOMLKGN_STR-XGEWIZUNT sy-vline 
WA_KOMLKGN_STR-XGEWIZUFG sy-vline 
WA_KOMLKGN_STR-XGEWIZUFN sy-vline 
WA_KOMLKGN_STR-KTFEIERFG sy-vline 
WA_KOMLKGN_STR-KTFEIERFN sy-vline 
WA_KOMLKGN_STR-KTNACHTNT sy-vline 
WA_KOMLKGN_STR-KTNACHTFG sy-vline 
WA_KOMLKGN_STR-KTNACHTFN sy-vline 
WA_KOMLKGN_STR-KTSONN_NT sy-vline 
WA_KOMLKGN_STR-KTSONN_FG sy-vline 
WA_KOMLKGN_STR-KTSONN_FN sy-vline 
WA_KOMLKGN_STR-KTSLGD sy-vline 
WA_KOMLKGN_STR-KTWEGD sy-vline 
WA_KOMLKGN_STR-KTFAGD sy-vline 
WA_KOMLKGN_STR-KTTOPO sy-vline 
WA_KOMLKGN_STR-KTTRAG sy-vline 
WA_KOMLKGN_STR-BEZKT1 sy-vline 
WA_KOMLKGN_STR-BEZKT2 sy-vline 
WA_KOMLKGN_STR-BEZKT3 sy-vline 
WA_KOMLKGN_STR-BEZKT4 sy-vline 
WA_KOMLKGN_STR-BEZKT5 sy-vline 
WA_KOMLKGN_STR-GEWTVA sy-vline 
WA_KOMLKGN_STR-GEWBEI sy-vline 
WA_KOMLKGN_STR-GESGEW sy-vline 
WA_KOMLKGN_STR-ANZBEI sy-vline 
WA_KOMLKGN_STR-MEINHG sy-vline 
WA_KOMLKGN_STR-XFEIERTAG sy-vline 
WA_KOMLKGN_STR-WOTAG_N sy-vline 
WA_KOMLKGN_STR-WOTAG_A sy-vline 
WA_KOMLKGN_STR-XVERGPVAST sy-vline 
WA_KOMLKGN_STR-XVERGPVAPE sy-vline 
WA_KOMLKGN_STR-XVERGPVATD sy-vline 
WA_KOMLKGN_STR-XVERGPVADU sy-vline 
WA_KOMLKGN_STR-XVERGBEZPA sy-vline 
WA_KOMLKGN_STR-DRERZ sy-vline 
WA_KOMLKGN_STR-PVA sy-vline 
WA_KOMLKGN_STR-BZPERF sy-vline 
WA_KOMLKGN_STR-WRBART sy-vline 
WA_KOMLKGN_STR-WRBAKT sy-vline 
WA_KOMLKGN_STR-MINBEZ sy-vline 
WA_KOMLKGN_STR-MINEIN sy-vline 
WA_KOMLKGN_STR-XWKZ sy-vline 
WA_KOMLKGN_STR-POART sy-vline 
WA_KOMLKGN_STR-XEINML sy-vline 
WA_KOMLKGN_STR-XRENDI sy-vline 
WA_KOMLKGN_STR-XPATE sy-vline 
WA_KOMLKGN_STR-XFBLGABR sy-vline 
WA_KOMLKGN_STR-ZLSCH sy-vline 
WA_KOMLKGN_STR-VTWEG sy-vline 
WA_KOMLKGN_STR-SPART sy-vline 
WA_KOMLKGN_STR-GPAG sy-vline 
WA_KOMLKGN_STR-GPRG sy-vline 
WA_KOMLKGN_STR-BSTDK sy-vline 
WA_KOMLKGN_STR-VBELN sy-vline 
WA_KOMLKGN_STR-POSNR sy-vline 
WA_KOMLKGN_STR-POSEX sy-vline 
WA_KOMLKGN_STR-ETENR sy-vline 
WA_KOMLKGN_STR-GUELTIGVON sy-vline 
WA_KOMLKGN_STR-RECHBEGINN sy-vline 
WA_KOMLKGN_STR-XIMMAT sy-vline 
WA_KOMLKGN_STR-FXMSG sy-vline 
WA_KOMLKGN_STR-JSNABR sy-vline 
WA_KOMLKGN_STR-FKDAT sy-vline 
WA_KOMLKGN_STR-FAKVON sy-vline 
WA_KOMLKGN_STR-FAKBIS sy-vline 
WA_KOMLKGN_STR-OBJART_V sy-vline 
WA_KOMLKGN_STR-UEBERLART sy-vline 
WA_KOMLKGN_STR-KONDA sy-vline 
WA_KOMLKGN_STR-ABRPOS sy-vline 
WA_KOMLKGN_STR-MONBEW sy-vline 
WA_KOMLKGN_STR-SHKZG sy-vline 
WA_KOMLKGN_STR-ANZMONABRE sy-vline 
WA_KOMLKGN_STR-XPROVRUECK sy-vline 
WA_KOMLKGN_STR-PERNR sy-vline 
WA_KOMLKGN_STR-JPROVKDAT sy-vline 
WA_KOMLKGN_STR-ANZET sy-vline 
WA_KOMLKGN_STR-XJSIF sy-vline 
WA_KOMLKGN_STR-XINDART sy-vline 
WA_KOMLKGN_STR-PROVRART sy-vline 
WA_KOMLKGN_STR-DUMMY sy-vline 
WA_KOMLKGN_STR-WERBKZSCHL sy-vline 
WA_KOMLKGN_STR-XNEGOP sy-vline 
WA_KOMLKGN_STR-FKPER sy-vline 
WA_KOMLKGN_STR-ZUSTTYP sy-vline 
WA_KOMLKGN_STR-KTGRD_MA sy-vline 
WA_KOMLKGN_STR-KTGRDVSG sy-vline 
WA_KOMLKGN_STR-WRBMDZ sy-vline 
WA_KOMLKGN_STR-WRBMDG sy-vline 
WA_KOMLKGN_STR-VKORG sy-vline 
WA_KOMLKGN_STR-FAHRKM sy-vline 
WA_KOMLKGN_STR-EFAHRK sy-vline 
WA_KOMLKGN_STR-BBEWRT sy-vline 
WA_KOMLKGN_STR-VERKMITART sy-vline 
WA_KOMLKGN_STR-TAET_KLASS sy-vline 
WA_KOMLKGN_STR-VORGAENGER sy-vline 
WA_KOMLKGN_STR-NACHFOLGER sy-vline 
WA_KOMLKGN_STR-DRERZTRAEG sy-vline 
WA_KOMLKGN_STR-PVATRAEG sy-vline 
WA_KOMLKGN_STR-VERTYP sy-vline 
WA_KOMLKGN_STR-VAUSGB sy-vline 
WA_KOMLKGN_STR-PROMNR sy-vline 
WA_KOMLKGN_STR-PROVPERCNT sy-vline 
WA_KOMLKGN_STR-EVENT sy-vline 
WA_KOMLKGN_STR-XAQUISITION sy-vline 
WA_KOMLKGN_STR-VKONT sy-vline 
WA_KOMLKGN_STR-MATNR sy-vline 
WA_KOMLKGN_STR-MONNRCOMPL sy-vline 
WA_KOMLKGN_STR-MONFACTOR sy-vline 
WA_KOMLKGN_STR-TUENRCOMPL sy-vline 
WA_KOMLKGN_STR-TUEFACTOR sy-vline 
WA_KOMLKGN_STR-WEDNRCOMPL sy-vline 
WA_KOMLKGN_STR-WEDFACTOR sy-vline 
WA_KOMLKGN_STR-THUNRCOMPL sy-vline 
WA_KOMLKGN_STR-THUFACTOR sy-vline 
WA_KOMLKGN_STR-FRINRCOMPL sy-vline 
WA_KOMLKGN_STR-FRIFACTOR sy-vline 
WA_KOMLKGN_STR-SATNRCOMPL sy-vline 
WA_KOMLKGN_STR-SATFACTOR sy-vline 
WA_KOMLKGN_STR-SUNNRCOMPL sy-vline 
WA_KOMLKGN_STR-SUNFACTOR sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.