LINKING OF PURCHASE ORDER TO CREDIT NOTE TABLES
SELECT *
FROM POR1 T1
LEFT OUTER JOIN OPOR T2 ON T1.DocEntry = T2.DocEntry
LEFT OUTER JOIN PDN1 T3 ON T2.DocEntry = T3.BaseEntry
AND T1.LineNum = T3.BaseLine
AND T1.ItemCode = T3.ItemCode
LEFT OUTER JOIN OPDN T4 ON T3.DocEntry = T4.DocEntry
LEFT OUTER JOIN RPD1 T5 ON T4.DocEntry = T5.BaseEntry
AND T3.LineNum = T5.BaseLine
AND T3.ItemCode = T5.ItemCode
LEFT OUTER JOIN ORPD T6 ON T5.DocEntry = T6.DocEntry
LEFT OUTER JOIN PCH1 T7 ON T4.DocEntry = T7.BaseEntry
AND T3.LineNum = T7.BaseLine
AND T3.ItemCode = T7.ItemCode
LEFT OUTER JOIN OPCH T8 ON T7.DocEntry = T8.DocEntry
LEFT OUTER JOIN RPC1 T9 ON T8.DocEntry = T9.BaseEntry
AND T7.LineNum = T9.BaseLine
AND T7.ItemCode = T9.ItemCode
LEFT OUTER JOIN ORPC T10 ON T9.DocEntry = T10.DocEntry
Add the required field from the table in the select and check required condition on the where clause...
Hope Helpful
