I_DocInfoRecdObjectLink

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_DocInfoRecdObjectLink.
-- 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: ICVDOCOBJLINK

CREATE VIEW I_DocInfoRecdObjectLink AS
SELECT
  ObjectLinks.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  ObjectLinks.DocumentType AS DocumentType,
  ObjectLinks.DocumentInfoRecord AS DocumentInfoRecord,
  ObjectLinks.DocumentPart AS DocumentPart,
  ObjectLinks.DocumentVersion AS DocumentVersion,
  ObjectLinks.LinkedSAPObject AS LinkedSAPObject,
  ObjectLinks.DocObjectLinkCounter AS DocObjectLinkCounter,
  LastChange.created_at AS CreationDateTime,
  LastChange.created_by AS CreatedByUser,
  LastChange.changed_at AS ChangedDateTime,
  LastChange.changed_by AS ChangedBy,
  ObjectLinks.DocInfoRecdLinkStatus AS DocInfoRecdLinkStatus,
  ObjectLinks.DocInfoRecdObjectLinkStatus AS DocInfoRecdObjectLinkStatus,
  ObjectLinks.ObjectTypeDatabaseTable AS ObjectTypeDatabaseTable,
  ObjectLinks.DocInfoRecdAdditionalObjectKey AS DocInfoRecdAdditionalObjectKey,
  ObjectLinks.DocLinkDirectionIsActive AS DocLinkDirectionIsActive,
  ObjectLinks.IsDefaultDocument AS IsDefaultDocument,
  ObjectLinks.DocInfoRecdIsDeleted AS DocInfoRecdIsMarkedForDeletion,
  ObjectLinks.DocInfoRecdLongTextUUID AS DocInfoRecdLongTextUUID,
  ObjectLinks.DocumentIsCreatedByCAD AS DocumentIsCreatedByCAD,
  ObjectLinks.DocInfoRecdConfignMgmtFixed AS DocInfoRecdConfignMgmtFixed
FROM P_DocInfoRecdObjectLink AS ObjectLinks
LEFT OUTER JOIN drad_last_change AS LastChange ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocInfoRecdDocumentType AS _DocumentType ON DocumentType = _DocumentType.DocumentType  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdNumber AS _DocumentNumber ON DocumentType = _DocumentNumber.DocumentType AND DocumentInfoRecord = _DocumentNumber.DocumentInfoRecord  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDocumentVersion AS _DocumentVersion ON DocumentType = _DocumentVersion.DocumentType AND DocumentInfoRecord = _DocumentVersion.DocumentInfoRecord AND DocumentVersion = _DocumentVersion.DocumentVersion  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDocumentPart AS _DocumentPart ON DocumentPart = _DocumentPart.DocumentPart AND DocumentType = _DocumentPart.DocumentType AND DocumentInfoRecord = _DocumentPart.DocumentInfoRecord AND DocumentVersion = _DocumentPart.DocumentVersion  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDocumentTypeText AS _DocumentTypeDescription ON DocumentType = _DocumentTypeDescription.DocumentType  -- association [0..*]
LEFT OUTER JOIN I_DocInfoRecdObjectLinkText AS _LinkedObjectDesc ON LinkedSAPObject = _LinkedObjectDesc.LinkedSAPObject  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _CreatedUser ON DocumentType = _CreatedUser.DocumentInfoRecordDocType AND DocumentPart = _CreatedUser.DocumentInfoRecordDocPart AND DocumentInfoRecord = _CreatedUser.DocumentInfoRecordDocNumber AND DocumentVersion = _CreatedUser.DocumentInfoRecordDocVersion AND CreatedByUser = _CreatedUser.ResponsiblePersonName  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _ChangedUser ON DocumentType = _ChangedUser.DocumentInfoRecordDocType AND DocumentPart = _ChangedUser.DocumentInfoRecordDocPart AND DocumentInfoRecord = _ChangedUser.DocumentInfoRecordDocNumber AND DocumentVersion = _ChangedUser.DocumentInfoRecordDocVersion AND ChangedBy = _ChangedUser.LastChangedByUser  -- association [1..1]
;