ABAP Select data from SAP table FTI_BI_REP_ODS 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 FTI_BI_REP_ODS 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 FTI_BI_REP_ODS. 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 FTI_BI_REP_ODS 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_FTI_BI_REP_ODS TYPE STANDARD TABLE OF FTI_BI_REP_ODS,
      WA_FTI_BI_REP_ODS TYPE FTI_BI_REP_ODS,
      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: <FTI_BI_REP_ODS> TYPE FTI_BI_REP_ODS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FTI_BI_REP_ODS
*  INTO TABLE @DATA(IT_FTI_BI_REP_ODS2).
*--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_FTI_BI_REP_ODS INDEX 1 INTO DATA(WA_FTI_BI_REP_ODS2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FTI_BI_REP_ODS>-MANDT = 1.
<FTI_BI_REP_ODS>-VALUATION_AREA = 1.
<FTI_BI_REP_ODS>-BUSTRANSID = 1.
<FTI_BI_REP_ODS>-TRLFLOWNUMBER = 1.
<FTI_BI_REP_ODS>-BUKRS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FTI_BI_REP_ODS-TR_ACC_CODE, sy-vline,
  WA_FTI_BI_REP_ODS-VALUATION_CLASS, sy-vline,
  WA_FTI_BI_REP_ODS-GSART, sy-vline,
  WA_FTI_BI_REP_ODS-PORTFOLIO, sy-vline,
  WA_FTI_BI_REP_ODS-SECURITY_ID, sy-vline,
  WA_FTI_BI_REP_ODS-LOANS_CONTRACT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FTI_BI_REP_ODS 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_FTI_BI_REP_ODS 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_FTI_BI_REP_ODS INTO WA_FTI_BI_REP_ODS.


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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit TRLBS, internal->external for field TRL_BOOKINGSTATE
CALL FUNCTION 'CONVERSION_EXIT_TRLBS_OUTPUT'
  EXPORTING
    input =                      WA_FTI_BI_REP_ODS-TRL_BOOKINGSTATE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FTI_BI_REP_ODS-TRL_BOOKINGSTATE.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit PERI7, internal->external for field PERIO
CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT'
  EXPORTING
    input =                      WA_FTI_BI_REP_ODS-PERIO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FTI_BI_REP_ODS-PERIO.
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_FTI_BI_REP_ODS_STR, 
MANDT TYPE STRING,
VALUATION_AREA TYPE STRING,
BUSTRANSID TYPE STRING,
TRLFLOWNUMBER TYPE STRING,
BUKRS TYPE STRING,
TR_ACC_CODE TYPE STRING,
VALUATION_CLASS TYPE STRING,
GSART TYPE STRING,
PORTFOLIO TYPE STRING,
SECURITY_ID TYPE STRING,
LOANS_CONTRACT TYPE STRING,
DEAL_NUMBER TYPE STRING,
HEDGE_ID TYPE STRING,
ACCOUNT_GROUP TYPE STRING,
SECURITY_ACCOUNT TYPE STRING,
POSITION_ACCOUNT TYPE STRING,
FLAG_LONG_SHORT TYPE STRING,
LOT_ID TYPE STRING,
DLOTGENERATION TYPE STRING,
TLOTGENERATION TYPE STRING,
LOTGENERATION_US TYPE STRING,
LOTGENERATION_CT TYPE STRING,
LOTPOS_INIT_DATE TYPE STRING,
LOTPOS_ORG_DATE TYPE STRING,
LOTGEN_DEALNR TYPE STRING,
HREL_NUMBER TYPE STRING,
FISCAL_YEAR TYPE STRING,
HITEM_NUMBER TYPE STRING,
HINST_NUMBER TYPE STRING,
FIKRS TYPE STRING,
FUND TYPE STRING,
GRANT_NBR TYPE STRING,
ACC_ASS_REF TYPE STRING,
HKONT TYPE STRING,
DBESTAND TYPE STRING,
SE_DEAL_NUMBER TYPE STRING,
RKONTRA TYPE STRING,
FLOW_TYPE TYPE STRING,
BUSTRANSCAT TYPE STRING,
GEN_BUSTRANSCAT TYPE STRING,
SOURCETARGET_FLG TYPE STRING,
QUANT_CAT TYPE STRING,
AMOUNT_CAT TYPE STRING,
TRL_BOOKINGSTATE TYPE STRING,
PL_CATEGORY TYPE STRING,
LEDGER_POST_STAT TYPE STRING,
BELNR TYPE STRING,
AWKEY TYPE STRING,
GL_ACCOUNT_D TYPE STRING,
GL_ACCOUNT_C TYPE STRING,
DBUDAT TYPE STRING,
DGJAHR TYPE STRING,
DMONAT TYPE STRING,
PERIO TYPE STRING,
SZBMETH TYPE STRING,
DBERVON TYPE STRING,
DBERBIS TYPE STRING,
SINCLVON TYPE STRING,
SINCLBIS TYPE STRING,
SSOLHAB TYPE STRING,
SHWHR TYPE STRING,
SVWHR TYPE STRING,
SBWHR TYPE STRING,
PLWHR TYPE STRING,
D_UNITS TYPE STRING,
D_NOMINAL_AMT_PC TYPE STRING,
D_NOMINAL_ORG_PC TYPE STRING,
D_PURCH_PC TYPE STRING,
D_PURCH_LC TYPE STRING,
D_PURCH_VC TYPE STRING,
D_AQU_VAL_PC TYPE STRING,
D_AQU_VAL_LC TYPE STRING,
D_AQU_VAL_VC TYPE STRING,
D_BOOK_VAL_PC TYPE STRING,
D_BOOK_VAL_LC TYPE STRING,
D_BOOK_VAL_VC TYPE STRING,
D_CHARGE_PC TYPE STRING,
D_CHARGE_LC TYPE STRING,
D_CHARGE_VC TYPE STRING,
D_BOOK_VAL_EX_PC TYPE STRING,
D_BOOK_VAL_EX_LC TYPE STRING,
D_BOOK_VAL_EX_VC TYPE STRING,
D_VAL_TI_PC TYPE STRING,
D_VAL_TI_LC TYPE STRING,
D_VAL_TI_VC TYPE STRING,
D_VAL_FX_LC TYPE STRING,
D_VAL_FX_VC TYPE STRING,
D_VALFXAAQUVL_LC TYPE STRING,
D_VALFXAAQUVL_VC TYPE STRING,
D_VAL_CH_TI_PC TYPE STRING,
D_VAL_CH_TI_LC TYPE STRING,
D_VAL_CH_TI_VC TYPE STRING,
D_VAL_CH_FX_LC TYPE STRING,
D_VAL_CH_FX_VC TYPE STRING,
D_AMORT_PC TYPE STRING,
D_AMORT_LC TYPE STRING,
D_AMORT_VC TYPE STRING,
D_IMPMNT_PC TYPE STRING,
D_IMPMNT_LC TYPE STRING,
D_IMPMNT_VC TYPE STRING,
D_IMPMNT_FX_LC TYPE STRING,
D_IMPMNT_FX_VC TYPE STRING,
D_REPAYMENT_PC TYPE STRING,
D_REPAYMENT_LC TYPE STRING,
D_REPAYMENT_VC TYPE STRING,
D_AMAQU_VAL_PC TYPE STRING,
D_AMAQU_VAL_LC TYPE STRING,
D_AMAQU_VAL_VC TYPE STRING,
D_DISAGIO_PC TYPE STRING,
D_DISAGIO_LC TYPE STRING,
D_DISAGIO_VC TYPE STRING,
D_VAL_TI_NPL_PC TYPE STRING,
D_VAL_TI_NPL_LC TYPE STRING,
D_VAL_TI_NPL_VC TYPE STRING,
D_VAL_FX_NPL_LC TYPE STRING,
D_VAL_FX_NPL_VC TYPE STRING,
D_VAL_CH_TI_N_PC TYPE STRING,
D_VAL_CH_TI_N_LC TYPE STRING,
D_VAL_CH_TI_N_VC TYPE STRING,
D_VAL_CH_FX_N_LC TYPE STRING,
D_VAL_CH_FX_N_VC TYPE STRING,
D_VARMAR_PC TYPE STRING,
D_VARMAR_LC TYPE STRING,
D_VARMAR_VC TYPE STRING,
D_SPOTVALP_LC TYPE STRING,
D_SPOTVALP_VC TYPE STRING,
D_SPOTVALS_LC TYPE STRING,
D_SPOTVALS_VC TYPE STRING,
D_SWAPACC_PC TYPE STRING,
D_SWAPACC_LC TYPE STRING,
D_SWAPACC_VC TYPE STRING,
D_SWAPVAL_LC TYPE STRING,
D_SWAPVAL_VC TYPE STRING,
AMOUNT_PC TYPE STRING,
AMOUNT_LC TYPE STRING,
AMOUNT_VC TYPE STRING,
PLAMOUNT_PLC TYPE STRING,
PLAMOUNT_LC TYPE STRING,
D_ORIG_VAD_LC TYPE STRING,
D_ORIG_VAD_PC TYPE STRING,
D_ORIG_VAD_VC TYPE STRING,
D_VAD_GAIN_LC TYPE STRING,
D_VAD_GAIN_PC TYPE STRING,
D_VAD_GAIN_VC TYPE STRING,
D_VAD_LOSS_LC TYPE STRING,
D_VAD_LOSS_PC TYPE STRING,
D_VAD_LOSS_VC TYPE STRING,
D_HADJ_LC TYPE STRING,
D_HADJ_PC TYPE STRING,
D_HADJ_VC TYPE STRING,
D_EFFECTIVE_LC TYPE STRING,
D_EFFECTIVE_PC TYPE STRING,
D_EFFECTIVE_VC TYPE STRING,
D_EFF_DORMANT_LC TYPE STRING,
D_EFF_DORMANT_PC TYPE STRING,
D_EFF_DORMANT_VC TYPE STRING,
D_INEFFECTIVE_LC TYPE STRING,
D_INEFFECTIVE_PC TYPE STRING,
D_INEFFECTIVE_VC TYPE STRING,
D_INEFF_DORM_LC TYPE STRING,
D_INEFF_DORM_P TYPE STRING,
D_INEFF_DORM_V TYPE STRING,
UPDMOD TYPE STRING,
CREATE_NAME TYPE STRING,
CREATE_DATE TYPE STRING,
CREATE_TIME TYPE STRING,
REQUEST_ID TYPE STRING,
REQUEST_DATE TYPE STRING,
REQUEST_TIME TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FTI_BI_REP_ODS_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_FTI_BI_REP_ODS_STR-MANDT sy-vline 
WA_FTI_BI_REP_ODS_STR-VALUATION_AREA sy-vline 
WA_FTI_BI_REP_ODS_STR-BUSTRANSID sy-vline 
WA_FTI_BI_REP_ODS_STR-TRLFLOWNUMBER sy-vline 
WA_FTI_BI_REP_ODS_STR-BUKRS sy-vline 
WA_FTI_BI_REP_ODS_STR-TR_ACC_CODE sy-vline 
WA_FTI_BI_REP_ODS_STR-VALUATION_CLASS sy-vline 
WA_FTI_BI_REP_ODS_STR-GSART sy-vline 
WA_FTI_BI_REP_ODS_STR-PORTFOLIO sy-vline 
WA_FTI_BI_REP_ODS_STR-SECURITY_ID sy-vline 
WA_FTI_BI_REP_ODS_STR-LOANS_CONTRACT sy-vline 
WA_FTI_BI_REP_ODS_STR-DEAL_NUMBER sy-vline 
WA_FTI_BI_REP_ODS_STR-HEDGE_ID sy-vline 
WA_FTI_BI_REP_ODS_STR-ACCOUNT_GROUP sy-vline 
WA_FTI_BI_REP_ODS_STR-SECURITY_ACCOUNT sy-vline 
WA_FTI_BI_REP_ODS_STR-POSITION_ACCOUNT sy-vline 
WA_FTI_BI_REP_ODS_STR-FLAG_LONG_SHORT sy-vline 
WA_FTI_BI_REP_ODS_STR-LOT_ID sy-vline 
WA_FTI_BI_REP_ODS_STR-DLOTGENERATION sy-vline 
WA_FTI_BI_REP_ODS_STR-TLOTGENERATION sy-vline 
WA_FTI_BI_REP_ODS_STR-LOTGENERATION_US sy-vline 
WA_FTI_BI_REP_ODS_STR-LOTGENERATION_CT sy-vline 
WA_FTI_BI_REP_ODS_STR-LOTPOS_INIT_DATE sy-vline 
WA_FTI_BI_REP_ODS_STR-LOTPOS_ORG_DATE sy-vline 
WA_FTI_BI_REP_ODS_STR-LOTGEN_DEALNR sy-vline 
WA_FTI_BI_REP_ODS_STR-HREL_NUMBER sy-vline 
WA_FTI_BI_REP_ODS_STR-FISCAL_YEAR sy-vline 
WA_FTI_BI_REP_ODS_STR-HITEM_NUMBER sy-vline 
WA_FTI_BI_REP_ODS_STR-HINST_NUMBER sy-vline 
WA_FTI_BI_REP_ODS_STR-FIKRS sy-vline 
WA_FTI_BI_REP_ODS_STR-FUND sy-vline 
WA_FTI_BI_REP_ODS_STR-GRANT_NBR sy-vline 
WA_FTI_BI_REP_ODS_STR-ACC_ASS_REF sy-vline 
WA_FTI_BI_REP_ODS_STR-HKONT sy-vline 
WA_FTI_BI_REP_ODS_STR-DBESTAND sy-vline 
WA_FTI_BI_REP_ODS_STR-SE_DEAL_NUMBER sy-vline 
WA_FTI_BI_REP_ODS_STR-RKONTRA sy-vline 
WA_FTI_BI_REP_ODS_STR-FLOW_TYPE sy-vline 
WA_FTI_BI_REP_ODS_STR-BUSTRANSCAT sy-vline 
WA_FTI_BI_REP_ODS_STR-GEN_BUSTRANSCAT sy-vline 
WA_FTI_BI_REP_ODS_STR-SOURCETARGET_FLG sy-vline 
WA_FTI_BI_REP_ODS_STR-QUANT_CAT sy-vline 
WA_FTI_BI_REP_ODS_STR-AMOUNT_CAT sy-vline 
WA_FTI_BI_REP_ODS_STR-TRL_BOOKINGSTATE sy-vline 
WA_FTI_BI_REP_ODS_STR-PL_CATEGORY sy-vline 
WA_FTI_BI_REP_ODS_STR-LEDGER_POST_STAT sy-vline 
WA_FTI_BI_REP_ODS_STR-BELNR sy-vline 
WA_FTI_BI_REP_ODS_STR-AWKEY sy-vline 
WA_FTI_BI_REP_ODS_STR-GL_ACCOUNT_D sy-vline 
WA_FTI_BI_REP_ODS_STR-GL_ACCOUNT_C sy-vline 
WA_FTI_BI_REP_ODS_STR-DBUDAT sy-vline 
WA_FTI_BI_REP_ODS_STR-DGJAHR sy-vline 
WA_FTI_BI_REP_ODS_STR-DMONAT sy-vline 
WA_FTI_BI_REP_ODS_STR-PERIO sy-vline 
WA_FTI_BI_REP_ODS_STR-SZBMETH sy-vline 
WA_FTI_BI_REP_ODS_STR-DBERVON sy-vline 
WA_FTI_BI_REP_ODS_STR-DBERBIS sy-vline 
WA_FTI_BI_REP_ODS_STR-SINCLVON sy-vline 
WA_FTI_BI_REP_ODS_STR-SINCLBIS sy-vline 
WA_FTI_BI_REP_ODS_STR-SSOLHAB sy-vline 
WA_FTI_BI_REP_ODS_STR-SHWHR sy-vline 
WA_FTI_BI_REP_ODS_STR-SVWHR sy-vline 
WA_FTI_BI_REP_ODS_STR-SBWHR sy-vline 
WA_FTI_BI_REP_ODS_STR-PLWHR sy-vline 
WA_FTI_BI_REP_ODS_STR-D_UNITS sy-vline 
WA_FTI_BI_REP_ODS_STR-D_NOMINAL_AMT_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_NOMINAL_ORG_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_PURCH_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_PURCH_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_PURCH_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AQU_VAL_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AQU_VAL_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AQU_VAL_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_BOOK_VAL_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_BOOK_VAL_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_BOOK_VAL_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_CHARGE_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_CHARGE_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_CHARGE_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_BOOK_VAL_EX_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_BOOK_VAL_EX_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_BOOK_VAL_EX_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_TI_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_TI_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_TI_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_FX_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_FX_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VALFXAAQUVL_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VALFXAAQUVL_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_TI_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_TI_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_TI_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_FX_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_FX_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AMORT_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AMORT_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AMORT_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_IMPMNT_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_IMPMNT_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_IMPMNT_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_IMPMNT_FX_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_IMPMNT_FX_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_REPAYMENT_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_REPAYMENT_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_REPAYMENT_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AMAQU_VAL_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AMAQU_VAL_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_AMAQU_VAL_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_DISAGIO_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_DISAGIO_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_DISAGIO_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_TI_NPL_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_TI_NPL_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_TI_NPL_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_FX_NPL_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_FX_NPL_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_TI_N_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_TI_N_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_TI_N_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_FX_N_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAL_CH_FX_N_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VARMAR_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VARMAR_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VARMAR_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SPOTVALP_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SPOTVALP_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SPOTVALS_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SPOTVALS_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SWAPACC_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SWAPACC_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SWAPACC_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SWAPVAL_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_SWAPVAL_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-AMOUNT_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-AMOUNT_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-AMOUNT_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-PLAMOUNT_PLC sy-vline 
WA_FTI_BI_REP_ODS_STR-PLAMOUNT_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_ORIG_VAD_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_ORIG_VAD_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_ORIG_VAD_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAD_GAIN_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAD_GAIN_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAD_GAIN_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAD_LOSS_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAD_LOSS_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_VAD_LOSS_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_HADJ_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_HADJ_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_HADJ_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_EFFECTIVE_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_EFFECTIVE_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_EFFECTIVE_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_EFF_DORMANT_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_EFF_DORMANT_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_EFF_DORMANT_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_INEFFECTIVE_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_INEFFECTIVE_PC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_INEFFECTIVE_VC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_INEFF_DORM_LC sy-vline 
WA_FTI_BI_REP_ODS_STR-D_INEFF_DORM_P sy-vline 
WA_FTI_BI_REP_ODS_STR-D_INEFF_DORM_V sy-vline 
WA_FTI_BI_REP_ODS_STR-UPDMOD sy-vline 
WA_FTI_BI_REP_ODS_STR-CREATE_NAME sy-vline 
WA_FTI_BI_REP_ODS_STR-CREATE_DATE sy-vline 
WA_FTI_BI_REP_ODS_STR-CREATE_TIME sy-vline 
WA_FTI_BI_REP_ODS_STR-REQUEST_ID sy-vline 
WA_FTI_BI_REP_ODS_STR-REQUEST_DATE sy-vline 
WA_FTI_BI_REP_ODS_STR-REQUEST_TIME sy-vline      INTO ld_text SEPARATED BY SPACE.

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