ABAP Select data from SAP table MWZDM07M2 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 MWZDM07M2 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 MWZDM07M2. 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 MWZDM07M2 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_MWZDM07M2 TYPE STANDARD TABLE OF MWZDM07M2,
      WA_MWZDM07M2 TYPE MWZDM07M2,
      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: <MWZDM07M2> TYPE MWZDM07M2.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MWZDM07M2
*  INTO TABLE @DATA(IT_MWZDM07M22).
*--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_MWZDM07M2 INDEX 1 INTO DATA(WA_MWZDM07M22).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MWZDM07M2>-MANDT = 1.
<MWZDM07M2>-MBLNR = 1.
<MWZDM07M2>-MJAHR = 1.
<MWZDM07M2>-ZEILE = 1.
<MWZDM07M2>-VBUND = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MWZDM07M2-XOWST, sy-vline,
  WA_MWZDM07M2-XPRMS, sy-vline,
  WA_MWZDM07M2-XLAUT, sy-vline,
  WA_MWZDM07M2-XWESC, sy-vline,
  WA_MWZDM07M2-KZGRU, sy-vline,
  WA_MWZDM07M2-GRTXT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MWZDM07M2 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_MWZDM07M2 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_MWZDM07M2 INTO WA_MWZDM07M2.


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

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

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

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

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

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

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

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

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

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

*Conversion exit EAN11, internal->external for field EAN11_BME
CALL FUNCTION 'CONVERSION_EXIT_EAN11_OUTPUT'
  EXPORTING
    input =                      WA_MWZDM07M2-EAN11_BME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MWZDM07M2-EAN11_BME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EAN11, internal->external for field EAN11_KON
CALL FUNCTION 'CONVERSION_EXIT_EAN11_OUTPUT'
  EXPORTING
    input =                      WA_MWZDM07M2-EAN11_KON
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MWZDM07M2-EAN11_KON.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit PERKZ, internal->external for field IPRKZ
CALL FUNCTION 'CONVERSION_EXIT_PERKZ_OUTPUT'
  EXPORTING
    input =                      WA_MWZDM07M2-IPRKZ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MWZDM07M2-IPRKZ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PERKZ, internal->external for field IPRKZ_HBD
CALL FUNCTION 'CONVERSION_EXIT_PERKZ_OUTPUT'
  EXPORTING
    input =                      WA_MWZDM07M2-IPRKZ_HBD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MWZDM07M2-IPRKZ_HBD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PERKZ, internal->external for field UMIPRKZ
