cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Not sure your question has been answered. Mr.Karthik replied to show different between Receipt from prodcution with Good receipt (under inventory transactions).

But your question is, "How to identify a production order with receipt from production and return components( for this also same receipt from production is used).

Let me know your comments.

Former Member
0 Kudos

Hi,

Yes, I got what you mean. Actually is not a direct answer.

End up I found out that my query also include records from Good receipt (under inventory transactions), after applied Mr.Karthik query, at least it help to filter and only show records from receipt from production or return components( for this also same receipt from production is used)

Since I need it in hurry, so I had export all the records and make filtering by using excel to display only if one WO link to 2 or more receipt from production.

Or is there any better solution ?

Anyway, really appreciate your help.

Thank you

kothandaraman_nagarajan
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi,

Thank you for the query, this is more what I need.

Thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

     When IGN1.BaseEntry=202 then it is a receipt from Production. If IGN1.BaseEntry=-1 then it is a normal Goods Receipt Document.

Cheers

Karthik

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Karthik,

FYI : It is not base entry, should be Base type.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Nagarajan,

              Sorry for Mistake in my words.. And thanks for your sharp bug identification....

Cheers

Karthik

kothandaraman_nagarajan
Active Contributor
0 Kudos

You are welcome.

arif_siddique12
Explorer
0 Kudos

This is the correct answer