DROP VIEW LD0VAA0ActivityGroup
;

CREATE VIEW LD0VAA0ActivityGroup
AS 
SELECT
 U72.*
,Q.KLARTEXT AS GRUPPTYP_T

FROM LD0V0U72 AS U72 
LEFT OUTER JOIN LD0V0Q01 AS Q ON Q.KODTYP = 'LNGRUPPTYP' AND U72.GRUPPTYP = Q.KOD
;