ABAP Select data from SAP table JBIUPCDFP 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 JBIUPCDFP 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 JBIUPCDFP. 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 JBIUPCDFP 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_JBIUPCDFP TYPE STANDARD TABLE OF JBIUPCDFP,
      WA_JBIUPCDFP TYPE JBIUPCDFP,
      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: <JBIUPCDFP> TYPE JBIUPCDFP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM JBIUPCDFP
*  INTO TABLE @DATA(IT_JBIUPCDFP2).
*--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_JBIUPCDFP INDEX 1 INTO DATA(WA_JBIUPCDFP2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<JBIUPCDFP>-SET_TYPE = 1.
<JBIUPCDFP>-MODE = 1.
<JBIUPCDFP>-TYPE = 1.
<JBIUPCDFP>-SECURITY_NUMBER = 1.
<JBIUPCDFP>-CATEGORY = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_JBIUPCDFP-STOCK_EXCHANGE, sy-vline,
  WA_JBIUPCDFP-CURRENCY, sy-vline,
  WA_JBIUPCDFP-CURRENCY_ISO, sy-vline,
  WA_JBIUPCDFP-FLAT_PRICE, sy-vline,
  WA_JBIUPCDFP-HOME_EXCHANGE, sy-vline,
  WA_JBIUPCDFP-LISTING_KEY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_JBIUPCDFP 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_JBIUPCDFP 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_JBIUPCDFP INTO WA_JBIUPCDFP.


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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field SECURITY_REFERENCE
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_JBIUPCDFP-SECURITY_REFERENCE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_JBIUPCDFP-SECURITY_REFERENCE.
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_JBIUPCDFP_STR, 
SET_TYPE TYPE STRING,
MODE TYPE STRING,
TYPE TYPE STRING,
SECURITY_NUMBER TYPE STRING,
CATEGORY TYPE STRING,
STOCK_EXCHANGE TYPE STRING,
CURRENCY TYPE STRING,
CURRENCY_ISO TYPE STRING,
FLAT_PRICE TYPE STRING,
HOME_EXCHANGE TYPE STRING,
LISTING_KEY TYPE STRING,
INDEX_NUMBER TYPE STRING,
INDEX_NAME TYPE STRING,
CONDITION_TYPE TYPE STRING,
VALID_FROM TYPE STRING,
CONDITION_FORM TYPE STRING,
AMOUNT TYPE STRING,
REF_SIGN TYPE STRING,
PERCENTAGE_RATE TYPE STRING,
INTEREST_CALC_METHOD TYPE STRING,
CALC_DATE TYPE STRING,
CALC_MONTH_END TYPE STRING,
CALC_INCLUSIV TYPE STRING,
CALC_CALENDAR_RULE TYPE STRING,
CALC_DETERMINE_METHOD TYPE STRING,
CALC_DATE_RELATED TYPE STRING,
DUE_DATE TYPE STRING,
DUE_MONTH_END TYPE STRING,
DUE_INCLUSIV TYPE STRING,
DUE_CALENDAR_RULE TYPE STRING,
DUE_DATE_RELATED TYPE STRING,
DUE_DETERMINE_METHOD TYPE STRING,
FREQUENCY_MONTH TYPE STRING,
CALENDAR TYPE STRING,
FORMULAR_REFERENCE TYPE STRING,
FORMULAR_REF TYPE STRING,
VARIABLE_NAME TYPE STRING,
VARIABLE_VALUE TYPE STRING,
REF_INTEREST_RATE TYPE STRING,
PFLUCT TYPE STRING,
RIGHTTYPE TYPE STRING,
PRICE TYPE STRING,
CURRENCY1 TYPE STRING,
CURRENCY1_ISO TYPE STRING,
BASICRATE TYPE STRING,
RANL TYPE STRING,
STARTDATE TYPE STRING,
ENDDATE TYPE STRING,
RANLNEW TYPE STRING,
SETTLEMENTPAYMENT TYPE STRING,
SETTLEMENTPAYMENT_CURRENCY TYPE STRING,
SETTLEMENTPAYMENT_CUR_ISO TYPE STRING,
RATIONUMERATOR TYPE STRING,
RATIODENOMINATOR TYPE STRING,
RERF TYPE STRING,
DERF TYPE STRING,
TERF TYPE STRING,
REHER TYPE STRING,
RBEAR TYPE STRING,
DBEAR TYPE STRING,
TBEAR TYPE STRING,
RBHER TYPE STRING,
SUB_PRICE TYPE STRING,
SUB_CURRENCY TYPE STRING,
SUB_CURRENCY_ISO TYPE STRING,
SUB_NUMERATOR TYPE STRING,
SUB_DENOMINATOR TYPE STRING,
SUB_PERIOD_FROM TYPE STRING,
SUB_PERIOD_UNTIL TYPE STRING,
SUB_TRADING_FROM TYPE STRING,
SUB_TRADING_UNTIL TYPE STRING,
PRICE_REF_SHARE TYPE STRING,
DIVIDEND_ADV_DIS TYPE STRING,
RANLUNDERLYING TYPE STRING,
SUBSCRIPTIONRATE TYPE STRING,
REFERENCEUNIT TYPE STRING,
REFERENCE_CURR TYPE STRING,
REFERENCE_CURR_ISO TYPE STRING,
SHORTTEXT TYPE STRING,
INPAYMENT_RATE TYPE STRING,
PAYMENT_AMOUNT TYPE STRING,
NUMBER_OF_SHARES TYPE STRING,
CAPITAL_PR_SHARE TYPE STRING,
VOTES_PER_SHARE TYPE STRING,
EXTRA_CAPITAL TYPE STRING,
AGGREGATION_KEY TYPE STRING,
SHORT_TEXT TYPE STRING,
LONG_TEXT TYPE STRING,
PRODUCT_TYPE TYPE STRING,
LISTED TYPE STRING,
QUOTATION TYPE STRING,
ISSUER TYPE STRING,
ISSUE_CURRENCY TYPE STRING,
ISSUE_CURRENCY_ISO TYPE STRING,
ISSUE_PRICE TYPE STRING,
ISSUE_RATE TYPE STRING,
SSTBE TYPE STRING,
OPTION_CATEGORY TYPE STRING,
TERM_FROM TYPE STRING,
TERM_UPTO TYPE STRING,
EXERCISE_TYPE TYPE STRING,
EXERCISE_MIN TYPE STRING,
NUMERATOR TYPE STRING,
SETTLEMENT TYPE STRING,
BASIC_RATE TYPE STRING,
REFERENCE_UNITS TYPE STRING,
REFERENCE_CURRENCY TYPE STRING,
REFERENCE_CURRENCY_ISO TYPE STRING,
SECURITY_CATEGORY TYPE STRING,
ELIGIBLE_TO_SERVE TYPE STRING,
UNDERLYING TYPE STRING,
DENOMINATOR TYPE STRING,
EXERCISE_PRICE TYPE STRING,
EXERCISE_CURRENCY TYPE STRING,
EXERCISE_CURRENCY_ISO TYPE STRING,
SECURITY_INDEX TYPE STRING,
INDEX_MARK TYPE STRING,
INDEX_BASE TYPE STRING,
INDEX_CURRENCY TYPE STRING,
INDEX_CURRENCY_ISO TYPE STRING,
SECURITY_TYPE TYPE STRING,
NOMINAL_VALUE TYPE STRING,
TRADING_UNIT TYPE STRING,
ISSUER_CALL TYPE STRING,
ELIGIBLE TYPE STRING,
ELIGIBLE_AS_COLL TYPE STRING,
SECONDARY_LOANS TYPE STRING,
FINAL_DUE_DATE TYPE STRING,
INCLUSIVE_INDICATOR TYPE STRING,
ISSUE_YIELD TYPE STRING,
YIELD_METHOD TYPE STRING,
YIELD_FREQUENCY TYPE STRING,
REPAYMENT_TYPE TYPE STRING,
DISCOUNTED TYPE STRING,
OBLIGATION_TO_OFFER TYPE STRING,
RIGHT_TO_OFFER TYPE STRING,
DRAWING TYPE STRING,
DRAWING_DATE TYPE STRING,
ISSUE_START TYPE STRING,
CLASSIFICATION TYPE STRING,
BONDHOLDER_CALL TYPE STRING,
CUTTING_DAYS TYPE STRING,
CONV_PERIOD_FROM TYPE STRING,
CONV_PERIOD_TO TYPE STRING,
CONV_RATIO_NOMINATOR TYPE STRING,
CONV_RATIO_DENOMINATOR TYPE STRING,
CONV_PREMIUM TYPE STRING,
CURRENCY_MARKUP TYPE STRING,
CURRENCY_MARKUP_ISO TYPE STRING,
CUM_EX_INDICATOR TYPE STRING,
NUMBER_OF_WARRANTS TYPE STRING,
UNDERLYING2 TYPE STRING,
FELLOW_PARTNER TYPE STRING,
STOCK_CATEGORY TYPE STRING,
STOCK_FORM TYPE STRING,
SHAREHOLDING_TYPE TYPE STRING,
SHAREHOLDING_STRUCT TYPE STRING,
SHARES_OUTSTANDING TYPE STRING,
BALANCE_DATE TYPE STRING,
DIVIDEND_RIGHTS TYPE STRING,
ENTITLED_FROM TYPE STRING,
EXCHANGE_FROM TYPE STRING,
EXCHANGE_TO TYPE STRING,
EXCHANGE_NUMERATOR TYPE STRING,
EXCHANGE_DENOMINATOR TYPE STRING,
CLEARING_AMOUNT TYPE STRING,
CLEARING_CURRENCY TYPE STRING,
CLEARING_CURRENCY_ISO TYPE STRING,
TRADING_UNTIL TYPE STRING,
CONDITION_VALID_FROM TYPE STRING,
FUND_TYPE TYPE STRING,
FUND_CATEGORY TYPE STRING,
FUND_VOLUME TYPE STRING,
PUBLIC_FUND TYPE STRING,
ISSUE_PREMIUM TYPE STRING,
FOREIGN_INVESTMENT_LAW TYPE STRING,
ACCUMULATION TYPE STRING,
REINVESTMENT_DISCOUNT TYPE STRING,
COUPON_NUMBER TYPE STRING,
FACTORY_CALENDAR TYPE STRING,
OPT_FUT_CATEGORY TYPE STRING,
OPT_FUT_QUOTATION TYPE STRING,
MARGIN_TYPE TYPE STRING,
TICK_IN_PERCENT TYPE STRING,
TICK_AMOUNT TYPE STRING,
TICK_IN_POINTS TYPE STRING,
TICK_VALUE TYPE STRING,
TICK_CURRENCY TYPE STRING,
TICK_CURRENCY_ISO TYPE STRING,
LAST_TRADING_DAY TYPE STRING,
SETTLEMENT_DAY TYPE STRING,
EXPIRY_DATE TYPE STRING,
INDEX_POINT_VALUE TYPE STRING,
INDEX_P_CURRENCY TYPE STRING,
INDEX_P_CURRENCY_ISO TYPE STRING,
SETTLEMENT_METHOD TYPE STRING,
PUT_CALL_INDICATOR TYPE STRING,
SETTLEMENT_OPT TYPE STRING,
EXERCISE_TYPE_OPT TYPE STRING,
NUMBER_OF_UNITS TYPE STRING,
SECURITY_REFERENCE TYPE STRING,
STRIKE_AMOUNT TYPE STRING,
STRIKE_CURRENCY TYPE STRING,
STRIKE_CURRENCY_ISO TYPE STRING,
STRIKE_IN_PERCENT TYPE STRING,
STRIKE_IN_POINTS TYPE STRING,
NOMINAL_VALUE_F TYPE STRING,
NOMINAL_CURRENCY TYPE STRING,
NOMINAL_CURRENCY_ISO TYPE STRING,
INTEREST_CALC_F TYPE STRING,
FINAL_DUE_DATE_F TYPE STRING,
RATING TYPE STRING,
INSTITUTE TYPE STRING,
PRICE_INDEX TYPE STRING,
SET_NAME TYPE STRING,
SMOVERW TYPE STRING,
SDEPOSTAT TYPE STRING,
SWPHGMPF TYPE STRING,
FUNDED TYPE STRING,
BPEXT TYPE STRING,
PRODUCT_CATEGORY TYPE STRING,
ORG_INDEX TYPE STRING,END OF T_EKKO_STR.
DATA: WA_JBIUPCDFP_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_JBIUPCDFP_STR-SET_TYPE sy-vline 
WA_JBIUPCDFP_STR-MODE sy-vline 
WA_JBIUPCDFP_STR-TYPE sy-vline 
WA_JBIUPCDFP_STR-SECURITY_NUMBER sy-vline 
WA_JBIUPCDFP_STR-CATEGORY sy-vline 
WA_JBIUPCDFP_STR-STOCK_EXCHANGE sy-vline 
WA_JBIUPCDFP_STR-CURRENCY sy-vline 
WA_JBIUPCDFP_STR-CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-FLAT_PRICE sy-vline 
WA_JBIUPCDFP_STR-HOME_EXCHANGE sy-vline 
WA_JBIUPCDFP_STR-LISTING_KEY sy-vline 
WA_JBIUPCDFP_STR-INDEX_NUMBER sy-vline 
WA_JBIUPCDFP_STR-INDEX_NAME sy-vline 
WA_JBIUPCDFP_STR-CONDITION_TYPE sy-vline 
WA_JBIUPCDFP_STR-VALID_FROM sy-vline 
WA_JBIUPCDFP_STR-CONDITION_FORM sy-vline 
WA_JBIUPCDFP_STR-AMOUNT sy-vline 
WA_JBIUPCDFP_STR-REF_SIGN sy-vline 
WA_JBIUPCDFP_STR-PERCENTAGE_RATE sy-vline 
WA_JBIUPCDFP_STR-INTEREST_CALC_METHOD sy-vline 
WA_JBIUPCDFP_STR-CALC_DATE sy-vline 
WA_JBIUPCDFP_STR-CALC_MONTH_END sy-vline 
WA_JBIUPCDFP_STR-CALC_INCLUSIV sy-vline 
WA_JBIUPCDFP_STR-CALC_CALENDAR_RULE sy-vline 
WA_JBIUPCDFP_STR-CALC_DETERMINE_METHOD sy-vline 
WA_JBIUPCDFP_STR-CALC_DATE_RELATED sy-vline 
WA_JBIUPCDFP_STR-DUE_DATE sy-vline 
WA_JBIUPCDFP_STR-DUE_MONTH_END sy-vline 
WA_JBIUPCDFP_STR-DUE_INCLUSIV sy-vline 
WA_JBIUPCDFP_STR-DUE_CALENDAR_RULE sy-vline 
WA_JBIUPCDFP_STR-DUE_DATE_RELATED sy-vline 
WA_JBIUPCDFP_STR-DUE_DETERMINE_METHOD sy-vline 
WA_JBIUPCDFP_STR-FREQUENCY_MONTH sy-vline 
WA_JBIUPCDFP_STR-CALENDAR sy-vline 
WA_JBIUPCDFP_STR-FORMULAR_REFERENCE sy-vline 
WA_JBIUPCDFP_STR-FORMULAR_REF sy-vline 
WA_JBIUPCDFP_STR-VARIABLE_NAME sy-vline 
WA_JBIUPCDFP_STR-VARIABLE_VALUE sy-vline 
WA_JBIUPCDFP_STR-REF_INTEREST_RATE sy-vline 
WA_JBIUPCDFP_STR-PFLUCT sy-vline 
WA_JBIUPCDFP_STR-RIGHTTYPE sy-vline 
WA_JBIUPCDFP_STR-PRICE sy-vline 
WA_JBIUPCDFP_STR-CURRENCY1 sy-vline 
WA_JBIUPCDFP_STR-CURRENCY1_ISO sy-vline 
WA_JBIUPCDFP_STR-BASICRATE sy-vline 
WA_JBIUPCDFP_STR-RANL sy-vline 
WA_JBIUPCDFP_STR-STARTDATE sy-vline 
WA_JBIUPCDFP_STR-ENDDATE sy-vline 
WA_JBIUPCDFP_STR-RANLNEW sy-vline 
WA_JBIUPCDFP_STR-SETTLEMENTPAYMENT sy-vline 
WA_JBIUPCDFP_STR-SETTLEMENTPAYMENT_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-SETTLEMENTPAYMENT_CUR_ISO sy-vline 
WA_JBIUPCDFP_STR-RATIONUMERATOR sy-vline 
WA_JBIUPCDFP_STR-RATIODENOMINATOR sy-vline 
WA_JBIUPCDFP_STR-RERF sy-vline 
WA_JBIUPCDFP_STR-DERF sy-vline 
WA_JBIUPCDFP_STR-TERF sy-vline 
WA_JBIUPCDFP_STR-REHER sy-vline 
WA_JBIUPCDFP_STR-RBEAR sy-vline 
WA_JBIUPCDFP_STR-DBEAR sy-vline 
WA_JBIUPCDFP_STR-TBEAR sy-vline 
WA_JBIUPCDFP_STR-RBHER sy-vline 
WA_JBIUPCDFP_STR-SUB_PRICE sy-vline 
WA_JBIUPCDFP_STR-SUB_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-SUB_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-SUB_NUMERATOR sy-vline 
WA_JBIUPCDFP_STR-SUB_DENOMINATOR sy-vline 
WA_JBIUPCDFP_STR-SUB_PERIOD_FROM sy-vline 
WA_JBIUPCDFP_STR-SUB_PERIOD_UNTIL sy-vline 
WA_JBIUPCDFP_STR-SUB_TRADING_FROM sy-vline 
WA_JBIUPCDFP_STR-SUB_TRADING_UNTIL sy-vline 
WA_JBIUPCDFP_STR-PRICE_REF_SHARE sy-vline 
WA_JBIUPCDFP_STR-DIVIDEND_ADV_DIS sy-vline 
WA_JBIUPCDFP_STR-RANLUNDERLYING sy-vline 
WA_JBIUPCDFP_STR-SUBSCRIPTIONRATE sy-vline 
WA_JBIUPCDFP_STR-REFERENCEUNIT sy-vline 
WA_JBIUPCDFP_STR-REFERENCE_CURR sy-vline 
WA_JBIUPCDFP_STR-REFERENCE_CURR_ISO sy-vline 
WA_JBIUPCDFP_STR-SHORTTEXT sy-vline 
WA_JBIUPCDFP_STR-INPAYMENT_RATE sy-vline 
WA_JBIUPCDFP_STR-PAYMENT_AMOUNT sy-vline 
WA_JBIUPCDFP_STR-NUMBER_OF_SHARES sy-vline 
WA_JBIUPCDFP_STR-CAPITAL_PR_SHARE sy-vline 
WA_JBIUPCDFP_STR-VOTES_PER_SHARE sy-vline 
WA_JBIUPCDFP_STR-EXTRA_CAPITAL sy-vline 
WA_JBIUPCDFP_STR-AGGREGATION_KEY sy-vline 
WA_JBIUPCDFP_STR-SHORT_TEXT sy-vline 
WA_JBIUPCDFP_STR-LONG_TEXT sy-vline 
WA_JBIUPCDFP_STR-PRODUCT_TYPE sy-vline 
WA_JBIUPCDFP_STR-LISTED sy-vline 
WA_JBIUPCDFP_STR-QUOTATION sy-vline 
WA_JBIUPCDFP_STR-ISSUER sy-vline 
WA_JBIUPCDFP_STR-ISSUE_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-ISSUE_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-ISSUE_PRICE sy-vline 
WA_JBIUPCDFP_STR-ISSUE_RATE sy-vline 
WA_JBIUPCDFP_STR-SSTBE sy-vline 
WA_JBIUPCDFP_STR-OPTION_CATEGORY sy-vline 
WA_JBIUPCDFP_STR-TERM_FROM sy-vline 
WA_JBIUPCDFP_STR-TERM_UPTO sy-vline 
WA_JBIUPCDFP_STR-EXERCISE_TYPE sy-vline 
WA_JBIUPCDFP_STR-EXERCISE_MIN sy-vline 
WA_JBIUPCDFP_STR-NUMERATOR sy-vline 
WA_JBIUPCDFP_STR-SETTLEMENT sy-vline 
WA_JBIUPCDFP_STR-BASIC_RATE sy-vline 
WA_JBIUPCDFP_STR-REFERENCE_UNITS sy-vline 
WA_JBIUPCDFP_STR-REFERENCE_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-REFERENCE_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-SECURITY_CATEGORY sy-vline 
WA_JBIUPCDFP_STR-ELIGIBLE_TO_SERVE sy-vline 
WA_JBIUPCDFP_STR-UNDERLYING sy-vline 
WA_JBIUPCDFP_STR-DENOMINATOR sy-vline 
WA_JBIUPCDFP_STR-EXERCISE_PRICE sy-vline 
WA_JBIUPCDFP_STR-EXERCISE_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-EXERCISE_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-SECURITY_INDEX sy-vline 
WA_JBIUPCDFP_STR-INDEX_MARK sy-vline 
WA_JBIUPCDFP_STR-INDEX_BASE sy-vline 
WA_JBIUPCDFP_STR-INDEX_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-INDEX_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-SECURITY_TYPE sy-vline 
WA_JBIUPCDFP_STR-NOMINAL_VALUE sy-vline 
WA_JBIUPCDFP_STR-TRADING_UNIT sy-vline 
WA_JBIUPCDFP_STR-ISSUER_CALL sy-vline 
WA_JBIUPCDFP_STR-ELIGIBLE sy-vline 
WA_JBIUPCDFP_STR-ELIGIBLE_AS_COLL sy-vline 
WA_JBIUPCDFP_STR-SECONDARY_LOANS sy-vline 
WA_JBIUPCDFP_STR-FINAL_DUE_DATE sy-vline 
WA_JBIUPCDFP_STR-INCLUSIVE_INDICATOR sy-vline 
WA_JBIUPCDFP_STR-ISSUE_YIELD sy-vline 
WA_JBIUPCDFP_STR-YIELD_METHOD sy-vline 
WA_JBIUPCDFP_STR-YIELD_FREQUENCY sy-vline 
WA_JBIUPCDFP_STR-REPAYMENT_TYPE sy-vline 
WA_JBIUPCDFP_STR-DISCOUNTED sy-vline 
WA_JBIUPCDFP_STR-OBLIGATION_TO_OFFER sy-vline 
WA_JBIUPCDFP_STR-RIGHT_TO_OFFER sy-vline 
WA_JBIUPCDFP_STR-DRAWING sy-vline 
WA_JBIUPCDFP_STR-DRAWING_DATE sy-vline 
WA_JBIUPCDFP_STR-ISSUE_START sy-vline 
WA_JBIUPCDFP_STR-CLASSIFICATION sy-vline 
WA_JBIUPCDFP_STR-BONDHOLDER_CALL sy-vline 
WA_JBIUPCDFP_STR-CUTTING_DAYS sy-vline 
WA_JBIUPCDFP_STR-CONV_PERIOD_FROM sy-vline 
WA_JBIUPCDFP_STR-CONV_PERIOD_TO sy-vline 
WA_JBIUPCDFP_STR-CONV_RATIO_NOMINATOR sy-vline 
WA_JBIUPCDFP_STR-CONV_RATIO_DENOMINATOR sy-vline 
WA_JBIUPCDFP_STR-CONV_PREMIUM sy-vline 
WA_JBIUPCDFP_STR-CURRENCY_MARKUP sy-vline 
WA_JBIUPCDFP_STR-CURRENCY_MARKUP_ISO sy-vline 
WA_JBIUPCDFP_STR-CUM_EX_INDICATOR sy-vline 
WA_JBIUPCDFP_STR-NUMBER_OF_WARRANTS sy-vline 
WA_JBIUPCDFP_STR-UNDERLYING2 sy-vline 
WA_JBIUPCDFP_STR-FELLOW_PARTNER sy-vline 
WA_JBIUPCDFP_STR-STOCK_CATEGORY sy-vline 
WA_JBIUPCDFP_STR-STOCK_FORM sy-vline 
WA_JBIUPCDFP_STR-SHAREHOLDING_TYPE sy-vline 
WA_JBIUPCDFP_STR-SHAREHOLDING_STRUCT sy-vline 
WA_JBIUPCDFP_STR-SHARES_OUTSTANDING sy-vline 
WA_JBIUPCDFP_STR-BALANCE_DATE sy-vline 
WA_JBIUPCDFP_STR-DIVIDEND_RIGHTS sy-vline 
WA_JBIUPCDFP_STR-ENTITLED_FROM sy-vline 
WA_JBIUPCDFP_STR-EXCHANGE_FROM sy-vline 
WA_JBIUPCDFP_STR-EXCHANGE_TO sy-vline 
WA_JBIUPCDFP_STR-EXCHANGE_NUMERATOR sy-vline 
WA_JBIUPCDFP_STR-EXCHANGE_DENOMINATOR sy-vline 
WA_JBIUPCDFP_STR-CLEARING_AMOUNT sy-vline 
WA_JBIUPCDFP_STR-CLEARING_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-CLEARING_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-TRADING_UNTIL sy-vline 
WA_JBIUPCDFP_STR-CONDITION_VALID_FROM sy-vline 
WA_JBIUPCDFP_STR-FUND_TYPE sy-vline 
WA_JBIUPCDFP_STR-FUND_CATEGORY sy-vline 
WA_JBIUPCDFP_STR-FUND_VOLUME sy-vline 
WA_JBIUPCDFP_STR-PUBLIC_FUND sy-vline 
WA_JBIUPCDFP_STR-ISSUE_PREMIUM sy-vline 
WA_JBIUPCDFP_STR-FOREIGN_INVESTMENT_LAW sy-vline 
WA_JBIUPCDFP_STR-ACCUMULATION sy-vline 
WA_JBIUPCDFP_STR-REINVESTMENT_DISCOUNT sy-vline 
WA_JBIUPCDFP_STR-COUPON_NUMBER sy-vline 
WA_JBIUPCDFP_STR-FACTORY_CALENDAR sy-vline 
WA_JBIUPCDFP_STR-OPT_FUT_CATEGORY sy-vline 
WA_JBIUPCDFP_STR-OPT_FUT_QUOTATION sy-vline 
WA_JBIUPCDFP_STR-MARGIN_TYPE sy-vline 
WA_JBIUPCDFP_STR-TICK_IN_PERCENT sy-vline 
WA_JBIUPCDFP_STR-TICK_AMOUNT sy-vline 
WA_JBIUPCDFP_STR-TICK_IN_POINTS sy-vline 
WA_JBIUPCDFP_STR-TICK_VALUE sy-vline 
WA_JBIUPCDFP_STR-TICK_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-TICK_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-LAST_TRADING_DAY sy-vline 
WA_JBIUPCDFP_STR-SETTLEMENT_DAY sy-vline 
WA_JBIUPCDFP_STR-EXPIRY_DATE sy-vline 
WA_JBIUPCDFP_STR-INDEX_POINT_VALUE sy-vline 
WA_JBIUPCDFP_STR-INDEX_P_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-INDEX_P_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-SETTLEMENT_METHOD sy-vline 
WA_JBIUPCDFP_STR-PUT_CALL_INDICATOR sy-vline 
WA_JBIUPCDFP_STR-SETTLEMENT_OPT sy-vline 
WA_JBIUPCDFP_STR-EXERCISE_TYPE_OPT sy-vline 
WA_JBIUPCDFP_STR-NUMBER_OF_UNITS sy-vline 
WA_JBIUPCDFP_STR-SECURITY_REFERENCE sy-vline 
WA_JBIUPCDFP_STR-STRIKE_AMOUNT sy-vline 
WA_JBIUPCDFP_STR-STRIKE_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-STRIKE_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-STRIKE_IN_PERCENT sy-vline 
WA_JBIUPCDFP_STR-STRIKE_IN_POINTS sy-vline 
WA_JBIUPCDFP_STR-NOMINAL_VALUE_F sy-vline 
WA_JBIUPCDFP_STR-NOMINAL_CURRENCY sy-vline 
WA_JBIUPCDFP_STR-NOMINAL_CURRENCY_ISO sy-vline 
WA_JBIUPCDFP_STR-INTEREST_CALC_F sy-vline 
WA_JBIUPCDFP_STR-FINAL_DUE_DATE_F sy-vline 
WA_JBIUPCDFP_STR-RATING sy-vline 
WA_JBIUPCDFP_STR-INSTITUTE sy-vline 
WA_JBIUPCDFP_STR-PRICE_INDEX sy-vline 
WA_JBIUPCDFP_STR-SET_NAME sy-vline 
WA_JBIUPCDFP_STR-SMOVERW sy-vline 
WA_JBIUPCDFP_STR-SDEPOSTAT sy-vline 
WA_JBIUPCDFP_STR-SWPHGMPF sy-vline 
WA_JBIUPCDFP_STR-FUNDED sy-vline 
WA_JBIUPCDFP_STR-BPEXT sy-vline 
WA_JBIUPCDFP_STR-PRODUCT_CATEGORY sy-vline 
WA_JBIUPCDFP_STR-ORG_INDEX sy-vline      INTO ld_text SEPARATED BY SPACE.

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