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 find out whether a particular view is maintained in Material Master

Former Member
0 Kudos
665

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
569

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

5 REPLIES 5

Former Member
0 Kudos
569

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

Former Member
0 Kudos
570

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_member181962
Active Contributor
0 Kudos
569

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

0 Kudos
569

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.

0 Kudos
569

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