Skip to Content

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

Table For Bin wise Goods Issue


We are using SAP B1 9.0 PL  08 UK Localization.

We are using Warehouse management system ( Enable Bin for Warehouse). Can any one help me to find Table for bin wise Goods issue.




Hi Again Arpit

I joined OINM Table also to get exact item cost for that transaction. You can add columns and input criteria

SELECT T0.[TransType],T3.DocDate, T3.BASE_REF, T0.[ItemCode], T1.[Quantity],T3.CalcPrice,  T2.[BinCode]

FROM [dbo].[OILM]  T0

  INNER JOIN OBTL T1 ON T0.[MessageID] = T1.[MessageID]

  INNER JOIN OBIN T2 ON T1.[BinAbs] = T2.[AbsEntry]

  Inner Join OINM T3 on T3.TransType = T0.TransType and T3.CreatedBy = T0.DocEntry

WHERE T0.[TransType] =60

Please try this query



1 View this answer in context

Helpful Answer

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