How are the OWOR/Wor1 and OIGE/IGE1 tables joined?
I am trying to join these tables so that I can extract the Total document costs from the OIGE table for my work order completed query. I cannot get it to work. I realize there could be several Issues for Production (OIGE) for a single work order but I'm still not getting the query to join correctly.
Balaji Sampath replied
Try the below joins
OIGE T0 INNER JOIN IGE1 T1 ON T0.DocEntry = T1.DocEntry inner join owor t2 on t2.docnum = t1.baseentry left join ign1 t3 on t3.baseentry = t2.docnum left join oign t4 on t4.docentry = t3.docentry