ABAP Select data from SAP table FARR_S_CONS 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 FARR_S_CONS 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 FARR_S_CONS. 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 FARR_S_CONS 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_FARR_S_CONS TYPE STANDARD TABLE OF FARR_S_CONS,
      WA_FARR_S_CONS TYPE FARR_S_CONS,
      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: <FARR_S_CONS> TYPE FARR_S_CONS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FARR_S_CONS
*  INTO TABLE @DATA(IT_FARR_S_CONS2).
*--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_FARR_S_CONS INDEX 1 INTO DATA(WA_FARR_S_CONS2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FARR_S_CONS>-ACCT_PRINCIPLE = 1.
<FARR_S_CONS>-POST_LIAB_TX = 1.
<FARR_S_CONS>-POST_MODE_TX = 1.
<FARR_S_CONS>-POST_LIAB = 1.
<FARR_S_CONS>-POB_ROLE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FARR_S_CONS-LC_CALC_METHOD, sy-vline,
  WA_FARR_S_CONS-LEADING_POB_ID, sy-vline,
  WA_FARR_S_CONS-HI_LEVEL_POB_ID, sy-vline,
  WA_FARR_S_CONS-PREVENT_ALLOC, sy-vline,
  WA_FARR_S_CONS-BOM_POB_ID, sy-vline,
  WA_FARR_S_CONS-DISTINCT_TYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FARR_S_CONS 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_FARR_S_CONS 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_FARR_S_CONS INTO WA_FARR_S_CONS.


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

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

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

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

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

*Conversion exit RRQUT, internal->external for field QUANTITY
CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT'
  EXPORTING
    input =                      WA_FARR_S_CONS-QUANTITY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_CONS-QUANTITY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RRQUT, internal->external for field EFFECTIVE_QTY
CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT'
  EXPORTING
    input =                      WA_FARR_S_CONS-EFFECTIVE_QTY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_CONS-EFFECTIVE_QTY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RRQUT, internal->external for field SUM_FULFIL_QUANT
CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT'
  EXPORTING
    input =                      WA_FARR_S_CONS-SUM_FULFIL_QUANT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_CONS-SUM_FULFIL_QUANT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RRQUT, internal->external for field SUM_FULQ_PEND
CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT'
  EXPORTING
    input =                      WA_FARR_S_CONS-SUM_FULQ_PEND
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_CONS-SUM_FULQ_PEND.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RRQUT, internal->external for field SUM_FULQ_BOOKED
CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT'
  EXPORTING
    input =                      WA_FARR_S_CONS-SUM_FULQ_BOOKED
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_CONS-SUM_FULQ_BOOKED.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RRQUT, internal->external for field SUM_REV_QTY_DELTA
CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT'
  EXPORTING
    input =                      WA_FARR_S_CONS-SUM_REV_QTY_DELTA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_CONS-SUM_REV_QTY_DELTA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RRQUT, internal->external for field REPORTED_QTY
CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT'
  EXPORTING
    input =                      WA_FARR_S_CONS-REPORTED_QTY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_CONS-REPORTED_QTY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RRQUT, internal->external for field DEFITEM_QTY
CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT'
  EXPORTING
    input =                      WA_FARR_S_CONS-DEFITEM_QTY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_CONS-DEFITEM_QTY.
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_FARR_S_CONS_STR, 
ACCT_PRINCIPLE TYPE STRING,
POST_LIAB_TX TYPE STRING,
POST_MODE_TX TYPE STRING,
POST_LIAB TYPE STRING,
POB_ROLE TYPE STRING,
LC_CALC_METHOD TYPE STRING,
LEADING_POB_ID TYPE STRING,
HI_LEVEL_POB_ID TYPE STRING,
PREVENT_ALLOC TYPE STRING,
BOM_POB_ID TYPE STRING,
DISTINCT_TYPE TYPE STRING,
FULFILL_TYPE TYPE STRING,
EVENT_TYPE TYPE STRING,
VALUE_RELEVANT TYPE STRING,
START_DATE_TYPE TYPE STRING,
FULLY_FULFILLED TYPE STRING,
FINAL_INVOICE TYPE STRING,
REV_REC_BLOCK TYPE STRING,
SOFT_DELETED TYPE STRING,
MANUAL_CREATED TYPE STRING,
MANUAL_DELETED TYPE STRING,
SOURCE_OF_PRICE TYPE STRING,
VALIDATE_RESULT TYPE STRING,
PENDING_CONFLICT TYPE STRING,
CONTRACT_STATUS TYPE STRING,
STATUS TYPE STRING,
PAOBJNR TYPE STRING,
KDAUF TYPE STRING,
KDPOS TYPE STRING,
QUANTITY_UNIT TYPE STRING,
QUANTITY TYPE STRING,
EFFECTIVE_QTY TYPE STRING,
SUM_FULFIL_QUANT TYPE STRING,
SUM_FULQ_PEND TYPE STRING,
SUM_FULQ_BOOKED TYPE STRING,
SUM_REV_QTY_DELTA TYPE STRING,
REPORTED_QTY TYPE STRING,
DEFITEM_QTY TYPE STRING,
SSP_CURK TYPE STRING,
TRX_PRICE TYPE STRING,
ALLOC_AMT TYPE STRING,
AFTER_ALLOC_AMT TYPE STRING,
SUM_REV_SCHED TYPE STRING,
SUM_TOTAL_PLAN_REV TYPE STRING,
SUM_PLAN_REV TYPE STRING,
SUM_BOOK_REV TYPE STRING,
SUM_PLAN_INV TYPE STRING,
SUM_BOOK_INV TYPE STRING,
SUM_PLAN_REV_A TYPE STRING,
SUM_BOOK_REV_A TYPE STRING,
SUM_PLAN_INV_A TYPE STRING,
SUM_BOOK_INV_A TYPE STRING,
SUM_PLAN_REV_CLOSE TYPE STRING,
SUM_BOOK_REV_CLOSE TYPE STRING,
SUM_PLAN_INV_CLOSE TYPE STRING,
SUM_BOOK_INV_CLOSE TYPE STRING,
SUM_TRANSF_INV TYPE STRING,
SUM_ALL_IC TYPE STRING,
SUM_REC_ADJ TYPE STRING,
SUM_REC_ADJ_LC TYPE STRING,
SUM_TR_INV_LC TYPE STRING,
SUM_ALL_IC_LC TYPE STRING,
SUM_INV_AMT_CALC TYPE STRING,
SUM_FX_ED_INV TYPE STRING,
LOCAL_CURR TYPE STRING,
SUM_REC_ADJ_LC1 TYPE STRING,
SUM_TR_INV_LC1 TYPE STRING,
SUM_ALL_IC_LC1 TYPE STRING,
SUM_INV_AMT_CALC_LC1 TYPE STRING,
SUM_FX_ED_INV_LC1 TYPE STRING,
SUM_FX_ED_LC1 TYPE STRING,
SUM_FX_ED_BOOK_LC1 TYPE STRING,
LOCAL_CURR1 TYPE STRING,
SUM_REC_ADJ_LC2 TYPE STRING,
SUM_TR_INV_LC2 TYPE STRING,
SUM_ALL_IC_LC2 TYPE STRING,
SUM_INV_AMT_CALC_LC2 TYPE STRING,
SUM_FX_ED_INV_LC2 TYPE STRING,
SUM_FX_ED_LC2 TYPE STRING,
SUM_FX_ED_BOOK_LC2 TYPE STRING,
LOCAL_CURR2 TYPE STRING,
SUM_REC_ADJ_LC3 TYPE STRING,
SUM_TR_INV_LC3 TYPE STRING,
SUM_ALL_IC_LC3 TYPE STRING,
SUM_INV_AMT_CALC_LC3 TYPE STRING,
SUM_FX_ED_INV_LC3 TYPE STRING,
SUM_FX_ED_LC3 TYPE STRING,
SUM_FX_ED_BOOK_LC3 TYPE STRING,
LOCAL_CURR3 TYPE STRING,
SUM_PLAN_LIAB TYPE STRING,
SUM_BOOK_LIAB TYPE STRING,
SUM_PLAN_ASSET TYPE STRING,
SUM_BOOK_ASSET TYPE STRING,
MANUAL_SPREADING TYPE STRING,
SPREAD_CONFLICT TYPE STRING,
MANUAL_SPREAD_AMT TYPE STRING,
MANUAL_SPREAD_CONFLICT TYPE STRING,
MANUAL_SPREAD_EXIST TYPE STRING,
MANUAL_ALLOC_COND_MIS TYPE STRING,
MANUAL_ANY_CONFLICT TYPE STRING,
ERR01 TYPE STRING,
ERR02 TYPE STRING,
ERR03 TYPE STRING,
ERR04 TYPE STRING,
ERR05 TYPE STRING,
ERR06 TYPE STRING,
ERR07 TYPE STRING,
ERR08 TYPE STRING,
ERR09 TYPE STRING,
ERR10 TYPE STRING,
ERR11 TYPE STRING,
ERR12 TYPE STRING,
ERR13 TYPE STRING,
ERR14 TYPE STRING,
ERR15 TYPE STRING,
ERR16 TYPE STRING,
ERR17 TYPE STRING,
ERR18 TYPE STRING,
ERR19 TYPE STRING,
ERR22 TYPE STRING,
ERR25 TYPE STRING,
ERR29 TYPE STRING,
ERR30 TYPE STRING,
ERDAT TYPE STRING,
ERZEIT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FARR_S_CONS_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_FARR_S_CONS_STR-ACCT_PRINCIPLE sy-vline 
WA_FARR_S_CONS_STR-POST_LIAB_TX sy-vline 
WA_FARR_S_CONS_STR-POST_MODE_TX sy-vline 
WA_FARR_S_CONS_STR-POST_LIAB sy-vline 
WA_FARR_S_CONS_STR-POB_ROLE sy-vline 
WA_FARR_S_CONS_STR-LC_CALC_METHOD sy-vline 
WA_FARR_S_CONS_STR-LEADING_POB_ID sy-vline 
WA_FARR_S_CONS_STR-HI_LEVEL_POB_ID sy-vline 
WA_FARR_S_CONS_STR-PREVENT_ALLOC sy-vline 
WA_FARR_S_CONS_STR-BOM_POB_ID sy-vline 
WA_FARR_S_CONS_STR-DISTINCT_TYPE sy-vline 
WA_FARR_S_CONS_STR-FULFILL_TYPE sy-vline 
WA_FARR_S_CONS_STR-EVENT_TYPE sy-vline 
WA_FARR_S_CONS_STR-VALUE_RELEVANT sy-vline 
WA_FARR_S_CONS_STR-START_DATE_TYPE sy-vline 
WA_FARR_S_CONS_STR-FULLY_FULFILLED sy-vline 
WA_FARR_S_CONS_STR-FINAL_INVOICE sy-vline 
WA_FARR_S_CONS_STR-REV_REC_BLOCK sy-vline 
WA_FARR_S_CONS_STR-SOFT_DELETED sy-vline 
WA_FARR_S_CONS_STR-MANUAL_CREATED sy-vline 
WA_FARR_S_CONS_STR-MANUAL_DELETED sy-vline 
WA_FARR_S_CONS_STR-SOURCE_OF_PRICE sy-vline 
WA_FARR_S_CONS_STR-VALIDATE_RESULT sy-vline 
WA_FARR_S_CONS_STR-PENDING_CONFLICT sy-vline 
WA_FARR_S_CONS_STR-CONTRACT_STATUS sy-vline 
WA_FARR_S_CONS_STR-STATUS sy-vline 
WA_FARR_S_CONS_STR-PAOBJNR sy-vline 
WA_FARR_S_CONS_STR-KDAUF sy-vline 
WA_FARR_S_CONS_STR-KDPOS sy-vline 
WA_FARR_S_CONS_STR-QUANTITY_UNIT sy-vline 
WA_FARR_S_CONS_STR-QUANTITY sy-vline 
WA_FARR_S_CONS_STR-EFFECTIVE_QTY sy-vline 
WA_FARR_S_CONS_STR-SUM_FULFIL_QUANT sy-vline 
WA_FARR_S_CONS_STR-SUM_FULQ_PEND sy-vline 
WA_FARR_S_CONS_STR-SUM_FULQ_BOOKED sy-vline 
WA_FARR_S_CONS_STR-SUM_REV_QTY_DELTA sy-vline 
WA_FARR_S_CONS_STR-REPORTED_QTY sy-vline 
WA_FARR_S_CONS_STR-DEFITEM_QTY sy-vline 
WA_FARR_S_CONS_STR-SSP_CURK sy-vline 
WA_FARR_S_CONS_STR-TRX_PRICE sy-vline 
WA_FARR_S_CONS_STR-ALLOC_AMT sy-vline 
WA_FARR_S_CONS_STR-AFTER_ALLOC_AMT sy-vline 
WA_FARR_S_CONS_STR-SUM_REV_SCHED sy-vline 
WA_FARR_S_CONS_STR-SUM_TOTAL_PLAN_REV sy-vline 
WA_FARR_S_CONS_STR-SUM_PLAN_REV sy-vline 
WA_FARR_S_CONS_STR-SUM_BOOK_REV sy-vline 
WA_FARR_S_CONS_STR-SUM_PLAN_INV sy-vline 
WA_FARR_S_CONS_STR-SUM_BOOK_INV sy-vline 
WA_FARR_S_CONS_STR-SUM_PLAN_REV_A sy-vline 
WA_FARR_S_CONS_STR-SUM_BOOK_REV_A sy-vline 
WA_FARR_S_CONS_STR-SUM_PLAN_INV_A sy-vline 
WA_FARR_S_CONS_STR-SUM_BOOK_INV_A sy-vline 
WA_FARR_S_CONS_STR-SUM_PLAN_REV_CLOSE sy-vline 
WA_FARR_S_CONS_STR-SUM_BOOK_REV_CLOSE sy-vline 
WA_FARR_S_CONS_STR-SUM_PLAN_INV_CLOSE sy-vline 
WA_FARR_S_CONS_STR-SUM_BOOK_INV_CLOSE sy-vline 
WA_FARR_S_CONS_STR-SUM_TRANSF_INV sy-vline 
WA_FARR_S_CONS_STR-SUM_ALL_IC sy-vline 
WA_FARR_S_CONS_STR-SUM_REC_ADJ sy-vline 
WA_FARR_S_CONS_STR-SUM_REC_ADJ_LC sy-vline 
WA_FARR_S_CONS_STR-SUM_TR_INV_LC sy-vline 
WA_FARR_S_CONS_STR-SUM_ALL_IC_LC sy-vline 
WA_FARR_S_CONS_STR-SUM_INV_AMT_CALC sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_INV sy-vline 
WA_FARR_S_CONS_STR-LOCAL_CURR sy-vline 
WA_FARR_S_CONS_STR-SUM_REC_ADJ_LC1 sy-vline 
WA_FARR_S_CONS_STR-SUM_TR_INV_LC1 sy-vline 
WA_FARR_S_CONS_STR-SUM_ALL_IC_LC1 sy-vline 
WA_FARR_S_CONS_STR-SUM_INV_AMT_CALC_LC1 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_INV_LC1 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_LC1 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_BOOK_LC1 sy-vline 
WA_FARR_S_CONS_STR-LOCAL_CURR1 sy-vline 
WA_FARR_S_CONS_STR-SUM_REC_ADJ_LC2 sy-vline 
WA_FARR_S_CONS_STR-SUM_TR_INV_LC2 sy-vline 
WA_FARR_S_CONS_STR-SUM_ALL_IC_LC2 sy-vline 
WA_FARR_S_CONS_STR-SUM_INV_AMT_CALC_LC2 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_INV_LC2 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_LC2 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_BOOK_LC2 sy-vline 
WA_FARR_S_CONS_STR-LOCAL_CURR2 sy-vline 
WA_FARR_S_CONS_STR-SUM_REC_ADJ_LC3 sy-vline 
WA_FARR_S_CONS_STR-SUM_TR_INV_LC3 sy-vline 
WA_FARR_S_CONS_STR-SUM_ALL_IC_LC3 sy-vline 
WA_FARR_S_CONS_STR-SUM_INV_AMT_CALC_LC3 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_INV_LC3 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_LC3 sy-vline 
WA_FARR_S_CONS_STR-SUM_FX_ED_BOOK_LC3 sy-vline 
WA_FARR_S_CONS_STR-LOCAL_CURR3 sy-vline 
WA_FARR_S_CONS_STR-SUM_PLAN_LIAB sy-vline 
WA_FARR_S_CONS_STR-SUM_BOOK_LIAB sy-vline 
WA_FARR_S_CONS_STR-SUM_PLAN_ASSET sy-vline 
WA_FARR_S_CONS_STR-SUM_BOOK_ASSET sy-vline 
WA_FARR_S_CONS_STR-MANUAL_SPREADING sy-vline 
WA_FARR_S_CONS_STR-SPREAD_CONFLICT sy-vline 
WA_FARR_S_CONS_STR-MANUAL_SPREAD_AMT sy-vline 
WA_FARR_S_CONS_STR-MANUAL_SPREAD_CONFLICT sy-vline 
WA_FARR_S_CONS_STR-MANUAL_SPREAD_EXIST sy-vline 
WA_FARR_S_CONS_STR-MANUAL_ALLOC_COND_MIS sy-vline 
WA_FARR_S_CONS_STR-MANUAL_ANY_CONFLICT sy-vline 
WA_FARR_S_CONS_STR-ERR01 sy-vline 
WA_FARR_S_CONS_STR-ERR02 sy-vline 
WA_FARR_S_CONS_STR-ERR03 sy-vline 
WA_FARR_S_CONS_STR-ERR04 sy-vline 
WA_FARR_S_CONS_STR-ERR05 sy-vline 
WA_FARR_S_CONS_STR-ERR06 sy-vline 
WA_FARR_S_CONS_STR-ERR07 sy-vline 
WA_FARR_S_CONS_STR-ERR08 sy-vline 
WA_FARR_S_CONS_STR-ERR09 sy-vline 
WA_FARR_S_CONS_STR-ERR10 sy-vline 
WA_FARR_S_CONS_STR-ERR11 sy-vline 
WA_FARR_S_CONS_STR-ERR12 sy-vline 
WA_FARR_S_CONS_STR-ERR13 sy-vline 
WA_FARR_S_CONS_STR-ERR14 sy-vline 
WA_FARR_S_CONS_STR-ERR15 sy-vline 
WA_FARR_S_CONS_STR-ERR16 sy-vline 
WA_FARR_S_CONS_STR-ERR17 sy-vline 
WA_FARR_S_CONS_STR-ERR18 sy-vline 
WA_FARR_S_CONS_STR-ERR19 sy-vline 
WA_FARR_S_CONS_STR-ERR22 sy-vline 
WA_FARR_S_CONS_STR-ERR25 sy-vline 
WA_FARR_S_CONS_STR-ERR29 sy-vline 
WA_FARR_S_CONS_STR-ERR30 sy-vline 
WA_FARR_S_CONS_STR-ERDAT sy-vline 
WA_FARR_S_CONS_STR-ERZEIT sy-vline      INTO ld_text SEPARATED BY SPACE.

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