@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #XL,
dataClass: #MASTER
}
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view entity P_REOccupancyValidityCalc1
as select from I_REIntegObjectObject2SpaceGrp as _REIntegObjectObject2SpaceGrp
association [0..1] to I_REMeasurement as _REMeasurement on $projection.InternalRealEstateNumberLvl3 = _REMeasurement.InternalRealEstateNumber
{
_REIntegObjectObject2SpaceGrp.InternalRealEstateNumberLvl0 as InternalRealEstateNumberLvl0,
_REIntegObjectObject2SpaceGrp.InternalRealEstateNumberLvl3 as InternalRealEstateNumberLvl3,
coalesce(_REMeasurement.ValidityStartDate,'00000000') as ValidityStartDate,
coalesce(_REMeasurement.ValidityEndDate,'99991231') as ValidityEndDate
}
union all select from I_REIntegObjectObject2SpaceGrp as _REIntegObjectObject2SpaceGrp
association [0..1] to I_REIntegObjectOccupancy as _REIntegObjectOccupancy on $projection.InternalRealEstateNumberLvl0 = _REIntegObjectOccupancy.REIntegObjectInternalNumber
{
_REIntegObjectObject2SpaceGrp.InternalRealEstateNumberLvl0 as InternalRealEstateNumberLvl0,
_REIntegObjectObject2SpaceGrp.InternalRealEstateNumberLvl3 as InternalRealEstateNumberLvl3,
coalesce(_REIntegObjectOccupancy.REOccupancyFromDate,'00000000') as ValidityStartDate,
coalesce(_REIntegObjectOccupancy.REOccupancyToDate,'99991231') as ValidityEndDate
}
union all select from I_REIntegrationObjectTimeline as _REIntegObjectTimeline
{
_REIntegObjectTimeline.InternalRealEstateNumber as InternalRealEstateNumberLvl0,
_REIntegObjectTimeline.InternalRealEstateNumber as InternalRealEstateNumberLvl3,
coalesce(_REIntegObjectTimeline.ValidityStartDate,'00000000') as ValidityStartDate,
coalesce(_REIntegObjectTimeline.ValidityEndDate,'99991231') as ValidityEndDate
}
union all select from I_REIntegObjectObject2SpaceGrp as _REIntegObjectObject2SpaceGrp
{
_REIntegObjectObject2SpaceGrp.InternalRealEstateNumberLvl0 as InternalRealEstateNumberLvl0,
_REIntegObjectObject2SpaceGrp.InternalRealEstateNumberLvl3 as InternalRealEstateNumberLvl3,
coalesce(_REIntegObjectObject2SpaceGrp.ValidityStartDate,'00000000') as ValidityStartDate,
coalesce(_REIntegObjectObject2SpaceGrp.ValidityEndDate,'99991231') as ValidityEndDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REINTEGOBJECTOBJECT2SPACEGRP",
"I_REINTEGOBJECTOCCUPANCY",
"I_REINTEGRATIONOBJECTTIMELINE",
"I_REMEASUREMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/