Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Method/Query to identify receipt from production is from return component or normal receipt from production

Hi all,

Other than relationship map, is there any other method or query to identify receipt from production is from return component or normal receipt from production.

Thanks

Former Member
replied

Try this:

SELECT T0.[DocNum], T0.[ItemCode], T3.[DocNum], T2.[ItemCode], T5.[DocNum], T4.[ItemCode] FROM OWOR T0  INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry left join IGN1 T2 on  T1.[ItemCode] =  T2.[ItemCode] and   T2.[BaseRef] = T0.docnum    INNER JOIN OIGN T3 ON T2.DocEntry = T3.DocEntry INNER JOIN IGN1 T4 ON  T4.[ItemCode] =  T0.[ItemCode] and  T4.[BaseRef] = T0.docnum and T4.trantype = 'c' INNER JOIN OIGN T5 ON T4.DocEntry = T5.DocEntry

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question