cancel
Showing results for 
Search instead for 
Did you mean: 

How to check list of blocked material?

Former Member
0 Kudos

How to check list of blocked material?

Accepted Solutions (1)

Accepted Solutions (1)

former_member183424
Active Contributor

Hi,

Its depend on which procedure you have done for material blocking.

If you have block for "X-plant matl status" on basic data 1 tab.

Then you can see the blocked material from table MARA, with filtering value 01 or 02 for field MSTAE.

If you have block for "Plant-sp.matl status" on purchasing tab,

Then you can see the blocked material from table MARC, with filtering value 01 or 02 for field MMSTA

And if you used MM06 for deletion flag for material,

Then you can see the blocked material from table MARA, with filtering value X for field LVORM.

DEV

Former Member
0 Kudos

Hi Dev

Material transferred from other place under 313 (migo) and now it's under blocked. I want to see the list of these documents raised.

former_member183424
Active Contributor
0 Kudos

Hi,

This is called material blocked stock.

If you check the stock you can use t-code MB52 and MMBE.

If you want the material document number for movement type 313, please use MB51.

Go to MB51, Specify movement type 313 and others(If you have), then execute.

DEV

Prasoon
Active Contributor
0 Kudos

Hi,

   The movement type 313 wont block material, it can be used for  unrestricted material only. The movement type 313 is for transfer posting material within the plant - from storage loc to storage loc in two steps. 313 will remove from storage and 315 will place in storage.

   You can find the details of material movement from MB51 transaction. If the material is removed from storage and not placed in storage, use 315 to place it in storage in MB1B.

   The material can be moved to blocked stock using 103, 107, 322, 325, 344, 350 etc. You may insert these movement types in MB51 along with material and other details to get the exact movement.

Regards,

AKPT

Former Member
0 Kudos

Thanku so much

Former Member
0 Kudos

thanku so much for your valuable suggestion

former_member676866
Participant
0 Kudos

Great Answer

Answers (1)

Answers (1)

Prasoon
Active Contributor
0 Kudos

Hi,

   As of my knowledge, there is no standard transaction to get the list of blocked materials. You may create a query in SQVI transaction or develop an abap report for the same, using the tables MARA, MARC, & MARD as per requirement.

   If you use MM06 and put deletion flag for the materials, you can track the same with the following table and fields:

DF at Client Level: MARA-LVORM

DF at Plant Level: MARC-LVORM

DF at Storage Loc Level : MARD-LVORM

DF at Sales Org Level: MVKE-LVORM

  

  If you block the materials using x plant material status or plant specific status, you can use the fields MARA-MSTA or MARC-MMSTA as explained by Dev.

Regards,

AKPT