I_REArchitectureObject

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_REArchitectureObject.
-- 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 I_REArchitectureObject AS
SELECT
  architectureobjectuuid AS REArchitectureObjectUUID,
  objtype AS REArchitectureObjectType,
  intreno AS InternalRealEstateNumber,
  objnr AS REStatusObject,
  oid AS REArchitectureObjectOID,
  obnr AS REArchitectureObjectNumber,
  alternativeid AS REArchtrObjectAlternativeID,
  name AS REArchitectureObjectName,
  _REKeyAssgmt.REIdentificationKey AS REIdentificationKey,
  validfrom AS ValidityStartDate,
  validto AS ValidityEndDate,
  authgrp AS REAuthorizationGroup,
  CreationDateTime,
  LastChangeDateTime,
  LocalLastChangeDateTime
FROM viobbd
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REAuthorizationGroup AS _REAuthorizationGroup ON REAuthorizationGroup = _REAuthorizationGroup.REAuthorizationGroup AND _REAuthorizationGroup.RealEstateObjectType = 'J8'  -- association [0..1]
LEFT OUTER JOIN I_REArchitectureObjectType AS _REArchitectureObjectType ON REArchitectureObjectType = _REArchitectureObjectType.REArchitectureObjectType  -- association [1..1]
LEFT OUTER JOIN I_REArchitectureObjectText AS _Text ON REArchitectureObjectUUID = _Text.REArchitectureObjectUUID  -- association [1..*]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON REStatusObject = _StatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_REArchtrObjectAncestor AS _REArchtrObjectAncestor ON REArchitectureObjectOID = _REArchtrObjectAncestor.REArchitectureObjectOID AND _REArchtrObjectAncestor.REArchitectureObjectOID <> _REArchtrObjectAncestor.REArchtrObjectAncestorOID  -- association [0..*]
LEFT OUTER JOIN I_REArchtrObjectDescendant AS _REArchtrObjectDescendant ON REArchitectureObjectOID = _REArchtrObjectDescendant.REArchitectureObjectOID AND _REArchtrObjectDescendant.REArchitectureObjectOID <> _REArchtrObjectDescendant.REArchtrObjectDescendantOID  -- association [0..*]
LEFT OUTER JOIN I_REArchtrObjectAncestor AS _REArchitectureObjRoot ON REArchitectureObjectOID = _REArchitectureObjRoot.REArchitectureObjectOID AND _REArchitectureObjRoot.HierarchyLevel = 1  -- association [1..1]
LEFT OUTER JOIN I_REArchtrObjectAncestor AS _REArchitectureObjSite ON REArchitectureObjectOID = _REArchitectureObjSite.REArchitectureObjectOID AND _REArchitectureObjSite.REArchitectureObjectCategory = '1'  -- association [0..1]
LEFT OUTER JOIN I_REArchtrObjectAncestor AS _REArchitectureObjBuilding ON REArchitectureObjectOID = _REArchitectureObjBuilding.REArchitectureObjectOID AND _REArchitectureObjBuilding.REArchitectureObjectCategory = '2'  -- association [0..1]
LEFT OUTER JOIN I_REArchtrObjectAncestor AS _REArchitectureObjLand ON REArchitectureObjectOID = _REArchitectureObjLand.REArchitectureObjectOID AND _REArchitectureObjLand.REArchitectureObjectCategory = '3'  -- association [0..1]
LEFT OUTER JOIN E_REArchitectureObject AS _Extension ON REArchitectureObjectUUID = _Extension.REArchitectureObjectUUID  -- association [1..1]
;