ABAP Select data from SAP table VLCMVEHE 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 VLCMVEHE 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 VLCMVEHE. 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 VLCMVEHE 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_VLCMVEHE TYPE STANDARD TABLE OF VLCMVEHE,
      WA_VLCMVEHE TYPE VLCMVEHE,
      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: <VLCMVEHE> TYPE VLCMVEHE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VLCMVEHE
*  INTO TABLE @DATA(IT_VLCMVEHE2).
*--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_VLCMVEHE INDEX 1 INTO DATA(WA_VLCMVEHE2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<VLCMVEHE>-EXPAN = 1.
<VLCMVEHE>-CHBOX = 1.
<VLCMVEHE>-AMPEL = 1.
<VLCMVEHE>-MANDT = 1.
<VLCMVEHE>-VGUID = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_VLCMVEHE-VHCLE, sy-vline,
  WA_VLCMVEHE-MATNR, sy-vline,
  WA_VLCMVEHE-LIFNR, sy-vline,
  WA_VLCMVEHE-CHARG, sy-vline,
  WA_VLCMVEHE-EQUNR, sy-vline,
  WA_VLCMVEHE-WERKS, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_VLCMVEHE 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_VLCMVEHE 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_VLCMVEHE INTO WA_VLCMVEHE.


*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 MATN1, internal->external for field MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_VLCMVEHE-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VLCMVEHE-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field RQDEALER
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_VLCMVEHE-RQDEALER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VLCMVEHE-RQDEALER.
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_VLCMVEHE_STR, 
EXPAN TYPE STRING,
CHBOX TYPE STRING,
AMPEL TYPE STRING,
MANDT TYPE STRING,
VGUID TYPE STRING,
VHCLE TYPE STRING,
MATNR TYPE STRING,
LIFNR TYPE STRING,
CHARG TYPE STRING,
EQUNR TYPE STRING,
WERKS TYPE STRING,
LGORT TYPE STRING,
BWTAR TYPE STRING,
CUOBJ TYPE STRING,
CUABA TYPE STRING,
MMCTR TYPE STRING,
MMSTA TYPE STRING,
MMTSP TYPE STRING,
SDCTR TYPE STRING,
SDSTA TYPE STRING,
SDTSP TYPE STRING,
KUNNR TYPE STRING,
ENDCU TYPE STRING,
VHVIN TYPE STRING,
VHCEX TYPE STRING,
AVAIL TYPE STRING,
VBLTY TYPE STRING,
LOCTN TYPE STRING,
GPRICE TYPE STRING,
GPRICECUKY TYPE STRING,
CDTSP TYPE STRING,
PSTSP TYPE STRING,
PDTSP TYPE STRING,
ERNAM TYPE STRING,
VHUSG TYPE STRING,
CMPGN TYPE STRING,
PCOUNT TYPE STRING,
PCOUNT_U TYPE STRING,
IMMATDATE TYPE STRING,
VHSAR TYPE STRING,
VHORD TYPE STRING,
SHLVL TYPE STRING,
ARCHIVE_FLAG TYPE STRING,
USED_VEHICLE TYPE STRING,
DIGITALVEHICLEREFERENCEID TYPE STRING,
MMDATU TYPE STRING,
MMTIME TYPE STRING,
SDDATU TYPE STRING,
SDTIME TYPE STRING,
CDDATE TYPE STRING,
CDTIME TYPE STRING,
PSDATU TYPE STRING,
PSTIME TYPE STRING,
PDDATU TYPE STRING,
PDTIME TYPE STRING,
CSTRYEAR TYPE STRING,
CSTRMONTH TYPE STRING,
MATNRTXT TYPE STRING,
MMCTRTXT TYPE STRING,
MMSTATXT TYPE STRING,
SDCTRTXT TYPE STRING,
SDSTATXT TYPE STRING,
AVAILTXT TYPE STRING,
LOCTNCITY TYPE STRING,
LOCTNTXT TYPE STRING,
VHUSGTXT TYPE STRING,
VBLTYTXT TYPE STRING,
SHLVL_TXT TYPE STRING,
VHSARTXT TYPE STRING,
CMPGNTXT TYPE STRING,
ENDCUTXT TYPE STRING,
CU_NAME1 TYPE STRING,
SU_NAME1 TYPE STRING,
CONVPRICE TYPE STRING,
CONVPRICECUKY TYPE STRING,
WERKSNAME TYPE STRING,
XERROR TYPE STRING,
ACTLED TYPE STRING,
NEWTSP TYPE STRING,
ACTDOCTYPE TYPE STRING,
CATEGORY TYPE STRING,
ACTERNAM TYPE STRING,
PREV_VHCLE TYPE STRING,
FOLL_VHCLE TYPE STRING,
AKNCAT TYPE STRING,
AKNCATT TYPE STRING,
RESDATFROM TYPE STRING,
RESDATTO TYPE STRING,
VBELN TYPE STRING,
KUNNR_SD TYPE STRING,
KUNAM_SD TYPE STRING,
KUNWE_SD TYPE STRING,
WENAM_SD TYPE STRING,
KUNRE_SD TYPE STRING,
RENAM_SD TYPE STRING,
KUNRG_SD TYPE STRING,
RGNAM_SD TYPE STRING,
ANGDT TYPE STRING,
BNDDT TYPE STRING,
AUDAT TYPE STRING,
VBTYP TYPE STRING,
AUART TYPE STRING,
AUGRU TYPE STRING,
VSART TYPE STRING,
ABSTK TYPE STRING,
FAKSK TYPE STRING,
NETWR TYPE STRING,
WAERK TYPE STRING,
VKORG TYPE STRING,
VKORGTXT TYPE STRING,
VTWEG TYPE STRING,
VTWEGTXT TYPE STRING,
SPART TYPE STRING,
SPARTTXT TYPE STRING,
VKGRP TYPE STRING,
VKBUR TYPE STRING,
VDATU TYPE STRING,
BSTNK TYPE STRING,
BSTDK TYPE STRING,
ERDAT TYPE STRING,
ERDAT_SD TYPE STRING,
ERNAM_SD TYPE STRING,
AEDAT TYPE STRING,
UPD_TMSTMP TYPE STRING,
POSNR TYPE STRING,
CUOBJ_SD TYPE STRING,
ARKTX TYPE STRING,
PSTYV TYPE STRING,
POSAR TYPE STRING,
LFREL TYPE STRING,
FKREL TYPE STRING,
ABGRU TYPE STRING,
ZMENG TYPE STRING,
ZIEME TYPE STRING,
OPTYPE TYPE STRING,
OPTYPET TYPE STRING,
VSTATU TYPE STRING,
VSTATUT TYPE STRING,
TRGUID TYPE STRING,
DVDEALER TYPE STRING,
DVDEALNAM TYPE STRING,
RQDEALER TYPE STRING,
RQDEALNAM TYPE STRING,
TRANSSTAT TYPE STRING,
TRANSSTATT TYPE STRING,
TIMESTAMP TYPE STRING,
TRTIME TYPE STRING,
TRDATE TYPE STRING,
ACTION TYPE STRING,
AKTIONT TYPE STRING,
DOCNUM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_VLCMVEHE_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_VLCMVEHE_STR-EXPAN sy-vline 
WA_VLCMVEHE_STR-CHBOX sy-vline 
WA_VLCMVEHE_STR-AMPEL sy-vline 
WA_VLCMVEHE_STR-MANDT sy-vline 
WA_VLCMVEHE_STR-VGUID sy-vline 
WA_VLCMVEHE_STR-VHCLE sy-vline 
WA_VLCMVEHE_STR-MATNR sy-vline 
WA_VLCMVEHE_STR-LIFNR sy-vline 
WA_VLCMVEHE_STR-CHARG sy-vline 
WA_VLCMVEHE_STR-EQUNR sy-vline 
WA_VLCMVEHE_STR-WERKS sy-vline 
WA_VLCMVEHE_STR-LGORT sy-vline 
WA_VLCMVEHE_STR-BWTAR sy-vline 
WA_VLCMVEHE_STR-CUOBJ sy-vline 
WA_VLCMVEHE_STR-CUABA sy-vline 
WA_VLCMVEHE_STR-MMCTR sy-vline 
WA_VLCMVEHE_STR-MMSTA sy-vline 
WA_VLCMVEHE_STR-MMTSP sy-vline 
WA_VLCMVEHE_STR-SDCTR sy-vline 
WA_VLCMVEHE_STR-SDSTA sy-vline 
WA_VLCMVEHE_STR-SDTSP sy-vline 
WA_VLCMVEHE_STR-KUNNR sy-vline 
WA_VLCMVEHE_STR-ENDCU sy-vline 
WA_VLCMVEHE_STR-VHVIN sy-vline 
WA_VLCMVEHE_STR-VHCEX sy-vline 
WA_VLCMVEHE_STR-AVAIL sy-vline 
WA_VLCMVEHE_STR-VBLTY sy-vline 
WA_VLCMVEHE_STR-LOCTN sy-vline 
WA_VLCMVEHE_STR-GPRICE sy-vline 
WA_VLCMVEHE_STR-GPRICECUKY sy-vline 
WA_VLCMVEHE_STR-CDTSP sy-vline 
WA_VLCMVEHE_STR-PSTSP sy-vline 
WA_VLCMVEHE_STR-PDTSP sy-vline 
WA_VLCMVEHE_STR-ERNAM sy-vline 
WA_VLCMVEHE_STR-VHUSG sy-vline 
WA_VLCMVEHE_STR-CMPGN sy-vline 
WA_VLCMVEHE_STR-PCOUNT sy-vline 
WA_VLCMVEHE_STR-PCOUNT_U sy-vline 
WA_VLCMVEHE_STR-IMMATDATE sy-vline 
WA_VLCMVEHE_STR-VHSAR sy-vline 
WA_VLCMVEHE_STR-VHORD sy-vline 
WA_VLCMVEHE_STR-SHLVL sy-vline 
WA_VLCMVEHE_STR-ARCHIVE_FLAG sy-vline 
WA_VLCMVEHE_STR-USED_VEHICLE sy-vline 
WA_VLCMVEHE_STR-DIGITALVEHICLEREFERENCEID sy-vline 
WA_VLCMVEHE_STR-MMDATU sy-vline 
WA_VLCMVEHE_STR-MMTIME sy-vline 
WA_VLCMVEHE_STR-SDDATU sy-vline 
WA_VLCMVEHE_STR-SDTIME sy-vline 
WA_VLCMVEHE_STR-CDDATE sy-vline 
WA_VLCMVEHE_STR-CDTIME sy-vline 
WA_VLCMVEHE_STR-PSDATU sy-vline 
WA_VLCMVEHE_STR-PSTIME sy-vline 
WA_VLCMVEHE_STR-PDDATU sy-vline 
WA_VLCMVEHE_STR-PDTIME sy-vline 
WA_VLCMVEHE_STR-CSTRYEAR sy-vline 
WA_VLCMVEHE_STR-CSTRMONTH sy-vline 
WA_VLCMVEHE_STR-MATNRTXT sy-vline 
WA_VLCMVEHE_STR-MMCTRTXT sy-vline 
WA_VLCMVEHE_STR-MMSTATXT sy-vline 
WA_VLCMVEHE_STR-SDCTRTXT sy-vline 
WA_VLCMVEHE_STR-SDSTATXT sy-vline 
WA_VLCMVEHE_STR-AVAILTXT sy-vline 
WA_VLCMVEHE_STR-LOCTNCITY sy-vline 
WA_VLCMVEHE_STR-LOCTNTXT sy-vline 
WA_VLCMVEHE_STR-VHUSGTXT sy-vline 
WA_VLCMVEHE_STR-VBLTYTXT sy-vline 
WA_VLCMVEHE_STR-SHLVL_TXT sy-vline 
WA_VLCMVEHE_STR-VHSARTXT sy-vline 
WA_VLCMVEHE_STR-CMPGNTXT sy-vline 
WA_VLCMVEHE_STR-ENDCUTXT sy-vline 
WA_VLCMVEHE_STR-CU_NAME1 sy-vline 
WA_VLCMVEHE_STR-SU_NAME1 sy-vline 
WA_VLCMVEHE_STR-CONVPRICE sy-vline 
WA_VLCMVEHE_STR-CONVPRICECUKY sy-vline 
WA_VLCMVEHE_STR-WERKSNAME sy-vline 
WA_VLCMVEHE_STR-XERROR sy-vline 
WA_VLCMVEHE_STR-ACTLED sy-vline 
WA_VLCMVEHE_STR-NEWTSP sy-vline 
WA_VLCMVEHE_STR-ACTDOCTYPE sy-vline 
WA_VLCMVEHE_STR-CATEGORY sy-vline 
WA_VLCMVEHE_STR-ACTERNAM sy-vline 
WA_VLCMVEHE_STR-PREV_VHCLE sy-vline 
WA_VLCMVEHE_STR-FOLL_VHCLE sy-vline 
WA_VLCMVEHE_STR-AKNCAT sy-vline 
WA_VLCMVEHE_STR-AKNCATT sy-vline 
WA_VLCMVEHE_STR-RESDATFROM sy-vline 
WA_VLCMVEHE_STR-RESDATTO sy-vline 
WA_VLCMVEHE_STR-VBELN sy-vline 
WA_VLCMVEHE_STR-KUNNR_SD sy-vline 
WA_VLCMVEHE_STR-KUNAM_SD sy-vline 
WA_VLCMVEHE_STR-KUNWE_SD sy-vline 
WA_VLCMVEHE_STR-WENAM_SD sy-vline 
WA_VLCMVEHE_STR-KUNRE_SD sy-vline 
WA_VLCMVEHE_STR-RENAM_SD sy-vline 
WA_VLCMVEHE_STR-KUNRG_SD sy-vline 
WA_VLCMVEHE_STR-RGNAM_SD sy-vline 
WA_VLCMVEHE_STR-ANGDT sy-vline 
WA_VLCMVEHE_STR-BNDDT sy-vline 
WA_VLCMVEHE_STR-AUDAT sy-vline 
WA_VLCMVEHE_STR-VBTYP sy-vline 
WA_VLCMVEHE_STR-AUART sy-vline 
WA_VLCMVEHE_STR-AUGRU sy-vline 
WA_VLCMVEHE_STR-VSART sy-vline 
WA_VLCMVEHE_STR-ABSTK sy-vline 
WA_VLCMVEHE_STR-FAKSK sy-vline 
WA_VLCMVEHE_STR-NETWR sy-vline 
WA_VLCMVEHE_STR-WAERK sy-vline 
WA_VLCMVEHE_STR-VKORG sy-vline 
WA_VLCMVEHE_STR-VKORGTXT sy-vline 
WA_VLCMVEHE_STR-VTWEG sy-vline 
WA_VLCMVEHE_STR-VTWEGTXT sy-vline 
WA_VLCMVEHE_STR-SPART sy-vline 
WA_VLCMVEHE_STR-SPARTTXT sy-vline 
WA_VLCMVEHE_STR-VKGRP sy-vline 
WA_VLCMVEHE_STR-VKBUR sy-vline 
WA_VLCMVEHE_STR-VDATU sy-vline 
WA_VLCMVEHE_STR-BSTNK sy-vline 
WA_VLCMVEHE_STR-BSTDK sy-vline 
WA_VLCMVEHE_STR-ERDAT sy-vline 
WA_VLCMVEHE_STR-ERDAT_SD sy-vline 
WA_VLCMVEHE_STR-ERNAM_SD sy-vline 
WA_VLCMVEHE_STR-AEDAT sy-vline 
WA_VLCMVEHE_STR-UPD_TMSTMP sy-vline 
WA_VLCMVEHE_STR-POSNR sy-vline 
WA_VLCMVEHE_STR-CUOBJ_SD sy-vline 
WA_VLCMVEHE_STR-ARKTX sy-vline 
WA_VLCMVEHE_STR-PSTYV sy-vline 
WA_VLCMVEHE_STR-POSAR sy-vline 
WA_VLCMVEHE_STR-LFREL sy-vline 
WA_VLCMVEHE_STR-FKREL sy-vline 
WA_VLCMVEHE_STR-ABGRU sy-vline 
WA_VLCMVEHE_STR-ZMENG sy-vline 
WA_VLCMVEHE_STR-ZIEME sy-vline 
WA_VLCMVEHE_STR-OPTYPE sy-vline 
WA_VLCMVEHE_STR-OPTYPET sy-vline 
WA_VLCMVEHE_STR-VSTATU sy-vline 
WA_VLCMVEHE_STR-VSTATUT sy-vline 
WA_VLCMVEHE_STR-TRGUID sy-vline 
WA_VLCMVEHE_STR-DVDEALER sy-vline 
WA_VLCMVEHE_STR-DVDEALNAM sy-vline 
WA_VLCMVEHE_STR-RQDEALER sy-vline 
WA_VLCMVEHE_STR-RQDEALNAM sy-vline 
WA_VLCMVEHE_STR-TRANSSTAT sy-vline 
WA_VLCMVEHE_STR-TRANSSTATT sy-vline 
WA_VLCMVEHE_STR-TIMESTAMP sy-vline 
WA_VLCMVEHE_STR-TRTIME sy-vline 
WA_VLCMVEHE_STR-TRDATE sy-vline 
WA_VLCMVEHE_STR-ACTION sy-vline 
WA_VLCMVEHE_STR-AKTIONT sy-vline 
WA_VLCMVEHE_STR-DOCNUM sy-vline      INTO ld_text SEPARATED BY SPACE.

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