Material master views

[Former Member]

Hi all,

Is there any list/report which gives material views created for a material?

Thanks

Raghavendra

[Former Member · Accepted solution]

Hi,

in addition to the already mentioned database table MARA you could also check table MSTA. There you will not only find the maintained views (PSTAT), but also the related org level (plant, storage loc, sales channel etc.)

Regards, Axel

[Former Member]

In MARA Table check the filed "Maint. status"...

It will show you the Alphabets for each Views..

For Ex: for My material the "Maint. status" is KELBQ

that means..

the following views are maintained.

K Basic data

E Purchasing

L Storage

B Accounting

Q Quality management

Edited by: Manohar Raju on May 8, 2008 1:06 PM

[Former Member]

Thanks u all for ur immediate reply,

Raghavendra

[Former Member]

If it is OK, you should reward points..

[Former Member]

Dear,

I can't understand about your issue but i give you some useful t-code for material master.

MM01 - Create Material Master.

MM02 - Change Material Master.

MM03 - Display Material Master.

MM06 - Deletion Flag in Material Master.

MMSC - Extend Material for storage locatin.

MM60 - List of material master - Plant vise, Matrial type wise.

If it is useful for u

Please revert back.

Regards,

Mahesh Wagh.

[Former Member]

Check table MARA , for the material maintenance status are present each alphabet depicts the views maintained

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