ABAP Select data from SAP table VTVFGDI1 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 VTVFGDI1 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 VTVFGDI1. 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 VTVFGDI1 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_VTVFGDI1 TYPE STANDARD TABLE OF VTVFGDI1,
      WA_VTVFGDI1 TYPE VTVFGDI1,
      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: <VTVFGDI1> TYPE VTVFGDI1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VTVFGDI1
*  INTO TABLE @DATA(IT_VTVFGDI12).
*--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_VTVFGDI1 INDEX 1 INTO DATA(WA_VTVFGDI12).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<VTVFGDI1>-AKTYP = 1.
<VTVFGDI1>-RLTP1 = 1.
<VTVFGDI1>-RLTP2 = 1.
<VTVFGDI1>-RLTP3 = 1.
<VTVFGDI1>-RLTP4 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_VTVFGDI1-RLTP5, sy-vline,
  WA_VTVFGDI1-RLTP6, sy-vline,
  WA_VTVFGDI1-RLTP7, sy-vline,
  WA_VTVFGDI1-RLTP8, sy-vline,
  WA_VTVFGDI1-RLTP9, sy-vline,
  WA_VTVFGDI1-RIDEXT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_VTVFGDI1 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_VTVFGDI1 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_VTVFGDI1 INTO WA_VTVFGDI1.


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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field PRICE_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_VTVFGDI1-PRICE_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTVFGDI1-PRICE_UOM.
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_VTVFGDI1_STR, 
AKTYP TYPE STRING,
RLTP1 TYPE STRING,
RLTP2 TYPE STRING,
RLTP3 TYPE STRING,
RLTP4 TYPE STRING,
RLTP5 TYPE STRING,
RLTP6 TYPE STRING,
RLTP7 TYPE STRING,
RLTP8 TYPE STRING,
RLTP9 TYPE STRING,
RIDEXT TYPE STRING,
DGUELTAB TYPE STRING,
CHIND_40 TYPE STRING,
XTEXT TYPE STRING,
SSTAT TYPE STRING,
SVERS TYPE STRING,
BUKRS TYPE STRING,
RWKN TYPE STRING,
RPORTB TYPE STRING,
RDEALER TYPE STRING,
PARTNR TYPE STRING,
WAEHRUNG TYPE STRING,
ARR TYPE STRING,
SLPG TYPE STRING,
GRUPP TYPE STRING,
EBENE TYPE STRING,
DISPW TYPE STRING,
CHIND_41 TYPE STRING,
RLDEPO TYPE STRING,
CHIND_42 TYPE STRING,
NGIDNR TYPE STRING,
NBRANCH TYPE STRING,
AGGREGRULE TYPE STRING,
RMBEWREG TYPE STRING,
GFORM TYPE STRING,
GDETAIL TYPE STRING,
KATEKZ TYPE STRING,
AGGRKZ TYPE STRING,
DBLFZ TYPE STRING,
DELFZ TYPE STRING,
SFGTYP TYPE STRING,
SNOTTYPE TYPE STRING,
SNOMWHR TYPE STRING,
BNOMINAL TYPE STRING,
ASTUECK TYPE STRING,
WGSCHFT1 TYPE STRING,
WGSCHFT2 TYPE STRING,
BNOMI1 TYPE STRING,
BNOMI2 TYPE STRING,
BSALDO TYPE STRING,
DEFSZ TYPE STRING,
RANL TYPE STRING,
RHANDPL TYPE STRING,
IDX TYPE STRING,
IDXVAL TYPE STRING,
BPIDX TYPE STRING,
SPIDX TYPE STRING,
KKURSWP TYPE STRING,
DDEKSE TYPE STRING,
SSHLNG TYPE STRING,
SEZWHR TYPE STRING,
BEZWHR TYPE STRING,
RIDEXTRTEXT TYPE STRING,
BETICK TYPE STRING,
BWTICK TYPE STRING,
URANL TYPE STRING,
CTY_ID TYPE STRING,
QUOTSRC TYPE STRING,
BETICK_SEC TYPE STRING,
BWTICK_SEC TYPE STRING,
WWTICK TYPE STRING,
PPTICK TYPE STRING,
PITICK TYPE STRING,
CTY_QUANTITY TYPE STRING,
CTY_UOM TYPE STRING,
CSPREAD TYPE STRING,
CTY_ID2 TYPE STRING,
CSPREAD_FWD TYPE STRING,
EXP_APPR_CAT TYPE STRING,
CONTRACT_VALUE TYPE STRING,
CONTRACT_VALUE_CURR TYPE STRING,
FORWARD_DATE TYPE STRING,
BETICK_CTY_CUNIT TYPE STRING,
CURRENT_ACTIVITY_CATEGORY TYPE STRING,
LEAD_FGET TYPE STRING,
P_BUKRS TYPE STRING,
P_RANLALT1 TYPE STRING,
P_RANL TYPE STRING,
P_NORDEXT TYPE STRING,
P_NORDER TYPE STRING,
P_RBKONT TYPE STRING,
P_REXTNR TYPE STRING,
P_RFHA TYPE STRING,
P_RUBEST TYPE STRING,
P_RANLW TYPE STRING,
P_RLDEPO TYPE STRING,
P_SSHLNG TYPE STRING,
P_WKN TYPE STRING,
CHIND_43 TYPE STRING,
OPTI_NGIDNR TYPE STRING,
U_DDISPO TYPE STRING,
U_SNOTTYP TYPE STRING,
SABRMET TYPE STRING,
SETTLFL TYPE STRING,
SOPTAUS TYPE STRING,
OFWAERS TYPE STRING,
OSTRIKE TYPE STRING,
OSKURS TYPE STRING,
OSBPRICE TYPE STRING,
OSINDEX TYPE STRING,
OBNOTPT TYPE STRING,
OSPROZE TYPE STRING,
OBPROZE TYPE STRING,
OPTTYP TYPE STRING,
OPTTYP_AKT TYPE STRING,
OBEZVH TYPE STRING,
REWAERS TYPE STRING,
REBETR TYPE STRING,
RESSIGN TYPE STRING,
REDATE TYPE STRING,
B1OSTRIKE TYPE STRING,
B1OSBPRICE TYPE STRING,
B1OSINDEX TYPE STRING,
B1OSPROZE TYPE STRING,
B1OSKURS TYPE STRING,
BA1RBETR TYPE STRING,
BA1RWAER TYPE STRING,
BA1RDAT TYPE STRING,
BA1RSSIGN TYPE STRING,
B2OSTRIKE TYPE STRING,
B2OSBPRICE TYPE STRING,
B2OSINDEX TYPE STRING,
B2OSPROZE TYPE STRING,
B2OSKURS TYPE STRING,
BA2RBETR TYPE STRING,
BA2RWAER TYPE STRING,
BA2RDAT TYPE STRING,
BA2RSSIGN TYPE STRING,
SPUTCALL TYPE STRING,
VORZEIT TYPE STRING,
TOTALSAMPLECOUNT TYPE STRING,
FIXEDSAMPLECOUNT TYPE STRING,
FIXEDSPOTAVERAGE TYPE STRING,
NEXTSAMPLEDATE TYPE STRING,
FIXEDVOLATILITY TYPE STRING,
CHIND_44 TYPE STRING,
CHIND_44_COM TYPE STRING,
BEWEG_NGIDNR TYPE STRING,
COMBEWEG_NGIDNR TYPE STRING,
NCFNR TYPE STRING,
CFART TYPE STRING,
RKONDGR TYPE STRING,
SSIGN TYPE STRING,
SCWHR TYPE STRING,
BCWHR TYPE STRING,
DFAELL TYPE STRING,
DDISPO TYPE STRING,
DBERVON TYPE STRING,
DBERBIS TYPE STRING,
SZBMETH TYPE STRING,
ABASTAGE TYPE STRING,
ATAGE TYPE STRING,
CF_ASTCK TYPE STRING,
SNWHR TYPE STRING,
BNWHR TYPE STRING,
PKOND TYPE STRING,
SZSREF TYPE STRING,
SZSREFVZ TYPE STRING,
SOFFSET TYPE STRING,
SFORMREF TYPE STRING,
DZFEST TYPE STRING,
JSOFVERR TYPE STRING,
OPPZINS TYPE STRING,
FIKTKZ TYPE STRING,
SBWHR TYPE STRING,
BBWHR TYPE STRING,
XKURSKNZ TYPE STRING,
KKURS TYPE STRING,
SZINSART TYPE STRING,
FX_FIX_DATE TYPE STRING,
FX_SETTL_CRCY TYPE STRING,
SVARNAME_1 TYPE STRING,
PKOND_1 TYPE STRING,
SZSREF_1 TYPE STRING,
SVARNAME_2 TYPE STRING,
PKOND_2 TYPE STRING,
SZSREF_2 TYPE STRING,
SVARNAME_3 TYPE STRING,
PKOND_3 TYPE STRING,
SZSREF_3 TYPE STRING,
SVARNAME_4 TYPE STRING,
PKOND_4 TYPE STRING,
SZSREF_4 TYPE STRING,
SVARNAME_5 TYPE STRING,
PKOND_5 TYPE STRING,
SZSREF_5 TYPE STRING,
SVARNAME_6 TYPE STRING,
PKOND_6 TYPE STRING,
SZSREF_6 TYPE STRING,
FLOW_GROUP_ID TYPE STRING,
CTY_FLOW_CAT TYPE STRING,
COMMODITY_ID TYPE STRING,
QUANTITY TYPE STRING,
UNIT_OF_MEASURE TYPE STRING,
WEIGHTAGE TYPE STRING,
PAYMENT_DATE TYPE STRING,
PRICING_DATE TYPE STRING,
DELIVERY_DATE TYPE STRING,
CTY_PRICE TYPE STRING,
PRICE_CURR TYPE STRING,
PRICE_UOQ TYPE STRING,
PRICE_UOM TYPE STRING,
SPREAD TYPE STRING,
QUOT_SRC TYPE STRING,
QUOT_TYPE TYPE STRING,
QUOT_TIME TYPE STRING,
DCSID TYPE STRING,
MIC TYPE STRING,
PRICETYPE TYPE STRING,
TENOR TYPE STRING,
TIMING TYPE STRING,
KEYDATE TYPE STRING,
AVG_PERIOD_START TYPE STRING,
AVG_PERIOD_END TYPE STRING,END OF T_EKKO_STR.
DATA: WA_VTVFGDI1_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_VTVFGDI1_STR-AKTYP sy-vline 
WA_VTVFGDI1_STR-RLTP1 sy-vline 
WA_VTVFGDI1_STR-RLTP2 sy-vline 
WA_VTVFGDI1_STR-RLTP3 sy-vline 
WA_VTVFGDI1_STR-RLTP4 sy-vline 
WA_VTVFGDI1_STR-RLTP5 sy-vline 
WA_VTVFGDI1_STR-RLTP6 sy-vline 
WA_VTVFGDI1_STR-RLTP7 sy-vline 
WA_VTVFGDI1_STR-RLTP8 sy-vline 
WA_VTVFGDI1_STR-RLTP9 sy-vline 
WA_VTVFGDI1_STR-RIDEXT sy-vline 
WA_VTVFGDI1_STR-DGUELTAB sy-vline 
WA_VTVFGDI1_STR-CHIND_40 sy-vline 
WA_VTVFGDI1_STR-XTEXT sy-vline 
WA_VTVFGDI1_STR-SSTAT sy-vline 
WA_VTVFGDI1_STR-SVERS sy-vline 
WA_VTVFGDI1_STR-BUKRS sy-vline 
WA_VTVFGDI1_STR-RWKN sy-vline 
WA_VTVFGDI1_STR-RPORTB sy-vline 
WA_VTVFGDI1_STR-RDEALER sy-vline 
WA_VTVFGDI1_STR-PARTNR sy-vline 
WA_VTVFGDI1_STR-WAEHRUNG sy-vline 
WA_VTVFGDI1_STR-ARR sy-vline 
WA_VTVFGDI1_STR-SLPG sy-vline 
WA_VTVFGDI1_STR-GRUPP sy-vline 
WA_VTVFGDI1_STR-EBENE sy-vline 
WA_VTVFGDI1_STR-DISPW sy-vline 
WA_VTVFGDI1_STR-CHIND_41 sy-vline 
WA_VTVFGDI1_STR-RLDEPO sy-vline 
WA_VTVFGDI1_STR-CHIND_42 sy-vline 
WA_VTVFGDI1_STR-NGIDNR sy-vline 
WA_VTVFGDI1_STR-NBRANCH sy-vline 
WA_VTVFGDI1_STR-AGGREGRULE sy-vline 
WA_VTVFGDI1_STR-RMBEWREG sy-vline 
WA_VTVFGDI1_STR-GFORM sy-vline 
WA_VTVFGDI1_STR-GDETAIL sy-vline 
WA_VTVFGDI1_STR-KATEKZ sy-vline 
WA_VTVFGDI1_STR-AGGRKZ sy-vline 
WA_VTVFGDI1_STR-DBLFZ sy-vline 
WA_VTVFGDI1_STR-DELFZ sy-vline 
WA_VTVFGDI1_STR-SFGTYP sy-vline 
WA_VTVFGDI1_STR-SNOTTYPE sy-vline 
WA_VTVFGDI1_STR-SNOMWHR sy-vline 
WA_VTVFGDI1_STR-BNOMINAL sy-vline 
WA_VTVFGDI1_STR-ASTUECK sy-vline 
WA_VTVFGDI1_STR-WGSCHFT1 sy-vline 
WA_VTVFGDI1_STR-WGSCHFT2 sy-vline 
WA_VTVFGDI1_STR-BNOMI1 sy-vline 
WA_VTVFGDI1_STR-BNOMI2 sy-vline 
WA_VTVFGDI1_STR-BSALDO sy-vline 
WA_VTVFGDI1_STR-DEFSZ sy-vline 
WA_VTVFGDI1_STR-RANL sy-vline 
WA_VTVFGDI1_STR-RHANDPL sy-vline 
WA_VTVFGDI1_STR-IDX sy-vline 
WA_VTVFGDI1_STR-IDXVAL sy-vline 
WA_VTVFGDI1_STR-BPIDX sy-vline 
WA_VTVFGDI1_STR-SPIDX sy-vline 
WA_VTVFGDI1_STR-KKURSWP sy-vline 
WA_VTVFGDI1_STR-DDEKSE sy-vline 
WA_VTVFGDI1_STR-SSHLNG sy-vline 
WA_VTVFGDI1_STR-SEZWHR sy-vline 
WA_VTVFGDI1_STR-BEZWHR sy-vline 
WA_VTVFGDI1_STR-RIDEXTRTEXT sy-vline 
WA_VTVFGDI1_STR-BETICK sy-vline 
WA_VTVFGDI1_STR-BWTICK sy-vline 
WA_VTVFGDI1_STR-URANL sy-vline 
WA_VTVFGDI1_STR-CTY_ID sy-vline 
WA_VTVFGDI1_STR-QUOTSRC sy-vline 
WA_VTVFGDI1_STR-BETICK_SEC sy-vline 
WA_VTVFGDI1_STR-BWTICK_SEC sy-vline 
WA_VTVFGDI1_STR-WWTICK sy-vline 
WA_VTVFGDI1_STR-PPTICK sy-vline 
WA_VTVFGDI1_STR-PITICK sy-vline 
WA_VTVFGDI1_STR-CTY_QUANTITY sy-vline 
WA_VTVFGDI1_STR-CTY_UOM sy-vline 
WA_VTVFGDI1_STR-CSPREAD sy-vline 
WA_VTVFGDI1_STR-CTY_ID2 sy-vline 
WA_VTVFGDI1_STR-CSPREAD_FWD sy-vline 
WA_VTVFGDI1_STR-EXP_APPR_CAT sy-vline 
WA_VTVFGDI1_STR-CONTRACT_VALUE sy-vline 
WA_VTVFGDI1_STR-CONTRACT_VALUE_CURR sy-vline 
WA_VTVFGDI1_STR-FORWARD_DATE sy-vline 
WA_VTVFGDI1_STR-BETICK_CTY_CUNIT sy-vline 
WA_VTVFGDI1_STR-CURRENT_ACTIVITY_CATEGORY sy-vline 
WA_VTVFGDI1_STR-LEAD_FGET sy-vline 
WA_VTVFGDI1_STR-P_BUKRS sy-vline 
WA_VTVFGDI1_STR-P_RANLALT1 sy-vline 
WA_VTVFGDI1_STR-P_RANL sy-vline 
WA_VTVFGDI1_STR-P_NORDEXT sy-vline 
WA_VTVFGDI1_STR-P_NORDER sy-vline 
WA_VTVFGDI1_STR-P_RBKONT sy-vline 
WA_VTVFGDI1_STR-P_REXTNR sy-vline 
WA_VTVFGDI1_STR-P_RFHA sy-vline 
WA_VTVFGDI1_STR-P_RUBEST sy-vline 
WA_VTVFGDI1_STR-P_RANLW sy-vline 
WA_VTVFGDI1_STR-P_RLDEPO sy-vline 
WA_VTVFGDI1_STR-P_SSHLNG sy-vline 
WA_VTVFGDI1_STR-P_WKN sy-vline 
WA_VTVFGDI1_STR-CHIND_43 sy-vline 
WA_VTVFGDI1_STR-OPTI_NGIDNR sy-vline 
WA_VTVFGDI1_STR-U_DDISPO sy-vline 
WA_VTVFGDI1_STR-U_SNOTTYP sy-vline 
WA_VTVFGDI1_STR-SABRMET sy-vline 
WA_VTVFGDI1_STR-SETTLFL sy-vline 
WA_VTVFGDI1_STR-SOPTAUS sy-vline 
WA_VTVFGDI1_STR-OFWAERS sy-vline 
WA_VTVFGDI1_STR-OSTRIKE sy-vline 
WA_VTVFGDI1_STR-OSKURS sy-vline 
WA_VTVFGDI1_STR-OSBPRICE sy-vline 
WA_VTVFGDI1_STR-OSINDEX sy-vline 
WA_VTVFGDI1_STR-OBNOTPT sy-vline 
WA_VTVFGDI1_STR-OSPROZE sy-vline 
WA_VTVFGDI1_STR-OBPROZE sy-vline 
WA_VTVFGDI1_STR-OPTTYP sy-vline 
WA_VTVFGDI1_STR-OPTTYP_AKT sy-vline 
WA_VTVFGDI1_STR-OBEZVH sy-vline 
WA_VTVFGDI1_STR-REWAERS sy-vline 
WA_VTVFGDI1_STR-REBETR sy-vline 
WA_VTVFGDI1_STR-RESSIGN sy-vline 
WA_VTVFGDI1_STR-REDATE sy-vline 
WA_VTVFGDI1_STR-B1OSTRIKE sy-vline 
WA_VTVFGDI1_STR-B1OSBPRICE sy-vline 
WA_VTVFGDI1_STR-B1OSINDEX sy-vline 
WA_VTVFGDI1_STR-B1OSPROZE sy-vline 
WA_VTVFGDI1_STR-B1OSKURS sy-vline 
WA_VTVFGDI1_STR-BA1RBETR sy-vline 
WA_VTVFGDI1_STR-BA1RWAER sy-vline 
WA_VTVFGDI1_STR-BA1RDAT sy-vline 
WA_VTVFGDI1_STR-BA1RSSIGN sy-vline 
WA_VTVFGDI1_STR-B2OSTRIKE sy-vline 
WA_VTVFGDI1_STR-B2OSBPRICE sy-vline 
WA_VTVFGDI1_STR-B2OSINDEX sy-vline 
WA_VTVFGDI1_STR-B2OSPROZE sy-vline 
WA_VTVFGDI1_STR-B2OSKURS sy-vline 
WA_VTVFGDI1_STR-BA2RBETR sy-vline 
WA_VTVFGDI1_STR-BA2RWAER sy-vline 
WA_VTVFGDI1_STR-BA2RDAT sy-vline 
WA_VTVFGDI1_STR-BA2RSSIGN sy-vline 
WA_VTVFGDI1_STR-SPUTCALL sy-vline 
WA_VTVFGDI1_STR-VORZEIT sy-vline 
WA_VTVFGDI1_STR-TOTALSAMPLECOUNT sy-vline 
WA_VTVFGDI1_STR-FIXEDSAMPLECOUNT sy-vline 
WA_VTVFGDI1_STR-FIXEDSPOTAVERAGE sy-vline 
WA_VTVFGDI1_STR-NEXTSAMPLEDATE sy-vline 
WA_VTVFGDI1_STR-FIXEDVOLATILITY sy-vline 
WA_VTVFGDI1_STR-CHIND_44 sy-vline 
WA_VTVFGDI1_STR-CHIND_44_COM sy-vline 
WA_VTVFGDI1_STR-BEWEG_NGIDNR sy-vline 
WA_VTVFGDI1_STR-COMBEWEG_NGIDNR sy-vline 
WA_VTVFGDI1_STR-NCFNR sy-vline 
WA_VTVFGDI1_STR-CFART sy-vline 
WA_VTVFGDI1_STR-RKONDGR sy-vline 
WA_VTVFGDI1_STR-SSIGN sy-vline 
WA_VTVFGDI1_STR-SCWHR sy-vline 
WA_VTVFGDI1_STR-BCWHR sy-vline 
WA_VTVFGDI1_STR-DFAELL sy-vline 
WA_VTVFGDI1_STR-DDISPO sy-vline 
WA_VTVFGDI1_STR-DBERVON sy-vline 
WA_VTVFGDI1_STR-DBERBIS sy-vline 
WA_VTVFGDI1_STR-SZBMETH sy-vline 
WA_VTVFGDI1_STR-ABASTAGE sy-vline 
WA_VTVFGDI1_STR-ATAGE sy-vline 
WA_VTVFGDI1_STR-CF_ASTCK sy-vline 
WA_VTVFGDI1_STR-SNWHR sy-vline 
WA_VTVFGDI1_STR-BNWHR sy-vline 
WA_VTVFGDI1_STR-PKOND sy-vline 
WA_VTVFGDI1_STR-SZSREF sy-vline 
WA_VTVFGDI1_STR-SZSREFVZ sy-vline 
WA_VTVFGDI1_STR-SOFFSET sy-vline 
WA_VTVFGDI1_STR-SFORMREF sy-vline 
WA_VTVFGDI1_STR-DZFEST sy-vline 
WA_VTVFGDI1_STR-JSOFVERR sy-vline 
WA_VTVFGDI1_STR-OPPZINS sy-vline 
WA_VTVFGDI1_STR-FIKTKZ sy-vline 
WA_VTVFGDI1_STR-SBWHR sy-vline 
WA_VTVFGDI1_STR-BBWHR sy-vline 
WA_VTVFGDI1_STR-XKURSKNZ sy-vline 
WA_VTVFGDI1_STR-KKURS sy-vline 
WA_VTVFGDI1_STR-SZINSART sy-vline 
WA_VTVFGDI1_STR-FX_FIX_DATE sy-vline 
WA_VTVFGDI1_STR-FX_SETTL_CRCY sy-vline 
WA_VTVFGDI1_STR-SVARNAME_1 sy-vline 
WA_VTVFGDI1_STR-PKOND_1 sy-vline 
WA_VTVFGDI1_STR-SZSREF_1 sy-vline 
WA_VTVFGDI1_STR-SVARNAME_2 sy-vline 
WA_VTVFGDI1_STR-PKOND_2 sy-vline 
WA_VTVFGDI1_STR-SZSREF_2 sy-vline 
WA_VTVFGDI1_STR-SVARNAME_3 sy-vline 
WA_VTVFGDI1_STR-PKOND_3 sy-vline 
WA_VTVFGDI1_STR-SZSREF_3 sy-vline 
WA_VTVFGDI1_STR-SVARNAME_4 sy-vline 
WA_VTVFGDI1_STR-PKOND_4 sy-vline 
WA_VTVFGDI1_STR-SZSREF_4 sy-vline 
WA_VTVFGDI1_STR-SVARNAME_5 sy-vline 
WA_VTVFGDI1_STR-PKOND_5 sy-vline 
WA_VTVFGDI1_STR-SZSREF_5 sy-vline 
WA_VTVFGDI1_STR-SVARNAME_6 sy-vline 
WA_VTVFGDI1_STR-PKOND_6 sy-vline 
WA_VTVFGDI1_STR-SZSREF_6 sy-vline 
WA_VTVFGDI1_STR-FLOW_GROUP_ID sy-vline 
WA_VTVFGDI1_STR-CTY_FLOW_CAT sy-vline 
WA_VTVFGDI1_STR-COMMODITY_ID sy-vline 
WA_VTVFGDI1_STR-QUANTITY sy-vline 
WA_VTVFGDI1_STR-UNIT_OF_MEASURE sy-vline 
WA_VTVFGDI1_STR-WEIGHTAGE sy-vline 
WA_VTVFGDI1_STR-PAYMENT_DATE sy-vline 
WA_VTVFGDI1_STR-PRICING_DATE sy-vline 
WA_VTVFGDI1_STR-DELIVERY_DATE sy-vline 
WA_VTVFGDI1_STR-CTY_PRICE sy-vline 
WA_VTVFGDI1_STR-PRICE_CURR sy-vline 
WA_VTVFGDI1_STR-PRICE_UOQ sy-vline 
WA_VTVFGDI1_STR-PRICE_UOM sy-vline 
WA_VTVFGDI1_STR-SPREAD sy-vline 
WA_VTVFGDI1_STR-QUOT_SRC sy-vline 
WA_VTVFGDI1_STR-QUOT_TYPE sy-vline 
WA_VTVFGDI1_STR-QUOT_TIME sy-vline 
WA_VTVFGDI1_STR-DCSID sy-vline 
WA_VTVFGDI1_STR-MIC sy-vline 
WA_VTVFGDI1_STR-PRICETYPE sy-vline 
WA_VTVFGDI1_STR-TENOR sy-vline 
WA_VTVFGDI1_STR-TIMING sy-vline 
WA_VTVFGDI1_STR-KEYDATE sy-vline 
WA_VTVFGDI1_STR-AVG_PERIOD_START sy-vline 
WA_VTVFGDI1_STR-AVG_PERIOD_END sy-vline      INTO ld_text SEPARATED BY SPACE.

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