ABAP Select data from SAP table RFVIREPDATA 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 RFVIREPDATA 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 RFVIREPDATA. 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 RFVIREPDATA 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_RFVIREPDATA TYPE STANDARD TABLE OF RFVIREPDATA,
      WA_RFVIREPDATA TYPE RFVIREPDATA,
      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: <RFVIREPDATA> TYPE RFVIREPDATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RFVIREPDATA
*  INTO TABLE @DATA(IT_RFVIREPDATA2).
*--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_RFVIREPDATA INDEX 1 INTO DATA(WA_RFVIREPDATA2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RFVIREPDATA>-BUKRS = 1.
<RFVIREPDATA>-SWENR = 1.
<RFVIREPDATA>-SGENR = 1.
<RFVIREPDATA>-SGRNR = 1.
<RFVIREPDATA>-SMENR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RFVIREPDATA-XMETXT, sy-vline,
  WA_RFVIREPDATA-ME_ADR, sy-vline,
  WA_RFVIREPDATA-SNUNR, sy-vline,
  WA_RFVIREPDATA-SNUNRTXT, sy-vline,
  WA_RFVIREPDATA-STATUSTXT, sy-vline,
  WA_RFVIREPDATA-XKLEERGD, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RFVIREPDATA 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_RFVIREPDATA 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_RFVIREPDATA INTO WA_RFVIREPDATA.


*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_RFVIREPDATA-SWENR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFVIREPDATA-SWENR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field FEINS5
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_RFVIREPDATA-FEINS5
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RFVIREPDATA-FEINS5.
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_RFVIREPDATA_STR, 
BUKRS TYPE STRING,
SWENR TYPE STRING,
SGENR TYPE STRING,
SGRNR TYPE STRING,
SMENR TYPE STRING,
XMETXT TYPE STRING,
ME_ADR TYPE STRING,
SNUNR TYPE STRING,
SNUNRTXT TYPE STRING,
STATUSTXT TYPE STRING,
XKLEERGD TYPE STRING,
DSTGAB TYPE STRING,
DSTBIS TYPE STRING,
E_SMIVE TYPE STRING,
SMIVE TYPE STRING,
DMIBEG TYPE STRING,
DMIEND TYPE STRING,
DKUEZU TYPE STRING,
LINEK TYPE STRING,
AZIMM TYPE STRING,
AHALBZI TYPE STRING,
SFLART TYPE STRING,
FQMFLART TYPE STRING,
FEINS TYPE STRING,
XKFLART TYPE STRING,
SWHRKOND TYPE STRING,
ZLSCH TYPE STRING,
ZLSCHTXT TYPE STRING,
GZLSCH TYPE STRING,
GZLSCHTXT TYPE STRING,
SMIETSP TYPE STRING,
SMIETSPTXT TYPE STRING,
XAUSTKL TYPE STRING,
XAUSTKLTXT TYPE STRING,
XLAGE TYPE STRING,
XLAGETXT TYPE STRING,
DDATVON TYPE STRING,
DDATBIS TYPE STRING,
SAVAIL TYPE STRING,
XAVAIL TYPE STRING,
SMVART TYPE STRING,
SMVARTTXT TYPE STRING,
SMVANART TYPE STRING,
SMVANARTTXT TYPE STRING,
SKUEART TYPE STRING,
SKUEARTTXT TYPE STRING,
SKUEKEY TYPE STRING,
DKUEFR TYPE STRING,
SKUEFR TYPE STRING,
DEINKUE TYPE STRING,
JVERL TYPE STRING,
ANKUEN TYPE STRING,
VERLG TYPE STRING,
JKAUFOPT TYPE STRING,
DKAUFOPT TYPE STRING,
DEINZG TYPE STRING,
DAUSZG TYPE STRING,
GERSTD TYPE STRING,
IND_SECTOR TYPE STRING,
PARTFROM TYPE STRING,
PARTWHY TYPE STRING,
SSTOCKW TYPE STRING,
SSTOCKWTXT TYPE STRING,
RLGESCH TYPE STRING,
RLGESCHTXT TYPE STRING,
SGEBT TYPE STRING,
SGEBTTXT TYPE STRING,
USRSTATUS TYPE STRING,
EFFSUMNET TYPE STRING,
EFFSUMTOT TYPE STRING,
EFFSUMNET1 TYPE STRING,
EFFSUMNET2 TYPE STRING,
EFFSUMNET3 TYPE STRING,
EFFSUMNET4 TYPE STRING,
EFFSUMNET5 TYPE STRING,
EFFSUMNET6 TYPE STRING,
EFFSUMNET7 TYPE STRING,
EFFSUMNET8 TYPE STRING,
EFFSUMNET9 TYPE STRING,
EFFSUMNET0 TYPE STRING,
KONDSUMNET TYPE STRING,
KONDTAX TYPE STRING,
KONDSTKZ TYPE STRING,
KONDSUMTOT TYPE STRING,
SKOTYPMV1 TYPE STRING,
SKOTYPMV2 TYPE STRING,
SKOTYPMV3 TYPE STRING,
SKOTYPMV4 TYPE STRING,
SKOTYPMV5 TYPE STRING,
SKOTYPMV6 TYPE STRING,
SKOTYPMV7 TYPE STRING,
SKOTYPMV8 TYPE STRING,
SKOTYPMV9 TYPE STRING,
SKOTYPMV0 TYPE STRING,
KONDSUMNETME TYPE STRING,
SKOTYPME1 TYPE STRING,
SKOTYPME2 TYPE STRING,
SKOTYPME3 TYPE STRING,
SKOTYPME4 TYPE STRING,
SKOTYPME5 TYPE STRING,
SKOTYPME6 TYPE STRING,
SKOTYPME7 TYPE STRING,
SKOTYPME8 TYPE STRING,
SKOTYPME9 TYPE STRING,
SKOTYPME0 TYPE STRING,
DERZAHL TYPE STRING,
KUNNR TYPE STRING,
SPARTNR TYPE STRING,
MADAT TYPE STRING,
MANST TYPE STRING,
MABER TYPE STRING,
MANSP TYPE STRING,
HBKID TYPE STRING,
R1DATUM TYPE STRING,
R2DATUM TYPE STRING,
KLDATUM TYPE STRING,
KOEIGR TYPE STRING,
KONTOBV TYPE STRING,
ANRED TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
NAME3 TYPE STRING,
NAME4 TYPE STRING,
STRAS TYPE STRING,
PFACH TYPE STRING,
PSTL2 TYPE STRING,
PFORT TYPE STRING,
LAND1 TYPE STRING,
PSTLZ TYPE STRING,
ORT01 TYPE STRING,
ORT02 TYPE STRING,
REGIO TYPE STRING,
SPRAS TYPE STRING,
INLND TYPE STRING,
IWUSR00 TYPE STRING,
IWUSR01 TYPE STRING,
IWUSR02 TYPE STRING,
IWUSR03 TYPE STRING,
IWUSR04 TYPE STRING,
IWUSE04 TYPE STRING,
IWUSR05 TYPE STRING,
IWUSE05 TYPE STRING,
IWUSR06 TYPE STRING,
IWUSE06 TYPE STRING,
IWUSR07 TYPE STRING,
IWUSE07 TYPE STRING,
IWUSR08 TYPE STRING,
IWUSR09 TYPE STRING,
IWUSR10 TYPE STRING,
IWUSR11 TYPE STRING,
IBUSR00 TYPE STRING,
IBUSR01 TYPE STRING,
IBUSR02 TYPE STRING,
IBUSR03 TYPE STRING,
IBUSR04 TYPE STRING,
IBUSE04 TYPE STRING,
IBUSR05 TYPE STRING,
IBUSE05 TYPE STRING,
IBUSR06 TYPE STRING,
IBUSE06 TYPE STRING,
IBUSR07 TYPE STRING,
IBUSE07 TYPE STRING,
IBUSR08 TYPE STRING,
IBUSR09 TYPE STRING,
IBUSR10 TYPE STRING,
IBUSR11 TYPE STRING,
IGUSR00 TYPE STRING,
IGUSR01 TYPE STRING,
IGUSR02 TYPE STRING,
IGUSR03 TYPE STRING,
IGUSR04 TYPE STRING,
IGUSE04 TYPE STRING,
IGUSR05 TYPE STRING,
IGUSE05 TYPE STRING,
IGUSR06 TYPE STRING,
IGUSE06 TYPE STRING,
IGUSR07 TYPE STRING,
IGUSE07 TYPE STRING,
IGUSR08 TYPE STRING,
IGUSR09 TYPE STRING,
IGUSR10 TYPE STRING,
IGUSR11 TYPE STRING,
IMUSR00 TYPE STRING,
IMUSR01 TYPE STRING,
IMUSR02 TYPE STRING,
IMUSR03 TYPE STRING,
IMUSR04 TYPE STRING,
IMUSE04 TYPE STRING,
IMUSR05 TYPE STRING,
IMUSE05 TYPE STRING,
IMUSR06 TYPE STRING,
IMUSE06 TYPE STRING,
IMUSR07 TYPE STRING,
IMUSE07 TYPE STRING,
IMUSR08 TYPE STRING,
IMUSR09 TYPE STRING,
IMUSR10 TYPE STRING,
IMUSR11 TYPE STRING,
IVUSR00 TYPE STRING,
IVUSR01 TYPE STRING,
IVUSR02 TYPE STRING,
IVUSR03 TYPE STRING,
IVUSR04 TYPE STRING,
IVUSE04 TYPE STRING,
IVUSR05 TYPE STRING,
IVUSE05 TYPE STRING,
IVUSR06 TYPE STRING,
IVUSE06 TYPE STRING,
IVUSR07 TYPE STRING,
IVUSE07 TYPE STRING,
IVUSR08 TYPE STRING,
IVUSR09 TYPE STRING,
IVUSR10 TYPE STRING,
IVUSR11 TYPE STRING,
USR00 TYPE STRING,
USR01 TYPE STRING,
USR02 TYPE STRING,
USR03 TYPE STRING,
USR04 TYPE STRING,
USE04 TYPE STRING,
USR05 TYPE STRING,
USE05 TYPE STRING,
USR06 TYPE STRING,
USE06 TYPE STRING,
USR07 TYPE STRING,
USE07 TYPE STRING,
USR08 TYPE STRING,
USR09 TYPE STRING,
USR10 TYPE STRING,
USR11 TYPE STRING,
FQMFLART1 TYPE STRING,
FEINS1 TYPE STRING,
FQMFLART2 TYPE STRING,
FEINS2 TYPE STRING,
FQMFLART3 TYPE STRING,
FEINS3 TYPE STRING,
FQMFLART4 TYPE STRING,
FEINS4 TYPE STRING,
FQMFLART5 TYPE STRING,
FEINS5 TYPE STRING,
FCALC1 TYPE STRING,
BABRE1 TYPE STRING,
BABREEH1 TYPE STRING,
BABRE2 TYPE STRING,
BABREEH2 TYPE STRING,
BABRE3 TYPE STRING,
BABREEH3 TYPE STRING,
BABRE4 TYPE STRING,
BABREEH4 TYPE STRING,
BABRE5 TYPE STRING,
BABREEH5 TYPE STRING,
INTRENO_IM TYPE STRING,
OBJNR_ME TYPE STRING,
INTRENO_IV TYPE STRING,
INTRENO_IW TYPE STRING,
INTRENO_IB TYPE STRING,
INTRENO_IG TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RFVIREPDATA_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_RFVIREPDATA_STR-BUKRS sy-vline 
WA_RFVIREPDATA_STR-SWENR sy-vline 
WA_RFVIREPDATA_STR-SGENR sy-vline 
WA_RFVIREPDATA_STR-SGRNR sy-vline 
WA_RFVIREPDATA_STR-SMENR sy-vline 
WA_RFVIREPDATA_STR-XMETXT sy-vline 
WA_RFVIREPDATA_STR-ME_ADR sy-vline 
WA_RFVIREPDATA_STR-SNUNR sy-vline 
WA_RFVIREPDATA_STR-SNUNRTXT sy-vline 
WA_RFVIREPDATA_STR-STATUSTXT sy-vline 
WA_RFVIREPDATA_STR-XKLEERGD sy-vline 
WA_RFVIREPDATA_STR-DSTGAB sy-vline 
WA_RFVIREPDATA_STR-DSTBIS sy-vline 
WA_RFVIREPDATA_STR-E_SMIVE sy-vline 
WA_RFVIREPDATA_STR-SMIVE sy-vline 
WA_RFVIREPDATA_STR-DMIBEG sy-vline 
WA_RFVIREPDATA_STR-DMIEND sy-vline 
WA_RFVIREPDATA_STR-DKUEZU sy-vline 
WA_RFVIREPDATA_STR-LINEK sy-vline 
WA_RFVIREPDATA_STR-AZIMM sy-vline 
WA_RFVIREPDATA_STR-AHALBZI sy-vline 
WA_RFVIREPDATA_STR-SFLART sy-vline 
WA_RFVIREPDATA_STR-FQMFLART sy-vline 
WA_RFVIREPDATA_STR-FEINS sy-vline 
WA_RFVIREPDATA_STR-XKFLART sy-vline 
WA_RFVIREPDATA_STR-SWHRKOND sy-vline 
WA_RFVIREPDATA_STR-ZLSCH sy-vline 
WA_RFVIREPDATA_STR-ZLSCHTXT sy-vline 
WA_RFVIREPDATA_STR-GZLSCH sy-vline 
WA_RFVIREPDATA_STR-GZLSCHTXT sy-vline 
WA_RFVIREPDATA_STR-SMIETSP sy-vline 
WA_RFVIREPDATA_STR-SMIETSPTXT sy-vline 
WA_RFVIREPDATA_STR-XAUSTKL sy-vline 
WA_RFVIREPDATA_STR-XAUSTKLTXT sy-vline 
WA_RFVIREPDATA_STR-XLAGE sy-vline 
WA_RFVIREPDATA_STR-XLAGETXT sy-vline 
WA_RFVIREPDATA_STR-DDATVON sy-vline 
WA_RFVIREPDATA_STR-DDATBIS sy-vline 
WA_RFVIREPDATA_STR-SAVAIL sy-vline 
WA_RFVIREPDATA_STR-XAVAIL sy-vline 
WA_RFVIREPDATA_STR-SMVART sy-vline 
WA_RFVIREPDATA_STR-SMVARTTXT sy-vline 
WA_RFVIREPDATA_STR-SMVANART sy-vline 
WA_RFVIREPDATA_STR-SMVANARTTXT sy-vline 
WA_RFVIREPDATA_STR-SKUEART sy-vline 
WA_RFVIREPDATA_STR-SKUEARTTXT sy-vline 
WA_RFVIREPDATA_STR-SKUEKEY sy-vline 
WA_RFVIREPDATA_STR-DKUEFR sy-vline 
WA_RFVIREPDATA_STR-SKUEFR sy-vline 
WA_RFVIREPDATA_STR-DEINKUE sy-vline 
WA_RFVIREPDATA_STR-JVERL sy-vline 
WA_RFVIREPDATA_STR-ANKUEN sy-vline 
WA_RFVIREPDATA_STR-VERLG sy-vline 
WA_RFVIREPDATA_STR-JKAUFOPT sy-vline 
WA_RFVIREPDATA_STR-DKAUFOPT sy-vline 
WA_RFVIREPDATA_STR-DEINZG sy-vline 
WA_RFVIREPDATA_STR-DAUSZG sy-vline 
WA_RFVIREPDATA_STR-GERSTD sy-vline 
WA_RFVIREPDATA_STR-IND_SECTOR sy-vline 
WA_RFVIREPDATA_STR-PARTFROM sy-vline 
WA_RFVIREPDATA_STR-PARTWHY sy-vline 
WA_RFVIREPDATA_STR-SSTOCKW sy-vline 
WA_RFVIREPDATA_STR-SSTOCKWTXT sy-vline 
WA_RFVIREPDATA_STR-RLGESCH sy-vline 
WA_RFVIREPDATA_STR-RLGESCHTXT sy-vline 
WA_RFVIREPDATA_STR-SGEBT sy-vline 
WA_RFVIREPDATA_STR-SGEBTTXT sy-vline 
WA_RFVIREPDATA_STR-USRSTATUS sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET sy-vline 
WA_RFVIREPDATA_STR-EFFSUMTOT sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET1 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET2 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET3 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET4 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET5 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET6 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET7 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET8 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET9 sy-vline 
WA_RFVIREPDATA_STR-EFFSUMNET0 sy-vline 
WA_RFVIREPDATA_STR-KONDSUMNET sy-vline 
WA_RFVIREPDATA_STR-KONDTAX sy-vline 
WA_RFVIREPDATA_STR-KONDSTKZ sy-vline 
WA_RFVIREPDATA_STR-KONDSUMTOT sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV1 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV2 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV3 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV4 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV5 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV6 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV7 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV8 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV9 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPMV0 sy-vline 
WA_RFVIREPDATA_STR-KONDSUMNETME sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME1 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME2 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME3 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME4 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME5 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME6 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME7 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME8 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME9 sy-vline 
WA_RFVIREPDATA_STR-SKOTYPME0 sy-vline 
WA_RFVIREPDATA_STR-DERZAHL sy-vline 
WA_RFVIREPDATA_STR-KUNNR sy-vline 
WA_RFVIREPDATA_STR-SPARTNR sy-vline 
WA_RFVIREPDATA_STR-MADAT sy-vline 
WA_RFVIREPDATA_STR-MANST sy-vline 
WA_RFVIREPDATA_STR-MABER sy-vline 
WA_RFVIREPDATA_STR-MANSP sy-vline 
WA_RFVIREPDATA_STR-HBKID sy-vline 
WA_RFVIREPDATA_STR-R1DATUM sy-vline 
WA_RFVIREPDATA_STR-R2DATUM sy-vline 
WA_RFVIREPDATA_STR-KLDATUM sy-vline 
WA_RFVIREPDATA_STR-KOEIGR sy-vline 
WA_RFVIREPDATA_STR-KONTOBV sy-vline 
WA_RFVIREPDATA_STR-ANRED sy-vline 
WA_RFVIREPDATA_STR-NAME1 sy-vline 
WA_RFVIREPDATA_STR-NAME2 sy-vline 
WA_RFVIREPDATA_STR-NAME3 sy-vline 
WA_RFVIREPDATA_STR-NAME4 sy-vline 
WA_RFVIREPDATA_STR-STRAS sy-vline 
WA_RFVIREPDATA_STR-PFACH sy-vline 
WA_RFVIREPDATA_STR-PSTL2 sy-vline 
WA_RFVIREPDATA_STR-PFORT sy-vline 
WA_RFVIREPDATA_STR-LAND1 sy-vline 
WA_RFVIREPDATA_STR-PSTLZ sy-vline 
WA_RFVIREPDATA_STR-ORT01 sy-vline 
WA_RFVIREPDATA_STR-ORT02 sy-vline 
WA_RFVIREPDATA_STR-REGIO sy-vline 
WA_RFVIREPDATA_STR-SPRAS sy-vline 
WA_RFVIREPDATA_STR-INLND sy-vline 
WA_RFVIREPDATA_STR-IWUSR00 sy-vline 
WA_RFVIREPDATA_STR-IWUSR01 sy-vline 
WA_RFVIREPDATA_STR-IWUSR02 sy-vline 
WA_RFVIREPDATA_STR-IWUSR03 sy-vline 
WA_RFVIREPDATA_STR-IWUSR04 sy-vline 
WA_RFVIREPDATA_STR-IWUSE04 sy-vline 
WA_RFVIREPDATA_STR-IWUSR05 sy-vline 
WA_RFVIREPDATA_STR-IWUSE05 sy-vline 
WA_RFVIREPDATA_STR-IWUSR06 sy-vline 
WA_RFVIREPDATA_STR-IWUSE06 sy-vline 
WA_RFVIREPDATA_STR-IWUSR07 sy-vline 
WA_RFVIREPDATA_STR-IWUSE07 sy-vline 
WA_RFVIREPDATA_STR-IWUSR08 sy-vline 
WA_RFVIREPDATA_STR-IWUSR09 sy-vline 
WA_RFVIREPDATA_STR-IWUSR10 sy-vline 
WA_RFVIREPDATA_STR-IWUSR11 sy-vline 
WA_RFVIREPDATA_STR-IBUSR00 sy-vline 
WA_RFVIREPDATA_STR-IBUSR01 sy-vline 
WA_RFVIREPDATA_STR-IBUSR02 sy-vline 
WA_RFVIREPDATA_STR-IBUSR03 sy-vline 
WA_RFVIREPDATA_STR-IBUSR04 sy-vline 
WA_RFVIREPDATA_STR-IBUSE04 sy-vline 
WA_RFVIREPDATA_STR-IBUSR05 sy-vline 
WA_RFVIREPDATA_STR-IBUSE05 sy-vline 
WA_RFVIREPDATA_STR-IBUSR06 sy-vline 
WA_RFVIREPDATA_STR-IBUSE06 sy-vline 
WA_RFVIREPDATA_STR-IBUSR07 sy-vline 
WA_RFVIREPDATA_STR-IBUSE07 sy-vline 
WA_RFVIREPDATA_STR-IBUSR08 sy-vline 
WA_RFVIREPDATA_STR-IBUSR09 sy-vline 
WA_RFVIREPDATA_STR-IBUSR10 sy-vline 
WA_RFVIREPDATA_STR-IBUSR11 sy-vline 
WA_RFVIREPDATA_STR-IGUSR00 sy-vline 
WA_RFVIREPDATA_STR-IGUSR01 sy-vline 
WA_RFVIREPDATA_STR-IGUSR02 sy-vline 
WA_RFVIREPDATA_STR-IGUSR03 sy-vline 
WA_RFVIREPDATA_STR-IGUSR04 sy-vline 
WA_RFVIREPDATA_STR-IGUSE04 sy-vline 
WA_RFVIREPDATA_STR-IGUSR05 sy-vline 
WA_RFVIREPDATA_STR-IGUSE05 sy-vline 
WA_RFVIREPDATA_STR-IGUSR06 sy-vline 
WA_RFVIREPDATA_STR-IGUSE06 sy-vline 
WA_RFVIREPDATA_STR-IGUSR07 sy-vline 
WA_RFVIREPDATA_STR-IGUSE07 sy-vline 
WA_RFVIREPDATA_STR-IGUSR08 sy-vline 
WA_RFVIREPDATA_STR-IGUSR09 sy-vline 
WA_RFVIREPDATA_STR-IGUSR10 sy-vline 
WA_RFVIREPDATA_STR-IGUSR11 sy-vline 
WA_RFVIREPDATA_STR-IMUSR00 sy-vline 
WA_RFVIREPDATA_STR-IMUSR01 sy-vline 
WA_RFVIREPDATA_STR-IMUSR02 sy-vline 
WA_RFVIREPDATA_STR-IMUSR03 sy-vline 
WA_RFVIREPDATA_STR-IMUSR04 sy-vline 
WA_RFVIREPDATA_STR-IMUSE04 sy-vline 
WA_RFVIREPDATA_STR-IMUSR05 sy-vline 
WA_RFVIREPDATA_STR-IMUSE05 sy-vline 
WA_RFVIREPDATA_STR-IMUSR06 sy-vline 
WA_RFVIREPDATA_STR-IMUSE06 sy-vline 
WA_RFVIREPDATA_STR-IMUSR07 sy-vline 
WA_RFVIREPDATA_STR-IMUSE07 sy-vline 
WA_RFVIREPDATA_STR-IMUSR08 sy-vline 
WA_RFVIREPDATA_STR-IMUSR09 sy-vline 
WA_RFVIREPDATA_STR-IMUSR10 sy-vline 
WA_RFVIREPDATA_STR-IMUSR11 sy-vline 
WA_RFVIREPDATA_STR-IVUSR00 sy-vline 
WA_RFVIREPDATA_STR-IVUSR01 sy-vline 
WA_RFVIREPDATA_STR-IVUSR02 sy-vline 
WA_RFVIREPDATA_STR-IVUSR03 sy-vline 
WA_RFVIREPDATA_STR-IVUSR04 sy-vline 
WA_RFVIREPDATA_STR-IVUSE04 sy-vline 
WA_RFVIREPDATA_STR-IVUSR05 sy-vline 
WA_RFVIREPDATA_STR-IVUSE05 sy-vline 
WA_RFVIREPDATA_STR-IVUSR06 sy-vline 
WA_RFVIREPDATA_STR-IVUSE06 sy-vline 
WA_RFVIREPDATA_STR-IVUSR07 sy-vline 
WA_RFVIREPDATA_STR-IVUSE07 sy-vline 
WA_RFVIREPDATA_STR-IVUSR08 sy-vline 
WA_RFVIREPDATA_STR-IVUSR09 sy-vline 
WA_RFVIREPDATA_STR-IVUSR10 sy-vline 
WA_RFVIREPDATA_STR-IVUSR11 sy-vline 
WA_RFVIREPDATA_STR-USR00 sy-vline 
WA_RFVIREPDATA_STR-USR01 sy-vline 
WA_RFVIREPDATA_STR-USR02 sy-vline 
WA_RFVIREPDATA_STR-USR03 sy-vline 
WA_RFVIREPDATA_STR-USR04 sy-vline 
WA_RFVIREPDATA_STR-USE04 sy-vline 
WA_RFVIREPDATA_STR-USR05 sy-vline 
WA_RFVIREPDATA_STR-USE05 sy-vline 
WA_RFVIREPDATA_STR-USR06 sy-vline 
WA_RFVIREPDATA_STR-USE06 sy-vline 
WA_RFVIREPDATA_STR-USR07 sy-vline 
WA_RFVIREPDATA_STR-USE07 sy-vline 
WA_RFVIREPDATA_STR-USR08 sy-vline 
WA_RFVIREPDATA_STR-USR09 sy-vline 
WA_RFVIREPDATA_STR-USR10 sy-vline 
WA_RFVIREPDATA_STR-USR11 sy-vline 
WA_RFVIREPDATA_STR-FQMFLART1 sy-vline 
WA_RFVIREPDATA_STR-FEINS1 sy-vline 
WA_RFVIREPDATA_STR-FQMFLART2 sy-vline 
WA_RFVIREPDATA_STR-FEINS2 sy-vline 
WA_RFVIREPDATA_STR-FQMFLART3 sy-vline 
WA_RFVIREPDATA_STR-FEINS3 sy-vline 
WA_RFVIREPDATA_STR-FQMFLART4 sy-vline 
WA_RFVIREPDATA_STR-FEINS4 sy-vline 
WA_RFVIREPDATA_STR-FQMFLART5 sy-vline 
WA_RFVIREPDATA_STR-FEINS5 sy-vline 
WA_RFVIREPDATA_STR-FCALC1 sy-vline 
WA_RFVIREPDATA_STR-BABRE1 sy-vline 
WA_RFVIREPDATA_STR-BABREEH1 sy-vline 
WA_RFVIREPDATA_STR-BABRE2 sy-vline 
WA_RFVIREPDATA_STR-BABREEH2 sy-vline 
WA_RFVIREPDATA_STR-BABRE3 sy-vline 
WA_RFVIREPDATA_STR-BABREEH3 sy-vline 
WA_RFVIREPDATA_STR-BABRE4 sy-vline 
WA_RFVIREPDATA_STR-BABREEH4 sy-vline 
WA_RFVIREPDATA_STR-BABRE5 sy-vline 
WA_RFVIREPDATA_STR-BABREEH5 sy-vline 
WA_RFVIREPDATA_STR-INTRENO_IM sy-vline 
WA_RFVIREPDATA_STR-OBJNR_ME sy-vline 
WA_RFVIREPDATA_STR-INTRENO_IV sy-vline 
WA_RFVIREPDATA_STR-INTRENO_IW sy-vline 
WA_RFVIREPDATA_STR-INTRENO_IB sy-vline 
WA_RFVIREPDATA_STR-INTRENO_IG sy-vline      INTO ld_text SEPARATED BY SPACE.

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