ABAP Select data from SAP table VTGFHAPO 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 VTGFHAPO 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 VTGFHAPO. 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 VTGFHAPO 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_VTGFHAPO TYPE STANDARD TABLE OF VTGFHAPO,
      WA_VTGFHAPO TYPE VTGFHAPO,
      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: <VTGFHAPO> TYPE VTGFHAPO.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VTGFHAPO
*  INTO TABLE @DATA(IT_VTGFHAPO2).
*--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_VTGFHAPO INDEX 1 INTO DATA(WA_VTGFHAPO2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<VTGFHAPO>-MANDT = 1.
<VTGFHAPO>-BUKRS = 1.
<VTGFHAPO>-RFHA = 1.
<VTGFHAPO>-RFHAZU = 1.
<VTGFHAPO>-DCRDAT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_VTGFHAPO-TCRTIM, sy-vline,
  WA_VTGFHAPO-RFHAZB, sy-vline,
  WA_VTGFHAPO-CRUSER, sy-vline,
  WA_VTGFHAPO-UPUSER, sy-vline,
  WA_VTGFHAPO-DUPDAT, sy-vline,
  WA_VTGFHAPO-TUPTIM, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_VTGFHAPO 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_VTGFHAPO 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_VTGFHAPO INTO WA_VTGFHAPO.


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

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

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

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

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

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

*Conversion exit EXCRT, internal->external for field KHWKURS
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_VTGFHAPO-KHWKURS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTGFHAPO-KHWKURS.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit EXCRT, internal->external for field KZWKURS
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_VTGFHAPO-KZWKURS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTGFHAPO-KZWKURS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field KBWKURS
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_VTGFHAPO-KBWKURS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTGFHAPO-KBWKURS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field CONV_FACTOR_PRICED_QTY_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_VTGFHAPO-CONV_FACTOR_PRICED_QTY_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTGFHAPO-CONV_FACTOR_PRICED_QTY_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_VTGFHAPO_STR, 
MANDT TYPE STRING,
BUKRS TYPE STRING,
RFHA TYPE STRING,
RFHAZU TYPE STRING,
DCRDAT TYPE STRING,
TCRTIM TYPE STRING,
RFHAZB TYPE STRING,
CRUSER TYPE STRING,
UPUSER TYPE STRING,
DUPDAT TYPE STRING,
TUPTIM TYPE STRING,
RANTYP TYPE STRING,
SFHAZBA TYPE STRING,
SBKKLAS TYPE STRING,
SBKTYP TYPE STRING,
SBERFIMA TYPE STRING,
SSIGN TYPE STRING,
SHERKUNFT TYPE STRING,
SABVERF TYPE STRING,
RKONDGR TYPE STRING,
RKOND TYPE STRING,
DGUEL_KP TYPE STRING,
NSTUFE TYPE STRING,
SKOART TYPE STRING,
RREFKONT TYPE STRING,
SBZVABW TYPE STRING,
RAHABKI TYPE STRING,
RAHKTID TYPE STRING,
RPZAHL TYPE STRING,
RPBANK TYPE STRING,
SZART TYPE STRING,
ZLSCH TYPE STRING,
UZAWE TYPE STRING,
SPAYRQ TYPE STRING,
SPRSNG TYPE STRING,
SPRGRD TYPE STRING,
SCSPAY TYPE STRING,
ZWELS TYPE STRING,
PAYGR TYPE STRING,
SBEWEBE TYPE STRING,
SSPRGRD TYPE STRING,
SBFREI TYPE STRING,
SSTORNOBWG TYPE STRING,
PRKEY TYPE STRING,
BELNR TYPE STRING,
BELNR2 TYPE STRING,
GJAHR TYPE STRING,
DBUCHUNG TYPE STRING,
DFAELL TYPE STRING,
DZTERM TYPE STRING,
BZBETR TYPE STRING,
WZBETR TYPE STRING,
BHWBETR TYPE STRING,
KHWKURS TYPE STRING,
ASTUECK TYPE STRING,
BPRICE TYPE STRING,
WPRICE TYPE STRING,
BHWPREIS TYPE STRING,
BINDEX TYPE STRING,
VVBASIS TYPE STRING,
PWKURS TYPE STRING,
PRKKURS TYPE STRING,
BNWHR TYPE STRING,
RHANDPL TYPE STRING,
SKURSART TYPE STRING,
DBERVON TYPE STRING,
DBERBIS TYPE STRING,
ATAGE TYPE STRING,
ABASTAGE TYPE STRING,
PKOND TYPE STRING,
DPKOND TYPE STRING,
DZFEST TYPE STRING,
SZBMETH TYPE STRING,
SKALIDWT TYPE STRING,
BBASIS TYPE STRING,
WBASIS TYPE STRING,
JEXPOZINS TYPE STRING,
SINCL TYPE STRING,
SINCLBIS TYPE STRING,
SULTBIS TYPE STRING,
SEXCLVON TYPE STRING,
SULTVON TYPE STRING,
SAEND TYPE STRING,
DVALUT TYPE STRING,
SVINCL TYPE STRING,
SVULT TYPE STRING,
JSOFVERR TYPE STRING,
DVERRECH TYPE STRING,
SINCLVERR TYPE STRING,
SULTVERR TYPE STRING,
SSTORNOMAN TYPE STRING,
SSTORNOART TYPE STRING,
SBWGARTREF TYPE STRING,
SKHWFIX TYPE STRING,
ZUONR TYPE STRING,
RLDEPO TYPE STRING,
RANL TYPE STRING,
RTRBELNR TYPE STRING,
BUPRC TYPE STRING,
BPPRC TYPE STRING,
WBBETR TYPE STRING,
BBBETR TYPE STRING,
WEBETR TYPE STRING,
BEBETR TYPE STRING,
SRUNIT TYPE STRING,
KZWKURS TYPE STRING,
KBWKURS TYPE STRING,
WSBETR TYPE STRING,
DBESTAND TYPE STRING,
SSTCKKZ TYPE STRING,
SSTCKTG TYPE STRING,
SFLAT TYPE STRING,
SCOUPON TYPE STRING,
DCOUPON TYPE STRING,
AWKEY TYPE STRING,
INDEX_VALUE TYPE STRING,
SBASIS TYPE STRING,
REGI_STATE TYPE STRING,
RPCODE TYPE STRING,
RP_TEXT TYPE STRING,
HEDGE_ID TYPE STRING,
DBPERIOD TYPE STRING,
SPAEXCL TYPE STRING,
SPAULT TYPE STRING,
DEPERIOD TYPE STRING,
SPEINCL TYPE STRING,
SPEULT TYPE STRING,
AMMRHY TYPE STRING,
PPAYMENT TYPE STRING,
AMMRHYZV TYPE STRING,
LZBKZ TYPE STRING,
LANDL TYPE STRING,
BDIRTY TYPE STRING,
BAMOUNTCOMP TYPE STRING,
NOMINAL_ORG_AMT TYPE STRING,
NOM_FACTOR TYPE STRING,
RLDEPO2 TYPE STRING,
INDEX_PRICE TYPE STRING,
FLOWUUID TYPE STRING,
FLAGBYTE1 TYPE STRING,
QUANTITY TYPE STRING,
UNIT_OF_MEASURE TYPE STRING,
CONTRACT_PRICE TYPE STRING,
SPOT_PRICE TYPE STRING,
CONTANGO_BACKWRD TYPE STRING,
BPRC_SPOT1 TYPE STRING,
BPRC_SPOT2 TYPE STRING,
COST_FWD TYPE STRING,
INTEREST_FWD TYPE STRING,
REF_FLOWUUID TYPE STRING,
RGATT TYPE STRING,
COMMODITY_ID TYPE STRING,
QUOTATION_NAME TYPE STRING,
QUOTATION_SOURCE TYPE STRING,
QUOTATION_TYPE TYPE STRING,
SPREAD TYPE STRING,
PRICE_CURR_UNIT TYPE STRING,
PRICE_UOM TYPE STRING,
DIV_PCTC_OTC TYPE STRING,
TAINTED TYPE STRING,
CLEARED TYPE STRING,
DCSID TYPE STRING,
MIC TYPE STRING,
PRICE_TYPE TYPE STRING,
TIME_TO_MATURITY TYPE STRING,
TIMING TYPE STRING,
EXCH_RATE_TYPE TYPE STRING,
PRICE_PAYM_CURR TYPE STRING,
SPREAD_PAYM_CURR TYPE STRING,
FX_TRANSLATION TYPE STRING,
MNDID TYPE STRING,
BUGRENZ TYPE STRING,
BOGRENZ TYPE STRING,
SSTAFF TYPE STRING,
LOGIC_RKOND TYPE STRING,
RKONDREF TYPE STRING,
DGUEL_KPREF TYPE STRING,
PRESENT_DATE TYPE STRING,
INTEREST_PAID_BY TYPE STRING,
SHIPMENT_DATE TYPE STRING,
STATUS TYPE STRING,
PRESENT_ID TYPE STRING,
SSTOGRD TYPE STRING,
PRESENT_AMOUNT TYPE STRING,
PRESENT_BANK TYPE STRING,
PRESENT_DISCREPANCY TYPE STRING,
PRESENT_DECREASE_AMOUNT TYPE STRING,
PRESENT_REA_CRE_LINE TYPE STRING,
PRESENT_PAY_AMT TYPE STRING,
SROUNDFACTOR TYPE STRING,
ROUNDDECFACTOR TYPE STRING,
JEXPOINTFACTOR TYPE STRING,
FLOWFACTOR TYPE STRING,
BASEFACTOR TYPE STRING,
SROUNDBASEFACTOR TYPE STRING,
ROUNDDECBASEFACTOR TYPE STRING,
SKBWFIX TYPE STRING,
GROUPING_TERM TYPE STRING,
SSEQUENCE TYPE STRING,
SROUNDRATEFACTOR TYPE STRING,
ROUNDDECRATEFACTOR TYPE STRING,
AAVGDAYS TYPE STRING,
PAVGINTEREST TYPE STRING,
STGBASIS TYPE STRING,
JAVGCAP TYPE STRING,
PAVGCAP TYPE STRING,
JAVGFLOOR TYPE STRING,
PAVGFLOOR TYPE STRING,
PAVGSPREAD TYPE STRING,
SROUNDAVGINTEREST TYPE STRING,
ROUNDDECAVGINTEREST TYPE STRING,
AAVGWEIGHT TYPE STRING,
AAVGWEIGHTSUM TYPE STRING,
FX_FIXING_DATE TYPE STRING,
FX_REGI_STATE TYPE STRING,
FX_READ_DATE TYPE STRING,
PRICEINDEX_FIX_DATE_LOW TYPE STRING,
PRICEINDEX_READ_DATE_LOW TYPE STRING,
PRICEINDEX_FIX_DATE_HIGH TYPE STRING,
PRICEINDEX_READ_DATE_HIGH TYPE STRING,
PRICEINDEX_REGI_STATE TYPE STRING,
BBBETR_IDXCLEAN TYPE STRING,
TRADED_QUANTITY TYPE STRING,
TRADED_QUANTITY_UOM TYPE STRING,
CONV_FACTOR_TRADED_QTY TYPE STRING,
CONV_FACTOR_TRADED_QTY_UOM TYPE STRING,
CONV_FACTOR_PRICED_QTY TYPE STRING,
CONV_FACTOR_PRICED_QTY_UOM TYPE STRING,
IDCFM_USHA_TYPE TYPE STRING,
IDCFM_USHA_PERC TYPE STRING,
IDCFM_USHA_TOTA TYPE STRING,
IDCFM_USHA_CURR TYPE STRING,
IDCFM_USHA_FORM TYPE STRING,
SSELECTED TYPE STRING,
XZTERM TYPE STRING,
XZBETR TYPE STRING,
XDIRTY TYPE STRING,
XNWHR TYPE STRING,
XPRICE TYPE STRING,
XSTUECK TYPE STRING,
XBEWART TYPE STRING,
XSTORNOART TYPE STRING,
XKALIDWT TYPE STRING,
DISPNO TYPE STRING,
FMAREA TYPE STRING,
XZBETR_OLD TYPE STRING,
XAMOUNT_WD TYPE STRING,
XAMOUNT_EXT TYPE STRING,
CC_CURRENCY TYPE STRING,
SNEW TYPE STRING,
SDELETED TYPE STRING,
SMODIFIED TYPE STRING,
SVALIDATED TYPE STRING,
XBEWEBE TYPE STRING,
XZART_TRUE TYPE STRING,
XZART_FALSE TYPE STRING,
XPAYRQ_TRUE TYPE STRING,
XPAYRQ_FALSE TYPE STRING,
INDEX_DATABIN TYPE STRING,
KEY_DATABIN TYPE STRING,
ICON_REVERSED TYPE STRING,
ICON_MODIFIED TYPE STRING,
ICON_LOCKED TYPE STRING,
SNOT_MODIFIABLE TYPE STRING,
SNOT_DELETABLE TYPE STRING,
SNOT_REVERSABLE TYPE STRING,
SNOT_LOCKABLE TYPE STRING,
SNOT_RELEASABLE TYPE STRING,
SMAN_POSTABLE TYPE STRING,
SAPPL_REFERENCE TYPE STRING,
DZTERM_CONFIRMED TYPE STRING,
XKHWFIX TYPE STRING,
BZBETR_SIGNED TYPE STRING,
XALKZ TYPE STRING,
XALLB TYPE STRING,
XLDEPO TYPE STRING,
XREGI_STATE TYPE STRING,
XSEXCL TYPE STRING,
XSVULT TYPE STRING,
XVALUT TYPE STRING,
BHWBETR_SIGNED TYPE STRING,
AA_REF TYPE STRING,
PAYMENT_AWKEY TYPE STRING,
PAYMENT_STATE TYPE STRING,
XPAYMENT_STATE TYPE STRING,
BZBETR_OLD TYPE STRING,
AMOUNT_WD TYPE STRING,
AMOUNT_EXT TYPE STRING,
ROFHAZU TYPE STRING,
XBBETR TYPE STRING,
XBBETR_IDXCLEAN TYPE STRING,END OF T_EKKO_STR.
DATA: WA_VTGFHAPO_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_VTGFHAPO_STR-MANDT sy-vline 
WA_VTGFHAPO_STR-BUKRS sy-vline 
WA_VTGFHAPO_STR-RFHA sy-vline 
WA_VTGFHAPO_STR-RFHAZU sy-vline 
WA_VTGFHAPO_STR-DCRDAT sy-vline 
WA_VTGFHAPO_STR-TCRTIM sy-vline 
WA_VTGFHAPO_STR-RFHAZB sy-vline 
WA_VTGFHAPO_STR-CRUSER sy-vline 
WA_VTGFHAPO_STR-UPUSER sy-vline 
WA_VTGFHAPO_STR-DUPDAT sy-vline 
WA_VTGFHAPO_STR-TUPTIM sy-vline 
WA_VTGFHAPO_STR-RANTYP sy-vline 
WA_VTGFHAPO_STR-SFHAZBA sy-vline 
WA_VTGFHAPO_STR-SBKKLAS sy-vline 
WA_VTGFHAPO_STR-SBKTYP sy-vline 
WA_VTGFHAPO_STR-SBERFIMA sy-vline 
WA_VTGFHAPO_STR-SSIGN sy-vline 
WA_VTGFHAPO_STR-SHERKUNFT sy-vline 
WA_VTGFHAPO_STR-SABVERF sy-vline 
WA_VTGFHAPO_STR-RKONDGR sy-vline 
WA_VTGFHAPO_STR-RKOND sy-vline 
WA_VTGFHAPO_STR-DGUEL_KP sy-vline 
WA_VTGFHAPO_STR-NSTUFE sy-vline 
WA_VTGFHAPO_STR-SKOART sy-vline 
WA_VTGFHAPO_STR-RREFKONT sy-vline 
WA_VTGFHAPO_STR-SBZVABW sy-vline 
WA_VTGFHAPO_STR-RAHABKI sy-vline 
WA_VTGFHAPO_STR-RAHKTID sy-vline 
WA_VTGFHAPO_STR-RPZAHL sy-vline 
WA_VTGFHAPO_STR-RPBANK sy-vline 
WA_VTGFHAPO_STR-SZART sy-vline 
WA_VTGFHAPO_STR-ZLSCH sy-vline 
WA_VTGFHAPO_STR-UZAWE sy-vline 
WA_VTGFHAPO_STR-SPAYRQ sy-vline 
WA_VTGFHAPO_STR-SPRSNG sy-vline 
WA_VTGFHAPO_STR-SPRGRD sy-vline 
WA_VTGFHAPO_STR-SCSPAY sy-vline 
WA_VTGFHAPO_STR-ZWELS sy-vline 
WA_VTGFHAPO_STR-PAYGR sy-vline 
WA_VTGFHAPO_STR-SBEWEBE sy-vline 
WA_VTGFHAPO_STR-SSPRGRD sy-vline 
WA_VTGFHAPO_STR-SBFREI sy-vline 
WA_VTGFHAPO_STR-SSTORNOBWG sy-vline 
WA_VTGFHAPO_STR-PRKEY sy-vline 
WA_VTGFHAPO_STR-BELNR sy-vline 
WA_VTGFHAPO_STR-BELNR2 sy-vline 
WA_VTGFHAPO_STR-GJAHR sy-vline 
WA_VTGFHAPO_STR-DBUCHUNG sy-vline 
WA_VTGFHAPO_STR-DFAELL sy-vline 
WA_VTGFHAPO_STR-DZTERM sy-vline 
WA_VTGFHAPO_STR-BZBETR sy-vline 
WA_VTGFHAPO_STR-WZBETR sy-vline 
WA_VTGFHAPO_STR-BHWBETR sy-vline 
WA_VTGFHAPO_STR-KHWKURS sy-vline 
WA_VTGFHAPO_STR-ASTUECK sy-vline 
WA_VTGFHAPO_STR-BPRICE sy-vline 
WA_VTGFHAPO_STR-WPRICE sy-vline 
WA_VTGFHAPO_STR-BHWPREIS sy-vline 
WA_VTGFHAPO_STR-BINDEX sy-vline 
WA_VTGFHAPO_STR-VVBASIS sy-vline 
WA_VTGFHAPO_STR-PWKURS sy-vline 
WA_VTGFHAPO_STR-PRKKURS sy-vline 
WA_VTGFHAPO_STR-BNWHR sy-vline 
WA_VTGFHAPO_STR-RHANDPL sy-vline 
WA_VTGFHAPO_STR-SKURSART sy-vline 
WA_VTGFHAPO_STR-DBERVON sy-vline 
WA_VTGFHAPO_STR-DBERBIS sy-vline 
WA_VTGFHAPO_STR-ATAGE sy-vline 
WA_VTGFHAPO_STR-ABASTAGE sy-vline 
WA_VTGFHAPO_STR-PKOND sy-vline 
WA_VTGFHAPO_STR-DPKOND sy-vline 
WA_VTGFHAPO_STR-DZFEST sy-vline 
WA_VTGFHAPO_STR-SZBMETH sy-vline 
WA_VTGFHAPO_STR-SKALIDWT sy-vline 
WA_VTGFHAPO_STR-BBASIS sy-vline 
WA_VTGFHAPO_STR-WBASIS sy-vline 
WA_VTGFHAPO_STR-JEXPOZINS sy-vline 
WA_VTGFHAPO_STR-SINCL sy-vline 
WA_VTGFHAPO_STR-SINCLBIS sy-vline 
WA_VTGFHAPO_STR-SULTBIS sy-vline 
WA_VTGFHAPO_STR-SEXCLVON sy-vline 
WA_VTGFHAPO_STR-SULTVON sy-vline 
WA_VTGFHAPO_STR-SAEND sy-vline 
WA_VTGFHAPO_STR-DVALUT sy-vline 
WA_VTGFHAPO_STR-SVINCL sy-vline 
WA_VTGFHAPO_STR-SVULT sy-vline 
WA_VTGFHAPO_STR-JSOFVERR sy-vline 
WA_VTGFHAPO_STR-DVERRECH sy-vline 
WA_VTGFHAPO_STR-SINCLVERR sy-vline 
WA_VTGFHAPO_STR-SULTVERR sy-vline 
WA_VTGFHAPO_STR-SSTORNOMAN sy-vline 
WA_VTGFHAPO_STR-SSTORNOART sy-vline 
WA_VTGFHAPO_STR-SBWGARTREF sy-vline 
WA_VTGFHAPO_STR-SKHWFIX sy-vline 
WA_VTGFHAPO_STR-ZUONR sy-vline 
WA_VTGFHAPO_STR-RLDEPO sy-vline 
WA_VTGFHAPO_STR-RANL sy-vline 
WA_VTGFHAPO_STR-RTRBELNR sy-vline 
WA_VTGFHAPO_STR-BUPRC sy-vline 
WA_VTGFHAPO_STR-BPPRC sy-vline 
WA_VTGFHAPO_STR-WBBETR sy-vline 
WA_VTGFHAPO_STR-BBBETR sy-vline 
WA_VTGFHAPO_STR-WEBETR sy-vline 
WA_VTGFHAPO_STR-BEBETR sy-vline 
WA_VTGFHAPO_STR-SRUNIT sy-vline 
WA_VTGFHAPO_STR-KZWKURS sy-vline 
WA_VTGFHAPO_STR-KBWKURS sy-vline 
WA_VTGFHAPO_STR-WSBETR sy-vline 
WA_VTGFHAPO_STR-DBESTAND sy-vline 
WA_VTGFHAPO_STR-SSTCKKZ sy-vline 
WA_VTGFHAPO_STR-SSTCKTG sy-vline 
WA_VTGFHAPO_STR-SFLAT sy-vline 
WA_VTGFHAPO_STR-SCOUPON sy-vline 
WA_VTGFHAPO_STR-DCOUPON sy-vline 
WA_VTGFHAPO_STR-AWKEY sy-vline 
WA_VTGFHAPO_STR-INDEX_VALUE sy-vline 
WA_VTGFHAPO_STR-SBASIS sy-vline 
WA_VTGFHAPO_STR-REGI_STATE sy-vline 
WA_VTGFHAPO_STR-RPCODE sy-vline 
WA_VTGFHAPO_STR-RP_TEXT sy-vline 
WA_VTGFHAPO_STR-HEDGE_ID sy-vline 
WA_VTGFHAPO_STR-DBPERIOD sy-vline 
WA_VTGFHAPO_STR-SPAEXCL sy-vline 
WA_VTGFHAPO_STR-SPAULT sy-vline 
WA_VTGFHAPO_STR-DEPERIOD sy-vline 
WA_VTGFHAPO_STR-SPEINCL sy-vline 
WA_VTGFHAPO_STR-SPEULT sy-vline 
WA_VTGFHAPO_STR-AMMRHY sy-vline 
WA_VTGFHAPO_STR-PPAYMENT sy-vline 
WA_VTGFHAPO_STR-AMMRHYZV sy-vline 
WA_VTGFHAPO_STR-LZBKZ sy-vline 
WA_VTGFHAPO_STR-LANDL sy-vline 
WA_VTGFHAPO_STR-BDIRTY sy-vline 
WA_VTGFHAPO_STR-BAMOUNTCOMP sy-vline 
WA_VTGFHAPO_STR-NOMINAL_ORG_AMT sy-vline 
WA_VTGFHAPO_STR-NOM_FACTOR sy-vline 
WA_VTGFHAPO_STR-RLDEPO2 sy-vline 
WA_VTGFHAPO_STR-INDEX_PRICE sy-vline 
WA_VTGFHAPO_STR-FLOWUUID sy-vline 
WA_VTGFHAPO_STR-FLAGBYTE1 sy-vline 
WA_VTGFHAPO_STR-QUANTITY sy-vline 
WA_VTGFHAPO_STR-UNIT_OF_MEASURE sy-vline 
WA_VTGFHAPO_STR-CONTRACT_PRICE sy-vline 
WA_VTGFHAPO_STR-SPOT_PRICE sy-vline 
WA_VTGFHAPO_STR-CONTANGO_BACKWRD sy-vline 
WA_VTGFHAPO_STR-BPRC_SPOT1 sy-vline 
WA_VTGFHAPO_STR-BPRC_SPOT2 sy-vline 
WA_VTGFHAPO_STR-COST_FWD sy-vline 
WA_VTGFHAPO_STR-INTEREST_FWD sy-vline 
WA_VTGFHAPO_STR-REF_FLOWUUID sy-vline 
WA_VTGFHAPO_STR-RGATT sy-vline 
WA_VTGFHAPO_STR-COMMODITY_ID sy-vline 
WA_VTGFHAPO_STR-QUOTATION_NAME sy-vline 
WA_VTGFHAPO_STR-QUOTATION_SOURCE sy-vline 
WA_VTGFHAPO_STR-QUOTATION_TYPE sy-vline 
WA_VTGFHAPO_STR-SPREAD sy-vline 
WA_VTGFHAPO_STR-PRICE_CURR_UNIT sy-vline 
WA_VTGFHAPO_STR-PRICE_UOM sy-vline 
WA_VTGFHAPO_STR-DIV_PCTC_OTC sy-vline 
WA_VTGFHAPO_STR-TAINTED sy-vline 
WA_VTGFHAPO_STR-CLEARED sy-vline 
WA_VTGFHAPO_STR-DCSID sy-vline 
WA_VTGFHAPO_STR-MIC sy-vline 
WA_VTGFHAPO_STR-PRICE_TYPE sy-vline 
WA_VTGFHAPO_STR-TIME_TO_MATURITY sy-vline 
WA_VTGFHAPO_STR-TIMING sy-vline 
WA_VTGFHAPO_STR-EXCH_RATE_TYPE sy-vline 
WA_VTGFHAPO_STR-PRICE_PAYM_CURR sy-vline 
WA_VTGFHAPO_STR-SPREAD_PAYM_CURR sy-vline 
WA_VTGFHAPO_STR-FX_TRANSLATION sy-vline 
WA_VTGFHAPO_STR-MNDID sy-vline 
WA_VTGFHAPO_STR-BUGRENZ sy-vline 
WA_VTGFHAPO_STR-BOGRENZ sy-vline 
WA_VTGFHAPO_STR-SSTAFF sy-vline 
WA_VTGFHAPO_STR-LOGIC_RKOND sy-vline 
WA_VTGFHAPO_STR-RKONDREF sy-vline 
WA_VTGFHAPO_STR-DGUEL_KPREF sy-vline 
WA_VTGFHAPO_STR-PRESENT_DATE sy-vline 
WA_VTGFHAPO_STR-INTEREST_PAID_BY sy-vline 
WA_VTGFHAPO_STR-SHIPMENT_DATE sy-vline 
WA_VTGFHAPO_STR-STATUS sy-vline 
WA_VTGFHAPO_STR-PRESENT_ID sy-vline 
WA_VTGFHAPO_STR-SSTOGRD sy-vline 
WA_VTGFHAPO_STR-PRESENT_AMOUNT sy-vline 
WA_VTGFHAPO_STR-PRESENT_BANK sy-vline 
WA_VTGFHAPO_STR-PRESENT_DISCREPANCY sy-vline 
WA_VTGFHAPO_STR-PRESENT_DECREASE_AMOUNT sy-vline 
WA_VTGFHAPO_STR-PRESENT_REA_CRE_LINE sy-vline 
WA_VTGFHAPO_STR-PRESENT_PAY_AMT sy-vline 
WA_VTGFHAPO_STR-SROUNDFACTOR sy-vline 
WA_VTGFHAPO_STR-ROUNDDECFACTOR sy-vline 
WA_VTGFHAPO_STR-JEXPOINTFACTOR sy-vline 
WA_VTGFHAPO_STR-FLOWFACTOR sy-vline 
WA_VTGFHAPO_STR-BASEFACTOR sy-vline 
WA_VTGFHAPO_STR-SROUNDBASEFACTOR sy-vline 
WA_VTGFHAPO_STR-ROUNDDECBASEFACTOR sy-vline 
WA_VTGFHAPO_STR-SKBWFIX sy-vline 
WA_VTGFHAPO_STR-GROUPING_TERM sy-vline 
WA_VTGFHAPO_STR-SSEQUENCE sy-vline 
WA_VTGFHAPO_STR-SROUNDRATEFACTOR sy-vline 
WA_VTGFHAPO_STR-ROUNDDECRATEFACTOR sy-vline 
WA_VTGFHAPO_STR-AAVGDAYS sy-vline 
WA_VTGFHAPO_STR-PAVGINTEREST sy-vline 
WA_VTGFHAPO_STR-STGBASIS sy-vline 
WA_VTGFHAPO_STR-JAVGCAP sy-vline 
WA_VTGFHAPO_STR-PAVGCAP sy-vline 
WA_VTGFHAPO_STR-JAVGFLOOR sy-vline 
WA_VTGFHAPO_STR-PAVGFLOOR sy-vline 
WA_VTGFHAPO_STR-PAVGSPREAD sy-vline 
WA_VTGFHAPO_STR-SROUNDAVGINTEREST sy-vline 
WA_VTGFHAPO_STR-ROUNDDECAVGINTEREST sy-vline 
WA_VTGFHAPO_STR-AAVGWEIGHT sy-vline 
WA_VTGFHAPO_STR-AAVGWEIGHTSUM sy-vline 
WA_VTGFHAPO_STR-FX_FIXING_DATE sy-vline 
WA_VTGFHAPO_STR-FX_REGI_STATE sy-vline 
WA_VTGFHAPO_STR-FX_READ_DATE sy-vline 
WA_VTGFHAPO_STR-PRICEINDEX_FIX_DATE_LOW sy-vline 
WA_VTGFHAPO_STR-PRICEINDEX_READ_DATE_LOW sy-vline 
WA_VTGFHAPO_STR-PRICEINDEX_FIX_DATE_HIGH sy-vline 
WA_VTGFHAPO_STR-PRICEINDEX_READ_DATE_HIGH sy-vline 
WA_VTGFHAPO_STR-PRICEINDEX_REGI_STATE sy-vline 
WA_VTGFHAPO_STR-BBBETR_IDXCLEAN sy-vline 
WA_VTGFHAPO_STR-TRADED_QUANTITY sy-vline 
WA_VTGFHAPO_STR-TRADED_QUANTITY_UOM sy-vline 
WA_VTGFHAPO_STR-CONV_FACTOR_TRADED_QTY sy-vline 
WA_VTGFHAPO_STR-CONV_FACTOR_TRADED_QTY_UOM sy-vline 
WA_VTGFHAPO_STR-CONV_FACTOR_PRICED_QTY sy-vline 
WA_VTGFHAPO_STR-CONV_FACTOR_PRICED_QTY_UOM sy-vline 
WA_VTGFHAPO_STR-IDCFM_USHA_TYPE sy-vline 
WA_VTGFHAPO_STR-IDCFM_USHA_PERC sy-vline 
WA_VTGFHAPO_STR-IDCFM_USHA_TOTA sy-vline 
WA_VTGFHAPO_STR-IDCFM_USHA_CURR sy-vline 
WA_VTGFHAPO_STR-IDCFM_USHA_FORM sy-vline 
WA_VTGFHAPO_STR-SSELECTED sy-vline 
WA_VTGFHAPO_STR-XZTERM sy-vline 
WA_VTGFHAPO_STR-XZBETR sy-vline 
WA_VTGFHAPO_STR-XDIRTY sy-vline 
WA_VTGFHAPO_STR-XNWHR sy-vline 
WA_VTGFHAPO_STR-XPRICE sy-vline 
WA_VTGFHAPO_STR-XSTUECK sy-vline 
WA_VTGFHAPO_STR-XBEWART sy-vline 
WA_VTGFHAPO_STR-XSTORNOART sy-vline 
WA_VTGFHAPO_STR-XKALIDWT sy-vline 
WA_VTGFHAPO_STR-DISPNO sy-vline 
WA_VTGFHAPO_STR-FMAREA sy-vline 
WA_VTGFHAPO_STR-XZBETR_OLD sy-vline 
WA_VTGFHAPO_STR-XAMOUNT_WD sy-vline 
WA_VTGFHAPO_STR-XAMOUNT_EXT sy-vline 
WA_VTGFHAPO_STR-CC_CURRENCY sy-vline 
WA_VTGFHAPO_STR-SNEW sy-vline 
WA_VTGFHAPO_STR-SDELETED sy-vline 
WA_VTGFHAPO_STR-SMODIFIED sy-vline 
WA_VTGFHAPO_STR-SVALIDATED sy-vline 
WA_VTGFHAPO_STR-XBEWEBE sy-vline 
WA_VTGFHAPO_STR-XZART_TRUE sy-vline 
WA_VTGFHAPO_STR-XZART_FALSE sy-vline 
WA_VTGFHAPO_STR-XPAYRQ_TRUE sy-vline 
WA_VTGFHAPO_STR-XPAYRQ_FALSE sy-vline 
WA_VTGFHAPO_STR-INDEX_DATABIN sy-vline 
WA_VTGFHAPO_STR-KEY_DATABIN sy-vline 
WA_VTGFHAPO_STR-ICON_REVERSED sy-vline 
WA_VTGFHAPO_STR-ICON_MODIFIED sy-vline 
WA_VTGFHAPO_STR-ICON_LOCKED sy-vline 
WA_VTGFHAPO_STR-SNOT_MODIFIABLE sy-vline 
WA_VTGFHAPO_STR-SNOT_DELETABLE sy-vline 
WA_VTGFHAPO_STR-SNOT_REVERSABLE sy-vline 
WA_VTGFHAPO_STR-SNOT_LOCKABLE sy-vline 
WA_VTGFHAPO_STR-SNOT_RELEASABLE sy-vline 
WA_VTGFHAPO_STR-SMAN_POSTABLE sy-vline 
WA_VTGFHAPO_STR-SAPPL_REFERENCE sy-vline 
WA_VTGFHAPO_STR-DZTERM_CONFIRMED sy-vline 
WA_VTGFHAPO_STR-XKHWFIX sy-vline 
WA_VTGFHAPO_STR-BZBETR_SIGNED sy-vline 
WA_VTGFHAPO_STR-XALKZ sy-vline 
WA_VTGFHAPO_STR-XALLB sy-vline 
WA_VTGFHAPO_STR-XLDEPO sy-vline 
WA_VTGFHAPO_STR-XREGI_STATE sy-vline 
WA_VTGFHAPO_STR-XSEXCL sy-vline 
WA_VTGFHAPO_STR-XSVULT sy-vline 
WA_VTGFHAPO_STR-XVALUT sy-vline 
WA_VTGFHAPO_STR-BHWBETR_SIGNED sy-vline 
WA_VTGFHAPO_STR-AA_REF sy-vline 
WA_VTGFHAPO_STR-PAYMENT_AWKEY sy-vline 
WA_VTGFHAPO_STR-PAYMENT_STATE sy-vline 
WA_VTGFHAPO_STR-XPAYMENT_STATE sy-vline 
WA_VTGFHAPO_STR-BZBETR_OLD sy-vline 
WA_VTGFHAPO_STR-AMOUNT_WD sy-vline 
WA_VTGFHAPO_STR-AMOUNT_EXT sy-vline 
WA_VTGFHAPO_STR-ROFHAZU sy-vline 
WA_VTGFHAPO_STR-XBBETR sy-vline 
WA_VTGFHAPO_STR-XBBETR_IDXCLEAN sy-vline      INTO ld_text SEPARATED BY SPACE.

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