ABAP Select data from SAP table VTB_SFHAPO 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 VTB_SFHAPO 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 VTB_SFHAPO. 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 VTB_SFHAPO 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_VTB_SFHAPO TYPE STANDARD TABLE OF VTB_SFHAPO,
      WA_VTB_SFHAPO TYPE VTB_SFHAPO,
      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: <VTB_SFHAPO> TYPE VTB_SFHAPO.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VTB_SFHAPO
*  INTO TABLE @DATA(IT_VTB_SFHAPO2).
*--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_VTB_SFHAPO INDEX 1 INTO DATA(WA_VTB_SFHAPO2).


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

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

ENDLOOP.

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

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


*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_VTB_SFHAPO-RFHA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-RFHA.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field RPCODE
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_VTB_SFHAPO-RPCODE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-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_VTB_SFHAPO-UNIT_OF_MEASURE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-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_VTB_SFHAPO-RGATT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-RGATT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field PRICE_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_VTB_SFHAPO-PRICE_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-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_VTB_SFHAPO-PRESENT_BANK
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-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_VTB_SFHAPO-TRADED_QUANTITY_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-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_VTB_SFHAPO-CONV_FACTOR_TRADED_QTY_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-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_VTB_SFHAPO-CONV_FACTOR_PRICED_QTY_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-CONV_FACTOR_PRICED_QTY_UOM.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field RPCODE_R
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_VTB_SFHAPO-RPCODE_R
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VTB_SFHAPO-RPCODE_R.
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_VTB_SFHAPO_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,
XZTERM TYPE STRING,
XZBETR TYPE STRING,
DBESTANDX TYPE STRING,
DVALUTX TYPE STRING,
BMARGIN TYPE STRING,
XNWHR TYPE STRING,
XBSPOT TYPE STRING,
BSPOT TYPE STRING,
SPOTRATE TYPE STRING,
BFORW TYPE STRING,
WHWBETR TYPE STRING,
XBBETR TYPE STRING,
XBEWART TYPE STRING,
SSELECTED TYPE STRING,
XPRICE TYPE STRING,
XSTORNOART TYPE STRING,
XKALIDWT TYPE STRING,
XINCL TYPE STRING,
KZWKURS_FROM TYPE STRING,
KZWKURS_TO TYPE STRING,
KHWKURS_FROM TYPE STRING,
KHWKURS_TO TYPE STRING,
KBWKURS_FROM TYPE STRING,
KBWKURS_TO TYPE STRING,
XHBETR TYPE STRING,
XEBETR TYPE STRING,
XFLG_DEALFLOW TYPE STRING,
WZBETR_NEW TYPE STRING,
SRUNIT_NEW TYPE STRING,
DEFECT_RATE TYPE STRING,
DEFECT_RATE_NEW TYPE STRING,
ZUONR_NEW TYPE STRING,
INDEX_VALUE_P TYPE STRING,
INDEX_VALUE_U TYPE STRING,
BPRC_SPOT1_PER TYPE STRING,
BPRC_SPOT1_CURR TYPE STRING,
BPRC_SPOT2_PER TYPE STRING,
BPRC_SPOT2_CURR TYPE STRING,
COST_FWD_PER TYPE STRING,
COST_FWD_CURR TYPE STRING,
INTEREST_FWD_PER TYPE STRING,
INTEREST_FWD_CURR TYPE STRING,
SRUNIT_COST TYPE STRING,
SRUNIT_INT TYPE STRING,
SFHAZBA_R TYPE STRING,
XBEWART_R TYPE STRING,
BPPRC_R TYPE STRING,
BUPRC_R TYPE STRING,
SRUNIT_R TYPE STRING,
DBESTANDX_R TYPE STRING,
DBESTAND_R TYPE STRING,
DVALUTX_R TYPE STRING,
DVALUT_R TYPE STRING,
XZTERM_R TYPE STRING,
DZTERM_R TYPE STRING,
XEBETR_R TYPE STRING,
BEBETR_R TYPE STRING,
WEBETR_R TYPE STRING,
XZBETR_R TYPE STRING,
BZBETR_R TYPE STRING,
WZBETR_R TYPE STRING,
XHBETR_R TYPE STRING,
BHWBETR_R TYPE STRING,
WHWBETR_R TYPE STRING,
XBBETR_R TYPE STRING,
BBBETR_R TYPE STRING,
WBBETR_R TYPE STRING,
KZWKURS_R TYPE STRING,
KZWKURS_FROM_R TYPE STRING,
KZWKURS_TO_R TYPE STRING,
KHWKURS_R TYPE STRING,
KHWKURS_FROM_R TYPE STRING,
KHWKURS_TO_R TYPE STRING,
KBWKURS_R TYPE STRING,
KBWKURS_FROM_R TYPE STRING,
KBWKURS_TO_R TYPE STRING,
SBKTYP_R TYPE STRING,
SSIGN_R TYPE STRING,
SHERKUNFT_R TYPE STRING,
ASTUECK_R TYPE STRING,
XNWHR_R TYPE STRING,
BNWHR_R TYPE STRING,
SBKKLAS_R TYPE STRING,
SBERFIMA_R TYPE STRING,
RFHAZU_R TYPE STRING,
RFHAZB_R TYPE STRING,
DCRDAT_R TYPE STRING,
TCRTIM_R TYPE STRING,
CRUSER_R TYPE STRING,
UPUSER_R TYPE STRING,
DUPDAT_R TYPE STRING,
TUPTIM_R TYPE STRING,
RANTYP_R TYPE STRING,
SABVERF_R TYPE STRING,
RKONDGR_R TYPE STRING,
RKOND_R TYPE STRING,
DGUEL_KP_R TYPE STRING,
NSTUFE_R TYPE STRING,
SKOART_R TYPE STRING,
RREFKONT_R TYPE STRING,
SBZVABW_R TYPE STRING,
RAHABKI_R TYPE STRING,
RAHKTID_R TYPE STRING,
RPZAHL_R TYPE STRING,
RPBANK_R TYPE STRING,
SZART_R TYPE STRING,
ZLSCH_R TYPE STRING,
UZAWE_R TYPE STRING,
SPAYRQ_R TYPE STRING,
SPRSNG_R TYPE STRING,
SPRGRD_R TYPE STRING,
SCSPAY_R TYPE STRING,
ZWELS_R TYPE STRING,
PAYGR_R TYPE STRING,
SBEWEBE_R TYPE STRING,
SSPRGRD_R TYPE STRING,
SBFREI_R TYPE STRING,
SSTORNOBWG_R TYPE STRING,
PRKEY_R TYPE STRING,
BELNR_R TYPE STRING,
BELNR2_R TYPE STRING,
GJAHR_R TYPE STRING,
DBUCHUNG_R TYPE STRING,
DFAELL_R TYPE STRING,
BPRICE_R TYPE STRING,
WPRICE_R TYPE STRING,
BHWPREIS_R TYPE STRING,
BINDEX_R TYPE STRING,
VVBASIS_R TYPE STRING,
PWKURS_R TYPE STRING,
PRKKURS_R TYPE STRING,
RHANDPL_R TYPE STRING,
SKURSART_R TYPE STRING,
DBERVON_R TYPE STRING,
DBERBIS_R TYPE STRING,
ATAGE_R TYPE STRING,
ABASTAGE_R TYPE STRING,
PKOND_R TYPE STRING,
DPKOND_R TYPE STRING,
DZFEST_R TYPE STRING,
SZBMETH_R TYPE STRING,
SKALIDWT_R TYPE STRING,
BBASIS_R TYPE STRING,
WBASIS_R TYPE STRING,
JEXPOZINS_R TYPE STRING,
SINCL_R TYPE STRING,
SINCLBIS_R TYPE STRING,
SULTBIS_R TYPE STRING,
SEXCLVON_R TYPE STRING,
SULTVON_R TYPE STRING,
SAEND_R TYPE STRING,
SVINCL_R TYPE STRING,
SVULT_R TYPE STRING,
JSOFVERR_R TYPE STRING,
DVERRECH_R TYPE STRING,
SINCLVERR_R TYPE STRING,
SULTVERR_R TYPE STRING,
SSTORNOMAN_R TYPE STRING,
SSTORNOART_R TYPE STRING,
SBWGARTREF_R TYPE STRING,
SKHWFIX_R TYPE STRING,
ZUONR_R TYPE STRING,
RLDEPO_R TYPE STRING,
RANL_R TYPE STRING,
RTRBELNR_R TYPE STRING,
WSBETR_R TYPE STRING,
SSTCKKZ_R TYPE STRING,
SSTCKTG_R TYPE STRING,
SFLAT_R TYPE STRING,
SCOUPON_R TYPE STRING,
DCOUPON_R TYPE STRING,
AWKEY_R TYPE STRING,
INDEX_VALUE_R TYPE STRING,
SBASIS_R TYPE STRING,
REGI_STATE_R TYPE STRING,
RPCODE_R TYPE STRING,
RP_TEXT_R TYPE STRING,
HEDGE_ID_R TYPE STRING,
XINCL_R TYPE STRING,
XASTUECK TYPE STRING,
IDCFM_USHA_FIX TYPE STRING,
IDCFM_USHA_AMO TYPE STRING,
IDCFM_USHA_TOTAT TYPE STRING,
IDCFM_USHA_PERCT TYPE STRING,
IDCFM_USHA_CURRT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_VTB_SFHAPO_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_VTB_SFHAPO_STR-MANDT sy-vline 
WA_VTB_SFHAPO_STR-BUKRS sy-vline 
WA_VTB_SFHAPO_STR-RFHA sy-vline 
WA_VTB_SFHAPO_STR-RFHAZU sy-vline 
WA_VTB_SFHAPO_STR-DCRDAT sy-vline 
WA_VTB_SFHAPO_STR-TCRTIM sy-vline 
WA_VTB_SFHAPO_STR-RFHAZB sy-vline 
WA_VTB_SFHAPO_STR-CRUSER sy-vline 
WA_VTB_SFHAPO_STR-UPUSER sy-vline 
WA_VTB_SFHAPO_STR-DUPDAT sy-vline 
WA_VTB_SFHAPO_STR-TUPTIM sy-vline 
WA_VTB_SFHAPO_STR-RANTYP sy-vline 
WA_VTB_SFHAPO_STR-SFHAZBA sy-vline 
WA_VTB_SFHAPO_STR-SBKKLAS sy-vline 
WA_VTB_SFHAPO_STR-SBKTYP sy-vline 
WA_VTB_SFHAPO_STR-SBERFIMA sy-vline 
WA_VTB_SFHAPO_STR-SSIGN sy-vline 
WA_VTB_SFHAPO_STR-SHERKUNFT sy-vline 
WA_VTB_SFHAPO_STR-SABVERF sy-vline 
WA_VTB_SFHAPO_STR-RKONDGR sy-vline 
WA_VTB_SFHAPO_STR-RKOND sy-vline 
WA_VTB_SFHAPO_STR-DGUEL_KP sy-vline 
WA_VTB_SFHAPO_STR-NSTUFE sy-vline 
WA_VTB_SFHAPO_STR-SKOART sy-vline 
WA_VTB_SFHAPO_STR-RREFKONT sy-vline 
WA_VTB_SFHAPO_STR-SBZVABW sy-vline 
WA_VTB_SFHAPO_STR-RAHABKI sy-vline 
WA_VTB_SFHAPO_STR-RAHKTID sy-vline 
WA_VTB_SFHAPO_STR-RPZAHL sy-vline 
WA_VTB_SFHAPO_STR-RPBANK sy-vline 
WA_VTB_SFHAPO_STR-SZART sy-vline 
WA_VTB_SFHAPO_STR-ZLSCH sy-vline 
WA_VTB_SFHAPO_STR-UZAWE sy-vline 
WA_VTB_SFHAPO_STR-SPAYRQ sy-vline 
WA_VTB_SFHAPO_STR-SPRSNG sy-vline 
WA_VTB_SFHAPO_STR-SPRGRD sy-vline 
WA_VTB_SFHAPO_STR-SCSPAY sy-vline 
WA_VTB_SFHAPO_STR-ZWELS sy-vline 
WA_VTB_SFHAPO_STR-PAYGR sy-vline 
WA_VTB_SFHAPO_STR-SBEWEBE sy-vline 
WA_VTB_SFHAPO_STR-SSPRGRD sy-vline 
WA_VTB_SFHAPO_STR-SBFREI sy-vline 
WA_VTB_SFHAPO_STR-SSTORNOBWG sy-vline 
WA_VTB_SFHAPO_STR-PRKEY sy-vline 
WA_VTB_SFHAPO_STR-BELNR sy-vline 
WA_VTB_SFHAPO_STR-BELNR2 sy-vline 
WA_VTB_SFHAPO_STR-GJAHR sy-vline 
WA_VTB_SFHAPO_STR-DBUCHUNG sy-vline 
WA_VTB_SFHAPO_STR-DFAELL sy-vline 
WA_VTB_SFHAPO_STR-DZTERM sy-vline 
WA_VTB_SFHAPO_STR-BZBETR sy-vline 
WA_VTB_SFHAPO_STR-WZBETR sy-vline 
WA_VTB_SFHAPO_STR-BHWBETR sy-vline 
WA_VTB_SFHAPO_STR-KHWKURS sy-vline 
WA_VTB_SFHAPO_STR-ASTUECK sy-vline 
WA_VTB_SFHAPO_STR-BPRICE sy-vline 
WA_VTB_SFHAPO_STR-WPRICE sy-vline 
WA_VTB_SFHAPO_STR-BHWPREIS sy-vline 
WA_VTB_SFHAPO_STR-BINDEX sy-vline 
WA_VTB_SFHAPO_STR-VVBASIS sy-vline 
WA_VTB_SFHAPO_STR-PWKURS sy-vline 
WA_VTB_SFHAPO_STR-PRKKURS sy-vline 
WA_VTB_SFHAPO_STR-BNWHR sy-vline 
WA_VTB_SFHAPO_STR-RHANDPL sy-vline 
WA_VTB_SFHAPO_STR-SKURSART sy-vline 
WA_VTB_SFHAPO_STR-DBERVON sy-vline 
WA_VTB_SFHAPO_STR-DBERBIS sy-vline 
WA_VTB_SFHAPO_STR-ATAGE sy-vline 
WA_VTB_SFHAPO_STR-ABASTAGE sy-vline 
WA_VTB_SFHAPO_STR-PKOND sy-vline 
WA_VTB_SFHAPO_STR-DPKOND sy-vline 
WA_VTB_SFHAPO_STR-DZFEST sy-vline 
WA_VTB_SFHAPO_STR-SZBMETH sy-vline 
WA_VTB_SFHAPO_STR-SKALIDWT sy-vline 
WA_VTB_SFHAPO_STR-BBASIS sy-vline 
WA_VTB_SFHAPO_STR-WBASIS sy-vline 
WA_VTB_SFHAPO_STR-JEXPOZINS sy-vline 
WA_VTB_SFHAPO_STR-SINCL sy-vline 
WA_VTB_SFHAPO_STR-SINCLBIS sy-vline 
WA_VTB_SFHAPO_STR-SULTBIS sy-vline 
WA_VTB_SFHAPO_STR-SEXCLVON sy-vline 
WA_VTB_SFHAPO_STR-SULTVON sy-vline 
WA_VTB_SFHAPO_STR-SAEND sy-vline 
WA_VTB_SFHAPO_STR-DVALUT sy-vline 
WA_VTB_SFHAPO_STR-SVINCL sy-vline 
WA_VTB_SFHAPO_STR-SVULT sy-vline 
WA_VTB_SFHAPO_STR-JSOFVERR sy-vline 
WA_VTB_SFHAPO_STR-DVERRECH sy-vline 
WA_VTB_SFHAPO_STR-SINCLVERR sy-vline 
WA_VTB_SFHAPO_STR-SULTVERR sy-vline 
WA_VTB_SFHAPO_STR-SSTORNOMAN sy-vline 
WA_VTB_SFHAPO_STR-SSTORNOART sy-vline 
WA_VTB_SFHAPO_STR-SBWGARTREF sy-vline 
WA_VTB_SFHAPO_STR-SKHWFIX sy-vline 
WA_VTB_SFHAPO_STR-ZUONR sy-vline 
WA_VTB_SFHAPO_STR-RLDEPO sy-vline 
WA_VTB_SFHAPO_STR-RANL sy-vline 
WA_VTB_SFHAPO_STR-RTRBELNR sy-vline 
WA_VTB_SFHAPO_STR-BUPRC sy-vline 
WA_VTB_SFHAPO_STR-BPPRC sy-vline 
WA_VTB_SFHAPO_STR-WBBETR sy-vline 
WA_VTB_SFHAPO_STR-BBBETR sy-vline 
WA_VTB_SFHAPO_STR-WEBETR sy-vline 
WA_VTB_SFHAPO_STR-BEBETR sy-vline 
WA_VTB_SFHAPO_STR-SRUNIT sy-vline 
WA_VTB_SFHAPO_STR-KZWKURS sy-vline 
WA_VTB_SFHAPO_STR-KBWKURS sy-vline 
WA_VTB_SFHAPO_STR-WSBETR sy-vline 
WA_VTB_SFHAPO_STR-DBESTAND sy-vline 
WA_VTB_SFHAPO_STR-SSTCKKZ sy-vline 
WA_VTB_SFHAPO_STR-SSTCKTG sy-vline 
WA_VTB_SFHAPO_STR-SFLAT sy-vline 
WA_VTB_SFHAPO_STR-SCOUPON sy-vline 
WA_VTB_SFHAPO_STR-DCOUPON sy-vline 
WA_VTB_SFHAPO_STR-AWKEY sy-vline 
WA_VTB_SFHAPO_STR-INDEX_VALUE sy-vline 
WA_VTB_SFHAPO_STR-SBASIS sy-vline 
WA_VTB_SFHAPO_STR-REGI_STATE sy-vline 
WA_VTB_SFHAPO_STR-RPCODE sy-vline 
WA_VTB_SFHAPO_STR-RP_TEXT sy-vline 
WA_VTB_SFHAPO_STR-HEDGE_ID sy-vline 
WA_VTB_SFHAPO_STR-DBPERIOD sy-vline 
WA_VTB_SFHAPO_STR-SPAEXCL sy-vline 
WA_VTB_SFHAPO_STR-SPAULT sy-vline 
WA_VTB_SFHAPO_STR-DEPERIOD sy-vline 
WA_VTB_SFHAPO_STR-SPEINCL sy-vline 
WA_VTB_SFHAPO_STR-SPEULT sy-vline 
WA_VTB_SFHAPO_STR-AMMRHY sy-vline 
WA_VTB_SFHAPO_STR-PPAYMENT sy-vline 
WA_VTB_SFHAPO_STR-AMMRHYZV sy-vline 
WA_VTB_SFHAPO_STR-LZBKZ sy-vline 
WA_VTB_SFHAPO_STR-LANDL sy-vline 
WA_VTB_SFHAPO_STR-BDIRTY sy-vline 
WA_VTB_SFHAPO_STR-BAMOUNTCOMP sy-vline 
WA_VTB_SFHAPO_STR-NOMINAL_ORG_AMT sy-vline 
WA_VTB_SFHAPO_STR-NOM_FACTOR sy-vline 
WA_VTB_SFHAPO_STR-RLDEPO2 sy-vline 
WA_VTB_SFHAPO_STR-INDEX_PRICE sy-vline 
WA_VTB_SFHAPO_STR-FLOWUUID sy-vline 
WA_VTB_SFHAPO_STR-FLAGBYTE1 sy-vline 
WA_VTB_SFHAPO_STR-QUANTITY sy-vline 
WA_VTB_SFHAPO_STR-UNIT_OF_MEASURE sy-vline 
WA_VTB_SFHAPO_STR-CONTRACT_PRICE sy-vline 
WA_VTB_SFHAPO_STR-SPOT_PRICE sy-vline 
WA_VTB_SFHAPO_STR-CONTANGO_BACKWRD sy-vline 
WA_VTB_SFHAPO_STR-BPRC_SPOT1 sy-vline 
WA_VTB_SFHAPO_STR-BPRC_SPOT2 sy-vline 
WA_VTB_SFHAPO_STR-COST_FWD sy-vline 
WA_VTB_SFHAPO_STR-INTEREST_FWD sy-vline 
WA_VTB_SFHAPO_STR-REF_FLOWUUID sy-vline 
WA_VTB_SFHAPO_STR-RGATT sy-vline 
WA_VTB_SFHAPO_STR-COMMODITY_ID sy-vline 
WA_VTB_SFHAPO_STR-QUOTATION_NAME sy-vline 
WA_VTB_SFHAPO_STR-QUOTATION_SOURCE sy-vline 
WA_VTB_SFHAPO_STR-QUOTATION_TYPE sy-vline 
WA_VTB_SFHAPO_STR-SPREAD sy-vline 
WA_VTB_SFHAPO_STR-PRICE_CURR_UNIT sy-vline 
WA_VTB_SFHAPO_STR-PRICE_UOM sy-vline 
WA_VTB_SFHAPO_STR-DIV_PCTC_OTC sy-vline 
WA_VTB_SFHAPO_STR-TAINTED sy-vline 
WA_VTB_SFHAPO_STR-CLEARED sy-vline 
WA_VTB_SFHAPO_STR-DCSID sy-vline 
WA_VTB_SFHAPO_STR-MIC sy-vline 
WA_VTB_SFHAPO_STR-PRICE_TYPE sy-vline 
WA_VTB_SFHAPO_STR-TIME_TO_MATURITY sy-vline 
WA_VTB_SFHAPO_STR-TIMING sy-vline 
WA_VTB_SFHAPO_STR-EXCH_RATE_TYPE sy-vline 
WA_VTB_SFHAPO_STR-PRICE_PAYM_CURR sy-vline 
WA_VTB_SFHAPO_STR-SPREAD_PAYM_CURR sy-vline 
WA_VTB_SFHAPO_STR-FX_TRANSLATION sy-vline 
WA_VTB_SFHAPO_STR-MNDID sy-vline 
WA_VTB_SFHAPO_STR-BUGRENZ sy-vline 
WA_VTB_SFHAPO_STR-BOGRENZ sy-vline 
WA_VTB_SFHAPO_STR-SSTAFF sy-vline 
WA_VTB_SFHAPO_STR-LOGIC_RKOND sy-vline 
WA_VTB_SFHAPO_STR-RKONDREF sy-vline 
WA_VTB_SFHAPO_STR-DGUEL_KPREF sy-vline 
WA_VTB_SFHAPO_STR-PRESENT_DATE sy-vline 
WA_VTB_SFHAPO_STR-INTEREST_PAID_BY sy-vline 
WA_VTB_SFHAPO_STR-SHIPMENT_DATE sy-vline 
WA_VTB_SFHAPO_STR-STATUS sy-vline 
WA_VTB_SFHAPO_STR-PRESENT_ID sy-vline 
WA_VTB_SFHAPO_STR-SSTOGRD sy-vline 
WA_VTB_SFHAPO_STR-PRESENT_AMOUNT sy-vline 
WA_VTB_SFHAPO_STR-PRESENT_BANK sy-vline 
WA_VTB_SFHAPO_STR-PRESENT_DISCREPANCY sy-vline 
WA_VTB_SFHAPO_STR-PRESENT_DECREASE_AMOUNT sy-vline 
WA_VTB_SFHAPO_STR-PRESENT_REA_CRE_LINE sy-vline 
WA_VTB_SFHAPO_STR-PRESENT_PAY_AMT sy-vline 
WA_VTB_SFHAPO_STR-SROUNDFACTOR sy-vline 
WA_VTB_SFHAPO_STR-ROUNDDECFACTOR sy-vline 
WA_VTB_SFHAPO_STR-JEXPOINTFACTOR sy-vline 
WA_VTB_SFHAPO_STR-FLOWFACTOR sy-vline 
WA_VTB_SFHAPO_STR-BASEFACTOR sy-vline 
WA_VTB_SFHAPO_STR-SROUNDBASEFACTOR sy-vline 
WA_VTB_SFHAPO_STR-ROUNDDECBASEFACTOR sy-vline 
WA_VTB_SFHAPO_STR-SKBWFIX sy-vline 
WA_VTB_SFHAPO_STR-GROUPING_TERM sy-vline 
WA_VTB_SFHAPO_STR-SSEQUENCE sy-vline 
WA_VTB_SFHAPO_STR-SROUNDRATEFACTOR sy-vline 
WA_VTB_SFHAPO_STR-ROUNDDECRATEFACTOR sy-vline 
WA_VTB_SFHAPO_STR-AAVGDAYS sy-vline 
WA_VTB_SFHAPO_STR-PAVGINTEREST sy-vline 
WA_VTB_SFHAPO_STR-STGBASIS sy-vline 
WA_VTB_SFHAPO_STR-JAVGCAP sy-vline 
WA_VTB_SFHAPO_STR-PAVGCAP sy-vline 
WA_VTB_SFHAPO_STR-JAVGFLOOR sy-vline 
WA_VTB_SFHAPO_STR-PAVGFLOOR sy-vline 
WA_VTB_SFHAPO_STR-PAVGSPREAD sy-vline 
WA_VTB_SFHAPO_STR-SROUNDAVGINTEREST sy-vline 
WA_VTB_SFHAPO_STR-ROUNDDECAVGINTEREST sy-vline 
WA_VTB_SFHAPO_STR-AAVGWEIGHT sy-vline 
WA_VTB_SFHAPO_STR-AAVGWEIGHTSUM sy-vline 
WA_VTB_SFHAPO_STR-FX_FIXING_DATE sy-vline 
WA_VTB_SFHAPO_STR-FX_REGI_STATE sy-vline 
WA_VTB_SFHAPO_STR-FX_READ_DATE sy-vline 
WA_VTB_SFHAPO_STR-PRICEINDEX_FIX_DATE_LOW sy-vline 
WA_VTB_SFHAPO_STR-PRICEINDEX_READ_DATE_LOW sy-vline 
WA_VTB_SFHAPO_STR-PRICEINDEX_FIX_DATE_HIGH sy-vline 
WA_VTB_SFHAPO_STR-PRICEINDEX_READ_DATE_HIGH sy-vline 
WA_VTB_SFHAPO_STR-PRICEINDEX_REGI_STATE sy-vline 
WA_VTB_SFHAPO_STR-BBBETR_IDXCLEAN sy-vline 
WA_VTB_SFHAPO_STR-TRADED_QUANTITY sy-vline 
WA_VTB_SFHAPO_STR-TRADED_QUANTITY_UOM sy-vline 
WA_VTB_SFHAPO_STR-CONV_FACTOR_TRADED_QTY sy-vline 
WA_VTB_SFHAPO_STR-CONV_FACTOR_TRADED_QTY_UOM sy-vline 
WA_VTB_SFHAPO_STR-CONV_FACTOR_PRICED_QTY sy-vline 
WA_VTB_SFHAPO_STR-CONV_FACTOR_PRICED_QTY_UOM sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_TYPE sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_PERC sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_TOTA sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_CURR sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_FORM sy-vline 
WA_VTB_SFHAPO_STR-XZTERM sy-vline 
WA_VTB_SFHAPO_STR-XZBETR sy-vline 
WA_VTB_SFHAPO_STR-DBESTANDX sy-vline 
WA_VTB_SFHAPO_STR-DVALUTX sy-vline 
WA_VTB_SFHAPO_STR-BMARGIN sy-vline 
WA_VTB_SFHAPO_STR-XNWHR sy-vline 
WA_VTB_SFHAPO_STR-XBSPOT sy-vline 
WA_VTB_SFHAPO_STR-BSPOT sy-vline 
WA_VTB_SFHAPO_STR-SPOTRATE sy-vline 
WA_VTB_SFHAPO_STR-BFORW sy-vline 
WA_VTB_SFHAPO_STR-WHWBETR sy-vline 
WA_VTB_SFHAPO_STR-XBBETR sy-vline 
WA_VTB_SFHAPO_STR-XBEWART sy-vline 
WA_VTB_SFHAPO_STR-SSELECTED sy-vline 
WA_VTB_SFHAPO_STR-XPRICE sy-vline 
WA_VTB_SFHAPO_STR-XSTORNOART sy-vline 
WA_VTB_SFHAPO_STR-XKALIDWT sy-vline 
WA_VTB_SFHAPO_STR-XINCL sy-vline 
WA_VTB_SFHAPO_STR-KZWKURS_FROM sy-vline 
WA_VTB_SFHAPO_STR-KZWKURS_TO sy-vline 
WA_VTB_SFHAPO_STR-KHWKURS_FROM sy-vline 
WA_VTB_SFHAPO_STR-KHWKURS_TO sy-vline 
WA_VTB_SFHAPO_STR-KBWKURS_FROM sy-vline 
WA_VTB_SFHAPO_STR-KBWKURS_TO sy-vline 
WA_VTB_SFHAPO_STR-XHBETR sy-vline 
WA_VTB_SFHAPO_STR-XEBETR sy-vline 
WA_VTB_SFHAPO_STR-XFLG_DEALFLOW sy-vline 
WA_VTB_SFHAPO_STR-WZBETR_NEW sy-vline 
WA_VTB_SFHAPO_STR-SRUNIT_NEW sy-vline 
WA_VTB_SFHAPO_STR-DEFECT_RATE sy-vline 
WA_VTB_SFHAPO_STR-DEFECT_RATE_NEW sy-vline 
WA_VTB_SFHAPO_STR-ZUONR_NEW sy-vline 
WA_VTB_SFHAPO_STR-INDEX_VALUE_P sy-vline 
WA_VTB_SFHAPO_STR-INDEX_VALUE_U sy-vline 
WA_VTB_SFHAPO_STR-BPRC_SPOT1_PER sy-vline 
WA_VTB_SFHAPO_STR-BPRC_SPOT1_CURR sy-vline 
WA_VTB_SFHAPO_STR-BPRC_SPOT2_PER sy-vline 
WA_VTB_SFHAPO_STR-BPRC_SPOT2_CURR sy-vline 
WA_VTB_SFHAPO_STR-COST_FWD_PER sy-vline 
WA_VTB_SFHAPO_STR-COST_FWD_CURR sy-vline 
WA_VTB_SFHAPO_STR-INTEREST_FWD_PER sy-vline 
WA_VTB_SFHAPO_STR-INTEREST_FWD_CURR sy-vline 
WA_VTB_SFHAPO_STR-SRUNIT_COST sy-vline 
WA_VTB_SFHAPO_STR-SRUNIT_INT sy-vline 
WA_VTB_SFHAPO_STR-SFHAZBA_R sy-vline 
WA_VTB_SFHAPO_STR-XBEWART_R sy-vline 
WA_VTB_SFHAPO_STR-BPPRC_R sy-vline 
WA_VTB_SFHAPO_STR-BUPRC_R sy-vline 
WA_VTB_SFHAPO_STR-SRUNIT_R sy-vline 
WA_VTB_SFHAPO_STR-DBESTANDX_R sy-vline 
WA_VTB_SFHAPO_STR-DBESTAND_R sy-vline 
WA_VTB_SFHAPO_STR-DVALUTX_R sy-vline 
WA_VTB_SFHAPO_STR-DVALUT_R sy-vline 
WA_VTB_SFHAPO_STR-XZTERM_R sy-vline 
WA_VTB_SFHAPO_STR-DZTERM_R sy-vline 
WA_VTB_SFHAPO_STR-XEBETR_R sy-vline 
WA_VTB_SFHAPO_STR-BEBETR_R sy-vline 
WA_VTB_SFHAPO_STR-WEBETR_R sy-vline 
WA_VTB_SFHAPO_STR-XZBETR_R sy-vline 
WA_VTB_SFHAPO_STR-BZBETR_R sy-vline 
WA_VTB_SFHAPO_STR-WZBETR_R sy-vline 
WA_VTB_SFHAPO_STR-XHBETR_R sy-vline 
WA_VTB_SFHAPO_STR-BHWBETR_R sy-vline 
WA_VTB_SFHAPO_STR-WHWBETR_R sy-vline 
WA_VTB_SFHAPO_STR-XBBETR_R sy-vline 
WA_VTB_SFHAPO_STR-BBBETR_R sy-vline 
WA_VTB_SFHAPO_STR-WBBETR_R sy-vline 
WA_VTB_SFHAPO_STR-KZWKURS_R sy-vline 
WA_VTB_SFHAPO_STR-KZWKURS_FROM_R sy-vline 
WA_VTB_SFHAPO_STR-KZWKURS_TO_R sy-vline 
WA_VTB_SFHAPO_STR-KHWKURS_R sy-vline 
WA_VTB_SFHAPO_STR-KHWKURS_FROM_R sy-vline 
WA_VTB_SFHAPO_STR-KHWKURS_TO_R sy-vline 
WA_VTB_SFHAPO_STR-KBWKURS_R sy-vline 
WA_VTB_SFHAPO_STR-KBWKURS_FROM_R sy-vline 
WA_VTB_SFHAPO_STR-KBWKURS_TO_R sy-vline 
WA_VTB_SFHAPO_STR-SBKTYP_R sy-vline 
WA_VTB_SFHAPO_STR-SSIGN_R sy-vline 
WA_VTB_SFHAPO_STR-SHERKUNFT_R sy-vline 
WA_VTB_SFHAPO_STR-ASTUECK_R sy-vline 
WA_VTB_SFHAPO_STR-XNWHR_R sy-vline 
WA_VTB_SFHAPO_STR-BNWHR_R sy-vline 
WA_VTB_SFHAPO_STR-SBKKLAS_R sy-vline 
WA_VTB_SFHAPO_STR-SBERFIMA_R sy-vline 
WA_VTB_SFHAPO_STR-RFHAZU_R sy-vline 
WA_VTB_SFHAPO_STR-RFHAZB_R sy-vline 
WA_VTB_SFHAPO_STR-DCRDAT_R sy-vline 
WA_VTB_SFHAPO_STR-TCRTIM_R sy-vline 
WA_VTB_SFHAPO_STR-CRUSER_R sy-vline 
WA_VTB_SFHAPO_STR-UPUSER_R sy-vline 
WA_VTB_SFHAPO_STR-DUPDAT_R sy-vline 
WA_VTB_SFHAPO_STR-TUPTIM_R sy-vline 
WA_VTB_SFHAPO_STR-RANTYP_R sy-vline 
WA_VTB_SFHAPO_STR-SABVERF_R sy-vline 
WA_VTB_SFHAPO_STR-RKONDGR_R sy-vline 
WA_VTB_SFHAPO_STR-RKOND_R sy-vline 
WA_VTB_SFHAPO_STR-DGUEL_KP_R sy-vline 
WA_VTB_SFHAPO_STR-NSTUFE_R sy-vline 
WA_VTB_SFHAPO_STR-SKOART_R sy-vline 
WA_VTB_SFHAPO_STR-RREFKONT_R sy-vline 
WA_VTB_SFHAPO_STR-SBZVABW_R sy-vline 
WA_VTB_SFHAPO_STR-RAHABKI_R sy-vline 
WA_VTB_SFHAPO_STR-RAHKTID_R sy-vline 
WA_VTB_SFHAPO_STR-RPZAHL_R sy-vline 
WA_VTB_SFHAPO_STR-RPBANK_R sy-vline 
WA_VTB_SFHAPO_STR-SZART_R sy-vline 
WA_VTB_SFHAPO_STR-ZLSCH_R sy-vline 
WA_VTB_SFHAPO_STR-UZAWE_R sy-vline 
WA_VTB_SFHAPO_STR-SPAYRQ_R sy-vline 
WA_VTB_SFHAPO_STR-SPRSNG_R sy-vline 
WA_VTB_SFHAPO_STR-SPRGRD_R sy-vline 
WA_VTB_SFHAPO_STR-SCSPAY_R sy-vline 
WA_VTB_SFHAPO_STR-ZWELS_R sy-vline 
WA_VTB_SFHAPO_STR-PAYGR_R sy-vline 
WA_VTB_SFHAPO_STR-SBEWEBE_R sy-vline 
WA_VTB_SFHAPO_STR-SSPRGRD_R sy-vline 
WA_VTB_SFHAPO_STR-SBFREI_R sy-vline 
WA_VTB_SFHAPO_STR-SSTORNOBWG_R sy-vline 
WA_VTB_SFHAPO_STR-PRKEY_R sy-vline 
WA_VTB_SFHAPO_STR-BELNR_R sy-vline 
WA_VTB_SFHAPO_STR-BELNR2_R sy-vline 
WA_VTB_SFHAPO_STR-GJAHR_R sy-vline 
WA_VTB_SFHAPO_STR-DBUCHUNG_R sy-vline 
WA_VTB_SFHAPO_STR-DFAELL_R sy-vline 
WA_VTB_SFHAPO_STR-BPRICE_R sy-vline 
WA_VTB_SFHAPO_STR-WPRICE_R sy-vline 
WA_VTB_SFHAPO_STR-BHWPREIS_R sy-vline 
WA_VTB_SFHAPO_STR-BINDEX_R sy-vline 
WA_VTB_SFHAPO_STR-VVBASIS_R sy-vline 
WA_VTB_SFHAPO_STR-PWKURS_R sy-vline 
WA_VTB_SFHAPO_STR-PRKKURS_R sy-vline 
WA_VTB_SFHAPO_STR-RHANDPL_R sy-vline 
WA_VTB_SFHAPO_STR-SKURSART_R sy-vline 
WA_VTB_SFHAPO_STR-DBERVON_R sy-vline 
WA_VTB_SFHAPO_STR-DBERBIS_R sy-vline 
WA_VTB_SFHAPO_STR-ATAGE_R sy-vline 
WA_VTB_SFHAPO_STR-ABASTAGE_R sy-vline 
WA_VTB_SFHAPO_STR-PKOND_R sy-vline 
WA_VTB_SFHAPO_STR-DPKOND_R sy-vline 
WA_VTB_SFHAPO_STR-DZFEST_R sy-vline 
WA_VTB_SFHAPO_STR-SZBMETH_R sy-vline 
WA_VTB_SFHAPO_STR-SKALIDWT_R sy-vline 
WA_VTB_SFHAPO_STR-BBASIS_R sy-vline 
WA_VTB_SFHAPO_STR-WBASIS_R sy-vline 
WA_VTB_SFHAPO_STR-JEXPOZINS_R sy-vline 
WA_VTB_SFHAPO_STR-SINCL_R sy-vline 
WA_VTB_SFHAPO_STR-SINCLBIS_R sy-vline 
WA_VTB_SFHAPO_STR-SULTBIS_R sy-vline 
WA_VTB_SFHAPO_STR-SEXCLVON_R sy-vline 
WA_VTB_SFHAPO_STR-SULTVON_R sy-vline 
WA_VTB_SFHAPO_STR-SAEND_R sy-vline 
WA_VTB_SFHAPO_STR-SVINCL_R sy-vline 
WA_VTB_SFHAPO_STR-SVULT_R sy-vline 
WA_VTB_SFHAPO_STR-JSOFVERR_R sy-vline 
WA_VTB_SFHAPO_STR-DVERRECH_R sy-vline 
WA_VTB_SFHAPO_STR-SINCLVERR_R sy-vline 
WA_VTB_SFHAPO_STR-SULTVERR_R sy-vline 
WA_VTB_SFHAPO_STR-SSTORNOMAN_R sy-vline 
WA_VTB_SFHAPO_STR-SSTORNOART_R sy-vline 
WA_VTB_SFHAPO_STR-SBWGARTREF_R sy-vline 
WA_VTB_SFHAPO_STR-SKHWFIX_R sy-vline 
WA_VTB_SFHAPO_STR-ZUONR_R sy-vline 
WA_VTB_SFHAPO_STR-RLDEPO_R sy-vline 
WA_VTB_SFHAPO_STR-RANL_R sy-vline 
WA_VTB_SFHAPO_STR-RTRBELNR_R sy-vline 
WA_VTB_SFHAPO_STR-WSBETR_R sy-vline 
WA_VTB_SFHAPO_STR-SSTCKKZ_R sy-vline 
WA_VTB_SFHAPO_STR-SSTCKTG_R sy-vline 
WA_VTB_SFHAPO_STR-SFLAT_R sy-vline 
WA_VTB_SFHAPO_STR-SCOUPON_R sy-vline 
WA_VTB_SFHAPO_STR-DCOUPON_R sy-vline 
WA_VTB_SFHAPO_STR-AWKEY_R sy-vline 
WA_VTB_SFHAPO_STR-INDEX_VALUE_R sy-vline 
WA_VTB_SFHAPO_STR-SBASIS_R sy-vline 
WA_VTB_SFHAPO_STR-REGI_STATE_R sy-vline 
WA_VTB_SFHAPO_STR-RPCODE_R sy-vline 
WA_VTB_SFHAPO_STR-RP_TEXT_R sy-vline 
WA_VTB_SFHAPO_STR-HEDGE_ID_R sy-vline 
WA_VTB_SFHAPO_STR-XINCL_R sy-vline 
WA_VTB_SFHAPO_STR-XASTUECK sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_FIX sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_AMO sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_TOTAT sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_PERCT sy-vline 
WA_VTB_SFHAPO_STR-IDCFM_USHA_CURRT sy-vline      INTO ld_text SEPARATED BY SPACE.

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