R_RERntblObjectMeasurementTP

DDL: R_RERNTBLOBJECTMEASUREMENTTP Type: view_entity TRANSACTIONAL Package: RAP_RE_GO
15 Fields 2 Data Sources 1 Associations

RE Rentable Object Measurement TP

R_RERntblObjectMeasurementTP is a Transactional CDS View that provides data about "RE Rentable Object Measurement TP" in SAP S/4HANA. It reads from 2 data sources (I_REMeasurement, I_RERentableObject) and exposes 15 fields with key fields RealEstateRentableObjectUUID, InternalRealEstateNumber, REMeasurementType, ValidityEndDate. It has 1 association to related views. Part of development package RAP_RE_GO.

Data Sources (2)

SourceAliasJoin Type
I_REMeasurement _REMeasurement from
I_RERentableObject _RERentableObjectData inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REEntryValidity _REEntryValidity $projection.REEntryValidity = _REEntryValidity.REEntryValidity

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label RE Rentable Object Measurement TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY RealEstateRentableObjectUUID I_RERentableObject RealEstateRentableObjectUUID UUID GO
KEY InternalRealEstateNumber I_REMeasurement InternalRealEstateNumber RE Key
KEY REMeasurementType I_REMeasurement REMeasurementType MeasType
KEY ValidityEndDate
ValidityEndDateForEdit I_REMeasurement ValidityEndDate ValidTo
ValidityStartDate I_REMeasurement ValidityStartDate Validity Start Date
REMeasurementTypeForEdit I_REMeasurement REMeasurementType MeasType
REMeasurementIsTotal
REMeasurementUnit I_REMeasurement REMeasurementUnit
REMeasurementQuantity I_REMeasurement REMeasurementQuantity Assigned Amount
REMaximumMeasurementQuantity I_REMeasurement REMaximumMeasurementQuantity Capacity
_RERentableObject _RERentableObject
_REMeasurementType I_REMeasurement _REMeasurementType
_UnitOfMeasure I_REMeasurement _UnitOfMeasure
_REEntryValidity _REEntryValidity

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 R_RERntblObjectMeasurementTP.
-- 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 R_RERntblObjectMeasurementTP AS
SELECT
  _RERentableObjectData.RealEstateRentableObjectUUID AS RealEstateRentableObjectUUID,
  _REMeasurement.InternalRealEstateNumber AS InternalRealEstateNumber,
  _REMeasurement.REMeasurementType AS REMeasurementType,
  cast( _REMeasurement.ValidityEndDate as abap.char(8) ) AS ValidityEndDate,
  _REMeasurement.ValidityEndDate AS ValidityEndDateForEdit,
  _REMeasurement.ValidityStartDate AS ValidityStartDate,
  _REMeasurement.REMeasurementType AS REMeasurementTypeForEdit,
  _REMeasurement._REMeasurementType.REMeasurementIsTotal AS REMeasurementIsTotal,
  _REMeasurement.REMeasurementUnit AS REMeasurementUnit,
  _REMeasurement.REMeasurementQuantity AS REMeasurementQuantity,
  _REMeasurement.REMaximumMeasurementQuantity AS REMaximumMeasurementQuantity,
  _REMeasurement._REMeasurementType AS _REMeasurementType,
  _REMeasurement._UnitOfMeasure AS _UnitOfMeasure
FROM I_REMeasurement AS _REMeasurement
INNER JOIN I_RERentableObject AS _RERentableObjectData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_REEntryValidity AS _REEntryValidity ON REEntryValidity = _REEntryValidity.REEntryValidity  -- association [1..1]
;

Learn More