on 07-13-2018 4:36 PM
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?
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.