Skip to Content
0

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

Apr 15, 2017 at 04:02 PM

70

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Jürgen L
Apr 15, 2017 at 04:05 PM
0

I do this all year - where is your difficulty?

Share
10 |10000 characters needed characters left characters exceeded
Ajit Patil Apr 15, 2017 at 04:10 PM
0

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 ?

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Apr 15, 2017 at 05:14 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Ajit Patil Apr 16, 2017 at 11:19 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Apr 16, 2017 at 10:25 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded