i want QM table relationship i.e qals,qamr,qase,plmk

[Former Member]

i want to print <b>incoming inspection lot</b> smartform for specific inspections done (for ex: chemical analysis and physical analysis ) on incoming lot which come into company .so, i get inspection group from QALS table and insepections done form PLPO table but how to relate this to get data from QAMR AND QASE AND PLMK TABLES TO get inspection done and its values. plz, tell me how this tables are realted.

tahnking u,

[Former Member]

Hi

do like this

PRUEFLOS is the common field in QALS,QAMR and QASE

and join QAMR and QASE with

PRUEFLOS VORGLFNR MERKNR fields

link QPMK-MKMNR and PLMK with field VERWMERKM

link PLMK and PLPO

QMERKNR is the common field in tables QAMV,PLMK,QPMK

Regards

Anji

[Former Member]

Kumar,

Go to Transaction SQVI and create a quickview. There you can give the table names and it will automatically give you all the relationships between different tables.

Regards

Aneesh.