ABAP Select data from SAP table CADBTRIALBAL 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 CADBTRIALBAL 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 CADBTRIALBAL. 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 CADBTRIALBAL 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_CADBTRIALBAL TYPE STANDARD TABLE OF CADBTRIALBAL,
      WA_CADBTRIALBAL TYPE CADBTRIALBAL,
      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: <CADBTRIALBAL> TYPE CADBTRIALBAL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CADBTRIALBAL
*  INTO TABLE @DATA(IT_CADBTRIALBAL2).
*--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_CADBTRIALBAL INDEX 1 INTO DATA(WA_CADBTRIALBAL2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CADBTRIALBAL>-MANDT = 1.
<CADBTRIALBAL>-LEDGER = 1.
<CADBTRIALBAL>-COMPANYCODE = 1.
<CADBTRIALBAL>-COMPANYCODENAME = 1.
<CADBTRIALBAL>-GLACCOUNT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CADBTRIALBAL-GLACCOUNTNAME, sy-vline,
  WA_CADBTRIALBAL-POSTINGDATE, sy-vline,
  WA_CADBTRIALBAL-FISCALYEAR, sy-vline,
  WA_CADBTRIALBAL-LEDGERFISCALYEAR, sy-vline,
  WA_CADBTRIALBAL-FLOWOFFUNDSLEDGERFISCALYEAR, sy-vline,
  WA_CADBTRIALBAL-PROFITCENTER, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CADBTRIALBAL 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_CADBTRIALBAL 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_CADBTRIALBAL INTO WA_CADBTRIALBAL.


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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field PARTNERSEGMENT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CADBTRIALBAL-PARTNERSEGMENT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CADBTRIALBAL-PARTNERSEGMENT.
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_CADBTRIALBAL_STR, 
MANDT TYPE STRING,
LEDGER TYPE STRING,
COMPANYCODE TYPE STRING,
COMPANYCODENAME TYPE STRING,
GLACCOUNT TYPE STRING,
GLACCOUNTNAME TYPE STRING,
POSTINGDATE TYPE STRING,
FISCALYEAR TYPE STRING,
LEDGERFISCALYEAR TYPE STRING,
FLOWOFFUNDSLEDGERFISCALYEAR TYPE STRING,
PROFITCENTER TYPE STRING,
PROFITCENTERNAME TYPE STRING,
FUNCTIONALAREA TYPE STRING,
FUNCTIONALAREANAME TYPE STRING,
CONTROLLINGAREA TYPE STRING,
SEGMENT TYPE STRING,
SEGMENTNAME TYPE STRING,
COSTCENTER TYPE STRING,
COSTCENTERNAME TYPE STRING,
PARTNERPROFITCENTER TYPE STRING,
PARTNERPROFITCENTERNAME TYPE STRING,
PARTNERFUNCTIONALAREA TYPE STRING,
PARTNERFUNCTIONALAREANAME TYPE STRING,
PARTNERCOMPANY TYPE STRING,
PARTNERSEGMENT TYPE STRING,
FISCALYEARVARIANT TYPE STRING,
CHARTOFACCOUNTS TYPE STRING,
BALANCETRANSACTIONCURRENCY TYPE STRING,
AMOUNTINBALANCETRANSACCRCY TYPE STRING,
PRIORDAYBALINBALTRANSCRCY TYPE STRING,
CURDAYACTYAMTINBALTRANSCRCY TYPE STRING,
PRIORMONTHBALINBALTRANSCRCY TYPE STRING,
CURMONTHACTYAMTINBALTRANSCRCY TYPE STRING,
YTDBALINBALTRANSCRCY TYPE STRING,
MTDAVGDAILYBALINBALTRANSCRCY TYPE STRING,
QTDAVGDAILYBALINBALTRANSCRCY TYPE STRING,
YTDAVGDAILYBALINBALTRANSCRCY TYPE STRING,
MTDAVGACTYAMTINBALTRANSCRCY TYPE STRING,
QTDACTYAMTINBALTRANSCRCY TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
AMOUNTINCOMPANYCODECURRENCY TYPE STRING,
PRIORDAYBALINCCCRCY TYPE STRING,
CURDAYACTYAMTINCCCRCY TYPE STRING,
PRIORMONTHBALINCCCRCY TYPE STRING,
CURMONTHACTYAMTINCCCRCY TYPE STRING,
YTDBALINCCCRCY TYPE STRING,
MTDAVGDAILYBALINCCCRCY TYPE STRING,
QTDAVGDAILYBALINCCCRCY TYPE STRING,
YTDAVGDAILYBALINCCCRCY TYPE STRING,
MTDAVGACTYAMTINCCCRCY TYPE STRING,
QTDACTYAMTINCCCRCY TYPE STRING,
GLOBALCURRENCY TYPE STRING,
AMOUNTINGLOBALCURRENCY TYPE STRING,
PRIORDAYBALINGLOBCRCY TYPE STRING,
CURDAYACTYAMTINGLOBCRCY TYPE STRING,
PRIORMONTHBALINGLOBCRCY TYPE STRING,
CURMONTHACTYAMTINGLOBCRCY TYPE STRING,
YTDBALINGLOBCRCY TYPE STRING,
MTDAVGDAILYBALINGLOBCRCY TYPE STRING,
QTDAVGDAILYBALINGLOBCRCY TYPE STRING,
YTDAVGDAILYBALINGLOBCRCY TYPE STRING,
MTDAVGACTYAMTINGLOBCRCY TYPE STRING,
QTDACTYAMTINGLOBCRCY TYPE STRING,
FREEDEFINEDCURRENCY1 TYPE STRING,
AMOUNTINFREEDEFINEDCURRENCY1 TYPE STRING,
PRIORDAYBALINFDCRCY1 TYPE STRING,
CURDAYACTYAMTINFDCRCY1 TYPE STRING,
PRIORMONTHBALINFDCRCY1 TYPE STRING,
CURMONTHACTYAMTINFDCRCY1 TYPE STRING,
YTDBALINFDCRCY1 TYPE STRING,
MTDAVGDAILYBALINFDCRCY1 TYPE STRING,
QTDAVGDAILYBALINFDCRCY1 TYPE STRING,
YTDAVGDAILYBALINFDCRCY1 TYPE STRING,
MTDAVGACTYAMTINFDCRCY1 TYPE STRING,
QTDACTYAMTINFDCRCY1 TYPE STRING,
FREEDEFINEDCURRENCY2 TYPE STRING,
AMOUNTINFREEDEFINEDCURRENCY2 TYPE STRING,
PRIORDAYBALINFDCRCY2 TYPE STRING,
CURDAYACTYAMTINFDCRCY2 TYPE STRING,
PRIORMONTHBALINFDCRCY2 TYPE STRING,
CURMONTHACTYAMTINFDCRCY2 TYPE STRING,
YTDBALINFDCRCY2 TYPE STRING,
MTDAVGDAILYBALINFDCRCY2 TYPE STRING,
QTDAVGDAILYBALINFDCRCY2 TYPE STRING,
YTDAVGDAILYBALINFDCRCY2 TYPE STRING,
MTDAVGACTYAMTINFDCRCY2 TYPE STRING,
QTDACTYAMTINFDCRCY2 TYPE STRING,
FREEDEFINEDCURRENCY3 TYPE STRING,
AMOUNTINFREEDEFINEDCURRENCY3 TYPE STRING,
PRIORDAYBALINFDCRCY3 TYPE STRING,
CURDAYACTYAMTINFDCRCY3 TYPE STRING,
PRIORMONTHBALINFDCRCY3 TYPE STRING,
CURMONTHACTYAMTINFDCRCY3 TYPE STRING,
YTDBALINFDCRCY3 TYPE STRING,
MTDAVGDAILYBALINFDCRCY3 TYPE STRING,
QTDAVGDAILYBALINFDCRCY3 TYPE STRING,
YTDAVGDAILYBALINFDCRCY3 TYPE STRING,
MTDAVGACTYAMTINFDCRCY3 TYPE STRING,
QTDACTYAMTINFDCRCY3 TYPE STRING,
FREEDEFINEDCURRENCY4 TYPE STRING,
AMOUNTINFREEDEFINEDCURRENCY4 TYPE STRING,
PRIORDAYBALINFDCRCY4 TYPE STRING,
CURDAYACTYAMTINFDCRCY4 TYPE STRING,
PRIORMONTHBALINFDCRCY4 TYPE STRING,
CURMONTHACTYAMTINFDCRCY4 TYPE STRING,
YTDBALINFDCRCY4 TYPE STRING,
MTDAVGDAILYBALINFDCRCY4 TYPE STRING,
QTDAVGDAILYBALINFDCRCY4 TYPE STRING,
YTDAVGDAILYBALINFDCRCY4 TYPE STRING,
MTDAVGACTYAMTINFDCRCY4 TYPE STRING,
QTDACTYAMTINFDCRCY4 TYPE STRING,
FREEDEFINEDCURRENCY5 TYPE STRING,
AMOUNTINFREEDEFINEDCURRENCY5 TYPE STRING,
PRIORDAYBALINFDCRCY5 TYPE STRING,
CURDAYACTYAMTINFDCRCY5 TYPE STRING,
PRIORMONTHBALINFDCRCY5 TYPE STRING,
CURMONTHACTYAMTINFDCRCY5 TYPE STRING,
YTDBALINFDCRCY5 TYPE STRING,
MTDAVGDAILYBALINFDCRCY5 TYPE STRING,
QTDAVGDAILYBALINFDCRCY5 TYPE STRING,
YTDAVGDAILYBALINFDCRCY5 TYPE STRING,
MTDAVGACTYAMTINFDCRCY5 TYPE STRING,
QTDACTYAMTINFDCRCY5 TYPE STRING,
FREEDEFINEDCURRENCY6 TYPE STRING,
AMOUNTINFREEDEFINEDCURRENCY6 TYPE STRING,
PRIORDAYBALINFDCRCY6 TYPE STRING,
CURDAYACTYAMTINFDCRCY6 TYPE STRING,
PRIORMONTHBALINFDCRCY6 TYPE STRING,
CURMONTHACTYAMTINFDCRCY6 TYPE STRING,
YTDBALINFDCRCY6 TYPE STRING,
MTDAVGDAILYBALINFDCRCY6 TYPE STRING,
QTDAVGDAILYBALINFDCRCY6 TYPE STRING,
YTDAVGDAILYBALINFDCRCY6 TYPE STRING,
MTDAVGACTYAMTINFDCRCY6 TYPE STRING,
QTDACTYAMTINFDCRCY6 TYPE STRING,
FREEDEFINEDCURRENCY7 TYPE STRING,
AMOUNTINFREEDEFINEDCURRENCY7 TYPE STRING,
PRIORDAYBALINFDCRCY7 TYPE STRING,
CURDAYACTYAMTINFDCRCY7 TYPE STRING,
PRIORMONTHBALINFDCRCY7 TYPE STRING,
CURMONTHACTYAMTINFDCRCY7 TYPE STRING,
YTDBALINFDCRCY7 TYPE STRING,
MTDAVGDAILYBALINFDCRCY7 TYPE STRING,
QTDAVGDAILYBALINFDCRCY7 TYPE STRING,
YTDAVGDAILYBALINFDCRCY7 TYPE STRING,
MTDAVGACTYAMTINFDCRCY7 TYPE STRING,
QTDACTYAMTINFDCRCY7 TYPE STRING,
FREEDEFINEDCURRENCY8 TYPE STRING,
AMOUNTINFREEDEFINEDCURRENCY8 TYPE STRING,
PRIORDAYBALINFDCRCY8 TYPE STRING,
CURDAYACTYAMTINFDCRCY8 TYPE STRING,
PRIORMONTHBALINFDCRCY8 TYPE STRING,
CURMONTHACTYAMTINFDCRCY8 TYPE STRING,
YTDBALINFDCRCY8 TYPE STRING,
MTDAVGDAILYBALINFDCRCY8 TYPE STRING,
QTDAVGDAILYBALINFDCRCY8 TYPE STRING,
YTDAVGDAILYBALINFDCRCY8 TYPE STRING,
MTDAVGACTYAMTINFDCRCY8 TYPE STRING,
QTDACTYAMTINFDCRCY8 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CADBTRIALBAL_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_CADBTRIALBAL_STR-MANDT sy-vline 
WA_CADBTRIALBAL_STR-LEDGER sy-vline 
WA_CADBTRIALBAL_STR-COMPANYCODE sy-vline 
WA_CADBTRIALBAL_STR-COMPANYCODENAME sy-vline 
WA_CADBTRIALBAL_STR-GLACCOUNT sy-vline 
WA_CADBTRIALBAL_STR-GLACCOUNTNAME sy-vline 
WA_CADBTRIALBAL_STR-POSTINGDATE sy-vline 
WA_CADBTRIALBAL_STR-FISCALYEAR sy-vline 
WA_CADBTRIALBAL_STR-LEDGERFISCALYEAR sy-vline 
WA_CADBTRIALBAL_STR-FLOWOFFUNDSLEDGERFISCALYEAR sy-vline 
WA_CADBTRIALBAL_STR-PROFITCENTER sy-vline 
WA_CADBTRIALBAL_STR-PROFITCENTERNAME sy-vline 
WA_CADBTRIALBAL_STR-FUNCTIONALAREA sy-vline 
WA_CADBTRIALBAL_STR-FUNCTIONALAREANAME sy-vline 
WA_CADBTRIALBAL_STR-CONTROLLINGAREA sy-vline 
WA_CADBTRIALBAL_STR-SEGMENT sy-vline 
WA_CADBTRIALBAL_STR-SEGMENTNAME sy-vline 
WA_CADBTRIALBAL_STR-COSTCENTER sy-vline 
WA_CADBTRIALBAL_STR-COSTCENTERNAME sy-vline 
WA_CADBTRIALBAL_STR-PARTNERPROFITCENTER sy-vline 
WA_CADBTRIALBAL_STR-PARTNERPROFITCENTERNAME sy-vline 
WA_CADBTRIALBAL_STR-PARTNERFUNCTIONALAREA sy-vline 
WA_CADBTRIALBAL_STR-PARTNERFUNCTIONALAREANAME sy-vline 
WA_CADBTRIALBAL_STR-PARTNERCOMPANY sy-vline 
WA_CADBTRIALBAL_STR-PARTNERSEGMENT sy-vline 
WA_CADBTRIALBAL_STR-FISCALYEARVARIANT sy-vline 
WA_CADBTRIALBAL_STR-CHARTOFACCOUNTS sy-vline 
WA_CADBTRIALBAL_STR-BALANCETRANSACTIONCURRENCY sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINBALANCETRANSACCRCY sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINBALTRANSCRCY sy-vline 
WA_CADBTRIALBAL_STR-COMPANYCODECURRENCY sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINCOMPANYCODECURRENCY sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINCCCRCY sy-vline 
WA_CADBTRIALBAL_STR-GLOBALCURRENCY sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINGLOBALCURRENCY sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINGLOBCRCY sy-vline 
WA_CADBTRIALBAL_STR-FREEDEFINEDCURRENCY1 sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINFREEDEFINEDCURRENCY1 sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINFDCRCY1 sy-vline 
WA_CADBTRIALBAL_STR-FREEDEFINEDCURRENCY2 sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINFREEDEFINEDCURRENCY2 sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINFDCRCY2 sy-vline 
WA_CADBTRIALBAL_STR-FREEDEFINEDCURRENCY3 sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINFREEDEFINEDCURRENCY3 sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINFDCRCY3 sy-vline 
WA_CADBTRIALBAL_STR-FREEDEFINEDCURRENCY4 sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINFREEDEFINEDCURRENCY4 sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINFDCRCY4 sy-vline 
WA_CADBTRIALBAL_STR-FREEDEFINEDCURRENCY5 sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINFREEDEFINEDCURRENCY5 sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINFDCRCY5 sy-vline 
WA_CADBTRIALBAL_STR-FREEDEFINEDCURRENCY6 sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINFREEDEFINEDCURRENCY6 sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINFDCRCY6 sy-vline 
WA_CADBTRIALBAL_STR-FREEDEFINEDCURRENCY7 sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINFREEDEFINEDCURRENCY7 sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINFDCRCY7 sy-vline 
WA_CADBTRIALBAL_STR-FREEDEFINEDCURRENCY8 sy-vline 
WA_CADBTRIALBAL_STR-AMOUNTINFREEDEFINEDCURRENCY8 sy-vline 
WA_CADBTRIALBAL_STR-PRIORDAYBALINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-CURDAYACTYAMTINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-PRIORMONTHBALINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-CURMONTHACTYAMTINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-YTDBALINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGDAILYBALINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-QTDAVGDAILYBALINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-YTDAVGDAILYBALINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-MTDAVGACTYAMTINFDCRCY8 sy-vline 
WA_CADBTRIALBAL_STR-QTDACTYAMTINFDCRCY8 sy-vline      INTO ld_text SEPARATED BY SPACE.

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