P_REIntegObjMsmtHierCalc7

DDL: P_REINTEGOBJMSMTHIERCALC7 Type: view_entity COMPOSITE
10 Fields 2 Data Sources

Integration Object Measurement Hierarchy Date Calc View 7

P_REIntegObjMsmtHierCalc7 is a Composite CDS View that provides data about "Integration Object Measurement Hierarchy Date Calc View 7" in SAP S/4HANA. It reads from 2 data sources (P_REIntegObjMsmtHierCalc5, I_REIntegrationObjectRelation) and exposes 10 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 7 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 (10)

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
InternalRealEstateNumberRltn I_REIntegrationObjectRelation InternalRealEstateNumberRltn Int. Num Relation
REMeasurementTotalQuantity P_REIntegObjMsmtHierCalc5 REMeasurementQuantity
REMeasurementPartialUnit I_REIntegrationObjectRelation REMeasurementUnit
REMeasurementPartialQuantity I_REIntegrationObjectRelation REMeasurementPartialQuantity Partial Amount

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_REIntegObjMsmtHierCalc7.
-- 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_REIntegObjMsmtHierCalc7 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,
  _REIntegrationObjectRelation.InternalRealEstateNumberRltn AS InternalRealEstateNumberRltn,
  _REIntegObjMsmtHierCalc5.REMeasurementQuantity AS REMeasurementTotalQuantity,
  _REIntegrationObjectRelation.REMeasurementUnit AS REMeasurementPartialUnit,
  _REIntegrationObjectRelation.REMeasurementPartialQuantity AS REMeasurementPartialQuantity
FROM P_REIntegObjMsmtHierCalc5 AS _REIntegObjMsmtHierCalc5
INNER JOIN I_REIntegrationObjectRelation AS _REIntegrationObjectRelation ON /* join condition not captured in parsed metadata */
;

Learn More