CREATE VIEW "SBODEMODE"."B1_NotFullyCreditedDocView" ( "ObjType", "AbsEntry" ) AS ((((SELECT T0."ObjType" AS "ObjType", T0."DocEntry" AS "AbsEntry" FROM  "SBODEMODE"."OINV" T0  INNER  JOIN "SBODEMODE"."INV1" T1  ON  T1."DocEntry" = T0."DocEntry"    LEFT OUTER  JOIN "SBODEMODE"."RIN1" T2  ON  T2."BaseEntry" = T1."DocEntry"  AND  T2."BaseLine" = T1."LineNum"   WHERE T2."DocEntry" IS NULL   OR  T2."LineTotal" <> T1."LineTotal"  OR  (T0."DocType" = ('I' )  AND  T2."Quantity" <> T1."Quantity" )  GROUP BY T0."ObjType", T0."DocEntry") UNION (SELECT T0."ObjType" AS "ObjType", T0."DocEntry" AS "AbsEntry" FROM  "SBODEMODE"."OPCH" T0  INNER  JOIN "SBODEMODE"."PCH1" T1  ON  T1."DocEntry" = T0."DocEntry"    LEFT OUTER  JOIN "SBODEMODE"."RPC1" T2  ON  T2."BaseEntry" = T1."DocEntry"  AND  T2."BaseLine" = T1."LineNum"   WHERE T2."DocEntry" IS NULL   OR  T2."LineTotal" <> T1."LineTotal"  OR  (T0."DocType" = ('I' )  AND  T2."Quantity" <> T1."Quantity" )  GROUP BY T0."ObjType", T0."DocEntry")) UNION (SELECT T0."ObjType" AS "ObjType", T0."DocEntry" AS "AbsEntry" FROM  "SBODEMODE"."OINV" T0  INNER  JOIN "SBODEMODE"."INV1" T1  ON  T1."DocEntry" = T0."DocEntry"    LEFT OUTER  JOIN "SBODEMODE"."RIN1" T2  ON  T2."BaseEntry" = T1."DocEntry"  AND  T2."BaseLine" = T1."LineNum"   WHERE T2."DocEntry" IS NULL   OR  T2."LineTotal" <> T1."LineTotal"  OR  (T0."DocType" = ('I' )  AND  T2."Quantity" <> T1."Quantity" )  GROUP BY T0."ObjType", T0."DocEntry" HAVING COUNT(DISTINCT T2."DocEntry") > (1 ))) UNION (SELECT T0."ObjType" AS "ObjType", T0."DocEntry" AS "AbsEntry" FROM  "SBODEMODE"."OPCH" T0  INNER  JOIN "SBODEMODE"."PCH1" T1  ON  T1."DocEntry" = T0."DocEntry"    LEFT OUTER  JOIN "SBODEMODE"."RPC1" T2  ON  T2."BaseEntry" = T1."DocEntry"  AND  T2."BaseLine" = T1."LineNum"   WHERE T2."DocEntry" IS NULL   OR  T2."LineTotal" <> T1."LineTotal"  OR  (T0."DocType" = ('I' )  AND  T2."Quantity" <> T1."Quantity" )  GROUP BY T0."ObjType", T0."DocEntry" HAVING COUNT(DISTINCT T2."DocEntry") > (1 ))) WITH READ ONLY