SAP BW: Project budget controlling with allocation
Project duration: 9 months
Brief description
Further development of an existing data model for analysis of product budget capacities. The focus of the enhancement is a multi-level assessment procedure to ensure greater transparency through more precise cost allocation during project management.
Supplement
The initial data model contains both company-specific master data for projects, orders and investment programs, as well as the corresponding movement data. Most of the data model represents the historicization of project budgets and order costs, which make it possible to create comparisons between current and past planned and actual values. Master data: The data model was enhanced with various new master data attributes for orders, WBS elements, settlement rules and investment programs. Movement data: For project and order data, expenditures are converted using a multi-level assessment (for both planned and actual expenditures). For the assessment of planned and actual values, different types of logic were implemented that redistribute the original planned values based on settlement rules (for orders and projects), cost centers and assessment, thereby allowing for more detailed controlling.
Subject description
Reporting consists of master data reports for investment programs, projects, orders and settlement rules, and especially reports for evaluating budget utilizations (investment and expense projects). Central points of the data model: historicization of master and movement data; multiple model for input-based allocation of planned and actual values for projects. Objectives of application: more transparent, detailed and flexible project controlling; better project control and input-based cost allocations in projects; data backup/historicization to enable a view of historic data; automation of processes, which were previously implemented manually (multiple-level cost distribution based on allocation keys based on project-dependent cost centers).