C_REUseEnableObjRelationTP

DDL: C_REUSEENABLEOBJRELATIONTP Type: view_entity CONSUMPTION Package: ODATA_RE_IP_ENABLE_USE_APP
17 Fields 1 Data Sources 2 Associations 1 OData Services 1 Fiori Apps

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. It is exposed through 1 OData service (UI_REUSAGEENABLE). It is used in 1 Fiori application: Manage Usage Enablement Groups. Part of development package ODATA_RE_IP_ENABLE_USE_APP.

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_REUSAGEENABLE UI_REUSAGEENABLE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5465 Manage Usage Enablement Groups Transactional The "Manage Usage Enablement Groups" App allows Customers to manage and maintain the Enable Use Groups.

Manage Usage Enablement Groups

Business Role: Real Estate Specialist - Location Management

To support lease-in scenarios, location management must be enabled for use before real estate objects can be assigned to a lease-in contract. Real estate object here, refer to buildings, lands or groups of spaces created within SAP Cloud for Real Estate. When a real estate object is enabled for use, it (single or grouped objects) is synchronized with SAP S/4HANA, and is simultaneously assigned to a company code, a cost object, and usage type. You can optionally assign other attributes (such as fixed assets assigned to the location) to the enabled group. Once enabled for use, objects are available for assignment to a lease-in contract.

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