I_REIntegObjectHierarchyMap

DDL: I_REINTEGOBJECTHIERARCHYMAP Type: view_entity COMPOSITE

Real Estate Integ Obj Lvl to Obj Mapper

I_REIntegObjectHierarchyMap is a Composite CDS View (Cube) that provides data about "Real Estate Integ Obj Lvl to Obj Mapper" in SAP S/4HANA. It reads from 1 data source (I_REIntegrationObjectSubObj) and exposes 11 fields with key fields InternalRealEstateNumberLvl0, InternalRealEstateNumberLvl1, InternalRealEstateNumberLvl2, InternalRealEstateNumberLvl3. It has 7 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_REIntegrationObjectSubObj _REIntegObjectHierarchy from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_REIntegrationObjectBasicData _REIntegrationObjectSite $projection.InternalRealEstateNumberLvl0 = _REIntegrationObjectSite.InternalRealEstateNumber and _REIntegrationObjectSite.REIntegrationObjectType = 'C4SI'
[0..1] I_REIntegrationObjectBasicData _REIntegrationObjectLand $projection.InternalRealEstateNumberLvl1 = _REIntegrationObjectLand.InternalRealEstateNumber and _REIntegrationObjectLand.REIntegrationObjectType = 'C4PR'
[0..1] I_REIntegrationObjectBasicData _REIntegrationObjectBuilding $projection.InternalRealEstateNumberLvl1 = _REIntegrationObjectBuilding.InternalRealEstateNumber and _REIntegrationObjectBuilding.REIntegrationObjectType = 'C4BU'
[0..1] I_REIntegrationObjectBasicData _REIntegrationObjectSpaceGroup ( $projection.InternalRealEstateNumberLvl2 = _REIntegrationObjectSpaceGroup.InternalRealEstateNumber or $projection.InternalRealEstateNumberLvl3 = _REIntegrationObjectSpaceGroup.InternalRealEstateNumber ) and _REIntegrationObjectSpaceGroup.REIntegrationObjectType = 'C4SG'
[0..1] I_REIntegrationObjectBasicData _REIntegrationObjectFloor ( $projection.InternalRealEstateNumberLvl2 = _REIntegrationObjectFloor.InternalRealEstateNumber or $projection.InternalRealEstateNumberLvl3 = _REIntegrationObjectFloor.InternalRealEstateNumber ) and _REIntegrationObjectFloor.REIntegrationObjectType = 'C4FL'
[0..1] I_REIntegrationObjectBasicData _REIntegrationObjectLandArea ( $projection.InternalRealEstateNumberLvl3 = _REIntegrationObjectLandArea.InternalRealEstateNumber or $projection.InternalRealEstateNumberLvl2 = _REIntegrationObjectLandArea.InternalRealEstateNumber ) and _REIntegrationObjectLandArea.REIntegrationObjectType = 'C4LA'
[0..1] I_REIntegrationObjectBasicData _REIntegrationObjectSpace ( $projection.InternalRealEstateNumberLvl3 = _REIntegrationObjectSpace.InternalRealEstateNumber or $projection.InternalRealEstateNumberLvl2 = _REIntegrationObjectSpace.InternalRealEstateNumber ) and _REIntegrationObjectSpace.REIntegrationObjectType = 'C4SP'

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integ Obj Lvl to Obj Mapper view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumberLvl0 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl0
KEY InternalRealEstateNumberLvl1 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl1
KEY InternalRealEstateNumberLvl2 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl2
KEY InternalRealEstateNumberLvl3 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl3
_REIntegrationObjectSite _REIntegrationObjectSite
_REIntegrationObjectLand _REIntegrationObjectLand
_REIntegrationObjectBuilding _REIntegrationObjectBuilding
_REIntegrationObjectSpaceGroup _REIntegrationObjectSpaceGroup
_REIntegrationObjectFloor _REIntegrationObjectFloor
_REIntegrationObjectLandArea _REIntegrationObjectLandArea
_REIntegrationObjectSpace _REIntegrationObjectSpace 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Obj Lvl to Obj Mapper'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@Analytics: {dataCategory: #CUBE}
@Analytics.internalName:#LOCAL
define view entity I_REIntegObjectHierarchyMap
  as select from I_REIntegrationObjectSubObj as _REIntegObjectHierarchy
  association [1..1] to I_REIntegrationObjectBasicData as _REIntegrationObjectSite       on  $projection.InternalRealEstateNumberLvl0         = _REIntegrationObjectSite.InternalRealEstateNumber
                                                                                         and _REIntegrationObjectSite.REIntegrationObjectType = 'C4SI'
  association [0..1] to I_REIntegrationObjectBasicData as _REIntegrationObjectLand       on  $projection.InternalRealEstateNumberLvl1         = _REIntegrationObjectLand.InternalRealEstateNumber
                                                                                         and _REIntegrationObjectLand.REIntegrationObjectType = 'C4PR'
  association [0..1] to I_REIntegrationObjectBasicData as _REIntegrationObjectBuilding   on  $projection.InternalRealEstateNumberLvl1             = _REIntegrationObjectBuilding.InternalRealEstateNumber
                                                                                         and _REIntegrationObjectBuilding.REIntegrationObjectType = 'C4BU'
  association [0..1] to I_REIntegrationObjectBasicData as _REIntegrationObjectSpaceGroup on  (
      $projection.InternalRealEstateNumberLvl2                                                                                                      = _REIntegrationObjectSpaceGroup.InternalRealEstateNumber
      or $projection.InternalRealEstateNumberLvl3                                                                                                   = _REIntegrationObjectSpaceGroup.InternalRealEstateNumber
    )
                                                                                         and _REIntegrationObjectSpaceGroup.REIntegrationObjectType = 'C4SG'

  association [0..1] to I_REIntegrationObjectBasicData as _REIntegrationObjectFloor      on  (
           $projection.InternalRealEstateNumberLvl2                                                                                            = _REIntegrationObjectFloor.InternalRealEstateNumber
           or $projection.InternalRealEstateNumberLvl3                                                                                         = _REIntegrationObjectFloor.InternalRealEstateNumber
         )
                                                                                         and _REIntegrationObjectFloor.REIntegrationObjectType = 'C4FL'
  association [0..1] to I_REIntegrationObjectBasicData as _REIntegrationObjectLandArea   on  (
        $projection.InternalRealEstateNumberLvl3                                                                                                  = _REIntegrationObjectLandArea.InternalRealEstateNumber
        or $projection.InternalRealEstateNumberLvl2                                                                                               = _REIntegrationObjectLandArea.InternalRealEstateNumber
      )
                                                                                         and _REIntegrationObjectLandArea.REIntegrationObjectType = 'C4LA'
  association [0..1] to I_REIntegrationObjectBasicData as _REIntegrationObjectSpace      on  (
           $projection.InternalRealEstateNumberLvl3                                                                                            = _REIntegrationObjectSpace.InternalRealEstateNumber
           or $projection.InternalRealEstateNumberLvl2                                                                                         = _REIntegrationObjectSpace.InternalRealEstateNumber
         )
                                                                                         and _REIntegrationObjectSpace.REIntegrationObjectType = 'C4SP'

{
  key     _REIntegObjectHierarchy.InternalRealEstateNumberLvl0 as InternalRealEstateNumberLvl0,
  key     _REIntegObjectHierarchy.InternalRealEstateNumberLvl1 as InternalRealEstateNumberLvl1,
  key     _REIntegObjectHierarchy.InternalRealEstateNumberLvl2 as InternalRealEstateNumberLvl2,
  key     _REIntegObjectHierarchy.InternalRealEstateNumberLvl3 as InternalRealEstateNumberLvl3,

          /* Associations */
          _REIntegrationObjectSite,
          _REIntegrationObjectLand,
          _REIntegrationObjectBuilding,
          _REIntegrationObjectSpaceGroup,
          _REIntegrationObjectFloor,
          _REIntegrationObjectLandArea,
          _REIntegrationObjectSpace
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REINTEGRATIONOBJECTSUBOBJ"
],
"ASSOCIATED":
[
"I_REINTEGRATIONOBJECTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More