ABAP Select data from SAP table FIKZ_S_VATINV_HEADER 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 FIKZ_S_VATINV_HEADER 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 FIKZ_S_VATINV_HEADER. 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 FIKZ_S_VATINV_HEADER 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_FIKZ_S_VATINV_HEADER TYPE STANDARD TABLE OF FIKZ_S_VATINV_HEADER,
      WA_FIKZ_S_VATINV_HEADER TYPE FIKZ_S_VATINV_HEADER,
      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: <FIKZ_S_VATINV_HEADER> TYPE FIKZ_S_VATINV_HEADER.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FIKZ_S_VATINV_HEADER
*  INTO TABLE @DATA(IT_FIKZ_S_VATINV_HEADER2).
*--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_FIKZ_S_VATINV_HEADER INDEX 1 INTO DATA(WA_FIKZ_S_VATINV_HEADER2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FIKZ_S_VATINV_HEADER ASSIGNING <FIKZ_S_VATINV_HEADER>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FIKZ_S_VATINV_HEADER>-INV_NUM = 1.
<FIKZ_S_VATINV_HEADER>-INV_DATE = 1.
<FIKZ_S_VATINV_HEADER>-INVADD_NUM = 1.
<FIKZ_S_VATINV_HEADER>-INVADD_DATE = 1.
<FIKZ_S_VATINV_HEADER>-CORR_DATE = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FIKZ_S_VATINV_HEADER-CEO, sy-vline,
WA_FIKZ_S_VATINV_HEADER-ACCOUNTANT, sy-vline,
WA_FIKZ_S_VATINV_HEADER-SPELL_AMOUNT, sy-vline,
WA_FIKZ_S_VATINV_HEADER-SHIP_DOC, sy-vline,
WA_FIKZ_S_VATINV_HEADER-ZTERMS, sy-vline,
WA_FIKZ_S_VATINV_HEADER-INCO_CODE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FIKZ_S_VATINV_HEADER 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_FIKZ_S_VATINV_HEADER 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_FIKZ_S_VATINV_HEADER INTO WA_FIKZ_S_VATINV_HEADER. *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 VBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FIKZ_S_VATINV_HEADER-VBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FIKZ_S_VATINV_HEADER-VBELN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit AC152, internal->external for field SMNET CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_FIKZ_S_VATINV_HEADER-SMNET IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FIKZ_S_VATINV_HEADER-SMNET.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SMVAT CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_FIKZ_S_VATINV_HEADER-SMVAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FIKZ_S_VATINV_HEADER-SMVAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field SMTOT CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_FIKZ_S_VATINV_HEADER-SMTOT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FIKZ_S_VATINV_HEADER-SMTOT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field EXTOTAL CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_FIKZ_S_VATINV_HEADER-EXTOTAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FIKZ_S_VATINV_HEADER-EXTOTAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field KURSF CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FIKZ_S_VATINV_HEADER-KURSF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FIKZ_S_VATINV_HEADER-KURSF.
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_FIKZ_S_VATINV_HEADER_STR,
INV_NUM TYPE STRING,
INV_DATE TYPE STRING,
INVADD_NUM TYPE STRING,
INVADD_DATE TYPE STRING,
CORR_DATE TYPE STRING,
CEO TYPE STRING,
ACCOUNTANT TYPE STRING,
SPELL_AMOUNT TYPE STRING,
SHIP_DOC TYPE STRING,
ZTERMS TYPE STRING,
INCO_CODE TYPE STRING,
INCO_DESC TYPE STRING,
VBELN TYPE STRING,
CONTR_NUM TYPE STRING,
CONTR_DATE TYPE STRING,
VBTYP TYPE STRING,
SLAND TYPE STRING,
WAERS TYPE STRING,
WAERK TYPE STRING,
ADRNR TYPE STRING,
FULL_NAME TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
NAME3 TYPE STRING,
NAME4 TYPE STRING,
CITY1 TYPE STRING,
CITY2 TYPE STRING,
PCODE1 TYPE STRING,
STREET TYPE STRING,
HNUM1 TYPE STRING,
HNUM2 TYPE STRING,
TELNUM TYPE STRING,
REGION TYPE STRING,
LAND TYPE STRING,
VEND_KAZIDN TYPE STRING,
VEND_RNN TYPE STRING,
VEND_BIN TYPE STRING,
VEND_IBAN TYPE STRING,
VEND_BIC TYPE STRING,
VEND_BANK_NAME TYPE STRING,
VEND_BANK_ADDR TYPE STRING,
VEND_DATE_VAT_CER TYPE STRING,
VEND_NUMBER_VAT_CER TYPE STRING,
VEND_SERIES_VAT_CER TYPE STRING,
VEND_BENEF_CODE TYPE STRING,
BENEF_CODE TYPE STRING,
DATE_VAT_CERTIF TYPE STRING,
NUMBER_VAT_CERTIF TYPE STRING,
SERIES_VAT_CERTIF TYPE STRING,
VKORG TYPE STRING,
VKORG_ADR TYPE STRING,
KAZIDN_CO TYPE STRING,
RNN_CO TYPE STRING,
NAME1_CO TYPE STRING,
NAME2_CO TYPE STRING,
NAME3_CO TYPE STRING,
NAME4_CO TYPE STRING,
CITY1_CO TYPE STRING,
CITY2_CO TYPE STRING,
PCODE1_CO TYPE STRING,
STREET_CO TYPE STRING,
HNUM1_CO TYPE STRING,
HNUM2_CO TYPE STRING,
TELNUM_CO TYPE STRING,
LAND_CO TYPE STRING,
LANDT_CO TYPE STRING,
REGIO_CO TYPE STRING,
PARTN_NAME TYPE STRING,
PARTN_KAZIDN TYPE STRING,
PARTN_RNN TYPE STRING,
PARTN_INN TYPE STRING,
PARTN_BIC TYPE STRING,
PARTN_KPP TYPE STRING,
PARTN_UNP TYPE STRING,
PARTN_BIN TYPE STRING,
PARTN_IIN TYPE STRING,
PARTN_IBAN TYPE STRING,
PARTN_BANK_NAME TYPE STRING,
PARTN_BANK_ADDR TYPE STRING,
PARTN_DATE_VAT_CER TYPE STRING,
PARTN_NUMBER_VAT_CER TYPE STRING,
PARTN_SERIES_VAT_CER TYPE STRING,
PARTN_BENEF_CODE TYPE STRING,
KOART TYPE STRING,
KUNAG TYPE STRING,
ADRNR_AG TYPE STRING,
STCEG_AG TYPE STRING,
STCEG1_AG TYPE STRING,
NAME1_AG TYPE STRING,
NAME2_AG TYPE STRING,
NAME3_AG TYPE STRING,
NAME4_AG TYPE STRING,
CITY1_AG TYPE STRING,
CITY2_AG TYPE STRING,
PCODE1_AG TYPE STRING,
STREET_AG TYPE STRING,
HNUM1_AG TYPE STRING,
HNUM2_AG TYPE STRING,
TELNUM_AG TYPE STRING,
LAND_AG TYPE STRING,
LANDT_AG TYPE STRING,
REGIO_AG TYPE STRING,
KUNWE TYPE STRING,
KAZIDN_WE TYPE STRING,
RNN_WE TYPE STRING,
ADRNR_WE TYPE STRING,
STCEG_WE TYPE STRING,
NAME1_WE TYPE STRING,
NAME2_WE TYPE STRING,
NAME3_WE TYPE STRING,
NAME4_WE TYPE STRING,
CITY1_WE TYPE STRING,
CITY2_WE TYPE STRING,
PCODE1_WE TYPE STRING,
STREET_WE TYPE STRING,
HNUM1_WE TYPE STRING,
HNUM2_WE TYPE STRING,
TELNUM_WE TYPE STRING,
LAND_WE TYPE STRING,
LANDT_WE TYPE STRING,
REGIO_WE TYPE STRING,
SMNET TYPE STRING,
SMVAT TYPE STRING,
SMTOT TYPE STRING,
EXTOTAL TYPE STRING,
CURTXT TYPE STRING,
WAERC TYPE STRING,
KURSF TYPE STRING,
LFDAT TYPE STRING,
REPORT_PERIOD_FROM TYPE STRING,
REPORT_PERIOD_TO TYPE STRING,
NONTAX TYPE STRING,
TRANSPORT_TYPE_CODE TYPE STRING,END OF T_EKKO_STR. DATA: WA_FIKZ_S_VATINV_HEADER_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_FIKZ_S_VATINV_HEADER_STR-INV_NUM sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-INV_DATE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-INVADD_NUM sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-INVADD_DATE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CORR_DATE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CEO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-ACCOUNTANT sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-SPELL_AMOUNT sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-SHIP_DOC sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-ZTERMS sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-INCO_CODE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-INCO_DESC sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VBELN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CONTR_NUM sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CONTR_DATE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VBTYP sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-SLAND sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-WAERS sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-WAERK sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-ADRNR sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-FULL_NAME sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME1 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME2 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME3 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME4 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CITY1 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CITY2 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PCODE1 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-STREET sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-HNUM1 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-HNUM2 sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-TELNUM sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-REGION sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-LAND sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_KAZIDN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_RNN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_BIN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_IBAN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_BIC sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_BANK_NAME sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_BANK_ADDR sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_DATE_VAT_CER sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_NUMBER_VAT_CER sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_SERIES_VAT_CER sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VEND_BENEF_CODE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-BENEF_CODE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-DATE_VAT_CERTIF sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NUMBER_VAT_CERTIF sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-SERIES_VAT_CERTIF sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VKORG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-VKORG_ADR sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-KAZIDN_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-RNN_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME1_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME2_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME3_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME4_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CITY1_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CITY2_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PCODE1_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-STREET_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-HNUM1_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-HNUM2_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-TELNUM_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-LAND_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-LANDT_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-REGIO_CO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_NAME sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_KAZIDN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_RNN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_INN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_BIC sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_KPP sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_UNP sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_BIN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_IIN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_IBAN sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_BANK_NAME sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_BANK_ADDR sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_DATE_VAT_CER sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_NUMBER_VAT_CER sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_SERIES_VAT_CER sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PARTN_BENEF_CODE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-KOART sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-KUNAG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-ADRNR_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-STCEG_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-STCEG1_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME1_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME2_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME3_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME4_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CITY1_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CITY2_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PCODE1_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-STREET_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-HNUM1_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-HNUM2_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-TELNUM_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-LAND_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-LANDT_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-REGIO_AG sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-KUNWE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-KAZIDN_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-RNN_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-ADRNR_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-STCEG_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME1_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME2_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME3_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NAME4_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CITY1_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CITY2_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-PCODE1_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-STREET_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-HNUM1_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-HNUM2_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-TELNUM_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-LAND_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-LANDT_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-REGIO_WE sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-SMNET sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-SMVAT sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-SMTOT sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-EXTOTAL sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-CURTXT sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-WAERC sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-KURSF sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-LFDAT sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-REPORT_PERIOD_FROM sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-REPORT_PERIOD_TO sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-NONTAX sy-vline
WA_FIKZ_S_VATINV_HEADER_STR-TRANSPORT_TYPE_CODE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.