Skip to Content
Author's profile photo Former Member



All the examples and screenshots used in this blog are hypothetical and for illustrative purposes only. They should not serve as guidance in preparing financial statements or submitting financial data to any government entity.


ECC – ERP Central Component
ERP – Enterprise Resource Planning
GL – General Ledger
ECCS – Enterprise Controlling Consolidation System
SEM – Strategic Enterprise Management
BCS – Business Consolidation System
OLAP – On-Line Analytical Processing
XML – eXtensible Markup Language
XBRL – eXtensible Business Reporting Language
SEC – Securities and Exchange Commission
FASB – Financial Accounting Standards Board


I would like to write a brief proof of concept blog showing how the standard SAP software – ECC can be used to deliver well formatted financial statements as required by one government entity – SEC. There are many other possible solutions to this particular business problem and there are many other configurations possible, but this particular one presents the simplest one in my mind for the best way to present financial results to the public.

XBRL (wikipedia reference) started its life over 10 years ago and it’s an officially mandated format in the US. It’s featured in websites of both SEC (@ and FASB (@ For any business entity going and remaining public or quoted in the US stock exchanges it is a de facto rule. Its technical origins lie in XML.

Main Steps

First things first or it all starts with a journal entry or at least one debit and one credit which add up to 0. It’s true for one entry and also true for any trial balance which serves as foundation to any financial report. Many business events and transactions created by business partners must take place before one such credit or debit is recorded, but the underlying concept hasn’t changed since the XVth century Venice.

Starting with the traditional or some might say boring ECC, an accounting journal entry is made as shown in the FB03 Display transaction. It happens during the last month of 2011 and will become part of 2011 annual report. Debit is to account 100000 and credit to account 30000. Nothing new so far. Your SAP system has millions of them.

ECC GL Entry


After accounting as completed its close activities we pull a trial balance which again is the standard F.01 transaction (behind which is the report/program RFBILA00). The most important selection value is “1” which points to “Extract to consolidation”.

F.01 Financial Statements


After necessary configuration is performed, a dialog box with ECCS_FILE  and the checked flag for “Receiver is SEM-BCS” sends the trial balance  to a flat ASCII file in the operating system directory. At this point, the financial records are ready to leave the ECC and get ready for the interface with SEM-BCS.

ECCS Extract


A report showing our GL account balances as mapped to the preconsolidation ledger along with the output file provides an interim status of the integrated financial reporting. The file needs to be transformed before being loaded into the SEM-BCS which is the OLAP equivalent of ECCS, but the underlying account and balance information cannot change to maintain the integrity of the financial reporting process and satisfy the internal controls and external auditing requirements.

Report and Flat File


After the necessary changes, the BCS file can be uploaded. This is part of the flexible upload task which in turn is a step in the group financial close process of consolidated entity comprised of multiple legal entities of various percentage ownership stakes where the most critical balances or totals are investments, goodwill, equity, non-controlling interests, and intercompany relationships. This is example is the simplest one possible, but in reality includes hundreds of items and steps which are automated by ECC/BCS or some other combination of technology and interfaces.

BCS Upload Task


After the load into the BCS, another intermediate check is performed within the reporting cube showing the balances of the two accounts which now are called Financial Statement Items. Here they are the exact equivalents (1:1) of the General Ledger accounts, but in reality they would differ and would be reflected along the N:1 relationship.

Reported Financial Data


The end users can obviously navigate the reporting cube in a browser of their choice. Here the amounts are presented via Firefox browser.

Firefox SAP Cube


Now comes the most interesting mapping tool of the BCS – XBRL taxonomy. The taxonomy file is guaranteed to change every year as both FASB and SEC keep fine tuning the financial reporting requirements. As soon as the file is released by the government, mapping and testing can begin. Again, the simplest mapping possible is illustrated here, but the same process is true for all the other relationships.

XBRL Mapping


After mapping (assignment) has been completed, the last step of processing within the ECC is generating an instance which in turn creates an XML file. The XML format is the superset of XBRL and its basic definition has not changed since 1998. The file can be read by any browser and together with the XSD file and some other files creates the XBRL standard. This is the last step where SAP code is involved with processing financial information which has originated the the GL or any subledger systems feeding it.

XML File


As an example only, a trial version of the Altova software shows a grid display of the XML/XBRL file with all the necessary values as required by the SEC.

Grid XBRL View ready for filing



We have gone from a GL journal entry to the published financial statements using the minimum steps required and leveraging the existing SAP production installations. This virtual financial reporting value chain takes a lot of manpower and even more hours to accomplish today, but this example shows a clear opporunity to streamline and make it a more efficient process thus creating added value for all.

Have a happy closing of the 2011 financial year about to begin as soon as 2011 is over.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Birgit Starmanns
      Birgit Starmanns
      SAP’s strategic solution for regulatory disclosures and XBRL submissions is SAP BusinessObjects Disclosure Management, and as such, it is the solution recommended by SAP for any form of XBRL-based reporting. All future enhancements of disclosure and XBRL functionality will be based on the disclosure management application.

      The use of the legacy XBRL capabilities in SAP ECC is not endorsed by SAP, for the following reasons:
      - SAP ERP EhP3  will be supported in maintenance mode only, in accordance with the standard SAP Maintenance Strategy. There will be no further development of the XBRL functionality in SAP ECC.
      - The legacy solution delivered in SAP ERP EhP3 is missing key XBRL-related capabilities, such as support for XBRL validations or formulas, and the extension of taxonomies, which are key requirements in support of XBRL-based reporting.
      - New mandates, such as the E-Bilanz filings required in Germany, are not supported with the legacy capabilities in SAP ECC.

      Author's profile photo Former Member
      Former Member
      Hi Birgit,

      nice to hear from you and thank you for leaving the clarification as to where SAP is heading strategically. i have decided to restrict my postings to wiki area due to low interest in the topic on SDN, but my goal has been to show how to make best of their existing ECC investment. i understand SEM-BCS is in the maintenance mode (except for a few features) and users are on their own when trying to make it fit their requirements. nevertheless, i was really happy to see it work with the most recent US GAAP taxonomy xsd files.

      Best regards,


      Author's profile photo Former Member
      Former Member

      Good day, Former Member

      Interesting about XBRL, “presents the simplest one in my mind for the best way to present financial results to the public”

      I proposed it in Jul.2015:


      With IBM Watson analyze Financial Statements and reports stored in XBRL with NIIF

      By Ricardo Dolinski Garrido. V73877. Application Architect in IBM Venezuela



      2.- Problem:

      One idea about how we can drive more value for our customers would be permit them to access on demand in the process of comparing their performance metrics to industry bests or best practices from other companies, in the World.

      How do you get knowledge from the financial performance for a company within an industry, a country or globally through a request of service online with recent accounting data and best financial practices?

      3.- Solution:

      Use Watson – XBRL – IFRS – Bluemix – Cloud for calculate and compare financial metrics with its peers and the best and lowest performance for each metric in the peer group.

      This product IBM Watson Financial Benchmarking getting knowledge from value of gaps in cash flow benefit and the outcome would look like FinListics Solutions

      I have focused the project in the following schemes:

      a.- Use a sample of 5 companies,

      One company target relative to 4 peer companies in the same industry

      b.- Data in XBRL scheme, adhered to IFRS,

      Built with IBM Cloud

      Access accounting data stored in XBRL with IFRS

      [320000] Income statement, by nature of expense, for example


      c.- Presentation Information scheme,

      Built with IBM Bluemix

      Build framework with metrics GROWTH & PROFITABILITY, for example


      d.- Presentation Knowledge scheme,

      Built with IBM Watson

      Interpret metrics to get knowledge through formulating hypotheses based on evidence


      e.- Routine as a Service (aaS) scheme,

      Built with IBM Bluemix

      Execute the above three schemes at the request of service for the target company:

      XBRL, Information and Knowledge


      f.- Front-end scheme,

      Built with IBM Watson Engagement Advisor (WEA) for Mobile

      Show the schemes at the request of service: Information and Knowledge



      Former Member

      username: Former Member

      S_User: S0018218833

      P_User: P1942534595