ABAP Select data from SAP table IFMREPGAX 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 IFMREPGAX 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 IFMREPGAX. 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 IFMREPGAX 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_IFMREPGAX TYPE STANDARD TABLE OF IFMREPGAX,
      WA_IFMREPGAX TYPE IFMREPGAX,
      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: <IFMREPGAX> TYPE IFMREPGAX.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM IFMREPGAX
*  INTO TABLE @DATA(IT_IFMREPGAX2).
*--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_IFMREPGAX INDEX 1 INTO DATA(WA_IFMREPGAX2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<IFMREPGAX>-FIKRS = 1.
<IFMREPGAX>-FONDS = 1.
<IFMREPGAX>-FICTR = 1.
<IFMREPGAX>-FIPEX = 1.
<IFMREPGAX>-FNAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_IFMREPGAX-SPONSOR, sy-vline,
  WA_IFMREPGAX-FINUSE, sy-vline,
  WA_IFMREPGAX-FUND_TYPE, sy-vline,
  WA_IFMREPGAX-FUND_TYPET, sy-vline,
  WA_IFMREPGAX-CNAME, sy-vline,
  WA_IFMREPGAX-BOSSID, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_IFMREPGAX 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_IFMREPGAX 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_IFMREPGAX INTO WA_IFMREPGAX.


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

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

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

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

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

*Conversion exit PERI7, internal->external for field PERIO7
CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT'
  EXPORTING
    input =                      WA_IFMREPGAX-PERIO7
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_IFMREPGAX-PERIO7.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ABPSN, internal->external for field POSID
CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT'
  EXPORTING
    input =                      WA_IFMREPGAX-POSID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_IFMREPGAX-POSID.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit NUMCV, internal->external for field VORNR
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_IFMREPGAX-VORNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_IFMREPGAX-VORNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit GJAHR, internal->external for field FMXYEAR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_IFMREPGAX-FMXYEAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_IFMREPGAX-FMXYEAR.
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_IFMREPGAX_STR, 
FIKRS TYPE STRING,
FONDS TYPE STRING,
FICTR TYPE STRING,
FIPEX TYPE STRING,
FNAME TYPE STRING,
SPONSOR TYPE STRING,
FINUSE TYPE STRING,
FUND_TYPE TYPE STRING,
FUND_TYPET TYPE STRING,
CNAME TYPE STRING,
BOSSID TYPE STRING,
PNAME TYPE STRING,
POTYP TYPE STRING,
FIVOR TYPE STRING,
REFBN TYPE STRING,
RFPOS TYPE STRING,
RFORG TYPE STRING,
WRTTP TYPE STRING,
WTEXT TYPE STRING,
BTART TYPE STRING,
BTEXT TYPE STRING,
STATS TYPE STRING,
STATT TYPE STRING,
GJAHR TYPE STRING,
PERIO TYPE STRING,
PERIO7 TYPE STRING,
BUDAT TYPE STRING,
ZHLDT TYPE STRING,
TRANR TYPE STRING,
CTRNR TYPE STRING,
BUKRS TYPE STRING,
HKONT TYPE STRING,
SGTXT TYPE STRING,
LIFNR TYPE STRING,
FAREA TYPE STRING,
FTEXT TYPE STRING,
MEASURE TYPE STRING,
ME_SHORT_DESC TYPE STRING,
ME_DESCRIPTION TYPE STRING,
GRANT_NBR TYPE STRING,
GRANT_TYPE TYPE STRING,
GM_SHORT_DESC TYPE STRING,
GM_DESCRIPTION TYPE STRING,
CFLEV TYPE STRING,
USERDIM TYPE STRING,
VREFBT TYPE STRING,
VRFPOS TYPE STRING,
VREFBN TYPE STRING,
KOKRS TYPE STRING,
KOSTL TYPE STRING,
KTEXT TYPE STRING,
AUFNR TYPE STRING,
ATEXT TYPE STRING,
POSID TYPE STRING,
POST1 TYPE STRING,
PRCTR TYPE STRING,
PRCTRT TYPE STRING,
AWTYP TYPE STRING,
AWREF TYPE STRING,
AWORG TYPE STRING,
AWSYS TYPE STRING,
VOGJAHR TYPE STRING,
VOBELNR TYPE STRING,
VOBUZEI TYPE STRING,
KNGJAHR TYPE STRING,
KUNNR TYPE STRING,
SORTLK TYPE STRING,
SORTLL TYPE STRING,
CF_FLAG TYPE STRING,
VRGNG TYPE STRING,
VTEXT TYPE STRING,
FWAER TYPE STRING,
FKBTRC TYPE STRING,
FKBTRP TYPE STRING,
TWAER TYPE STRING,
TRBTRC TYPE STRING,
TRBTRP TYPE STRING,
FKBTRW TYPE STRING,
TRBTRW TYPE STRING,
LOTKZ TYPE STRING,
BSTAT TYPE STRING,
BLART TYPE STRING,
BLDAT TYPE STRING,
MONAT TYPE STRING,
WWERT TYPE STRING,
CPUDT TYPE STRING,
CPUTM TYPE STRING,
AEDAT TYPE STRING,
USNAM TYPE STRING,
TCODE TYPE STRING,
BLDOCDATE TYPE STRING,
BVORG TYPE STRING,
XBLNR TYPE STRING,
BKTXT TYPE STRING,
KURSF TYPE STRING,
XFRGE TYPE STRING,
XPRFG TYPE STRING,
USUPD TYPE STRING,
PSOTY TYPE STRING,
PSOAK TYPE STRING,
PSOKS TYPE STRING,
STGRD TYPE STRING,
PSOSG TYPE STRING,
PSOFN TYPE STRING,
INTFORM TYPE STRING,
INTDATE TYPE STRING,
DBBLG TYPE STRING,
XWFFR TYPE STRING,
FRWEG TYPE STRING,
VBUND TYPE STRING,
USCMP TYPE STRING,
USREL TYPE STRING,
WSKTO TYPE STRING,
SKNTO TYPE STRING,
ERLKZ TYPE STRING,
UMSKZ TYPE STRING,
ZLSCH TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
ANBWA TYPE STRING,
BZDAT TYPE STRING,
ZLSPR TYPE STRING,
ZFBDT TYPE STRING,
MSCHL TYPE STRING,
MANSP TYPE STRING,
EMPFB TYPE STRING,
BVTYP TYPE STRING,
MABER TYPE STRING,
ZINKZ TYPE STRING,
ZTERM TYPE STRING,
KIDNO TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
NAME3 TYPE STRING,
NAME4 TYPE STRING,
PSTLZ TYPE STRING,
LAND1 TYPE STRING,
PFACH TYPE STRING,
BANKL TYPE STRING,
BANKS TYPE STRING,
REGIO TYPE STRING,
BANKN TYPE STRING,
ORT01 TYPE STRING,
STRAS TYPE STRING,
STCD1 TYPE STRING,
STCD2 TYPE STRING,
MCOD1 TYPE STRING,
PSOIS TYPE STRING,
PSOFG TYPE STRING,
PSON1 TYPE STRING,
PSON2 TYPE STRING,
PSON3 TYPE STRING,
XEZER TYPE STRING,
KOINH TYPE STRING,
XREF1 TYPE STRING,
XREF2 TYPE STRING,
PSOVN TYPE STRING,
PSOTL TYPE STRING,
PAYFLG TYPE STRING,
RDIFF TYPE STRING,
NPLNR TYPE STRING,
FMBELNR TYPE STRING,
KNBELNR TYPE STRING,
RFSYS TYPE STRING,
PSOBT TYPE STRING,
RFKNT TYPE STRING,
RFTYP TYPE STRING,
GNJHR TYPE STRING,
VORNR TYPE STRING,
RFETE TYPE STRING,
KNBUZEI TYPE STRING,
REFBT TYPE STRING,
CFCNT TYPE STRING,
CFSTAT TYPE STRING,
RRCTY TYPE STRING,
LOEKZ TYPE STRING,
XREVS TYPE STRING,
BUDGET_PD TYPE STRING,
BUDGET_PD_NAME TYPE STRING,
BKONT TYPE STRING,
IBAN TYPE STRING,
SWIFT TYPE STRING,
BUS_AREA TYPE STRING,
FMXDOCNR TYPE STRING,
FMXYEAR TYPE STRING,
FMXDOCLN TYPE STRING,
FMXZEKKN TYPE STRING,
FMVOR TYPE STRING,
FMCPUDT TYPE STRING,
FMCPUTM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_IFMREPGAX_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_IFMREPGAX_STR-FIKRS sy-vline 
WA_IFMREPGAX_STR-FONDS sy-vline 
WA_IFMREPGAX_STR-FICTR sy-vline 
WA_IFMREPGAX_STR-FIPEX sy-vline 
WA_IFMREPGAX_STR-FNAME sy-vline 
WA_IFMREPGAX_STR-SPONSOR sy-vline 
WA_IFMREPGAX_STR-FINUSE sy-vline 
WA_IFMREPGAX_STR-FUND_TYPE sy-vline 
WA_IFMREPGAX_STR-FUND_TYPET sy-vline 
WA_IFMREPGAX_STR-CNAME sy-vline 
WA_IFMREPGAX_STR-BOSSID sy-vline 
WA_IFMREPGAX_STR-PNAME sy-vline 
WA_IFMREPGAX_STR-POTYP sy-vline 
WA_IFMREPGAX_STR-FIVOR sy-vline 
WA_IFMREPGAX_STR-REFBN sy-vline 
WA_IFMREPGAX_STR-RFPOS sy-vline 
WA_IFMREPGAX_STR-RFORG sy-vline 
WA_IFMREPGAX_STR-WRTTP sy-vline 
WA_IFMREPGAX_STR-WTEXT sy-vline 
WA_IFMREPGAX_STR-BTART sy-vline 
WA_IFMREPGAX_STR-BTEXT sy-vline 
WA_IFMREPGAX_STR-STATS sy-vline 
WA_IFMREPGAX_STR-STATT sy-vline 
WA_IFMREPGAX_STR-GJAHR sy-vline 
WA_IFMREPGAX_STR-PERIO sy-vline 
WA_IFMREPGAX_STR-PERIO7 sy-vline 
WA_IFMREPGAX_STR-BUDAT sy-vline 
WA_IFMREPGAX_STR-ZHLDT sy-vline 
WA_IFMREPGAX_STR-TRANR sy-vline 
WA_IFMREPGAX_STR-CTRNR sy-vline 
WA_IFMREPGAX_STR-BUKRS sy-vline 
WA_IFMREPGAX_STR-HKONT sy-vline 
WA_IFMREPGAX_STR-SGTXT sy-vline 
WA_IFMREPGAX_STR-LIFNR sy-vline 
WA_IFMREPGAX_STR-FAREA sy-vline 
WA_IFMREPGAX_STR-FTEXT sy-vline 
WA_IFMREPGAX_STR-MEASURE sy-vline 
WA_IFMREPGAX_STR-ME_SHORT_DESC sy-vline 
WA_IFMREPGAX_STR-ME_DESCRIPTION sy-vline 
WA_IFMREPGAX_STR-GRANT_NBR sy-vline 
WA_IFMREPGAX_STR-GRANT_TYPE sy-vline 
WA_IFMREPGAX_STR-GM_SHORT_DESC sy-vline 
WA_IFMREPGAX_STR-GM_DESCRIPTION sy-vline 
WA_IFMREPGAX_STR-CFLEV sy-vline 
WA_IFMREPGAX_STR-USERDIM sy-vline 
WA_IFMREPGAX_STR-VREFBT sy-vline 
WA_IFMREPGAX_STR-VRFPOS sy-vline 
WA_IFMREPGAX_STR-VREFBN sy-vline 
WA_IFMREPGAX_STR-KOKRS sy-vline 
WA_IFMREPGAX_STR-KOSTL sy-vline 
WA_IFMREPGAX_STR-KTEXT sy-vline 
WA_IFMREPGAX_STR-AUFNR sy-vline 
WA_IFMREPGAX_STR-ATEXT sy-vline 
WA_IFMREPGAX_STR-POSID sy-vline 
WA_IFMREPGAX_STR-POST1 sy-vline 
WA_IFMREPGAX_STR-PRCTR sy-vline 
WA_IFMREPGAX_STR-PRCTRT sy-vline 
WA_IFMREPGAX_STR-AWTYP sy-vline 
WA_IFMREPGAX_STR-AWREF sy-vline 
WA_IFMREPGAX_STR-AWORG sy-vline 
WA_IFMREPGAX_STR-AWSYS sy-vline 
WA_IFMREPGAX_STR-VOGJAHR sy-vline 
WA_IFMREPGAX_STR-VOBELNR sy-vline 
WA_IFMREPGAX_STR-VOBUZEI sy-vline 
WA_IFMREPGAX_STR-KNGJAHR sy-vline 
WA_IFMREPGAX_STR-KUNNR sy-vline 
WA_IFMREPGAX_STR-SORTLK sy-vline 
WA_IFMREPGAX_STR-SORTLL sy-vline 
WA_IFMREPGAX_STR-CF_FLAG sy-vline 
WA_IFMREPGAX_STR-VRGNG sy-vline 
WA_IFMREPGAX_STR-VTEXT sy-vline 
WA_IFMREPGAX_STR-FWAER sy-vline 
WA_IFMREPGAX_STR-FKBTRC sy-vline 
WA_IFMREPGAX_STR-FKBTRP sy-vline 
WA_IFMREPGAX_STR-TWAER sy-vline 
WA_IFMREPGAX_STR-TRBTRC sy-vline 
WA_IFMREPGAX_STR-TRBTRP sy-vline 
WA_IFMREPGAX_STR-FKBTRW sy-vline 
WA_IFMREPGAX_STR-TRBTRW sy-vline 
WA_IFMREPGAX_STR-LOTKZ sy-vline 
WA_IFMREPGAX_STR-BSTAT sy-vline 
WA_IFMREPGAX_STR-BLART sy-vline 
WA_IFMREPGAX_STR-BLDAT sy-vline 
WA_IFMREPGAX_STR-MONAT sy-vline 
WA_IFMREPGAX_STR-WWERT sy-vline 
WA_IFMREPGAX_STR-CPUDT sy-vline 
WA_IFMREPGAX_STR-CPUTM sy-vline 
WA_IFMREPGAX_STR-AEDAT sy-vline 
WA_IFMREPGAX_STR-USNAM sy-vline 
WA_IFMREPGAX_STR-TCODE sy-vline 
WA_IFMREPGAX_STR-BLDOCDATE sy-vline 
WA_IFMREPGAX_STR-BVORG sy-vline 
WA_IFMREPGAX_STR-XBLNR sy-vline 
WA_IFMREPGAX_STR-BKTXT sy-vline 
WA_IFMREPGAX_STR-KURSF sy-vline 
WA_IFMREPGAX_STR-XFRGE sy-vline 
WA_IFMREPGAX_STR-XPRFG sy-vline 
WA_IFMREPGAX_STR-USUPD sy-vline 
WA_IFMREPGAX_STR-PSOTY sy-vline 
WA_IFMREPGAX_STR-PSOAK sy-vline 
WA_IFMREPGAX_STR-PSOKS sy-vline 
WA_IFMREPGAX_STR-STGRD sy-vline 
WA_IFMREPGAX_STR-PSOSG sy-vline 
WA_IFMREPGAX_STR-PSOFN sy-vline 
WA_IFMREPGAX_STR-INTFORM sy-vline 
WA_IFMREPGAX_STR-INTDATE sy-vline 
WA_IFMREPGAX_STR-DBBLG sy-vline 
WA_IFMREPGAX_STR-XWFFR sy-vline 
WA_IFMREPGAX_STR-FRWEG sy-vline 
WA_IFMREPGAX_STR-VBUND sy-vline 
WA_IFMREPGAX_STR-USCMP sy-vline 
WA_IFMREPGAX_STR-USREL sy-vline 
WA_IFMREPGAX_STR-WSKTO sy-vline 
WA_IFMREPGAX_STR-SKNTO sy-vline 
WA_IFMREPGAX_STR-ERLKZ sy-vline 
WA_IFMREPGAX_STR-UMSKZ sy-vline 
WA_IFMREPGAX_STR-ZLSCH sy-vline 
WA_IFMREPGAX_STR-ANLN1 sy-vline 
WA_IFMREPGAX_STR-ANLN2 sy-vline 
WA_IFMREPGAX_STR-ANBWA sy-vline 
WA_IFMREPGAX_STR-BZDAT sy-vline 
WA_IFMREPGAX_STR-ZLSPR sy-vline 
WA_IFMREPGAX_STR-ZFBDT sy-vline 
WA_IFMREPGAX_STR-MSCHL sy-vline 
WA_IFMREPGAX_STR-MANSP sy-vline 
WA_IFMREPGAX_STR-EMPFB sy-vline 
WA_IFMREPGAX_STR-BVTYP sy-vline 
WA_IFMREPGAX_STR-MABER sy-vline 
WA_IFMREPGAX_STR-ZINKZ sy-vline 
WA_IFMREPGAX_STR-ZTERM sy-vline 
WA_IFMREPGAX_STR-KIDNO sy-vline 
WA_IFMREPGAX_STR-NAME1 sy-vline 
WA_IFMREPGAX_STR-NAME2 sy-vline 
WA_IFMREPGAX_STR-NAME3 sy-vline 
WA_IFMREPGAX_STR-NAME4 sy-vline 
WA_IFMREPGAX_STR-PSTLZ sy-vline 
WA_IFMREPGAX_STR-LAND1 sy-vline 
WA_IFMREPGAX_STR-PFACH sy-vline 
WA_IFMREPGAX_STR-BANKL sy-vline 
WA_IFMREPGAX_STR-BANKS sy-vline 
WA_IFMREPGAX_STR-REGIO sy-vline 
WA_IFMREPGAX_STR-BANKN sy-vline 
WA_IFMREPGAX_STR-ORT01 sy-vline 
WA_IFMREPGAX_STR-STRAS sy-vline 
WA_IFMREPGAX_STR-STCD1 sy-vline 
WA_IFMREPGAX_STR-STCD2 sy-vline 
WA_IFMREPGAX_STR-MCOD1 sy-vline 
WA_IFMREPGAX_STR-PSOIS sy-vline 
WA_IFMREPGAX_STR-PSOFG sy-vline 
WA_IFMREPGAX_STR-PSON1 sy-vline 
WA_IFMREPGAX_STR-PSON2 sy-vline 
WA_IFMREPGAX_STR-PSON3 sy-vline 
WA_IFMREPGAX_STR-XEZER sy-vline 
WA_IFMREPGAX_STR-KOINH sy-vline 
WA_IFMREPGAX_STR-XREF1 sy-vline 
WA_IFMREPGAX_STR-XREF2 sy-vline 
WA_IFMREPGAX_STR-PSOVN sy-vline 
WA_IFMREPGAX_STR-PSOTL sy-vline 
WA_IFMREPGAX_STR-PAYFLG sy-vline 
WA_IFMREPGAX_STR-RDIFF sy-vline 
WA_IFMREPGAX_STR-NPLNR sy-vline 
WA_IFMREPGAX_STR-FMBELNR sy-vline 
WA_IFMREPGAX_STR-KNBELNR sy-vline 
WA_IFMREPGAX_STR-RFSYS sy-vline 
WA_IFMREPGAX_STR-PSOBT sy-vline 
WA_IFMREPGAX_STR-RFKNT sy-vline 
WA_IFMREPGAX_STR-RFTYP sy-vline 
WA_IFMREPGAX_STR-GNJHR sy-vline 
WA_IFMREPGAX_STR-VORNR sy-vline 
WA_IFMREPGAX_STR-RFETE sy-vline 
WA_IFMREPGAX_STR-KNBUZEI sy-vline 
WA_IFMREPGAX_STR-REFBT sy-vline 
WA_IFMREPGAX_STR-CFCNT sy-vline 
WA_IFMREPGAX_STR-CFSTAT sy-vline 
WA_IFMREPGAX_STR-RRCTY sy-vline 
WA_IFMREPGAX_STR-LOEKZ sy-vline 
WA_IFMREPGAX_STR-XREVS sy-vline 
WA_IFMREPGAX_STR-BUDGET_PD sy-vline 
WA_IFMREPGAX_STR-BUDGET_PD_NAME sy-vline 
WA_IFMREPGAX_STR-BKONT sy-vline 
WA_IFMREPGAX_STR-IBAN sy-vline 
WA_IFMREPGAX_STR-SWIFT sy-vline 
WA_IFMREPGAX_STR-BUS_AREA sy-vline 
WA_IFMREPGAX_STR-FMXDOCNR sy-vline 
WA_IFMREPGAX_STR-FMXYEAR sy-vline 
WA_IFMREPGAX_STR-FMXDOCLN sy-vline 
WA_IFMREPGAX_STR-FMXZEKKN sy-vline 
WA_IFMREPGAX_STR-FMVOR sy-vline 
WA_IFMREPGAX_STR-FMCPUDT sy-vline 
WA_IFMREPGAX_STR-FMCPUTM sy-vline      INTO ld_text SEPARATED BY SPACE.

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