I_REIntegObjectHierarchyMap

DDL: I_REINTEGOBJECTHIERARCHYMAP Type: view_entity COMPOSITE Package: VDM_RE_IP
11 Fields 1 Data Sources 7 Associations

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. Part of development package VDM_RE_IP.

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 RE Key
KEY InternalRealEstateNumberLvl1 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl1 RE Key
KEY InternalRealEstateNumberLvl2 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl2
KEY InternalRealEstateNumberLvl3 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl3
_REIntegrationObjectSite _REIntegrationObjectSite
_REIntegrationObjectLand _REIntegrationObjectLand
_REIntegrationObjectBuilding _REIntegrationObjectBuilding
_REIntegrationObjectSpaceGroup _REIntegrationObjectSpaceGroup
_REIntegrationObjectFloor _REIntegrationObjectFloor
_REIntegrationObjectLandArea _REIntegrationObjectLandArea
_REIntegrationObjectSpace _REIntegrationObjectSpace

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_REIntegObjectHierarchyMap.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_REIntegObjectHierarchyMap AS
SELECT
  _REIntegObjectHierarchy.InternalRealEstateNumberLvl0 AS InternalRealEstateNumberLvl0,
  _REIntegObjectHierarchy.InternalRealEstateNumberLvl1 AS InternalRealEstateNumberLvl1,
  _REIntegObjectHierarchy.InternalRealEstateNumberLvl2 AS InternalRealEstateNumberLvl2,
  _REIntegObjectHierarchy.InternalRealEstateNumberLvl3 AS InternalRealEstateNumberLvl3
FROM I_REIntegrationObjectSubObj AS _REIntegObjectHierarchy
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegrationObjectSite ON InternalRealEstateNumberLvl0 = _REIntegrationObjectSite.InternalRealEstateNumber AND _REIntegrationObjectSite.REIntegrationObjectType = 'C4SI'  -- association [1..1]
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegrationObjectLand ON InternalRealEstateNumberLvl1 = _REIntegrationObjectLand.InternalRealEstateNumber AND _REIntegrationObjectLand.REIntegrationObjectType = 'C4PR'  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegrationObjectBuilding ON InternalRealEstateNumberLvl1 = _REIntegrationObjectBuilding.InternalRealEstateNumber AND _REIntegrationObjectBuilding.REIntegrationObjectType = 'C4BU'  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegrationObjectSpaceGroup ON ( InternalRealEstateNumberLvl2 = _REIntegrationObjectSpaceGroup.InternalRealEstateNumber OR InternalRealEstateNumberLvl3 = _REIntegrationObjectSpaceGroup.InternalRealEstateNumber ) AND _REIntegrationObjectSpaceGroup.REIntegrationObjectType = 'C4SG'  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegrationObjectFloor ON ( InternalRealEstateNumberLvl2 = _REIntegrationObjectFloor.InternalRealEstateNumber OR InternalRealEstateNumberLvl3 = _REIntegrationObjectFloor.InternalRealEstateNumber ) AND _REIntegrationObjectFloor.REIntegrationObjectType = 'C4FL'  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegrationObjectLandArea ON ( InternalRealEstateNumberLvl3 = _REIntegrationObjectLandArea.InternalRealEstateNumber OR InternalRealEstateNumberLvl2 = _REIntegrationObjectLandArea.InternalRealEstateNumber ) AND _REIntegrationObjectLandArea.REIntegrationObjectType = 'C4LA'  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegrationObjectSpace ON ( InternalRealEstateNumberLvl3 = _REIntegrationObjectSpace.InternalRealEstateNumber OR InternalRealEstateNumberLvl2 = _REIntegrationObjectSpace.InternalRealEstateNumber ) AND _REIntegrationObjectSpace.REIntegrationObjectType = 'C4SP'  -- association [0..1]
;

Learn More