Skip to Content
-1
Feb 01, 2021 at 06:45 AM

QUERY error SAP BUSINESS ONE HANA

36 Views

SELECT T1."LineNum", T1."ItemCode", T1."Dscription", T3."DistNumber", T3."MnfSerial", T1."Quantity", T1."Price", T1."TaxCode", T1."LineTotal", T5."Quantity", T5."Price", T5."TaxCode", T5."LineTotal" FROM ORDR T0 INNER JOIN RDR1 T1 ON T0."DocEntry" = T1."DocEntry"

INNER JOIN OITM T2 ON T1."ItemCode" = T2."ItemCode" LEFT JOIN OBTN T3 ON T2."ItemCode" = T3."ItemCode"

LEFT JOIN ODLN T2 ON T2."DocEntry" = T1."TrgetEntry" LEFT JOIN DLN1 T3 on T3."DocEntry" = T2."DocEntry"

LEFT JOIN OINV T4 ON T4."DocEntry" = T3."TrgetEntry"

LEFT JOIN INV1 T5 ON T5."DocEntry" = T4."DocEntry"

LEFT JOIN ORDN T6 ON T6."DocEntry" = T5."TrgetEntry"

LEFT JOIN RDN1 T7 ON T7."DocEntry" = T6."DocEntry"

Error Like : Invalid DocEntry...

Please help me on that.