ABAP Select data from SAP table MCRBCHAR 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 MCRBCHAR 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 MCRBCHAR. 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 MCRBCHAR 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_MCRBCHAR TYPE STANDARD TABLE OF MCRBCHAR,
      WA_MCRBCHAR TYPE MCRBCHAR,
      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: <MCRBCHAR> TYPE MCRBCHAR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MCRBCHAR
*  INTO TABLE @DATA(IT_MCRBCHAR2).
*--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_MCRBCHAR INDEX 1 INTO DATA(WA_MCRBCHAR2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MCRBCHAR>-MANDT = 1.
<MCRBCHAR>-BELNR = 1.
<MCRBCHAR>-GJAHR = 1.
<MCRBCHAR>-BLART = 1.
<MCRBCHAR>-BLDAT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MCRBCHAR-BUDAT, sy-vline,
  WA_MCRBCHAR-USNAM, sy-vline,
  WA_MCRBCHAR-TCODE, sy-vline,
  WA_MCRBCHAR-CPUDT, sy-vline,
  WA_MCRBCHAR-CPUTM, sy-vline,
  WA_MCRBCHAR-VGART, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MCRBCHAR 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_MCRBCHAR 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_MCRBCHAR INTO WA_MCRBCHAR.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit FMCIS, internal->external for field FIPOS
CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT'
  EXPORTING
    input =                      WA_MCRBCHAR-FIPOS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCRBCHAR-FIPOS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit ABPSP, internal->external for field PS_PSP_PNR
CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT'
  EXPORTING
    input =                      WA_MCRBCHAR-PS_PSP_PNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCRBCHAR-PS_PSP_PNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field BASME
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_MCRBCHAR-BASME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCRBCHAR-BASME.
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_MCRBCHAR_STR, 
MANDT TYPE STRING,
BELNR TYPE STRING,
GJAHR TYPE STRING,
BLART TYPE STRING,
BLDAT TYPE STRING,
BUDAT TYPE STRING,
USNAM TYPE STRING,
TCODE TYPE STRING,
CPUDT TYPE STRING,
CPUTM TYPE STRING,
VGART TYPE STRING,
WAERS TYPE STRING,
KURSF TYPE STRING,
MWSKZ1 TYPE STRING,
MWSKZ2 TYPE STRING,
ZTERM TYPE STRING,
ZBD1T TYPE STRING,
ZBD1P TYPE STRING,
ZBD2T TYPE STRING,
ZBD2P TYPE STRING,
ZBD3T TYPE STRING,
XRECH TYPE STRING,
BKTXT TYPE STRING,
SAPRL TYPE STRING,
LOGSYS TYPE STRING,
XMWST TYPE STRING,
STBLG TYPE STRING,
STJAH TYPE STRING,
MWSKZ_BNK TYPE STRING,
TXJCD_BNK TYPE STRING,
IVTYP TYPE STRING,
XRBTX TYPE STRING,
REPART TYPE STRING,
RBSTAT TYPE STRING,
KNUMVE TYPE STRING,
KNUMVL TYPE STRING,
XAUTAKZ TYPE STRING,
ESRNR TYPE STRING,
ESRPZ TYPE STRING,
ESRRE TYPE STRING,
QSSKZ TYPE STRING,
DIEKZ TYPE STRING,
LANDL TYPE STRING,
LZBKZ TYPE STRING,
TXKRS TYPE STRING,
EMPFB TYPE STRING,
BVTYP TYPE STRING,
HBKID TYPE STRING,
ZLSPR TYPE STRING,
ZLSCH TYPE STRING,
ZFBDT TYPE STRING,
KIDNO TYPE STRING,
REBZG TYPE STRING,
REBZJ TYPE STRING,
XINVE TYPE STRING,
EGMLD TYPE STRING,
XEGDR TYPE STRING,
J_1BNFTYPE TYPE STRING,
BRNCH TYPE STRING,
ERFPR TYPE STRING,
SECCO TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
NAME3 TYPE STRING,
NAME4 TYPE STRING,
PSTLZ TYPE STRING,
ORT01 TYPE STRING,
LAND1 TYPE STRING,
STRAS TYPE STRING,
PFACH TYPE STRING,
PSTL2 TYPE STRING,
PSKTO TYPE STRING,
BANKN TYPE STRING,
BANKL TYPE STRING,
BANKS TYPE STRING,
STCD1 TYPE STRING,
STCD2 TYPE STRING,
STKZU TYPE STRING,
STKZA TYPE STRING,
REGIO TYPE STRING,
BKONT TYPE STRING,
DTAWS TYPE STRING,
DTAMS TYPE STRING,
SPRAS TYPE STRING,
XCPDK TYPE STRING,
EMPFG TYPE STRING,
FITYP TYPE STRING,
STCDT TYPE STRING,
STKZN TYPE STRING,
STCD3 TYPE STRING,
STCD4 TYPE STRING,
BKREF TYPE STRING,
J_1KFREPRE TYPE STRING,
J_1KFTBUS TYPE STRING,
J_1KFTIND TYPE STRING,
ANRED TYPE STRING,
STCEG TYPE STRING,
ERNAME TYPE STRING,
REINDAT TYPE STRING,
UZAWE TYPE STRING,
FDLEV TYPE STRING,
FDTAG TYPE STRING,
ZBFIX TYPE STRING,
FRGKZ TYPE STRING,
ERFNAM TYPE STRING,
BUPLA TYPE STRING,
FILKD TYPE STRING,
LOTKZ TYPE STRING,
PREPAY_STATUS TYPE STRING,
ASSIGN_STATUS TYPE STRING,
ASSIGN_NEXT_DATE TYPE STRING,
ASSIGN_END_DATE TYPE STRING,
MRM_ZLSPR TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
MATNR TYPE STRING,
BWKEY TYPE STRING,
BWTAR TYPE STRING,
WERKS TYPE STRING,
BSTME TYPE STRING,
PSTYP TYPE STRING,
KNTTP TYPE STRING,
BKLAS TYPE STRING,
EREKZ TYPE STRING,
EXKBE TYPE STRING,
XEKBZ TYPE STRING,
TBTKZ TYPE STRING,
SPGRP TYPE STRING,
SPGRM TYPE STRING,
SPGRT TYPE STRING,
SPGRG TYPE STRING,
SPGRV TYPE STRING,
SPGRQ TYPE STRING,
SPGRC TYPE STRING,
BUSTW TYPE STRING,
XBLNR TYPE STRING,
XRUEB TYPE STRING,
KSCHL TYPE STRING,
XLIFO TYPE STRING,
LFBNR TYPE STRING,
LFGJA TYPE STRING,
LFPOS TYPE STRING,
MATBF TYPE STRING,
LFEHL TYPE STRING,
GRICD TYPE STRING,
GRIRG TYPE STRING,
GITYP TYPE STRING,
PACKNO TYPE STRING,
INTROW TYPE STRING,
KZMEK TYPE STRING,
MRMOK TYPE STRING,
STUNR TYPE STRING,
ZAEHK TYPE STRING,
WEREC TYPE STRING,
LIFNR TYPE STRING,
FRBNR TYPE STRING,
BPUMZ TYPE STRING,
BPUMN TYPE STRING,
AFNAM TYPE STRING,
EKGRP TYPE STRING,
FKNUM TYPE STRING,
FKPOS TYPE STRING,
FPLNR TYPE STRING,
HWAER TYPE STRING,
LEBRE TYPE STRING,
MATKL TYPE STRING,
PEINH TYPE STRING,
REPOS TYPE STRING,
RETPO TYPE STRING,
TXZ01 TYPE STRING,
WEBRE TYPE STRING,
ERNAM TYPE STRING,
EKORG TYPE STRING,
LIFNR2 TYPE STRING,
KZBWS TYPE STRING,
KTPNR TYPE STRING,
KONNR TYPE STRING,
WEUNB TYPE STRING,
WEPOS TYPE STRING,
KTOPL TYPE STRING,
BEWAE TYPE STRING,
UMREZ TYPE STRING,
UMREN TYPE STRING,
SUPKZ TYPE STRING,
LAUFNAME TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
APLZL TYPE STRING,
AUFNR TYPE STRING,
DABRZ TYPE STRING,
FIPOS TYPE STRING,
FISTL TYPE STRING,
FKBER TYPE STRING,
GEBER TYPE STRING,
GRANT_NBR TYPE STRING,
GSBER TYPE STRING,
IMKEY TYPE STRING,
KOKRS TYPE STRING,
KOSTL TYPE STRING,
KSTRG TYPE STRING,
PAOBJNR TYPE STRING,
PRCTR TYPE STRING,
PS_PSP_PNR TYPE STRING,
RECID TYPE STRING,
SAKNR TYPE STRING,
SGTXT TYPE STRING,
TXJCD TYPE STRING,
VBELN TYPE STRING,
VBELP TYPE STRING,
VPTNR TYPE STRING,
MWSKZ TYPE STRING,
ZEKKN TYPE STRING,
XUNPL TYPE STRING,
LSTAR TYPE STRING,
PRZNR TYPE STRING,
AUFPL TYPE STRING,
BUKRS TYPE STRING,
SHKZG TYPE STRING,
BZDAT TYPE STRING,
XNEGP TYPE STRING,
ERLKZ TYPE STRING,
FIKRS TYPE STRING,
KBLNR TYPE STRING,
KBLPOS TYPE STRING,
PARGB TYPE STRING,
PERNR TYPE STRING,
XSKRL TYPE STRING,
NPLNR TYPE STRING,
VORNR TYPE STRING,
ZUONR TYPE STRING,
MEINS TYPE STRING,
MWART TYPE STRING,
KOART TYPE STRING,
SPGRS TYPE STRING,
BPRME TYPE STRING,
BASME TYPE STRING,
NOQUANTITY TYPE STRING,
VRTKZ TYPE STRING,
BUDGET_PD TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MCRBCHAR_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_MCRBCHAR_STR-MANDT sy-vline 
WA_MCRBCHAR_STR-BELNR sy-vline 
WA_MCRBCHAR_STR-GJAHR sy-vline 
WA_MCRBCHAR_STR-BLART sy-vline 
WA_MCRBCHAR_STR-BLDAT sy-vline 
WA_MCRBCHAR_STR-BUDAT sy-vline 
WA_MCRBCHAR_STR-USNAM sy-vline 
WA_MCRBCHAR_STR-TCODE sy-vline 
WA_MCRBCHAR_STR-CPUDT sy-vline 
WA_MCRBCHAR_STR-CPUTM sy-vline 
WA_MCRBCHAR_STR-VGART sy-vline 
WA_MCRBCHAR_STR-WAERS sy-vline 
WA_MCRBCHAR_STR-KURSF sy-vline 
WA_MCRBCHAR_STR-MWSKZ1 sy-vline 
WA_MCRBCHAR_STR-MWSKZ2 sy-vline 
WA_MCRBCHAR_STR-ZTERM sy-vline 
WA_MCRBCHAR_STR-ZBD1T sy-vline 
WA_MCRBCHAR_STR-ZBD1P sy-vline 
WA_MCRBCHAR_STR-ZBD2T sy-vline 
WA_MCRBCHAR_STR-ZBD2P sy-vline 
WA_MCRBCHAR_STR-ZBD3T sy-vline 
WA_MCRBCHAR_STR-XRECH sy-vline 
WA_MCRBCHAR_STR-BKTXT sy-vline 
WA_MCRBCHAR_STR-SAPRL sy-vline 
WA_MCRBCHAR_STR-LOGSYS sy-vline 
WA_MCRBCHAR_STR-XMWST sy-vline 
WA_MCRBCHAR_STR-STBLG sy-vline 
WA_MCRBCHAR_STR-STJAH sy-vline 
WA_MCRBCHAR_STR-MWSKZ_BNK sy-vline 
WA_MCRBCHAR_STR-TXJCD_BNK sy-vline 
WA_MCRBCHAR_STR-IVTYP sy-vline 
WA_MCRBCHAR_STR-XRBTX sy-vline 
WA_MCRBCHAR_STR-REPART sy-vline 
WA_MCRBCHAR_STR-RBSTAT sy-vline 
WA_MCRBCHAR_STR-KNUMVE sy-vline 
WA_MCRBCHAR_STR-KNUMVL sy-vline 
WA_MCRBCHAR_STR-XAUTAKZ sy-vline 
WA_MCRBCHAR_STR-ESRNR sy-vline 
WA_MCRBCHAR_STR-ESRPZ sy-vline 
WA_MCRBCHAR_STR-ESRRE sy-vline 
WA_MCRBCHAR_STR-QSSKZ sy-vline 
WA_MCRBCHAR_STR-DIEKZ sy-vline 
WA_MCRBCHAR_STR-LANDL sy-vline 
WA_MCRBCHAR_STR-LZBKZ sy-vline 
WA_MCRBCHAR_STR-TXKRS sy-vline 
WA_MCRBCHAR_STR-EMPFB sy-vline 
WA_MCRBCHAR_STR-BVTYP sy-vline 
WA_MCRBCHAR_STR-HBKID sy-vline 
WA_MCRBCHAR_STR-ZLSPR sy-vline 
WA_MCRBCHAR_STR-ZLSCH sy-vline 
WA_MCRBCHAR_STR-ZFBDT sy-vline 
WA_MCRBCHAR_STR-KIDNO sy-vline 
WA_MCRBCHAR_STR-REBZG sy-vline 
WA_MCRBCHAR_STR-REBZJ sy-vline 
WA_MCRBCHAR_STR-XINVE sy-vline 
WA_MCRBCHAR_STR-EGMLD sy-vline 
WA_MCRBCHAR_STR-XEGDR sy-vline 
WA_MCRBCHAR_STR-J_1BNFTYPE sy-vline 
WA_MCRBCHAR_STR-BRNCH sy-vline 
WA_MCRBCHAR_STR-ERFPR sy-vline 
WA_MCRBCHAR_STR-SECCO sy-vline 
WA_MCRBCHAR_STR-NAME1 sy-vline 
WA_MCRBCHAR_STR-NAME2 sy-vline 
WA_MCRBCHAR_STR-NAME3 sy-vline 
WA_MCRBCHAR_STR-NAME4 sy-vline 
WA_MCRBCHAR_STR-PSTLZ sy-vline 
WA_MCRBCHAR_STR-ORT01 sy-vline 
WA_MCRBCHAR_STR-LAND1 sy-vline 
WA_MCRBCHAR_STR-STRAS sy-vline 
WA_MCRBCHAR_STR-PFACH sy-vline 
WA_MCRBCHAR_STR-PSTL2 sy-vline 
WA_MCRBCHAR_STR-PSKTO sy-vline 
WA_MCRBCHAR_STR-BANKN sy-vline 
WA_MCRBCHAR_STR-BANKL sy-vline 
WA_MCRBCHAR_STR-BANKS sy-vline 
WA_MCRBCHAR_STR-STCD1 sy-vline 
WA_MCRBCHAR_STR-STCD2 sy-vline 
WA_MCRBCHAR_STR-STKZU sy-vline 
WA_MCRBCHAR_STR-STKZA sy-vline 
WA_MCRBCHAR_STR-REGIO sy-vline 
WA_MCRBCHAR_STR-BKONT sy-vline 
WA_MCRBCHAR_STR-DTAWS sy-vline 
WA_MCRBCHAR_STR-DTAMS sy-vline 
WA_MCRBCHAR_STR-SPRAS sy-vline 
WA_MCRBCHAR_STR-XCPDK sy-vline 
WA_MCRBCHAR_STR-EMPFG sy-vline 
WA_MCRBCHAR_STR-FITYP sy-vline 
WA_MCRBCHAR_STR-STCDT sy-vline 
WA_MCRBCHAR_STR-STKZN sy-vline 
WA_MCRBCHAR_STR-STCD3 sy-vline 
WA_MCRBCHAR_STR-STCD4 sy-vline 
WA_MCRBCHAR_STR-BKREF sy-vline 
WA_MCRBCHAR_STR-J_1KFREPRE sy-vline 
WA_MCRBCHAR_STR-J_1KFTBUS sy-vline 
WA_MCRBCHAR_STR-J_1KFTIND sy-vline 
WA_MCRBCHAR_STR-ANRED sy-vline 
WA_MCRBCHAR_STR-STCEG sy-vline 
WA_MCRBCHAR_STR-ERNAME sy-vline 
WA_MCRBCHAR_STR-REINDAT sy-vline 
WA_MCRBCHAR_STR-UZAWE sy-vline 
WA_MCRBCHAR_STR-FDLEV sy-vline 
WA_MCRBCHAR_STR-FDTAG sy-vline 
WA_MCRBCHAR_STR-ZBFIX sy-vline 
WA_MCRBCHAR_STR-FRGKZ sy-vline 
WA_MCRBCHAR_STR-ERFNAM sy-vline 
WA_MCRBCHAR_STR-BUPLA sy-vline 
WA_MCRBCHAR_STR-FILKD sy-vline 
WA_MCRBCHAR_STR-LOTKZ sy-vline 
WA_MCRBCHAR_STR-PREPAY_STATUS sy-vline 
WA_MCRBCHAR_STR-ASSIGN_STATUS sy-vline 
WA_MCRBCHAR_STR-ASSIGN_NEXT_DATE sy-vline 
WA_MCRBCHAR_STR-ASSIGN_END_DATE sy-vline 
WA_MCRBCHAR_STR-MRM_ZLSPR sy-vline 
WA_MCRBCHAR_STR-EBELN sy-vline 
WA_MCRBCHAR_STR-EBELP sy-vline 
WA_MCRBCHAR_STR-MATNR sy-vline 
WA_MCRBCHAR_STR-BWKEY sy-vline 
WA_MCRBCHAR_STR-BWTAR sy-vline 
WA_MCRBCHAR_STR-WERKS sy-vline 
WA_MCRBCHAR_STR-BSTME sy-vline 
WA_MCRBCHAR_STR-PSTYP sy-vline 
WA_MCRBCHAR_STR-KNTTP sy-vline 
WA_MCRBCHAR_STR-BKLAS sy-vline 
WA_MCRBCHAR_STR-EREKZ sy-vline 
WA_MCRBCHAR_STR-EXKBE sy-vline 
WA_MCRBCHAR_STR-XEKBZ sy-vline 
WA_MCRBCHAR_STR-TBTKZ sy-vline 
WA_MCRBCHAR_STR-SPGRP sy-vline 
WA_MCRBCHAR_STR-SPGRM sy-vline 
WA_MCRBCHAR_STR-SPGRT sy-vline 
WA_MCRBCHAR_STR-SPGRG sy-vline 
WA_MCRBCHAR_STR-SPGRV sy-vline 
WA_MCRBCHAR_STR-SPGRQ sy-vline 
WA_MCRBCHAR_STR-SPGRC sy-vline 
WA_MCRBCHAR_STR-BUSTW sy-vline 
WA_MCRBCHAR_STR-XBLNR sy-vline 
WA_MCRBCHAR_STR-XRUEB sy-vline 
WA_MCRBCHAR_STR-KSCHL sy-vline 
WA_MCRBCHAR_STR-XLIFO sy-vline 
WA_MCRBCHAR_STR-LFBNR sy-vline 
WA_MCRBCHAR_STR-LFGJA sy-vline 
WA_MCRBCHAR_STR-LFPOS sy-vline 
WA_MCRBCHAR_STR-MATBF sy-vline 
WA_MCRBCHAR_STR-LFEHL sy-vline 
WA_MCRBCHAR_STR-GRICD sy-vline 
WA_MCRBCHAR_STR-GRIRG sy-vline 
WA_MCRBCHAR_STR-GITYP sy-vline 
WA_MCRBCHAR_STR-PACKNO sy-vline 
WA_MCRBCHAR_STR-INTROW sy-vline 
WA_MCRBCHAR_STR-KZMEK sy-vline 
WA_MCRBCHAR_STR-MRMOK sy-vline 
WA_MCRBCHAR_STR-STUNR sy-vline 
WA_MCRBCHAR_STR-ZAEHK sy-vline 
WA_MCRBCHAR_STR-WEREC sy-vline 
WA_MCRBCHAR_STR-LIFNR sy-vline 
WA_MCRBCHAR_STR-FRBNR sy-vline 
WA_MCRBCHAR_STR-BPUMZ sy-vline 
WA_MCRBCHAR_STR-BPUMN sy-vline 
WA_MCRBCHAR_STR-AFNAM sy-vline 
WA_MCRBCHAR_STR-EKGRP sy-vline 
WA_MCRBCHAR_STR-FKNUM sy-vline 
WA_MCRBCHAR_STR-FKPOS sy-vline 
WA_MCRBCHAR_STR-FPLNR sy-vline 
WA_MCRBCHAR_STR-HWAER sy-vline 
WA_MCRBCHAR_STR-LEBRE sy-vline 
WA_MCRBCHAR_STR-MATKL sy-vline 
WA_MCRBCHAR_STR-PEINH sy-vline 
WA_MCRBCHAR_STR-REPOS sy-vline 
WA_MCRBCHAR_STR-RETPO sy-vline 
WA_MCRBCHAR_STR-TXZ01 sy-vline 
WA_MCRBCHAR_STR-WEBRE sy-vline 
WA_MCRBCHAR_STR-ERNAM sy-vline 
WA_MCRBCHAR_STR-EKORG sy-vline 
WA_MCRBCHAR_STR-LIFNR2 sy-vline 
WA_MCRBCHAR_STR-KZBWS sy-vline 
WA_MCRBCHAR_STR-KTPNR sy-vline 
WA_MCRBCHAR_STR-KONNR sy-vline 
WA_MCRBCHAR_STR-WEUNB sy-vline 
WA_MCRBCHAR_STR-WEPOS sy-vline 
WA_MCRBCHAR_STR-KTOPL sy-vline 
WA_MCRBCHAR_STR-BEWAE sy-vline 
WA_MCRBCHAR_STR-UMREZ sy-vline 
WA_MCRBCHAR_STR-UMREN sy-vline 
WA_MCRBCHAR_STR-SUPKZ sy-vline 
WA_MCRBCHAR_STR-LAUFNAME sy-vline 
WA_MCRBCHAR_STR-ANLN1 sy-vline 
WA_MCRBCHAR_STR-ANLN2 sy-vline 
WA_MCRBCHAR_STR-APLZL sy-vline 
WA_MCRBCHAR_STR-AUFNR sy-vline 
WA_MCRBCHAR_STR-DABRZ sy-vline 
WA_MCRBCHAR_STR-FIPOS sy-vline 
WA_MCRBCHAR_STR-FISTL sy-vline 
WA_MCRBCHAR_STR-FKBER sy-vline 
WA_MCRBCHAR_STR-GEBER sy-vline 
WA_MCRBCHAR_STR-GRANT_NBR sy-vline 
WA_MCRBCHAR_STR-GSBER sy-vline 
WA_MCRBCHAR_STR-IMKEY sy-vline 
WA_MCRBCHAR_STR-KOKRS sy-vline 
WA_MCRBCHAR_STR-KOSTL sy-vline 
WA_MCRBCHAR_STR-KSTRG sy-vline 
WA_MCRBCHAR_STR-PAOBJNR sy-vline 
WA_MCRBCHAR_STR-PRCTR sy-vline 
WA_MCRBCHAR_STR-PS_PSP_PNR sy-vline 
WA_MCRBCHAR_STR-RECID sy-vline 
WA_MCRBCHAR_STR-SAKNR sy-vline 
WA_MCRBCHAR_STR-SGTXT sy-vline 
WA_MCRBCHAR_STR-TXJCD sy-vline 
WA_MCRBCHAR_STR-VBELN sy-vline 
WA_MCRBCHAR_STR-VBELP sy-vline 
WA_MCRBCHAR_STR-VPTNR sy-vline 
WA_MCRBCHAR_STR-MWSKZ sy-vline 
WA_MCRBCHAR_STR-ZEKKN sy-vline 
WA_MCRBCHAR_STR-XUNPL sy-vline 
WA_MCRBCHAR_STR-LSTAR sy-vline 
WA_MCRBCHAR_STR-PRZNR sy-vline 
WA_MCRBCHAR_STR-AUFPL sy-vline 
WA_MCRBCHAR_STR-BUKRS sy-vline 
WA_MCRBCHAR_STR-SHKZG sy-vline 
WA_MCRBCHAR_STR-BZDAT sy-vline 
WA_MCRBCHAR_STR-XNEGP sy-vline 
WA_MCRBCHAR_STR-ERLKZ sy-vline 
WA_MCRBCHAR_STR-FIKRS sy-vline 
WA_MCRBCHAR_STR-KBLNR sy-vline 
WA_MCRBCHAR_STR-KBLPOS sy-vline 
WA_MCRBCHAR_STR-PARGB sy-vline 
WA_MCRBCHAR_STR-PERNR sy-vline 
WA_MCRBCHAR_STR-XSKRL sy-vline 
WA_MCRBCHAR_STR-NPLNR sy-vline 
WA_MCRBCHAR_STR-VORNR sy-vline 
WA_MCRBCHAR_STR-ZUONR sy-vline 
WA_MCRBCHAR_STR-MEINS sy-vline 
WA_MCRBCHAR_STR-MWART sy-vline 
WA_MCRBCHAR_STR-KOART sy-vline 
WA_MCRBCHAR_STR-SPGRS sy-vline 
WA_MCRBCHAR_STR-BPRME sy-vline 
WA_MCRBCHAR_STR-BASME sy-vline 
WA_MCRBCHAR_STR-NOQUANTITY sy-vline 
WA_MCRBCHAR_STR-VRTKZ sy-vline 
WA_MCRBCHAR_STR-BUDGET_PD sy-vline      INTO ld_text SEPARATED BY SPACE.

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