C_REOccupancyManageTP

DDL: C_REOCCUPANCYMANAGETP Type: view_entity CONSUMPTION
45 Fields 1 Data Sources 2 Associations

Real Estate Occupancy Manage

C_REOccupancyManageTP is a Consumption CDS View that provides data about "Real Estate Occupancy Manage" in SAP S/4HANA. It reads from 1 data source (R_REIntegrationObjectTP) and exposes 45 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 Occupancy Manage view
Metadata.allowExtensions true view
Search.searchable true view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
REStatusObject REStatusObject Val. Obj. No.
REIntegrationObjectNumber REIntegrationObjectNumber Occupancy Group
REIntegrationObjNumberForEdit REIntegrationObjNumberForEdit Occupancy Group
REIntegrationObjectType REIntegrationObjectType
REIntegrationObjectName REIntegrationObjectName
REIntegObjectLongName REIntegObjectLongName
RESpaceGroupUsageType RESpaceGroupUsageType
REIntegObjSpaceGroupType REIntegObjSpaceGroupType
REIntegObjectCategory _REIntegObjSpaceGroupType REIntegObjectCategory
REUseEnableObjectNumber REUseEnableObjectNumber Usage Enablement Group
REUseEnableObjectName _REUseEnableIntegrationObject REIntegrationObjectName
REInternalNumberForUseEnable REInternalNumberForUseEnable
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CompanyCode CompanyCodeEnableUse
CompanyCodeEnableUse CompanyCode Receiver Company Code
CompanyCodeName _CompanyCodeEnableUse CompanyCodeName Company Name
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
REIntegrationObjectNumberSite Site Number
REIntegObjectSiteName
REParentIntegObjectNumber REParentIntegObjectNumber Building/Land Number
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
REResponsibleUserDescription _ResponsibleUser UserDescription Full Name
REParentIntegrationObjectName _REParentIntegrationObject REIntegrationObjectName
virtualIsInitialVersionrecabool
virtualREStatusProfileIsHiddenrecabool
virtualSystemStatusTextreipvdmiostatus
_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_REOccupancyManageTP.
-- 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_REOccupancyManageTP AS
SELECT
  InternalRealEstateNumber,
  REStatusObject,
  REIntegrationObjectNumber,
  REIntegrationObjNumberForEdit,
  REIntegrationObjectType,
  REIntegrationObjectName,
  REIntegObjectLongName,
  RESpaceGroupUsageType,
  REIntegObjSpaceGroupType,
  _REIntegObjSpaceGroupType.REIntegObjectCategory AS REIntegObjectCategory,
  REUseEnableObjectNumber,
  _REUseEnableIntegrationObject.REIntegrationObjectName AS REUseEnableObjectName,
  REInternalNumberForUseEnable,
  ValidityStartDate,
  ValidityEndDate,
  CompanyCodeEnableUse AS CompanyCode,
  CompanyCode AS CompanyCodeEnableUse,
  _CompanyCodeEnableUse.CompanyCodeName AS CompanyCodeName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  RESourceOfChange,
  Responsible,
  REAuthorizationGroup,
  _REParentIntegrationObject._REParentIntegrationObject.REIntegrationObjectNumber AS REIntegrationObjectNumberSite,
  _REParentIntegrationObject._REParentIntegrationObject.REIntegrationObjectName AS REIntegObjectSiteName,
  REParentIntegObjectNumber,
  REParentIntegObjectExternalID,
  _REParentIntegrationObject.REIntegObjectLongName AS REParentIntegObjectLongName,
  _REParentIntegrationObject.ValidityStartDate AS REParentValidityStartDate,
  _REParentIntegrationObject.ValidityEndDate AS REParentValidityEndDate,
  StatusProfile,
  _ResponsibleUser.UserDescription AS REResponsibleUserDescription,
  _REParentIntegrationObject.REIntegrationObjectName AS REParentIntegrationObjectName,
  virtual IsInitialVersion : recabool AS virtualIsInitialVersionrecabool,
  virtual REStatusProfileIsHidden : recabool AS virtualREStatusProfileIsHiddenrecabool,
  virtual SystemStatusText : reipvdmiostatus AS virtualSystemStatusTextreipvdmiostatus
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