on 10-12-2007 9:20 AM
Dear Gurus
How to see which materials are there with 'valuation category' ? ( which t-code or table must I look in)
I also understood that a 'valuation type' can be seen from the 'delivery' tab page for a line item in a P.O.
However I can see fields as 'overdeliv','stock type','shelf life','reminder','incoterms' but no field as 'valuation type' in the 'delivery' tab page for a line item in a P.O. So I took a look in mm03 for the material and it has no 'valuation category' defined. Thus I am assuming , if 'valuation category' is defined in Material master, then only 'valuation type' is visible ?
Can someone guide me here ?
Kind Regards
Manoj
Hello Manoj,
I've checked some PO in our system. In case of materials that have only one valuation type I can't see it on the PO (on 'Delivery' tab).
We have some material of split valuation. For these materials I can see the valuation type on 'Delivery' tab.
Double click on material on PO >> you can go into material master and check the fields you want.
If you copy several material (part number) from your PO, you can do a mass-valuation class - check in MM60.
At the moment I can1t recommend better solution.
BR
Csaba
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Manoj,
You create valuation types for valuation category
category is mentioned in Material master
When you first create material it is valuation type independent
you will have to extend it for a valuation type after that
and while extending it system will ask you for valuation type
if you have mentioned valuation category in material master
Hope its clear
BR
Diwakar
reward if useful
Hi Manoj,
The Valuation type field will be checked in the Organizational level tab of the Material master.
When you enter the value for Valuation category in accounting view 1 in material master. The valuation type which is assigned to valuation category will be pop in the Organizational level tab there you need to assign what valuation type for the same material.
If you assign the two valuation type then the system will valuate the material on the basis of this valuation type.
rgds
Chidanand
Hi Manoj.
Valuation type is there in the material master.
This is the part of split valuation along with valuation category.
If a material has valuation category then it will have valuation type.
which viewing the accounting view of the material master , you can see in the inputfiels are plant and valuation type.
hope it wud have answered ur question
Reward if useful
Shawn
Hi Manoj,
Material master do contain this field.
If you enter MM03 and choose the 'Accounting' view, you can give the valuation type - if it is in use for that material.
If you are in MM03 on accounting view, you can click 'Organisational level' button (it's under the menu) and check it.
I've checked: we use this field (valuation type) only for materials we have split valuation (we can produce or purchase those materials so we have to give how we want to valuate that lot we purchase/produce). If we don't have split valuation for a material the valuation class determines beyond question how that material is valuated - I GUESS.
So, if the material is only procured externally, it hasn't got valuation type, that's why we cannot see it on PO (on 'delivery' tab).
BR
Csaba
Hai,
By using the Tcode <b>mm60,</b> to display the list of materials for the diff plants for the particular material type & material group, you can see the details of material , plant, Valuation type, matl desc, matl grp, matl type, unit, p.grp, valuation category etc., for all the materials present in the plant.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks all Gurus.
My doubt has been cleared.
Excellent contributions all.
Kind Regards
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj
T code SE16 table MBEW
Reward if usefull
Vishal.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Please find serewith some tablesa related to material
MARA Material master
MAKT Material text
MARC Material per plant / stock
MVKE Material master, sales data
MARD Storage location / stock
MSKA Sales order stock
MSPR Project stock
MARM Units of measure
MEAN International article number
PGMI Planning material
PROP Forecast parameters
MAPR Link MARC <=> PROP
MBEW Material valuation
MVER Material consumption
MLGN Material / Warehouse number
MLGT Material / Storage type
MPRP Forecast profiles
MDTB MRP table
MDKP Header data for MRP document
MLAN Tax data material master
MTQSS Material master view: QM
you. can see data from thre tables
Regards
Kedar Kulkarni
**reward if useful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.