CREATE VIEW "SBODEMODE"."B1_DocLineView" ( "DocEntry", "LineNum", "ObjType", "ArrayType", "TaxOnly", "CEECFlag", "CiOppLineN", "AcctCode", "MYFtype" ) AS ((((((((((SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."INV1" T0  INNER  JOIN "SBODEMODE"."OINV" T1  ON  T1."DocEntry" = T0."DocEntry") UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."RIN1" T0  INNER  JOIN "SBODEMODE"."ORIN" T1  ON  T1."DocEntry" = T0."DocEntry")) UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."PCH1" T0  INNER  JOIN "SBODEMODE"."OPCH" T1  ON  T1."DocEntry" = T0."DocEntry")) UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."RPC1" T0  INNER  JOIN "SBODEMODE"."ORPC" T1  ON  T1."DocEntry" = T0."DocEntry")) UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."DPI1" T0  INNER  JOIN "SBODEMODE"."ODPI" T1  ON  T1."DocEntry" = T0."DocEntry")) UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."DPO1" T0  INNER  JOIN "SBODEMODE"."ODPO" T1  ON  T1."DocEntry" = T0."DocEntry")) UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."CSI1" T0  INNER  JOIN "SBODEMODE"."OCSI" T1  ON  T1."DocEntry" = T0."DocEntry")) UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."CPI1" T0  INNER  JOIN "SBODEMODE"."OCPI" T1  ON  T1."DocEntry" = T0."DocEntry")) UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."CSV1" T0  INNER  JOIN "SBODEMODE"."OCSV" T1  ON  T1."DocEntry" = T0."DocEntry")) UNION ALL (SELECT T0."DocEntry", T0."LineNum", T0."ObjType", 12 AS "ArrayType", T0."TaxOnly", T0."CEECFlag", T0."CiOppLineN", T0."AcctCode", T0."MYFtype" FROM  "SBODEMODE"."CPV1" T0  INNER  JOIN "SBODEMODE"."OCPV" T1  ON  T1."DocEntry" = T0."DocEntry")) WITH READ ONLY