I_REIntegObjectMsmtSubObj

DDL: I_REINTEGOBJECTMSMTSUBOBJ SQL: IREINTOBMSSUBOBJ Type: view COMPOSITE
22 Fields 2 Data Sources

Real Estate Integ Measurement Subobject

I_REIntegObjectMsmtSubObj is a Composite CDS View that provides data about "Real Estate Integ Measurement Subobject" in SAP S/4HANA. It reads from 2 data sources (I_REIntegObjectSubObjValidity, I_REMeasurement) and exposes 22 fields with key fields InternalRealEstateNumberLvl3, REMeasurementType, ValidityEndDateendasValidityEndDate.

Data Sources (2)

SourceAliasJoin Type
I_REIntegObjectSubObjValidity _REIntegObjectSubObjValidity from
I_REMeasurement _REMeasurement inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBMSSUBOBJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integ Measurement Subobject view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumberLvl3 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl3
KEY REMeasurementType I_REMeasurement REMeasurementType MeasType
KEY ValidityEndDateendasValidityEndDate
ValidityStartDateendasValidityStartDate
InternalRealEstateNumberLvl2 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl2
InternalRealEstateNumberLvl1 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl1 RE Key
InternalRealEstateNumberLvl0 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl0 RE Key
ValidityStartDateLvl0 I_REIntegObjectSubObjValidity ValidityStartDateLvl0 Validity Start Date
ValidityEndDateLvl0 I_REIntegObjectSubObjValidity ValidityEndDateLvl0 ValidTo
ValidityStartDateLvl1 I_REIntegObjectSubObjValidity ValidityStartDateLvl1 Validity Start Date
ValidityEndDateLvl1 I_REIntegObjectSubObjValidity ValidityEndDateLvl1 ValidTo
ValidityStartDateLvl2 I_REIntegObjectSubObjValidity ValidityStartDateLvl2
ValidityEndDateLvl2 I_REIntegObjectSubObjValidity ValidityEndDateLvl2
ValidityStartDateLvl3 I_REIntegObjectSubObjValidity ValidityStartDateLvl3
ValidityEndDateLvl3 I_REIntegObjectSubObjValidity ValidityEndDateLvl3
REMeasurementQuantity I_REMeasurement REMeasurementQuantity Assigned Amount
REMaximumMeasurementQuantity REMaximumMeasurementQuantity Capacity
REMeasurementUnit REMeasurementUnit
REMeasurementIsManuallySet REMeasurementIsManuallySet ManualOverwrite
REMsmtHasSubordinateObject REMsmtHasSubordinateObject Hierarchical
_REMeasurementType _REMeasurementType
_UnitOfMeasure _UnitOfMeasure

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_REIntegObjectMsmtSubObj.
-- 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.
-- SQL view name: IREINTOBMSSUBOBJ

CREATE VIEW I_REIntegObjectMsmtSubObj AS
SELECT
  _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 AS InternalRealEstateNumberLvl3,
  _REMeasurement.REMeasurementType AS REMeasurementType,
  case when _REMeasurement.ValidityEndDate > _REIntegObjectSubObjValidity.ValidityEndDateLvl3 then _REIntegObjectSubObjValidity.ValidityEndDateLvl3 when _REMeasurement.ValidityEndDate > _REIntegObjectSubObjValidity.ValidityEndDateLvl2 then _REIntegObjectSubObjValidity.ValidityEndDateLvl2 when _REMeasurement.ValidityEndDate > _REIntegObjectSubObjValidity.ValidityEndDateLvl1 then _REIntegObjectSubObjValidity.ValidityEndDateLvl1 when _REMeasurement.ValidityEndDate > _REIntegObjectSubObjValidity.ValidityEndDateLvl0 then _REIntegObjectSubObjValidity.ValidityEndDateLvl0 else _REMeasurement.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate,
  case when _REMeasurement.ValidityStartDate < _REIntegObjectSubObjValidity.ValidityStartDateLvl3 then _REIntegObjectSubObjValidity.ValidityStartDateLvl3 when _REMeasurement.ValidityStartDate < _REIntegObjectSubObjValidity.ValidityStartDateLvl2 then _REIntegObjectSubObjValidity.ValidityStartDateLvl2 when _REMeasurement.ValidityStartDate < _REIntegObjectSubObjValidity.ValidityStartDateLvl1 then _REIntegObjectSubObjValidity.ValidityStartDateLvl1 when _REMeasurement.ValidityStartDate < _REIntegObjectSubObjValidity.ValidityStartDateLvl0 then _REIntegObjectSubObjValidity.ValidityStartDateLvl0 else _REMeasurement.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl2 AS InternalRealEstateNumberLvl2,
  _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl1 AS InternalRealEstateNumberLvl1,
  _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl0 AS InternalRealEstateNumberLvl0,
  _REIntegObjectSubObjValidity.ValidityStartDateLvl0 AS ValidityStartDateLvl0,
  _REIntegObjectSubObjValidity.ValidityEndDateLvl0 AS ValidityEndDateLvl0,
  _REIntegObjectSubObjValidity.ValidityStartDateLvl1 AS ValidityStartDateLvl1,
  _REIntegObjectSubObjValidity.ValidityEndDateLvl1 AS ValidityEndDateLvl1,
  _REIntegObjectSubObjValidity.ValidityStartDateLvl2 AS ValidityStartDateLvl2,
  _REIntegObjectSubObjValidity.ValidityEndDateLvl2 AS ValidityEndDateLvl2,
  _REIntegObjectSubObjValidity.ValidityStartDateLvl3 AS ValidityStartDateLvl3,
  _REIntegObjectSubObjValidity.ValidityEndDateLvl3 AS ValidityEndDateLvl3,
  _REMeasurement.REMeasurementQuantity AS REMeasurementQuantity,
  REMaximumMeasurementQuantity,
  REMeasurementUnit,
  REMeasurementIsManuallySet,
  REMsmtHasSubordinateObject
FROM I_REIntegObjectSubObjValidity AS _REIntegObjectSubObjValidity
INNER JOIN I_REMeasurement AS _REMeasurement ON /* join condition not captured in parsed metadata */
;

Learn More