P_REIntegObjMsmtHierCalc6

DDL: P_REINTEGOBJMSMTHIERCALC6 Type: view_entity COMPOSITE
7 Fields 2 Data Sources

Integration Object Measurement Hierarchy Date Calc View 5

P_REIntegObjMsmtHierCalc6 is a Composite CDS View that provides data about "Integration Object Measurement Hierarchy Date Calc View 5" in SAP S/4HANA. It reads from 2 data sources (P_REIntegObjMsmtHierCalc5, I_REIntegrationObjectRelation) and exposes 7 fields with key fields InternalRealEstatenumber, REMeasurementType, ValidityStartDateendasValidityStartDate, ValidityEndDateendasValidityEndDate.

Data Sources (2)

SourceAliasJoin Type
P_REIntegObjMsmtHierCalc5 _REIntegObjMsmtHierCalc5 from
I_REIntegrationObjectRelation _REIntegrationObjectRelation inner

Annotations (8)

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

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstatenumber I_REIntegrationObjectRelation InternalRealEstateNumber RE Key
KEY REMeasurementType P_REIntegObjMsmtHierCalc5 REMeasurementType MeasType
KEY ValidityStartDateendasValidityStartDate
KEY ValidityEndDateendasValidityEndDate
REMeasurementUnit P_REIntegObjMsmtHierCalc5 REMeasurementUnit
REIntegrationObjectType P_REIntegObjMsmtHierCalc5 REIntegrationObjectType
REMeasurementTotalQuantity

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_REIntegObjMsmtHierCalc6.
-- 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_REIntegObjMsmtHierCalc6 AS
SELECT
  _REIntegrationObjectRelation.InternalRealEstateNumber AS InternalRealEstatenumber,
  _REIntegObjMsmtHierCalc5.REMeasurementType AS REMeasurementType,
  case when _REIntegObjMsmtHierCalc5.ValidityStartDate > _REIntegrationObjectRelation.ValidityStartDate then _REIntegObjMsmtHierCalc5.ValidityStartDate else _REIntegrationObjectRelation.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  case when _REIntegObjMsmtHierCalc5.ValidityEndDate < _REIntegrationObjectRelation.ValidityEndDate then _REIntegObjMsmtHierCalc5.ValidityEndDate else _REIntegrationObjectRelation.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  _REIntegObjMsmtHierCalc5.REMeasurementUnit AS REMeasurementUnit,
  _REIntegObjMsmtHierCalc5.REIntegrationObjectType AS REIntegrationObjectType,
  sum( _REIntegObjMsmtHierCalc5.REMeasurementQuantity ) AS REMeasurementTotalQuantity
FROM P_REIntegObjMsmtHierCalc5 AS _REIntegObjMsmtHierCalc5
INNER JOIN I_REIntegrationObjectRelation AS _REIntegrationObjectRelation ON /* join condition not captured in parsed metadata */
;

Learn More