ABAP Select data from SAP table FISS_TRIAL_BAL 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 FISS_TRIAL_BAL 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 FISS_TRIAL_BAL. 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 FISS_TRIAL_BAL 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_FISS_TRIAL_BAL TYPE STANDARD TABLE OF FISS_TRIAL_BAL,
      WA_FISS_TRIAL_BAL TYPE FISS_TRIAL_BAL,
      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: <FISS_TRIAL_BAL> TYPE FISS_TRIAL_BAL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FISS_TRIAL_BAL
*  INTO TABLE @DATA(IT_FISS_TRIAL_BAL2).
*--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_FISS_TRIAL_BAL INDEX 1 INTO DATA(WA_FISS_TRIAL_BAL2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FISS_TRIAL_BAL>-MANDT = 1.
<FISS_TRIAL_BAL>-RBUKRS = 1.
<FISS_TRIAL_BAL>-RLDNR = 1.
<FISS_TRIAL_BAL>-RYEAR = 1.
<FISS_TRIAL_BAL>-KTOPL = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FISS_TRIAL_BAL-RACCT, sy-vline,
  WA_FISS_TRIAL_BAL-RCNTR, sy-vline,
  WA_FISS_TRIAL_BAL-PRCTR, sy-vline,
  WA_FISS_TRIAL_BAL-RFAREA, sy-vline,
  WA_FISS_TRIAL_BAL-RBUSA, sy-vline,
  WA_FISS_TRIAL_BAL-KOKRS, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FISS_TRIAL_BAL 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_FISS_TRIAL_BAL 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_FISS_TRIAL_BAL INTO WA_FISS_TRIAL_BAL.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_FISS_TRIAL_BAL-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FISS_TRIAL_BAL-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field AUFNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FISS_TRIAL_BAL-AUFNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FISS_TRIAL_BAL-AUFNR.
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_FISS_TRIAL_BAL_STR, 
MANDT TYPE STRING,
RBUKRS TYPE STRING,
RLDNR TYPE STRING,
RYEAR TYPE STRING,
KTOPL TYPE STRING,
RACCT TYPE STRING,
RCNTR TYPE STRING,
PRCTR TYPE STRING,
RFAREA TYPE STRING,
RBUSA TYPE STRING,
KOKRS TYPE STRING,
SEGMENT TYPE STRING,
DRCRK TYPE STRING,
POPER TYPE STRING,
GJAHR TYPE STRING,
LIFNR TYPE STRING,
KUNNR TYPE STRING,
RTCUR TYPE STRING,
RWCUR TYPE STRING,
RHCUR TYPE STRING,
RKCUR TYPE STRING,
ROCUR TYPE STRING,
PREV_BAL TYPE STRING,
PERIOD_BAL TYPE STRING,
CMP_PREV_BAL TYPE STRING,
CMP_PERIOD_BAL TYPE STRING,
PREV_BAL_DIFF TYPE STRING,
PERIOD_BAL_DIFF TYPE STRING,
PREV_BAL_PERCENT TYPE STRING,
PERIOD_BAL_PERCENT TYPE STRING,
CMP_RYEAR TYPE STRING,
REP_POPER TYPE STRING,
REP_RYEAR TYPE STRING,
TSL TYPE STRING,
WSL TYPE STRING,
HSL TYPE STRING,
KSL TYPE STRING,
OSL TYPE STRING,
BELNR TYPE STRING,
DOCLN TYPE STRING,
RMVCT TYPE STRING,
AWTYP TYPE STRING,
AWSYS TYPE STRING,
AWREF TYPE STRING,
RUNIT TYPE STRING,
SCNTR TYPE STRING,
PPRCTR TYPE STRING,
SFAREA TYPE STRING,
SBUSA TYPE STRING,
RASSC TYPE STRING,
PSEGMENT TYPE STRING,
MSL TYPE STRING,
PERIV TYPE STRING,
BUDAT TYPE STRING,
BLDAT TYPE STRING,
BLART TYPE STRING,
BUZEI TYPE STRING,
ZUONR TYPE STRING,
BSCHL TYPE STRING,
KTOSL TYPE STRING,
SLALITTYPE TYPE STRING,
USNAM TYPE STRING,
LOKKT TYPE STRING,
REBZG TYPE STRING,
REBZJ TYPE STRING,
REBZZ TYPE STRING,
REBZT TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
SGTXT TYPE STRING,
KDAUF TYPE STRING,
KDPOS TYPE STRING,
MATNR TYPE STRING,
WERKS TYPE STRING,
KOART TYPE STRING,
UMSKZ TYPE STRING,
MWSKZ TYPE STRING,
HBKID TYPE STRING,
HKTID TYPE STRING,
AUGDT TYPE STRING,
AUGBL TYPE STRING,
AUGGJ TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
BZDAT TYPE STRING,
ANBWA TYPE STRING,
KALNR TYPE STRING,
BWTAR TYPE STRING,
BWKEY TYPE STRING,
GKONT TYPE STRING,
GKOAR TYPE STRING,
PERNR TYPE STRING,
PBUKRS TYPE STRING,
UKOSTL TYPE STRING,
ULSTAR TYPE STRING,
LSTAR TYPE STRING,
AUFNR TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
REP_PERIOD_TXT TYPE STRING,
REP_PERIOD_YEAR TYPE STRING,
PREV_PERIOD_TXT TYPE STRING,
PREV_PERIOD_YEAR TYPE STRING,
REP_POPER_TO TYPE STRING,
PERIOD_BAL_DR TYPE STRING,
PERIOD_BAL_CR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FISS_TRIAL_BAL_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_FISS_TRIAL_BAL_STR-MANDT sy-vline 
WA_FISS_TRIAL_BAL_STR-RBUKRS sy-vline 
WA_FISS_TRIAL_BAL_STR-RLDNR sy-vline 
WA_FISS_TRIAL_BAL_STR-RYEAR sy-vline 
WA_FISS_TRIAL_BAL_STR-KTOPL sy-vline 
WA_FISS_TRIAL_BAL_STR-RACCT sy-vline 
WA_FISS_TRIAL_BAL_STR-RCNTR sy-vline 
WA_FISS_TRIAL_BAL_STR-PRCTR sy-vline 
WA_FISS_TRIAL_BAL_STR-RFAREA sy-vline 
WA_FISS_TRIAL_BAL_STR-RBUSA sy-vline 
WA_FISS_TRIAL_BAL_STR-KOKRS sy-vline 
WA_FISS_TRIAL_BAL_STR-SEGMENT sy-vline 
WA_FISS_TRIAL_BAL_STR-DRCRK sy-vline 
WA_FISS_TRIAL_BAL_STR-POPER sy-vline 
WA_FISS_TRIAL_BAL_STR-GJAHR sy-vline 
WA_FISS_TRIAL_BAL_STR-LIFNR sy-vline 
WA_FISS_TRIAL_BAL_STR-KUNNR sy-vline 
WA_FISS_TRIAL_BAL_STR-RTCUR sy-vline 
WA_FISS_TRIAL_BAL_STR-RWCUR sy-vline 
WA_FISS_TRIAL_BAL_STR-RHCUR sy-vline 
WA_FISS_TRIAL_BAL_STR-RKCUR sy-vline 
WA_FISS_TRIAL_BAL_STR-ROCUR sy-vline 
WA_FISS_TRIAL_BAL_STR-PREV_BAL sy-vline 
WA_FISS_TRIAL_BAL_STR-PERIOD_BAL sy-vline 
WA_FISS_TRIAL_BAL_STR-CMP_PREV_BAL sy-vline 
WA_FISS_TRIAL_BAL_STR-CMP_PERIOD_BAL sy-vline 
WA_FISS_TRIAL_BAL_STR-PREV_BAL_DIFF sy-vline 
WA_FISS_TRIAL_BAL_STR-PERIOD_BAL_DIFF sy-vline 
WA_FISS_TRIAL_BAL_STR-PREV_BAL_PERCENT sy-vline 
WA_FISS_TRIAL_BAL_STR-PERIOD_BAL_PERCENT sy-vline 
WA_FISS_TRIAL_BAL_STR-CMP_RYEAR sy-vline 
WA_FISS_TRIAL_BAL_STR-REP_POPER sy-vline 
WA_FISS_TRIAL_BAL_STR-REP_RYEAR sy-vline 
WA_FISS_TRIAL_BAL_STR-TSL sy-vline 
WA_FISS_TRIAL_BAL_STR-WSL sy-vline 
WA_FISS_TRIAL_BAL_STR-HSL sy-vline 
WA_FISS_TRIAL_BAL_STR-KSL sy-vline 
WA_FISS_TRIAL_BAL_STR-OSL sy-vline 
WA_FISS_TRIAL_BAL_STR-BELNR sy-vline 
WA_FISS_TRIAL_BAL_STR-DOCLN sy-vline 
WA_FISS_TRIAL_BAL_STR-RMVCT sy-vline 
WA_FISS_TRIAL_BAL_STR-AWTYP sy-vline 
WA_FISS_TRIAL_BAL_STR-AWSYS sy-vline 
WA_FISS_TRIAL_BAL_STR-AWREF sy-vline 
WA_FISS_TRIAL_BAL_STR-RUNIT sy-vline 
WA_FISS_TRIAL_BAL_STR-SCNTR sy-vline 
WA_FISS_TRIAL_BAL_STR-PPRCTR sy-vline 
WA_FISS_TRIAL_BAL_STR-SFAREA sy-vline 
WA_FISS_TRIAL_BAL_STR-SBUSA sy-vline 
WA_FISS_TRIAL_BAL_STR-RASSC sy-vline 
WA_FISS_TRIAL_BAL_STR-PSEGMENT sy-vline 
WA_FISS_TRIAL_BAL_STR-MSL sy-vline 
WA_FISS_TRIAL_BAL_STR-PERIV sy-vline 
WA_FISS_TRIAL_BAL_STR-BUDAT sy-vline 
WA_FISS_TRIAL_BAL_STR-BLDAT sy-vline 
WA_FISS_TRIAL_BAL_STR-BLART sy-vline 
WA_FISS_TRIAL_BAL_STR-BUZEI sy-vline 
WA_FISS_TRIAL_BAL_STR-ZUONR sy-vline 
WA_FISS_TRIAL_BAL_STR-BSCHL sy-vline 
WA_FISS_TRIAL_BAL_STR-KTOSL sy-vline 
WA_FISS_TRIAL_BAL_STR-SLALITTYPE sy-vline 
WA_FISS_TRIAL_BAL_STR-USNAM sy-vline 
WA_FISS_TRIAL_BAL_STR-LOKKT sy-vline 
WA_FISS_TRIAL_BAL_STR-REBZG sy-vline 
WA_FISS_TRIAL_BAL_STR-REBZJ sy-vline 
WA_FISS_TRIAL_BAL_STR-REBZZ sy-vline 
WA_FISS_TRIAL_BAL_STR-REBZT sy-vline 
WA_FISS_TRIAL_BAL_STR-EBELN sy-vline 
WA_FISS_TRIAL_BAL_STR-EBELP sy-vline 
WA_FISS_TRIAL_BAL_STR-SGTXT sy-vline 
WA_FISS_TRIAL_BAL_STR-KDAUF sy-vline 
WA_FISS_TRIAL_BAL_STR-KDPOS sy-vline 
WA_FISS_TRIAL_BAL_STR-MATNR sy-vline 
WA_FISS_TRIAL_BAL_STR-WERKS sy-vline 
WA_FISS_TRIAL_BAL_STR-KOART sy-vline 
WA_FISS_TRIAL_BAL_STR-UMSKZ sy-vline 
WA_FISS_TRIAL_BAL_STR-MWSKZ sy-vline 
WA_FISS_TRIAL_BAL_STR-HBKID sy-vline 
WA_FISS_TRIAL_BAL_STR-HKTID sy-vline 
WA_FISS_TRIAL_BAL_STR-AUGDT sy-vline 
WA_FISS_TRIAL_BAL_STR-AUGBL sy-vline 
WA_FISS_TRIAL_BAL_STR-AUGGJ sy-vline 
WA_FISS_TRIAL_BAL_STR-ANLN1 sy-vline 
WA_FISS_TRIAL_BAL_STR-ANLN2 sy-vline 
WA_FISS_TRIAL_BAL_STR-BZDAT sy-vline 
WA_FISS_TRIAL_BAL_STR-ANBWA sy-vline 
WA_FISS_TRIAL_BAL_STR-KALNR sy-vline 
WA_FISS_TRIAL_BAL_STR-BWTAR sy-vline 
WA_FISS_TRIAL_BAL_STR-BWKEY sy-vline 
WA_FISS_TRIAL_BAL_STR-GKONT sy-vline 
WA_FISS_TRIAL_BAL_STR-GKOAR sy-vline 
WA_FISS_TRIAL_BAL_STR-PERNR sy-vline 
WA_FISS_TRIAL_BAL_STR-PBUKRS sy-vline 
WA_FISS_TRIAL_BAL_STR-UKOSTL sy-vline 
WA_FISS_TRIAL_BAL_STR-ULSTAR sy-vline 
WA_FISS_TRIAL_BAL_STR-LSTAR sy-vline 
WA_FISS_TRIAL_BAL_STR-AUFNR sy-vline 
WA_FISS_TRIAL_BAL_STR-VKORG sy-vline 
WA_FISS_TRIAL_BAL_STR-VTWEG sy-vline 
WA_FISS_TRIAL_BAL_STR-SPART sy-vline 
WA_FISS_TRIAL_BAL_STR-REP_PERIOD_TXT sy-vline 
WA_FISS_TRIAL_BAL_STR-REP_PERIOD_YEAR sy-vline 
WA_FISS_TRIAL_BAL_STR-PREV_PERIOD_TXT sy-vline 
WA_FISS_TRIAL_BAL_STR-PREV_PERIOD_YEAR sy-vline 
WA_FISS_TRIAL_BAL_STR-REP_POPER_TO sy-vline 
WA_FISS_TRIAL_BAL_STR-PERIOD_BAL_DR sy-vline 
WA_FISS_TRIAL_BAL_STR-PERIOD_BAL_CR sy-vline      INTO ld_text SEPARATED BY SPACE.

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