SAP QM - Query on all Inspection Plan

[Former Member]

Good mornign SAP QM Experts !

I have to make a query in order to do some checks on the inspection plan :

I need to extract all the inspection plan that contains a specific operation . . .

Ho can i do this thing by using ABAB and SAP Tables ?

Wich query i have to join in order to extract this inspection plan ?

This is the scenario :

I have two operation in the inspection plant like these :

CODE : "OPCERT" DESCRIPTION : "Analysis Cem"

CODE : "OPCERT" DESCRIPTION : "Analysis Dummy"

As you can see , there is two operation with the same code but different description ( and meaning ) .

I have to get all the inspection plan that contains "OPCERT Analysis Dummy" in the operations . . .

Thanks once again for the support !

[Former Member]

You can use SQVI & join table

Inspection Plan PLKO Inspection plan Header

Inspection Plan MAPL Material Assignement

Inspection Plan PLPO Operation Details

[Former Member]

Thanks , this is very helpfull for me . . .

But from PLPO table I can not find the operation that i'm searching . . .

I have started to check a lot , i have getted his inspection plan and the i have checked with it all his

operation , i can find the operation but the description in PLPO table are different

from the operations showed in QA03 transaction for examples . . .

Have you got any idea ?

[Former Member]

It should be there still check

PLPO Task list operation / activity

PLMZ Allocation of BOM - items to operations

Copy group from the PLMK or MAPL copy it to PLPO -->then check

[Former Member]

I have tryed , PLMZ is empty for control plan . . .

[Former Member]

In PLPO -

---

> check LTXA1

[Former Member]

Check , it contains a description but that description is not the one that is showed in QE03 transaction . . .

I have make some trace on the program and i found that the description that i'm searching is taken by

logical database PLPOD . . .

Have you got any idea ?

[former_member42743]

He's given you the correct tables. Check your joins to make sure you are using the right joins. Don't assume SAP proposed the proper joins in SQVI. Often times they are wrong.

FF