11 Replies Latest reply: Jul 3, 2013 7:40 AM by Farooq Basha RSS

Material Master Locked & Deletion Flag

Ramachchanthiran S
Currently Being Moderated

Hi

 

1. Is material master locked and material maser deletion flag set are same or diffenent? explain

 

2. How to see the list of materials flag for deletion? is any t code or from table how??

 

Vijay

  • Re: Material Master Locked & Deletion Flag
    Prashant Kumar
    Currently Being Moderated

    Blocked means you cannot do any furhter processing at the block level.

    Flag for deletion means after sometime Standard SAP program will run and the Material will be deleted(Archieved) from the system.

    Check Table MARA,MARC & MARD for different level of Blocking or flag for deletion.

  • Re: Material Master Locked & Deletion Flag
    amit bafna
    Currently Being Moderated

    Hi

     

    1. Is material master locked and material maser deletion flag set are same or diffenent? explain

     

    Material master locked is when one user will try to use material code which is currently used by another user so he will get the message that material is locked by user xyz.

     

    Deletion of material will avoid the user to do any transaction on such material which is flag for deletion as if this maeterial is not in use.

     

    2. How to see the list of materials flag for deletion? is any t code or from table how??

     

    to see the material mark for deletion go in se11 table mara and get all the data for which LVORM = 'X'.

    Vijay

  • Re: Material Master Locked & Deletion Flag
    Manish Kumar Agarwal
    Currently Being Moderated

    Material master locked and material maser deletion flag set are not same.

     

    Material master will be locked , if two users will try to do the changes in same time in same material, that time system will give the error message that Material is locked.

    deletion flag can be set to any material by using transaction code MM06. and to see the list of material with deletion flag you can use the table  MARA and the field name is LVORM

  • Re: Material Master Locked & Deletion Flag
    Dhawal Desai
    Currently Being Moderated

    If u mean to say Blocked,it is blocked temporarily,u can actovate it again

    & if u set the material for Flag for deletion,it will archive in the system & then del;eted gradually

  • Re: Material Master Locked & Deletion Flag
    Aditya Shukla
    Currently Being Moderated

    Hi,

     

    When two different user try to access same data at same time, like material stock, or try to edit same data, like try to change same material master, then system gives message " XXXXXX is blocked by user XXXXXX".

     

    Deletion flag is set to prevent the use of that particular material in the process. If, I want that users should not use a particular material in any process, then i can set a deletion flag. During year end activity, we can archive that data. Suppose a material is no more in the use, why to maintain the data.

     

    Thanks,

    Aditya.

    • Re: Material Master Locked & Deletion Flag
      Jürgen L
      Currently Being Moderated

      Deletion flag is not set to prevent use of a material, the deletion flag does nothing than issuing a warning in a standard system. Please read more details in my blog: Material master deletion flag and blocking activities

       

      you are totally wrong with this assumption: "During year end activity, we can archive that data."

      if a material was in use, then it has collected stock data. you have created many transaction data using this material number. You can only archive a material if stock data for current and previous year are zero, if no data exist in the system that makes use of this material, which means you have to archive all created data and dependent master data like info record, bill of materials, orders prior to the material master archiving. if you never did any archiving,  then be sure you cannot archive a material with deletion flag for many many years, maybe never if you have no overall archiving concept.

       

      the lock XXXXXX is blocked by user XXXXXX, only one user can update a material at a time, that is like a tunnel with just one lane, it is not possible to access this tunnel with 2 cars side on side.

  • Re: Material Master Locked & Deletion Flag
    Farooq Basha
    Currently Being Moderated

    HI,

     

    Material master locked is when one user will try to use material code which is currently used by another user so he will get the message that material is locked by user.

    Blocked means we can't do any further processing action at the block level and using program run we can able to delete the material, using MARA, MARC MARD tables can find the different level of Blocking and Flag for deletions.(Tcode MM06)

    Using T.code SE11--> MARA -->LVORM(X)


    Regards

    S.Farooq Basha

Actions