C_REUseEnableTP

DDL: C_REUSEENABLETP Type: view_entity CONSUMPTION Package: ODATA_RE_IP_ENABLE_USE_APP

Real Estate IO Use Enablement

C_REUseEnableTP is a Consumption CDS View that provides data about "Real Estate IO Use Enablement" in SAP S/4HANA. It reads from 1 data source (R_REIntegrationObjectTP) and exposes 44 fields with key field 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_REIntegrationObjectTP R_REIntegrationObjectTP projection

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_REIntegObjectMsmtChart_2 _REIntegObjectMsmtChart $projection.InternalRealEstateNumber = _REIntegObjectMsmtChart.InternalRealEstateNumber
[1..*] C_REIntegObjectMeasurement _REIntegObjectMeasurement $projection.InternalRealEstateNumber = _REIntegObjectMeasurement.InternalRealEstateNumber

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey InternalRealEstateNumber view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
EndUserText.label Real Estate IO Use Enablement view
Metadata.allowExtensions true view
Search.searchable 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 (44)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
REStatusObject REStatusObject Val. Obj. No.
REIntegrationObjectNumber REIntegrationObjectNumber Usage Enablement Group
REIntegrationObjNumberForEdit REIntegrationObjNumberForEdit Usage Enablement Group
REIntegrationObjectType REIntegrationObjectType Integration Object Type
REIntegObjectCtrlgObjectType REIntegObjectCtrlgObjectType
REIntegrationObjectName REIntegrationObjectName
REIntegObjectLongName REIntegObjectLongName
RESpaceGroupUsageType RESpaceGroupUsageType
RESpaceGrpEnableUseType RESpaceGrpEnableUseType
REIntegObjSpaceGroupType REIntegObjSpaceGroupType
ValidityStartDate ValidityStartDate Validity Start Date
CompanyCode CompanyCode Receiver Company Code
CompanyCodeEnableUse CompanyCodeEnableUse
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ValidityEndDate ValidityEndDate ValidTo
REIntegrationObjectNumberSite Site Number
REIntegObjectSiteName
REParentIntegObjectNumber REParentIntegObjectNumber Building/Land Number
REInternalNumberForUseEnable REInternalNumberForUseEnable
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDateTime LastChangeDateTime Timestamp
RESourceOfChange RESourceOfChange Editing Source
Responsible Responsible User Name
REAuthorizationGroup REAuthorizationGroup Authoriz. Group
REParentIntegObjectExternalID REParentIntegObjectExternalID Building/Land Short Name
REParentIntegObjectLongName _REParentIntegrationObject REIntegObjectLongName Building/Land Long Name
REParentValidityStartDate _REParentIntegrationObject ValidityStartDate Building/Land Validity Start Date
REParentValidityEndDate _REParentIntegrationObject ValidityEndDate Building/Land Validity End Date
StatusProfile StatusProfile Status Profile
virtualIsInitialVersionrecabool
virtualREStatusProfileIsHiddenrecabool
virtualSystemStatusTextreipvdmiostatus
REParentIntegrationObjectName _REParentIntegrationObject REIntegrationObjectName
REResponsibleUserDescription _ResponsibleUser UserDescription Full Name
_REIntegObjectMsmtChart _REIntegObjectMsmtChart
_REIntegObjectMeasurement _REIntegObjectMeasurement
_REUseEnableIntegrationObject _REUseEnableIntegrationObject

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_REUseEnableTP.
-- 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_REUseEnableTP AS
SELECT
  InternalRealEstateNumber,
  REStatusObject,
  REIntegrationObjectNumber,
  REIntegrationObjNumberForEdit,
  REIntegrationObjectType,
  REIntegObjectCtrlgObjectType,
  REIntegrationObjectName,
  REIntegObjectLongName,
  RESpaceGroupUsageType,
  RESpaceGrpEnableUseType,
  REIntegObjSpaceGroupType,
  ValidityStartDate,
  CompanyCode,
  CompanyCodeEnableUse,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ValidityEndDate,
  _REParentIntegrationObject._REParentIntegrationObject.REIntegrationObjectNumber AS REIntegrationObjectNumberSite,
  _REParentIntegrationObject._REParentIntegrationObject.REIntegrationObjectName AS REIntegObjectSiteName,
  REParentIntegObjectNumber,
  REInternalNumberForUseEnable,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  RESourceOfChange,
  Responsible,
  REAuthorizationGroup,
  REParentIntegObjectExternalID,
  _REParentIntegrationObject.REIntegObjectLongName AS REParentIntegObjectLongName,
  _REParentIntegrationObject.ValidityStartDate AS REParentValidityStartDate,
  _REParentIntegrationObject.ValidityEndDate AS REParentValidityEndDate,
  StatusProfile,
  virtual IsInitialVersion : recabool AS virtualIsInitialVersionrecabool,
  virtual REStatusProfileIsHidden : recabool AS virtualREStatusProfileIsHiddenrecabool,
  virtual SystemStatusText : reipvdmiostatus AS virtualSystemStatusTextreipvdmiostatus,
  _REParentIntegrationObject.REIntegrationObjectName AS REParentIntegrationObjectName,
  _ResponsibleUser.UserDescription AS REResponsibleUserDescription
FROM R_REIntegrationObjectTP
LEFT OUTER JOIN C_REIntegObjectMsmtChart_2 AS _REIntegObjectMsmtChart ON InternalRealEstateNumber = _REIntegObjectMsmtChart.InternalRealEstateNumber  -- association [1..*]
LEFT OUTER JOIN C_REIntegObjectMeasurement AS _REIntegObjectMeasurement ON InternalRealEstateNumber = _REIntegObjectMeasurement.InternalRealEstateNumber  -- association [1..*]
;