2514824 - The Electronic Financial Statement Run For Germany Delivers Zero Values While Importing The XBRL File in Excel

SAP Knowledge Base Article - Public

2514824 - The Electronic Financial Statement Run For Germany Delivers Zero Values While Importing The XBRL File in Excel

Symptom

When you import the XBRL file which you created in the Electronic Financial Statement Run into Excel you only get Zero values in tab Balance Sheet and in tab Profit and Loss. This is a known issue and the Case Document and the workarounds provided are valid to overcome this issue.

Reproducing the Issue

Prerequisite: You have to install SAP ERP Client for E-Bilanz.

  1. Go to the Application and User Management Work Center.
  2. Select Microsoft Office® Template Maintenance View.
  3. Press Go.
  4. Filter after Template name gcd and press Enter.
  5. Select GCD E-Bilanz Germany 2016-04-01 Excel Template and press Download, you will this need for uploading information in step D.
  6. Click OK to save to Harddisk.

You can see that you now have the correct Template on your Harddisk.

  1. Go to the Business Configuration Work Center.
  2. Select the Overview View.
  3. Search for keyword Electronic in asterisks (*).
  4. Click on Electronic Financial Reporting and Press Change Immediately.
  5. Press on Edit Taxonomies for Electronic Financial Reporting.

You can see that Taxonomies ID DECD06 and DEGP06 from 2015-04-03 are available but there should be a version which matches with the Template 2016-04-01.

  1. Go to the General Ledger Work Center.
  2. Click on Electronic Financial Reporting - Germany.
  3. Select Run ID XXX.
  4. You can see the following settings for Taxonomy and Global Common Data Taxonomy:
  5. DEGP06 - GAAP-Module HGB Taxonomy 2015-04-03.
  6. DECD06 - GCD-Module HGB Taxonomy 2015-04-03.
  7. The attached template is GCDE-BilanzGermany2016-04-01_Deutsch.xlsm 
  8. You can see as well that version of Taxonomy and version of Template do not match: the Taxonomy is from 2015 and the Excel Template is from 2016.
  9. Download GCDE-BilanzGermany2016-04-01_Deutsch.xlsm file.

You can see now that you have downloaded the XLSM / XBRL file.

  1. Go to Microsoft Excel.
  2. Load Form Template from Application and User Management Work Center 2016-04-01 Excel Template which you saved to Harddisk in step A.
  3. Switch to tab SAP ERP client for E-Bilanz.
  4. Press Import XBRL-Datei (Import XBRL File).
  5. Select GCDE-BilanzGermany2016-04-01_Deutsch.xlsm from your harddisk.
  6. You can see that under tab Bilanz (Balance Sheet) and GuV (Profit and Loss) there are Zero values which should not be the case. The Values should be filled.

Cause

The new Taxonomy 6.0 is not yet available. The new Excel Template from Application and User Management Work Center GCD E-Bilanz Germany 2016-04-01 does not work together with the old Taxonomy 5.4. and is creating Zero values.

Resolution

There are two Workarounds at the moment:

Workaround A)

  1. Use the old Taxonomy 5.4. together with the old template from the Application and User Management Work Center 2015-04-03 and create a New Electronic Financial Reporting Run in the General Ledger Work Center.

Workaround B)

  1. Go to the Business Configuration Work Center.
  2. Select the Implementation Projects View.
  3. Highlight First Implementation and press Open Activity List.
  4. Search for Electronic with asterisks (*).
  5. Click on Electronic Financial Reporting Activity.
  6. Press Edit Taxonomies for Electronic Financial Reporting.
  7. Highlight DEGP06 GAAP-Module HGB Taxonomy 2015-04-03.

Here you can see that this is the available actual Taxonomy.

  1. Highlight Income Statement by Function of Expense.
  2. Press Copy Assignment - Copy Existing.
  3. Select Assignment from DEGP04.
  4. Use the selected Financial Reporting Structure.
  5. Tick the checkbox Overwrite Existing Assignments.
  6. Press OK.
  7. Repeat the above steps with Balance Sheet and then similar with Taxonomy DECD06 (both Income Statement and Balance Sheet).
  8. Rerun the Electronic Financial Reporting Run in the General Ledger Work Center.

Keywords

KBA , SRD-FIN-GL , General Ledger , How To

Product

SAP Business ByDesign all versions