topic Re: Material view exists in Application Development and Automation Discussions

Material view exists

Former Member — Mon, 17 Jul 2006 08:32:04 GMT

Hi!

How can I check if a specific material view is existing, or which material views are existing?

BAPI or FM would be better.

THX:

Re: Material view exists

Former Member — Mon, 17 Jul 2006 08:32:57 GMT

Hi peter,

1. Not only which views

are available, but

for which-which plants,

which-which sales organisation,

etc etc,

also we can get.

2. MSTA

This is the KEY TABLE.

3. Importrant fields in this are:

STATM = which view is available

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

4. There are other fields,

which give FURTHER information

regarding THAT VIEW

(eg. sales organisation code, plant code)

5. Note that

There will be MULTIPLE RECORDS

for a material number

in this table

based upon the different view

and multiple records, in the same view.

regards,

amit m.

Re: Material view exists

Former Member — Mon, 17 Jul 2006 08:35:24 GMT

Hi again,

1. We can also use this FM.

MSTA_GENERIC_READ_WITH_MATNR

regards,

amit m.

Re: Material view exists

Former Member — Mon, 17 Jul 2006 08:45:24 GMT

Hi,

Check this link..

Regards

vijay

Re: Material view exists

Former Member — Mon, 17 Jul 2006 08:48:33 GMT

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

......

that field is <b>PSTAT</b> you can see that in <b>MARA</b>.

Regards

vijay