SAP123
Articles
Split Valuation By Willem Hoek This notes relates to SAP ECC (ERP Central Component) 5.0 Without split valuation, materials are valued at plant level. With split valuation, the same material number at a plant can have different stock quantity and value for different groupings (called valuation types). The valuation types are set up in configuration could be for example: newd, old or GB, US, AU, ... (indicating countries for example) red, blue, black, etc.... (indicating colors for example) The valuation typs are grouped together in a valuation category So for example, the above valuation types could be grouped by age, country, color. A mater ial is activated by entering the valuation type in the accounting view of the material master. IMPORTANT: It is possible to change a valuation category if no stock and PO were created. However, once a Valuation category is assigned -- it can not be un-assigned (make blank again). So it is not something that get changed at will. It needs to be decided on creation of material. Steps to set it up CONFIGURATION 1. Activate Valuation 2. Create Valuation Category 3. Create Valuation Types 4. Link Categories > Types 5. Link valid Valuation Categories to Plant
MASTER DATA 1. Activate Split Activate Split valuation valuation for a material (Add Valuation Category in material master) 2. Create Accounting views for every valuation type Using Split Valuation in transactions 1. Create Purchase Order 2. Goods Receipt / Goods Issue 3. Physical Inventory 4. Stock Overview
-------------DETAIL-----------------In this example we want to group material in the same plant based on AGE (valuation category). We will have two "groups" (valuation types): OLD and NEW. Configuration IMG: Material Management > Valuation > Split Valuation 1. Activate Valuation - tcode OMW0
Configure Split Valuation - tcode OMWC
2. Create Valuation Category Select: Global Categories
The Ext Mandatory option will force users to enter a valuation type in purchase orders. Select: Create (to save)
3. Create Valuation Types Select: Global Types > Create
Select: Create (to save) The Purchase Orders attributes option indicate if PO's are allowed or not. 1 - Not allowed 2 - Allowed but with warning 3 - Allowed The account category reference determines what GL valuation classes will be allowed. 4. Link Categories > Types Select: Global categories (from main config menu) Select: Valuation Category Select: Types > cat.
Activate valid valuation categories
5. Link valid Valuation Categories to Plant Select: Local Definitions (from main config menu) Select: Plant to use Select: Cats -> OU Select: Valuation Categegory and press Activate
ACTIVATE MATERIAL MASTER 1. Activate Split valuation for a material (Add Valuation Category in material master) Material Master create - MM01
NOTE: It is only possble to change a material (valuation category) if no stock and PO were created. So it is not something that get changed at will. It needs to be decided on creation of material. 2. Create Accounting views for every valuation type - mm01
USING SPLIT VALUATION IN TRANSACTIONS 1. Create Purchase Order - ME21N
2. Goods Receipt / Goods Issue - MIGO
4. Physical Inventory - example MI10
Note that the batch field is used! 5. Stock Overview - MMBE
--------------- END OF DOCUMENT -----------
Get my blog posts in your inbox! email address Subscribe
POPULAR POSTS SAP SD Tables SAP MM Tables Loading Material Masters with LSMW Direct Input method Very basics of SAP External Service Management SAP Finance Tables Setting up simple Release Procedure for Purchase Requisitions Change SAP documents -- tables CDHDR and CDPOS
1
26 Comments
mpsingh
•
thanx sir ji •
manas
•
•
Thanx a lot!! •
•
Alvaro Gonzalez
•
What about if my material does not need the Valuation Type?? when I try to do the GR by MIGO, apperars the next message: "Material 23000046 2000, not subject to split valuation." this material is valuated at plant level, so why is the message reason??? Thks a lot •
•
illem
•
If not required don't enter valuation type info during GR. To see if it is required for your material, have a look at the material master (accounting view) -- as per notes in article above. •
•
Arvind Mehta
•
Because valuation of material at plant level is not a split valuation. •
•
Alvaro
•
how can i fix it? •
•
rv n
e a
•
If it is just a warning, ignore it but if it is not letting you do the posting, we need to see what exactly the error is. -- Arvind Mehta, Project Lead- SAP Supply Chain •
Robert
•
•
Brilliant, split valuation at a glance... •
•
Akhilesh Mishra
•
Very thorough document....Many many thanks!! •
•
ellikkara
•
gREAT Sir !! •
•
ganeshmm
•
realy usefull artical, thanks for sharing it •
Frank
•
•
All the setup for s plit valuation is done. Valuation categories are setup and Valuation Types are configured. I created a material but forgot to enter a valuation category in the Accounting 1 view. I now want to add the valuation category in order to create the material per valuation type. But during MM02, the field "valuation category" is grey and I cannot enter any value. There is no stock, no PO's, no Batches for the material. Any idea on how to add the valuation category? Thanks in advance Frank •
•
Tucanchu
•
In MM01, you need to extend the material. •
Gsdffg
•
•
excellent •
•
ijaypatilsap
•
If split vauation is already active and val cat and valuation types settings are done and working perfectly in production server, Now I have created a new plant in dev when I active val cat for new plant system is not asking for any Transport requests, is it not transported should we do these changes directly in production system???? •
•
ijay
•
Split VAluation tables are not automatically transported. You need to manually transport by selecting the necessary plant and various valuation types •
Jitendra Baghel
•
•
Thank you for this artical - it is realy usfull •
Albert
•
•
Excellent •
•
Partha
•
Awesomeeeeeeeeeeeeee.....thanks a ton..... •
•
Pusarla Venkatesh
•
Awesome document. I s hould really appreciate it, becuase it helped me a lot. •
Ram
•
•
Excellent document. Never seen a better one on Split Valuation. It helped me!! •
Amit Talathi
•
•
really good document •
Zittarello
•
•
Hi, I have a question. Is possible to applicate valuation LIFO to Material that has three split valuations type ? and how LIFO works in this case ? Thank's •
MAX
•
•
Thank you for this article - It helped me a lot. •
K. Ashok
•
•
Good one •
•
amy
•
I create split new valuation type and have assign it to material master, but when I create PO in me21n a can't change the filed valuation type. please help me... •
•
Website built by Willem Hoek SAP is a registered trademark of SAP AG - This website is not affiliated to SAP AG or any of its subsidiaries
