ABAP Select data from SAP table FARR_S_BIZ_RECON into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP FARR_S_BIZ_RECON 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_BIZ_RECON. 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_BIZ_RECON 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_BIZ_RECON TYPE STANDARD TABLE OF FARR_S_BIZ_RECON,
      WA_FARR_S_BIZ_RECON TYPE FARR_S_BIZ_RECON,
      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_BIZ_RECON> TYPE FARR_S_BIZ_RECON.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FARR_S_BIZ_RECON
*  INTO TABLE @DATA(IT_FARR_S_BIZ_RECON2).
*--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_BIZ_RECON INDEX 1 INTO DATA(WA_FARR_S_BIZ_RECON2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FARR_S_BIZ_RECON ASSIGNING <FARR_S_BIZ_RECON>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FARR_S_BIZ_RECON>-MANDT = 1.
<FARR_S_BIZ_RECON>-COMPANY_CODE = 1.
<FARR_S_BIZ_RECON>-ACCT_PRINCIPLE = 1.
<FARR_S_BIZ_RECON>-CONTRACT_ID = 1.
<FARR_S_BIZ_RECON>-POB_ID = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FARR_S_BIZ_RECON-CONDITION_TYPE, sy-vline,
WA_FARR_S_BIZ_RECON-ACCT_PERIOD, sy-vline,
WA_FARR_S_BIZ_RECON-EXEC_TYPE, sy-vline,
WA_FARR_S_BIZ_RECON-GJAHR, sy-vline,
WA_FARR_S_BIZ_RECON-POPER, sy-vline,
WA_FARR_S_BIZ_RECON-POB_TYPE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FARR_S_BIZ_RECON 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_BIZ_RECON 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_BIZ_RECON INTO WA_FARR_S_BIZ_RECON. *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 CONTRACT_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FARR_S_BIZ_RECON-CONTRACT_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_BIZ_RECON-CONTRACT_ID.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit RRQUT, internal->external for field QUANTITY CALL FUNCTION 'CONVERSION_EXIT_RRQUT_OUTPUT' EXPORTING input = WA_FARR_S_BIZ_RECON-QUANTITY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_BIZ_RECON-QUANTITY.
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_BIZ_RECON-QUANTITY_UNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_BIZ_RECON-QUANTITY_UNIT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ABPSN, internal->external for field PS_POSID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_FARR_S_BIZ_RECON-PS_POSID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FARR_S_BIZ_RECON-PS_POSID.
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_BIZ_RECON_STR,
MANDT TYPE STRING,
COMPANY_CODE TYPE STRING,
ACCT_PRINCIPLE TYPE STRING,
CONTRACT_ID TYPE STRING,
POB_ID TYPE STRING,
CONDITION_TYPE TYPE STRING,
ACCT_PERIOD TYPE STRING,
EXEC_TYPE TYPE STRING,
GJAHR TYPE STRING,
POPER TYPE STRING,
POB_TYPE TYPE STRING,
REFERENCE_TYPE TYPE STRING,
REFERENCE_ID TYPE STRING,
HEADER_ID TYPE STRING,
ITEM_ID TYPE STRING,
CUSTOMER_ID TYPE STRING,
PARTNER TYPE STRING,
CUST_NAME TYPE STRING,
OP_COND_PRICE TYPE STRING,
OP_COND_COST TYPE STRING,
OPERATION_CURR TYPE STRING,
INVOICE_AMOUNT TYPE STRING,
INVOICE_CURRENCY TYPE STRING,
INVOICE_AMOUNT_LC1 TYPE STRING,
INVOICE_CURRENCY_LC1 TYPE STRING,
INVOICE_AMOUNT_LC2 TYPE STRING,
INVOICE_CURRENCY_LC2 TYPE STRING,
INVOICE_AMOUNT_LC3 TYPE STRING,
INVOICE_CURRENCY_LC3 TYPE STRING,
COST_AMOUNT TYPE STRING,
COST_CURRENCY TYPE STRING,
OP_QUANTITY TYPE STRING,
QUANTITY TYPE STRING,
QUANTITY_UNIT TYPE STRING,
MATERIAL TYPE STRING,
MAT_DESC TYPE STRING,
TRX_PRICE TYPE STRING,
TRX_PRICE_ORG TYPE STRING,
WAERS TYPE STRING,
SSP TYPE STRING,
COST_AMT TYPE STRING,
ALLOC_AMT TYPE STRING,
SCHED_RV TYPE STRING,
SCHED_RV_CUMLTV TYPE STRING,
SCHED_CO TYPE STRING,
SCHED_CO_CUMLTV TYPE STRING,
SCHED_IC TYPE STRING,
SCHED_IC_CUMLTV TYPE STRING,
POST_RV TYPE STRING,
POST_IC TYPE STRING,
POST_CO TYPE STRING,
POST_UR TYPE STRING,
POST_DR TYPE STRING,
POST_CA TYPE STRING,
POST_CL TYPE STRING,
POST_CJ TYPE STRING,
LOCAL_CURK1 TYPE STRING,
POST_RV_LC1 TYPE STRING,
POST_IC_LC1 TYPE STRING,
POST_CO_LC1 TYPE STRING,
POST_UR_LC1 TYPE STRING,
POST_DR_LC1 TYPE STRING,
POST_CA_LC1 TYPE STRING,
POST_CL_LC1 TYPE STRING,
POST_CJ_LC1 TYPE STRING,
LOCAL_CURK2 TYPE STRING,
POST_RV_LC2 TYPE STRING,
POST_IC_LC2 TYPE STRING,
POST_CO_LC2 TYPE STRING,
POST_UR_LC2 TYPE STRING,
POST_DR_LC2 TYPE STRING,
POST_CA_LC2 TYPE STRING,
POST_CL_LC2 TYPE STRING,
POST_CJ_LC2 TYPE STRING,
LOCAL_CURK3 TYPE STRING,
POST_RV_LC3 TYPE STRING,
POST_IC_LC3 TYPE STRING,
POST_CO_LC3 TYPE STRING,
POST_UR_LC3 TYPE STRING,
POST_DR_LC3 TYPE STRING,
POST_CA_LC3 TYPE STRING,
POST_CL_LC3 TYPE STRING,
POST_CJ_LC3 TYPE STRING,
LIAB_ASSET_FLAG TYPE STRING,
DV_RESULT TYPE STRING,
DV_TIMESTAMP TYPE STRING,
UNPROC_RAI TYPE STRING,
CONFLICT TYPE STRING,
POB_STATUS TYPE STRING,
STATUS TYPE STRING,
SUSPEND_FLAG TYPE STRING,
GL_ACC_IC_CC TYPE STRING,
GL_ACC_RV_CO TYPE STRING,
FKBER TYPE STRING,
GSBER TYPE STRING,
SEGMENT TYPE STRING,
PRCTR TYPE STRING,
PAOBJNR TYPE STRING,
KOSTL TYPE STRING,
AUFNR TYPE STRING,
KDAUF TYPE STRING,
KDPOS TYPE STRING,
PS_POSID TYPE STRING,
REMARKS TYPE STRING,
UNAME TYPE STRING,
TIMESTAMP TYPE STRING,END OF T_EKKO_STR. DATA: WA_FARR_S_BIZ_RECON_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_BIZ_RECON_STR-MANDT sy-vline
WA_FARR_S_BIZ_RECON_STR-COMPANY_CODE sy-vline
WA_FARR_S_BIZ_RECON_STR-ACCT_PRINCIPLE sy-vline
WA_FARR_S_BIZ_RECON_STR-CONTRACT_ID sy-vline
WA_FARR_S_BIZ_RECON_STR-POB_ID sy-vline
WA_FARR_S_BIZ_RECON_STR-CONDITION_TYPE sy-vline
WA_FARR_S_BIZ_RECON_STR-ACCT_PERIOD sy-vline
WA_FARR_S_BIZ_RECON_STR-EXEC_TYPE sy-vline
WA_FARR_S_BIZ_RECON_STR-GJAHR sy-vline
WA_FARR_S_BIZ_RECON_STR-POPER sy-vline
WA_FARR_S_BIZ_RECON_STR-POB_TYPE sy-vline
WA_FARR_S_BIZ_RECON_STR-REFERENCE_TYPE sy-vline
WA_FARR_S_BIZ_RECON_STR-REFERENCE_ID sy-vline
WA_FARR_S_BIZ_RECON_STR-HEADER_ID sy-vline
WA_FARR_S_BIZ_RECON_STR-ITEM_ID sy-vline
WA_FARR_S_BIZ_RECON_STR-CUSTOMER_ID sy-vline
WA_FARR_S_BIZ_RECON_STR-PARTNER sy-vline
WA_FARR_S_BIZ_RECON_STR-CUST_NAME sy-vline
WA_FARR_S_BIZ_RECON_STR-OP_COND_PRICE sy-vline
WA_FARR_S_BIZ_RECON_STR-OP_COND_COST sy-vline
WA_FARR_S_BIZ_RECON_STR-OPERATION_CURR sy-vline
WA_FARR_S_BIZ_RECON_STR-INVOICE_AMOUNT sy-vline
WA_FARR_S_BIZ_RECON_STR-INVOICE_CURRENCY sy-vline
WA_FARR_S_BIZ_RECON_STR-INVOICE_AMOUNT_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-INVOICE_CURRENCY_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-INVOICE_AMOUNT_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-INVOICE_CURRENCY_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-INVOICE_AMOUNT_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-INVOICE_CURRENCY_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-COST_AMOUNT sy-vline
WA_FARR_S_BIZ_RECON_STR-COST_CURRENCY sy-vline
WA_FARR_S_BIZ_RECON_STR-OP_QUANTITY sy-vline
WA_FARR_S_BIZ_RECON_STR-QUANTITY sy-vline
WA_FARR_S_BIZ_RECON_STR-QUANTITY_UNIT sy-vline
WA_FARR_S_BIZ_RECON_STR-MATERIAL sy-vline
WA_FARR_S_BIZ_RECON_STR-MAT_DESC sy-vline
WA_FARR_S_BIZ_RECON_STR-TRX_PRICE sy-vline
WA_FARR_S_BIZ_RECON_STR-TRX_PRICE_ORG sy-vline
WA_FARR_S_BIZ_RECON_STR-WAERS sy-vline
WA_FARR_S_BIZ_RECON_STR-SSP sy-vline
WA_FARR_S_BIZ_RECON_STR-COST_AMT sy-vline
WA_FARR_S_BIZ_RECON_STR-ALLOC_AMT sy-vline
WA_FARR_S_BIZ_RECON_STR-SCHED_RV sy-vline
WA_FARR_S_BIZ_RECON_STR-SCHED_RV_CUMLTV sy-vline
WA_FARR_S_BIZ_RECON_STR-SCHED_CO sy-vline
WA_FARR_S_BIZ_RECON_STR-SCHED_CO_CUMLTV sy-vline
WA_FARR_S_BIZ_RECON_STR-SCHED_IC sy-vline
WA_FARR_S_BIZ_RECON_STR-SCHED_IC_CUMLTV sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_RV sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_IC sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CO sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_UR sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_DR sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CA sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CL sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CJ sy-vline
WA_FARR_S_BIZ_RECON_STR-LOCAL_CURK1 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_RV_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_IC_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CO_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_UR_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_DR_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CA_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CL_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CJ_LC1 sy-vline
WA_FARR_S_BIZ_RECON_STR-LOCAL_CURK2 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_RV_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_IC_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CO_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_UR_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_DR_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CA_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CL_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CJ_LC2 sy-vline
WA_FARR_S_BIZ_RECON_STR-LOCAL_CURK3 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_RV_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_IC_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CO_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_UR_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_DR_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CA_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CL_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-POST_CJ_LC3 sy-vline
WA_FARR_S_BIZ_RECON_STR-LIAB_ASSET_FLAG sy-vline
WA_FARR_S_BIZ_RECON_STR-DV_RESULT sy-vline
WA_FARR_S_BIZ_RECON_STR-DV_TIMESTAMP sy-vline
WA_FARR_S_BIZ_RECON_STR-UNPROC_RAI sy-vline
WA_FARR_S_BIZ_RECON_STR-CONFLICT sy-vline
WA_FARR_S_BIZ_RECON_STR-POB_STATUS sy-vline
WA_FARR_S_BIZ_RECON_STR-STATUS sy-vline
WA_FARR_S_BIZ_RECON_STR-SUSPEND_FLAG sy-vline
WA_FARR_S_BIZ_RECON_STR-GL_ACC_IC_CC sy-vline
WA_FARR_S_BIZ_RECON_STR-GL_ACC_RV_CO sy-vline
WA_FARR_S_BIZ_RECON_STR-FKBER sy-vline
WA_FARR_S_BIZ_RECON_STR-GSBER sy-vline
WA_FARR_S_BIZ_RECON_STR-SEGMENT sy-vline
WA_FARR_S_BIZ_RECON_STR-PRCTR sy-vline
WA_FARR_S_BIZ_RECON_STR-PAOBJNR sy-vline
WA_FARR_S_BIZ_RECON_STR-KOSTL sy-vline
WA_FARR_S_BIZ_RECON_STR-AUFNR sy-vline
WA_FARR_S_BIZ_RECON_STR-KDAUF sy-vline
WA_FARR_S_BIZ_RECON_STR-KDPOS sy-vline
WA_FARR_S_BIZ_RECON_STR-PS_POSID sy-vline
WA_FARR_S_BIZ_RECON_STR-REMARKS sy-vline
WA_FARR_S_BIZ_RECON_STR-UNAME sy-vline
WA_FARR_S_BIZ_RECON_STR-TIMESTAMP sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.