Material Master Locked & Deletion Flag

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi

1. MARA LVORM = 'X' is giving the data which is marked deletion at client level. Is thr any way to see the material deletion at plant level and str loc level??

2. Thr is a filed MATFI in MARA is giving the data which are locked?? Wat is this?

Vijay

[Former Member · Accepted solution]

For plant level see MARC -LVORM and MARD - LVORM for storage loc level.

[Former Member · Accepted solution]

Hi ,

1) LOCK means someone is in change mode of that material and you can not do anything with that material for that time period .

2) If you want to check the deletion flag then I suggest you instead of checking MARA for deletion flag check *TCODE MM06. *

If will give you a broader idea liek at which level it is marked for deletion .

Hope it solves your query.

Regards,

Anupam

[Former Member]

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

[Former Member]

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.

[JL23]

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:

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.

[Former Member]

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

[Former Member]

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

Using table MARA u can extract the required data

[Former Member]

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

[Former Member]

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.