P_REOCCUPANCYBASECUBE

CDS View

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)

ViewTypeJoinVDMDescription
I_REOccupancyCube view from COMPOSITE Real Estate Occupancy - Cube

Fields (34)

KeyField CDS FieldsUsed 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)
);