P_REIntegObjectOccpcyCalc6

@AbapCatalog.sqlViewName: 'PREINTOBJOCCCAL6'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view P_REIntegObjectOccpcyCalc6
  as select from           P_REIntegObjectOccpcyCalc2 as _REIntegObjectOccpcyCalc
    inner join             P_REIntegObjectOccpcyCalc2 as _REIntegObjectOccpcyCalc2 on  _REIntegObjectOccpcyCalc.REIntegObjectStatusObject =  _REIntegObjectOccpcyCalc2.REIntegObjectStatusObject
                                                                                   and _REIntegObjectOccpcyCalc.RENextOccupancyToDate     <= _REIntegObjectOccpcyCalc2.REOccupancyFromDate
    left outer to one join P_REIntegObjectOccpcyCalc2 as _REIntegObjectOccpcyCalc3 on  _REIntegObjectOccpcyCalc.REIntegObjectStatusObject = _REIntegObjectOccpcyCalc3.REIntegObjectStatusObject
                                                                                   and _REIntegObjectOccpcyCalc.RENextOccupancyToDate     = _REIntegObjectOccpcyCalc3.REOccupancyFromDate
{
  _REIntegObjectOccpcyCalc.REIntegObjectStatusObject,
  _REIntegObjectOccpcyCalc.REContractStatusObject,
  _REIntegObjectOccpcyCalc.REIntegObjectInternalNumber,
  _REIntegObjectOccpcyCalc.REContractInternalNumber,
  _REIntegObjectOccpcyCalc.CompanyCode,
  _REIntegObjectOccpcyCalc.RealEstateContract,
  _REIntegObjectOccpcyCalc.REOccupancyFromDate,
  _REIntegObjectOccpcyCalc.REOccupancyToDate,
  _REIntegObjectOccpcyCalc.REPrevOccupancyFromDate,
  _REIntegObjectOccpcyCalc.RENextOccupancyToDate,
  _REIntegObjectOccpcyCalc.REIntegObjectValidityStartDate,
  _REIntegObjectOccpcyCalc.REIntegObjectValidityEndDate,
  _REIntegObjectOccpcyCalc.ContractStartDate,
  _REIntegObjectOccpcyCalc.ContractEndDate,
  _REIntegObjectOccpcyCalc.REObjAssgmtValidityStartDate,
  _REIntegObjectOccpcyCalc.REObjAssgmtValidityEndDate,
  _REIntegObjectOccpcyCalc.REObjectPossessionStartDate,
  _REIntegObjectOccpcyCalc.REObjectPossessionEndDate,
  _REIntegObjectOccpcyCalc2.REIntegObjectStatusObject as REIntegObjectStatusObject2,
  _REIntegObjectOccpcyCalc2.REContractStatusObject    as REContractStatusObject2,
  _REIntegObjectOccpcyCalc2.REOccupancyFromDate       as REOccupancyFromDate2,
  _REIntegObjectOccpcyCalc2.REOccupancyToDate         as REOccupancyToDate2,
  _REIntegObjectOccpcyCalc2.REPrevOccupancyFromDate   as REPrevOccupancyFromDate2,
  _REIntegObjectOccpcyCalc2.RENextOccupancyToDate     as RENextOccupancyToDate2
}
where
      _REIntegObjectOccpcyCalc3.REIntegObjectStatusObject is null
  and _REIntegObjectOccpcyCalc.REOccupancyToDate          <> '99991231'