Skip to Content
0

SAP BO manufactured batch query

Nov 01, 2016 at 04:33 PM

33

avatar image
Former Member

Dear Experts,

I need to do a report that shows me the number of lots that have occurred with the lot number.

Basically these are the tables that need to unite, but I get duplicate data

T0.ItemCode,T0.DistNumber, T2.Quantity, T0.SysNumber FROM
OBTN T0  INNER JOIN OITM T1 
ON T0.[ItemCode] = T1.[ItemCode] 
INNER JOIN IGN1 T2 
ON T1.[ItemCode] = T2.[ItemCode]
LEFT JOIN OIGN T3 
ON T3.DocEntry = T2.DocEntry

Thank you & Regards,

Victor

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers