Skip to Content
0
Sep 11, 2023 at 12:48 PM

query execution taking more time and close the SAP Business One

44 Views

Dear all,

Below query is taking a more time to execute and close the SAP.

Query is developed in HANA.

SELECT 

T0."DocEntry",T8."BPLName" AS "Branch Name",T0."CreateDate",
T0."CreateTS",T0."DocNum",T0."NumAtCard" AS "Cust PO No",T0."CardCode", 
T0."CardName",T3."GroupName", T0."DocDate", T1."ItemCode", T1."Dscription",
T1."Quantity" AS "ORDER QTY", T1."DelivrdQty" ,(T1."Quantity"-T1."DelivrdQty") AS "Balance QTY",
T4."U_AVG_MRP" AS "Average MRP",(T1."Quantity"*(T4."U_AVG_MRP"/2)) AS "Average Order Value",
((T1."Quantity"-T1."DelivrdQty")*(T4."U_AVG_MRP"/2)) AS "Average Pending Value",
T1."WhsCode",T1."U_UNE_AQ" AS "Whs Pass QTy",T1."U_UNE_AQWHS" AS "Total Pass Qty"
,(CASE WHEN T0."DocStatus"='C' AND T0."CANCELED" ='Y' THEN 'CANCELED' WHEN T0."DocStatus"='C' AND T0."CANCELED" ='N' THEN 'CLOSE' ELSE 'OPEN' END) AS "SO STATUS", T0."CANCELED"
FROM ORDR T0
INNER JOIN RDR1 T1 ON T0."DocEntry" = T1."DocEntry"
INNER JOIN OCRD T2 ON T2."CardCode"=T0."CardCode"
INNER JOIN OCRG T3 ON T3."GroupCode"=T2."GroupCode"
INNER JOIN OITM T4 ON T1."ItemCode"=T4."ItemCode"
INNER JOIN OBPL T8 ON T8."BPLId"=T0."BPLId"
WHERE (:BranchName = '' OR T8."BPLName" = :BranchName) AND T0."DocDate" >=[%1] AND T0."DocDate" <=[%2]
ORDER BY T0."DocNum";

Regards,

Nikunj Mehta