Reporting with SEM-BCS and EC-CS

  • by Dan Sullivan, Senior Consultant, focusSAP
  • March 2, 2012
Learn how SAP Enterprise Controlling and Consolidation (EC-CS) and SAP Strategic Enterprise Management-Business Consolidation System (SEM-BCS) reporting uses consolidations logic to dynamically report consolidated results.
Key Concept
The consolidation logic programmed into the reporting for SAP Strategic Enterprise Management-Business Consolidation System (SEM-BCS) and SAP Enterprise Controlling-Consolidation (EC-CS) takes into consideration for each period: posting levels; accounting techniques; the structure of the time-dependent hierarchy of consolidation groups or units; dates of first consolidation; and divestiture accounting. This logic dynamically determines, at the time the report is executed, what records to include or exclude to get true consolidated results for the consolidation group being reported and not just aggregation of the database records.

SAP Strategic Enterprise Management-Business Consolidation System (SEM-BCS) and SAP Enterprise Controlling-Consolidation (EC-CS) have consolidations logic programmed into the reporting. In many cases, this logic allows you to obtain consolidated results dynamically for almost any consolidation group.

Note
For more information on consolidation of investments, see my article “A Simplified Approach for Consolidation of Investments,” which shows how to automate consolidation of investments without a full-blown implementation of the consolidation of investments component.

Figure 1 shows the consolidation logic for reporting on consolidation of investments with SEM-BCS and SAP EC-CS. Although SEM-BCS is illustrated in Figure 1 with SAP NetWeaver BW InfoCubes, the logic applies to EC-CS as well.


Figure 1
SEM-BCS SAP NetWeaver BW reporting with SEM-BCS virtual InfoCube’s consolidation logic

Dan Sullivan

Dan Sullivan is a consultant with more than 28 years of experience in accounting and systems design. He has been an accounting manager for a Fortune 200 global enterprise, where he first implemented global ERP systems. He has worked in numerous industries implementing global enterprise solutions with a focus on SAP. These industries include retail, manufacturing, and utilities.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.