I_REMeasurement

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_REMeasurement.
-- 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: IREMEASUREMENT

CREATE VIEW I_REMeasurement AS
SELECT
  intreno AS InternalRealEstateNumber,
  meas AS REMeasurementType,
  cast(validto as rebdvdmvalidto) AS ValidityEndDate,
  cast(validfrom as rebdvdmvalidfrom) AS ValidityStartDate,
  measvalue AS REMeasurementQuantity,
  measvaluecmpl AS REMaximumMeasurementQuantity,
  cast (measunit as msehiunit preserving type) AS REMeasurementUnit,
  ismanuallyset AS REMeasurementIsManuallySet,
  ishierarchical AS REMsmtHasSubordinateObject
FROM vibdmeas
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REMeasurementType AS _REMeasurementType ON REMeasurementType = _REMeasurementType.REMeasurementType  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON REMeasurementUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;