QM material Master

[Former Member]

Dear all

how can i see the material on which Quality View is on but no inspection type has been define *(just vies is selected)

is there any report to see

[Former Member]

Hi,

You can create query based on table MARA & MARC.

Select maintenance status of the material as well as the indicator 'Inspection Set up Exists'.

If the maintenance stauts contains QM view (Indicator - Q) & inspection set up key is blank, then your query is resolved.

Regards,

Prashant Kolhatkar

[Former Member]

Hi,

Pl. revard, if your query is resolved.

Regards,

Prashant Kolhatkar

[Former Member]

could u plz explain in detail

tell me the steps plz

[Former Member]

Go to SQVI

Create "New" Query

Add tables MARA MARC & QMAT

System will automatically find the primary key for these tables

Select the material ,Inspection type,plant in selection screen

Also select the field called "Inspection setup" exists............

This Query will give you the list of material plantwise for which inspection type exists ,at the same type can show which inspection types exists.