CREATE VIEW "SBODEMODE"."B1_SnBOpenQtyViewForWTR" ( "DocType", "DocEntry", "DocLine", "DocSubLine", "ManagedBy", "ItemCode", "SysNumber", "LocCode", "Quantity" ) AS SELECT T0."ApplyType" AS "DocType", T0."ApplyEntry" AS "DocEntry", T0."ApplyLine" AS "DocLine", T0."AppSubLine" AS "DocSubLine", T0."ManagedBy" AS "ManagedBy", T0."ItemCode" AS "ItemCode", T0."SysNumber" AS "SysNumber", T0."LocCode" AS "LocCode", SUM(T0."Quantity") AS "Quantity" FROM  "SBODEMODE"."B1_SnBOpenQtyInnerView" T0  GROUP BY T0."ApplyType", T0."ApplyEntry", T0."ApplyLine", T0."AppSubLine", T0."ManagedBy", T0."ItemCode", T0."SysNumber", T0."LocCode", T0."TransId" HAVING SUM(T0."Quantity") <> (0 ) WITH READ ONLY