DROP VIEW LD0VAA0EnrollmentTranslator
;

CREATE VIEW LD0VAA0EnrollmentTranslator
AS 
SELECT
 U41.TOLKBESTNR
,U41.KONTAKTTILLFNR
,U41.SPRAK
,U41.UPDDAT
,U41.UPDSIGN
,Q.KLARTEXT AS SPRAK_T
FROM LD0V0U41 AS U41 
LEFT OUTER JOIN LD0V0Q01 AS Q ON Q.KODTYP = 'SPRAK' AND U41.SPRAK = Q.KOD
;
