QM - Table Relationship

[yohan_weerasinghe]

Hi!!!

Currently I am developing a Z-Programme for QM module using the transactions QE11 & QA11.

QE11 is for Results Recording & QA11 is for Usage Decision. QA11 is done after the QE11 is completed.

Now my question is,

*I want to find out inspection points which have no results recorded. Also I wants to know what are the inspection points that the results are recorded*. I have found few tables for those requirements but, don't know whether they are the most accurate places to extract data from. But those tables doesn't help me in my initial requirement. Those tables are,

1. QALS - Inspection lot record.

2. QAMR - Characteristic results during Inspection processing.

3. QAMV - Characteristic specifications for Inspection processing.

4. QAPP - Inspection point.

5. QASR - Sample results for Inspection characteristics .

Please help me to dig out this...

Thanking you,

Yohan.

[yohan_weerasinghe]

Could anyone please help me on this...

[yohan_weerasinghe]

QASR table has the values.