table for Views in Material Master

[former_member342013]

Hi

In which table i will come to know That

What all Views are selected for Materials ?

Regards

Smitha

[Former Member · Accepted solution]

Good day Smitha,

You can check material views for the particulare material number by PSTAT field

in MARA table. It will give for particular material number which are the views are

used.

Status defination can be known by using T132 table.

I mean

   A                         Work scheduling
   B                         Accounting
   C                         Classification
   D                         MRP
   E                         Purchasing
   F                         Production resources/tools
   G                         Costing
   K                         Basic data
   L                         Storage
   P                         Forecasting
   Q                         Quality management
   S                         Warehouse management
   V                         Sales
   X                         Plant stocks
   Z                         Storage location stocks

Hope it helps.

Regards and Best wishes.

[Former Member]

Hiie all,

I need all the list of Views like Basic Data - 1 , basic data 2 for a particular material .

[Former Member]

Check MSTA. Note that there is no separation from basic 1 and basic 2. the status fields, and msta only recognize the "basic data" view

[former_member342013]

ThankYou

[Former Member]

See fields VPSTA and/or PSTAT in various tables (MARA, MARC, etc.).

[Former Member]

Check out - MOFF in SE16

It has entries of the Views which are NOT been created.

Thnx