Manpower Planning - BPC Data Model
The BPC data model feeds from the SAP HR application which is uploaded through BI. The following diagram represents the integrated data model with the integration of the transactional system and BI. This data model also includes the BS derivation as it will be an integrated solution into the application in this project phase. For the manpower planning process, the focus will be from the steps 1 to 4 of the diagram:

Figure: Manpower Planning - Integrated Data Model
- Data transfer from transactional systems to BW (transactional data and master data) as repository of data for BPC
- Upload of data to BPC in order to perform budgeting processes
- Configuration of the Manpower budgeting process for all companies
- Manpower budget is “sent” to the companies in order to build their budget
- P&L and CAPEX Budget is entered into BPC by the AB Group of companies:
- Other Expenses are entered into BPC manually by all companies using a common template
- Rest of P&L for all companies uploaded into BPC using current structures
- CAPEX is uploaded via flat file to BPC following structures defined in step 5
- Once P&L budget is in BPC for all companies, it is sent to the balance sheet to configure B/S budget:
- Using common rules for all companies to derive B/S from P&L
- Entering manual data for all lines that are not calculated from P&L/CAPEX (or uploaded via flat file)
- P&L and Balance Sheet budget for all companies is uploaded into the consolidation applications
- Budget Consolidation process is performed (as per current process)
- Budgeting Reporting is performed:
- Consolidation reporting: Consolidated budget for B/S, P&L, CF,… (as per current)
- Operational budget reporting for P&L and B/S and Manpower in BPC
Operational budget reporting for companies not in BPC in their legacy systems
For the manpower planning application the following dimensions will be required :
