How SAP B1 specifically in picking module create information from "bin location allocation - Issue"?

[IkkiThePhoenix]

Hi,
I have a little question about how SAP B1 create the information from "bin location allocation - Issue" to show. I would like to recreate this using a queary, I very confuse about which table are consulting.

Thanks.

[williamwachholz]

Hello,

Check the table OIBQ - Item Bin Accumulator Table. 

SELECT  OIBQ."BinAbs" AS "BinAbsEntry", OIBQ."OnHandQty" AS "Quantity"

FROM OIBQ

INNER JOIN OBIN ON OBIN."AbsEntry" = OIBQ."BinAbs"

WHERE OIBQ."ItemCode" = '99999'

AND OIBQ."WhsCode" = '01'

AND OIBQ."OnHandQty" > 0

Best regards

[IkkiThePhoenix]

Hello,

Thanks for answering @williamwachholz help a lot.

With this information from the table OIBQ how SAP can know exactly the items are Available ? I can't find it, that make me think that SAP manages his own logic or query internally.

Thanks

[williamwachholz]

You have to search for documents with open quantity holding the item. This can be done search the transaction log tables (OITL and OBTL).

Here is an example for sales orders. You will have to adapt the query to search all open sales orders for the item that are holding its quantity.

SELECT OBTL."BinAbs" AS "BinAbsEntry",

OBTL."Quantity"

FROM OITL

INNER JOIN OBTL ON OBTL."ITLEntry" = OITL."LogEntry"

WHERE OITL."DocType" = 17

AND OITL."DocEntry" = 9999999