Different issue value of same material based on procured price

[Former Member]

Hi gurus,

Please help in below scenario:

Material "X" is procured at three different rates e.g. 10,12 and 14 and same is issued to Cost Centre / Production Order (for e.g. A,B and C). Now the requirement is, I should get a report that if same material was issued @10 in cost centre "A", @12 in cost centre "B" and @14 in cost centre "C".

How can I get this report / do the required config

thanks

[JL23]

Is it directly ordered to the cost center or do you store the material first in your warehouse and issue it later to the cost center?

Do you have batch management and/or split valuation activated?

[Former Member]

We store it first, then issue. We can maintain both batch mgmt and Split valuation activated.

1. Can we have the required reporting if we go with only batch management activated. If yes, kindly share how

2.Else how the same can be achieved through split valuation

thanks

[JL23]

Batch management is used to to identify individual quantities, e.g. based on receipt date, vendor.

Without split valuation you know just individual quantities, but all have the same moving average price.

Hence you need to have split valuation at batch level. Only this triggers that each batch has its own value. And then you can issue the batch with its specific value.

[Former Member]

Thanks a lot for the clarification. Just one more clarification please;

If we maintain the material with valuation type as say "X", "Y" and "Z", shall we have to maintain the same batch each time while receiving goods e.g. batch "X" for 

valuation type "X", batch "Y" for valuation type "Y" and so on, OR let the system take the batch number automatically (internal number) and moving average price of the

material will be maintained valuation type wise irrespective of number of batches against each valuation type.

Kindly clarify this confusion.

[JL23]

Easiest way in your case is  valuation category B  for batch.

When you do a GR then a new batch is created and SAP automatically adds a valuation type with the same number to your material master. No need for manual maintenance of valuation types. No need to assign a batch number manually either.

[Former Member]

Hi,

Created a material with valuation category "B" and not maintained any valuation type. While creating PO below error is there:-

Valuation data for material TEST123, valuation type 02, not maintained

    Message no. ME127

Kindly suggest

Thanks

[JL23]

I am sorry, shouldn't have just said B for Batch, this is an individual setting in cusotmizing.

The important thing is that your valuation category has a flag for "Determine val. type automat"

In OMWC click the global categories, and then select your category and set this indicator in change mode. Maybe you have a category X, X is set for automatic in my IDES system.