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 P_REOccupancyBaseCube.
-- 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 P_REOccupancyBaseCube AS
SELECT
coalesce(_REUseEnableIntegrationObject.CompanyCode,'') AS CompanyCode,
_REIntegObjOccpcyHierCalc.InternalRealEstateNumber AS REIntegObjectInternalNumber,
_REIntegObjOccpcyHierCalc.REMeasurementType AS REMeasurementType,
_REIntegObjOccpcyHierCalc.ValidityEndDate AS ValidityEndDate,
_REIntegObjOccpcyHierCalc.ValidityStartDate AS ValidityStartDate,
_REIntegrationObject.REIntegrationObjectNumber AS REIntegrationObjectNumber,
_REIntegrationObject.RealEstateExternalID AS RealEstateExternalID,
_REIntegrationObject.REIntegrationObjectName AS REIntegrationObjectName,
_REIntegrationObject.REIntegObjectLongName AS REIntegObjectLongName,
_REIntegObjectObj2SpaceGrp.InternalRealEstateNumberLvl0 AS REInternalNumberForUseEnable,
coalesce( _REIntegObjectOccupancy.InternalRealEstateNumberLvl0,'' ) AS REInternalNumberForOccupancy,
_REIntegObjectHierarchyMap._REIntegrationObjectSite.InternalRealEstateNumber AS REInternalNumberForSite,
_REIntegObjectHierarchyMap._REIntegrationObjectBuilding.InternalRealEstateNumber AS REInternalNumberForBuilding,
_REIntegObjectHierarchyMap._REIntegrationObjectLand.InternalRealEstateNumber AS REInternalNumberForLand,
_REIntegObjectHierarchyMap._REIntegrationObjectFloor.InternalRealEstateNumber AS REInternalNumberForFloor,
cast( _REIntegObjectObj2SpaceGrp.RealEstateExternalIDLvl0 as reipvdmextidoccpcy preserving type ) AS RealEstateExternalIDForOccpcy,
cast( _REIntegObjectHierarchyMap._REIntegrationObjectSite.RealEstateExternalID as reipvdmextidsite preserving type ) AS RealEstateExternalIDSite,
cast( _REIntegObjectHierarchyMap._REIntegrationObjectBuilding.RealEstateExternalID as reipvdmextidbuilding preserving type ) AS RealEstateExternalIDBldng,
cast( _REIntegObjectHierarchyMap._REIntegrationObjectLand.RealEstateExternalID as reipvdmextidland preserving type ) AS RealEstateExternalIDLand,
cast( _REIntegObjectHierarchyMap._REIntegrationObjectFloor.RealEstateExternalID as reipvdmextidfloor preserving type ) AS RealEstateExternalIDFloor,
cast( _REIntegObjectHierarchyMap._REIntegrationObjectSite.REIntegrationObjectNumber as reipvdmionrsite preserving type ) AS REIntegrationObjectNumberSite,
cast( _REIntegObjectHierarchyMap._REIntegrationObjectBuilding.REIntegrationObjectNumber as reipvdmionrbuilding preserving type ) AS REIntegrationObjectNumberBldng,
cast( _REIntegObjectHierarchyMap._REIntegrationObjectLand.REIntegrationObjectNumber as reipvdmionrland preserving type ) AS REIntegrationObjectNumberLand,
cast( _REIntegObjectHierarchyMap._REIntegrationObjectFloor.REIntegrationObjectNumber as reipvdmionrfloor preserving type ) AS REIntegrationObjectNumberFloor,
_REIntegObjectHierarchyMap._REIntegrationObjectSite._REObjectAddress._Address.Country AS Country,
_REIntegObjectHierarchyMap._REIntegrationObjectSite._REObjectAddress._Address.Region AS Region,
_REIntegrationObject.REAuthorizationGroup AS REAuthorizationGroup,
_REIntegrationObject.REIntegrationObjectType AS REIntegrationObjectType,
_REIntegObjectTimeline.REIntegObjectUsageClfn AS REIntegObjectUsageClfn,
_REIntegObjectTimeline.REIntegObjectUsageType AS REIntegObjectUsageType,
_REIntegObjOccpcyHierCalc.REMeasurementUnit AS REMeasurementUnit,
_REUseEnableIntegrationObject.REIntegObjSpaceGroupType AS REIntegObjSpaceGroupType,
_REUseEnableIntegrationObject.RESpaceGrpEnableUseType AS RESpaceGrpEnableUseType,
_REIntegObjectTimeline.REIntegrationObjectIsActive AS REIntegrationObjectIsActive,
_REIntegObjOccpcyHierCalc.REMeasurementQuantity AS REMeasurementQuantity,
cast( 1 as reipvdmnumberofobjects ) AS RENumberOfObjects
FROM P_REIntegObjOccpcyHierCalc4 AS _REIntegObjOccpcyHierCalc
INNER JOIN I_REChartColorAssignment AS _ChartColor ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_REIntegrationObject AS _REUseEnableIntegrationObject ON REInternalNumberForUseEnable = _REUseEnableIntegrationObject.InternalRealEstateNumber -- association [0..1]
LEFT OUTER JOIN I_REIntegrationObject AS _REIntegrationObject ON REIntegObjectInternalNumber = _REIntegrationObject.InternalRealEstateNumber -- association [1..1]
LEFT OUTER JOIN I_REIntegObjectObject2SpaceGrp AS _REIntegObjectOccupancy ON ( REIntegObjectInternalNumber = _REIntegObjectOccupancy.InternalRealEstateNumberLvl3 OR REIntegObjectInternalNumber = _REIntegObjectOccupancy.InternalRealEstateNumberLvl2 ) AND ( _REIntegObjectOccupancy.REIntegObjSpaceGroupType = 'EO01' OR _REIntegObjectOccupancy.REIntegObjSpaceGroupType = 'IO01' OR _REIntegObjectOccupancy.REIntegObjSpaceGroupType = 'IC01' ) AND ( ValidityStartDate <= _REIntegObjectOccupancy.ValidityEndDate AND ValidityEndDate >= _REIntegObjectOccupancy.ValidityStartDate ) AND _REIntegObjectOccupancy.REInternalNumberForUseEnable <> '' AND ( REInternalNumberForUseEnable = _REIntegObjectOccupancy.REInternalNumberForUseEnable ) -- association [0..*]
LEFT OUTER JOIN I_REMeasurementType AS _REMeasurementType ON REMeasurementType = _REMeasurementType.REMeasurementType -- association [1..1]
LEFT OUTER JOIN I_REIntegrationObjectTimeline AS _REIntegObjectTimeline ON REIntegObjectInternalNumber = _REIntegObjectTimeline.InternalRealEstateNumber AND ( ValidityStartDate <= _REIntegObjectTimeline.ValidityEndDate AND ValidityEndDate >= _REIntegObjectTimeline.ValidityStartDate ) -- association [1..1]
LEFT OUTER JOIN I_REIntegObjectHierarchyMap AS _REIntegObjectHierarchyMap ON ( ( REIntegObjectInternalNumber = _REIntegObjectHierarchyMap.InternalRealEstateNumberLvl3 ) OR( REIntegObjectInternalNumber = _REIntegObjectHierarchyMap.InternalRealEstateNumberLvl2 ) ) -- association [0..1]
;