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.
Unnikrishnan Balan replied
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