I_REObjectArchived

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_REObjectArchived.
-- 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: IREOBJARCH

CREATE VIEW I_REObjectArchived AS
SELECT
  arobjguid AS REArchiveObjectUUID,
  arobjtype AS REArchiveObjectType,
  arobjkey AS RealEstateArchiveObjectKey,
  ardeleted AS REObjectIsDeleted,
  rerf AS CreatedByUser,
  derf AS CreationDate,
  terf AS CreationTime,
  reher AS RESourceOfCreation,
  arfileid AS REArchiveFileID,
  intreno AS InternalRealEstateNumber,
  objnr AS REStatusObject,
  cast(imkey as recaimkeyfi preserving type ) AS REInternalFinNumber,
  guid AS REObjectUUID,
  identkey AS REIdentificationKey,
  Responsible,
  ardestroyed AS REObjectIsDestroyed,
  oid AS RealEstateObjectOID
FROM vicaarobj AS _REObjectArchived
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ResponsibleUser ON Responsible = _ResponsibleUser.UserID  -- association [0..1]
;