CREATE VIEW "SBODEMODE"."B1_PaymentMeansPerDateView" ( "PayObjType", "PayAbsEntry", "MeansType", "MeansLine", "MeansAbsEntry", "MeansID", "MeansStrID", "MeansDate", "MeansDateTotal", "DocTotalSum", "MeansPart" ) AS SELECT T0."PayObjType" AS "PayObjType", T0."PayAbsEntry" AS "PayAbsEntry", T0."MeansType" AS "MeansType", T0."MeansLine" AS "MeansLine", T0."MeansAbsEntry" AS "MeansAbsEntry", T0."MeansID" AS "MeansID", T0."MeansStrID" AS "MeansStrID", T0."MeansDate" AS "MeansDate", T0."MeansTotalSum" AS "MeansDateTotal", T0."DocTotalSum" AS "DocTotalSum", (T0."MeansTotalSum" / T1."MeansDateTotal") AS "MeansPart" FROM  "SBODEMODE"."B1_PaymentMeansView" T0   LEFT OUTER  JOIN "SBODEMODE"."B1_PaymentMeansDateTotalsView" T1  ON  T1."PayObjType" = T0."PayObjType"  AND  T1."PayAbsEntry" = T0."PayAbsEntry"  AND  T1."MeansDate" = T0."MeansDate" WITH READ ONLY