P_REIntegObjMsmtHierCalc3

DDL: P_REINTEGOBJMSMTHIERCALC3 Type: view_entity COMPOSITE Package: VDM_RE_IP
13 Fields 2 Data Sources 1 Associations

Integration Object Measurement Hierarchy Calc View 3

P_REIntegObjMsmtHierCalc3 is a Composite CDS View that provides data about "Integration Object Measurement Hierarchy Calc View 3" in SAP S/4HANA. It reads from 2 data sources (I_REIntegrationObjectRelation, I_REIntegrationObjectSubObj) and exposes 13 fields with key fields InternalRealEstateNumberLvl0, InternalRealEstateNumberLvl1, InternalRealEstateNumberLvl2, InternalRealEstateNumberLvl3, ValidityEndDate. It has 1 association to related views. Part of development package VDM_RE_IP.

Data Sources (2)

SourceAliasJoin Type
I_REIntegrationObjectRelation _REIntegObjectRelation inner
I_REIntegrationObjectSubObj _REIntegrationObjectSubObj from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REIntegrationObjectBasicData _REIntegObjLvl0 _REIntegObjectRelation.InternalRealEstateNumber = _REIntegObjLvl0.InternalRealEstateNumber

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Integration Object Measurement Hierarchy Calc View 3 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumberLvl0 I_REIntegrationObjectRelation InternalRealEstateNumber RE Key
KEY InternalRealEstateNumberLvl1 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl1 RE Key
KEY InternalRealEstateNumberLvl2 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl2
KEY InternalRealEstateNumberLvl3 I_REIntegrationObjectSubObj InternalRealEstateNumberLvl3
KEY ValidityEndDate I_REIntegrationObjectRelation ValidityEndDate ValidTo
KEY ValidityStartDate I_REIntegrationObjectRelation ValidityStartDate Validity Start Date
RealEstateExternalIDLvl0 _REIntegObjLvl0 RealEstateExternalID
ValidityStartDateLvl0 I_REIntegrationObjectRelation ValidityStartDate Validity Start Date
ValidityEndDateLvl0 I_REIntegrationObjectRelation ValidityEndDate ValidTo
InternalRealEstateNumberRltn I_REIntegrationObjectRelation InternalRealEstateNumberRltn Int. Num Relation
REIsObjectRelationPartial I_REIntegrationObjectRelation REIsObjectRelationPartial Partial Object Relation
REInternalNumberForUseEnable _REIntegObjLvl0 REInternalNumberForUseEnable
REIntegObjSpaceGroupType _REIntegObjLvl0 REIntegObjSpaceGroupType

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 P_REIntegObjMsmtHierCalc3.
-- 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 P_REIntegObjMsmtHierCalc3 AS
SELECT
  _REIntegObjectRelation.InternalRealEstateNumber AS InternalRealEstateNumberLvl0,
  _REIntegrationObjectSubObj.InternalRealEstateNumberLvl1 AS InternalRealEstateNumberLvl1,
  _REIntegrationObjectSubObj.InternalRealEstateNumberLvl2 AS InternalRealEstateNumberLvl2,
  _REIntegrationObjectSubObj.InternalRealEstateNumberLvl3 AS InternalRealEstateNumberLvl3,
  _REIntegObjectRelation.ValidityEndDate AS ValidityEndDate,
  _REIntegObjectRelation.ValidityStartDate AS ValidityStartDate,
  _REIntegObjLvl0.RealEstateExternalID AS RealEstateExternalIDLvl0,
  _REIntegObjectRelation.ValidityStartDate AS ValidityStartDateLvl0,
  _REIntegObjectRelation.ValidityEndDate AS ValidityEndDateLvl0,
  _REIntegObjectRelation.InternalRealEstateNumberRltn AS InternalRealEstateNumberRltn,
  _REIntegObjectRelation.REIsObjectRelationPartial AS REIsObjectRelationPartial,
  _REIntegObjLvl0.REInternalNumberForUseEnable AS REInternalNumberForUseEnable,
  _REIntegObjLvl0.REIntegObjSpaceGroupType AS REIntegObjSpaceGroupType
FROM I_REIntegrationObjectSubObj AS _REIntegrationObjectSubObj
INNER JOIN I_REIntegrationObjectRelation AS _REIntegObjectRelation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_REIntegrationObjectBasicData AS _REIntegObjLvl0 ON _REIntegObjectRelation.InternalRealEstateNumber = _REIntegObjLvl0.InternalRealEstateNumber  -- association [1..1]
;

Learn More