Excel related planning can be done in SAP BPC Optimized for SAP S/4HANA (abbreviation: BPC Optimized).
A big advantage is the delivered planning content which allows online saving of plan data into data table ACDOCP which is the S/4HANA plan data table. For customers who want to transfer their plan data from the old CO plan data tables into ACDOCP or back from ACDOCP into the old CO tables there is either a transfer program for the administrator or the business user in the delivered Analysis for Microsoft Excel planning workbooks can trigger the extraction and retraction by themselves.
Planned maintenance for BPC Optimized is until 2027.
The S/4HANA Business Suite contains:
SAP Accounting
SAP Cash Management
SAP BPC Optimized for SAP S/4HANA
SAP BPC Optimized for SAP S/4HANA 10.1, version for SAP NetWeaver contains the following:
New or reworked accounting processes in a content based planning solution
Excel User Interface
A simplified data architecture based on ACDOCP and ACDOCA for actual data with FI-CO integration
Access to actual and master data real time from SAP S/4HANA without data replication
- Line items as the only source for operative reporting and planning
- Plan data has the same granularity as in General Ledger
- Very good bottom-up and top-down planning capabilities with plan data available at any level
- Fast plan data processing through planning functions of PAK (Planning Application Kit)
- Planning and Reporting in HANA speed
An integrated data-model based on new FI-CO documents, to allow flexibility and simulations during the planning process.
The delivered content works with Analysis for Microsoft Excel workbooks.
The previous figure shows all content Analysis for Microsoft Excel workbooks delivered with S/4HANA 2021 on premise. The content Analysis Workbooks are all FIORI compliant. You can plan your costs on your cost centers with the help of this workbook. Afterwards the business user chooses the Save button to online store the plan data in table ACDOCP.
The preceding figure shows a data transfer workbook which the end user could use after planning. With the help of the Copy BPC to ERP button you can in parallel copy the new plan data from ACDOCP back to the old CO tables.
With the help of the Copy ERP to BPC button you can copy data from the old CO tables into table ACDOCP.
Note
Don´t forget to save your data after executing the data transfer!
In ACDOCP all plan data is stored in categories whereas in the old ERP planning was stored in versions. So before you can start planning, you have to set up a plan category. The preceding figure explains how to set it up.
Note
Category ACT01 is "the" category for actual data and its technical name must be maintained as ACT01. ACT01 is mapped to version 0 which represents actual data in the old CO tables together with the value type for actual data.
In the following you will find some examples of how the content Analysis for Microsoft Excel workbooks are used and how the retraction back to the old CO tables works.
If you want to do Activity Input planning you should use tab card Activities of Analysis workbook /ERP/SFIN_A03_WB01. Keep in mind how to enter the data (see the previous figure). The data set with receiver cost center 1200 is the data set represents activity input planning (100 hours).
If all the activity inputs are planned on receiver cost centers and this in parallel represents the total activity output of the sender cost center, then no further planning of activity output is necessary, that is, scheduled activity corresponds the activity output of the sender cost center.
If on the other hand the activity output is higher than the scheduled activity, then you will have to plan this for the sender cost center and receiver cost center # (with quantity 10). This is described in the preceding figure. In this case the scheduled activity (100) is minor to the planned activity output (110 = 100 + 10).
Use Workbook /ERP/SFIN_A09_WB01 for retraction of activity inputs into the old CO tables. The result of this retraction can be seen in transaction KP06 and in column Scheduled Activity of transaction KP26.
The total activity output consists of the following two aspects:
- If all the activity inputs are planned on receiver cost centers and this in parallel represents the total activity output of the sender cost center, then no further planning of activity output is necessary. i.e. scheduled activity corresponds the activity output of the sender cost center.
- If on the other hand the activity output is higher than the scheduled activity, then you will have to plan this for the sender cost center and receiver cost center # (with quantity 10).
To retract the activity output into the old CO tables, use workbook /ERP/SFIN_A08_WB01. In the preceding figure, the sum of 110 is retracted into transaction KP26 and represents the complete activity output planning of cost center 1300 with activity type 1421, i.e 110 hours. The result of this retraction can be seen in S/4HANA transaction KP26.
The preceding figure shows the Activity tab of workbook /ERP/SFIN_A03_WB01.
If you want to plan fix prices for activity types you should use tab card Prices of Analysis workbook /ERP/SFIN_A03_WB01.
Using workbook /ERP/SFIN_A08_WB01 does not only retract activity outputs but also the prices back in the old CO tables. The result of this retraction also shows the prices in column Price Fixed of transaction KP26.
In transaction KP06 as a consequence you will also see the result of the multiplication of the Plan fixed consumption * Price Fixed in column Plan fixed costs (50 EUR * 100 H = EUR 5000).
The preceding figure shows the Prices tab of workbook /ERP/SFIN_A03_WB01.
The preceding figure shows the retraction workbook /ERP/SFIN_A08_WB01 for activity output and price retraction.
The preceding figure shows the delivered workbook for planning of G/L accounts of type costs on internal orders /ERP/SFIN_A11_WB01.
You can retract the costs you planned on internal orders using workbook /ERP/SFIN_A19_WB01. As a result you can check the data in transaction KO12 for your internal order.
If the administrator is going to execute the data transfer centrally, they can use some delivered reports.
In SAP S/4HANA, the data for financial planning is based on the ACDOCP table, which is the main table for planning. It serves as the single source of truth for plan data and helps connect predecessor and successor processes. To transfer financial plan data between the CO tables and the ACDOCP table in SAP S/4HANA, you can use the programs described in the preceding figure.
Note
If the customer doesn't have SAP BPC Optimized for SAP S/4HANA and needs to transfer data from the old CO tables to ACDOCP program, R_FINS_PLAN_TRANS_CO_ERP_2_S4H listed in the preceding figure can be used.
The preceding figure explains how to enter the selections if an administrator centrally executes the transfer to the old CO tables for Cost Center/Cost Element planning as well as for Activity Input lanning.
If you also want to transfer activity prices this is not possible using the report in the preceding figure. If needed, the only way is to use workbook Price and Activity Transfer for Cost Centers - /ERP/SFIN_A08_WB01.