ABAP Select data from SAP table FICL_S_COMPRXML 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 FICL_S_COMPRXML 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 FICL_S_COMPRXML. 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 FICL_S_COMPRXML 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_FICL_S_COMPRXML TYPE STANDARD TABLE OF FICL_S_COMPRXML,
      WA_FICL_S_COMPRXML TYPE FICL_S_COMPRXML,
      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: <FICL_S_COMPRXML> TYPE FICL_S_COMPRXML.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FICL_S_COMPRXML
*  INTO TABLE @DATA(IT_FICL_S_COMPRXML2).
*--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_FICL_S_COMPRXML INDEX 1 INTO DATA(WA_FICL_S_COMPRXML2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FICL_S_COMPRXML>-BUKRS = 1.
<FICL_S_COMPRXML>-FICL_OFFBLART = 1.
<FICL_S_COMPRXML>-BELNR = 1.
<FICL_S_COMPRXML>-TAXPAYID = 1.
<FICL_S_COMPRXML>-SENDTAXID = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FICL_S_COMPRXML-TAXPRD, sy-vline,
  WA_FICL_S_COMPRXML-RESOLDATE, sy-vline,
  WA_FICL_S_COMPRXML-RESOLNUM, sy-vline,
  WA_FICL_S_COMPRXML-OPTYPE, sy-vline,
  WA_FICL_S_COMPRXML-BOOKTYPE, sy-vline,
  WA_FICL_S_COMPRXML-REMITTYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FICL_S_COMPRXML 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_FICL_S_COMPRXML 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_FICL_S_COMPRXML INTO WA_FICL_S_COMPRXML.


*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 BELNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FICL_S_COMPRXML-BELNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FICL_S_COMPRXML-BELNR.
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_FICL_S_COMPRXML_STR, 
BUKRS TYPE STRING,
FICL_OFFBLART TYPE STRING,
BELNR TYPE STRING,
TAXPAYID TYPE STRING,
SENDTAXID TYPE STRING,
TAXPRD TYPE STRING,
RESOLDATE TYPE STRING,
RESOLNUM TYPE STRING,
OPTYPE TYPE STRING,
BOOKTYPE TYPE STRING,
REMITTYPE TYPE STRING,
SEGNUM TYPE STRING,
NOTYFOLIO TYPE STRING,
CODAUTREC TYPE STRING,
S_DOCTYP TYPE STRING,
S_TAXTYPE TYPE STRING,
S_DOCNUM TYPE STRING,
S_TOTCANCEL TYPE STRING,
S_TOTEXEOP TYPE STRING,
S_TOTEXEAMOUNT TYPE STRING,
S_TOTNETAMOUNT TYPE STRING,
S_TOTRECVATOP TYPE STRING,
S_TOTVATAMOUNT TYPE STRING,
S_TOTFXDASSETOP TYPE STRING,
S_TOTFXDASSETAMNT TYPE STRING,
S_TOTFXDVATAMNT TYPE STRING,
S_NORECOVVATCODE TYPE STRING,
S_TOTNORECOVVATOP TYPE STRING,
S_TOTNORECOVVATAMOUNT TYPE STRING,
S_NORECOVVATCODE2 TYPE STRING,
S_TOTNORECOVVATOP2 TYPE STRING,
S_TOTNORECOVVATAMOUNT2 TYPE STRING,
S_NORECOVVATCODE3 TYPE STRING,
S_TOTNORECOVVATOP3 TYPE STRING,
S_TOTNORECOVVATAMOUNT3 TYPE STRING,
S_NORECOVVATCODE4 TYPE STRING,
S_TOTNORECOVVATOP4 TYPE STRING,
S_TOTNORECOVVATAMOUNT4 TYPE STRING,
S_NORECOVVATCODE9 TYPE STRING,
S_TOTNORECOVVATOP9 TYPE STRING,
S_TOTNORECOVVATAMOUNT9 TYPE STRING,
S_COMUSEVATOP TYPE STRING,
S_TOTCOMUSEVATAMNT TYPE STRING,
S_TAXCODE TYPE STRING,
S_TOTTAXAMNT TYPE STRING,
S_TOTWOCRED TYPE STRING,
S_TOTTOTAMNT TYPE STRING,
S_TOTVATNOWITHH TYPE STRING,
S_TOTCIGARS TYPE STRING,
S_TOTCIGARETTES TYPE STRING,
S_TOTMANUFTOBAC TYPE STRING,
S_TOTVEHTAX TYPE STRING,
P_DOCTYP TYPE STRING,
P_TAXTYPE TYPE STRING,
P_DOCNUM TYPE STRING,
P_TOTCANCEL TYPE STRING,
P_TOTEXEOP TYPE STRING,
P_TOTEXEAMOUNT TYPE STRING,
P_TOTNETAMOUNT TYPE STRING,
P_TOTRECVATOP TYPE STRING,
P_TOTVATAMOUNT TYPE STRING,
P_TOTFXDASSETOP TYPE STRING,
P_TOTFXDASSETAMNT TYPE STRING,
P_TOTFXDVATAMNT TYPE STRING,
P_NORECOVATCODE TYPE STRING,
P_TOTNORECVATCODE TYPE STRING,
P_TOTNORECVATAMNT TYPE STRING,
P_NORECOVATCODE2 TYPE STRING,
P_TOTNORECVATCODE2 TYPE STRING,
P_TOTNORECVATAMNT2 TYPE STRING,
P_NORECOVATCODE3 TYPE STRING,
P_TOTNORECVATCODE3 TYPE STRING,
P_TOTNORECVATAMNT3 TYPE STRING,
P_NORECOVATCODE4 TYPE STRING,
P_TOTNORECVATCODE4 TYPE STRING,
P_TOTNORECVATAMNT4 TYPE STRING,
P_NORECOVATCODE9 TYPE STRING,
P_TOTNORECVATCODE9 TYPE STRING,
P_TOTNORECVATAMNT9 TYPE STRING,
P_COMUSEVATOP TYPE STRING,
P_TOTCOMUSEVATAMNT TYPE STRING,
P_PROPFACTOR TYPE STRING,
P_TOTCOMUSEVATCREDIT TYPE STRING,
P_TAXCODE TYPE STRING,
P_TOTTAXAMNT TYPE STRING,
P_ADITTAXFACT TYPE STRING,
P_TOTTAXCREDIT TYPE STRING,
P_TOTWOCRED TYPE STRING,
P_TOTTOTAMNT TYPE STRING,
P_TOTNOWITHH TYPE STRING,
P_TOTCIGARS TYPE STRING,
P_TOTCIGARETTES TYPE STRING,
P_TOTMANUFTOBAC TYPE STRING,
P_TOTVEHTAX TYPE STRING,
P_ADITTAXFACTOR TYPE STRING,
D_DOCTYP TYPE STRING,
D_ISSUER TYPE STRING,
D_DOCNUM TYPE STRING,
D_CANCELLED TYPE STRING,
D_OPERATION TYPE STRING,
D_TAXTYPE TYPE STRING,
D_INTNUM TYPE STRING,
D_DOCDATE TYPE STRING,
D_BRNCHCODE TYPE STRING,
D_DOCTAXIDNO TYPE STRING,
D_TRADENAME TYPE STRING,
D_EXEAMOUNT TYPE STRING,
D_NETAMOUNT TYPE STRING,
D_RECVATAMOUNT TYPE STRING,
D_FXDASSETAMNT TYPE STRING,
D_FXDVATAMNT TYPE STRING,
D_NORECOVATCODE TYPE STRING,
D_NORECVATAMNT TYPE STRING,
D_NORECOVATCODE2 TYPE STRING,
D_NORECVATAMNT2 TYPE STRING,
D_NORECOVATCODE3 TYPE STRING,
D_NORECVATAMNT3 TYPE STRING,
D_NORECOVATCODE4 TYPE STRING,
D_NORECVATAMNT4 TYPE STRING,
D_NORECOVATCODE9 TYPE STRING,
D_NORECVATAMNT9 TYPE STRING,
D_COMUSEVATAMNT TYPE STRING,
D_TAXCODE TYPE STRING,
D_TAXRATE TYPE STRING,
D_CREDTAXAMNT TYPE STRING,
D_NOCREDAMNT TYPE STRING,
D_TOTAMNT TYPE STRING,
D_NOTVATWITHH TYPE STRING,
D_CIGARS TYPE STRING,
D_CIGARETTES TYPE STRING,
D_MANUFTOBAC TYPE STRING,
D_VEHTAX TYPE STRING,
D_OTAXRATE TYPE STRING,
WAERS TYPE STRING,
REFER_NUMBER TYPE STRING,
SURCHARGE_AMNT TYPE STRING,
EXE_AMNT TYPE STRING,
NET_AMNT TYPE STRING,
VAT_AMNT TYPE STRING,
CONST_CRED TYPE STRING,
COM_NETO TYPE STRING,
COM_EXE TYPE STRING,
COM_IVA TYPE STRING,
TOT_AMNT TYPE STRING,
TOT_NOT_AMNT TYPE STRING,
SUM_EXE_AMNT TYPE STRING,
SUM_NET_AMNT TYPE STRING,
SUM_VAT_AMNT TYPE STRING,
SUM_TOT_AMNT TYPE STRING,
SUM_CONST_CRED TYPE STRING,
SUM_COM_NETO TYPE STRING,
SUM_COM_EXE TYPE STRING,
SUM_COM_IVA TYPE STRING,
SUM_TOT_NOT_AMNT TYPE STRING,
TOT_WITH_VAT TYPE STRING,
PAR_WITH_VAT TYPE STRING,
SUM_WITH_VAT TYPE STRING,
TAXCODE TYPE STRING,
DOC_REF_NUM TYPE STRING,
DOC_TAX_NO TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FICL_S_COMPRXML_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_FICL_S_COMPRXML_STR-BUKRS sy-vline 
WA_FICL_S_COMPRXML_STR-FICL_OFFBLART sy-vline 
WA_FICL_S_COMPRXML_STR-BELNR sy-vline 
WA_FICL_S_COMPRXML_STR-TAXPAYID sy-vline 
WA_FICL_S_COMPRXML_STR-SENDTAXID sy-vline 
WA_FICL_S_COMPRXML_STR-TAXPRD sy-vline 
WA_FICL_S_COMPRXML_STR-RESOLDATE sy-vline 
WA_FICL_S_COMPRXML_STR-RESOLNUM sy-vline 
WA_FICL_S_COMPRXML_STR-OPTYPE sy-vline 
WA_FICL_S_COMPRXML_STR-BOOKTYPE sy-vline 
WA_FICL_S_COMPRXML_STR-REMITTYPE sy-vline 
WA_FICL_S_COMPRXML_STR-SEGNUM sy-vline 
WA_FICL_S_COMPRXML_STR-NOTYFOLIO sy-vline 
WA_FICL_S_COMPRXML_STR-CODAUTREC sy-vline 
WA_FICL_S_COMPRXML_STR-S_DOCTYP sy-vline 
WA_FICL_S_COMPRXML_STR-S_TAXTYPE sy-vline 
WA_FICL_S_COMPRXML_STR-S_DOCNUM sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTCANCEL sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTEXEOP sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTEXEAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNETAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTRECVATOP sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTVATAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTFXDASSETOP sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTFXDASSETAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTFXDVATAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_NORECOVVATCODE sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATOP sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_NORECOVVATCODE2 sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATOP2 sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATAMOUNT2 sy-vline 
WA_FICL_S_COMPRXML_STR-S_NORECOVVATCODE3 sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATOP3 sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATAMOUNT3 sy-vline 
WA_FICL_S_COMPRXML_STR-S_NORECOVVATCODE4 sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATOP4 sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATAMOUNT4 sy-vline 
WA_FICL_S_COMPRXML_STR-S_NORECOVVATCODE9 sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATOP9 sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTNORECOVVATAMOUNT9 sy-vline 
WA_FICL_S_COMPRXML_STR-S_COMUSEVATOP sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTCOMUSEVATAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_TAXCODE sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTTAXAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTWOCRED sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTTOTAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTVATNOWITHH sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTCIGARS sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTCIGARETTES sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTMANUFTOBAC sy-vline 
WA_FICL_S_COMPRXML_STR-S_TOTVEHTAX sy-vline 
WA_FICL_S_COMPRXML_STR-P_DOCTYP sy-vline 
WA_FICL_S_COMPRXML_STR-P_TAXTYPE sy-vline 
WA_FICL_S_COMPRXML_STR-P_DOCNUM sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTCANCEL sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTEXEOP sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTEXEAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNETAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTRECVATOP sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTVATAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTFXDASSETOP sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTFXDASSETAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTFXDVATAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_NORECOVATCODE sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATCODE sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_NORECOVATCODE2 sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATCODE2 sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATAMNT2 sy-vline 
WA_FICL_S_COMPRXML_STR-P_NORECOVATCODE3 sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATCODE3 sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATAMNT3 sy-vline 
WA_FICL_S_COMPRXML_STR-P_NORECOVATCODE4 sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATCODE4 sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATAMNT4 sy-vline 
WA_FICL_S_COMPRXML_STR-P_NORECOVATCODE9 sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATCODE9 sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNORECVATAMNT9 sy-vline 
WA_FICL_S_COMPRXML_STR-P_COMUSEVATOP sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTCOMUSEVATAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_PROPFACTOR sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTCOMUSEVATCREDIT sy-vline 
WA_FICL_S_COMPRXML_STR-P_TAXCODE sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTTAXAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_ADITTAXFACT sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTTAXCREDIT sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTWOCRED sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTTOTAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTNOWITHH sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTCIGARS sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTCIGARETTES sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTMANUFTOBAC sy-vline 
WA_FICL_S_COMPRXML_STR-P_TOTVEHTAX sy-vline 
WA_FICL_S_COMPRXML_STR-P_ADITTAXFACTOR sy-vline 
WA_FICL_S_COMPRXML_STR-D_DOCTYP sy-vline 
WA_FICL_S_COMPRXML_STR-D_ISSUER sy-vline 
WA_FICL_S_COMPRXML_STR-D_DOCNUM sy-vline 
WA_FICL_S_COMPRXML_STR-D_CANCELLED sy-vline 
WA_FICL_S_COMPRXML_STR-D_OPERATION sy-vline 
WA_FICL_S_COMPRXML_STR-D_TAXTYPE sy-vline 
WA_FICL_S_COMPRXML_STR-D_INTNUM sy-vline 
WA_FICL_S_COMPRXML_STR-D_DOCDATE sy-vline 
WA_FICL_S_COMPRXML_STR-D_BRNCHCODE sy-vline 
WA_FICL_S_COMPRXML_STR-D_DOCTAXIDNO sy-vline 
WA_FICL_S_COMPRXML_STR-D_TRADENAME sy-vline 
WA_FICL_S_COMPRXML_STR-D_EXEAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_NETAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_RECVATAMOUNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_FXDASSETAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_FXDVATAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECOVATCODE sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECVATAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECOVATCODE2 sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECVATAMNT2 sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECOVATCODE3 sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECVATAMNT3 sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECOVATCODE4 sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECVATAMNT4 sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECOVATCODE9 sy-vline 
WA_FICL_S_COMPRXML_STR-D_NORECVATAMNT9 sy-vline 
WA_FICL_S_COMPRXML_STR-D_COMUSEVATAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_TAXCODE sy-vline 
WA_FICL_S_COMPRXML_STR-D_TAXRATE sy-vline 
WA_FICL_S_COMPRXML_STR-D_CREDTAXAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_NOCREDAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_TOTAMNT sy-vline 
WA_FICL_S_COMPRXML_STR-D_NOTVATWITHH sy-vline 
WA_FICL_S_COMPRXML_STR-D_CIGARS sy-vline 
WA_FICL_S_COMPRXML_STR-D_CIGARETTES sy-vline 
WA_FICL_S_COMPRXML_STR-D_MANUFTOBAC sy-vline 
WA_FICL_S_COMPRXML_STR-D_VEHTAX sy-vline 
WA_FICL_S_COMPRXML_STR-D_OTAXRATE sy-vline 
WA_FICL_S_COMPRXML_STR-WAERS sy-vline 
WA_FICL_S_COMPRXML_STR-REFER_NUMBER sy-vline 
WA_FICL_S_COMPRXML_STR-SURCHARGE_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-EXE_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-NET_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-VAT_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-CONST_CRED sy-vline 
WA_FICL_S_COMPRXML_STR-COM_NETO sy-vline 
WA_FICL_S_COMPRXML_STR-COM_EXE sy-vline 
WA_FICL_S_COMPRXML_STR-COM_IVA sy-vline 
WA_FICL_S_COMPRXML_STR-TOT_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-TOT_NOT_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_EXE_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_NET_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_VAT_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_TOT_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_CONST_CRED sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_COM_NETO sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_COM_EXE sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_COM_IVA sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_TOT_NOT_AMNT sy-vline 
WA_FICL_S_COMPRXML_STR-TOT_WITH_VAT sy-vline 
WA_FICL_S_COMPRXML_STR-PAR_WITH_VAT sy-vline 
WA_FICL_S_COMPRXML_STR-SUM_WITH_VAT sy-vline 
WA_FICL_S_COMPRXML_STR-TAXCODE sy-vline 
WA_FICL_S_COMPRXML_STR-DOC_REF_NUM sy-vline 
WA_FICL_S_COMPRXML_STR-DOC_TAX_NO sy-vline      INTO ld_text SEPARATED BY SPACE.

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