DROP VIEW LD0VL1C
;
CREATE VIEW LD0VL1C
      AS SELECT * 
      FROM LD0P0C URVAL
      WHERE EXISTS(SELECT 'X'
            FROM LD0V0AJD AJD
            WHERE AJD.VYNAMN = 'FUTRED'
            AND URVAL.TMARK = 0
            AND URVAL.AEVERKTYP >= AJD.JFRDTA1
            AND URVAL.AEVERKTYP <= AJD.JFRDTA2
            AND URVAL.ORGID = AJD.JFRDTA3
            AND URVAL.ORGENHNR LIKE AJD.JFRDTA10);
