Advance Return for Tax on Sales and Purchases with XML

Use

You can use report RFUMSV00 to create your advance return for tax on sales and purchases in XML (Extended Mark-up Language). You get an XML file that you can process further as required to then submit the return to the local tax authorities. XML offers a flexible alternative to the static, proprietary formats currently used for data transfer in several countries.

Note Note

In several countries, the national tax authorities are currently preparing to receive tax returns in XML in the future.

End of the note.

Features

Report RFUMSV00 creates an XML file. You can adjust the XML data to meet the requirements and formats of the respective national tax authorities. To adjust the XML data, you create a corresponding style sheet. You then send the data to the local tax authorities electronically (for example, as XML file or PDF file).

Activities

Call up report RFUMSV00 and select the field Output in XML Format in the screen area Output Control .
Check the other settings and start the report.
The system saves the data for your advance return for tax on sales and purchases in an XML file locally in a proposal directory. (See output example below)
You can use a style sheet to transfer the XML data created by the SAP System into the required format using XSLT (Extended Style Sheet Transformation).

Define a style sheet that maps the XML data of the SAP System in accordance with the requirements and formats of your national advance return for tax on sales and purchases forms.

Example

XML data output for a tax code (<item>) with report RFUMSV00

<?xml version="1.0" encoding="utf-8" ?>

<Advance_Return_for_Tax_on_Sales_and_Purchases>

<item>

<company_code> 0001 </company_code>

< tax_code > N1 </ tax_code >

<transaction_key> VST </transaction_key>

<percentage_rate> 16,000 </percentage_rate>

<tax_description> Input tax 16% not deductible,

assignable</tax_description>

<base_amount_loc_curr> 165.70 </base_amount_loc_curr>

<gross_amount_loc_curr> 192.21 </gross_amount_loc_curr>

<base_amount_doc_curr> 0.00 </base_amount_doc_curr>

<local_curr> EUR </local_curr>

<doc_curr/>

<tax_amount_loc_curr> 26.51 </tax_amount_loc_curr>

<tax_amount_doc_curr> 0.00 </tax_amount_doc_curr>

<non_deduct_tax_loc_curr> 26.51 </non_deduct_tax_loc_curr>

<non_deduct_tax_doc_curr> 0.00 </non_deduct_tax_doc_curr>

</ item >

< item > … </ item >

</Advance_Return_for_Tax_on_Sales_and_Purchases>