ABAP Select data from SAP table /XFT/INV_VIEW1 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 /XFT/INV_VIEW1 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 /XFT/INV_VIEW1. 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 /XFT/INV_VIEW1 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_/XFT/INV_VIEW1 TYPE STANDARD TABLE OF /XFT/INV_VIEW1,
      WA_/XFT/INV_VIEW1 TYPE /XFT/INV_VIEW1,
      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: </XFT/INV_VIEW1> TYPE /XFT/INV_VIEW1.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /XFT/INV_VIEW1
  INTO TABLE IT_/XFT/INV_VIEW1.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /XFT/INV_VIEW1
*  INTO TABLE @DATA(IT_/XFT/INV_VIEW12).
*--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_/XFT/INV_VIEW1 INDEX 1 INTO DATA(WA_/XFT/INV_VIEW12).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/XFT/INV_VIEW1 ASSIGNING </XFT/INV_VIEW1>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</XFT/INV_VIEW1>-MANDT = 1.
</XFT/INV_VIEW1>-PROCESS_ID = 1.
</XFT/INV_VIEW1>-GUID = 1.
</XFT/INV_VIEW1>-INV_TYPE = 1.
</XFT/INV_VIEW1>-PROCESS_ID_CHILD = 1.

ENDLOOP.

LOOP AT IT_/XFT/INV_VIEW1 INTO WA_/XFT/INV_VIEW1.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/XFT/INV_VIEW1-RATING, sy-vline,
  WA_/XFT/INV_VIEW1-FOLLOW_ON_DOC, sy-vline,
  WA_/XFT/INV_VIEW1-STATUS, sy-vline,
  WA_/XFT/INV_VIEW1-SYST_STATUS, sy-vline,
  WA_/XFT/INV_VIEW1-CREATE_DATE, sy-vline,
  WA_/XFT/INV_VIEW1-CREATE_TIME, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/XFT/INV_VIEW1 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_/XFT/INV_VIEW1 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_/XFT/INV_VIEW1 INTO WA_/XFT/INV_VIEW1.


