Internal number ranges for Material master and vendor master

[Former Member]

Hi Team,

We have decided to use Internal number range for Material master and vendor master, I want to know the precautions I should take because same number should be in all clients i.e Dev, Quality and Production.

we are using LSMW for the same,  While uploading the data there is chance of error in any of the clients  so there is possibility  that the number may differ in that client for same material in another client.

Please guide me how to resolve this issue or any method by which synchronize  all the three clients to have same numbers.

Thanks in advance. 

[JL23 · Accepted solution]

In general it is not a good approach to keep the numbers equal in DEV, Quality and Production.

if someone creates a number manually in any of the three systems, then your logic is broken anyway.

But if you are acting alone, then it is possible.

if you use IDOC method to load the master data, then you can pre-assign the internal numbers using the function module NUMBER_GET_NEXT.

further you need a z-table to  write old and new number into it as  cross reference table.

then you need a logic for the material number basically  like that:

select new number from cross reference table.

if not found call the function module to get a new number

write new number to the cross reference table

in the first system you get always a new number via the function module.

In all other systems you get the new number from the cross reference table.

[Former Member]

Hi,

This is unusual requirement, why you need this, please share you scenario of such requirement.

You can also maintain development and quality client  as per production by coping production system periodically (Weekly/biweekly/fortnightly/monthly).

This way not only vendor master but other transactional data will also be the same.

Best Regards

Ruksana