What is C_REOccupancyCubeDEX in SAP S/4HANA?

C_REOccupancyCubeDEX is a consumption CDS view in SAP S/4HANA. Real Estate Occupancy for Data Extraction It contains 40 fields.

Which tables does C_REOccupancyCubeDEX read from?

C_REOccupancyCubeDEX reads data from: I_REOccupancyCube.

What VDM layer is C_REOccupancyCubeDEX?

C_REOccupancyCubeDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_REOccupancyCubeDEX

DDL: C_REOCCUPANCYCUBEDEX Type: view_entity CONSUMPTION Package: VDM_RE_IP

40 Fields 1 Data Sources

Real Estate Occupancy for Data Extraction

C_REOccupancyCubeDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_REOccupancyCubeDEX is a Consumption CDS View (Cube) that provides data about "Real Estate Occupancy for Data Extraction" in SAP S/4HANA. It reads from 1 data source (I_REOccupancyCube) and exposes 40 fields with key fields REIntegObjectInternalNumber, REInternalNumberForOccupancy, REInternalNumberForUseEnable, REMeasurementType, ValidityEndDate. Part of development package VDM_RE_IP.

SAP API Hub

Category	Consumption
State	C1
Line of Business	Cross Applications
Application Component	RE-FX-IP-2CL
Capabilities	Data Source for Data Extraction,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Cross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_REOccupancyCube	I_REOccupancyCube	from

Annotations (11)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Real Estate Occupancy for Data Extraction	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view

Fields (40)

Key	Field	Source Field	Description
KEY	REIntegObjectInternalNumber	REIntegObjectInternalNumber	Internal Key of Real Estate Object
KEY	REInternalNumberForOccupancy
KEY	REInternalNumberForUseEnable
KEY	REMeasurementType	REMeasurementType	Measurement Type
KEY	ValidityEndDate	ValidityEndDate	ValidTo
	ValidityStartDate	ValidityStartDate	Validity Start Date
	ValidityStartEndDateValue	ValidityStartEndDateValue	Date from to (RAP Key)
	CompanyCode	CompanyCode	Receiver Company Code
	REIntegrationObjectNumber	REIntegrationObjectNumber	Integration Object Number of Space
	RealEstateExternalID	RealEstateExternalID	Integration Object Space - External Identification
	REIntegrationObjectName	REIntegrationObjectName	Object Name (Short)
	REIntegObjectLongName	REIntegObjectLongName	Object Name (Long)
	REIntegrationObjectOccpcyName	REIntegrationObjectOccpcyName	Object Name (Short)
	REInternalNumberForSite	REInternalNumberForSite	Internal Key of Real Estate Object
	REInternalNumberForBuilding	REInternalNumberForBuilding	Internal Key of Real Estate Object
	REInternalNumberForLand	REInternalNumberForLand	Internal Key of Real Estate Object
	REInternalNumberForFloor	REInternalNumberForFloor	Internal Key of Real Estate Object
	RealEstateExternalIDSite	RealEstateExternalIDSite	Integration Object Site - External Identification
	RealEstateExternalIDBldng	RealEstateExternalIDBldng	Integration Object Building - External Identification
	RealEstateExternalIDLand	RealEstateExternalIDLand	Integration Object Site - External Identification
	RealEstateExternalIDFloor	RealEstateExternalIDFloor	Integration Object Floor - External Identification
	REIntegrationObjectNumberSite	REIntegrationObjectNumberSite	Integration Object Number of Site
	REIntegrationObjectNumberBldng	REIntegrationObjectNumberBldng	Integration Object Number of Building
	REIntegrationObjectNumberLand	REIntegrationObjectNumberLand	Integration Object Number of Land
	REIntegrationObjectNumberFloor	REIntegrationObjectNumberFloor	Integration Object Number of Floor
	Country	Country	Country/Region Key
	Region	Region	Region (State, Province, County)
	REAuthorizationGroup	REAuthorizationGroup	Authorization Group
	REIntegrationObjectType	REIntegrationObjectType	Object Type
	REIntegObjectUsageClfn	REIntegObjectUsageClfn	Usage Classification
	REIntegObjectUsageType	REIntegObjectUsageType	Object Usage Type
	RESpaceGrpEnableUseType	RESpaceGrpEnableUseType	Usage Enablement Type
	REIntegObjSpaceGroupType	REIntegObjSpaceGroupType	Group Type
	RESpaceGroupUsageType	RESpaceGroupUsageType	Group Usage Type
	REIntegrationObjectIsGrouped	REIntegrationObjectIsGrouped	Integration Object: Is Grouped
	RealEstateContract	RealEstateContract	Real Estate Contract Number
	REIntegrationObjectIsOccupied	REIntegrationObjectIsOccupied	Integration Object: Is Active
	REContractIsActive	REContractIsActive	Truth Value: True/False
	REMeasurementUnit	REMeasurementUnit	Unit of Measure
	REMeasurementQuantity	REMeasurementQuantity

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_REOccupancyCubeDEX.
-- 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_REOccupancyCubeDEX AS
SELECT
  REIntegObjectInternalNumber,
  coalesce(REInternalNumberForOccupancy,'') AS REInternalNumberForOccupancy,
  coalesce(REInternalNumberForUseEnable,'') AS REInternalNumberForUseEnable,
  REMeasurementType,
  ValidityEndDate,
  ValidityStartDate,
  ValidityStartEndDateValue,
  CompanyCode,
  REIntegrationObjectNumber,
  RealEstateExternalID,
  REIntegrationObjectName,
  REIntegObjectLongName,
  REIntegrationObjectOccpcyName,
  REInternalNumberForSite,
  REInternalNumberForBuilding,
  REInternalNumberForLand,
  REInternalNumberForFloor,
  RealEstateExternalIDSite,
  RealEstateExternalIDBldng,
  RealEstateExternalIDLand,
  RealEstateExternalIDFloor,
  REIntegrationObjectNumberSite,
  REIntegrationObjectNumberBldng,
  REIntegrationObjectNumberLand,
  REIntegrationObjectNumberFloor,
  Country,
  Region,
  REAuthorizationGroup,
  REIntegrationObjectType,
  REIntegObjectUsageClfn,
  REIntegObjectUsageType,
  RESpaceGrpEnableUseType,
  REIntegObjSpaceGroupType,
  RESpaceGroupUsageType,
  REIntegrationObjectIsGrouped,
  RealEstateContract,
  REIntegrationObjectIsOccupied,
  REContractIsActive,
  REMeasurementUnit,
  REMeasurementQuantity
FROM I_REOccupancyCube
;

Depth:

C_REOccupancyCubeDEX view_entity

I_REOccupancyCube view