Material number change.

[Former Member]

Hi all,

Is it possible to change material number in SAP; that is to change old material and put a new number.

Regards

Sappy

[former_member581212 · Accepted solution]

hi,

Its to change the NUMBER but not number range....

USE MMNR, click on Group button and right click on mouse.

, insert group, Enter Text for Material type and Enter interval from number to To number and press enter.

MATERIAL NUMBER RANGE:

can use enhancements MGA00002 & MGA00003 on Material Number Ranges...

Hope it helps..

Regards

Priyanka.P

[Former Member]

This message was moderated.

[former_member370070]

Probably easiest to just create new materials, with the new numbers, in refernece to the old ones.

[Former Member]

Hi,

It is not possible to change the matrial number. If still you want to change th number then contact ABAPER.

With Regards

Saeed Arif

[Former Member]

Undating the Table entries directly will create auditing problems so never try this option

[former_member181995]

Sorry i'm worried that is possible but i would never suggest you to do this.

possible ways:

1:You could use the material number you want changed as a template to create a new material. Then archive the old material number.

2:

UPDATE MARA 
SET MATNR = 
WHERE MATNR = . 

COMMIT WORK. "i would never suggest.

reason:Matnr is the primary key and foreign key as well for many many SAP table if you are daring to do this than i lost after thinking your SAP system database integrity.

so please go with first possible way and old material you may either delete or achieve.

Edited by: Ámit Güjärgoüd on Oct 15, 2008 6:06 AM

[former_member192897]

It is Not Possible to Change Material Number Once Created.

Why you want to change the Material Number Instead You Can Block it For Further Postings and Can create New Material Record.

[Former Member]

I'm afraid it's not possible.