Last Updated on January 1, 2022 by Pradeep
WIP in SAP in S/4HANA Finance
WIP or Work in Progress for reporting and posting is a mapping exercise. The configurations of WIP in SAP S/4HANA for product cost by Period and Product cost by Order are similar.
We will look at the configuration for product cost by period and highlight the difference along the way.
Key configurations required in doing WIP in SAP S4 HANA Finance
- First, Create the Result Analysis key and version
- Then, Create Line IDs and map to source cost elements
- Map line IDs to WIP or results analysis cost elements ( Type 31)
- Finally, Create posting rules for settling WIP to SAP ERP Finance ( FI)
WIP calculation is a period end activity of Product cost by order calculation. So, now let us know what is exactly the product cost by order. And what we do in this to get the WIP calculation.
Product Cost by Order – The Platform for WIP in SAP
The Product cost by order scenario involves working with manufacturing orders. You will now look at the differences between WIP calculation for manufacturing orders and product cost collectors.
Relation of WIP to Product cost by Order
You can evaluate WIP at an actual cost in product cost by order. All order debits are WIP until valuated goods receipt into inventory occurs.
At the period end, you can determine the actual balance of incomplete manufacturing orders not fully delivered to inventory during WIP calculation.
During settlement, you post calculated WIP to a WIP balance sheet account and an offsetting profit and loss account.
Also read: Product Costing – All that you need to know
You can base SAP WIP calculation on the following manufacturing order status
- REL- Released- Calculate WIP
- DLV-Delivered-Cancel WIP
- TECO-technically complete –Cancel WIP
You calculate WIP at each period end until the order status is set to “DLV” or “TECO”. Then the system cancels WIP and calculates the variance. Further, let’s take an example for a better understanding.
You may be interested in: SAP product Costing Interview Questions
Steps involved in Product Cost by Order to reach WIP Calculation
To understand the concept of Product Cost by order which finally leads to get WIP in the S/4HANA Finance system, here I have given a scenario where you can see the different steps that we take to perform this activity.
So let us go ahead.
Step 1: Create Production Order
Following image and description would help you understand the creation of Production Order
Material # 152 is to be produced in Plant No -1201. The total quantity is to be produced # 6 Units and 3 units delivered.
- Costing Variant for calculating Target Cost- Z201
- Costing variant for calculating Actual Cost –Z202
- Result Analysis Key for WIP calculation- MBMF01
- Used for Production Order Variance Analysis – Z00001
- You use Routing Data in Production Order – 50000013
- Likewise, you use BOM Data in production Order – 00000102
Important Post: Key Changes in SAP Profitability Analysis 2020
Step 2: Accounting Document for Raw Material Consumption
Step 3: Controlling Document created when activity confirmed
This controlling document is for Material # 152 and Production Order # 1000225.
Step 4: Finance document created in Universal Journal in S4 HANA
This is with reference to activity confirmation.
Step 5: Calculation of Actual Cost
Once you see the confirmation performing in the system, SAP will calculate and update the actual cost.
Total Cost – 46,045.21 (22,569.28+22573.08+902.85) out of this 3 items Production receipt done Cost – 41,486.58
Note- Since its a multi-level cost calculation. Thus no Raw material consumed for finished stock.
However, the Raw Material consumed with Semi-Finished stock.
With this, the system posted accounting document.
Step 6 (The End Result): WIP in SAP S/4HANA System
So, at the end of doing all these activities, the WIP value would be like this.
And its accounting document will be like this.
So, these are the key settings or configuration requirements that we do into the system. And thus, we get the WIP calculation. The whole process is very deep and involves careful handling in order to avoid errors.
These screen images and information in this article gives you a brief idea of the actual tasks that consultants do in real-time.
Related Article: Learn the Concept of Product Cost Planning
Also a Related Video: Business Process in SAP S/4HANA
EndNote
The Work in Progress calculation or WIP in SAP is an important part of the S/4HANA Finance configuration. One must not leave this subject while learning the SAP S4 HANA Finance.
WIP calculation and configuration is part of the job profile of SAP S4 HANA Finance consultants. Hence, if you wish to be a competent HANA consultant or if you already are one, make sure you have knowledge on this subject.
Also Read:
1. Detailed Guide on SAP material Ledger
2. Best Features of SAP Profitability Analysis (COPA)
