Skip to Content

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

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.



Former Member
Former Member replied

Hi Tony

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

With Regards

Balaji Sampath

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question