ABAP Select data from SAP table FCLM_S_FA_BKH 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 FCLM_S_FA_BKH 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 FCLM_S_FA_BKH. 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 FCLM_S_FA_BKH 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_FCLM_S_FA_BKH TYPE STANDARD TABLE OF FCLM_S_FA_BKH,
      WA_FCLM_S_FA_BKH TYPE FCLM_S_FA_BKH,
      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: <FCLM_S_FA_BKH> TYPE FCLM_S_FA_BKH.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FCLM_S_FA_BKH
*  INTO TABLE @DATA(IT_FCLM_S_FA_BKH2).
*--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_FCLM_S_FA_BKH INDEX 1 INTO DATA(WA_FCLM_S_FA_BKH2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FCLM_S_FA_BKH>-GENERATED_ID = 1.
<FCLM_S_FA_BKH>-DISPLAYCURRENCY = 1.
<FCLM_S_FA_BKH>-CYCLEPATTERN = 1.
<FCLM_S_FA_BKH>-EXRATETYPE = 1.
<FCLM_S_FA_BKH>-KEYDATE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FCLM_S_FA_BKH-VIEW_TYPE_EXT, sy-vline,
  WA_FCLM_S_FA_BKH-VIEW_TYPE, sy-vline,
  WA_FCLM_S_FA_BKH-P_HIERNAME, sy-vline,
  WA_FCLM_S_FA_BKH-P_EXPORT, sy-vline,
  WA_FCLM_S_FA_BKH-ACTUALDATE, sy-vline,
  WA_FCLM_S_FA_BKH-ISBANKCURRENCY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FCLM_S_FA_BKH 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_FCLM_S_FA_BKH 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_FCLM_S_FA_BKH INTO WA_FCLM_S_FA_BKH.


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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field PROFITCENTER
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_S_FA_BKH-PROFITCENTER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_S_FA_BKH-PROFITCENTER.
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_FCLM_S_FA_BKH_STR, 
GENERATED_ID TYPE STRING,
DISPLAYCURRENCY TYPE STRING,
CYCLEPATTERN TYPE STRING,
EXRATETYPE TYPE STRING,
KEYDATE TYPE STRING,
VIEW_TYPE_EXT TYPE STRING,
VIEW_TYPE TYPE STRING,
P_HIERNAME TYPE STRING,
P_EXPORT TYPE STRING,
ACTUALDATE TYPE STRING,
ISBANKCURRENCY TYPE STRING,
CALENDAREND TYPE STRING,
HIERARCHYNAME TYPE STRING,
NODEID TYPE STRING,
PARENTID TYPE STRING,
NEXTID TYPE STRING,
CHILDID TYPE STRING,
NODELEVEL TYPE STRING,
SORT_ORDER TYPE STRING,
IS_DATA TYPE STRING,
IS_TRANSACTIONCUR TYPE STRING,
S_TEXT TYPE STRING,
DIRECTION TYPE STRING,
BANKACCOUNTGROUP TYPE STRING,
BANK TYPE STRING,
BANKACCOUNTTYPE TYPE STRING,
FIDOCUMENTTYPE TYPE STRING,
BANKCOUNTRY TYPE STRING,
BANKACCOUNT TYPE STRING,
BANKACCOUNTNAME TYPE STRING,
BANKGROUPNAME TYPE STRING,
BANKRATING TYPE STRING,
BANKGROUP TYPE STRING,
CERTAINTYLEVEL TYPE STRING,
SUMMARIZATIONTERM TYPE STRING,
SUMMARIZATIONGROUP TYPE STRING,
ACCID TYPE STRING,
COMPANYCODE TYPE STRING,
COMPANYCODENAME TYPE STRING,
GLACCOUNT TYPE STRING,
BANKACCOUNTCURRENCY TYPE STRING,
CASHPLANNINGGROUP TYPE STRING,
OVERDUEPLANNINGLEVEL TYPE STRING,
PLANNINGLEVEL TYPE STRING,
LIQUIDITYITEMNAME TYPE STRING,
LIQUIDITYITEM TYPE STRING,
HOUSEBANK TYPE STRING,
HOUSEBANKACCOUNT TYPE STRING,
CONVERT_OVERDUE TYPE STRING,
OVERDUE TYPE STRING,
CONVERT_DATA1 TYPE STRING,
DATA1 TYPE STRING,
CONVERT_DATA2 TYPE STRING,
DATA2 TYPE STRING,
CONVERT_DATA3 TYPE STRING,
DATA3 TYPE STRING,
CONVERT_DATA4 TYPE STRING,
DATA4 TYPE STRING,
CONVERT_DATA5 TYPE STRING,
DATA5 TYPE STRING,
CONVERT_DATA6 TYPE STRING,
DATA6 TYPE STRING,
CONVERT_DATA7 TYPE STRING,
DATA7 TYPE STRING,
CONVERT_DATA8 TYPE STRING,
DATA8 TYPE STRING,
CONVERT_DATA9 TYPE STRING,
DATA9 TYPE STRING,
CONVERT_DATA10 TYPE STRING,
DATA10 TYPE STRING,
CONVERT_DATA11 TYPE STRING,
DATA11 TYPE STRING,
CONVERT_DATA12 TYPE STRING,
DATA12 TYPE STRING,
CONVERT_DATA13 TYPE STRING,
DATA13 TYPE STRING,
CONVERT_DATA14 TYPE STRING,
DATA14 TYPE STRING,
CONVERT_DATA15 TYPE STRING,
DATA15 TYPE STRING,
CONVERT_DATA16 TYPE STRING,
DATA16 TYPE STRING,
CONVERT_DATA17 TYPE STRING,
DATA17 TYPE STRING,
CONVERT_DATA18 TYPE STRING,
DATA18 TYPE STRING,
CONVERT_DATA19 TYPE STRING,
DATA19 TYPE STRING,
CONVERT_DATA20 TYPE STRING,
DATA20 TYPE STRING,
CONVERT_DATA21 TYPE STRING,
DATA21 TYPE STRING,
CONVERT_DATA22 TYPE STRING,
DATA22 TYPE STRING,
CONVERT_DATA23 TYPE STRING,
DATA23 TYPE STRING,
CONVERT_DATA24 TYPE STRING,
DATA24 TYPE STRING,
CONVERT_DATA25 TYPE STRING,
DATA25 TYPE STRING,
CONVERT_DATA26 TYPE STRING,
DATA26 TYPE STRING,
CONVERT_DATA27 TYPE STRING,
DATA27 TYPE STRING,
CONVERT_DATA28 TYPE STRING,
DATA28 TYPE STRING,
CONVERT_DATA29 TYPE STRING,
DATA29 TYPE STRING,
CONVERT_DATA30 TYPE STRING,
DATA30 TYPE STRING,
CONVERT_DATA31 TYPE STRING,
DATA31 TYPE STRING,
CONVERT_DATA32 TYPE STRING,
DATA32 TYPE STRING,
CNT TYPE STRING,
TEXTDATA1 TYPE STRING,
TEXTDATA2 TYPE STRING,
TEXTDATA3 TYPE STRING,
TEXTDATA4 TYPE STRING,
TEXTDATA5 TYPE STRING,
TEXTDATA6 TYPE STRING,
TEXTDATA7 TYPE STRING,
TEXTDATA8 TYPE STRING,
TEXTDATA9 TYPE STRING,
TEXTDATA10 TYPE STRING,
TEXTDATA11 TYPE STRING,
TEXTDATA12 TYPE STRING,
TEXTDATA13 TYPE STRING,
TEXTDATA14 TYPE STRING,
TEXTDATA15 TYPE STRING,
TEXTDATA16 TYPE STRING,
TEXTDATA17 TYPE STRING,
TEXTDATA18 TYPE STRING,
TEXTDATA19 TYPE STRING,
TEXTDATA20 TYPE STRING,
TEXTDATA21 TYPE STRING,
TEXTDATA22 TYPE STRING,
TEXTDATA23 TYPE STRING,
TEXTDATA24 TYPE STRING,
TEXTDATA25 TYPE STRING,
TEXTDATA26 TYPE STRING,
TEXTDATA27 TYPE STRING,
TEXTDATA28 TYPE STRING,
TEXTDATA29 TYPE STRING,
TEXTDATA30 TYPE STRING,
TEXTDATA31 TYPE STRING,
TEXTDATA32 TYPE STRING,
TEXTOVERDUE TYPE STRING,
CONTENT TYPE STRING,
PREVIOUSFLAG TYPE STRING,
CALENDAR TYPE STRING,
ENDOFPERIOD TYPE STRING,
PLANNING_LEVEL_DESC TYPE STRING,
CASHPLANNINGGROUP_DESC TYPE STRING,
LIQUIDITYITEMDESC TYPE STRING,
BUSINESSAREA TYPE STRING,
SEGMENT TYPE STRING,
TRADINGPARTNER TYPE STRING,
PROFITCENTER TYPE STRING,
HISTORICAL_TIMESTAMP TYPE STRING,
RECONCILIATION_STATUS TYPE STRING,
RELEASE_STATUS TYPE STRING,
RELEASE_FLAG TYPE STRING,
DATE_INDICATOR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FCLM_S_FA_BKH_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_FCLM_S_FA_BKH_STR-GENERATED_ID sy-vline 
WA_FCLM_S_FA_BKH_STR-DISPLAYCURRENCY sy-vline 
WA_FCLM_S_FA_BKH_STR-CYCLEPATTERN sy-vline 
WA_FCLM_S_FA_BKH_STR-EXRATETYPE sy-vline 
WA_FCLM_S_FA_BKH_STR-KEYDATE sy-vline 
WA_FCLM_S_FA_BKH_STR-VIEW_TYPE_EXT sy-vline 
WA_FCLM_S_FA_BKH_STR-VIEW_TYPE sy-vline 
WA_FCLM_S_FA_BKH_STR-P_HIERNAME sy-vline 
WA_FCLM_S_FA_BKH_STR-P_EXPORT sy-vline 
WA_FCLM_S_FA_BKH_STR-ACTUALDATE sy-vline 
WA_FCLM_S_FA_BKH_STR-ISBANKCURRENCY sy-vline 
WA_FCLM_S_FA_BKH_STR-CALENDAREND sy-vline 
WA_FCLM_S_FA_BKH_STR-HIERARCHYNAME sy-vline 
WA_FCLM_S_FA_BKH_STR-NODEID sy-vline 
WA_FCLM_S_FA_BKH_STR-PARENTID sy-vline 
WA_FCLM_S_FA_BKH_STR-NEXTID sy-vline 
WA_FCLM_S_FA_BKH_STR-CHILDID sy-vline 
WA_FCLM_S_FA_BKH_STR-NODELEVEL sy-vline 
WA_FCLM_S_FA_BKH_STR-SORT_ORDER sy-vline 
WA_FCLM_S_FA_BKH_STR-IS_DATA sy-vline 
WA_FCLM_S_FA_BKH_STR-IS_TRANSACTIONCUR sy-vline 
WA_FCLM_S_FA_BKH_STR-S_TEXT sy-vline 
WA_FCLM_S_FA_BKH_STR-DIRECTION sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKACCOUNTGROUP sy-vline 
WA_FCLM_S_FA_BKH_STR-BANK sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKACCOUNTTYPE sy-vline 
WA_FCLM_S_FA_BKH_STR-FIDOCUMENTTYPE sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKCOUNTRY sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKACCOUNT sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKACCOUNTNAME sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKGROUPNAME sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKRATING sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKGROUP sy-vline 
WA_FCLM_S_FA_BKH_STR-CERTAINTYLEVEL sy-vline 
WA_FCLM_S_FA_BKH_STR-SUMMARIZATIONTERM sy-vline 
WA_FCLM_S_FA_BKH_STR-SUMMARIZATIONGROUP sy-vline 
WA_FCLM_S_FA_BKH_STR-ACCID sy-vline 
WA_FCLM_S_FA_BKH_STR-COMPANYCODE sy-vline 
WA_FCLM_S_FA_BKH_STR-COMPANYCODENAME sy-vline 
WA_FCLM_S_FA_BKH_STR-GLACCOUNT sy-vline 
WA_FCLM_S_FA_BKH_STR-BANKACCOUNTCURRENCY sy-vline 
WA_FCLM_S_FA_BKH_STR-CASHPLANNINGGROUP sy-vline 
WA_FCLM_S_FA_BKH_STR-OVERDUEPLANNINGLEVEL sy-vline 
WA_FCLM_S_FA_BKH_STR-PLANNINGLEVEL sy-vline 
WA_FCLM_S_FA_BKH_STR-LIQUIDITYITEMNAME sy-vline 
WA_FCLM_S_FA_BKH_STR-LIQUIDITYITEM sy-vline 
WA_FCLM_S_FA_BKH_STR-HOUSEBANK sy-vline 
WA_FCLM_S_FA_BKH_STR-HOUSEBANKACCOUNT sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_OVERDUE sy-vline 
WA_FCLM_S_FA_BKH_STR-OVERDUE sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA1 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA1 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA2 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA2 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA3 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA3 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA4 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA4 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA5 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA5 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA6 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA6 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA7 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA7 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA8 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA8 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA9 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA9 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA10 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA10 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA11 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA11 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA12 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA12 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA13 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA13 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA14 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA14 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA15 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA15 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA16 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA16 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA17 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA17 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA18 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA18 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA19 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA19 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA20 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA20 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA21 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA21 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA22 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA22 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA23 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA23 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA24 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA24 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA25 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA25 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA26 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA26 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA27 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA27 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA28 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA28 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA29 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA29 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA30 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA30 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA31 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA31 sy-vline 
WA_FCLM_S_FA_BKH_STR-CONVERT_DATA32 sy-vline 
WA_FCLM_S_FA_BKH_STR-DATA32 sy-vline 
WA_FCLM_S_FA_BKH_STR-CNT sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA1 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA2 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA3 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA4 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA5 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA6 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA7 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA8 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA9 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA10 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA11 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA12 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA13 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA14 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA15 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA16 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA17 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA18 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA19 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA20 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA21 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA22 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA23 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA24 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA25 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA26 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA27 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA28 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA29 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA30 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA31 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTDATA32 sy-vline 
WA_FCLM_S_FA_BKH_STR-TEXTOVERDUE sy-vline 
WA_FCLM_S_FA_BKH_STR-CONTENT sy-vline 
WA_FCLM_S_FA_BKH_STR-PREVIOUSFLAG sy-vline 
WA_FCLM_S_FA_BKH_STR-CALENDAR sy-vline 
WA_FCLM_S_FA_BKH_STR-ENDOFPERIOD sy-vline 
WA_FCLM_S_FA_BKH_STR-PLANNING_LEVEL_DESC sy-vline 
WA_FCLM_S_FA_BKH_STR-CASHPLANNINGGROUP_DESC sy-vline 
WA_FCLM_S_FA_BKH_STR-LIQUIDITYITEMDESC sy-vline 
WA_FCLM_S_FA_BKH_STR-BUSINESSAREA sy-vline 
WA_FCLM_S_FA_BKH_STR-SEGMENT sy-vline 
WA_FCLM_S_FA_BKH_STR-TRADINGPARTNER sy-vline 
WA_FCLM_S_FA_BKH_STR-PROFITCENTER sy-vline 
WA_FCLM_S_FA_BKH_STR-HISTORICAL_TIMESTAMP sy-vline 
WA_FCLM_S_FA_BKH_STR-RECONCILIATION_STATUS sy-vline 
WA_FCLM_S_FA_BKH_STR-RELEASE_STATUS sy-vline 
WA_FCLM_S_FA_BKH_STR-RELEASE_FLAG sy-vline 
WA_FCLM_S_FA_BKH_STR-DATE_INDICATOR sy-vline      INTO ld_text SEPARATED BY SPACE.

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