I_REIntegObjectOccupancyVH

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_REIntegObjectOccupancyVH.
-- 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: IREINTOBJOCCVH

CREATE VIEW I_REIntegObjectOccupancyVH AS
SELECT
  _REIntegrationObjLvl2.REIntegrationObjectNumber AS REIntegrationObjectNumberLvl2,
  InternalRealEstateNumberLvl2,
  _REObjectTypeDetails.REIdentification AS REIdentification,
  _REIntegrationObjLvl2.REIntegrationObjectName AS REIntegrationObjectName,
  _REIntegrationObjLvl2.ValidityStartDate AS ValidityStartDate,
  _REIntegrationObjLvl2.ValidityEndDate AS ValidityEndDate,
  _REIntegrationObjLvl2.REStatusObject AS REStatusObject,
  _REIntegrationObjLvl2.REIntegrationObjectType AS REIntegrationObjectType,
  _REIntegrationObjLvl2.RESpaceGroupUsageType AS RESpaceGroupUsageType,
  _REIntegrationObjLvl2.REIntegObjSpaceGroupType AS REIntegObjSpaceGroupType,
  _REIntegrationObjLvl2.REIntegObjectLongName AS REIntegObjectLongName,
  _REIntegrationObjLvl2.Responsible AS Responsible,
  _REIntegrationObjLvl2._REUseEnableIntegrationObject.CompanyCode AS CompanyCode,
  _REIntegrationObjLvl2.REAuthorizationGroup AS REAuthorizationGroup,
  _REIntegrationObjLvl2._REIntegObjSpaceGroupType.REIntegObjectReference AS REIntegObjectReference,
  RealEstateExternalIDLvl0,
  InternalRealEstateNumberLvl0,
  REIntegObjectSiteName,
  RealEstateExternalIDLvl1,
  InternalRealEstateNumberLvl1,
  _REIntegrationObjLvl1Bu.REIntegrationObjectName AS REIntegObjectBuildingName,
  _REIntegrationObjLvl1La.REIntegrationObjectName AS REIntegObjectLandName,
  cast( coalesce( _REIntegrationObjLvl1Bu.ValidityStartDate, _REIntegrationObjLvl1La.ValidityStartDate ) as rebdvdmvalidfrom preserving type ) AS ValidityStartDateLvl1,
  cast( coalesce( _REIntegrationObjLvl1Bu.ValidityEndDate, _REIntegrationObjLvl1La.ValidityEndDate ) as rebdvdmvalidfrom preserving type ) AS ValidityEndDateLvl1
LEFT OUTER JOIN I_REIntegrationObject AS _REIntegrationObjLvl2 ON _REIntegrationObjLvl2.InternalRealEstateNumber = InternalRealEstateNumberLvl2 AND _REIntegrationObjLvl2.REIntegrationObjectType = 'C4SG'  -- association [1..1]
LEFT OUTER JOIN I_REIntegrationObject AS _REIntegrationObjLvl1Bu ON _REIntegrationObjLvl1Bu.InternalRealEstateNumber = InternalRealEstateNumberLvl1 AND _REIntegrationObjLvl1Bu.REIntegrationObjectType = 'C4BU'  -- association [1..1]
LEFT OUTER JOIN I_REIntegrationObject AS _REIntegrationObjLvl1La ON _REIntegrationObjLvl1La.InternalRealEstateNumber = InternalRealEstateNumberLvl1 AND _REIntegrationObjLvl1La.REIntegrationObjectType = 'C4PR'  -- association [1..1]
LEFT OUTER JOIN I_REObjectTypeDetails AS _REObjectTypeDetails ON _REObjectTypeDetails.InternalRealEstateNumber = InternalRealEstateNumberLvl2  -- association [1..1]
;