MPN Settings problem in OMT0

[Former Member]

Hai Experts,

I am doing MPN Setting.

I couldn't be able to get MPN Fields in Material master, So i went to OMT0 T.Code, There i checked

Manufacture part no : check box. & saved it. then immediately i got error message that

" Check whether a corresponding database index exists "

Message no. MM051

Indicator Field name Index

KZPMA MARA-PMATA PMA

KZPMV MVKE-PMATN PMV

KZNFM MARC-NFMAT NFM

KZVBM MARC-VRBWK/MARC-VRBMT VBM

KZPRG No index necessary

KZSAT MARA-SATNR O

KZSTD MARC-STDPD STD

KZMPN MARA-BMATN MPN and BMA

Pleas guide me what i have to do ? to get fields in material master.

[Former Member]

Hi Satya,

I am also facing the same problem while creating the material master.

I have checked the OMS9 and OMSR setting and 124/ 123 field groups are optional not in Hide.

If you know the solution, kindly post me solution.

Thanks in Advance,

Suresh Kumar P.

[Former Member]

Mr.Pithani Suresh ...

Go to OMT0 , Where u have to activated Manufacturer part no.

then u can get the fields in Material master

[former_member192897]

First you Set the Manufacturer Part Profile in ONPN then Go to Material Master and Check in Purchasing View.

If you are not able to See the same then go to OMSR & OMS9 and Check the Fields are Hidden.

Here is the Process of Manufacturer Part Profile :

Create External No ranges for Vendor Account Group MNFR and save.

Now Create Each Make / Manufacturer like ABB as one Vendor in XK01 Trxn code.

Create Material Code original say XXXX in MM01 with ROH material type. (for eg Transistor which is available with ABB & Seimens make)

Create material code for ABB make say 11with Material type HERS which contain only two views (Basic Data & Purchasing) and give Make, Original material No & Material group and other details and save.

Create material code for Seimens make say 12with Material type HERS which contain only two views (Basic Data & Purchasing) and give Make, Original material No & Material group and other details and save.

Create a Purchase order with original Material XXXX, then it will ask for mnfg part profile then select the material and click F4 on it it will show you the created mfg part nos like ABB 11 & seimes 12 and select one and save.

Prerequisite is you have to Activate Mfg part profile in OMPN trxn code

And in Material master Purchasing View Select the mfg part profile and save

Even if you set the Mfg part number in Display mode in SPRO settings system will throw the same error.

Now What can be done is :

Either go to ME21N and Select material tab after inputting and press f4 and select Manufacturer part number options then system will showe the list of mfg part number maintained to that material select the desired and save.

Else go to MM02 Purchasing View and in Mfg part Profile tab there must be a four charecter profile assigned to field Remove this and save.

The Second option is not a good practice.

[Former Member]

Hi,

I think that you have :

1- First to assign a "Manufacturer Part Profile" to you Material in Material master record, Purchasing View.

You can customize Mfr Part profil through Tcode OMPN

2- You define the different MPN for your Material through Tcode MP01

Regards