4 Replies Latest reply: Aug 14, 2008 9:19 AM by Anilkumar Dalai RSS

Material Master view Table

Radha Krishna Madineedi
Currently Being Moderated

Hi Experts,


From which table I can find the views maintained for a particular material.  For Ex. For Material M1 I have maintained Basic Data1, Basic Data2 and Purchasing Views.  In which table I can find that for Material M1 Basic Data1, Basic Data2 and Purchasing views are maintained?


Thanks in advance.

  • Re: Material Master view Table
    Kishore Kumar Chiluka
    Currently Being Moderated



    Check table MSTA - Material Master Status

  • Re: Material Master view Table
    vishal shelke
    Currently Being Moderated



    in se16 table MOFF and field STATM




  • Re: Material Master view Table
    Juergen L
    Currently Being Moderated

    You can see this directly in table MARA field PSTAT

  • Re: Material Master view Table
    Anilkumar Dalai
    Currently Being Moderated



    You can see your material master views by using following tables.


    MARA - Material Master: General data

    MAKT - Material Master: Description

    MARM - Material Master: Unit of Measure

    MAPE - Material master: Export control file 

    MARC - Material master: Plant data

    MARD - Material master: Storage location 

    MAST - Material link to BOM

    MBEW - Material valuation

    MLGN u2013 Material Master: WM Inventory

    MLGT u2013 Material Master: WM Inventory type

    MDIP - Material: MRP profiles (field contents) 

    MKOP - Consignment price segment (old versions of SAP)

    EBEW - Valuation of sales order stock

    QBEW - Valuation of project stock

    MVER u2013 Material Master: Consumption <Plant>

    DVER u2013 Material Master: Consumption <MRP Area>

    MVKE u2013 Material Master: Sales <Sales Org, Distr Ch>

    MLAN - Material Master: Tax indicator

    MARC - Material Master: Plant data

    MAPR u2013 Material Master: Forecast

    MARD u2013 Material Master: Storage Location

    MCH1 u2013 Material Master: X Plant Batches

    MCHA u2013 Material Master: Batches

    MCHB u2013 Material Master: Batch Stock

    MDMA - MRP Area data

    DBVM - MRP Planning File Entry: MRP Area

    MOFF - Outstanding Material Master Records (Maintenance status)

    MARCH - Material Master C Segment: History

    MARDH - Material Master Storage Location Segment: History

    MBEWH - Material Valuation: History

    MCHBH - Batch Stocks: History

    MKOLH - Special Stocks from Vendor: History

    MSCAH - Sales Order Stock at Vendor: History

    MSKAH - Sales Order Stock: History

    MSKUH - Special Stocks at Customer: History

    MSLBH - Special Stocks at Vendor: History

    MSPRH - Project Stock: History

    MSSAH - Total Sales Order Stocks: History

    MSSQH - Total Project Stocks: History



    How u can see......?

    Go to SE16 transaction

    Enter Table Name........

    Enter the selection Parameters...



    You will get the table entries


    Thanks & Regards

    Anilkumar Dalai