Skip to Content
0
Jul 13, 2018 at 03:36 PM

Bin location in return draft

200 Views

Hello,

I'm trying to create a query in SAP Business one, which takes the return draft (header and line) it means ODRF and DRF1 table.
in this query I am trying to extract the bin location code in the OBIN table.
I can not make the connection. I did a test with the RDF19 table but it does not work:

please find here my query:

SELECT

T1."DocEntry",

T1."ItemCode",

T2."CodeBars",

T2."ItemName",

T1."Quantity",

T1."WhsCode"AS"WarehouseFrom",

T4."BinCode"AS"Warehouse"

FROM ODRF T0

INNERJOIN DRF1 T1 ON T0."DocEntry" = T1."DocEntry"

INNERJOIN OITM T2 ON T1."ItemCode" = T2."ItemCode"

LEFTOUTERJOIN "DRF19" T3 ON T3."DocEntry" = T0."DocEntry"AND T1."LineNum" = T3."LineNum"

LEFTOUTERJOIN "OBIN" T4 ON T4."AbsEntry" = T3."BinAbs"

i was expecting to see all return draft line with each item bin location.

but this query didn't give me all return draft, and i have return draft docEntry repated in the result.

i think the DRF19 does not stock the bin location every time...

do you have a solution or may be give me the good table that i can related to ODRF and DRF1 to see the detail of bin location of each item in my return draft please?