CREATE VIEW "SBODEMODE"."B1_EUSalesStockTransferView" ( "OCRD_LicTradNum", "OWHS_From_FedTaxID", "LineTotal", "Quantity", "DocEntry", "DocNum", "ObjType", "DocDate", "TaxDate", "VatDate", "FinncPriod", "CANCELED", "OWTR_CardCode", "OWTR_CardName", "Shipper_CardCode", "Shipper_CardName", "OWHS_From_Country", "OCRY_From_IsEc", "OWHS_To_Country", "OCRY_To_IsEc", "Dummy_TAX1_NdPercent", "Dummy_TAX1_CrditDebit", "Dummy_TAX1_BaseArrTyp", "Dummy_OVTG_TriangularDeal", "Dummy_OVTG_Code", "Dummy_OVTG_GoddsShip", "Dummy_OVTG_VatCategory", "Dummy_OVTG_ServSupply" ) AS SELECT T2."LicTradNum" AS "OCRD_LicTradNum", T3."FedTaxID" AS "OWHS_From_FedTaxID", T0."LineTotal", T0."Quantity", T1."DocEntry", T1."DocNum", T1."ObjType", T1."DocDate", T1."TaxDate", T1."VatDate", T1."FinncPriod", T1."CANCELED", T1."CardCode" AS "OWTR_CardCode", T1."CardName" AS "OWTR_CardName", T7."CardCode" AS "Shipper_CardCode", T7."CardName" AS "Shipper_CardName", T3."Country" AS "OWHS_From_Country", T5."IsEC" AS "OCRY_From_IsEc", T4."Country" AS "OWHS_To_Country", T6."IsEC" AS "OCRY_To_IsEc", T9."NdPercent" AS "Dummy_TAX1_NdPercent", T9."CrditDebit" AS "Dummy_TAX1_CrditDebit", T9."BaseArrTyp" AS "Dummy_TAX1_BaseArrTyp", T10."Indicator" AS "Dummy_OVTG_TriangularDeal", T10."Code" AS "Dummy_OVTG_Code", T10."GoddsShip" AS "Dummy_OVTG_GoddsShip", T10."Category" AS "Dummy_OVTG_VatCategory", T10."ServSupply" AS "Dummy_OVTG_ServSupply" FROM  "SBODEMODE"."WTR1" T0  INNER  JOIN "SBODEMODE"."OWTR" T1  ON  T0."DocEntry" = T1."DocEntry"    LEFT OUTER  JOIN "SBODEMODE"."OCRD" T2  ON  T1."CardCode" = T2."CardCode"   INNER  JOIN "SBODEMODE"."OWHS" T3  ON  T0."FromWhsCod" = T3."WhsCode"   INNER  JOIN "SBODEMODE"."OWHS" T4  ON  T0."WhsCode" = T4."WhsCode"   INNER  JOIN "SBODEMODE"."OCRY" T5  ON  T3."Country" = T5."Code"   INNER  JOIN "SBODEMODE"."OCRY" T6  ON  T4."Country" = T6."Code"    LEFT OUTER  JOIN "SBODEMODE"."OCRD" T7  ON  T3."Shipper" = T7."CardCode"   INNER  JOIN "SBODEMODE"."OADM" T8  ON  T8."CompnyName" = T8."CompnyName"    LEFT OUTER  JOIN "SBODEMODE"."TAX1" T9  ON  T9."AbsEntry" = -1    LEFT OUTER  JOIN "SBODEMODE"."OVTG" T10  ON  T10."Code" = ''   WHERE (T3."Country" = T8."Country"  AND  T5."IsEC" = ('Y' )  AND  T4."Country" <> T8."Country"  AND  T6."IsEC" = ('Y' ) ) OR  (T3."Country" <> T8."Country"  AND  T5."IsEC" = ('Y' )  AND  T4."Country" = T8."Country"  AND  T6."IsEC" = ('Y' ) ) OR  (T3."Country" <> T8."Country"  AND  T5."IsEC" = ('Y' )  AND  T4."Country" <> T8."Country"  AND  T6."IsEC" = ('Y' )  AND  T4."Country" <> T3."Country" ) WITH READ ONLY