P_REOCCUPANCYBASECUBE
Real Estate Occupancy Base - Cube
P_REOCCUPANCYBASECUBE is a CDS View in S/4HANA. Real Estate Occupancy Base - Cube. It contains 34 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_REOccupancyCube | view | from | COMPOSITE | Real Estate Occupancy - Cube |
Fields (34)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | REIntegObjectInternalNumber | REIntegObjectInternalNumber | 1 |
| KEY | REInternalNumberForOccupancy | REInternalNumberForOccupancy | 1 |
| KEY | REInternalNumberForUseEnable | REInternalNumberForUseEnable | 1 |
| KEY | REMeasurementType | REMeasurementType | 1 |
| KEY | ValidityEndDate | ValidityEndDate | 1 |
| _REIntegObjectTimeline | _REIntegObjectTimeline | 1 | |
| _REIntegrationObject | _REIntegrationObject | 1 | |
| _REMeasurementType | _REMeasurementType | 1 | |
| Country | Country | 1 | |
| RealEstateExternalIDBldng | RealEstateExternalIDBldng | 1 | |
| RealEstateExternalIDFloor | RealEstateExternalIDFloor | 1 | |
| RealEstateExternalIDForOccpcy | RealEstateExternalIDForOccpcy | 1 | |
| RealEstateExternalIDLand | RealEstateExternalIDLand | 1 | |
| RealEstateExternalIDSite | RealEstateExternalIDSite | 1 | |
| REAuthorizationGroup | REAuthorizationGroup | 1 | |
| Region | Region | 1 | |
| REIntegObjectLongName | REIntegObjectLongName | 1 | |
| REIntegObjectUsageClfn | REIntegObjectUsageClfn | 1 | |
| REIntegObjectUsageType | REIntegObjectUsageType | 1 | |
| REIntegrationObjectIsActive | REIntegrationObjectIsActive | 1 | |
| REIntegrationObjectIsGrouped | REIntegrationObjectIsGrouped | 1 | |
| REIntegrationObjectName | REIntegrationObjectName | 1 | |
| REIntegrationObjectNumberBldng | REIntegrationObjectNumberBldng | 1 | |
| REIntegrationObjectNumberFloor | REIntegrationObjectNumberFloor | 1 | |
| REIntegrationObjectNumberLand | REIntegrationObjectNumberLand | 1 | |
| REIntegrationObjectNumberSite | REIntegrationObjectNumberSite | 1 | |
| REIntegrationObjectType | REIntegrationObjectType | 1 | |
| REInternalNumberForBuilding | REInternalNumberForBuilding | 1 | |
| REInternalNumberForFloor | REInternalNumberForFloor | 1 | |
| REInternalNumberForLand | REInternalNumberForLand | 1 | |
| REInternalNumberForSite | REInternalNumberForSite | 1 | |
| REMeasurementUnit | REMeasurementUnit | 1 | |
| RESpaceGrpEnableUseType | RESpaceGrpEnableUseType | 1 | |
| ValidityStartDate | ValidityStartDate | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Real Estate Occupancy Base - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_REOCCUPANCYBASECUBE (
REINTEGOBJECTINTERNALNUMBER,
REINTERNALNUMBERFOROCCUPANCY,
REINTERNALNUMBERFORUSEENABLE,
REMEASUREMENTTYPE,
VALIDITYENDDATE,
_REINTEGOBJECTTIMELINE,
_REINTEGRATIONOBJECT,
_REMEASUREMENTTYPE,
COUNTRY,
REALESTATEEXTERNALIDBLDNG,
REALESTATEEXTERNALIDFLOOR,
REALESTATEEXTERNALIDFOROCCPCY,
REALESTATEEXTERNALIDLAND,
REALESTATEEXTERNALIDSITE,
REAUTHORIZATIONGROUP,
REGION,
REINTEGOBJECTLONGNAME,
REINTEGOBJECTUSAGECLFN,
REINTEGOBJECTUSAGETYPE,
REINTEGRATIONOBJECTISACTIVE,
REINTEGRATIONOBJECTISGROUPED,
REINTEGRATIONOBJECTNAME,
REINTEGRATIONOBJECTNUMBERBLDNG,
REINTEGRATIONOBJECTNUMBERFLOOR,
REINTEGRATIONOBJECTNUMBERLAND,
REINTEGRATIONOBJECTNUMBERSITE,
REINTEGRATIONOBJECTTYPE,
REINTERNALNUMBERFORBUILDING,
REINTERNALNUMBERFORFLOOR,
REINTERNALNUMBERFORLAND,
REINTERNALNUMBERFORSITE,
REMEASUREMENTUNIT,
RESPACEGRPENABLEUSETYPE,
VALIDITYSTARTDATE,
PRIMARY KEY (REINTEGOBJECTINTERNALNUMBER, REINTERNALNUMBERFOROCCUPANCY, REINTERNALNUMBERFORUSEENABLE, REMEASUREMENTTYPE, VALIDITYENDDATE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA