Sales order and Inspection Lot relation

[Former Member]

Hi All,

How can we find relation between Inspection lot and its coresponding sales order?

Thanks and Regards

Nazmul

[Former Member]

Hi Nazmul,

you can find the can we find relation between Inspection lot and its corresponding sales order with the help of QA32 Inspection lot list

Give inputs like : material / Plant / inspection lot origin and all where we can find out inspection lot number

i hope it will helpful for you

Thanks

[Former Member]

http://scn.sap.com/thread/1428836

Above thread might help u ?

[former_member183879]

Hi,

Please ask some QM Consultant. There are lot of tables starting with QA*. Please check some of these tables to get the answer

Just checked it in the system now. You cannot find it out directly. The inspection lot is available only in LIPS table. So you have to find out the relationship between inspection lot and the delivery document for the item. Once you find that, you can find the link between delivery and sales document.

i.e. SELECT LIPS-VBELN where QADB-PREUFLOS = LIPS-PREUFLOS

Once LIPS VBELN u can find sales order in VBFA