ABAP Select data from SAP table PCNFINSTMNTBAL01 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 PCNFINSTMNTBAL01 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 PCNFINSTMNTBAL01. 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 PCNFINSTMNTBAL01 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_PCNFINSTMNTBAL01 TYPE STANDARD TABLE OF PCNFINSTMNTBAL01,
      WA_PCNFINSTMNTBAL01 TYPE PCNFINSTMNTBAL01,
      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: <PCNFINSTMNTBAL01> TYPE PCNFINSTMNTBAL01.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PCNFINSTMNTBAL01
*  INTO TABLE @DATA(IT_PCNFINSTMNTBAL012).
*--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_PCNFINSTMNTBAL01 INDEX 1 INTO DATA(WA_PCNFINSTMNTBAL012).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PCNFINSTMNTBAL01>-MANDT = 1.
<PCNFINSTMNTBAL01>-LEDGER = 1.
<PCNFINSTMNTBAL01>-COMPANYCODE = 1.
<PCNFINSTMNTBAL01>-FISCALYEAR = 1.
<PCNFINSTMNTBAL01>-ACCOUNTINGDOCUMENT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PCNFINSTMNTBAL01-LEDGERGLLINEITEM, sy-vline,
  WA_PCNFINSTMNTBAL01-LEDGERFISCALYEAR, sy-vline,
  WA_PCNFINSTMNTBAL01-GLACCOUNT, sy-vline,
  WA_PCNFINSTMNTBAL01-ALTERNATIVEGLACCOUNT, sy-vline,
  WA_PCNFINSTMNTBAL01-PROFITCENTER, sy-vline,
  WA_PCNFINSTMNTBAL01-FUNCTIONALAREA, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PCNFINSTMNTBAL01 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_PCNFINSTMNTBAL01 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_PCNFINSTMNTBAL01 INTO WA_PCNFINSTMNTBAL01.


