CREATE VIEW "SBODEMODE"."B1_SnBTransRptFirstBinView" ( "ITLEntry", "SnBMDAbs", "BinCode", "SnBTransRptFirstBinViewBinCount" ) AS SELECT T0."ITLEntry", T0."SnBMDAbs", MIN(T1."BinCode") AS "BinCode", COUNT(DISTINCT T1."AbsEntry") AS "SnBTransRptFirstBinViewBinCount" FROM  "SBODEMODE"."OBTL" T0  INNER  JOIN "SBODEMODE"."OBIN" T1  ON  T0."BinAbs" = T1."AbsEntry"   WHERE T0."ITLEntry" <> (-1 )   GROUP BY T0."ITLEntry", T0."SnBMDAbs" WITH READ ONLY