CREATE VIEW "SBODEMODE"."B1_ProductionVarianceView" ( "WOR", "AppObjType", "ItemCode", "ItemName", "IsInventory", "ItemType", "Quantity", "RealTransaction", "OpenPriceDiff", "OpenNegInv", "UsedForParent", "Variance", "EvalSystem" ) AS SELECT T0."WOR", T0."AppObjType", T0."ItemCode", T0."ItemName", T0."IsInventory", T0."ItemType" AS "ItemType", COALESCE(T1."Quantity", 0.000000) AS "Quantity", COALESCE(T1."TotalLC", 0.000000) AS "RealTransaction", COALESCE(T1."PriceDiff", 0.000000) AS "OpenPriceDiff", COALESCE(T1."NegInvAdjs", 0.000000) AS "OpenNegInv", COALESCE(T2."TotalLC", 0.000000) AS "UsedForParent", 0.000000 AS "Variance", T0."EvalSystem" FROM  "SBODEMODE"."B1_ProductionContributionView" T0   LEFT OUTER  JOIN "SBODEMODE"."B1_ProductionContributionView" T1  ON  T0."WOR" = T1."WOR"  AND  T0."ItemType" = T1."ItemType"  AND  T0."ItemCode" = T1."ItemCode"  AND  T0."TransType" = T1."TransType"  AND  T0."DocEntry" = T1."DocEntry"  AND  T0."AppObjType" = T1."AppObjType"  AND  T0."POLine" = T1."POLine"  AND  T0."LineID" = T1."LineID"  AND  T0."MessageID" = T1."MessageID"  AND  T1."Contribution" = 'N'    LEFT OUTER  JOIN "SBODEMODE"."B1_ProductionContributionView" T2  ON  T0."WOR" = T2."WOR"  AND  T0."ItemType" = T2."ItemType"  AND  T0."ItemCode" = T2."ItemCode"  AND  T0."TransType" = T2."TransType"  AND  T0."DocEntry" = T2."DocEntry"  AND  T0."AppObjType" = T2."AppObjType"  AND  T0."POLine" = T2."POLine"  AND  T0."LineID" = T2."LineID"  AND  T0."MessageID" = T2."MessageID"  AND  T2."Contribution" = 'Y' WITH READ ONLY