How to find a particular view from table MARD field PSTAT

Hi Friends,

Do any one have any idea how to check the Views created for a material. I have a requirement to check Plant data1, Plant data2 MRP1, MRP2, MRP3 and MRP4 Views are created or not if not created then I need to create it.

I can see the table MARD have field PSTAT but how can we recogonize how many views are created for a particular material. Even though I have created 5 views for a material it shows only DL in PSTAT.

The overall maintenance status is made up of the individual maintenance statuses. The individual maintenance statuses have the following meaning:

Work scheduling A

Accounting B

Classification C

MRP D

Purchasing E

Production resources/tools F

Costing G

Basic data K

Storage L

Forecasting P

Quality management Q

Warehouse management S

Sales V

Plant stocks X

Storage location stocks Z

Thanks in advance,

Sujith.