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:
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?