ABAP Select data from SAP table MDCL 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 MDCL 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 MDCL. 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 MDCL 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_MDCL TYPE STANDARD TABLE OF MDCL,
      WA_MDCL TYPE MDCL,
      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: <MDCL> TYPE MDCL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MDCL
*  INTO TABLE @DATA(IT_MDCL2).
*--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_MDCL INDEX 1 INTO DATA(WA_MDCL2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MDCL>-AUFST = 1.
<MDCL>-AUFWG = 1.
<MDCL>-PMSOR = 1.
<MDCL>-XPOSN = 1.
<MDCL>-PMSO1 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MDCL-EPOSN, sy-vline,
  WA_MDCL-STSOR, sy-vline,
  WA_MDCL-MATNR, sy-vline,
  WA_MDCL-WERKS, sy-vline,
  WA_MDCL-BDART, sy-vline,
  WA_MDCL-POSTP, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MDCL 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_MDCL 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_MDCL INTO WA_MDCL.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field KONTO
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MDCL-KONTO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MDCL-KONTO.
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_MDCL_STR, 
AUFST TYPE STRING,
AUFWG TYPE STRING,
PMSOR TYPE STRING,
XPOSN TYPE STRING,
PMSO1 TYPE STRING,
EPOSN TYPE STRING,
STSOR TYPE STRING,
MATNR TYPE STRING,
WERKS TYPE STRING,
BDART TYPE STRING,
POSTP TYPE STRING,
POSNR TYPE STRING,
UPSKZ TYPE STRING,
DUMPS TYPE STRING,
TXTPS TYPE STRING,
INPOS TYPE STRING,
SGTPS TYPE STRING,
KFPOS TYPE STRING,
KZKUP TYPE STRING,
KLPOS TYPE STRING,
CLAKZ TYPE STRING,
DBSKZ TYPE STRING,
MTKFM TYPE STRING,
KMPKA TYPE STRING,
KNTTP TYPE STRING,
SOBKZ TYPE STRING,
KZVBR TYPE STRING,
KZBWS TYPE STRING,
BEIKZ TYPE STRING,
ERSKZ TYPE STRING,
BDMNG TYPE STRING,
VMENG TYPE STRING,
LAGME TYPE STRING,
ESMNG TYPE STRING,
SHKZG TYPE STRING,
BWART TYPE STRING,
KZEAR TYPE STRING,
ERFMG TYPE STRING,
ERFME TYPE STRING,
UMREZ TYPE STRING,
UMREN TYPE STRING,
ENMNG TYPE STRING,
FMENG TYPE STRING,
ALTPS TYPE STRING,
EWAHR TYPE STRING,
ALPGR TYPE STRING,
ALPRF TYPE STRING,
ALPST TYPE STRING,
KMPAS TYPE STRING,
AVOAS TYPE STRING,
AVONT TYPE STRING,
BDTER TYPE STRING,
SBTER TYPE STRING,
NLFZT TYPE STRING,
ASTTR TYPE STRING,
VERTI TYPE STRING,
REVLV TYPE STRING,
ROHPS TYPE STRING,
ROANZ TYPE STRING,
ROAME TYPE STRING,
ROMNG TYPE STRING,
ROMEI TYPE STRING,
ROMS1 TYPE STRING,
ROMS2 TYPE STRING,
ROMS3 TYPE STRING,
RFORM TYPE STRING,
LGPRO TYPE STRING,
PRVBE TYPE STRING,
CHARG TYPE STRING,
AUSME TYPE STRING,
STLTX TYPE STRING,
SGTX1 TYPE STRING,
SGTX2 TYPE STRING,
NFPKZ TYPE STRING,
KZAUS TYPE STRING,
NFEAG TYPE STRING,
NFGRP TYPE STRING,
NAFKZ TYPE STRING,
NFMAT TYPE STRING,
NOMNG TYPE STRING,
NFUML TYPE STRING,
AENNR TYPE STRING,
BAUGR TYPE STRING,
BAUST TYPE STRING,
BAUWG TYPE STRING,
STLTY TYPE STRING,
STLNR TYPE STRING,
STKNR TYPE STRING,
STKZA TYPE STRING,
STVKN TYPE STRING,
SERNR TYPE STRING,
CUOBJ TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
LIFZT TYPE STRING,
WEBAZ TYPE STRING,
LIFNR TYPE STRING,
PREIS TYPE STRING,
PEINH TYPE STRING,
WAERS TYPE STRING,
SAKTO TYPE STRING,
MATKL TYPE STRING,
DISMM TYPE STRING,
DISVF TYPE STRING,
DISST TYPE STRING,
MISKZ TYPE STRING,
MAKTX TYPE STRING,
SBDKZ TYPE STRING,
KZBED TYPE STRING,
EPRIO TYPE STRING,
XCHPF TYPE STRING,
MTAKZ TYPE STRING,
MTADT TYPE STRING,
MTNMT TYPE STRING,
RSNUM TYPE STRING,
RSPOS TYPE STRING,
RSART TYPE STRING,
AUFNR TYPE STRING,
APLZL TYPE STRING,
SMBLN TYPE STRING,
SMBLP TYPE STRING,
VSTAT TYPE STRING,
SELKZ TYPE STRING,
IMDCI TYPE STRING,
ACENQ TYPE STRING,
IFIXX TYPE STRING,
STALT TYPE STRING,
MTVFP TYPE STRING,
PUMNG TYPE STRING,
VRPLA TYPE STRING,
PBDNR TYPE STRING,
NOSRQ TYPE STRING,
DBKZG TYPE STRING,
TECHS TYPE STRING,
OBNUM TYPE STRING,
EDGNO TYPE STRING,
NLFZV TYPE STRING,
NLFMV TYPE STRING,
APOKZ TYPE STRING,
MB_GRUND TYPE STRING,
XFEHL TYPE STRING,
NODSP TYPE STRING,
MLSCR TYPE STRING,
SGT_RCAT TYPE STRING,
SGT_SCAT TYPE STRING,
BOM_VERSN TYPE STRING,
/CWM/ERFMG TYPE STRING,
/CWM/ERFME TYPE STRING,
/CWM/BDMNG TYPE STRING,
/CWM/MEINS TYPE STRING,
NO_DISP TYPE STRING,
DISUB_PSPNR TYPE STRING,
DISUB_KUNNR TYPE STRING,
DISUB_VBELN TYPE STRING,
DISUB_POSNR TYPE STRING,
DISUB_OWNER TYPE STRING,
ALLOCATED TYPE STRING,
FSH_CRITICAL_COMP TYPE STRING,
FSH_CRITICAL_LEVEL TYPE STRING,
WRF_CHARSTC1 TYPE STRING,
WRF_CHARSTC1_TXT TYPE STRING,
WRF_CHARSTC2 TYPE STRING,
WRF_CHARSTC2_TXT TYPE STRING,
WRF_CHARSTC3 TYPE STRING,
WRF_CHARSTC3_TXT TYPE STRING,
PLNFL TYPE STRING,
VORNR TYPE STRING,
LTXA1 TYPE STRING,
ARBPL TYPE STRING,
KTEXT TYPE STRING,
AUFPS TYPE STRING,
KDAUF TYPE STRING,
KDPOS TYPE STRING,
INSMK TYPE STRING,
ELIKZ TYPE STRING,
WEMPF TYPE STRING,
ABLAD TYPE STRING,
LGNUM TYPE STRING,
LGTYP TYPE STRING,
LGPBE TYPE STRING,
ELGPBE TYPE STRING,
DISPO TYPE STRING,
FEVOR TYPE STRING,
AVAIL TYPE STRING,
LMINB TYPE STRING,
DISKZ TYPE STRING,
KANBN TYPE STRING,
NBDMG TYPE STRING,
MISSQ TYPE STRING,
ERFGME TYPE STRING,
WMPPI TYPE STRING,
ELORT TYPE STRING,
ESOBKZ TYPE STRING,
ELIFNR TYPE STRING,
EQUAN TYPE STRING,
RMISS TYPE STRING,
EXCEP TYPE STRING,
MSGID TYPE STRING,
MSGNO TYPE STRING,
MSGTY TYPE STRING,
MSGV1 TYPE STRING,
MSGV2 TYPE STRING,
MSGV3 TYPE STRING,
MSGV4 TYPE STRING,
WEBLNR TYPE STRING,
WEBLPOS TYPE STRING,
AUFPL TYPE STRING,
AUTYP TYPE STRING,
KZBEW TYPE STRING,
LFPOS TYPE STRING,
NPLNR TYPE STRING,
PS_PSP_PNR TYPE STRING,
OBJNR TYPE STRING,
ERSDA TYPE STRING,
FWDAT TYPE STRING,
BUDAT TYPE STRING,
BLDAT TYPE STRING,
XSTOR TYPE STRING,
SJAHR TYPE STRING,
QPLOS TYPE STRING,
MHDAT TYPE STRING,
DNOTW TYPE STRING,
BERKZ TYPE STRING,
TBMNG TYPE STRING,
PRREG TYPE STRING,
KZECH TYPE STRING,
BWTAR TYPE STRING,
PLNUM TYPE STRING,
KONTO TYPE STRING,
KTOMA TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MDCL_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_MDCL_STR-AUFST sy-vline 
WA_MDCL_STR-AUFWG sy-vline 
WA_MDCL_STR-PMSOR sy-vline 
WA_MDCL_STR-XPOSN sy-vline 
WA_MDCL_STR-PMSO1 sy-vline 
WA_MDCL_STR-EPOSN sy-vline 
WA_MDCL_STR-STSOR sy-vline 
WA_MDCL_STR-MATNR sy-vline 
WA_MDCL_STR-WERKS sy-vline 
WA_MDCL_STR-BDART sy-vline 
WA_MDCL_STR-POSTP sy-vline 
WA_MDCL_STR-POSNR sy-vline 
WA_MDCL_STR-UPSKZ sy-vline 
WA_MDCL_STR-DUMPS sy-vline 
WA_MDCL_STR-TXTPS sy-vline 
WA_MDCL_STR-INPOS sy-vline 
WA_MDCL_STR-SGTPS sy-vline 
WA_MDCL_STR-KFPOS sy-vline 
WA_MDCL_STR-KZKUP sy-vline 
WA_MDCL_STR-KLPOS sy-vline 
WA_MDCL_STR-CLAKZ sy-vline 
WA_MDCL_STR-DBSKZ sy-vline 
WA_MDCL_STR-MTKFM sy-vline 
WA_MDCL_STR-KMPKA sy-vline 
WA_MDCL_STR-KNTTP sy-vline 
WA_MDCL_STR-SOBKZ sy-vline 
WA_MDCL_STR-KZVBR sy-vline 
WA_MDCL_STR-KZBWS sy-vline 
WA_MDCL_STR-BEIKZ sy-vline 
WA_MDCL_STR-ERSKZ sy-vline 
WA_MDCL_STR-BDMNG sy-vline 
WA_MDCL_STR-VMENG sy-vline 
WA_MDCL_STR-LAGME sy-vline 
WA_MDCL_STR-ESMNG sy-vline 
WA_MDCL_STR-SHKZG sy-vline 
WA_MDCL_STR-BWART sy-vline 
WA_MDCL_STR-KZEAR sy-vline 
WA_MDCL_STR-ERFMG sy-vline 
WA_MDCL_STR-ERFME sy-vline 
WA_MDCL_STR-UMREZ sy-vline 
WA_MDCL_STR-UMREN sy-vline 
WA_MDCL_STR-ENMNG sy-vline 
WA_MDCL_STR-FMENG sy-vline 
WA_MDCL_STR-ALTPS sy-vline 
WA_MDCL_STR-EWAHR sy-vline 
WA_MDCL_STR-ALPGR sy-vline 
WA_MDCL_STR-ALPRF sy-vline 
WA_MDCL_STR-ALPST sy-vline 
WA_MDCL_STR-KMPAS sy-vline 
WA_MDCL_STR-AVOAS sy-vline 
WA_MDCL_STR-AVONT sy-vline 
WA_MDCL_STR-BDTER sy-vline 
WA_MDCL_STR-SBTER sy-vline 
WA_MDCL_STR-NLFZT sy-vline 
WA_MDCL_STR-ASTTR sy-vline 
WA_MDCL_STR-VERTI sy-vline 
WA_MDCL_STR-REVLV sy-vline 
WA_MDCL_STR-ROHPS sy-vline 
WA_MDCL_STR-ROANZ sy-vline 
WA_MDCL_STR-ROAME sy-vline 
WA_MDCL_STR-ROMNG sy-vline 
WA_MDCL_STR-ROMEI sy-vline 
WA_MDCL_STR-ROMS1 sy-vline 
WA_MDCL_STR-ROMS2 sy-vline 
WA_MDCL_STR-ROMS3 sy-vline 
WA_MDCL_STR-RFORM sy-vline 
WA_MDCL_STR-LGPRO sy-vline 
WA_MDCL_STR-PRVBE sy-vline 
WA_MDCL_STR-CHARG sy-vline 
WA_MDCL_STR-AUSME sy-vline 
WA_MDCL_STR-STLTX sy-vline 
WA_MDCL_STR-SGTX1 sy-vline 
WA_MDCL_STR-SGTX2 sy-vline 
WA_MDCL_STR-NFPKZ sy-vline 
WA_MDCL_STR-KZAUS sy-vline 
WA_MDCL_STR-NFEAG sy-vline 
WA_MDCL_STR-NFGRP sy-vline 
WA_MDCL_STR-NAFKZ sy-vline 
WA_MDCL_STR-NFMAT sy-vline 
WA_MDCL_STR-NOMNG sy-vline 
WA_MDCL_STR-NFUML sy-vline 
WA_MDCL_STR-AENNR sy-vline 
WA_MDCL_STR-BAUGR sy-vline 
WA_MDCL_STR-BAUST sy-vline 
WA_MDCL_STR-BAUWG sy-vline 
WA_MDCL_STR-STLTY sy-vline 
WA_MDCL_STR-STLNR sy-vline 
WA_MDCL_STR-STKNR sy-vline 
WA_MDCL_STR-STKZA sy-vline 
WA_MDCL_STR-STVKN sy-vline 
WA_MDCL_STR-SERNR sy-vline 
WA_MDCL_STR-CUOBJ sy-vline 
WA_MDCL_STR-EKORG sy-vline 
WA_MDCL_STR-EKGRP sy-vline 
WA_MDCL_STR-LIFZT sy-vline 
WA_MDCL_STR-WEBAZ sy-vline 
WA_MDCL_STR-LIFNR sy-vline 
WA_MDCL_STR-PREIS sy-vline 
WA_MDCL_STR-PEINH sy-vline 
WA_MDCL_STR-WAERS sy-vline 
WA_MDCL_STR-SAKTO sy-vline 
WA_MDCL_STR-MATKL sy-vline 
WA_MDCL_STR-DISMM sy-vline 
WA_MDCL_STR-DISVF sy-vline 
WA_MDCL_STR-DISST sy-vline 
WA_MDCL_STR-MISKZ sy-vline 
WA_MDCL_STR-MAKTX sy-vline 
WA_MDCL_STR-SBDKZ sy-vline 
WA_MDCL_STR-KZBED sy-vline 
WA_MDCL_STR-EPRIO sy-vline 
WA_MDCL_STR-XCHPF sy-vline 
WA_MDCL_STR-MTAKZ sy-vline 
WA_MDCL_STR-MTADT sy-vline 
WA_MDCL_STR-MTNMT sy-vline 
WA_MDCL_STR-RSNUM sy-vline 
WA_MDCL_STR-RSPOS sy-vline 
WA_MDCL_STR-RSART sy-vline 
WA_MDCL_STR-AUFNR sy-vline 
WA_MDCL_STR-APLZL sy-vline 
WA_MDCL_STR-SMBLN sy-vline 
WA_MDCL_STR-SMBLP sy-vline 
WA_MDCL_STR-VSTAT sy-vline 
WA_MDCL_STR-SELKZ sy-vline 
WA_MDCL_STR-IMDCI sy-vline 
WA_MDCL_STR-ACENQ sy-vline 
WA_MDCL_STR-IFIXX sy-vline 
WA_MDCL_STR-STALT sy-vline 
WA_MDCL_STR-MTVFP sy-vline 
WA_MDCL_STR-PUMNG sy-vline 
WA_MDCL_STR-VRPLA sy-vline 
WA_MDCL_STR-PBDNR sy-vline 
WA_MDCL_STR-NOSRQ sy-vline 
WA_MDCL_STR-DBKZG sy-vline 
WA_MDCL_STR-TECHS sy-vline 
WA_MDCL_STR-OBNUM sy-vline 
WA_MDCL_STR-EDGNO sy-vline 
WA_MDCL_STR-NLFZV sy-vline 
WA_MDCL_STR-NLFMV sy-vline 
WA_MDCL_STR-APOKZ sy-vline 
WA_MDCL_STR-MB_GRUND sy-vline 
WA_MDCL_STR-XFEHL sy-vline 
WA_MDCL_STR-NODSP sy-vline 
WA_MDCL_STR-MLSCR sy-vline 
WA_MDCL_STR-SGT_RCAT sy-vline 
WA_MDCL_STR-SGT_SCAT sy-vline 
WA_MDCL_STR-BOM_VERSN sy-vline 
WA_MDCL_STR-/CWM/ERFMG sy-vline 
WA_MDCL_STR-/CWM/ERFME sy-vline 
WA_MDCL_STR-/CWM/BDMNG sy-vline 
WA_MDCL_STR-/CWM/MEINS sy-vline 
WA_MDCL_STR-NO_DISP sy-vline 
WA_MDCL_STR-DISUB_PSPNR sy-vline 
WA_MDCL_STR-DISUB_KUNNR sy-vline 
WA_MDCL_STR-DISUB_VBELN sy-vline 
WA_MDCL_STR-DISUB_POSNR sy-vline 
WA_MDCL_STR-DISUB_OWNER sy-vline 
WA_MDCL_STR-ALLOCATED sy-vline 
WA_MDCL_STR-FSH_CRITICAL_COMP sy-vline 
WA_MDCL_STR-FSH_CRITICAL_LEVEL sy-vline 
WA_MDCL_STR-WRF_CHARSTC1 sy-vline 
WA_MDCL_STR-WRF_CHARSTC1_TXT sy-vline 
WA_MDCL_STR-WRF_CHARSTC2 sy-vline 
WA_MDCL_STR-WRF_CHARSTC2_TXT sy-vline 
WA_MDCL_STR-WRF_CHARSTC3 sy-vline 
WA_MDCL_STR-WRF_CHARSTC3_TXT sy-vline 
WA_MDCL_STR-PLNFL sy-vline 
WA_MDCL_STR-VORNR sy-vline 
WA_MDCL_STR-LTXA1 sy-vline 
WA_MDCL_STR-ARBPL sy-vline 
WA_MDCL_STR-KTEXT sy-vline 
WA_MDCL_STR-AUFPS sy-vline 
WA_MDCL_STR-KDAUF sy-vline 
WA_MDCL_STR-KDPOS sy-vline 
WA_MDCL_STR-INSMK sy-vline 
WA_MDCL_STR-ELIKZ sy-vline 
WA_MDCL_STR-WEMPF sy-vline 
WA_MDCL_STR-ABLAD sy-vline 
WA_MDCL_STR-LGNUM sy-vline 
WA_MDCL_STR-LGTYP sy-vline 
WA_MDCL_STR-LGPBE sy-vline 
WA_MDCL_STR-ELGPBE sy-vline 
WA_MDCL_STR-DISPO sy-vline 
WA_MDCL_STR-FEVOR sy-vline 
WA_MDCL_STR-AVAIL sy-vline 
WA_MDCL_STR-LMINB sy-vline 
WA_MDCL_STR-DISKZ sy-vline 
WA_MDCL_STR-KANBN sy-vline 
WA_MDCL_STR-NBDMG sy-vline 
WA_MDCL_STR-MISSQ sy-vline 
WA_MDCL_STR-ERFGME sy-vline 
WA_MDCL_STR-WMPPI sy-vline 
WA_MDCL_STR-ELORT sy-vline 
WA_MDCL_STR-ESOBKZ sy-vline 
WA_MDCL_STR-ELIFNR sy-vline 
WA_MDCL_STR-EQUAN sy-vline 
WA_MDCL_STR-RMISS sy-vline 
WA_MDCL_STR-EXCEP sy-vline 
WA_MDCL_STR-MSGID sy-vline 
WA_MDCL_STR-MSGNO sy-vline 
WA_MDCL_STR-MSGTY sy-vline 
WA_MDCL_STR-MSGV1 sy-vline 
WA_MDCL_STR-MSGV2 sy-vline 
WA_MDCL_STR-MSGV3 sy-vline 
WA_MDCL_STR-MSGV4 sy-vline 
WA_MDCL_STR-WEBLNR sy-vline 
WA_MDCL_STR-WEBLPOS sy-vline 
WA_MDCL_STR-AUFPL sy-vline 
WA_MDCL_STR-AUTYP sy-vline 
WA_MDCL_STR-KZBEW sy-vline 
WA_MDCL_STR-LFPOS sy-vline 
WA_MDCL_STR-NPLNR sy-vline 
WA_MDCL_STR-PS_PSP_PNR sy-vline 
WA_MDCL_STR-OBJNR sy-vline 
WA_MDCL_STR-ERSDA sy-vline 
WA_MDCL_STR-FWDAT sy-vline 
WA_MDCL_STR-BUDAT sy-vline 
WA_MDCL_STR-BLDAT sy-vline 
WA_MDCL_STR-XSTOR sy-vline 
WA_MDCL_STR-SJAHR sy-vline 
WA_MDCL_STR-QPLOS sy-vline 
WA_MDCL_STR-MHDAT sy-vline 
WA_MDCL_STR-DNOTW sy-vline 
WA_MDCL_STR-BERKZ sy-vline 
WA_MDCL_STR-TBMNG sy-vline 
WA_MDCL_STR-PRREG sy-vline 
WA_MDCL_STR-KZECH sy-vline 
WA_MDCL_STR-BWTAR sy-vline 
WA_MDCL_STR-PLNUM sy-vline 
WA_MDCL_STR-KONTO sy-vline 
WA_MDCL_STR-KTOMA sy-vline      INTO ld_text SEPARATED BY SPACE.

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