How a Film Company Uses SAP NetWeaver BW for Closed-Loop Planning

  • by Hari Srinivasan, Senior Principal, Inforte
  • March 15, 2009
Follow the setup for building and executing controls in SAP NetWeaver BW in the context of a real-life media-specific business process.
SAP Business Planning and Simulation (BW-BPS) allows you to use standard planning applications or build your own. BW-BPS contains the Web Interface Builder for building a custom front-end user interface. Alternatively, you can use the delivered Microsoft Excel interface. The planning workbench allows you to establish the planning data model and enables the creation and use of custom coding to create planning applications for your own business processes. In addition, you can use the standard ABAP workbench tools with the planning workbench to create a custom retraction process to seamlessly integrate planning processes in SAP NetWeaver BW with SAP ERP Central Component.

Many of you are challenged with the need to manage planning processes in SAP NetWeaver Business Warehouse (SAP NetWeaver BW) that have a closed-loop process with transactional systems such as SAP ERP Central Component (SAP ECC). The transactional postings triggered from SAP NetWeaver BW subsequently enable decision-making or generate a transactional posting with an accounting implication.

An example of such a closed-loop automated process is the cost center plan that is created in SAP NetWeaver BW and then retracted to SAP ECC. Next, transactional postings are created. Subsequently, plan allocations are made on the cost center plan, which is then compared with the actual cost center postings. Another example is marketing spend that is tracked and created in SAP NetWeaver BW, and the monthly accrual that is posted to SAP ECC using a retractor.

In a previous article titled "How to Build and Use Controls for Closed-Loop Planning Processes in SAP NetWeaver BI," I walked you through a consumer product goods (CPG) business process that required establishing a closed-loop process from your SAP NetWeaver BW environment. The business process I explained helped you understand the implications with respect to segregation of duties (SoD) and how to build controls that help you realize the business process via technical implementation.

Now I explain media-specific business processes known as ultimates and amortization, which begin with a planning process and end with accounting journal postings based on media industry-specific accounting guidelines provided by the American Institute of Certified Public Accountants (AICPA) Statement of Position (SOP) 00-2, Accounting by Producers or Distributors of Films. This article is based on an actual implementation at a media company. The content has been created in a generic form to make it applicable and consumable in similar industries while protecting sensitive information from the implementation. My example is on a BW 3.5 system with R/3 4.6C, but it works with up to SAP NetWeaver BW 7.0 and SAP ERP Central Component (SAP ECC) 6.0 as well.

Hari Srinivasan

Hari Srinivasan is an SAP NetWeaver BW specialist with more than a decade of experience in implementing SAP FI/CO, IS Retail, and SAP NetWeaver BW. Hari specializes in implementing SAP NetWeaver BW solutions including the SAP BusinessObjects suite of products and planning applications. Hari has also conducted numerous BW data warehousing and upgrade assessments, conducted reporting strategy assignments, and developed migration strategies from SAP NetWeaver BW to the SAP BusinessObjects suite of products. Hari is now focusing on working with the EPM and SAP BusinessObjects suites. Prior to working with SAP systems and applications, Hari worked in several managerial positions in accounting, finance, project acquisitions, and infrastructure investment. Hari is a chartered accountant from India and a certified information systems auditor.

See more by this author


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.