ABAP Select data from SAP table RNF18 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 RNF18 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 RNF18. 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 RNF18 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_RNF18 TYPE STANDARD TABLE OF RNF18,
      WA_RNF18 TYPE RNF18,
      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: <RNF18> TYPE RNF18.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RNF18
*  INTO TABLE @DATA(IT_RNF182).
*--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_RNF18 INDEX 1 INTO DATA(WA_RNF182).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RNF18>-FALNR = 1.
<RNF18>-AUFDT = 1.
<RNF18>-AUFZT = 1.
<RNF18>-ENTDT = 1.
<RNF18>-ENTZT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RNF18-AUFOFAKB, sy-vline,
  WA_RNF18-AUFOPFKB, sy-vline,
  WA_RNF18-ORGFA, sy-vline,
  WA_RNF18-ORGPF, sy-vline,
  WA_RNF18-AUFBWART, sy-vline,
  WA_RNF18-AUFBWATX, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RNF18 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_RNF18 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_RNF18 INTO WA_RNF18.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit NLJUS, internal->external for field PASSNR
CALL FUNCTION 'CONVERSION_EXIT_NLJUS_OUTPUT'
  EXPORTING
    input =                      WA_RNF18-PASSNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RNF18-PASSNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field NARNR_A
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RNF18-NARNR_A
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RNF18-NARNR_A.
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_RNF18_STR, 
FALNR TYPE STRING,
AUFDT TYPE STRING,
AUFZT TYPE STRING,
ENTDT TYPE STRING,
ENTZT TYPE STRING,
AUFOFAKB TYPE STRING,
AUFOPFKB TYPE STRING,
ORGFA TYPE STRING,
ORGPF TYPE STRING,
AUFBWART TYPE STRING,
AUFBWATX TYPE STRING,
ENTBWART TYPE STRING,
ENTBWATX TYPE STRING,
ENTOFAKB TYPE STRING,
ENTOPFKB TYPE STRING,
ENTORGFA TYPE STRING,
ENTORGPF TYPE STRING,
ENTBWGR1 TYPE STRING,
CONCATPAT TYPE STRING,
FZIFF TYPE STRING,
FPEDT TYPE STRING,
TOB TYPE STRING,
CONSENT TYPE STRING,
EINDKAT TYPE STRING,
EINDKEY1 TYPE STRING,
EINDIKTXT TYPE STRING,
EINDIKTX2 TYPE STRING,
EINDITXT TYPE STRING,
EINDLO TYPE STRING,
EINDGW TYPE STRING,
EINDTYP TYPE STRING,
AUFDKAT TYPE STRING,
AUFDKEY TYPE STRING,
AUFDIKTXT TYPE STRING,
AUFDIKTX2 TYPE STRING,
AUFDITXT TYPE STRING,
AUFDLO TYPE STRING,
AUFDGW TYPE STRING,
AUFDTYP TYPE STRING,
EINRDKAT TYPE STRING,
EINRDKEY TYPE STRING,
EINRDIKTXT TYPE STRING,
EINRDIKTX2 TYPE STRING,
EINRDTYP TYPE STRING,
AUFRDKAT TYPE STRING,
AUFRDKEY TYPE STRING,
AUFRDIKTXT TYPE STRING,
AUFRDIKTX2 TYPE STRING,
AUFRDTYP TYPE STRING,
EIN2DKAT TYPE STRING,
EIN2DKEY1 TYPE STRING,
EIN2DIKTXT TYPE STRING,
EIN2DIKTX2 TYPE STRING,
EIN2DITXT TYPE STRING,
EIN2DLO TYPE STRING,
EIN2DGW TYPE STRING,
EIN2DTYP TYPE STRING,
AUF2DKAT TYPE STRING,
AUF2DKEY TYPE STRING,
AUF2DIKTXT TYPE STRING,
AUF2DIKTX2 TYPE STRING,
AUF2DITXT TYPE STRING,
AUF2DLO TYPE STRING,
AUF2DGW TYPE STRING,
AUF2DTYP TYPE STRING,
EIN2RDKAT TYPE STRING,
EIN2RDKEY TYPE STRING,
EIN2RDKTXT TYPE STRING,
EIN2RDKTX2 TYPE STRING,
EIN2RDTYP TYPE STRING,
AUF2RDKAT TYPE STRING,
AUF2RDKEY TYPE STRING,
AUF2RDKTXT TYPE STRING,
AUF2RDKTX2 TYPE STRING,
AUF2RDTYP TYPE STRING,
ENTDKAT TYPE STRING,
ENTDKEY1 TYPE STRING,
ENTDIKTXT TYPE STRING,
ENTDIKTX2 TYPE STRING,
ENTDITXT TYPE STRING,
ENTDLO TYPE STRING,
ENTDGW TYPE STRING,
ENTDTYP TYPE STRING,
KHDDKAT TYPE STRING,
KHDDKEY TYPE STRING,
KHDDIKTXT TYPE STRING,
KHDDIKTX2 TYPE STRING,
KHDDITXT TYPE STRING,
KHDDLO TYPE STRING,
KHDDGW TYPE STRING,
KHDDTYP TYPE STRING,
ENTRDKAT TYPE STRING,
ENTRDKEY TYPE STRING,
ENTRDIKTXT TYPE STRING,
ENTRDIKTX2 TYPE STRING,
ENTRDTYP TYPE STRING,
KHDRDKAT TYPE STRING,
KHDRDKEY TYPE STRING,
KHDRDIKTXT TYPE STRING,
KHDRDIKTX2 TYPE STRING,
KHDRDTYP TYPE STRING,
ENT2DKAT TYPE STRING,
ENT2DKEY1 TYPE STRING,
ENT2DIKTXT TYPE STRING,
ENT2DIKTX2 TYPE STRING,
ENT2DITXT TYPE STRING,
ENT2DLO TYPE STRING,
ENT2DGW TYPE STRING,
ENT2DTYP TYPE STRING,
ENT2RDKAT TYPE STRING,
ENT2RDKEY TYPE STRING,
ENT2RDKTXT TYPE STRING,
ENT2RDKTX2 TYPE STRING,
ENT2RDTYP TYPE STRING,
ICBWIDT TYPE STRING,
ICBWIZT TYPE STRING,
ICBWART TYPE STRING,
ICBWATX TYPE STRING,
ICORGFA TYPE STRING,
ICFAKEY TYPE STRING,
ICORGPF TYPE STRING,
ICTARLS TYPE STRING,
ICTARLSTXT TYPE STRING,
ICPMK TYPE STRING,
ICPML TYPE STRING,
ICPTXT TYPE STRING,
ICPHC TYPE STRING,
ICDITXT TYPE STRING,
ICDKAT1 TYPE STRING,
ICDKEY1 TYPE STRING,
ICDKAT_REF TYPE STRING,
ICDKEY_REF TYPE STRING,
ICDIATXT1 TYPE STRING,
ICDIATXT2 TYPE STRING,
ICDIATXTR1 TYPE STRING,
ICDIATXTR2 TYPE STRING,
ICANZOP TYPE STRING,
ICDLO TYPE STRING,
ICDGW TYPE STRING,
ICD1TYP TYPE STRING,
ICDREFTYP TYPE STRING,
MANDT TYPE STRING,
PATNR TYPE STRING,
EINRI TYPE STRING,
GSCHL TYPE STRING,
NNAME TYPE STRING,
NNAMS TYPE STRING,
VNAME TYPE STRING,
VNAMS TYPE STRING,
TITEL TYPE STRING,
NAMZU TYPE STRING,
VORSW TYPE STRING,
NAME2 TYPE STRING,
GBDAT TYPE STRING,
GBNAM TYPE STRING,
GBNAS TYPE STRING,
GLAND TYPE STRING,
TODKZ TYPE STRING,
TODDT TYPE STRING,
TODZT TYPE STRING,
TODDB TYPE STRING,
TODZB TYPE STRING,
TODUR TYPE STRING,
ANRED TYPE STRING,
FAMST TYPE STRING,
KONFE TYPE STRING,
NATIO TYPE STRING,
SPRAS TYPE STRING,
LAND TYPE STRING,
PSTLZ TYPE STRING,
ORT TYPE STRING,
ORT2 TYPE STRING,
STRAS TYPE STRING,
BLAND TYPE STRING,
GEBIE TYPE STRING,
TELF1 TYPE STRING,
SPEND TYPE STRING,
SPENT TYPE STRING,
SPELT TYPE STRING,
VIPKZ TYPE STRING,
ARCHV TYPE STRING,
STATU TYPE STRING,
EXTNR TYPE STRING,
NOTAN TYPE STRING,
KRZAN TYPE STRING,
RFPAT TYPE STRING,
RFZIF TYPE STRING,
BERUF TYPE STRING,
AGNUM TYPE STRING,
AGNAM TYPE STRING,
AGLAN TYPE STRING,
AGPLZ TYPE STRING,
AGORT TYPE STRING,
AGSTR TYPE STRING,
AGTEL TYPE STRING,
RVNUM TYPE STRING,
ANNA1 TYPE STRING,
ANVN1 TYPE STRING,
ANLA1 TYPE STRING,
ANPL1 TYPE STRING,
ANOR1 TYPE STRING,
ANST1 TYPE STRING,
ANTE1 TYPE STRING,
ANVV1 TYPE STRING,
VMKZ1 TYPE STRING,
ANNA2 TYPE STRING,
ANVN2 TYPE STRING,
ANLA2 TYPE STRING,
ANPL2 TYPE STRING,
ANOR2 TYPE STRING,
ANST2 TYPE STRING,
ANTE2 TYPE STRING,
ANVV2 TYPE STRING,
VMKZ2 TYPE STRING,
KZTXT TYPE STRING,
LGTXT TYPE STRING,
BEGDT TYPE STRING,
ENDDT TYPE STRING,
HISTK TYPE STRING,
RISKF TYPE STRING,
TESTP TYPE STRING,
PZIFF TYPE STRING,
ERDAT TYPE STRING,
ERUSR TYPE STRING,
UPDAT TYPE STRING,
UPUSR TYPE STRING,
STORN TYPE STRING,
STUSR TYPE STRING,
STDAT TYPE STRING,
GBORT TYPE STRING,
HARNR TYPE STRING,
EARNR TYPE STRING,
UARNR TYPE STRING,
RACE TYPE STRING,
RESID TYPE STRING,
PASSTY TYPE STRING,
PASSNR TYPE STRING,
ADRNR TYPE STRING,
ADROB TYPE STRING,
ADNAG TYPE STRING,
ADOAG TYPE STRING,
ADNN1 TYPE STRING,
ADON1 TYPE STRING,
ADNN2 TYPE STRING,
ADON2 TYPE STRING,
ANEX1 TYPE STRING,
ANEX2 TYPE STRING,
ADRN2 TYPE STRING,
ADRO2 TYPE STRING,
INACT TYPE STRING,
USER1 TYPE STRING,
USER2 TYPE STRING,
USER3 TYPE STRING,
USER4 TYPE STRING,
USER5 TYPE STRING,
USER6 TYPE STRING,
EXTAUFG TYPE STRING,
EXTAUFGA TYPE STRING,
EMPSC TYPE STRING,
UNKNOWN_GBDAT TYPE STRING,
MIG_DONE TYPE STRING,
INSID TYPE STRING,
ISTAT_BPL TYPE STRING,
TAXNUM TYPE STRING,
TAXNUM_IND TYPE STRING,
STP TYPE STRING,
STP_ENDDT TYPE STRING,
CONS_PERSDATA TYPE STRING,
/ISHFR/BIRTHRK TYPE STRING,
DTH_LOC TYPE STRING,
OCCUP TYPE STRING,
NARNR_S TYPE STRING,
NARNR_A TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RNF18_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_RNF18_STR-FALNR sy-vline 
WA_RNF18_STR-AUFDT sy-vline 
WA_RNF18_STR-AUFZT sy-vline 
WA_RNF18_STR-ENTDT sy-vline 
WA_RNF18_STR-ENTZT sy-vline 
WA_RNF18_STR-AUFOFAKB sy-vline 
WA_RNF18_STR-AUFOPFKB sy-vline 
WA_RNF18_STR-ORGFA sy-vline 
WA_RNF18_STR-ORGPF sy-vline 
WA_RNF18_STR-AUFBWART sy-vline 
WA_RNF18_STR-AUFBWATX sy-vline 
WA_RNF18_STR-ENTBWART sy-vline 
WA_RNF18_STR-ENTBWATX sy-vline 
WA_RNF18_STR-ENTOFAKB sy-vline 
WA_RNF18_STR-ENTOPFKB sy-vline 
WA_RNF18_STR-ENTORGFA sy-vline 
WA_RNF18_STR-ENTORGPF sy-vline 
WA_RNF18_STR-ENTBWGR1 sy-vline 
WA_RNF18_STR-CONCATPAT sy-vline 
WA_RNF18_STR-FZIFF sy-vline 
WA_RNF18_STR-FPEDT sy-vline 
WA_RNF18_STR-TOB sy-vline 
WA_RNF18_STR-CONSENT sy-vline 
WA_RNF18_STR-EINDKAT sy-vline 
WA_RNF18_STR-EINDKEY1 sy-vline 
WA_RNF18_STR-EINDIKTXT sy-vline 
WA_RNF18_STR-EINDIKTX2 sy-vline 
WA_RNF18_STR-EINDITXT sy-vline 
WA_RNF18_STR-EINDLO sy-vline 
WA_RNF18_STR-EINDGW sy-vline 
WA_RNF18_STR-EINDTYP sy-vline 
WA_RNF18_STR-AUFDKAT sy-vline 
WA_RNF18_STR-AUFDKEY sy-vline 
WA_RNF18_STR-AUFDIKTXT sy-vline 
WA_RNF18_STR-AUFDIKTX2 sy-vline 
WA_RNF18_STR-AUFDITXT sy-vline 
WA_RNF18_STR-AUFDLO sy-vline 
WA_RNF18_STR-AUFDGW sy-vline 
WA_RNF18_STR-AUFDTYP sy-vline 
WA_RNF18_STR-EINRDKAT sy-vline 
WA_RNF18_STR-EINRDKEY sy-vline 
WA_RNF18_STR-EINRDIKTXT sy-vline 
WA_RNF18_STR-EINRDIKTX2 sy-vline 
WA_RNF18_STR-EINRDTYP sy-vline 
WA_RNF18_STR-AUFRDKAT sy-vline 
WA_RNF18_STR-AUFRDKEY sy-vline 
WA_RNF18_STR-AUFRDIKTXT sy-vline 
WA_RNF18_STR-AUFRDIKTX2 sy-vline 
WA_RNF18_STR-AUFRDTYP sy-vline 
WA_RNF18_STR-EIN2DKAT sy-vline 
WA_RNF18_STR-EIN2DKEY1 sy-vline 
WA_RNF18_STR-EIN2DIKTXT sy-vline 
WA_RNF18_STR-EIN2DIKTX2 sy-vline 
WA_RNF18_STR-EIN2DITXT sy-vline 
WA_RNF18_STR-EIN2DLO sy-vline 
WA_RNF18_STR-EIN2DGW sy-vline 
WA_RNF18_STR-EIN2DTYP sy-vline 
WA_RNF18_STR-AUF2DKAT sy-vline 
WA_RNF18_STR-AUF2DKEY sy-vline 
WA_RNF18_STR-AUF2DIKTXT sy-vline 
WA_RNF18_STR-AUF2DIKTX2 sy-vline 
WA_RNF18_STR-AUF2DITXT sy-vline 
WA_RNF18_STR-AUF2DLO sy-vline 
WA_RNF18_STR-AUF2DGW sy-vline 
WA_RNF18_STR-AUF2DTYP sy-vline 
WA_RNF18_STR-EIN2RDKAT sy-vline 
WA_RNF18_STR-EIN2RDKEY sy-vline 
WA_RNF18_STR-EIN2RDKTXT sy-vline 
WA_RNF18_STR-EIN2RDKTX2 sy-vline 
WA_RNF18_STR-EIN2RDTYP sy-vline 
WA_RNF18_STR-AUF2RDKAT sy-vline 
WA_RNF18_STR-AUF2RDKEY sy-vline 
WA_RNF18_STR-AUF2RDKTXT sy-vline 
WA_RNF18_STR-AUF2RDKTX2 sy-vline 
WA_RNF18_STR-AUF2RDTYP sy-vline 
WA_RNF18_STR-ENTDKAT sy-vline 
WA_RNF18_STR-ENTDKEY1 sy-vline 
WA_RNF18_STR-ENTDIKTXT sy-vline 
WA_RNF18_STR-ENTDIKTX2 sy-vline 
WA_RNF18_STR-ENTDITXT sy-vline 
WA_RNF18_STR-ENTDLO sy-vline 
WA_RNF18_STR-ENTDGW sy-vline 
WA_RNF18_STR-ENTDTYP sy-vline 
WA_RNF18_STR-KHDDKAT sy-vline 
WA_RNF18_STR-KHDDKEY sy-vline 
WA_RNF18_STR-KHDDIKTXT sy-vline 
WA_RNF18_STR-KHDDIKTX2 sy-vline 
WA_RNF18_STR-KHDDITXT sy-vline 
WA_RNF18_STR-KHDDLO sy-vline 
WA_RNF18_STR-KHDDGW sy-vline 
WA_RNF18_STR-KHDDTYP sy-vline 
WA_RNF18_STR-ENTRDKAT sy-vline 
WA_RNF18_STR-ENTRDKEY sy-vline 
WA_RNF18_STR-ENTRDIKTXT sy-vline 
WA_RNF18_STR-ENTRDIKTX2 sy-vline 
WA_RNF18_STR-ENTRDTYP sy-vline 
WA_RNF18_STR-KHDRDKAT sy-vline 
WA_RNF18_STR-KHDRDKEY sy-vline 
WA_RNF18_STR-KHDRDIKTXT sy-vline 
WA_RNF18_STR-KHDRDIKTX2 sy-vline 
WA_RNF18_STR-KHDRDTYP sy-vline 
WA_RNF18_STR-ENT2DKAT sy-vline 
WA_RNF18_STR-ENT2DKEY1 sy-vline 
WA_RNF18_STR-ENT2DIKTXT sy-vline 
WA_RNF18_STR-ENT2DIKTX2 sy-vline 
WA_RNF18_STR-ENT2DITXT sy-vline 
WA_RNF18_STR-ENT2DLO sy-vline 
WA_RNF18_STR-ENT2DGW sy-vline 
WA_RNF18_STR-ENT2DTYP sy-vline 
WA_RNF18_STR-ENT2RDKAT sy-vline 
WA_RNF18_STR-ENT2RDKEY sy-vline 
WA_RNF18_STR-ENT2RDKTXT sy-vline 
WA_RNF18_STR-ENT2RDKTX2 sy-vline 
WA_RNF18_STR-ENT2RDTYP sy-vline 
WA_RNF18_STR-ICBWIDT sy-vline 
WA_RNF18_STR-ICBWIZT sy-vline 
WA_RNF18_STR-ICBWART sy-vline 
WA_RNF18_STR-ICBWATX sy-vline 
WA_RNF18_STR-ICORGFA sy-vline 
WA_RNF18_STR-ICFAKEY sy-vline 
WA_RNF18_STR-ICORGPF sy-vline 
WA_RNF18_STR-ICTARLS sy-vline 
WA_RNF18_STR-ICTARLSTXT sy-vline 
WA_RNF18_STR-ICPMK sy-vline 
WA_RNF18_STR-ICPML sy-vline 
WA_RNF18_STR-ICPTXT sy-vline 
WA_RNF18_STR-ICPHC sy-vline 
WA_RNF18_STR-ICDITXT sy-vline 
WA_RNF18_STR-ICDKAT1 sy-vline 
WA_RNF18_STR-ICDKEY1 sy-vline 
WA_RNF18_STR-ICDKAT_REF sy-vline 
WA_RNF18_STR-ICDKEY_REF sy-vline 
WA_RNF18_STR-ICDIATXT1 sy-vline 
WA_RNF18_STR-ICDIATXT2 sy-vline 
WA_RNF18_STR-ICDIATXTR1 sy-vline 
WA_RNF18_STR-ICDIATXTR2 sy-vline 
WA_RNF18_STR-ICANZOP sy-vline 
WA_RNF18_STR-ICDLO sy-vline 
WA_RNF18_STR-ICDGW sy-vline 
WA_RNF18_STR-ICD1TYP sy-vline 
WA_RNF18_STR-ICDREFTYP sy-vline 
WA_RNF18_STR-MANDT sy-vline 
WA_RNF18_STR-PATNR sy-vline 
WA_RNF18_STR-EINRI sy-vline 
WA_RNF18_STR-GSCHL sy-vline 
WA_RNF18_STR-NNAME sy-vline 
WA_RNF18_STR-NNAMS sy-vline 
WA_RNF18_STR-VNAME sy-vline 
WA_RNF18_STR-VNAMS sy-vline 
WA_RNF18_STR-TITEL sy-vline 
WA_RNF18_STR-NAMZU sy-vline 
WA_RNF18_STR-VORSW sy-vline 
WA_RNF18_STR-NAME2 sy-vline 
WA_RNF18_STR-GBDAT sy-vline 
WA_RNF18_STR-GBNAM sy-vline 
WA_RNF18_STR-GBNAS sy-vline 
WA_RNF18_STR-GLAND sy-vline 
WA_RNF18_STR-TODKZ sy-vline 
WA_RNF18_STR-TODDT sy-vline 
WA_RNF18_STR-TODZT sy-vline 
WA_RNF18_STR-TODDB sy-vline 
WA_RNF18_STR-TODZB sy-vline 
WA_RNF18_STR-TODUR sy-vline 
WA_RNF18_STR-ANRED sy-vline 
WA_RNF18_STR-FAMST sy-vline 
WA_RNF18_STR-KONFE sy-vline 
WA_RNF18_STR-NATIO sy-vline 
WA_RNF18_STR-SPRAS sy-vline 
WA_RNF18_STR-LAND sy-vline 
WA_RNF18_STR-PSTLZ sy-vline 
WA_RNF18_STR-ORT sy-vline 
WA_RNF18_STR-ORT2 sy-vline 
WA_RNF18_STR-STRAS sy-vline 
WA_RNF18_STR-BLAND sy-vline 
WA_RNF18_STR-GEBIE sy-vline 
WA_RNF18_STR-TELF1 sy-vline 
WA_RNF18_STR-SPEND sy-vline 
WA_RNF18_STR-SPENT sy-vline 
WA_RNF18_STR-SPELT sy-vline 
WA_RNF18_STR-VIPKZ sy-vline 
WA_RNF18_STR-ARCHV sy-vline 
WA_RNF18_STR-STATU sy-vline 
WA_RNF18_STR-EXTNR sy-vline 
WA_RNF18_STR-NOTAN sy-vline 
WA_RNF18_STR-KRZAN sy-vline 
WA_RNF18_STR-RFPAT sy-vline 
WA_RNF18_STR-RFZIF sy-vline 
WA_RNF18_STR-BERUF sy-vline 
WA_RNF18_STR-AGNUM sy-vline 
WA_RNF18_STR-AGNAM sy-vline 
WA_RNF18_STR-AGLAN sy-vline 
WA_RNF18_STR-AGPLZ sy-vline 
WA_RNF18_STR-AGORT sy-vline 
WA_RNF18_STR-AGSTR sy-vline 
WA_RNF18_STR-AGTEL sy-vline 
WA_RNF18_STR-RVNUM sy-vline 
WA_RNF18_STR-ANNA1 sy-vline 
WA_RNF18_STR-ANVN1 sy-vline 
WA_RNF18_STR-ANLA1 sy-vline 
WA_RNF18_STR-ANPL1 sy-vline 
WA_RNF18_STR-ANOR1 sy-vline 
WA_RNF18_STR-ANST1 sy-vline 
WA_RNF18_STR-ANTE1 sy-vline 
WA_RNF18_STR-ANVV1 sy-vline 
WA_RNF18_STR-VMKZ1 sy-vline 
WA_RNF18_STR-ANNA2 sy-vline 
WA_RNF18_STR-ANVN2 sy-vline 
WA_RNF18_STR-ANLA2 sy-vline 
WA_RNF18_STR-ANPL2 sy-vline 
WA_RNF18_STR-ANOR2 sy-vline 
WA_RNF18_STR-ANST2 sy-vline 
WA_RNF18_STR-ANTE2 sy-vline 
WA_RNF18_STR-ANVV2 sy-vline 
WA_RNF18_STR-VMKZ2 sy-vline 
WA_RNF18_STR-KZTXT sy-vline 
WA_RNF18_STR-LGTXT sy-vline 
WA_RNF18_STR-BEGDT sy-vline 
WA_RNF18_STR-ENDDT sy-vline 
WA_RNF18_STR-HISTK sy-vline 
WA_RNF18_STR-RISKF sy-vline 
WA_RNF18_STR-TESTP sy-vline 
WA_RNF18_STR-PZIFF sy-vline 
WA_RNF18_STR-ERDAT sy-vline 
WA_RNF18_STR-ERUSR sy-vline 
WA_RNF18_STR-UPDAT sy-vline 
WA_RNF18_STR-UPUSR sy-vline 
WA_RNF18_STR-STORN sy-vline 
WA_RNF18_STR-STUSR sy-vline 
WA_RNF18_STR-STDAT sy-vline 
WA_RNF18_STR-GBORT sy-vline 
WA_RNF18_STR-HARNR sy-vline 
WA_RNF18_STR-EARNR sy-vline 
WA_RNF18_STR-UARNR sy-vline 
WA_RNF18_STR-RACE sy-vline 
WA_RNF18_STR-RESID sy-vline 
WA_RNF18_STR-PASSTY sy-vline 
WA_RNF18_STR-PASSNR sy-vline 
WA_RNF18_STR-ADRNR sy-vline 
WA_RNF18_STR-ADROB sy-vline 
WA_RNF18_STR-ADNAG sy-vline 
WA_RNF18_STR-ADOAG sy-vline 
WA_RNF18_STR-ADNN1 sy-vline 
WA_RNF18_STR-ADON1 sy-vline 
WA_RNF18_STR-ADNN2 sy-vline 
WA_RNF18_STR-ADON2 sy-vline 
WA_RNF18_STR-ANEX1 sy-vline 
WA_RNF18_STR-ANEX2 sy-vline 
WA_RNF18_STR-ADRN2 sy-vline 
WA_RNF18_STR-ADRO2 sy-vline 
WA_RNF18_STR-INACT sy-vline 
WA_RNF18_STR-USER1 sy-vline 
WA_RNF18_STR-USER2 sy-vline 
WA_RNF18_STR-USER3 sy-vline 
WA_RNF18_STR-USER4 sy-vline 
WA_RNF18_STR-USER5 sy-vline 
WA_RNF18_STR-USER6 sy-vline 
WA_RNF18_STR-EXTAUFG sy-vline 
WA_RNF18_STR-EXTAUFGA sy-vline 
WA_RNF18_STR-EMPSC sy-vline 
WA_RNF18_STR-UNKNOWN_GBDAT sy-vline 
WA_RNF18_STR-MIG_DONE sy-vline 
WA_RNF18_STR-INSID sy-vline 
WA_RNF18_STR-ISTAT_BPL sy-vline 
WA_RNF18_STR-TAXNUM sy-vline 
WA_RNF18_STR-TAXNUM_IND sy-vline 
WA_RNF18_STR-STP sy-vline 
WA_RNF18_STR-STP_ENDDT sy-vline 
WA_RNF18_STR-CONS_PERSDATA sy-vline 
WA_RNF18_STR-/ISHFR/BIRTHRK sy-vline 
WA_RNF18_STR-DTH_LOC sy-vline 
WA_RNF18_STR-OCCUP sy-vline 
WA_RNF18_STR-NARNR_S sy-vline 
WA_RNF18_STR-NARNR_A sy-vline      INTO ld_text SEPARATED BY SPACE.

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