Table For Bin wise Goods Issue

[arpit_shah2]

Hi,

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.

Regards,

Arpit

[former_member212181 · Accepted solution]

Hi Arpit,

Please try below query

SELECT T0.[TransType], T0.[ItemCode], T1.[Quantity], T2.[BinCode]

FROM [dbo].[OILM]  T0

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

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

WHERE T0.[TransType] =60

Thanks

Unnikrishnan

[arpit_shah2 · Accepted solution]

Thanks Unnikrishnan and Sorry for delay.

Can you please help me to include item Cost ( Not Info Price) for Transaction Type = 60.

Regards,

Arpit

[former_member212181 · Accepted solution]

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

Thanks

Unnikrishnan

[arpit_shah2 · Accepted solution]

Thanks Unnikrishnan,

Query work properly, I just add one more join between line no.

Regards,

Arpit

[former_member212181 · Accepted solution]

Hi Arpit,

If You got the answer, please close the thread by marking correct / helpful answer

Thanks