ABAP Select data from SAP table RNLE1 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 RNLE1 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 RNLE1. 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 RNLE1 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_RNLE1 TYPE STANDARD TABLE OF RNLE1,
      WA_RNLE1 TYPE RNLE1,
      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: <RNLE1> TYPE RNLE1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RNLE1
*  INTO TABLE @DATA(IT_RNLE12).
*--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_RNLE1 INDEX 1 INTO DATA(WA_RNLE12).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RNLE1>-EINRI = 1.
<RNLE1>-FALNR = 1.
<RNLE1>-ORGID = 1.
<RNLE1>-LEIST = 1.
<RNLE1>-LNRLS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RNLE1-POSNR, sy-vline,
  WA_RNLE1-BELNR, sy-vline,
  WA_RNLE1-LINNR, sy-vline,
  WA_RNLE1-LFDBEW, sy-vline,
  WA_RNLE1-REFBEW, sy-vline,
  WA_RNLE1-ABART, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RNLE1 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_RNLE1 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_RNLE1 INTO WA_RNLE1.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field CONSVA
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RNLE1-CONSVA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RNLE1-CONSVA.
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_RNLE1_STR, 
EINRI TYPE STRING,
FALNR TYPE STRING,
ORGID TYPE STRING,
LEIST TYPE STRING,
LNRLS TYPE STRING,
POSNR TYPE STRING,
BELNR TYPE STRING,
LINNR TYPE STRING,
LFDBEW TYPE STRING,
REFBEW TYPE STRING,
ABART TYPE STRING,
ABGDT TYPE STRING,
ABLST TYPE STRING,
ABRKZ TYPE STRING,
ABRMA TYPE STRING,
ABTAR TYPE STRING,
ABTEX TYPE STRING,
ABTXT TYPE STRING,
ABTYP TYPE STRING,
ABGER TYPE STRING,
ABRLS TYPE STRING,
ANART TYPE STRING,
ANFOE TYPE STRING,
ANMAN TYPE STRING,
ANZOP TYPE STRING,
AOKURZ TYPE STRING,
AORGKB TYPE STRING,
ANPOE TYPE STRING,
APMAN TYPE STRING,
APOEKB TYPE STRING,
BEGDT TYPE STRING,
BEGZT TYPE STRING,
BEGTX TYPE STRING,
BEGKZ TYPE STRING,
BFORM TYPE STRING,
BSTAT TYPE STRING,
BZLST TYPE STRING,
DISP TYPE STRING,
DBTRAG TYPE STRING,
DMENGE TYPE STRING,
DPREIS TYPE STRING,
EILST TYPE STRING,
EITAR TYPE STRING,
ENDLS TYPE STRING,
ENDDT TYPE STRING,
ENDZT TYPE STRING,
ENTKY TYPE STRING,
ENZKY TYPE STRING,
ENTGA TYPE STRING,
ENTG2 TYPE STRING,
EOKURZ TYPE STRING,
EORGKB TYPE STRING,
ERBOE TYPE STRING,
ERBTY TYPE STRING,
ERMAN TYPE STRING,
ERROR TYPE STRING,
ERDAT TYPE STRING,
ERUSR TYPE STRING,
ERGZT TYPE STRING,
EVENT TYPE STRING,
EVTUP TYPE STRING,
EXCAT TYPE STRING,
GBTRAG TYPE STRING,
GMENGE TYPE STRING,
GPREIS TYPE STRING,
HAUST TYPE STRING,
HCOKZ TYPE STRING,
IDBKZ TYPE STRING,
ICDKT TYPE STRING,
ICDKY TYPE STRING,
ICPMK TYPE STRING,
ICPML TYPE STRING,
ICPHC TYPE STRING,
IDENT TYPE STRING,
KBTRAG TYPE STRING,
KMENGE TYPE STRING,
KPREIS TYPE STRING,
KPROZ TYPE STRING,
KOSTR TYPE STRING,
KTNAM TYPE STRING,
KTXT1 TYPE STRING,
KTXT2 TYPE STRING,
KTRKZ TYPE STRING,
KUEST TYPE STRING,
LEBIS TYPE STRING,
LEIID TYPE STRING,
LEINH TYPE STRING,
LEITX TYPE STRING,
LEITX2 TYPE STRING,
LEVON TYPE STRING,
LFDNR TYPE STRING,
LGTXT TYPE STRING,
LNRDYN TYPE STRING,
LNRDI TYPE STRING,
LNRKI TYPE STRING,
LOEKZ TYPE STRING,
LSLOK TYPE STRING,
MANDT TYPE STRING,
MARK TYPE STRING,
MATNR TYPE STRING,
MDIND TYPE STRING,
MENGE TYPE STRING,
MODIFY TYPE STRING,
MSGLI TYPE STRING,
NLEI TYPE STRING,
NLEIST TYPE STRING,
NLSLOK TYPE STRING,
NKUA TYPE STRING,
NOCHG TYPE STRING,
NBGDT TYPE STRING,
NBGZT TYPE STRING,
OBJCT TYPE STRING,
OBJUP TYPE STRING,
POSTX TYPE STRING,
PREIS TYPE STRING,
PRLST TYPE STRING,
PRPRZ TYPE STRING,
PSTAT TYPE STRING,
PTEXT TYPE STRING,
PTAMP TYPE STRING,
PZAHL TYPE STRING,
PZUSG TYPE STRING,
REFLNR TYPE STRING,
REST TYPE STRING,
SEKZ TYPE STRING,
SEQUE TYPE STRING,
STALS TYPE STRING,
STDAT TYPE STRING,
STORN TYPE STRING,
STUSR TYPE STRING,
TAGRU TYPE STRING,
TARID TYPE STRING,
TARIF TYPE STRING,
TARLS TYPE STRING,
TARSP TYPE STRING,
TARAS TYPE STRING,
TAXKL TYPE STRING,
TBTRAG TYPE STRING,
TGRKZ TYPE STRING,
UEBAB TYPE STRING,
UPDAT TYPE STRING,
UPUSR TYPE STRING,
VCODE TYPE STRING,
VERKZ TYPE STRING,
VOREINST TYPE STRING,
WAERS TYPE STRING,
WEGEL TYPE STRING,
ZEITR TYPE STRING,
WNDNR TYPE STRING,
REMRK TYPE STRING,
REMKZ TYPE STRING,
REFKY TYPE STRING,
REFNR TYPE STRING,
KZBCP TYPE STRING,
BILLP TYPE STRING,
REFKU TYPE STRING,
USER0 TYPE STRING,
USER1 TYPE STRING,
USER2 TYPE STRING,
USERDATE1 TYPE STRING,
USERDATE2 TYPE STRING,
USERTIME1 TYPE STRING,
USERTIME2 TYPE STRING,
USERPRICE1 TYPE STRING,
USERAMOUNT1 TYPE STRING,
USERUNIT1 TYPE STRING,
USERSIGN1 TYPE STRING,
USERSIGN2 TYPE STRING,
USERTEXT1 TYPE STRING,
VIEWTYPE TYPE STRING,
FORMNAME TYPE STRING,
FORMBELNR TYPE STRING,
ZOTYP TYPE STRING,
BGMAN TYPE STRING,
EDMAN TYPE STRING,
FIX TYPE STRING,
CONVSIGN TYPE STRING,
LNRLM TYPE STRING,
NLKZA TYPE STRING,
ZMID1 TYPE STRING,
ZMDA1 TYPE STRING,
ZMTI1 TYPE STRING,
ZMAN1 TYPE STRING,
ZMEH1 TYPE STRING,
LSTZ1 TYPE STRING,
LSTZ2 TYPE STRING,
MEDUNIT TYPE STRING,
WISSCD TYPE STRING,
BEAG TYPE STRING,
LABTYP TYPE STRING,
ASSTP TYPE STRING,
KZPRF TYPE STRING,
KZEAH TYPE STRING,
KZEXT TYPE STRING,
DBCNR TYPE STRING,
/ISHFR/AKTIV TYPE STRING,
/ISHFR/PHASE TYPE STRING,
/ISHFR/MOD_CD1 TYPE STRING,
/ISHFR/MOD_CD2 TYPE STRING,
/ISHFR/MOD_CD3 TYPE STRING,
/ISHFR/MOD_CD4 TYPE STRING,
/ISHFR/KOE_SV TYPE STRING,
/ISHFR/PRSC_DT TYPE STRING,
/ISHFR/ASS_CD TYPE STRING,
/ISHFR/PUR_PR TYPE STRING,
/ISHFR/EXO_CP TYPE STRING,
/ISHFR/NABM_CO TYPE STRING,
/ISHFR/HOPRICE TYPE STRING,
/ISHFR/PSCRV TYPE STRING,
HIC_FREE TYPE STRING,
DEVNR TYPE STRING,
ORDNR TYPE STRING,
IVFACT TYPE STRING,
DCODE TYPE STRING,
CONSVA TYPE STRING,
LAAMB TYPE STRING,
LSCHL TYPE STRING,
ABRTX TYPE STRING,
ENTGAMB TYPE STRING,
THERGROUP TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RNLE1_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_RNLE1_STR-EINRI sy-vline 
WA_RNLE1_STR-FALNR sy-vline 
WA_RNLE1_STR-ORGID sy-vline 
WA_RNLE1_STR-LEIST sy-vline 
WA_RNLE1_STR-LNRLS sy-vline 
WA_RNLE1_STR-POSNR sy-vline 
WA_RNLE1_STR-BELNR sy-vline 
WA_RNLE1_STR-LINNR sy-vline 
WA_RNLE1_STR-LFDBEW sy-vline 
WA_RNLE1_STR-REFBEW sy-vline 
WA_RNLE1_STR-ABART sy-vline 
WA_RNLE1_STR-ABGDT sy-vline 
WA_RNLE1_STR-ABLST sy-vline 
WA_RNLE1_STR-ABRKZ sy-vline 
WA_RNLE1_STR-ABRMA sy-vline 
WA_RNLE1_STR-ABTAR sy-vline 
WA_RNLE1_STR-ABTEX sy-vline 
WA_RNLE1_STR-ABTXT sy-vline 
WA_RNLE1_STR-ABTYP sy-vline 
WA_RNLE1_STR-ABGER sy-vline 
WA_RNLE1_STR-ABRLS sy-vline 
WA_RNLE1_STR-ANART sy-vline 
WA_RNLE1_STR-ANFOE sy-vline 
WA_RNLE1_STR-ANMAN sy-vline 
WA_RNLE1_STR-ANZOP sy-vline 
WA_RNLE1_STR-AOKURZ sy-vline 
WA_RNLE1_STR-AORGKB sy-vline 
WA_RNLE1_STR-ANPOE sy-vline 
WA_RNLE1_STR-APMAN sy-vline 
WA_RNLE1_STR-APOEKB sy-vline 
WA_RNLE1_STR-BEGDT sy-vline 
WA_RNLE1_STR-BEGZT sy-vline 
WA_RNLE1_STR-BEGTX sy-vline 
WA_RNLE1_STR-BEGKZ sy-vline 
WA_RNLE1_STR-BFORM sy-vline 
WA_RNLE1_STR-BSTAT sy-vline 
WA_RNLE1_STR-BZLST sy-vline 
WA_RNLE1_STR-DISP sy-vline 
WA_RNLE1_STR-DBTRAG sy-vline 
WA_RNLE1_STR-DMENGE sy-vline 
WA_RNLE1_STR-DPREIS sy-vline 
WA_RNLE1_STR-EILST sy-vline 
WA_RNLE1_STR-EITAR sy-vline 
WA_RNLE1_STR-ENDLS sy-vline 
WA_RNLE1_STR-ENDDT sy-vline 
WA_RNLE1_STR-ENDZT sy-vline 
WA_RNLE1_STR-ENTKY sy-vline 
WA_RNLE1_STR-ENZKY sy-vline 
WA_RNLE1_STR-ENTGA sy-vline 
WA_RNLE1_STR-ENTG2 sy-vline 
WA_RNLE1_STR-EOKURZ sy-vline 
WA_RNLE1_STR-EORGKB sy-vline 
WA_RNLE1_STR-ERBOE sy-vline 
WA_RNLE1_STR-ERBTY sy-vline 
WA_RNLE1_STR-ERMAN sy-vline 
WA_RNLE1_STR-ERROR sy-vline 
WA_RNLE1_STR-ERDAT sy-vline 
WA_RNLE1_STR-ERUSR sy-vline 
WA_RNLE1_STR-ERGZT sy-vline 
WA_RNLE1_STR-EVENT sy-vline 
WA_RNLE1_STR-EVTUP sy-vline 
WA_RNLE1_STR-EXCAT sy-vline 
WA_RNLE1_STR-GBTRAG sy-vline 
WA_RNLE1_STR-GMENGE sy-vline 
WA_RNLE1_STR-GPREIS sy-vline 
WA_RNLE1_STR-HAUST sy-vline 
WA_RNLE1_STR-HCOKZ sy-vline 
WA_RNLE1_STR-IDBKZ sy-vline 
WA_RNLE1_STR-ICDKT sy-vline 
WA_RNLE1_STR-ICDKY sy-vline 
WA_RNLE1_STR-ICPMK sy-vline 
WA_RNLE1_STR-ICPML sy-vline 
WA_RNLE1_STR-ICPHC sy-vline 
WA_RNLE1_STR-IDENT sy-vline 
WA_RNLE1_STR-KBTRAG sy-vline 
WA_RNLE1_STR-KMENGE sy-vline 
WA_RNLE1_STR-KPREIS sy-vline 
WA_RNLE1_STR-KPROZ sy-vline 
WA_RNLE1_STR-KOSTR sy-vline 
WA_RNLE1_STR-KTNAM sy-vline 
WA_RNLE1_STR-KTXT1 sy-vline 
WA_RNLE1_STR-KTXT2 sy-vline 
WA_RNLE1_STR-KTRKZ sy-vline 
WA_RNLE1_STR-KUEST sy-vline 
WA_RNLE1_STR-LEBIS sy-vline 
WA_RNLE1_STR-LEIID sy-vline 
WA_RNLE1_STR-LEINH sy-vline 
WA_RNLE1_STR-LEITX sy-vline 
WA_RNLE1_STR-LEITX2 sy-vline 
WA_RNLE1_STR-LEVON sy-vline 
WA_RNLE1_STR-LFDNR sy-vline 
WA_RNLE1_STR-LGTXT sy-vline 
WA_RNLE1_STR-LNRDYN sy-vline 
WA_RNLE1_STR-LNRDI sy-vline 
WA_RNLE1_STR-LNRKI sy-vline 
WA_RNLE1_STR-LOEKZ sy-vline 
WA_RNLE1_STR-LSLOK sy-vline 
WA_RNLE1_STR-MANDT sy-vline 
WA_RNLE1_STR-MARK sy-vline 
WA_RNLE1_STR-MATNR sy-vline 
WA_RNLE1_STR-MDIND sy-vline 
WA_RNLE1_STR-MENGE sy-vline 
WA_RNLE1_STR-MODIFY sy-vline 
WA_RNLE1_STR-MSGLI sy-vline 
WA_RNLE1_STR-NLEI sy-vline 
WA_RNLE1_STR-NLEIST sy-vline 
WA_RNLE1_STR-NLSLOK sy-vline 
WA_RNLE1_STR-NKUA sy-vline 
WA_RNLE1_STR-NOCHG sy-vline 
WA_RNLE1_STR-NBGDT sy-vline 
WA_RNLE1_STR-NBGZT sy-vline 
WA_RNLE1_STR-OBJCT sy-vline 
WA_RNLE1_STR-OBJUP sy-vline 
WA_RNLE1_STR-POSTX sy-vline 
WA_RNLE1_STR-PREIS sy-vline 
WA_RNLE1_STR-PRLST sy-vline 
WA_RNLE1_STR-PRPRZ sy-vline 
WA_RNLE1_STR-PSTAT sy-vline 
WA_RNLE1_STR-PTEXT sy-vline 
WA_RNLE1_STR-PTAMP sy-vline 
WA_RNLE1_STR-PZAHL sy-vline 
WA_RNLE1_STR-PZUSG sy-vline 
WA_RNLE1_STR-REFLNR sy-vline 
WA_RNLE1_STR-REST sy-vline 
WA_RNLE1_STR-SEKZ sy-vline 
WA_RNLE1_STR-SEQUE sy-vline 
WA_RNLE1_STR-STALS sy-vline 
WA_RNLE1_STR-STDAT sy-vline 
WA_RNLE1_STR-STORN sy-vline 
WA_RNLE1_STR-STUSR sy-vline 
WA_RNLE1_STR-TAGRU sy-vline 
WA_RNLE1_STR-TARID sy-vline 
WA_RNLE1_STR-TARIF sy-vline 
WA_RNLE1_STR-TARLS sy-vline 
WA_RNLE1_STR-TARSP sy-vline 
WA_RNLE1_STR-TARAS sy-vline 
WA_RNLE1_STR-TAXKL sy-vline 
WA_RNLE1_STR-TBTRAG sy-vline 
WA_RNLE1_STR-TGRKZ sy-vline 
WA_RNLE1_STR-UEBAB sy-vline 
WA_RNLE1_STR-UPDAT sy-vline 
WA_RNLE1_STR-UPUSR sy-vline 
WA_RNLE1_STR-VCODE sy-vline 
WA_RNLE1_STR-VERKZ sy-vline 
WA_RNLE1_STR-VOREINST sy-vline 
WA_RNLE1_STR-WAERS sy-vline 
WA_RNLE1_STR-WEGEL sy-vline 
WA_RNLE1_STR-ZEITR sy-vline 
WA_RNLE1_STR-WNDNR sy-vline 
WA_RNLE1_STR-REMRK sy-vline 
WA_RNLE1_STR-REMKZ sy-vline 
WA_RNLE1_STR-REFKY sy-vline 
WA_RNLE1_STR-REFNR sy-vline 
WA_RNLE1_STR-KZBCP sy-vline 
WA_RNLE1_STR-BILLP sy-vline 
WA_RNLE1_STR-REFKU sy-vline 
WA_RNLE1_STR-USER0 sy-vline 
WA_RNLE1_STR-USER1 sy-vline 
WA_RNLE1_STR-USER2 sy-vline 
WA_RNLE1_STR-USERDATE1 sy-vline 
WA_RNLE1_STR-USERDATE2 sy-vline 
WA_RNLE1_STR-USERTIME1 sy-vline 
WA_RNLE1_STR-USERTIME2 sy-vline 
WA_RNLE1_STR-USERPRICE1 sy-vline 
WA_RNLE1_STR-USERAMOUNT1 sy-vline 
WA_RNLE1_STR-USERUNIT1 sy-vline 
WA_RNLE1_STR-USERSIGN1 sy-vline 
WA_RNLE1_STR-USERSIGN2 sy-vline 
WA_RNLE1_STR-USERTEXT1 sy-vline 
WA_RNLE1_STR-VIEWTYPE sy-vline 
WA_RNLE1_STR-FORMNAME sy-vline 
WA_RNLE1_STR-FORMBELNR sy-vline 
WA_RNLE1_STR-ZOTYP sy-vline 
WA_RNLE1_STR-BGMAN sy-vline 
WA_RNLE1_STR-EDMAN sy-vline 
WA_RNLE1_STR-FIX sy-vline 
WA_RNLE1_STR-CONVSIGN sy-vline 
WA_RNLE1_STR-LNRLM sy-vline 
WA_RNLE1_STR-NLKZA sy-vline 
WA_RNLE1_STR-ZMID1 sy-vline 
WA_RNLE1_STR-ZMDA1 sy-vline 
WA_RNLE1_STR-ZMTI1 sy-vline 
WA_RNLE1_STR-ZMAN1 sy-vline 
WA_RNLE1_STR-ZMEH1 sy-vline 
WA_RNLE1_STR-LSTZ1 sy-vline 
WA_RNLE1_STR-LSTZ2 sy-vline 
WA_RNLE1_STR-MEDUNIT sy-vline 
WA_RNLE1_STR-WISSCD sy-vline 
WA_RNLE1_STR-BEAG sy-vline 
WA_RNLE1_STR-LABTYP sy-vline 
WA_RNLE1_STR-ASSTP sy-vline 
WA_RNLE1_STR-KZPRF sy-vline 
WA_RNLE1_STR-KZEAH sy-vline 
WA_RNLE1_STR-KZEXT sy-vline 
WA_RNLE1_STR-DBCNR sy-vline 
WA_RNLE1_STR-/ISHFR/AKTIV sy-vline 
WA_RNLE1_STR-/ISHFR/PHASE sy-vline 
WA_RNLE1_STR-/ISHFR/MOD_CD1 sy-vline 
WA_RNLE1_STR-/ISHFR/MOD_CD2 sy-vline 
WA_RNLE1_STR-/ISHFR/MOD_CD3 sy-vline 
WA_RNLE1_STR-/ISHFR/MOD_CD4 sy-vline 
WA_RNLE1_STR-/ISHFR/KOE_SV sy-vline 
WA_RNLE1_STR-/ISHFR/PRSC_DT sy-vline 
WA_RNLE1_STR-/ISHFR/ASS_CD sy-vline 
WA_RNLE1_STR-/ISHFR/PUR_PR sy-vline 
WA_RNLE1_STR-/ISHFR/EXO_CP sy-vline 
WA_RNLE1_STR-/ISHFR/NABM_CO sy-vline 
WA_RNLE1_STR-/ISHFR/HOPRICE sy-vline 
WA_RNLE1_STR-/ISHFR/PSCRV sy-vline 
WA_RNLE1_STR-HIC_FREE sy-vline 
WA_RNLE1_STR-DEVNR sy-vline 
WA_RNLE1_STR-ORDNR sy-vline 
WA_RNLE1_STR-IVFACT sy-vline 
WA_RNLE1_STR-DCODE sy-vline 
WA_RNLE1_STR-CONSVA sy-vline 
WA_RNLE1_STR-LAAMB sy-vline 
WA_RNLE1_STR-LSCHL sy-vline 
WA_RNLE1_STR-ABRTX sy-vline 
WA_RNLE1_STR-ENTGAMB sy-vline 
WA_RNLE1_STR-THERGROUP sy-vline      INTO ld_text SEPARATED BY SPACE.

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