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.
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.