I_REIntegObjectOccupancy

@AbapCatalog.sqlViewName: 'IREINTOBJOCC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Object Occupancy'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

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

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.supportedCapabilities:  [  #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
                                        #EXTRACTION_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE]

@Analytics:{
    dataExtraction: {
        enabled: true
    }
}

define view I_REIntegObjectOccupancy
  as select from P_REIntegObjectOccpcyCalc2
{
  REIntegObjectStatusObject,
  REContractStatusObject,
  REIntegObjectInternalNumber,
  REContractInternalNumber,
  CompanyCode,
  RealEstateContract,
  REOccupancyFromDate,
  REOccupancyToDate,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate,
  ContractStartDate,
  ContractEndDate,
  REObjAssgmtValidityStartDate,
  REObjAssgmtValidityEndDate,
  REObjectPossessionStartDate,
  REObjectPossessionEndDate,
  IsVacant,
  REContractIsActive
  
}
union select from P_REIntegObjectOccpcyCalc8
{
  REIntegObjectStatusObject,
  ' ' as REContractStatusObject,
  REIntegObjectInternalNumber,
  ' ' as REContractInternalNumber,
  ' ' as CompanyCode,
  ' ' as RealEstateContract,
  REOccupancyFromDate,
  REOccupancyToDate,
  REIntegObjectValidityStartDate,
  REIntegObjectValidityEndDate,
  ' ' as ContractStartDate,
  ' ' as ContractEndDate,
  ' ' as REObjAssgmtValidityStartDate,
  ' ' as REObjAssgmtValidityEndDate,
  ' ' as REObjectPossessionStartDate,
  ' ' as REObjectPossessionEndDate,
  IsVacant,
  ' ' as REContractIsActive
}