P_REIntegObjMsmtHierDateCalc1

DDL: P_REINTEGOBJMSMTHIERDATECALC1 Type: view_entity COMPOSITE Package: VDM_RE_IP
4 Fields 4 Data Sources

Integration Object Measurement Hierarchy Date Calc View 1

P_REIntegObjMsmtHierDateCalc1 is a Composite CDS View that provides data about "Integration Object Measurement Hierarchy Date Calc View 1" in SAP S/4HANA. It reads from 4 data sources (P_REIntegObjMsmtHierCalc3, I_REIntegrationObjectRelation, I_REIntegrationObjectTimeline, I_REMeasurement) and exposes 4 fields with key field InternalRealEstateNumber. Part of development package VDM_RE_IP.

Data Sources (4)

SourceAliasJoin Type
P_REIntegObjMsmtHierCalc3 _REIntegObjMsmtHierCalc3 inner
I_REIntegrationObjectRelation _REIntegrationObjectRelation union_all
I_REIntegrationObjectTimeline _REIntegrationObjectTimeline inner
I_REMeasurement _REMeasurement from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Integration Object Measurement Hierarchy Date Calc View 1 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 (4)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber I_REMeasurement InternalRealEstateNumber RE Key
ValidityStartDateendasValidityStartDate
ValidityStartDate I_REIntegrationObjectRelation ValidityStartDate Validity Start Date
ValidityEndDate I_REIntegrationObjectRelation ValidityEndDate ValidTo

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_REIntegObjMsmtHierDateCalc1.
-- 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_REIntegObjMsmtHierDateCalc1 AS
SELECT
  _REMeasurement.InternalRealEstateNumber AS InternalRealEstateNumber,
  case when _REIntegrationObjectTimeline.ValidityStartDate < _REMeasurement.ValidityStartDate then _REMeasurement.ValidityStartDate else _REIntegrationObjectTimeline.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  _REIntegrationObjectRelation.ValidityStartDate AS ValidityStartDate,
  _REIntegrationObjectRelation.ValidityEndDate AS ValidityEndDate
FROM I_REMeasurement AS _REMeasurement
INNER JOIN I_REIntegrationObjectTimeline AS _REIntegrationObjectTimeline ON /* join condition not captured in parsed metadata */
INNER JOIN P_REIntegObjMsmtHierCalc3 AS _REIntegObjMsmtHierCalc3 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_REIntegrationObjectRelation
;

Learn More