Material Master - Sub Classification

[Former Member]

Hi Friends

My client has a problem in inventory matching. To avoid this, business wants some of their steel Materials to be sub classified according to the batch/Coil No.

Suppose we have a material with material no. X ( Specifications HA3PO 200 X 6). This material is supplied by a vendor under different Batch/ Foil NO.

These batch / Foil NO. are defined as per the length and width of the coil. Now the business wants to include the batch/Foil No. as sub category of the material.

They are at present marinating the info in an excel sheet and they are facing problem in matching inventory to the SAP system. To get rid of this they need a solution.

How do we map this and where should we do? I'm not a MM conslt, but need to help the business quickly.

Your help will be highly appreciated.

Thanks

[Former Member]

Go for Variant configuration if possible. The master maintenance activity will be one time activity but it will easier for daily operation.

[Former Member]

Thank you all for your prompt responses.

One mre quick qustion, under one material how many subclass we can create? My client has 25-30 sub classes in each material.

Thanks

[former_member529134]

Hello PK

You can maintain as many valuation types (subclasses in this case) as you want for a material.There is no restriction for that.

The only thing is that you have to create the valuation types and do the assignments in SPRO initially.

Regards

[Former Member]

Greg

The batch/coil no's will change from month to month, it all depends on suppliers naming onvention. So we can't maintain master data.

To larify more please find the brief description. I will be very happy if anyone can give a feasible work around..

Brief Desc,

The business does a monthly forecast on the steel required for the usage and based on the forecast they will raise a PO for material required and quantity. Once the consignment is delivered itu2019s received at X location.

The steel is supplied by each vendor in their own specifications which would be in the form of batch/Coil No. The batch/coil information is provided to the busness by the supplier beforehand. Each material can have multiple Batch/Coil nos. The steel inventory is kept in excel by the stores people. Please note that the batch/Coil nou2019s will not be the same every month, its description entirely depends upon the supplier. So we canu2019t maintain a master data.

When ever there is a specific usage of the steel the business transfer the material from X location to B. The transfer could be from any of the batch/coil nou2019s , but we canu2019t confirm from the system that which coil we are using. So in order to maintain the record and to avoid hassles in reconciliation the business wants to have a separate field when they transfer material from Vco1 to LSo1. (MB1B is the transaction for the transfer)

Please note that the business pays only to the material theyu2019ve used not the whole consignment. So both the business and the supplier of the steel, wants to keep track of their steel by the individual coil number so as to avoid any mismatch.

Hope you understand the issue and give me a feedback asap.

Thanks

[former_member529134]

Hello

Is it that the material will be having some specified size configurations or it can have many variations?

If it is having specified size configurations you can go with split valuation as Pankaj said.

In split valuation we can split a particular material in SAP and keep track of it both quantity and value base. And when you create a puirchase order or a goods movement, along with the material number we will enter the valuation type (the identification given to various size configurations of the material).Thus the material movement of each size configuration can be tracked.

But the problem is that you have to create the master record for every valuation type so for that you must be having a knowldge of all size configurations.

Regards

Gregory Mathews

[pankaj_singh9]

Hi,

It is suggested to use concept of Split Valuation for this so that you will get proper tracking of Quantity as well as value of stock.

I will explain this with an example, For e.g. valuation criteria is SUBCLASS

Go to OMWC - Configure Split Valuation

Here Create Valuation Category as for e.g. "SUBCLASS" and Valuation Types as "FOIL NO 1" and "FOIL NO 2"

Here in Valuation types, you can assign the Account Category Reference

And in OMSK - You can define 2 Valuation classes and assign these to 2 Account Category References

Now in OBYC - Maintain Account Determination for Account Key BSX as per the valuation class

Refer following link for detailed configuration of Split Valuation

[Split Valuation Process|http://www.sap123.com/showthread.php?t=29]

[Split Valuation Help|http://help.sap.com/saphelp_erp60_sp/helpdata/en/8f/d1de34e4cb2300e10000009b38f83b/frameset.htm]

Process Flow: -

1. Create Material Master for Asset in MM01, maintain valuation category ORIGIN in "Accounting 1" view and extend the material master for all the above 2 valuation types and input the value.

Here in your case Valuation Types will be "FOIL NO 1" and "FOIL NO 2" and also assign the respective valuation classes.

When you want to Purchase materials then,

1. ME21N - Create for Material with valuation type "FOIL NO 1" or "FOIL NO 2" as per requirement, maintain it in "Delivery" Tab

2. MIGO - GR w.r.t. PO (GR of material will be done in valuation type as per maintained in PO "FOIL NO 1" and "FOIL NO 2"

3. MMBE - Stock Overview (Here you can see the stock as per valuation type "FOIL NO 1" and "FOIL NO 2"