Knowledge Management

Question:
Could anyone please inform me about the necessary steps to carry out a massive valuation class modification in the material master?
Thank you
Answer:
Hi Anuska:
For "professional" SAPpers, the word modification means to change a Standard SAP program, which I don't believe that you want to do.
If you want to change valuation classes in multiple materials, then the long text of Message M3 368 tells you how.
Cause:
You wanted to change the valuation class. However, this is not possible because one or more of the following already exist for the material:
Valuated Stocks in the current period or in the previous period
Open Purchase Orders or Delivery Schedule Lines
Production Orders for which a goods movement has already taken place
System Response:
Your change is reset by the system.
What To Do:
If valuated stocks already exist, you can change the valuation class only as follows:
A) Post the stocks of the material to an interim account.
B) Change the valuation class in the material master record.
C)Post the stocks of the material back to their original account.
If open purchase orders already exist, you can only change the valuation class if you first flag the corresponding purchase order items for deletion.
If production orders exist for which a goods movement has already taken place, you can only change the valuation class if you first set the status of the production orders to Deleted.
Sys_Admin:
In Customizing for the Material Master , you can switch the check for open purchase orders and/or for production orders to a warning. You do this in OMT4 by assigning the message type Warning to message MM 326 and/or MM 327 respectively. However, first ensure organizationally that further processing of the open purchase orders or production orders cannot result in inconsistencies.
We usually post the stocks to a cost center with a 201 Movement Type, then change the valuation class, and then reverse the Material Document with MBST, which moves the stock back into inventory.
I hope that this helps.
_________________
Ciao,
Sackman
SAP Consultant
Answer:
Hi Sackman,
Your explanation was so detailed that I would not make any further comments as far as the technical recommendation is concerned. However, it is very much critical that the business implication shall be taken into due consideration prior to taking any technical implementation. If you are looking at mass maintenance of valuation class, what it does mean to financial reporting, or the possible inconsistency between MM stock value and FI/CO booking value which will be seen in MB5L transaction.
Cheers,
HT
Answer:
Thank you very much Sackman.
Best regards,
Anuska
-----------------------------------
Hi Anuska:
For "professional" SAPpers, the word modification means to change a Standard SAP program, which I don't believe that you want to do.
If you want to change valuation classes in multiple materials, then the long text of Message M3 368 tells you how.
Cause:
You wanted to change the valuation class. However, this is not possible because one or more of the following already exist for the material:
Valuated Stocks in the current period or in the previous period
Open Purchase Orders or Delivery Schedule Lines
Production Orders for which a goods movement has already taken place
System Response:
Your change is reset by the system.
What To Do:
If valuated stocks already exist, you can change the valuation class only as follows:
A) Post the stocks of the material to an interim account.
B) Change the valuation class in the material master record.
C)Post the stocks of the material back to their original account.
If open purchase orders already exist, you can only change the valuation class if you first flag the corresponding purchase order items for deletion.
If production orders exist for which a goods movement has already taken place, you can only change the valuation class if you first set the status of the production orders to Deleted.
Sys_Admin:
In Customizing for the Material Master , you can switch the check for open purchase orders and/or for production orders to a warning. You do this in OMT4 by assigning the message type Warning to message MM 326 and/or MM 327 respectively. However, first ensure organizationally that further processing of the open purchase orders or production orders cannot result in inconsistencies.
We usually post the stocks to a cost center with a 201 Movement Type, then change the valuation class, and then reverse the Material Document with MBST, which moves the stock back into inventory.
I hope that this helps.
Answer:
Ha Tran,
thank you once again for your "beware" remark on this hot topic.
Sackman,
thank you for your post. i have been investigating the risks of going this route and read thoroughly what was posted by some of you and other MM regulars.
we all seem to agree that its possible to change a material valuation class after having stock. the way you suggest (i.e. posting via 201 to CC in MB1A followed by reversal in MBST) is possibly the "cleanest" one. now, one question remains and you might be in position to advise us:
-after changing the Valuation Class in the Material Master, the way you describe, did you face any problem/inconsistency/difference in MB5L between MM and FI stock values in the long run (say, at closing/year end)?
thank you in advance for your advise.
daniel
Answer:
Hello Daniel & Ha Tran:
So may people (in this forum) ask me How to do this or that in SAP, that I often don't spend the time to counsel them on whether it is a good idea or not. Of course, if we take ourselves seriously as consultants, this is an important part of our job.
I can tell you definitively that I have helped one of my customers do this exact procedure on multiple occasions, and it had no long-term negative impacts.
I think that this really comes down to what the FI & CO Key Users are willing to tolerate and accept. Of course, if you change Valuation Classes in the middle of a period, the G/L Postings will differ from before the change and after the change, and therefore, also the basis for evaluation will not be the same.
In my customer's case, I think they felt that those materials had been posted to wrong (from their perspective) G/L Accounts for too long, and they simply wanted to "correct" the problem, while keeping the same material number.
The most important point, to consider if you do this is to close all open logistics documents, which was hopefully clear in my previous post.
As with many "solutions" in SAP, there are pros & cons, and it is necessary to discuss which solution makes more sense within the group of those who will be directly impacted in order to make the correct decsion for that business scenario in that company.
I hope that this helps.
_________________
Ciao,
Sackman
SAP Consultant
Answer:
Sackman, again many thanks for your time and concern in this topic.
all the best,
daniel
Answer:
Hi all,
We use a batch input wich moves the stock to a temporal material with a 309 mvt., then we change the valuation class and reverse the mvt with a 310 mvt.
It have no impact in consumtion neither in controlling
You must have one temporal material for each measuring unit you use.