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.

Step 1:

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.

Step 2:

Go to transaction FSE1_XBRL and upload the (unpacked) ZIP-File:

Ebil1.jpg

In the next screen choose the leading file (look at SAP-Note 1690315):

Ebil2.jpg

For taxonomy 5.3 choose the marked file:

Ebil3.jpg

Confirm the button.

You will receive the message “Version EBIL was loaded successfully”.

Step 3:

Go to Financial Accounting (New) –> General Ledger Accounting (New) –> Periodic Processing –> Document –> Define Financial Statement Versions (Electronic Financial Statement).

Ebil4.jpg

Click the button “Financial Statement Items”

EBIL5.jpg

You have to assign in this step all your accounts to a position of the taxonomy.

Step 4:

After all accounts are assigned to a taxonomy position you can show with transaction FSE0_XBRL the financial statement in XBRL taxonomy form.

Ebil6.jpg

Ebil7.jpg

Step 5:

With transaction code FSE0_EXPORT_NODES you are able to export the XBRL-Statement to Microsoft Excel.

Step 6:

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.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

      1. N S

        Hello Michaela,

        Thanks for the quick reply. My client wants to use version 5.3. According to the guide attached to note 1666580 we should use as leading file “de-gaap-ci-2012-06-01-shell.xsd”. But this is meant for version 5.1.

        According to note 1690315 the following leading files are available as leading files for the CORE taxonomy:

        • de-gaap-ci-2014-04-02-shell.xsd
        • de-gaap-ci-2014-04-02-shell-fiscal.xsd
        • de-gaap-ci-2014-04-02-shell-microbilg.xsd
        • de-gaap-ci-2014-04-02-shell-fiscal-microbilg.xsd
        • de-gaap-ci-2014-04-02-shell-group.xsd

        In your guide you are using “de-gaap-ci-2014-04-02-shell-fiscal.xsd” while according to the guide from note 1666580 I would have expected we should use “de-gaap-ci-2014-04-02-shell.xsd”


        Although both these leading files are available in the zip which can be downloaded from http://www.esteuer.de, during upload in SAP only your version is available. This could be an program error according to note 2052869, but I am note sure though.


        Do you know what the difference is between de-gaap-ci-2014-04-02-shell-fiscal.xsd” and “de-gaap-ci-2014-04-02-shell-fiscal.xsd” files?


        Thank you,


        N S




        (0) 
  1. Mahmoud Elnady

    Hi

    Could you add a brief introduction of the above document in order to facilitate the understanding of the benefit of implementing it.. You work is appreciated and your document has enriched the community..

    Regards

    Mahmoud EL Nady

    (0) 

Leave a Reply