This discussion is locked
7 Replies Latest reply: Nov 25, 2013 4:30 AM by Rajesh Yadav RSS

How to check list of blocked material?

Rajesh Yadav
Currently Being Moderated

How to check list of blocked material?

  • Re: How to check list of blocked material?
    Dëv Päträ
    Currently Being Moderated

    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

  • Re: How to check list of blocked material?
    PRASOON AK
    Currently Being Moderated

    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