Skip to Content

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

Linking from the Inventory Transactions Logs table (OITL)

Hi Everyone,

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?

Kind Regards,

David

Former Member
replied

Hi,

Try this link for OWTR and same way try for other documents:

FROM
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,

Nagarajan

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