*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 GJAHR, internal->external for field INV_DOC_YEAR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_/XFT/INV_VIEW1-INV_DOC_YEAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/XFT/INV_VIEW1-INV_DOC_YEAR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ISOLA, internal->external for field LANGU
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_/XFT/INV_VIEW1-LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/XFT/INV_VIEW1-LANGU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PO_NUMBER
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/XFT/INV_VIEW1-PO_NUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/XFT/INV_VIEW1-PO_NUMBER.
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_/XFT/INV_VIEW1_STR, 
MANDT TYPE STRING,
PROCESS_ID TYPE STRING,
GUID TYPE STRING,
INV_TYPE TYPE STRING,
PROCESS_ID_CHILD TYPE STRING,
RATING TYPE STRING,
FOLLOW_ON_DOC TYPE STRING,
STATUS TYPE STRING,
SYST_STATUS TYPE STRING,
CREATE_DATE TYPE STRING,
CREATE_TIME TYPE STRING,
CHANGE_DATE TYPE STRING,
CHANGE_TIME TYPE STRING,
CHANGE_USER TYPE STRING,
MESS_EX TYPE STRING,
ITER_NUM_VAL TYPE STRING,
ITERATION_NUM TYPE STRING,
PROCESS_TYPE_DIS TYPE STRING,
PROCESS_TYPE TYPE STRING,
PROCESS_TYPE_VAL TYPE STRING,
RECORD_ID TYPE STRING,
TIMESTAMP TYPE STRING,
DOCUMENTS TYPE STRING,
DOC_STRUCNAME TYPE STRING,
MESSAGES TYPE STRING,
MESS_STRUCNAME TYPE STRING,
INV_DOC_NO TYPE STRING,
INV_DOC_YEAR TYPE STRING,
OBJECT_TYPE TYPE STRING,
MIRO_ICON TYPE STRING,
MRM_VORGANG TYPE STRING,
INVOICE_IND TYPE STRING,
DOC_TYPE TYPE STRING,
DOC_DATE TYPE STRING,
PSTNG_DATE TYPE STRING,
REF_DOC_NO TYPE STRING,
COMP_CODE TYPE STRING,
DIFF_INV TYPE STRING,
CURRENCY TYPE STRING,
CURRENCY_ISO TYPE STRING,
GROSS_AMOUNT TYPE STRING,
INV_REC_DATE TYPE STRING,
CALC_TAX_IND TYPE STRING,
BLINE_DATE TYPE STRING,
PMNTTRMS TYPE STRING,
DSCT_DAYS1 TYPE STRING,
DSCT_PCT1 TYPE STRING,
DSCT_DAYS2 TYPE STRING,
DSCT_PCT2 TYPE STRING,
NETTERMS TYPE STRING,
FIXEDTERMS TYPE STRING,
PMNT_BLOCK TYPE STRING,
DSCT_AMOUNT TYPE STRING,
PYMT_METH TYPE STRING,
INV_REF_NO TYPE STRING,
INV_YEAR TYPE STRING,
PARTNER_BK TYPE STRING,
HOUSEBANKID TYPE STRING,
EXCH_RATE TYPE STRING,
EXCH_RATE_V TYPE STRING,
IV_CATEGORY TYPE STRING,
DEL_COSTS TYPE STRING,
DEL_COSTS_TAXC TYPE STRING,
DEL_COSTS_TAXJ TYPE STRING,
PERSON_EXT TYPE STRING,
PMTMTHSUPL TYPE STRING,
SCBANK_IND TYPE STRING,
SUPCOUNTRY TYPE STRING,
BLLSRV_IND TYPE STRING,
REF_DOC_NO_LONG TYPE STRING,
PO_SUB_NO TYPE STRING,
PO_CHECKDG TYPE STRING,
PO_REF_NO TYPE STRING,
PAYEE_PAYER TYPE STRING,
ALLOC_NMBR TYPE STRING,
PAYMT_REF TYPE STRING,
PLANNING_LEVEL TYPE STRING,
PLANNING_DATE TYPE STRING,
BUS_AREA TYPE STRING,
LOT_NUMBER TYPE STRING,
ITEM_TEXT TYPE STRING,
J_1BNFTYPE TYPE STRING,
EU_TRIANG_DEAL TYPE STRING,
REPCOUNTRY TYPE STRING,
BU_PARTNER TYPE STRING,
NAME TYPE STRING,
NAME_2 TYPE STRING,
NAME_3 TYPE STRING,
NAME_4 TYPE STRING,
POSTL_CODE TYPE STRING,
CITY TYPE STRING,
COUNTRY TYPE STRING,
STREET TYPE STRING,
PO_BOX TYPE STRING,
POBX_PCD TYPE STRING,
REGION TYPE STRING,
FORM_OF_ADDR TYPE STRING,
LANGU TYPE STRING,
POBK_CURAC TYPE STRING,
BANK_ACCT TYPE STRING,
BANK_NO TYPE STRING,
BANK_CTRY TYPE STRING,
CTRL_KEY TYPE STRING,
BANK_REF TYPE STRING,
TAX_NO_1 TYPE STRING,
TAX_NO_2 TYPE STRING,
TAX_NO_3 TYPE STRING,
TAX_NO_4 TYPE STRING,
SLS_PUR_TX TYPE STRING,
EQUAL_TAX TYPE STRING,
TAX_CATEGORY TYPE STRING,
TAX_NO_TY TYPE STRING,
SOLE_PROP TYPE STRING,
VAT_REG_NO TYPE STRING,
USER_STATUS TYPE STRING,
PERSON_RESP TYPE STRING,
ORG_UNIT TYPE STRING,
DESCRIPTION TYPE STRING,
USER1 TYPE STRING,
USER2 TYPE STRING,
USER3 TYPE STRING,
USER4 TYPE STRING,
USER5 TYPE STRING,
USER6 TYPE STRING,
USER7 TYPE STRING,
USER8 TYPE STRING,
USER9 TYPE STRING,
USER10 TYPE STRING,
USER11 TYPE STRING,
USER12 TYPE STRING,
USER13 TYPE STRING,
USER14 TYPE STRING,
USER15 TYPE STRING,
MIRO TYPE STRING,
INVOICE_DOC_ITEM TYPE STRING,
PO_NUMBER TYPE STRING,
PO_ITEM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/XFT/INV_VIEW1_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_/XFT/INV_VIEW1_STR-MANDT sy-vline 
WA_/XFT/INV_VIEW1_STR-PROCESS_ID sy-vline 
WA_/XFT/INV_VIEW1_STR-GUID sy-vline 
WA_/XFT/INV_VIEW1_STR-INV_TYPE sy-vline 
WA_/XFT/INV_VIEW1_STR-PROCESS_ID_CHILD sy-vline 
WA_/XFT/INV_VIEW1_STR-RATING sy-vline 
WA_/XFT/INV_VIEW1_STR-FOLLOW_ON_DOC sy-vline 
WA_/XFT/INV_VIEW1_STR-STATUS sy-vline 
WA_/XFT/INV_VIEW1_STR-SYST_STATUS sy-vline 
WA_/XFT/INV_VIEW1_STR-CREATE_DATE sy-vline 
WA_/XFT/INV_VIEW1_STR-CREATE_TIME sy-vline 
WA_/XFT/INV_VIEW1_STR-CHANGE_DATE sy-vline 
WA_/XFT/INV_VIEW1_STR-CHANGE_TIME sy-vline 
WA_/XFT/INV_VIEW1_STR-CHANGE_USER sy-vline 
WA_/XFT/INV_VIEW1_STR-MESS_EX sy-vline 
WA_/XFT/INV_VIEW1_STR-ITER_NUM_VAL sy-vline 
WA_/XFT/INV_VIEW1_STR-ITERATION_NUM sy-vline 
WA_/XFT/INV_VIEW1_STR-PROCESS_TYPE_DIS sy-vline 
WA_/XFT/INV_VIEW1_STR-PROCESS_TYPE sy-vline 
WA_/XFT/INV_VIEW1_STR-PROCESS_TYPE_VAL sy-vline 
WA_/XFT/INV_VIEW1_STR-RECORD_ID sy-vline 
WA_/XFT/INV_VIEW1_STR-TIMESTAMP sy-vline 
WA_/XFT/INV_VIEW1_STR-DOCUMENTS sy-vline 
WA_/XFT/INV_VIEW1_STR-DOC_STRUCNAME sy-vline 
WA_/XFT/INV_VIEW1_STR-MESSAGES sy-vline 
WA_/XFT/INV_VIEW1_STR-MESS_STRUCNAME sy-vline 
WA_/XFT/INV_VIEW1_STR-INV_DOC_NO sy-vline 
WA_/XFT/INV_VIEW1_STR-INV_DOC_YEAR sy-vline 
WA_/XFT/INV_VIEW1_STR-OBJECT_TYPE sy-vline 
WA_/XFT/INV_VIEW1_STR-MIRO_ICON sy-vline 
WA_/XFT/INV_VIEW1_STR-MRM_VORGANG sy-vline 
WA_/XFT/INV_VIEW1_STR-INVOICE_IND sy-vline 
WA_/XFT/INV_VIEW1_STR-DOC_TYPE sy-vline 
WA_/XFT/INV_VIEW1_STR-DOC_DATE sy-vline 
WA_/XFT/INV_VIEW1_STR-PSTNG_DATE sy-vline 
WA_/XFT/INV_VIEW1_STR-REF_DOC_NO sy-vline 
WA_/XFT/INV_VIEW1_STR-COMP_CODE sy-vline 
WA_/XFT/INV_VIEW1_STR-DIFF_INV sy-vline 
WA_/XFT/INV_VIEW1_STR-CURRENCY sy-vline 
WA_/XFT/INV_VIEW1_STR-CURRENCY_ISO sy-vline 
WA_/XFT/INV_VIEW1_STR-GROSS_AMOUNT sy-vline 
WA_/XFT/INV_VIEW1_STR-INV_REC_DATE sy-vline 
WA_/XFT/INV_VIEW1_STR-CALC_TAX_IND sy-vline 
WA_/XFT/INV_VIEW1_STR-BLINE_DATE sy-vline 
WA_/XFT/INV_VIEW1_STR-PMNTTRMS sy-vline 
WA_/XFT/INV_VIEW1_STR-DSCT_DAYS1 sy-vline 
WA_/XFT/INV_VIEW1_STR-DSCT_PCT1 sy-vline 
WA_/XFT/INV_VIEW1_STR-DSCT_DAYS2 sy-vline 
WA_/XFT/INV_VIEW1_STR-DSCT_PCT2 sy-vline 
WA_/XFT/INV_VIEW1_STR-NETTERMS sy-vline 
WA_/XFT/INV_VIEW1_STR-FIXEDTERMS sy-vline 
WA_/XFT/INV_VIEW1_STR-PMNT_BLOCK sy-vline 
WA_/XFT/INV_VIEW1_STR-DSCT_AMOUNT sy-vline 
WA_/XFT/INV_VIEW1_STR-PYMT_METH sy-vline 
WA_/XFT/INV_VIEW1_STR-INV_REF_NO sy-vline 
WA_/XFT/INV_VIEW1_STR-INV_YEAR sy-vline 
WA_/XFT/INV_VIEW1_STR-PARTNER_BK sy-vline 
WA_/XFT/INV_VIEW1_STR-HOUSEBANKID sy-vline 
WA_/XFT/INV_VIEW1_STR-EXCH_RATE sy-vline 
WA_/XFT/INV_VIEW1_STR-EXCH_RATE_V sy-vline 
WA_/XFT/INV_VIEW1_STR-IV_CATEGORY sy-vline 
WA_/XFT/INV_VIEW1_STR-DEL_COSTS sy-vline 
WA_/XFT/INV_VIEW1_STR-DEL_COSTS_TAXC sy-vline 
WA_/XFT/INV_VIEW1_STR-DEL_COSTS_TAXJ sy-vline 
WA_/XFT/INV_VIEW1_STR-PERSON_EXT sy-vline 
WA_/XFT/INV_VIEW1_STR-PMTMTHSUPL sy-vline 
WA_/XFT/INV_VIEW1_STR-SCBANK_IND sy-vline 
WA_/XFT/INV_VIEW1_STR-SUPCOUNTRY sy-vline 
WA_/XFT/INV_VIEW1_STR-BLLSRV_IND sy-vline 
WA_/XFT/INV_VIEW1_STR-REF_DOC_NO_LONG sy-vline 
WA_/XFT/INV_VIEW1_STR-PO_SUB_NO sy-vline 
WA_/XFT/INV_VIEW1_STR-PO_CHECKDG sy-vline 
WA_/XFT/INV_VIEW1_STR-PO_REF_NO sy-vline 
WA_/XFT/INV_VIEW1_STR-PAYEE_PAYER sy-vline 
WA_/XFT/INV_VIEW1_STR-ALLOC_NMBR sy-vline 
WA_/XFT/INV_VIEW1_STR-PAYMT_REF sy-vline 
WA_/XFT/INV_VIEW1_STR-PLANNING_LEVEL sy-vline 
WA_/XFT/INV_VIEW1_STR-PLANNING_DATE sy-vline 
WA_/XFT/INV_VIEW1_STR-BUS_AREA sy-vline 
WA_/XFT/INV_VIEW1_STR-LOT_NUMBER sy-vline 
WA_/XFT/INV_VIEW1_STR-ITEM_TEXT sy-vline 
WA_/XFT/INV_VIEW1_STR-J_1BNFTYPE sy-vline 
WA_/XFT/INV_VIEW1_STR-EU_TRIANG_DEAL sy-vline 
WA_/XFT/INV_VIEW1_STR-REPCOUNTRY sy-vline 
WA_/XFT/INV_VIEW1_STR-BU_PARTNER sy-vline 
WA_/XFT/INV_VIEW1_STR-NAME sy-vline 
WA_/XFT/INV_VIEW1_STR-NAME_2 sy-vline 
WA_/XFT/INV_VIEW1_STR-NAME_3 sy-vline 
WA_/XFT/INV_VIEW1_STR-NAME_4 sy-vline 
WA_/XFT/INV_VIEW1_STR-POSTL_CODE sy-vline 
WA_/XFT/INV_VIEW1_STR-CITY sy-vline 
WA_/XFT/INV_VIEW1_STR-COUNTRY sy-vline 
WA_/XFT/INV_VIEW1_STR-STREET sy-vline 
WA_/XFT/INV_VIEW1_STR-PO_BOX sy-vline 
WA_/XFT/INV_VIEW1_STR-POBX_PCD sy-vline 
WA_/XFT/INV_VIEW1_STR-REGION sy-vline 
WA_/XFT/INV_VIEW1_STR-FORM_OF_ADDR sy-vline 
WA_/XFT/INV_VIEW1_STR-LANGU sy-vline 
WA_/XFT/INV_VIEW1_STR-POBK_CURAC sy-vline 
WA_/XFT/INV_VIEW1_STR-BANK_ACCT sy-vline 
WA_/XFT/INV_VIEW1_STR-BANK_NO sy-vline 
WA_/XFT/INV_VIEW1_STR-BANK_CTRY sy-vline 
WA_/XFT/INV_VIEW1_STR-CTRL_KEY sy-vline 
WA_/XFT/INV_VIEW1_STR-BANK_REF sy-vline 
WA_/XFT/INV_VIEW1_STR-TAX_NO_1 sy-vline 
WA_/XFT/INV_VIEW1_STR-TAX_NO_2 sy-vline 
WA_/XFT/INV_VIEW1_STR-TAX_NO_3 sy-vline 
WA_/XFT/INV_VIEW1_STR-TAX_NO_4 sy-vline 
WA_/XFT/INV_VIEW1_STR-SLS_PUR_TX sy-vline 
WA_/XFT/INV_VIEW1_STR-EQUAL_TAX sy-vline 
WA_/XFT/INV_VIEW1_STR-TAX_CATEGORY sy-vline 
WA_/XFT/INV_VIEW1_STR-TAX_NO_TY sy-vline 
WA_/XFT/INV_VIEW1_STR-SOLE_PROP sy-vline 
WA_/XFT/INV_VIEW1_STR-VAT_REG_NO sy-vline 
WA_/XFT/INV_VIEW1_STR-USER_STATUS sy-vline 
WA_/XFT/INV_VIEW1_STR-PERSON_RESP sy-vline 
WA_/XFT/INV_VIEW1_STR-ORG_UNIT sy-vline 
WA_/XFT/INV_VIEW1_STR-DESCRIPTION sy-vline 
WA_/XFT/INV_VIEW1_STR-USER1 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER2 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER3 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER4 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER5 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER6 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER7 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER8 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER9 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER10 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER11 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER12 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER13 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER14 sy-vline 
WA_/XFT/INV_VIEW1_STR-USER15 sy-vline 
WA_/XFT/INV_VIEW1_STR-MIRO sy-vline 
WA_/XFT/INV_VIEW1_STR-INVOICE_DOC_ITEM sy-vline 
WA_/XFT/INV_VIEW1_STR-PO_NUMBER sy-vline 
WA_/XFT/INV_VIEW1_STR-PO_ITEM sy-vline      INTO ld_text SEPARATED BY SPACE.

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