*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_PCNFINSTMNTBAL01-LEDGER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PCNFINSTMNTBAL01-LEDGER.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field SEGMENT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PCNFINSTMNTBAL01-SEGMENT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PCNFINSTMNTBAL01-SEGMENT.
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_PCNFINSTMNTBAL01_STR, 
MANDT TYPE STRING,
LEDGER TYPE STRING,
COMPANYCODE TYPE STRING,
FISCALYEAR TYPE STRING,
ACCOUNTINGDOCUMENT TYPE STRING,
LEDGERGLLINEITEM TYPE STRING,
LEDGERFISCALYEAR TYPE STRING,
GLACCOUNT TYPE STRING,
ALTERNATIVEGLACCOUNT TYPE STRING,
PROFITCENTER TYPE STRING,
FUNCTIONALAREA TYPE STRING,
BUSINESSAREA TYPE STRING,
SEGMENT TYPE STRING,
DEBITCREDITCODE TYPE STRING,
POSTINGDATE TYPE STRING,
CHARTOFACCOUNTS TYPE STRING,
COUNTRYCHARTOFACCOUNTS TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
GLOBALCURRENCY TYPE STRING,
FREEDEFINEDCURRENCY1 TYPE STRING,
FREEDEFINEDCURRENCY2 TYPE STRING,
FREEDEFINEDCURRENCY3 TYPE STRING,
FREEDEFINEDCURRENCY4 TYPE STRING,
FREEDEFINEDCURRENCY5 TYPE STRING,
FREEDEFINEDCURRENCY6 TYPE STRING,
FREEDEFINEDCURRENCY7 TYPE STRING,
FREEDEFINEDCURRENCY8 TYPE STRING,
DEBITAMOUNTINCOCODECRCY TYPE STRING,
CREDITAMOUNTINCOCODECRCY TYPE STRING,
DEBITAMOUNTINGLOBALCRCY TYPE STRING,
CREDITAMOUNTINGLOBALCRCY TYPE STRING,
DEBITAMOUNTINFREEDEFINEDCRCY1 TYPE STRING,
CREDITAMOUNTINFREEDEFINEDCRCY1 TYPE STRING,
DEBITAMOUNTINFREEDEFINEDCRCY2 TYPE STRING,
CREDITAMOUNTINFREEDEFINEDCRCY2 TYPE STRING,
DEBITAMOUNTINFREEDEFINEDCRCY3 TYPE STRING,
CREDITAMOUNTINFREEDEFINEDCRCY3 TYPE STRING,
DEBITAMOUNTINFREEDEFINEDCRCY4 TYPE STRING,
CREDITAMOUNTINFREEDEFINEDCRCY4 TYPE STRING,
DEBITAMOUNTINFREEDEFINEDCRCY5 TYPE STRING,
CREDITAMOUNTINFREEDEFINEDCRCY5 TYPE STRING,
DEBITAMOUNTINFREEDEFINEDCRCY6 TYPE STRING,
CREDITAMOUNTINFREEDEFINEDCRCY6 TYPE STRING,
DEBITAMOUNTINFREEDEFINEDCRCY7 TYPE STRING,
CREDITAMOUNTINFREEDEFINEDCRCY7 TYPE STRING,
DEBITAMOUNTINFREEDEFINEDCRCY8 TYPE STRING,
CREDITAMOUNTINFREEDEFINEDCRCY8 TYPE STRING,
PERIODDEBITAMTINCOCODECRCY TYPE STRING,
PERIODCREDITAMTINCOCODECRCY TYPE STRING,
PERIODDEBITAMTINGLOBALCRCY TYPE STRING,
PERIODCREDITAMTINGLOBALCRCY TYPE STRING,
PERIODDEBITAMTINFREEDFNDCRCY1 TYPE STRING,
PERIODCREDITAMTINFREEDFNDCRCY1 TYPE STRING,
PERIODDEBITAMTINFREEDFNDCRCY2 TYPE STRING,
PERIODCREDITAMTINFREEDFNDCRCY2 TYPE STRING,
PERIODDEBITAMTINFREEDFNDCRCY3 TYPE STRING,
PERIODCREDITAMTINFREEDFNDCRCY3 TYPE STRING,
PERIODDEBITAMTINFREEDFNDCRCY4 TYPE STRING,
PERIODCREDITAMTINFREEDFNDCRCY4 TYPE STRING,
PERIODDEBITAMTINFREEDFNDCRCY5 TYPE STRING,
PERIODCREDITAMTINFREEDFNDCRCY5 TYPE STRING,
PERIODDEBITAMTINFREEDFNDCRCY6 TYPE STRING,
PERIODCREDITAMTINFREEDFNDCRCY6 TYPE STRING,
PERIODDEBITAMTINFREEDFNDCRCY7 TYPE STRING,
PERIODCREDITAMTINFREEDFNDCRCY7 TYPE STRING,
PERIODDEBITAMTINFREEDFNDCRCY8 TYPE STRING,
PERIODCREDITAMTINFREEDFNDCRCY8 TYPE STRING,
QUARTERDEBITAMTINCOCODECRCY TYPE STRING,
QUARTERCREDITAMTINCOCODECRCY TYPE STRING,
QUARTERDEBITAMTINGLOBALCRCY TYPE STRING,
QUARTERCREDITAMTINGLOBALCRCY TYPE STRING,
QUARTERDEBITAMTINFREEDFNDCRCY1 TYPE STRING,
QUARTERCRDTAMTINFREEDFNDCRCY1 TYPE STRING,
QUARTERDEBITAMTINFREEDFNDCRCY2 TYPE STRING,
QUARTERCRDTAMTINFREEDFNDCRCY2 TYPE STRING,
QUARTERDEBITAMTINFREEDFNDCRCY3 TYPE STRING,
QUARTERCRDTAMTINFREEDFNDCRCY3 TYPE STRING,
QUARTERDEBITAMTINFREEDFNDCRCY4 TYPE STRING,
QUARTERCRDTAMTINFREEDFNDCRCY4 TYPE STRING,
QUARTERDEBITAMTINFREEDFNDCRCY5 TYPE STRING,
QUARTERCRDTAMTINFREEDFNDCRCY5 TYPE STRING,
QUARTERDEBITAMTINFREEDFNDCRCY6 TYPE STRING,
QUARTERCRDTAMTINFREEDFNDCRCY6 TYPE STRING,
QUARTERDEBITAMTINFREEDFNDCRCY7 TYPE STRING,
QUARTERCRDTAMTINFREEDFNDCRCY7 TYPE STRING,
QUARTERDEBITAMTINFREEDFNDCRCY8 TYPE STRING,
QUARTERCRDTAMTINFREEDFNDCRCY8 TYPE STRING,
COMPRNPERDDEBITAMTINCOCODECRCY TYPE STRING,
COMPRNPERDCRDTAMTINCOCODECRCY TYPE STRING,
COMPRNPERDDEBITAMTINGLOBALCRCY TYPE STRING,
COMPRNPERDCRDTAMTINGLOBALCRCY TYPE STRING,
COMPRNPERDDEBITAMTINFDFNDCRCY1 TYPE STRING,
COMPRNPERDCRDTAMTINFDFNDCRCY1 TYPE STRING,
COMPRNPERDDEBITAMTINFDFNDCRCY2 TYPE STRING,
COMPRNPERDCRDTAMTINFDFNDCRCY2 TYPE STRING,
COMPRNPERDDEBITAMTINFDFNDCRCY3 TYPE STRING,
COMPRNPERDCRDTAMTINFDFNDCRCY3 TYPE STRING,
COMPRNPERDDEBITAMTINFDFNDCRCY4 TYPE STRING,
COMPRNPERDCRDTAMTINFDFNDCRCY4 TYPE STRING,
COMPRNPERDDEBITAMTINFDFNDCRCY5 TYPE STRING,
COMPRNPERDCRDTAMTINFDFNDCRCY5 TYPE STRING,
COMPRNPERDDEBITAMTINFDFNDCRCY6 TYPE STRING,
COMPRNPERDCRDTAMTINFDFNDCRCY6 TYPE STRING,
COMPRNPERDDEBITAMTINFDFNDCRCY7 TYPE STRING,
COMPRNPERDCRDTAMTINFDFNDCRCY7 TYPE STRING,
COMPRNPERDDEBITAMTINFDFNDCRCY8 TYPE STRING,
COMPRNPERDCRDTAMTINFDFNDCRCY8 TYPE STRING,
COMPRNDEBITAMTINCOCODECRCY TYPE STRING,
COMPRNCRDTAMTINCOCODECRCY TYPE STRING,
COMPRNDEBITAMTINGLOBALCRCY TYPE STRING,
COMPRNCRDTAMTINGLOBALCRCY TYPE STRING,
COMPRNDEBITAMTINFREEDFNDCRCY1 TYPE STRING,
COMPRNCRDTAMTINFREEDFNDCRCY1 TYPE STRING,
COMPRNDEBITAMTINFREEDFNDCRCY2 TYPE STRING,
COMPRNCRDTAMTINFREEDFNDCRCY2 TYPE STRING,
COMPRNDEBITAMTINFREEDFNDCRCY3 TYPE STRING,
COMPRNCRDTAMTINFREEDFNDCRCY3 TYPE STRING,
COMPRNDEBITAMTINFREEDFNDCRCY4 TYPE STRING,
COMPRNCRDTAMTINFREEDFNDCRCY4 TYPE STRING,
COMPRNDEBITAMTINFREEDFNDCRCY5 TYPE STRING,
COMPRNCRDTAMTINFREEDFNDCRCY5 TYPE STRING,
COMPRNDEBITAMTINFREEDFNDCRCY6 TYPE STRING,
COMPRNCRDTAMTINFREEDFNDCRCY6 TYPE STRING,
COMPRNDEBITAMTINFREEDFNDCRCY7 TYPE STRING,
COMPRNCRDTAMTINFREEDFNDCRCY7 TYPE STRING,
COMPRNDEBITAMTINFREEDFNDCRCY8 TYPE STRING,
COMPRNCRDTAMTINFREEDFNDCRCY8 TYPE STRING,
FISCALPERIOD TYPE STRING,
ENDINGBALANCEAMTINCOCODECRCY TYPE STRING,
ENDINGBALANCEAMTINGLOBALCRCY TYPE STRING,
ENDINGBALAMTINFREEDFNDCRCY1 TYPE STRING,
ENDINGBALAMTINFREEDFNDCRCY2 TYPE STRING,
ENDINGBALAMTINFREEDFNDCRCY3 TYPE STRING,
ENDINGBALAMTINFREEDFNDCRCY4 TYPE STRING,
ENDINGBALAMTINFREEDFNDCRCY5 TYPE STRING,
ENDINGBALAMTINFREEDFNDCRCY6 TYPE STRING,
ENDINGBALAMTINFREEDFNDCRCY7 TYPE STRING,
ENDINGBALAMTINFREEDFNDCRCY8 TYPE STRING,
STARTINGBALAMTINCOCODECRCY TYPE STRING,
STARTINGBALAMTINGLOBALCRCY TYPE STRING,
STARTINGBALAMTINFREEDFNDCRCY1 TYPE STRING,
STARTINGBALAMTINFREEDFNDCRCY2 TYPE STRING,
STARTINGBALAMTINFREEDFNDCRCY3 TYPE STRING,
STARTINGBALAMTINFREEDFNDCRCY4 TYPE STRING,
STARTINGBALAMTINFREEDFNDCRCY5 TYPE STRING,
STARTINGBALAMTINFREEDFNDCRCY6 TYPE STRING,
STARTINGBALAMTINFREEDFNDCRCY7 TYPE STRING,
STARTINGBALAMTINFREEDFNDCRCY8 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PCNFINSTMNTBAL01_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_PCNFINSTMNTBAL01_STR-MANDT sy-vline 
WA_PCNFINSTMNTBAL01_STR-LEDGER sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPANYCODE sy-vline 
WA_PCNFINSTMNTBAL01_STR-FISCALYEAR sy-vline 
WA_PCNFINSTMNTBAL01_STR-ACCOUNTINGDOCUMENT sy-vline 
WA_PCNFINSTMNTBAL01_STR-LEDGERGLLINEITEM sy-vline 
WA_PCNFINSTMNTBAL01_STR-LEDGERFISCALYEAR sy-vline 
WA_PCNFINSTMNTBAL01_STR-GLACCOUNT sy-vline 
WA_PCNFINSTMNTBAL01_STR-ALTERNATIVEGLACCOUNT sy-vline 
WA_PCNFINSTMNTBAL01_STR-PROFITCENTER sy-vline 
WA_PCNFINSTMNTBAL01_STR-FUNCTIONALAREA sy-vline 
WA_PCNFINSTMNTBAL01_STR-BUSINESSAREA sy-vline 
WA_PCNFINSTMNTBAL01_STR-SEGMENT sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITCREDITCODE sy-vline 
WA_PCNFINSTMNTBAL01_STR-POSTINGDATE sy-vline 
WA_PCNFINSTMNTBAL01_STR-CHARTOFACCOUNTS sy-vline 
WA_PCNFINSTMNTBAL01_STR-COUNTRYCHARTOFACCOUNTS sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPANYCODECURRENCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-GLOBALCURRENCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-FREEDEFINEDCURRENCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-FREEDEFINEDCURRENCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-FREEDEFINEDCURRENCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-FREEDEFINEDCURRENCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-FREEDEFINEDCURRENCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-FREEDEFINEDCURRENCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-FREEDEFINEDCURRENCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-FREEDEFINEDCURRENCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINFREEDEFINEDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINFREEDEFINEDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINFREEDEFINEDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINFREEDEFINEDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINFREEDEFINEDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINFREEDEFINEDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINFREEDEFINEDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINFREEDEFINEDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINFREEDEFINEDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINFREEDEFINEDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINFREEDEFINEDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINFREEDEFINEDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINFREEDEFINEDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINFREEDEFINEDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-DEBITAMOUNTINFREEDEFINEDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-CREDITAMOUNTINFREEDEFINEDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINFREEDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINFREEDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINFREEDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINFREEDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINFREEDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINFREEDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINFREEDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINFREEDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINFREEDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINFREEDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINFREEDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINFREEDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINFREEDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINFREEDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODDEBITAMTINFREEDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-PERIODCREDITAMTINFREEDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCREDITAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCREDITAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINFREEDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCRDTAMTINFREEDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINFREEDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCRDTAMTINFREEDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINFREEDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCRDTAMTINFREEDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINFREEDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCRDTAMTINFREEDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINFREEDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCRDTAMTINFREEDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINFREEDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCRDTAMTINFREEDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINFREEDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCRDTAMTINFREEDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERDEBITAMTINFREEDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-QUARTERCRDTAMTINFREEDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINFDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINFDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINFDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINFDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINFDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINFDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINFDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINFDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINFDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINFDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINFDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINFDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINFDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINFDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDDEBITAMTINFDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNPERDCRDTAMTINFDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINFREEDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINFREEDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINFREEDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINFREEDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINFREEDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINFREEDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINFREEDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINFREEDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINFREEDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINFREEDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINFREEDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINFREEDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINFREEDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINFREEDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNDEBITAMTINFREEDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-COMPRNCRDTAMTINFREEDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-FISCALPERIOD sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALANCEAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALANCEAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALAMTINFREEDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALAMTINFREEDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALAMTINFREEDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALAMTINFREEDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALAMTINFREEDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALAMTINFREEDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALAMTINFREEDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-ENDINGBALAMTINFREEDFNDCRCY8 sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINCOCODECRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINGLOBALCRCY sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINFREEDFNDCRCY1 sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINFREEDFNDCRCY2 sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINFREEDFNDCRCY3 sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINFREEDFNDCRCY4 sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINFREEDFNDCRCY5 sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINFREEDFNDCRCY6 sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINFREEDFNDCRCY7 sy-vline 
WA_PCNFINSTMNTBAL01_STR-STARTINGBALAMTINFREEDFNDCRCY8 sy-vline      INTO ld_text SEPARATED BY SPACE.

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