ABAP Select data from SAP table MCVTTK 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 MCVTTK 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 MCVTTK. 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 MCVTTK 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_MCVTTK TYPE STANDARD TABLE OF MCVTTK,
      WA_MCVTTK TYPE MCVTTK,
      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: <MCVTTK> TYPE MCVTTK.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MCVTTK
*  INTO TABLE @DATA(IT_MCVTTK2).
*--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_MCVTTK INDEX 1 INTO DATA(WA_MCVTTK2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MCVTTK>-MANDT = 1.
<MCVTTK>-TKNUM = 1.
<MCVTTK>-VBTYP = 1.
<MCVTTK>-SHTYP = 1.
<MCVTTK>-TPLST = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MCVTTK-ERNAM, sy-vline,
  WA_MCVTTK-ERDAT, sy-vline,
  WA_MCVTTK-ERZET, sy-vline,
  WA_MCVTTK-AENAM, sy-vline,
  WA_MCVTTK-AEDAT, sy-vline,
  WA_MCVTTK-AEZET, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MCVTTK 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_MCVTTK 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_MCVTTK INTO WA_MCVTTK.


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

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

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

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

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

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

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

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

*Conversion exit TSTRG, internal->external for field GESZTD
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-GESZTD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-GESZTD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field FAHZTD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-FAHZTD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-FAHZTD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRG, internal->external for field GESZTDA
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-GESZTDA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-GESZTDA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field FAHZTDA
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-FAHZTDA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-FAHZTDA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TMPLA, internal->external for field TSEGTP
CALL FUNCTION 'CONVERSION_EXIT_TMPLA_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-TSEGTP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-TSEGTP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field WARZTD
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-WARZTD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-WARZTD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field WARZTDA
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-WARZTDA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-WARZTDA.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit TDURM, internal->external for field DURLP
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-DURLP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-DURLP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field DURLA
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-DURLA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-DURLA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field DURTP
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-DURTP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-DURTP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field DURTA
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-DURTA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-DURTA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field LATEL
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-LATEL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-LATEL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field LATET
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-LATET
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-LATET.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field LATES
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-LATES
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-LATES.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field LATEE
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-LATEE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-LATEE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field LATER
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-LATER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-LATER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field LATEB
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-LATEB
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-LATEB.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field DURGES
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-DURGES
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-DURGES.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field DURFAH
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-DURFAH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-DURFAH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field DURGESP
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-DURGESP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-DURGESP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TDURM, internal->external for field DURFAHP
CALL FUNCTION 'CONVERSION_EXIT_TDURM_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-DURFAHP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-DURFAHP.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field PTVENR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MCVTTK-PTVENR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCVTTK-PTVENR.
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_MCVTTK_STR, 
MANDT TYPE STRING,
TKNUM TYPE STRING,
VBTYP TYPE STRING,
SHTYP TYPE STRING,
TPLST TYPE STRING,
ERNAM TYPE STRING,
ERDAT TYPE STRING,
ERZET TYPE STRING,
AENAM TYPE STRING,
AEDAT TYPE STRING,
AEZET TYPE STRING,
STERM TYPE STRING,
ABFER TYPE STRING,
ABWST TYPE STRING,
BFART TYPE STRING,
VSART TYPE STRING,
VSAVL TYPE STRING,
VSANL TYPE STRING,
LAUFK TYPE STRING,
VSBED TYPE STRING,
ROUTE TYPE STRING,
SIGNI TYPE STRING,
EXTI1 TYPE STRING,
EXTI2 TYPE STRING,
TPBEZ TYPE STRING,
STDIS TYPE STRING,
DTDIS TYPE STRING,
UZDIS TYPE STRING,
STREG TYPE STRING,
DPREG TYPE STRING,
UPREG TYPE STRING,
DAREG TYPE STRING,
UAREG TYPE STRING,
STLBG TYPE STRING,
DPLBG TYPE STRING,
UPLBG TYPE STRING,
DALBG TYPE STRING,
UALBG TYPE STRING,
STLAD TYPE STRING,
DPLEN TYPE STRING,
UPLEN TYPE STRING,
DALEN TYPE STRING,
UALEN TYPE STRING,
STABF TYPE STRING,
DPABF TYPE STRING,
UPABF TYPE STRING,
DTABF TYPE STRING,
UZABF TYPE STRING,
STTBG TYPE STRING,
DPTBG TYPE STRING,
UPTBG TYPE STRING,
DATBG TYPE STRING,
UATBG TYPE STRING,
STTEN TYPE STRING,
DPTEN TYPE STRING,
UPTEN TYPE STRING,
DATEN TYPE STRING,
UATEN TYPE STRING,
STTRG TYPE STRING,
TDLNR TYPE STRING,
TERNR TYPE STRING,
PKSTK TYPE STRING,
DTMEG TYPE STRING,
DTMEV TYPE STRING,
DISTZ TYPE STRING,
MEDST TYPE STRING,
FAHZT TYPE STRING,
GESZT TYPE STRING,
MEIZT TYPE STRING,
STAFO TYPE STRING,
FBSTA TYPE STRING,
FBGST TYPE STRING,
ARSTA TYPE STRING,
ARGST TYPE STRING,
STERM_DONE TYPE STRING,
VSE_FRK TYPE STRING,
KKALSM TYPE STRING,
SDABW TYPE STRING,
FRKRL TYPE STRING,
GESZTD TYPE STRING,
FAHZTD TYPE STRING,
GESZTDA TYPE STRING,
FAHZTDA TYPE STRING,
ROCPY_DONE TYPE STRING,
HANDLE TYPE STRING,
TSEGFL TYPE STRING,
TSEGTP TYPE STRING,
ADD01 TYPE STRING,
ADD02 TYPE STRING,
ADD03 TYPE STRING,
ADD04 TYPE STRING,
TEXT1 TYPE STRING,
TEXT2 TYPE STRING,
TEXT3 TYPE STRING,
TEXT4 TYPE STRING,
PROLI TYPE STRING,
DGTLOCK TYPE STRING,
DGMDDAT TYPE STRING,
CONT_DG TYPE STRING,
WARZTD TYPE STRING,
WARZTDA TYPE STRING,
AULWE TYPE STRING,
TNDRST TYPE STRING,
TNDRRC TYPE STRING,
TNDR_TEXT TYPE STRING,
TNDRDAT TYPE STRING,
TNDRZET TYPE STRING,
TNDR_MAXP TYPE STRING,
TNDR_MAXC TYPE STRING,
TNDR_ACTP TYPE STRING,
TNDR_ACTC TYPE STRING,
TNDR_CARR TYPE STRING,
TNDR_CRNM TYPE STRING,
TNDR_TRKID TYPE STRING,
TNDR_EXPD TYPE STRING,
TNDR_EXPT TYPE STRING,
TNDR_ERPD TYPE STRING,
TNDR_ERPT TYPE STRING,
TNDR_LTPD TYPE STRING,
TNDR_LTPT TYPE STRING,
TNDR_ERDD TYPE STRING,
TNDR_ERDT TYPE STRING,
TNDR_LTDD TYPE STRING,
TNDR_LTDT TYPE STRING,
TNDR_LDLG TYPE STRING,
TNDR_LDLU TYPE STRING,
KZHULFR TYPE STRING,
ALLOWED_TWGT TYPE STRING,
VLSTK TYPE STRING,
VERURSYS TYPE STRING,
CM_IDENT TYPE STRING,
CM_SEQUENCE TYPE STRING,
EXT_FREIGHT_ORD TYPE STRING,
EXT_TM_SYS TYPE STRING,
/BEV1/RPFAR1 TYPE STRING,
/BEV1/RPFAR2 TYPE STRING,
/BEV1/RPMOWA TYPE STRING,
/BEV1/RPANHAE TYPE STRING,
/BEV1/RPFLGNR TYPE STRING,
/VSO/R_STATUS TYPE STRING,
ADUMMY TYPE STRING,
VSTELA TYPE STRING,
WERKSZ TYPE STRING,
PSTLZA TYPE STRING,
PSTLZZ TYPE STRING,
ALAND TYPE STRING,
LLAND TYPE STRING,
AZONE TYPE STRING,
LZONE TYPE STRING,
REGIOA TYPE STRING,
REGIOZ TYPE STRING,
STADIS TYPE STRING,
STAVOL TYPE STRING,
STAGEW TYPE STRING,
ANZHV TYPE STRING,
ANZHVG TYPE STRING,
ANZVGES TYPE STRING,
ANZVGL TYPE STRING,
BRGEW_VE TYPE STRING,
NTGEW_VE TYPE STRING,
MAGEW_VE TYPE STRING,
TARAG_VE TYPE STRING,
GEWEI_MAX TYPE STRING,
GEWEI_TAR TYPE STRING,
AUSLG_VE TYPE STRING,
BRVOL_VE TYPE STRING,
NTVOL_VE TYPE STRING,
MAVOL_VE TYPE STRING,
TAVOL_VE TYPE STRING,
VOLEH_TAR TYPE STRING,
VOLEH_MAX TYPE STRING,
AUSLV_VE TYPE STRING,
VHILM_VE TYPE STRING,
DURLP TYPE STRING,
DURLA TYPE STRING,
DURTP TYPE STRING,
DURTA TYPE STRING,
LATEL TYPE STRING,
LATET TYPE STRING,
LATES TYPE STRING,
LATEE TYPE STRING,
LATER TYPE STRING,
LATEB TYPE STRING,
DURGES TYPE STRING,
DURFAH TYPE STRING,
DURGESP TYPE STRING,
DURFAHP TYPE STRING,
STACUR TYPE STRING,
HWAER TYPE STRING,
ALLOW_TWG TYPE STRING,
PKUNAG TYPE STRING,
PKUNWE TYPE STRING,
PKUNRE TYPE STRING,
PKUNRG TYPE STRING,
PTDLNR TYPE STRING,
PTFRNR TYPE STRING,
PTRFNR TYPE STRING,
PTVENR TYPE STRING,
PLAAG TYPE STRING,
PLAWE TYPE STRING,
PLARE TYPE STRING,
PLARG TYPE STRING,
PLASP TYPE STRING,
PLAFF TYPE STRING,
PLARF TYPE STRING,
PLATV TYPE STRING,
PABLA TYPE STRING,
PZONE TYPE STRING,
PDUMMY TYPE STRING,
UDUMMY TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MCVTTK_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_MCVTTK_STR-MANDT sy-vline 
WA_MCVTTK_STR-TKNUM sy-vline 
WA_MCVTTK_STR-VBTYP sy-vline 
WA_MCVTTK_STR-SHTYP sy-vline 
WA_MCVTTK_STR-TPLST sy-vline 
WA_MCVTTK_STR-ERNAM sy-vline 
WA_MCVTTK_STR-ERDAT sy-vline 
WA_MCVTTK_STR-ERZET sy-vline 
WA_MCVTTK_STR-AENAM sy-vline 
WA_MCVTTK_STR-AEDAT sy-vline 
WA_MCVTTK_STR-AEZET sy-vline 
WA_MCVTTK_STR-STERM sy-vline 
WA_MCVTTK_STR-ABFER sy-vline 
WA_MCVTTK_STR-ABWST sy-vline 
WA_MCVTTK_STR-BFART sy-vline 
WA_MCVTTK_STR-VSART sy-vline 
WA_MCVTTK_STR-VSAVL sy-vline 
WA_MCVTTK_STR-VSANL sy-vline 
WA_MCVTTK_STR-LAUFK sy-vline 
WA_MCVTTK_STR-VSBED sy-vline 
WA_MCVTTK_STR-ROUTE sy-vline 
WA_MCVTTK_STR-SIGNI sy-vline 
WA_MCVTTK_STR-EXTI1 sy-vline 
WA_MCVTTK_STR-EXTI2 sy-vline 
WA_MCVTTK_STR-TPBEZ sy-vline 
WA_MCVTTK_STR-STDIS sy-vline 
WA_MCVTTK_STR-DTDIS sy-vline 
WA_MCVTTK_STR-UZDIS sy-vline 
WA_MCVTTK_STR-STREG sy-vline 
WA_MCVTTK_STR-DPREG sy-vline 
WA_MCVTTK_STR-UPREG sy-vline 
WA_MCVTTK_STR-DAREG sy-vline 
WA_MCVTTK_STR-UAREG sy-vline 
WA_MCVTTK_STR-STLBG sy-vline 
WA_MCVTTK_STR-DPLBG sy-vline 
WA_MCVTTK_STR-UPLBG sy-vline 
WA_MCVTTK_STR-DALBG sy-vline 
WA_MCVTTK_STR-UALBG sy-vline 
WA_MCVTTK_STR-STLAD sy-vline 
WA_MCVTTK_STR-DPLEN sy-vline 
WA_MCVTTK_STR-UPLEN sy-vline 
WA_MCVTTK_STR-DALEN sy-vline 
WA_MCVTTK_STR-UALEN sy-vline 
WA_MCVTTK_STR-STABF sy-vline 
WA_MCVTTK_STR-DPABF sy-vline 
WA_MCVTTK_STR-UPABF sy-vline 
WA_MCVTTK_STR-DTABF sy-vline 
WA_MCVTTK_STR-UZABF sy-vline 
WA_MCVTTK_STR-STTBG sy-vline 
WA_MCVTTK_STR-DPTBG sy-vline 
WA_MCVTTK_STR-UPTBG sy-vline 
WA_MCVTTK_STR-DATBG sy-vline 
WA_MCVTTK_STR-UATBG sy-vline 
WA_MCVTTK_STR-STTEN sy-vline 
WA_MCVTTK_STR-DPTEN sy-vline 
WA_MCVTTK_STR-UPTEN sy-vline 
WA_MCVTTK_STR-DATEN sy-vline 
WA_MCVTTK_STR-UATEN sy-vline 
WA_MCVTTK_STR-STTRG sy-vline 
WA_MCVTTK_STR-TDLNR sy-vline 
WA_MCVTTK_STR-TERNR sy-vline 
WA_MCVTTK_STR-PKSTK sy-vline 
WA_MCVTTK_STR-DTMEG sy-vline 
WA_MCVTTK_STR-DTMEV sy-vline 
WA_MCVTTK_STR-DISTZ sy-vline 
WA_MCVTTK_STR-MEDST sy-vline 
WA_MCVTTK_STR-FAHZT sy-vline 
WA_MCVTTK_STR-GESZT sy-vline 
WA_MCVTTK_STR-MEIZT sy-vline 
WA_MCVTTK_STR-STAFO sy-vline 
WA_MCVTTK_STR-FBSTA sy-vline 
WA_MCVTTK_STR-FBGST sy-vline 
WA_MCVTTK_STR-ARSTA sy-vline 
WA_MCVTTK_STR-ARGST sy-vline 
WA_MCVTTK_STR-STERM_DONE sy-vline 
WA_MCVTTK_STR-VSE_FRK sy-vline 
WA_MCVTTK_STR-KKALSM sy-vline 
WA_MCVTTK_STR-SDABW sy-vline 
WA_MCVTTK_STR-FRKRL sy-vline 
WA_MCVTTK_STR-GESZTD sy-vline 
WA_MCVTTK_STR-FAHZTD sy-vline 
WA_MCVTTK_STR-GESZTDA sy-vline 
WA_MCVTTK_STR-FAHZTDA sy-vline 
WA_MCVTTK_STR-ROCPY_DONE sy-vline 
WA_MCVTTK_STR-HANDLE sy-vline 
WA_MCVTTK_STR-TSEGFL sy-vline 
WA_MCVTTK_STR-TSEGTP sy-vline 
WA_MCVTTK_STR-ADD01 sy-vline 
WA_MCVTTK_STR-ADD02 sy-vline 
WA_MCVTTK_STR-ADD03 sy-vline 
WA_MCVTTK_STR-ADD04 sy-vline 
WA_MCVTTK_STR-TEXT1 sy-vline 
WA_MCVTTK_STR-TEXT2 sy-vline 
WA_MCVTTK_STR-TEXT3 sy-vline 
WA_MCVTTK_STR-TEXT4 sy-vline 
WA_MCVTTK_STR-PROLI sy-vline 
WA_MCVTTK_STR-DGTLOCK sy-vline 
WA_MCVTTK_STR-DGMDDAT sy-vline 
WA_MCVTTK_STR-CONT_DG sy-vline 
WA_MCVTTK_STR-WARZTD sy-vline 
WA_MCVTTK_STR-WARZTDA sy-vline 
WA_MCVTTK_STR-AULWE sy-vline 
WA_MCVTTK_STR-TNDRST sy-vline 
WA_MCVTTK_STR-TNDRRC sy-vline 
WA_MCVTTK_STR-TNDR_TEXT sy-vline 
WA_MCVTTK_STR-TNDRDAT sy-vline 
WA_MCVTTK_STR-TNDRZET sy-vline 
WA_MCVTTK_STR-TNDR_MAXP sy-vline 
WA_MCVTTK_STR-TNDR_MAXC sy-vline 
WA_MCVTTK_STR-TNDR_ACTP sy-vline 
WA_MCVTTK_STR-TNDR_ACTC sy-vline 
WA_MCVTTK_STR-TNDR_CARR sy-vline 
WA_MCVTTK_STR-TNDR_CRNM sy-vline 
WA_MCVTTK_STR-TNDR_TRKID sy-vline 
WA_MCVTTK_STR-TNDR_EXPD sy-vline 
WA_MCVTTK_STR-TNDR_EXPT sy-vline 
WA_MCVTTK_STR-TNDR_ERPD sy-vline 
WA_MCVTTK_STR-TNDR_ERPT sy-vline 
WA_MCVTTK_STR-TNDR_LTPD sy-vline 
WA_MCVTTK_STR-TNDR_LTPT sy-vline 
WA_MCVTTK_STR-TNDR_ERDD sy-vline 
WA_MCVTTK_STR-TNDR_ERDT sy-vline 
WA_MCVTTK_STR-TNDR_LTDD sy-vline 
WA_MCVTTK_STR-TNDR_LTDT sy-vline 
WA_MCVTTK_STR-TNDR_LDLG sy-vline 
WA_MCVTTK_STR-TNDR_LDLU sy-vline 
WA_MCVTTK_STR-KZHULFR sy-vline 
WA_MCVTTK_STR-ALLOWED_TWGT sy-vline 
WA_MCVTTK_STR-VLSTK sy-vline 
WA_MCVTTK_STR-VERURSYS sy-vline 
WA_MCVTTK_STR-CM_IDENT sy-vline 
WA_MCVTTK_STR-CM_SEQUENCE sy-vline 
WA_MCVTTK_STR-EXT_FREIGHT_ORD sy-vline 
WA_MCVTTK_STR-EXT_TM_SYS sy-vline 
WA_MCVTTK_STR-/BEV1/RPFAR1 sy-vline 
WA_MCVTTK_STR-/BEV1/RPFAR2 sy-vline 
WA_MCVTTK_STR-/BEV1/RPMOWA sy-vline 
WA_MCVTTK_STR-/BEV1/RPANHAE sy-vline 
WA_MCVTTK_STR-/BEV1/RPFLGNR sy-vline 
WA_MCVTTK_STR-/VSO/R_STATUS sy-vline 
WA_MCVTTK_STR-ADUMMY sy-vline 
WA_MCVTTK_STR-VSTELA sy-vline 
WA_MCVTTK_STR-WERKSZ sy-vline 
WA_MCVTTK_STR-PSTLZA sy-vline 
WA_MCVTTK_STR-PSTLZZ sy-vline 
WA_MCVTTK_STR-ALAND sy-vline 
WA_MCVTTK_STR-LLAND sy-vline 
WA_MCVTTK_STR-AZONE sy-vline 
WA_MCVTTK_STR-LZONE sy-vline 
WA_MCVTTK_STR-REGIOA sy-vline 
WA_MCVTTK_STR-REGIOZ sy-vline 
WA_MCVTTK_STR-STADIS sy-vline 
WA_MCVTTK_STR-STAVOL sy-vline 
WA_MCVTTK_STR-STAGEW sy-vline 
WA_MCVTTK_STR-ANZHV sy-vline 
WA_MCVTTK_STR-ANZHVG sy-vline 
WA_MCVTTK_STR-ANZVGES sy-vline 
WA_MCVTTK_STR-ANZVGL sy-vline 
WA_MCVTTK_STR-BRGEW_VE sy-vline 
WA_MCVTTK_STR-NTGEW_VE sy-vline 
WA_MCVTTK_STR-MAGEW_VE sy-vline 
WA_MCVTTK_STR-TARAG_VE sy-vline 
WA_MCVTTK_STR-GEWEI_MAX sy-vline 
WA_MCVTTK_STR-GEWEI_TAR sy-vline 
WA_MCVTTK_STR-AUSLG_VE sy-vline 
WA_MCVTTK_STR-BRVOL_VE sy-vline 
WA_MCVTTK_STR-NTVOL_VE sy-vline 
WA_MCVTTK_STR-MAVOL_VE sy-vline 
WA_MCVTTK_STR-TAVOL_VE sy-vline 
WA_MCVTTK_STR-VOLEH_TAR sy-vline 
WA_MCVTTK_STR-VOLEH_MAX sy-vline 
WA_MCVTTK_STR-AUSLV_VE sy-vline 
WA_MCVTTK_STR-VHILM_VE sy-vline 
WA_MCVTTK_STR-DURLP sy-vline 
WA_MCVTTK_STR-DURLA sy-vline 
WA_MCVTTK_STR-DURTP sy-vline 
WA_MCVTTK_STR-DURTA sy-vline 
WA_MCVTTK_STR-LATEL sy-vline 
WA_MCVTTK_STR-LATET sy-vline 
WA_MCVTTK_STR-LATES sy-vline 
WA_MCVTTK_STR-LATEE sy-vline 
WA_MCVTTK_STR-LATER sy-vline 
WA_MCVTTK_STR-LATEB sy-vline 
WA_MCVTTK_STR-DURGES sy-vline 
WA_MCVTTK_STR-DURFAH sy-vline 
WA_MCVTTK_STR-DURGESP sy-vline 
WA_MCVTTK_STR-DURFAHP sy-vline 
WA_MCVTTK_STR-STACUR sy-vline 
WA_MCVTTK_STR-HWAER sy-vline 
WA_MCVTTK_STR-ALLOW_TWG sy-vline 
WA_MCVTTK_STR-PKUNAG sy-vline 
WA_MCVTTK_STR-PKUNWE sy-vline 
WA_MCVTTK_STR-PKUNRE sy-vline 
WA_MCVTTK_STR-PKUNRG sy-vline 
WA_MCVTTK_STR-PTDLNR sy-vline 
WA_MCVTTK_STR-PTFRNR sy-vline 
WA_MCVTTK_STR-PTRFNR sy-vline 
WA_MCVTTK_STR-PTVENR sy-vline 
WA_MCVTTK_STR-PLAAG sy-vline 
WA_MCVTTK_STR-PLAWE sy-vline 
WA_MCVTTK_STR-PLARE sy-vline 
WA_MCVTTK_STR-PLARG sy-vline 
WA_MCVTTK_STR-PLASP sy-vline 
WA_MCVTTK_STR-PLAFF sy-vline 
WA_MCVTTK_STR-PLARF sy-vline 
WA_MCVTTK_STR-PLATV sy-vline 
WA_MCVTTK_STR-PABLA sy-vline 
WA_MCVTTK_STR-PZONE sy-vline 
WA_MCVTTK_STR-PDUMMY sy-vline 
WA_MCVTTK_STR-UDUMMY sy-vline      INTO ld_text SEPARATED BY SPACE.

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