4 Replies Latest reply: Jan 15, 2009 9:25 AM by Satya K RSS

MPN Settings problem in OMT0

Satya K
Currently Being Moderated

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





KZPRG   No index necessary





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

  • Re: MPN Settings problem in OMT0
    Meher SOUAYEH
    Currently Being Moderated




    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





  • Re: MPN Settings problem in OMT0
    Ashok Kumar Telugu
    Currently Being Moderated

    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.

  • Re: MPN Settings problem in OMT0
    Pithani Suresh Kumar
    Currently Being Moderated

    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.