I_REIntegObjectBldngLandVH

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_REIntegObjectBldngLandVH.
-- 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: IREINTOBJBULAVH

CREATE VIEW I_REIntegObjectBldngLandVH AS
SELECT
  REIntegrationObjectNumberLvl1,
  InternalRealEstateNumberLvl1,
  RealEstateExternalIDLvl1,
  cast( coalesce( _REIntegrationObjLvl1Bu.REIntegrationObjectType, _REIntegrationObjLvl1La.REIntegrationObjectType ) as reipobjecttype preserving type ) AS REIntegrationObjectType,
  _REIntegrationObjLvl1Bu.REIntegrationObjectName AS REIntegObjectBuildingName,
  _REIntegrationObjLvl1La.REIntegrationObjectName AS REIntegObjectLandName,
  cast( coalesce( _REIntegrationObjLvl1La.REIntegrationObjectName, _REIntegrationObjLvl1Bu.REIntegrationObjectName ) as reipxsobject preserving type ) AS REIntegrationObjectName,
  cast( coalesce( _REIntegrationObjLvl1Bu.REAuthorizationGroup, _REIntegrationObjLvl1La.REAuthorizationGroup ) as recaauthgrp preserving type ) AS REAuthorizationGroup,
  cast( coalesce( _REIntegrationObjLvl1Bu.ValidityStartDate, _REIntegrationObjLvl1La.ValidityStartDate ) as rebdvdmvalidfrom preserving type ) AS ValidityStartDateLvl1,
  cast( coalesce( _REIntegrationObjLvl1Bu.ValidityEndDate, _REIntegrationObjLvl1La.ValidityEndDate ) as rebdvdmvalidto preserving type ) AS ValidityEndDateLvl1,
  REIntegrationObjectNumberLvl0,
  InternalRealEstateNumberLvl0,
  REIntegObjectSiteName
LEFT OUTER JOIN I_REIntegrationObject AS _REIntegrationObjLvl0 ON _REIntegrationObjLvl0.InternalRealEstateNumber = InternalRealEstateNumberLvl0  -- 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]
;