Split Valuation Vs Plant no value updated

[ali_dai]

Dear all,

I have a request to activate split valuation (in order to differentiate between materials with price -NEW- and with zero price - USED) for materials in a system already with 2,5 years of data. As the issues are a lot and known i was thinking of creating a new Plant with only quantity update and not value update instead.

Of course this is not the best approach and this i why i would like your thoughts on it.

BR

[ali_dai]

Hi Jurgen,

In this particular company code we are referring only to MM as no SD/PP/PM exist. We do not have BOMs, Equipments or EQUI BOM's. The idea of the 2nd plant is not to replace the existing plant. Info records etc should exist in the existing plant (i.e purchased materials). The 2nd plant would be a plant non-valuated in order to bring back used materials without value and in order to be able to distinguish every time which one to select.

The scenario is that this plant is used for materials used in drilling procedures (spare parts, chemicals etc). The business (now-after 2 years of live and with split valuation already active in other plants) decided that split valuation must be activated for this plant as well. The purpose is only to be able to distinguish the used materials from the new-purchased ones for inventory and accounting purposes.

In this case, the only impact is to create the materials in the new plant that will be created.

As concerns the volume, the volume of the materials is around 8400 and the 42000 PO line items (EKPO without taking into consideration deleted PO's, on hold etc).

[ali_dai]

Hi both,

Thanks for your answer.

Jurgen of course the question is not about the split valuation but on how to you think of the alternative of creating a new plant, as split valuation is as we all know quite complicated.

Anyhow, for split valuation the jobs to be done are:

1. Remove all stock

2. close open PO's

3. Delete all line items (with MEMASSPO)

4. Activate split valuation

5. Mass change materials' valuation category

6. Create valuation types of materials (with LSMW- already there)

7. Upload stock

8. Reverse deletion of old PO's.

9. Create new open PO's

For the plant are:

1. Create plant as no value update

2. migrate all materials to new plant (easy with Jurgen's post to create materials with LSMW using IDoc)

Please bear in mind that no archiving is in question here. Certainly something has to be done, either the 1st or the 2nd solution. To me the 2nd is easier, however the 1st is more SAP standard.

BR

[JL23]

In my eyes you forget all the other modules which make use of master data like material master who then have to recreate their master data under the new plant too. for me does the SAP world not end at the border of the MM module.

Also you have not listed info records, even in cases you have just 1 purchasing organization it is likely that users created info records at plant level (analyze your EINE table) which will not be found when you change over to a new plant. There might be source lists (pure plant level) and contracts, price conditions, and message conditions.

I would not give a preference to any without knowing the business and the volume of master data.

[JL23]

see OSS note 155874 - Change valuation category in material master for the prerequisites, this OSS note was already recommended in more than 30 similar discussions, make sure you search before you ask, it's a rule.

Based on these pre-requisites I doubt that you are able to perform this transition without longer downtime and serious business impact and I also doubt that your business wants to waive the history and recreate all currently open documents again. Not to mention all the needed customizing and testing for archiving, which is not easy going, it uncovers all mistakes from the past and also can only be carried out for completed business cases, which means you have to complete what is currently open or need to cancel it. Both can add extra confusion to the transition as you have track outside SAP what needs to be recreated. Certainly a project for many weeks or months .

Creating a new plant is not less work intensive, as you also need to cancel the open documents and need to recreate them. While you still have history for old business cases you have to extend all master data (material master, bill of material, security settings etc) to the new plant. This is as well like a migration project.

I would recommend to get in contact with a SAP's SLO team to get an estimate about such a project.

[Prasoon]

Hi,

Creating a new plant for the above purpose is not at all suggestible. You can very well go for split valuation and maintain two valuation types. For "USED", you may maintain price control as S with price as zero, which ultimately wont update inventory value for the valuation type.

Ofcourse, activating split valuation is bit complicated - however, you can check the open documents, stock etc and remove the same before activating split valuation. Please note that the stock has to be zero in the current as well as previos period. Simple LSMW and MASS can do most of the transactions.