C_REUseEnableTP

DDL: C_REUSEENABLETP Type: view_entity CONSUMPTION
44 Fields 1 Data Sources 2 Associations

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.

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

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..*]
;

Learn More