Skip to Content
avatar image
Former Member

SAP BO manufactured batch query

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers