How do I query the item batches for a bin location

[jun_dolor]

How would I query the batches of the items in a Bin Location? The RITL and RTBN tables are virtual. Here is a sample output:

Item          Batch    Warehouse     Bin Location
Prod-1        ABC001   W1            W1-B100-R100-L100-P100
Prod-1        XYZ001   W1            W1-B100-R100-L100-P101

[mgregur · Accepted solution]

Hi,

you need OBBQ table, it has ItemCode, Batch number, WhsCode and BinBabs.

BR,

Matija

[jun_dolor · Accepted solution]

Thank you very much. Yes, I was able to check it out, Best regards