Configuration Guide for E-Bilanz (Option 3)
There are three Options to configure the E-Bilanz in SAP:
- Option 1: SAP ERP/Other Systems with SAP BusinessObjects Disclosure Management
- Option 2: SAP ERP with SAP ERP Client for E-Bilanz
- Option 3: SAP ERP with a non-SAP-Software (for Example DATEV)
I will show you the configuration of the simplest of this three Methode (Option 3), because a lot of companies in Germany use together with SAP the non-SAP-Software DATEV.
Download the actual taxonomy from homepage http://www.esteuer.de from Bundesfinanzministerium. The ZIP-File contains several files. Important: don’t unpack this ZIP-File! Read SAP-Note 1690315. This note informs which one of the files is the leading file for the upload.
Go to transaction FSE1_XBRL and upload the (unpacked) ZIP-File:
In the next screen choose the leading file (look at SAP-Note 1690315):
For taxonomy 5.3 choose the marked file:
Confirm the button.
You will receive the message “Version EBIL was loaded successfully”.
Go to Financial Accounting (New) –> General Ledger Accounting (New) –> Periodic Processing –> Document –> Define Financial Statement Versions (Electronic Financial Statement).
Click the button “Financial Statement Items”
You have to assign in this step all your accounts to a position of the taxonomy.
After all accounts are assigned to a taxonomy position you can show with transaction FSE0_XBRL the financial statement in XBRL taxonomy form.
With transaction code FSE0_EXPORT_NODES you are able to export the XBRL-Statement to Microsoft Excel.
Upload the Excel-File with the XBRL-Statement to DATEV.
When you do this upload to DATEV for the first time, there are perhaps a lot of errors, which you have to correct then in SAP. Only when the upload to DATEV has no errors, the sending of the electronic financial statement from DATEV to the finance office will be possible.
There is also a possibility to load the global common datas (GCD) in SAP. I will post this in a second document.