CREATE OR REPLACE VIEW BAUTEILKLAS ( TA_NAME1, PS_NR1, PS_NR2, BTKL_KURZ ) AS
SELECT 'BAUTKLAS', btkl_nr1, btkl_nr2, bk.btkl_kurz
FROM    BAUTKLAS bk
WHERE   bk.l_status = 1
UNION
SELECT  'BAUTEIL', bt_nr1, bt_nr2, bk.btkl_kurz
FROM    BAUTEIL bt, BAUTKLAS bk
WHERE   bt.btkl_nr1     = bk.btkl_nr1
AND bt.btkl_nr2 = bk.btkl_nr2
AND bt.l_status = 1
AND bk.l_status = 1