C_REUseEnableObjRelationTP

DDL: C_REUSEENABLEOBJRELATIONTP Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 2 Associations

Real Estate Use Enable Relations

C_REUseEnableObjRelationTP is a Consumption CDS View that provides data about "Real Estate Use Enable Relations" in SAP S/4HANA. It reads from 1 data source (R_REIntegObjectObjRelationTP) and exposes 17 fields with key fields REIntegObjectRelationUUID, InternalRealEstateNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_REIntegObjectObjRelationTP R_REIntegObjectObjRelationTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_REUseEnableObjRltnMsmt_2 _REUseEnableObjRelMsmt $projection.InternalRealEstateNumberRltn = _REUseEnableObjRelMsmt.InternalRealEstateNumber and _REUseEnableObjRelMsmt.ValidityStartDate = $projection.ValidityEndDate and _REUseEnableObjRelMsmt.ValidityEndDate = $projection.ValidityStartDate
[0..*] C_REObjectAssgmtMsmtChart_2 _REObjectAssgmtMsmtChart $projection.InternalRealEstateNumberRltn = _REObjectAssgmtMsmtChart.InternalRealEstateNumber and _REObjectAssgmtMsmtChart.ValidityStartDate = $projection.ValidityEndDate and _REObjectAssgmtMsmtChart.ValidityEndDate = $projection.ValidityStartDate

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Real Estate Use Enable Relations view
Metadata.allowExtensions true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY REIntegObjectRelationUUID REIntegObjectRelationUUID
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
InternalRealEstateNumberRltn InternalRealEstateNumberRltn
ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
REStatusObject REStatusObject Val. Obj. No.
REParentIntegrationObjectName Parent Object
REIntegrationObjectNumber REIntegrationObjectNumber Object Number
RealEstateExternalID _RERelatedIntegrationObject RealEstateExternalID Object
REIntegrationObjectType REIntegrationObjectType
REParentIntegObjectExternalID _REIntegrationObjectTP REParentIntegObjectExternalID
REEntryValidity REEntryValidity Entry Validity
REIntegrationObjectName _RERelatedIntegrationObject REIntegrationObjectName
REIntegObjectLongName _RERelatedIntegrationObject REIntegObjectLongName
REEntryValidityCriticality REEntryValidityCriticality
_REUseEnableObjRelMsmt _REUseEnableObjRelMsmt
_REObjectAssgmtMsmtChart _REObjectAssgmtMsmtChart

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 C_REUseEnableObjRelationTP.
-- 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 C_REUseEnableObjRelationTP AS
SELECT
  REIntegObjectRelationUUID,
  InternalRealEstateNumber,
  InternalRealEstateNumberRltn,
  ValidityEndDate,
  ValidityStartDate,
  REStatusObject,
  _RERelatedIntegrationObject._REParentIntegrationObject.REIntegrationObjectName AS REParentIntegrationObjectName,
  REIntegrationObjectNumber,
  _RERelatedIntegrationObject.RealEstateExternalID AS RealEstateExternalID,
  REIntegrationObjectType,
  _REIntegrationObjectTP.REParentIntegObjectExternalID AS REParentIntegObjectExternalID,
  REEntryValidity,
  _RERelatedIntegrationObject.REIntegrationObjectName AS REIntegrationObjectName,
  _RERelatedIntegrationObject.REIntegObjectLongName AS REIntegObjectLongName,
  REEntryValidityCriticality
FROM R_REIntegObjectObjRelationTP
LEFT OUTER JOIN C_REUseEnableObjRltnMsmt_2 AS _REUseEnableObjRelMsmt ON InternalRealEstateNumberRltn = _REUseEnableObjRelMsmt.InternalRealEstateNumber AND _REUseEnableObjRelMsmt.ValidityStartDate = ValidityEndDate AND _REUseEnableObjRelMsmt.ValidityEndDate = ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN C_REObjectAssgmtMsmtChart_2 AS _REObjectAssgmtMsmtChart ON InternalRealEstateNumberRltn = _REObjectAssgmtMsmtChart.InternalRealEstateNumber AND _REObjectAssgmtMsmtChart.ValidityStartDate = ValidityEndDate AND _REObjectAssgmtMsmtChart.ValidityEndDate = ValidityStartDate  -- association [0..*]
;

Learn More