DROP VIEW LD0VAA0B
;
CREATE VIEW LD0VAA0B
AS
SELECT B.AKTNR, B.ARKIVNR, B.TYPNR, t.KLARTEXT TYPNR_T, B.HAND,B. UPLDAT,B.UTLDAT,B.AKTPNR,B.UPDDAT,B.UPDSIGN,B.ANSVHAND,B.ORGID,B.ORGENHNR
  FROM LD0V0B B
  INNER JOIN LD0V0Q01 T 
  ON T.KODTYP ='AKTTYP' 
  AND T.KOD = B.TYPNR
;