How to find out whether a particular view is maintained in Material Master

[Former Member]

Hi All ,

I got a requirement where user wants to know the materials for which classification view is maintained. Not one material at a time. User wants to get it done for entire material at one go. Is any field in any table available which will help for finding out the same. Or anyother logic through which we can achieve the same.

Thanks in advance,

Shyam.

[Former Member]

check in <b>MOFF</b> table.

[Former Member]

Hi,

Check the table MARA, there is a Field VPSTA. in this field the Material views will be stores with single charecters. so check for the Clasification view charecter

also it's PSTAT in MARA and MARC.

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

Regards

Sudheer

[Former Member]

HI Shyam,

In MARA there is a field PSTAT.

Each letter in that has a meaning:

Maintenance status

Use

The maintenance status records:

Which user departments may maintain a material master record of a particular material type

Which user departments have already maintained the material master record at a particular hierarchy level

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

User department Maintenance status

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

Regards,

Ravi

[Former Member]

Hi All,

What if those tables are not maintained properly. MOFF is also not maintained. I had found out some inconsistenceis in our quality system. Any other new way to solve the same query.

[PS_1978]

Hi Shyam,

Try using the FM <b>'SELECTION_VIEWS_FIND'</b>.

for this u have to pass the following parameter values:

bildsequenz = mbref (from table T134 for corresponding material type) and

pflegestatus = bilds (from table T133K for corresponding screen sequence from the T134 table).

This function module returns the selected views in a table.

<b>

DATA : v_mbref TYPE mbref,
       v_bildsequenz TYPE bildsq.

DATA : i_mbildtab LIKE mbildtab OCCURS 0.

SELECT SINGLE mbref FROM t134 INTO v_mbref WHERE mtart = wa_mara-mtart.

SELECT SINGLE bilds FROM t133k INTO v_bildsequenz WHERE mbref = v_mbref.

CALL FUNCTION 'SELECTION_VIEWS_FIND'
  EXPORTING
    bildsequenz           = v_bildsequenz
    pflegestatus          = wa_mara-pstat
  TABLES
    bildtab               = i_mbildtab
* EXCEPTIONS
*   CALL_WRONG            = 1
*   EMPTY_SELECTION       = 2
*   OTHERS                = 3
          .
IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

</b>

Hope this helps.

Regards,

Phani