P_REOccupancyValidityCalc1

DDL: P_REOCCUPANCYVALIDITYCALC1 Type: view_entity COMPOSITE Package: VDM_RE_IP

RE Occpcy Validity Calc Helper 1

P_REOccupancyValidityCalc1 is a Composite CDS View that provides data about "RE Occpcy Validity Calc Helper 1" in SAP S/4HANA. It reads from 4 data sources (I_REIntegObjectObject2SpaceGrp, I_REIntegObjectObject2SpaceGrp, I_REIntegObjectObject2SpaceGrp, I_REIntegrationObjectTimeline) and exposes 10 fields. It has 2 associations to related views. Part of development package VDM_RE_IP.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
I_REIntegObjectObject2SpaceGrp _REIntegObjectObject2SpaceGrp from
I_REIntegObjectObject2SpaceGrp _REIntegObjectObject2SpaceGrp union_all
I_REIntegObjectObject2SpaceGrp _REIntegObjectObject2SpaceGrp union_all
I_REIntegrationObjectTimeline _REIntegObjectTimeline union_all

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_REMeasurement _REMeasurement $projection.InternalRealEstateNumberLvl3 = _REMeasurement.InternalRealEstateNumber
[0..1] I_REIntegObjectOccupancy _REIntegObjectOccupancy $projection.InternalRealEstateNumberLvl0 = _REIntegObjectOccupancy.REIntegObjectInternalNumber

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
InternalRealEstateNumberLvl0 I_REIntegObjectObject2SpaceGrp InternalRealEstateNumberLvl0
InternalRealEstateNumberLvl3 I_REIntegObjectObject2SpaceGrp InternalRealEstateNumberLvl3
ValidityStartDate
InternalRealEstateNumberLvl3 I_REIntegObjectObject2SpaceGrp InternalRealEstateNumberLvl3
ValidityStartDate
InternalRealEstateNumberLvl3 I_REIntegrationObjectTimeline InternalRealEstateNumber
ValidityStartDate
InternalRealEstateNumberLvl3 I_REIntegObjectObject2SpaceGrp InternalRealEstateNumberLvl3
ValidityStartDate
ValidityEndDate 
@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
}

Learn More