Supply Chain Management Blogs by Members
Learn about SAP SCM software from firsthand experiences of community members. Share your own post and join the conversation about supply chain management.
cancel
Showing results for 
Search instead for 
Did you mean: 
LIngeswar_1437
Participant
0 Kudos
254

Inventory Split Valuation 

Split Valuation: Material can be valuated based on different types of procurement, it is known as Split valuation. 

Split valuation helps in valuating the stocks of a material in the same valuation area (company or plant) differently. 

 Some of the examples where split valuation is required are as follows: 

  • Stock that is procured externally from a vendor has a different valuation price than the stock of an in-house production. 
  • Stock obtained from one vendor is valuated at a different price than the stock obtained from another vendor. 
  • Same material having different batch may have different valuation prices. 

Introduction: 

  • IF you have a material (Raw Material) and this material you procure it from multi supplier’s domestic and foreign (from different countries).Purchasing a raw material from suppliers in Spain, China and Egypt So, the value of this raw material will be different from one country and another So, this will lead to differentiate in value of stock of this material and create one valuation category here and 3 valuation type according to these 3 countries. 

Another case: if you have spare part material and this material has different category (NEW-DAMAGED-Refurbished)  

  • So, the material is the same material but has different values according to its category which means that the material has one valuation category and 3 valuation types (NEW-DAMAGED-Refurbished) 

Example: 

  • You act as spare parts Company and has an oil filter (material) & you have different categories of this filter you purchase this oil filter (new, damaged or refurbished) 
  • So, you have one material has valuation category and this valuation category has  

valuation types in it. 

LIngeswar_1437_0-1719216626086.png

Settings for Split valuation in Customizing: 

LIngeswar_1437_1-1719216626090.png

1) Valuation category could be according to  

  • Procurement type  
  • Country of origin 
  • Quality 

2) Valuation type according to valuation category 

3) Assign valuation category to Plant 

Configuration Settings for Split Valuation: 

Activate Split Valuation:  

SPRO –> IMG –> Material Management –> Valuation and Account Assignment –> Split Valuation –> Activate Split Valuation 

Transaction Code: OMWO 

LIngeswar_1437_2-1719216626094.png

LIngeswar_1437_3-1719216626096.png

Configure Split Valuation: 

SPRO –> IMG –> Material Management –> Valuation and Account Assignment –> Split Valuation –> Configure Split Valuation 

Transaction Code: OMWC 

LIngeswar_1437_4-1719216626098.png

Click on the Cancel button field as shown below. 

LIngeswar_1437_5-1719216626099.png

The Initial Screen will appear  then click on the Global Types (Valuation Type) 

LIngeswar_1437_6-1719216626100.png

Click on the Create button if you want to create a new Valuation type or if you want to use existing one by changing to our related data. 

LIngeswar_1437_7-1719216626103.png

Here I am creating 3 valuation types for Spare Parts  

  • New 
  • Damaged 
  • Refurbished 

LIngeswar_1437_8-1719216626105.png

After maintaining the data click on the create button and then click on the save button as shown below. 

LIngeswar_1437_9-1719216626108.png

LIngeswar_1437_10-1719216626109.png 

LIngeswar_1437_11-1719216626111.png

LIngeswar_1437_12-1719216626114.png

Choose the Global Categories to define Valuation Category 

LIngeswar_1437_13-1719216626116.png

By clicking on the Global Categories, the initial screen will appear and Click on the Create field as shown below. 

LIngeswar_1437_14-1719216626118.png

After Maintaining the required click on the Create button and then click on the save button as shown. 

LIngeswar_1437_15-1719216626120.png

Place the Cursor on our Valuation Category  and click on the Types –> Categories field as shown ( It is nothing but activating the Valuation Types for the Valuation Category) 

LIngeswar_1437_16-1719216626122.png

Place the cursor on the Valuation type and click on the activate button as shown. 

LIngeswar_1437_17-1719216626125.png 

LIngeswar_1437_18-1719216626128.png

Next click on the Valuation Categories to organizational Unit field as shown (It is nothing but activating the Plant to Valuation Category. 

LIngeswar_1437_19-1719216626130.png

The initial screen will appear and place the cursor on the Plant and click on the activate button as shown. 

LIngeswar_1437_20-1719216626132.png

LIngeswar_1437_21-1719216626134.png

These are the Configuration Settings for the Inventory Split valuation that to be maintained before going into the Process flow. 

Now create the Material in MM01 Transaction 

Assign the Valuation Category in the Accounting 1 View 

Assign valuation category to material on accounting view 1& make sure from this material it should be moving average material. 

LIngeswar_1437_22-1719216626137.png

Next, we can assign the valuation Type in the Material Master to assign its price in the accounting View 1 for the different Valuation Types. 

 LIngeswar_1437_23-1719216626140.png

Maintain the Moving Average Price 100 USD for Valuation Type (V_NEW) 

LIngeswar_1437_24-1719216626142.png

Manual change the MAP to Standard Price I am maintaining the 10 USD for valuation type (V_Damaged) 

LIngeswar_1437_25-1719216626144.png

Maintain the Moving price 50 USD for valuation type (V_Refurb.) 

LIngeswar_1437_26-1719216626147.png

Next, Create the Purchase order with material category types New and refurbished. 

 LIngeswar_1437_27-1719216626152.png

PO Material created under - 2000057. 

Check the Stock Overview in MMBE for the material 90001. 

LIngeswar_1437_28-1719216626159.png

Next step Goods Receipt w.r.t Purchase Order in MIGO Transaction 

LIngeswar_1437_29-1719216626165.png

Material document 16 posted. 

LIngeswar_1437_30-1719216626169.png

Check the Stock Overview in MMBE 

LIngeswar_1437_31-1719216626171.png

10 Qty of our refurbished material were damaged. So, we need to move the quantity from Refurbished to damaged. 

LIngeswar_1437_32-1719216626176.png

Material document 400000023 posted. 

LIngeswar_1437_33-1719216626179.png

 

 

Labels in this area