12-16-2005 11:12 AM
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
12-16-2005 11:52 AM
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..
12-16-2005 11:21 AM
Hi,
following tables contains this information indirectly.
<b>MSICHTAUSW</b>
Hope this will help you.
Regards
Amit
12-16-2005 11:26 AM
it is a structure not a table and there is no link with material also.
12-16-2005 11:26 AM
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
12-16-2005 11:52 AM
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
12-16-2005 11:52 AM
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..
12-16-2005 11:59 AM
10-18-2006 5:05 AM
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
12-16-2005 12:03 PM
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.