Changing existing material Number ranges, base unit of measurement and description.

[former_member293372]

Hi gurus,

I working on SAP to SAP migration and i got below requirement form client.

Cline is international and in India they are using SAP from last 15 years and they want keep same material master data globally.

requirement is as below.

1) Globally they are using Material number ranges 9 digit and in India 8 digit they want to convert it 8 to 9.( they want to change existing number ranges as per material type)

2) want to change material base unit of measurement as per globally

3) Want to change material description as per globally.

Can we meet this requirement?

Please help.

[JL23]

Why would you want to close all open documents?

I thought you want migrate them from one SAP system to another SAP system. Why would you need to add extra work that is not needed?

In an existing system you can't change the key fields, not even with LSMW.

[former_member293372]

Thank you Jurgen,

As you mentioned i will check solution through Z table with the help of ABAP.

apart form that i suggested to client below flow if they want to change existing number ranges.

1) close all open documents of all materials (PR, PO, GRN, LIV, Delivery, BOM etc.)

2) Once its done then we will go for LSMW with require changes (Number ranges, BUOM, Description)

It will work or not?

[JL23]

if you do a SAP to SAP migration then you can exchange anything you want and need to meet the architecture of the target system.

Of course needs this a good preparation where exchanging of the material number is the easiest part.

You create a Z-table for the mapping with a simple structure, just 3 fields.

I use this all the time, this table holds the customizing mapping as well as the mapping of master data and document numbers

Field name; old value, new value

MATNR; 000000000000012345; 000000000000067890

Parts are maintained manually, other parts will be written automatically during the migration.

I usually do migrations IDoc to IDoc as explained in this blog: https://blogs.sap.com/2013/05/30/lsmw-migration-with-idoc-method-and-using-idoc-as-source/

E.g. the new material number will be determined via function module NUMBER_GET_NEXT in LSMW mapping rules and automatically written back to the Z-table where other migrations, e.g. purchasing info records, Bill of materials etc will then check this table for the new material number.

Different units require usually more preparation, we often face the issue that packaged materials are maintained in KG while we use eg. EA as the base unit. So we need the target unit and the conversion ratio and have to recalculate the quantity fields in the material master.

For this we usually add classification in the old system and let the user enrich the data, much more secure than using Excel where often nobody knows what the latest and completest version is.

[former_member293372]

Thanks Jurgen,

For quick reply.

Actually i want to know can we change existing number ranges, material unit of measurement? (I know it is not possible as per SAP standard)

If we want do it how can we meet this requirement it ?

[JL23]

I do this all year - where is your difficulty?