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

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