Tax reporting (RFUMSV00) - data from third party systems

[akaserer]

Hello everybody,

Short question:
Is there a way to enrich SAP standard tax reports (RFUMSV00, RFUMSV10,.. ) with data from external systems?

Long version:
Currently we do tax reporting in SAP using standard transactions/reports.

We post incoming invoices directly in SAP (outgoing payments are managed within SAP as well).

Outgoing invoices are posted in a non SAP customer system and transferred to SAP (incoming payments are also managed out of SAP.
The point here is: these outgoing invoices are posted on a dummy debtor in SAP. So we don't have the real customer master data in SAP (and we don't want/need to create customer master data in SAP in the future also).

Therefore, concerning tax reporting we don't have the customer data (VAT-ID, address) in SAP .

Is there a way, to import data related to text reporting for outgoing invoices into a special table SAP with the correct customer name and customer vat number, which would then enrich the VAT reports from that data pool ??

We use a SAP ERP right now but we prepare a transformation to S/4 HANA. Or maybe there is a solution which comes with S/4 HANA.

Any help is welcome, thanks and advance..

Best regards, Andreas

[sanilbhandari]

Hi akaserer

You would need to have the customer master data created with the right tax id set up to be able to use a tax report with both AR and AP Information as well as offset the credit against liability.

In one of my projects long ago, I had a similar situation where a non SAP System was used for customer billing and payments and information on invoice and payments was sent through an IDOC into SAP. The system was used in multiple countries. What we did to enable multi country tax reporting was the following:

1) When a new customer request was received from field, a customer master was set up in ERP System and an interface used to send the information in non ERP System with the customer no from ERP. This created a sub-ledger record for AR in the billing system with a reference to customer master information from ERP.

2) When the invoice was booked, it used to send an IDOC for Subledger record and with a reference of Customer Record in ERP in one of the field. A custom program used to create an invoice for the customer in ERP with the key figure being the customer no of ERP received in IDOC. The IDOC used to contain information like:

Customer No of ERP, Item Code (there was a mapping table in ERP for Item Code to Material Master), Tax Amount, Tax Base Amount and total amount.

With these details at a high level, we used to create a customer invoice in Finance. when IDOC was processed.

In your case, I do not see any possibility to able to process tax reports, unless you create a master data to identify for which customer the transactional data refers to.

Thanks & Regards

Sanil Bhandari