Material data cleansing

[#1]

Dear friends,

Can you pls help with your expertise for below mentioned scenarios?

Material data cleansing:

We are planning to create new material code numbering to all of the existing material >= 140,000 with "international standards and our own company customized Numbering."

1.How should we start with new materials (transaction MMNR) and how we should discontinue old materials(tcode-MM06)?

What is effective method to do the same as the number is so huge?

2.What will be impact on the existing thousands of open orders with old materials? And what will be other issues.

3.Do we need to take separate database or instance for cleansing of all material and then finally move from that database/instance?

4.What are the critical parameters in material master that we need to care during cleansing?

It will have much wider impact across transaction Work order, PR, RFQ, Contracts, PO, GR, IR and other sales transaction and other modules.

And thatu2019s why we need to tackle it smoothly.

Rgrds,

Deep Jain

[Former Member]

Hey

Why dont you try with Material to material transfer?

For this both the material masters should exist in the system. (Existing and new one you are going to create)

Both should have the same unit of measure.

Transfer can be happen only from unrestricted stock.

New material master number range can be created in MMNR

After transfering the material to material masters can be archived using MM06 and SARA

Check it out

Regards,

Raman

[Former Member]

Dear Friends/Raman,

One of many issue that lies here is that tens of thousand of long pending open orders in system then how we can close them. And by what timelines the old material must me discontinues?? It will have much wider impact across transaction Work order, PR, RFQ, Contracts, PO, GR, IR , sales and other transaction.

As I understand that there will be financial impact on the use of 309 movement type for material to material transfer, one material document will be created but with two line items. An accounting document also will be created along with the material document capturing the financial impact of the transfer. i.e. if both are having different valuation classes and hence different account postings, the issuing material stock a/c is credited and the receiving material stock account is debitedu2026Is it the right way??

Does only stock keeping unit need to be same for the material to material transfer? Is there any other field dependency???

Can we go with the same SAP Instance as we have Now Dev, Quality and Production OR Will it be better to go with separate instance for this cleansing activity?

Can you pls help me in getting different strategy to implement the same with their advantages and disadvantages?

Rgrds,

Pradeep Jain