P_DocumentInfoRecordObjectLink

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 P_DocumentInfoRecordObjectLink.
-- 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: PCVDOCOBJLINK

CREATE VIEW P_DocumentInfoRecordObjectLink AS
SELECT
  obj_links.dokar AS DocumentInfoRecordDocType,
  obj_links.doknr AS DocumentInfoRecordDocNumber,
  obj_links.dokvr AS DocumentInfoRecordDocVersion,
  obj_links.doktl AS DocumentInfoRecordDocPart,
  obj_links.dokob AS LinkedSAPObject,
  obj_links.objky AS LinkedSAPObjectKey,
  obj_links.obzae AS DocObjectLinkCounter,
  LastChange.created_at AS CreationDateTime,
  LastChange.created_by AS CreatedByUser,
  LastChange.changed_at AS ChangedDateTime,
  LastChange.changed_by AS LastChangedByUser,
  obj_links.vrkstat AS DocInfoRecdLinkStatus,
  obj_links.vrkstat1 AS DocInfoRecdObjectLinkStatus,
  obj_links.vobj AS ObjectTypeDatabaseTable,
  obj_links.vkey AS DocInfoRecdAdditionalObjectKey,
  obj_links.vdir AS DocLinkDirectionIsActive,
  obj_links.viewflag AS IsDefaultDocument,
  obj_links.delflag AS DocInfoRecdIsMarkedForDeletion,
  obj_links.longtext_id AS DocInfoRecdLongTextUUID,
  obj_links.cad_pos AS IsDocInfoRecdCreatedFromCAD,
  obj_links.cm_fixed AS DocInfoRecdConfignMgmtFixed,
  obj_links.archflag AS IsArchived
FROM drad AS obj_links
LEFT OUTER JOIN drad_last_change AS LastChange ON /* join condition not captured in parsed metadata */
;