Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get material view of a particular material

Former Member
0 Kudos

Hi All,

Please let me know how we can find the exisitng material view of a material i.e which table contains this entry.

eg. material x having view of basic data1,basic data2,classification,mrp1 ..etc.

This entry should be in one table, i want that table name.

regards,

Mukund

1 ACCEPTED SOLUTION

former_member188685
Active Contributor
0 Kudos

This is really interesting.....

all the views are stored in Mara table and that too in one field with combination....

K basic view

V sales View

E purchase view

D MRP view

F PRT view

L StorageView

G Cost View

A work scheduling view

P Forecast View

S warehouse view

B Account View

Q quanity view

......

Surprisingly that field is PSTAT you can see that in MARA.

Hope it will be clear..

vijay

Please reward for helpful answers..

8 REPLIES 8

amit_khare
Active Contributor
0 Kudos

Hi,

following tables contains this information indirectly.

<b>MSICHTAUSW</b>

Hope this will help you.

Regards

Amit

0 Kudos

it is a structure not a table and there is no link with material also.

Former Member
0 Kudos

Hi,

Check the following table

<b>MARC</b> - Classification

<b>MOFF</b> - Lists what views have not been created

Hope it helps u.

Thanks&Regards,

Ruthra.R

amit_khare
Active Contributor
0 Kudos

Hi,

Actually that structure store the screen calling of those view.

In reality those views does not depends on the material number but on the material type,and they are extracted by a function based on the material type of the number enetered.

It uses various tables and structures like rm03m, usrm1,etc.

The main function to perform conversion is -CONVERSION_EXIT_MATN1_INPUT.

Regards

Amit

former_member188685
Active Contributor
0 Kudos

This is really interesting.....

all the views are stored in Mara table and that too in one field with combination....

K basic view

V sales View

E purchase view

D MRP view

F PRT view

L StorageView

G Cost View

A work scheduling view

P Forecast View

S warehouse view

B Account View

Q quanity view

......

Surprisingly that field is PSTAT you can see that in MARA.

Hope it will be clear..

vijay

Please reward for helpful answers..

0 Kudos

Thanks the problem has been solved

0 Kudos

hi Mukund,

I have similar kind of requirement. i need to find out how many views a material has. Pls let me know how you solved it.

Thanks

Phani

Former Member
0 Kudos

for each material , many VIEWS can be created.

to check how many views a particular material have,

goto MARC-PSTAT

this PSTAT contains : how many views that material has

hope this is useful to you.