TSI_DB_SK

create view [<vlastnik>].<nazov view> as ....

--------------------


create view PRODUKTIONSWARTUNG.V_AUX_CLAR_STAMMDATEN
  2  as   SELECT
  3          ts.s_site_id                               -- TOID
  4        , ts.x_ksa_subscription_status               -- sprech. KD-STATUS, jedoch != STATUS
  5        , ts.status                                  -- STATUS
  6        , xa.s_x_ksa_debtor_number                   -- BKTO
  7        , xa.s_x_ksa_account_number                  -- KDNR
  8        , ts.s_x_ksa_fkto                            -- FKTO / GRUS
  9        , ts.x_ksa_setup_type                        -- KD_ART
 10        , ts.x_ksa_customer_class                    -- Kundenklasse sprechend
 11        , ts.x_ksa_cust_class_code                   -- Kundenklasse nummerisch
 12        , ts.x_ksa_customer_category                 -- KD_KATEGORIE_STR
 13        , ts.x_ksa_cust_cat_code                     -- KD_KATEGORIE_NUM
      FROM  table_site       ts
 14   15        ,     table_x_account  xa
 16        WHERE ts.site2x_account         = xa.objid
 17        AND   trim(ts.s_site_id)        IS NOT NULL
 18        AND   (    ts.status                           = 0
 19                OR lower(ts.x_ksa_subscription_status) = 'aktiv' );

View created.