CALL FUNCTION 'CONVERSION_EXIT_PERKZ_OUTPUT'
  EXPORTING
    input =                      WA_MWZDM07M2-UMIPRKZ
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MWZDM07M2-UMIPRKZ.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit ALPHA, internal->external for field KSTAR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MWZDM07M2-KSTAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MWZDM07M2-KSTAR.
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_MWZDM07M2_STR, 
MANDT TYPE STRING,
MBLNR TYPE STRING,
MJAHR TYPE STRING,
ZEILE TYPE STRING,
VBUND TYPE STRING,
XOWST TYPE STRING,
XPRMS TYPE STRING,
XLAUT TYPE STRING,
XWESC TYPE STRING,
KZGRU TYPE STRING,
GRTXT TYPE STRING,
WESCH TYPE STRING,
RECID TYPE STRING,
KASPE TYPE STRING,
KAVSP TYPE STRING,
SASPE TYPE STRING,
XSTBW TYPE STRING,
ZEILO TYPE STRING,
DIMNG TYPE STRING,
BWTOR TYPE STRING,
PRREG TYPE STRING,
KO_GSBER TYPE STRING,
KO_PARGB TYPE STRING,
XBKNG TYPE STRING,
XMCNG TYPE STRING,
XLONG TYPE STRING,
XSVNG TYPE STRING,
XSMNG TYPE STRING,
UMXBN TYPE STRING,
UMXMN TYPE STRING,
UMXLN TYPE STRING,
UMXSV TYPE STRING,
UMXSM TYPE STRING,
RESWK TYPE STRING,
LEWED TYPE STRING,
REVLV TYPE STRING,
KANBA TYPE STRING,
SERNP TYPE STRING,
UMMLM TYPE STRING,
UMKAL TYPE STRING,
VMVPR TYPE STRING,
UMVMV TYPE STRING,
ANZL1 TYPE STRING,
ANZL2 TYPE STRING,
LMEN1 TYPE STRING,
LMEN2 TYPE STRING,
LETY1 TYPE STRING,
LETY2 TYPE STRING,
IDNLF TYPE STRING,
EAN11 TYPE STRING,
SONUM TYPE STRING,
UMSON TYPE STRING,
UMHKM TYPE STRING,
UMXVK TYPE STRING,
KZMHD TYPE STRING,
MHDRZ TYPE STRING,
MHDHB TYPE STRING,
UMXCH TYPE STRING,
QM_ZUSTD TYPE STRING,
QM_UMZST TYPE STRING,
KZCLA TYPE STRING,
MHDAT TYPE STRING,
ANZSN TYPE STRING,
UMPRDHA TYPE STRING,
UMSATNR TYPE STRING,
UMBWVOR TYPE STRING,
UMBWSCL TYPE STRING,
UMSAISO TYPE STRING,
UMVOLEH TYPE STRING,
UMPLGTP TYPE STRING,
UMSERVG TYPE STRING,
EAN11_BME TYPE STRING,
EAN11_KON TYPE STRING,
EANME TYPE STRING,
CLASS TYPE STRING,
UMCLA TYPE STRING,
QMAT_INAKT TYPE STRING,
CHSMM TYPE STRING,
UMCHS TYPE STRING,
XCLAS TYPE STRING,
UMXCL TYPE STRING,
RMVCT TYPE STRING,
EK_VKWRT TYPE STRING,
EK_VKWRA TYPE STRING,
PKNUM TYPE STRING,
PKPOS TYPE STRING,
PKLVS TYPE STRING,
UMLIFCH TYPE STRING,
UMLICHA TYPE STRING,
UMLWEDT TYPE STRING,
UMVFDAT TYPE STRING,
UMHSDAT TYPE STRING,
MHDAT_OLD TYPE STRING,
UMQNDAT TYPE STRING,
XKOKO TYPE STRING,
UMAUT TYPE STRING,
TBBEL TYPE STRING,
TBBPO TYPE STRING,
TBBJR TYPE STRING,
VFMNG TYPE STRING,
CUOBJ TYPE STRING,
STDPD TYPE STRING,
TBPKZ TYPE STRING,
TAFKZ TYPE STRING,
XWART TYPE STRING,
DGLTS TYPE STRING,
UMMEN TYPE STRING,
UMXEI TYPE STRING,
DGLTP TYPE STRING,
UMKZB TYPE STRING,
UMMLA TYPE STRING,
UMSAISJ TYPE STRING,
EQUMG TYPE STRING,
XEXEQ TYPE STRING,
UMXEXEQ TYPE STRING,
GLMNG TYPE STRING,
UMKZBAA TYPE STRING,
DIRTA TYPE STRING,
UMSERNP TYPE STRING,
KZECH TYPE STRING,
FCHAR TYPE STRING,
XKCFC TYPE STRING,
KZCHP TYPE STRING,
INFNR TYPE STRING,
BWSPA TYPE STRING,
UPVOR TYPE STRING,
UPTYP TYPE STRING,
MEKOR TYPE STRING,
UEZEI TYPE STRING,
UEBPO TYPE STRING,
LWMNG TYPE STRING,
LWSBS TYPE STRING,
XWMHD TYPE STRING,
LAMNG TYPE STRING,
PRVBE TYPE STRING,
VEXVK TYPE STRING,
RBLVS TYPE STRING,
UMRBL TYPE STRING,
UMRBU TYPE STRING,
PARWK TYPE STRING,
KTOMA TYPE STRING,
XLBPD TYPE STRING,
XBNSB TYPE STRING,
XWAIT TYPE STRING,
XNOEQ TYPE STRING,
XSKNG TYPE STRING,
XSONG TYPE STRING,
XSWNG TYPE STRING,
UMXSK TYPE STRING,
UMXSO TYPE STRING,
UMXSW TYPE STRING,
XEWRX TYPE STRING,
X2FDO TYPE STRING,
UMVKW TYPE STRING,
UMVKA TYPE STRING,
XSENG TYPE STRING,
XSQNG TYPE STRING,
UMXSE TYPE STRING,
UMXSQ TYPE STRING,
AREWW TYPE STRING,
MHDLG TYPE STRING,
VWERW TYPE STRING,
KZWSO TYPE STRING,
UMATT TYPE STRING,
KZKUB TYPE STRING,
UBTYP TYPE STRING,
UBLGP TYPE STRING,
UMKZBWS TYPE STRING,
SETKZBWS TYPE STRING,
UMKZVBR TYPE STRING,
KALSM TYPE STRING,
UMKALNR TYPE STRING,
URERFMG TYPE STRING,
URVERMG TYPE STRING,
UMMTA TYPE STRING,
MBBME TYPE STRING,
MLBWG TYPE STRING,
UMXSTAU TYPE STRING,
UMXHEAD TYPE STRING,
EKALR TYPE STRING,
UMEKALR TYPE STRING,
EPRIO TYPE STRING,
UMEPR TYPE STRING,
RULES TYPE STRING,
AUFPL_ORD TYPE STRING,
APLZL_ORD TYPE STRING,
XERSY TYPE STRING,
MPROF TYPE STRING,
MFRNR TYPE STRING,
ELIKZ_INPUT TYPE STRING,
UMLGNTB TYPE STRING,
XOARC TYPE STRING,
XBEWM TYPE STRING,
UMXBEWM TYPE STRING,
KZEAR_INP TYPE STRING,
VUMVKW TYPE STRING,
ORZEIL TYPE STRING,
MTUSE TYPE STRING,
NFVAL TYPE STRING,
JV_CRPCALC TYPE STRING,
JV_RECIND TYPE STRING,
HSDAT_INPUT TYPE STRING,
VFDAT_INPUT TYPE STRING,
UMXWMHD TYPE STRING,
UMMHDHB TYPE STRING,
UMMHDRZ TYPE STRING,
BWTAR_XMBWL TYPE STRING,
UMBWTAR_XMBWL TYPE STRING,
RDMHD TYPE STRING,
IPRKZ TYPE STRING,
IPRKZ_HBD TYPE STRING,
UMIPRKZ TYPE STRING,
ESTAK TYPE STRING,
MBLFM TYPE STRING,
MBGJA TYPE STRING,
RMBEWH TYPE STRING,
MBRUE TYPE STRING,
XSAUT TYPE STRING,
UMMBLFM TYPE STRING,
UMMBGJA TYPE STRING,
UMRMBEWH TYPE STRING,
UMMBRUE TYPE STRING,
GWEMG TYPE STRING,
XREFC TYPE STRING,
UCUOB TYPE STRING,
USTDP TYPE STRING,
PRERR TYPE STRING,
FRLFD TYPE STRING,
XEXIT TYPE STRING,
VBELN_VL TYPE STRING,
VBELP_VL TYPE STRING,
KZXAB TYPE STRING,
UMKZXAB TYPE STRING,
UEKLA TYPE STRING,
UMXLAUT TYPE STRING,
XVASH TYPE STRING,
UMBFLME TYPE STRING,
KSTAR TYPE STRING,
ORUML TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MWZDM07M2_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_MWZDM07M2_STR-MANDT sy-vline 
WA_MWZDM07M2_STR-MBLNR sy-vline 
WA_MWZDM07M2_STR-MJAHR sy-vline 
WA_MWZDM07M2_STR-ZEILE sy-vline 
WA_MWZDM07M2_STR-VBUND sy-vline 
WA_MWZDM07M2_STR-XOWST sy-vline 
WA_MWZDM07M2_STR-XPRMS sy-vline 
WA_MWZDM07M2_STR-XLAUT sy-vline 
WA_MWZDM07M2_STR-XWESC sy-vline 
WA_MWZDM07M2_STR-KZGRU sy-vline 
WA_MWZDM07M2_STR-GRTXT sy-vline 
WA_MWZDM07M2_STR-WESCH sy-vline 
WA_MWZDM07M2_STR-RECID sy-vline 
WA_MWZDM07M2_STR-KASPE sy-vline 
WA_MWZDM07M2_STR-KAVSP sy-vline 
WA_MWZDM07M2_STR-SASPE sy-vline 
WA_MWZDM07M2_STR-XSTBW sy-vline 
WA_MWZDM07M2_STR-ZEILO sy-vline 
WA_MWZDM07M2_STR-DIMNG sy-vline 
WA_MWZDM07M2_STR-BWTOR sy-vline 
WA_MWZDM07M2_STR-PRREG sy-vline 
WA_MWZDM07M2_STR-KO_GSBER sy-vline 
WA_MWZDM07M2_STR-KO_PARGB sy-vline 
WA_MWZDM07M2_STR-XBKNG sy-vline 
WA_MWZDM07M2_STR-XMCNG sy-vline 
WA_MWZDM07M2_STR-XLONG sy-vline 
WA_MWZDM07M2_STR-XSVNG sy-vline 
WA_MWZDM07M2_STR-XSMNG sy-vline 
WA_MWZDM07M2_STR-UMXBN sy-vline 
WA_MWZDM07M2_STR-UMXMN sy-vline 
WA_MWZDM07M2_STR-UMXLN sy-vline 
WA_MWZDM07M2_STR-UMXSV sy-vline 
WA_MWZDM07M2_STR-UMXSM sy-vline 
WA_MWZDM07M2_STR-RESWK sy-vline 
WA_MWZDM07M2_STR-LEWED sy-vline 
WA_MWZDM07M2_STR-REVLV sy-vline 
WA_MWZDM07M2_STR-KANBA sy-vline 
WA_MWZDM07M2_STR-SERNP sy-vline 
WA_MWZDM07M2_STR-UMMLM sy-vline 
WA_MWZDM07M2_STR-UMKAL sy-vline 
WA_MWZDM07M2_STR-VMVPR sy-vline 
WA_MWZDM07M2_STR-UMVMV sy-vline 
WA_MWZDM07M2_STR-ANZL1 sy-vline 
WA_MWZDM07M2_STR-ANZL2 sy-vline 
WA_MWZDM07M2_STR-LMEN1 sy-vline 
WA_MWZDM07M2_STR-LMEN2 sy-vline 
WA_MWZDM07M2_STR-LETY1 sy-vline 
WA_MWZDM07M2_STR-LETY2 sy-vline 
WA_MWZDM07M2_STR-IDNLF sy-vline 
WA_MWZDM07M2_STR-EAN11 sy-vline 
WA_MWZDM07M2_STR-SONUM sy-vline 
WA_MWZDM07M2_STR-UMSON sy-vline 
WA_MWZDM07M2_STR-UMHKM sy-vline 
WA_MWZDM07M2_STR-UMXVK sy-vline 
WA_MWZDM07M2_STR-KZMHD sy-vline 
WA_MWZDM07M2_STR-MHDRZ sy-vline 
WA_MWZDM07M2_STR-MHDHB sy-vline 
WA_MWZDM07M2_STR-UMXCH sy-vline 
WA_MWZDM07M2_STR-QM_ZUSTD sy-vline 
WA_MWZDM07M2_STR-QM_UMZST sy-vline 
WA_MWZDM07M2_STR-KZCLA sy-vline 
WA_MWZDM07M2_STR-MHDAT sy-vline 
WA_MWZDM07M2_STR-ANZSN sy-vline 
WA_MWZDM07M2_STR-UMPRDHA sy-vline 
WA_MWZDM07M2_STR-UMSATNR sy-vline 
WA_MWZDM07M2_STR-UMBWVOR sy-vline 
WA_MWZDM07M2_STR-UMBWSCL sy-vline 
WA_MWZDM07M2_STR-UMSAISO sy-vline 
WA_MWZDM07M2_STR-UMVOLEH sy-vline 
WA_MWZDM07M2_STR-UMPLGTP sy-vline 
WA_MWZDM07M2_STR-UMSERVG sy-vline 
WA_MWZDM07M2_STR-EAN11_BME sy-vline 
WA_MWZDM07M2_STR-EAN11_KON sy-vline 
WA_MWZDM07M2_STR-EANME sy-vline 
WA_MWZDM07M2_STR-CLASS sy-vline 
WA_MWZDM07M2_STR-UMCLA sy-vline 
WA_MWZDM07M2_STR-QMAT_INAKT sy-vline 
WA_MWZDM07M2_STR-CHSMM sy-vline 
WA_MWZDM07M2_STR-UMCHS sy-vline 
WA_MWZDM07M2_STR-XCLAS sy-vline 
WA_MWZDM07M2_STR-UMXCL sy-vline 
WA_MWZDM07M2_STR-RMVCT sy-vline 
WA_MWZDM07M2_STR-EK_VKWRT sy-vline 
WA_MWZDM07M2_STR-EK_VKWRA sy-vline 
WA_MWZDM07M2_STR-PKNUM sy-vline 
WA_MWZDM07M2_STR-PKPOS sy-vline 
WA_MWZDM07M2_STR-PKLVS sy-vline 
WA_MWZDM07M2_STR-UMLIFCH sy-vline 
WA_MWZDM07M2_STR-UMLICHA sy-vline 
WA_MWZDM07M2_STR-UMLWEDT sy-vline 
WA_MWZDM07M2_STR-UMVFDAT sy-vline 
WA_MWZDM07M2_STR-UMHSDAT sy-vline 
WA_MWZDM07M2_STR-MHDAT_OLD sy-vline 
WA_MWZDM07M2_STR-UMQNDAT sy-vline 
WA_MWZDM07M2_STR-XKOKO sy-vline 
WA_MWZDM07M2_STR-UMAUT sy-vline 
WA_MWZDM07M2_STR-TBBEL sy-vline 
WA_MWZDM07M2_STR-TBBPO sy-vline 
WA_MWZDM07M2_STR-TBBJR sy-vline 
WA_MWZDM07M2_STR-VFMNG sy-vline 
WA_MWZDM07M2_STR-CUOBJ sy-vline 
WA_MWZDM07M2_STR-STDPD sy-vline 
WA_MWZDM07M2_STR-TBPKZ sy-vline 
WA_MWZDM07M2_STR-TAFKZ sy-vline 
WA_MWZDM07M2_STR-XWART sy-vline 
WA_MWZDM07M2_STR-DGLTS sy-vline 
WA_MWZDM07M2_STR-UMMEN sy-vline 
WA_MWZDM07M2_STR-UMXEI sy-vline 
WA_MWZDM07M2_STR-DGLTP sy-vline 
WA_MWZDM07M2_STR-UMKZB sy-vline 
WA_MWZDM07M2_STR-UMMLA sy-vline 
WA_MWZDM07M2_STR-UMSAISJ sy-vline 
WA_MWZDM07M2_STR-EQUMG sy-vline 
WA_MWZDM07M2_STR-XEXEQ sy-vline 
WA_MWZDM07M2_STR-UMXEXEQ sy-vline 
WA_MWZDM07M2_STR-GLMNG sy-vline 
WA_MWZDM07M2_STR-UMKZBAA sy-vline 
WA_MWZDM07M2_STR-DIRTA sy-vline 
WA_MWZDM07M2_STR-UMSERNP sy-vline 
WA_MWZDM07M2_STR-KZECH sy-vline 
WA_MWZDM07M2_STR-FCHAR sy-vline 
WA_MWZDM07M2_STR-XKCFC sy-vline 
WA_MWZDM07M2_STR-KZCHP sy-vline 
WA_MWZDM07M2_STR-INFNR sy-vline 
WA_MWZDM07M2_STR-BWSPA sy-vline 
WA_MWZDM07M2_STR-UPVOR sy-vline 
WA_MWZDM07M2_STR-UPTYP sy-vline 
WA_MWZDM07M2_STR-MEKOR sy-vline 
WA_MWZDM07M2_STR-UEZEI sy-vline 
WA_MWZDM07M2_STR-UEBPO sy-vline 
WA_MWZDM07M2_STR-LWMNG sy-vline 
WA_MWZDM07M2_STR-LWSBS sy-vline 
WA_MWZDM07M2_STR-XWMHD sy-vline 
WA_MWZDM07M2_STR-LAMNG sy-vline 
WA_MWZDM07M2_STR-PRVBE sy-vline 
WA_MWZDM07M2_STR-VEXVK sy-vline 
WA_MWZDM07M2_STR-RBLVS sy-vline 
WA_MWZDM07M2_STR-UMRBL sy-vline 
WA_MWZDM07M2_STR-UMRBU sy-vline 
WA_MWZDM07M2_STR-PARWK sy-vline 
WA_MWZDM07M2_STR-KTOMA sy-vline 
WA_MWZDM07M2_STR-XLBPD sy-vline 
WA_MWZDM07M2_STR-XBNSB sy-vline 
WA_MWZDM07M2_STR-XWAIT sy-vline 
WA_MWZDM07M2_STR-XNOEQ sy-vline 
WA_MWZDM07M2_STR-XSKNG sy-vline 
WA_MWZDM07M2_STR-XSONG sy-vline 
WA_MWZDM07M2_STR-XSWNG sy-vline 
WA_MWZDM07M2_STR-UMXSK sy-vline 
WA_MWZDM07M2_STR-UMXSO sy-vline 
WA_MWZDM07M2_STR-UMXSW sy-vline 
WA_MWZDM07M2_STR-XEWRX sy-vline 
WA_MWZDM07M2_STR-X2FDO sy-vline 
WA_MWZDM07M2_STR-UMVKW sy-vline 
WA_MWZDM07M2_STR-UMVKA sy-vline 
WA_MWZDM07M2_STR-XSENG sy-vline 
WA_MWZDM07M2_STR-XSQNG sy-vline 
WA_MWZDM07M2_STR-UMXSE sy-vline 
WA_MWZDM07M2_STR-UMXSQ sy-vline 
WA_MWZDM07M2_STR-AREWW sy-vline 
WA_MWZDM07M2_STR-MHDLG sy-vline 
WA_MWZDM07M2_STR-VWERW sy-vline 
WA_MWZDM07M2_STR-KZWSO sy-vline 
WA_MWZDM07M2_STR-UMATT sy-vline 
WA_MWZDM07M2_STR-KZKUB sy-vline 
WA_MWZDM07M2_STR-UBTYP sy-vline 
WA_MWZDM07M2_STR-UBLGP sy-vline 
WA_MWZDM07M2_STR-UMKZBWS sy-vline 
WA_MWZDM07M2_STR-SETKZBWS sy-vline 
WA_MWZDM07M2_STR-UMKZVBR sy-vline 
WA_MWZDM07M2_STR-KALSM sy-vline 
WA_MWZDM07M2_STR-UMKALNR sy-vline 
WA_MWZDM07M2_STR-URERFMG sy-vline 
WA_MWZDM07M2_STR-URVERMG sy-vline 
WA_MWZDM07M2_STR-UMMTA sy-vline 
WA_MWZDM07M2_STR-MBBME sy-vline 
WA_MWZDM07M2_STR-MLBWG sy-vline 
WA_MWZDM07M2_STR-UMXSTAU sy-vline 
WA_MWZDM07M2_STR-UMXHEAD sy-vline 
WA_MWZDM07M2_STR-EKALR sy-vline 
WA_MWZDM07M2_STR-UMEKALR sy-vline 
WA_MWZDM07M2_STR-EPRIO sy-vline 
WA_MWZDM07M2_STR-UMEPR sy-vline 
WA_MWZDM07M2_STR-RULES sy-vline 
WA_MWZDM07M2_STR-AUFPL_ORD sy-vline 
WA_MWZDM07M2_STR-APLZL_ORD sy-vline 
WA_MWZDM07M2_STR-XERSY sy-vline 
WA_MWZDM07M2_STR-MPROF sy-vline 
WA_MWZDM07M2_STR-MFRNR sy-vline 
WA_MWZDM07M2_STR-ELIKZ_INPUT sy-vline 
WA_MWZDM07M2_STR-UMLGNTB sy-vline 
WA_MWZDM07M2_STR-XOARC sy-vline 
WA_MWZDM07M2_STR-XBEWM sy-vline 
WA_MWZDM07M2_STR-UMXBEWM sy-vline 
WA_MWZDM07M2_STR-KZEAR_INP sy-vline 
WA_MWZDM07M2_STR-VUMVKW sy-vline 
WA_MWZDM07M2_STR-ORZEIL sy-vline 
WA_MWZDM07M2_STR-MTUSE sy-vline 
WA_MWZDM07M2_STR-NFVAL sy-vline 
WA_MWZDM07M2_STR-JV_CRPCALC sy-vline 
WA_MWZDM07M2_STR-JV_RECIND sy-vline 
WA_MWZDM07M2_STR-HSDAT_INPUT sy-vline 
WA_MWZDM07M2_STR-VFDAT_INPUT sy-vline 
WA_MWZDM07M2_STR-UMXWMHD sy-vline 
WA_MWZDM07M2_STR-UMMHDHB sy-vline 
WA_MWZDM07M2_STR-UMMHDRZ sy-vline 
WA_MWZDM07M2_STR-BWTAR_XMBWL sy-vline 
WA_MWZDM07M2_STR-UMBWTAR_XMBWL sy-vline 
WA_MWZDM07M2_STR-RDMHD sy-vline 
WA_MWZDM07M2_STR-IPRKZ sy-vline 
WA_MWZDM07M2_STR-IPRKZ_HBD sy-vline 
WA_MWZDM07M2_STR-UMIPRKZ sy-vline 
WA_MWZDM07M2_STR-ESTAK sy-vline 
WA_MWZDM07M2_STR-MBLFM sy-vline 
WA_MWZDM07M2_STR-MBGJA sy-vline 
WA_MWZDM07M2_STR-RMBEWH sy-vline 
WA_MWZDM07M2_STR-MBRUE sy-vline 
WA_MWZDM07M2_STR-XSAUT sy-vline 
WA_MWZDM07M2_STR-UMMBLFM sy-vline 
WA_MWZDM07M2_STR-UMMBGJA sy-vline 
WA_MWZDM07M2_STR-UMRMBEWH sy-vline 
WA_MWZDM07M2_STR-UMMBRUE sy-vline 
WA_MWZDM07M2_STR-GWEMG sy-vline 
WA_MWZDM07M2_STR-XREFC sy-vline 
WA_MWZDM07M2_STR-UCUOB sy-vline 
WA_MWZDM07M2_STR-USTDP sy-vline 
WA_MWZDM07M2_STR-PRERR sy-vline 
WA_MWZDM07M2_STR-FRLFD sy-vline 
WA_MWZDM07M2_STR-XEXIT sy-vline 
WA_MWZDM07M2_STR-VBELN_VL sy-vline 
WA_MWZDM07M2_STR-VBELP_VL sy-vline 
WA_MWZDM07M2_STR-KZXAB sy-vline 
WA_MWZDM07M2_STR-UMKZXAB sy-vline 
WA_MWZDM07M2_STR-UEKLA sy-vline 
WA_MWZDM07M2_STR-UMXLAUT sy-vline 
WA_MWZDM07M2_STR-XVASH sy-vline 
WA_MWZDM07M2_STR-UMBFLME sy-vline 
WA_MWZDM07M2_STR-KSTAR sy-vline 
WA_MWZDM07M2_STR-ORUML sy-vline      INTO ld_text SEPARATED BY SPACE.

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