Linking from the Inventory Transactions Logs table (OITL)
I am interested in linking from the Inventory Transactions Log (OITL table) to relevant documents; these being Deliveries (ODLN), Goods Issues (OIGE), Goods Receipts (OIGN), Goods Receipt Purchase Orders (OPDN) and Inventory Transfers (OWTR).
Is there any way of linking from the Log table (OITL) to the afore mentioned tables? Is so can you please share your wisdom?
Nagarajan K replied
Try this link for OWTR and same way try for other documents:
OWTR T0 INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry left join
OITL T2 on t1.docentry = T2.[ApplyEntry] and T1.[LineNum] =
T2.[ApplyLine] and T2.[ApplyType] = 67
Thanks & Regards,