I_REOccupancyCube

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 I_REOccupancyCube.
-- 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.
-- SQL view name: IREOCCPCYCUBE

CREATE VIEW I_REOccupancyCube AS
SELECT
  _REIntegObjectOccCubeBase.REIntegObjectInternalNumber AS REIntegObjectInternalNumber,
  _REIntegObjectOccCubeBase.REInternalNumberForOccupancy AS REInternalNumberForOccupancy,
  _REIntegObjectOccCubeBase.REInternalNumberForUseEnable AS REInternalNumberForUseEnable,
  _REIntegObjectOccCubeBase.REMeasurementType AS REMeasurementType,
  _REIntegObjectOccCubeBase.ValidityEndDate AS ValidityEndDate,
  _REIntegObjectOccCubeBase.ValidityStartDate AS ValidityStartDate,
  cast( concat(_REIntegObjectOccCubeBase.ValidityStartDate, _REIntegObjectOccCubeBase.ValidityEndDate ) as recadateperiod preserving type ) AS ValidityStartEndDateValue,
  cast( CompanyCode as bukrs preserving type ) AS CompanyCode,
  cast( _REIntegObjectOccCubeBase.REIntegrationObjectNumber as reipvdmionrspace preserving type ) AS REIntegrationObjectNumber,
  cast( _REIntegObjectOccCubeBase.RealEstateExternalID as reipvdmextidspace preserving type ) AS RealEstateExternalID,
  _REIntegObjectOccCubeBase.REIntegrationObjectName AS REIntegrationObjectName,
  _REIntegObjectOccCubeBase.REIntegObjectLongName AS REIntegObjectLongName,
  _REIntegObjectSpaceGroup.REIntegrationObjectName AS REIntegrationObjectOccpcyName,
  _REIntegObjectOccCubeBase.REInternalNumberForSite AS REInternalNumberForSite,
  _REIntegObjectOccCubeBase.REInternalNumberForBuilding AS REInternalNumberForBuilding,
  _REIntegObjectOccCubeBase.REInternalNumberForLand AS REInternalNumberForLand,
  _REIntegObjectOccCubeBase.REInternalNumberForFloor AS REInternalNumberForFloor,
  _REIntegObjectOccCubeBase.RealEstateExternalIDForOccpcy AS RealEstateExternalIDForOccpcy,
  _REIntegObjectOccCubeBase.RealEstateExternalIDSite AS RealEstateExternalIDSite,
  _REIntegObjectOccCubeBase.RealEstateExternalIDBldng AS RealEstateExternalIDBldng,
  _REIntegObjectOccCubeBase.RealEstateExternalIDLand AS RealEstateExternalIDLand,
  _REIntegObjectOccCubeBase.RealEstateExternalIDFloor AS RealEstateExternalIDFloor,
  _REIntegObjectOccCubeBase.REIntegrationObjectNumberSite AS REIntegrationObjectNumberSite,
  _REIntegObjectOccCubeBase.REIntegrationObjectNumberBldng AS REIntegrationObjectNumberBldng,
  _REIntegObjectOccCubeBase.REIntegrationObjectNumberLand AS REIntegrationObjectNumberLand,
  _REIntegObjectOccCubeBase.REIntegrationObjectNumberFloor AS REIntegrationObjectNumberFloor,
  _REIntegObjectOccCubeBase.Country AS Country,
  _REIntegObjectOccCubeBase.Region AS Region,
  _REIntegObjectOccCubeBase.REAuthorizationGroup AS REAuthorizationGroup,
  _REIntegObjectOccCubeBase.REIntegrationObjectType AS REIntegrationObjectType,
  _REIntegObjectOccCubeBase.REIntegObjectUsageClfn AS REIntegObjectUsageClfn,
  _REIntegObjectOccCubeBase.REIntegObjectUsageType AS REIntegObjectUsageType,
  _REIntegObjectOccCubeBase.REMeasurementUnit AS REMeasurementUnit,
  _REIntegObjectOccCubeBase.RESpaceGrpEnableUseType AS RESpaceGrpEnableUseType,
  _REIntegObjectSpaceGroup.REIntegObjSpaceGroupType AS REIntegObjSpaceGroupType,
  _REIntegObjectSpaceGroup.RESpaceGroupUsageType AS RESpaceGroupUsageType,
  _REIntegObjectOccCubeBase.REIntegrationObjectIsActive AS REIntegrationObjectIsActive,
  _REIntegObjectOccCubeBase.REIntegrationObjectIsGrouped AS REIntegrationObjectIsGrouped,
  _REOccupancy.RealEstateContract AS RealEstateContract,
  _REOccupancy.REContractIsActive AS REContractIsActive,
  _REIntegrationObjectRelation.REIsObjectRelationPartial AS REIsObjectRelationPartial,
  sum( _REIntegObjectOccCubeBase.REMeasurementQuantity ) AS REMeasurementTotalQuantity,
  sum( _REIntegObjectOccCubeBase.RENumberOfObjects ) AS RENumberOfObjects,
  _REIntegObjectOccCubeBase._REIntegObjectTimeline AS _REIntegObjectTimeline,
  _REIntegObjectOccCubeBase._REIntegrationObject AS _REIntegrationObject,
  _REIntegObjectOccCubeBase._REMeasurementType AS _REMeasurementType
FROM P_REOccupancyBaseCube AS _REIntegObjectOccCubeBase
LEFT OUTER JOIN I_REIntegObjectOccupancy AS _REOccupancy ON REInternalNumberForOccupancy = _REOccupancy.REIntegObjectInternalNumber AND ( ValidityStartDate <= _REOccupancy.REOccupancyToDate AND ValidityEndDate >= _REOccupancy.REOccupancyFromDate ) AND _REOccupancy.REIntegObjectInternalNumber <> '' AND CompanyCode = _REOccupancy.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObject AS _REIntegObjectSpaceGroup ON REInternalNumberForOccupancy = _REIntegObjectSpaceGroup.InternalRealEstateNumber AND ( _REIntegObjectSpaceGroup.REIntegObjSpaceGroupType = 'IO01' OR _REIntegObjectSpaceGroup.REIntegObjSpaceGroupType = 'EO01' OR _REIntegObjectSpaceGroup.REIntegObjSpaceGroupType = 'IC01' )  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObjectRelation AS _REIntegrationObjectRelation ON REInternalNumberForOccupancy = _REIntegrationObjectRelation.InternalRealEstateNumber AND REIntegObjectInternalNumber = _REIntegrationObjectRelation.InternalRealEstateNumberRltn AND REMeasurementType = _REIntegrationObjectRelation.REMeasurementType AND ValidityStartDate <= _REIntegrationObjectRelation.ValidityEndDate AND ValidityEndDate >= _REIntegrationObjectRelation.ValidityStartDate  -- association [0..1]
;