Query - Detailed Production Schedule Drill Down Report
SAP Business One detailed production schedule drill down report. Giving the production scheduler good accurate information is essential in meeting delivery demands. This production schedule does just that! It's almost like a production MRP, with exception messages, component stock statuses, and more.
And here is the HANA SQL - Simply paste into your Query Generator form.
SELECT CASE
WHEN T0."StartDate" > CURRENT_DATE AND T0."Status" = 'P' THEN 'Planned - Start Later'
WHEN T0."StartDate" = CURRENT_DATE AND T0."Status" = 'P' THEN 'Planned - Start Now'
WHEN T0."StartDate" < CURRENT_DATE AND T0."Status" = 'P' THEN 'Planned - Expedite'
WHEN T0."DueDate" > CURRENT_DATE AND T0."Status" = 'R' THEN 'Released - OnTime'
WHEN T0."DueDate" = CURRENT_DATE AND T0."Status" = 'R' THEN 'Released - Due Today'
WHEN T0."DueDate" < CURRENT_DATE AND T0."Status" = 'R' THEN 'Released - Expedite'
END AS "Status" ,
T0."DocNum" AS "WO",
T0."StartDate" AS "Start Date",
T0."ItemCode" AS "Finished Good",
T0."OriginNum" AS "Sales Order",
T4."CardName" AS "Customer",
T2."VisResCode" AS "Resource",
T1."ItemCode" AS "Component",
T3."ItemName" AS "Component Desc",
T1."PlannedQty" AS "Planned Qty",
T1."IssuedQty" AS "Issued Qty",
CASE
WHEN (T1."IssuedQty" + T3."OnHand") < T1."PlannedQty" THEN 'Shortage'
WHEN T1."IssuedQty" = T1."PlannedQty" THEN 'Issued Complete'
WHEN T1."IssuedQty" < T1."PlannedQty" AND T3."OnHand" >= T1."PlannedQty" THEN 'Stock Available'
END AS "Component Status",
T3."OnHand" AS "In Stock",
T3."IsCommited" AS "Reserved",
T3."OnOrder" AS "On Order"
FROM OWOR T0 INNER JOIN WOR1 T1 ON T0."DocEntry" = T1."DocEntry"
LEFT JOIN ORSC T2 ON T2."VisResCode" = T1."ItemCode"
LEFT JOIN OITM T3 ON T1."ItemCode" = T3."ItemCode"
LEFT JOIN OCRD T4 ON T0."CardCode" = T4."CardCode"
WHERE T0."Status" = 'P' OR T0."Status" = 'R'