ABAP Select data from SAP table REIS_BU_L 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 REIS_BU_L 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 REIS_BU_L. 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 REIS_BU_L 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_REIS_BU_L TYPE STANDARD TABLE OF REIS_BU_L,
      WA_REIS_BU_L TYPE REIS_BU_L,
      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: <REIS_BU_L> TYPE REIS_BU_L.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM REIS_BU_L
*  INTO TABLE @DATA(IT_REIS_BU_L2).
*--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_REIS_BU_L INDEX 1 INTO DATA(WA_REIS_BU_L2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<REIS_BU_L>-MANDT = 1.
<REIS_BU_L>-INTRENO = 1.
<REIS_BU_L>-BUKRS = 1.
<REIS_BU_L>-SWENR = 1.
<REIS_BU_L>-SGENR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_REIS_BU_L-OBJNR, sy-vline,
  WA_REIS_BU_L-IMKEY, sy-vline,
  WA_REIS_BU_L-CREATIONTYPE, sy-vline,
  WA_REIS_BU_L-RERF, sy-vline,
  WA_REIS_BU_L-DERF, sy-vline,
  WA_REIS_BU_L-TERF, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_REIS_BU_L 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_REIS_BU_L 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_REIS_BU_L INTO WA_REIS_BU_L.


*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 SWENR, internal->external for field SWENR
CALL FUNCTION 'CONVERSION_EXIT_SWENR_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-SWENR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-SWENR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit REDAT, internal->external for field VALIDTO
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-VALIDTO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-VALIDTO.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit REDAT, internal->external for field REALVALIDTO
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-REALVALIDTO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-REALVALIDTO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit FMCIL, internal->external for field COMMITMENTITEM
CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-COMMITMENTITEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-COMMITMENTITEM.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO01
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-MEASVALIDTO01
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-MEASVALIDTO01.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO02
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-MEASVALIDTO02
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-MEASVALIDTO02.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO03
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-MEASVALIDTO03
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-MEASVALIDTO03.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO04
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-MEASVALIDTO04
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-MEASVALIDTO04.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO05
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-MEASVALIDTO05
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-MEASVALIDTO05.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit REDAT, internal->external for field CTVALIDTO01
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-CTVALIDTO01
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-CTVALIDTO01.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field CTVALIDTO02
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-CTVALIDTO02
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-CTVALIDTO02.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field CTVALIDTO03
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-CTVALIDTO03
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-CTVALIDTO03.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field CTVALIDTO04
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-CTVALIDTO04
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-CTVALIDTO04.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field CTVALIDTO05
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-CTVALIDTO05
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-CTVALIDTO05.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field EDID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_REIS_BU_L-EDID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_BU_L-EDID.
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_REIS_BU_L_STR, 
MANDT TYPE STRING,
INTRENO TYPE STRING,
BUKRS TYPE STRING,
SWENR TYPE STRING,
SGENR TYPE STRING,
OBJNR TYPE STRING,
IMKEY TYPE STRING,
CREATIONTYPE TYPE STRING,
RERF TYPE STRING,
DERF TYPE STRING,
TERF TYPE STRING,
REHER TYPE STRING,
RBEAR TYPE STRING,
DBEAR TYPE STRING,
TBEAR TYPE STRING,
RBHER TYPE STRING,
RESPONSIBLE TYPE STRING,
USEREXCLUSIVE TYPE STRING,
AUTHGRP TYPE STRING,
VALIDFROM TYPE STRING,
VALIDTO TYPE STRING,
XGETXT TYPE STRING,
RGEBART TYPE STRING,
JERBBAU TYPE STRING,
RGEBZUST TYPE STRING,
YBAUJAHR TYPE STRING,
YMODERN TYPE STRING,
YAUFBAU TYPE STRING,
DBAUBEGI TYPE STRING,
BBAUW13 TYPE STRING,
BBAUWX TYPE STRING,
BBAUWAKT TYPE STRING,
BBAUWAKTX TYPE STRING,
BDMCBMRA TYPE STRING,
DBAUGENE TYPE STRING,
XBAUGENE TYPE STRING,
DBEZUGSF TYPE STRING,
DFERTIG TYPE STRING,
DSCHLUSS TYPE STRING,
JDENKMAL TYPE STRING,
DBAUVOR TYPE STRING,
DVORBES TYPE STRING,
DANTBAU TYPE STRING,
BEINHEITW TYPE STRING,
BEINHEITWX TYPE STRING,
NEINHEITW TYPE STRING,
BVERSWRT TYPE STRING,
BVERSWRTX TYPE STRING,
RVERSWRT TYPE STRING,
DWIRTUB TYPE STRING,
DVERKAUF TYPE STRING,
DVRKPLAN TYPE STRING,
DNUTZEND TYPE STRING,
DFRDVON TYPE STRING,
DFRDBIS TYPE STRING,
BANZGE TYPE STRING,
SUNUTZA TYPE STRING,
JUNUTZA TYPE STRING,
SSTCKBIS TYPE STRING,
SLIFTBIS TYPE STRING,
AUGESCH TYPE STRING,
JANLHIE TYPE STRING,
RLRALOC TYPE STRING,
USESRLRA TYPE STRING,
GEMEINDE TYPE STRING,
REINS TYPE STRING,
WAERS TYPE STRING,
HASCOP TYPE STRING,
USGFUNCTION TYPE STRING,
OBJCOND TYPE STRING,
OBJCAT TYPE STRING,
YEARDECONSTR TYPE STRING,
AREAVALUE TYPE STRING,
HEATINGTYPE TYPE STRING,
ENERGYHEAT TYPE STRING,
ENERGYWATER TYPE STRING,
HOTWATERSUPPLY TYPE STRING,
POWERCONSUM TYPE STRING,
GLAZING TYPE STRING,
ADMINNO TYPE STRING,
ADMINXGETXT TYPE STRING,
GEMEINDECH TYPE STRING,
BANZGECH TYPE STRING,
SSTCKBISCH TYPE STRING,
SLIFTBISCH TYPE STRING,
AUGESCHCH TYPE STRING,
SECCO TYPE STRING,
BUPLA TYPE STRING,
REPKOCH TYPE STRING,
BDCONSTR TYPE STRING,
BDFIREPREV TYPE STRING,
BDOTHOW TYPE STRING,
BDOWNSHIP TYPE STRING,
KOCHDATE TYPE STRING,
VPT TYPE STRING,
CURRENCY TYPE STRING,
CONDK TYPE STRING,
BUTXT TYPE STRING,
XWETEXT TYPE STRING,
XUNART TYPE STRING,
KTEXT TYPE STRING,
XGEBART TYPE STRING,
XGEBZUST TYPE STRING,
XGEMEINDE TYPE STRING,
XKREIS TYPE STRING,
XREGIO TYPE STRING,
RLRA TYPE STRING,
XRLRA TYPE STRING,
XRLRALOC TYPE STRING,
XDAZUST TYPE STRING,
XFAZUST TYPE STRING,
XADDRESS TYPE STRING,
GSBER TYPE STRING,
PRCTR TYPE STRING,
REALVALIDFROM TYPE STRING,
REALVALIDTO TYPE STRING,
XSTOCKO TYPE STRING,
XSTOCKL TYPE STRING,
TXJCD TYPE STRING,
XAUTHGRP TYPE STRING,
XMUSGFUNCTION TYPE STRING,
XJERBBAUK TYPE STRING,
XJERBBAUL TYPE STRING,
XSTOCKOK TYPE STRING,
XSTOCKLK TYPE STRING,
XSTOCKOL TYPE STRING,
XSTOCKLL TYPE STRING,
FUND TYPE STRING,
FUNDSCENTER TYPE STRING,
COMMITMENTITEM TYPE STRING,
FUNCTIONALAREA TYPE STRING,
GRANTNUMBER TYPE STRING,
MEASURE TYPE STRING,
BUDGETPERIOD TYPE STRING,
STREET TYPE STRING,
HOUSE_NUM1 TYPE STRING,
POST_CODE1 TYPE STRING,
CITY1 TYPE STRING,
COUNTRY TYPE STRING,
REGION TYPE STRING,
MEASVALUE01 TYPE STRING,
MEASVALUECMPL01 TYPE STRING,
MEASUNIT01 TYPE STRING,
MEASVALIDFROM01 TYPE STRING,
MEASVALIDTO01 TYPE STRING,
MEASVALUE02 TYPE STRING,
MEASVALUECMPL02 TYPE STRING,
MEASUNIT02 TYPE STRING,
MEASVALIDFROM02 TYPE STRING,
MEASVALIDTO02 TYPE STRING,
MEASVALUE03 TYPE STRING,
MEASVALUECMPL03 TYPE STRING,
MEASUNIT03 TYPE STRING,
MEASVALIDFROM03 TYPE STRING,
MEASVALIDTO03 TYPE STRING,
MEASVALUE04 TYPE STRING,
MEASVALUECMPL04 TYPE STRING,
MEASUNIT04 TYPE STRING,
MEASVALIDFROM04 TYPE STRING,
MEASVALIDTO04 TYPE STRING,
MEASVALUE05 TYPE STRING,
MEASVALUECMPL05 TYPE STRING,
MEASUNIT05 TYPE STRING,
MEASVALIDFROM05 TYPE STRING,
MEASVALIDTO05 TYPE STRING,
MEASISVALIDFROM TYPE STRING,
MEASISVALIDTO TYPE STRING,
RECISVALIDFROM TYPE STRING,
RECISVALIDTO TYPE STRING,
GEN_OBJTYPE TYPE STRING,
GEN_OBJNR TYPE STRING,
GEN_CONTRACT TYPE STRING,
GEN_PARTNER1 TYPE STRING,
GEN_PARTNER2 TYPE STRING,
ALVROWS TYPE STRING,
FIXFITCHARACT01 TYPE STRING,
CTVALIDFROM01 TYPE STRING,
CTVALIDTO01 TYPE STRING,
FFCTACCURATE01 TYPE STRING,
CHARACTCOUNT01 TYPE STRING,
ADDITIONALINFO01 TYPE STRING,
SUPPLEMENTINFO01 TYPE STRING,
FIXFITCHARACT02 TYPE STRING,
CTVALIDFROM02 TYPE STRING,
CTVALIDTO02 TYPE STRING,
FFCTACCURATE02 TYPE STRING,
CHARACTCOUNT02 TYPE STRING,
ADDITIONALINFO02 TYPE STRING,
SUPPLEMENTINFO02 TYPE STRING,
FIXFITCHARACT03 TYPE STRING,
CTVALIDFROM03 TYPE STRING,
CTVALIDTO03 TYPE STRING,
FFCTACCURATE03 TYPE STRING,
CHARACTCOUNT03 TYPE STRING,
ADDITIONALINFO03 TYPE STRING,
SUPPLEMENTINFO03 TYPE STRING,
FIXFITCHARACT04 TYPE STRING,
CTVALIDFROM04 TYPE STRING,
CTVALIDTO04 TYPE STRING,
FFCTACCURATE04 TYPE STRING,
CHARACTCOUNT04 TYPE STRING,
ADDITIONALINFO04 TYPE STRING,
SUPPLEMENTINFO04 TYPE STRING,
FIXFITCHARACT05 TYPE STRING,
CTVALIDFROM05 TYPE STRING,
CTVALIDTO05 TYPE STRING,
FFCTACCURATE05 TYPE STRING,
CHARACTCOUNT05 TYPE STRING,
ADDITIONALINFO05 TYPE STRING,
SUPPLEMENTINFO05 TYPE STRING,
FIXFITTISVALIDFROM TYPE STRING,
FIXFITTISVALIDTO TYPE STRING,
EGID TYPE STRING,
EDID TYPE STRING,
STREETCH TYPE STRING,
HOUSE_NUMCH TYPE STRING,
POST_CODECH TYPE STRING,
CITYCH TYPE STRING,
XCOORD TYPE STRING,
XOBJCOND TYPE STRING,
XOBJCAT TYPE STRING,
XHEATINGTYPE TYPE STRING,
XENERGYHEAT TYPE STRING,
XENERGYWATER TYPE STRING,
XGEMEINDECH TYPE STRING,
XKREISCH TYPE STRING,
XREGIOCH TYPE STRING,
XSTOCKOCH TYPE STRING,
XSTOCKLCH TYPE STRING,END OF T_EKKO_STR.
DATA: WA_REIS_BU_L_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_REIS_BU_L_STR-MANDT sy-vline 
WA_REIS_BU_L_STR-INTRENO sy-vline 
WA_REIS_BU_L_STR-BUKRS sy-vline 
WA_REIS_BU_L_STR-SWENR sy-vline 
WA_REIS_BU_L_STR-SGENR sy-vline 
WA_REIS_BU_L_STR-OBJNR sy-vline 
WA_REIS_BU_L_STR-IMKEY sy-vline 
WA_REIS_BU_L_STR-CREATIONTYPE sy-vline 
WA_REIS_BU_L_STR-RERF sy-vline 
WA_REIS_BU_L_STR-DERF sy-vline 
WA_REIS_BU_L_STR-TERF sy-vline 
WA_REIS_BU_L_STR-REHER sy-vline 
WA_REIS_BU_L_STR-RBEAR sy-vline 
WA_REIS_BU_L_STR-DBEAR sy-vline 
WA_REIS_BU_L_STR-TBEAR sy-vline 
WA_REIS_BU_L_STR-RBHER sy-vline 
WA_REIS_BU_L_STR-RESPONSIBLE sy-vline 
WA_REIS_BU_L_STR-USEREXCLUSIVE sy-vline 
WA_REIS_BU_L_STR-AUTHGRP sy-vline 
WA_REIS_BU_L_STR-VALIDFROM sy-vline 
WA_REIS_BU_L_STR-VALIDTO sy-vline 
WA_REIS_BU_L_STR-XGETXT sy-vline 
WA_REIS_BU_L_STR-RGEBART sy-vline 
WA_REIS_BU_L_STR-JERBBAU sy-vline 
WA_REIS_BU_L_STR-RGEBZUST sy-vline 
WA_REIS_BU_L_STR-YBAUJAHR sy-vline 
WA_REIS_BU_L_STR-YMODERN sy-vline 
WA_REIS_BU_L_STR-YAUFBAU sy-vline 
WA_REIS_BU_L_STR-DBAUBEGI sy-vline 
WA_REIS_BU_L_STR-BBAUW13 sy-vline 
WA_REIS_BU_L_STR-BBAUWX sy-vline 
WA_REIS_BU_L_STR-BBAUWAKT sy-vline 
WA_REIS_BU_L_STR-BBAUWAKTX sy-vline 
WA_REIS_BU_L_STR-BDMCBMRA sy-vline 
WA_REIS_BU_L_STR-DBAUGENE sy-vline 
WA_REIS_BU_L_STR-XBAUGENE sy-vline 
WA_REIS_BU_L_STR-DBEZUGSF sy-vline 
WA_REIS_BU_L_STR-DFERTIG sy-vline 
WA_REIS_BU_L_STR-DSCHLUSS sy-vline 
WA_REIS_BU_L_STR-JDENKMAL sy-vline 
WA_REIS_BU_L_STR-DBAUVOR sy-vline 
WA_REIS_BU_L_STR-DVORBES sy-vline 
WA_REIS_BU_L_STR-DANTBAU sy-vline 
WA_REIS_BU_L_STR-BEINHEITW sy-vline 
WA_REIS_BU_L_STR-BEINHEITWX sy-vline 
WA_REIS_BU_L_STR-NEINHEITW sy-vline 
WA_REIS_BU_L_STR-BVERSWRT sy-vline 
WA_REIS_BU_L_STR-BVERSWRTX sy-vline 
WA_REIS_BU_L_STR-RVERSWRT sy-vline 
WA_REIS_BU_L_STR-DWIRTUB sy-vline 
WA_REIS_BU_L_STR-DVERKAUF sy-vline 
WA_REIS_BU_L_STR-DVRKPLAN sy-vline 
WA_REIS_BU_L_STR-DNUTZEND sy-vline 
WA_REIS_BU_L_STR-DFRDVON sy-vline 
WA_REIS_BU_L_STR-DFRDBIS sy-vline 
WA_REIS_BU_L_STR-BANZGE sy-vline 
WA_REIS_BU_L_STR-SUNUTZA sy-vline 
WA_REIS_BU_L_STR-JUNUTZA sy-vline 
WA_REIS_BU_L_STR-SSTCKBIS sy-vline 
WA_REIS_BU_L_STR-SLIFTBIS sy-vline 
WA_REIS_BU_L_STR-AUGESCH sy-vline 
WA_REIS_BU_L_STR-JANLHIE sy-vline 
WA_REIS_BU_L_STR-RLRALOC sy-vline 
WA_REIS_BU_L_STR-USESRLRA sy-vline 
WA_REIS_BU_L_STR-GEMEINDE sy-vline 
WA_REIS_BU_L_STR-REINS sy-vline 
WA_REIS_BU_L_STR-WAERS sy-vline 
WA_REIS_BU_L_STR-HASCOP sy-vline 
WA_REIS_BU_L_STR-USGFUNCTION sy-vline 
WA_REIS_BU_L_STR-OBJCOND sy-vline 
WA_REIS_BU_L_STR-OBJCAT sy-vline 
WA_REIS_BU_L_STR-YEARDECONSTR sy-vline 
WA_REIS_BU_L_STR-AREAVALUE sy-vline 
WA_REIS_BU_L_STR-HEATINGTYPE sy-vline 
WA_REIS_BU_L_STR-ENERGYHEAT sy-vline 
WA_REIS_BU_L_STR-ENERGYWATER sy-vline 
WA_REIS_BU_L_STR-HOTWATERSUPPLY sy-vline 
WA_REIS_BU_L_STR-POWERCONSUM sy-vline 
WA_REIS_BU_L_STR-GLAZING sy-vline 
WA_REIS_BU_L_STR-ADMINNO sy-vline 
WA_REIS_BU_L_STR-ADMINXGETXT sy-vline 
WA_REIS_BU_L_STR-GEMEINDECH sy-vline 
WA_REIS_BU_L_STR-BANZGECH sy-vline 
WA_REIS_BU_L_STR-SSTCKBISCH sy-vline 
WA_REIS_BU_L_STR-SLIFTBISCH sy-vline 
WA_REIS_BU_L_STR-AUGESCHCH sy-vline 
WA_REIS_BU_L_STR-SECCO sy-vline 
WA_REIS_BU_L_STR-BUPLA sy-vline 
WA_REIS_BU_L_STR-REPKOCH sy-vline 
WA_REIS_BU_L_STR-BDCONSTR sy-vline 
WA_REIS_BU_L_STR-BDFIREPREV sy-vline 
WA_REIS_BU_L_STR-BDOTHOW sy-vline 
WA_REIS_BU_L_STR-BDOWNSHIP sy-vline 
WA_REIS_BU_L_STR-KOCHDATE sy-vline 
WA_REIS_BU_L_STR-VPT sy-vline 
WA_REIS_BU_L_STR-CURRENCY sy-vline 
WA_REIS_BU_L_STR-CONDK sy-vline 
WA_REIS_BU_L_STR-BUTXT sy-vline 
WA_REIS_BU_L_STR-XWETEXT sy-vline 
WA_REIS_BU_L_STR-XUNART sy-vline 
WA_REIS_BU_L_STR-KTEXT sy-vline 
WA_REIS_BU_L_STR-XGEBART sy-vline 
WA_REIS_BU_L_STR-XGEBZUST sy-vline 
WA_REIS_BU_L_STR-XGEMEINDE sy-vline 
WA_REIS_BU_L_STR-XKREIS sy-vline 
WA_REIS_BU_L_STR-XREGIO sy-vline 
WA_REIS_BU_L_STR-RLRA sy-vline 
WA_REIS_BU_L_STR-XRLRA sy-vline 
WA_REIS_BU_L_STR-XRLRALOC sy-vline 
WA_REIS_BU_L_STR-XDAZUST sy-vline 
WA_REIS_BU_L_STR-XFAZUST sy-vline 
WA_REIS_BU_L_STR-XADDRESS sy-vline 
WA_REIS_BU_L_STR-GSBER sy-vline 
WA_REIS_BU_L_STR-PRCTR sy-vline 
WA_REIS_BU_L_STR-REALVALIDFROM sy-vline 
WA_REIS_BU_L_STR-REALVALIDTO sy-vline 
WA_REIS_BU_L_STR-XSTOCKO sy-vline 
WA_REIS_BU_L_STR-XSTOCKL sy-vline 
WA_REIS_BU_L_STR-TXJCD sy-vline 
WA_REIS_BU_L_STR-XAUTHGRP sy-vline 
WA_REIS_BU_L_STR-XMUSGFUNCTION sy-vline 
WA_REIS_BU_L_STR-XJERBBAUK sy-vline 
WA_REIS_BU_L_STR-XJERBBAUL sy-vline 
WA_REIS_BU_L_STR-XSTOCKOK sy-vline 
WA_REIS_BU_L_STR-XSTOCKLK sy-vline 
WA_REIS_BU_L_STR-XSTOCKOL sy-vline 
WA_REIS_BU_L_STR-XSTOCKLL sy-vline 
WA_REIS_BU_L_STR-FUND sy-vline 
WA_REIS_BU_L_STR-FUNDSCENTER sy-vline 
WA_REIS_BU_L_STR-COMMITMENTITEM sy-vline 
WA_REIS_BU_L_STR-FUNCTIONALAREA sy-vline 
WA_REIS_BU_L_STR-GRANTNUMBER sy-vline 
WA_REIS_BU_L_STR-MEASURE sy-vline 
WA_REIS_BU_L_STR-BUDGETPERIOD sy-vline 
WA_REIS_BU_L_STR-STREET sy-vline 
WA_REIS_BU_L_STR-HOUSE_NUM1 sy-vline 
WA_REIS_BU_L_STR-POST_CODE1 sy-vline 
WA_REIS_BU_L_STR-CITY1 sy-vline 
WA_REIS_BU_L_STR-COUNTRY sy-vline 
WA_REIS_BU_L_STR-REGION sy-vline 
WA_REIS_BU_L_STR-MEASVALUE01 sy-vline 
WA_REIS_BU_L_STR-MEASVALUECMPL01 sy-vline 
WA_REIS_BU_L_STR-MEASUNIT01 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDFROM01 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDTO01 sy-vline 
WA_REIS_BU_L_STR-MEASVALUE02 sy-vline 
WA_REIS_BU_L_STR-MEASVALUECMPL02 sy-vline 
WA_REIS_BU_L_STR-MEASUNIT02 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDFROM02 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDTO02 sy-vline 
WA_REIS_BU_L_STR-MEASVALUE03 sy-vline 
WA_REIS_BU_L_STR-MEASVALUECMPL03 sy-vline 
WA_REIS_BU_L_STR-MEASUNIT03 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDFROM03 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDTO03 sy-vline 
WA_REIS_BU_L_STR-MEASVALUE04 sy-vline 
WA_REIS_BU_L_STR-MEASVALUECMPL04 sy-vline 
WA_REIS_BU_L_STR-MEASUNIT04 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDFROM04 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDTO04 sy-vline 
WA_REIS_BU_L_STR-MEASVALUE05 sy-vline 
WA_REIS_BU_L_STR-MEASVALUECMPL05 sy-vline 
WA_REIS_BU_L_STR-MEASUNIT05 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDFROM05 sy-vline 
WA_REIS_BU_L_STR-MEASVALIDTO05 sy-vline 
WA_REIS_BU_L_STR-MEASISVALIDFROM sy-vline 
WA_REIS_BU_L_STR-MEASISVALIDTO sy-vline 
WA_REIS_BU_L_STR-RECISVALIDFROM sy-vline 
WA_REIS_BU_L_STR-RECISVALIDTO sy-vline 
WA_REIS_BU_L_STR-GEN_OBJTYPE sy-vline 
WA_REIS_BU_L_STR-GEN_OBJNR sy-vline 
WA_REIS_BU_L_STR-GEN_CONTRACT sy-vline 
WA_REIS_BU_L_STR-GEN_PARTNER1 sy-vline 
WA_REIS_BU_L_STR-GEN_PARTNER2 sy-vline 
WA_REIS_BU_L_STR-ALVROWS sy-vline 
WA_REIS_BU_L_STR-FIXFITCHARACT01 sy-vline 
WA_REIS_BU_L_STR-CTVALIDFROM01 sy-vline 
WA_REIS_BU_L_STR-CTVALIDTO01 sy-vline 
WA_REIS_BU_L_STR-FFCTACCURATE01 sy-vline 
WA_REIS_BU_L_STR-CHARACTCOUNT01 sy-vline 
WA_REIS_BU_L_STR-ADDITIONALINFO01 sy-vline 
WA_REIS_BU_L_STR-SUPPLEMENTINFO01 sy-vline 
WA_REIS_BU_L_STR-FIXFITCHARACT02 sy-vline 
WA_REIS_BU_L_STR-CTVALIDFROM02 sy-vline 
WA_REIS_BU_L_STR-CTVALIDTO02 sy-vline 
WA_REIS_BU_L_STR-FFCTACCURATE02 sy-vline 
WA_REIS_BU_L_STR-CHARACTCOUNT02 sy-vline 
WA_REIS_BU_L_STR-ADDITIONALINFO02 sy-vline 
WA_REIS_BU_L_STR-SUPPLEMENTINFO02 sy-vline 
WA_REIS_BU_L_STR-FIXFITCHARACT03 sy-vline 
WA_REIS_BU_L_STR-CTVALIDFROM03 sy-vline 
WA_REIS_BU_L_STR-CTVALIDTO03 sy-vline 
WA_REIS_BU_L_STR-FFCTACCURATE03 sy-vline 
WA_REIS_BU_L_STR-CHARACTCOUNT03 sy-vline 
WA_REIS_BU_L_STR-ADDITIONALINFO03 sy-vline 
WA_REIS_BU_L_STR-SUPPLEMENTINFO03 sy-vline 
WA_REIS_BU_L_STR-FIXFITCHARACT04 sy-vline 
WA_REIS_BU_L_STR-CTVALIDFROM04 sy-vline 
WA_REIS_BU_L_STR-CTVALIDTO04 sy-vline 
WA_REIS_BU_L_STR-FFCTACCURATE04 sy-vline 
WA_REIS_BU_L_STR-CHARACTCOUNT04 sy-vline 
WA_REIS_BU_L_STR-ADDITIONALINFO04 sy-vline 
WA_REIS_BU_L_STR-SUPPLEMENTINFO04 sy-vline 
WA_REIS_BU_L_STR-FIXFITCHARACT05 sy-vline 
WA_REIS_BU_L_STR-CTVALIDFROM05 sy-vline 
WA_REIS_BU_L_STR-CTVALIDTO05 sy-vline 
WA_REIS_BU_L_STR-FFCTACCURATE05 sy-vline 
WA_REIS_BU_L_STR-CHARACTCOUNT05 sy-vline 
WA_REIS_BU_L_STR-ADDITIONALINFO05 sy-vline 
WA_REIS_BU_L_STR-SUPPLEMENTINFO05 sy-vline 
WA_REIS_BU_L_STR-FIXFITTISVALIDFROM sy-vline 
WA_REIS_BU_L_STR-FIXFITTISVALIDTO sy-vline 
WA_REIS_BU_L_STR-EGID sy-vline 
WA_REIS_BU_L_STR-EDID sy-vline 
WA_REIS_BU_L_STR-STREETCH sy-vline 
WA_REIS_BU_L_STR-HOUSE_NUMCH sy-vline 
WA_REIS_BU_L_STR-POST_CODECH sy-vline 
WA_REIS_BU_L_STR-CITYCH sy-vline 
WA_REIS_BU_L_STR-XCOORD sy-vline 
WA_REIS_BU_L_STR-XOBJCOND sy-vline 
WA_REIS_BU_L_STR-XOBJCAT sy-vline 
WA_REIS_BU_L_STR-XHEATINGTYPE sy-vline 
WA_REIS_BU_L_STR-XENERGYHEAT sy-vline 
WA_REIS_BU_L_STR-XENERGYWATER sy-vline 
WA_REIS_BU_L_STR-XGEMEINDECH sy-vline 
WA_REIS_BU_L_STR-XKREISCH sy-vline 
WA_REIS_BU_L_STR-XREGIOCH sy-vline 
WA_REIS_BU_L_STR-XSTOCKOCH sy-vline 
WA_REIS_BU_L_STR-XSTOCKLCH sy-vline      INTO ld_text SEPARATED BY SPACE.

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