I_ShiftNoteDocumentLink

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_ShiftNoteDocumentLink.
-- 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_ShiftNoteDocumentLink AS
SELECT
  docu.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  cast(docu.DocumentInfoRecordDocVersion as dokvr preserving type) AS DocumentInfoRecordDocVersion,
  cast(docu.DocumentInfoRecordDocNumber as doknr preserving type) AS DocumentInfoRecordDocNumber,
  cast(docu.DocumentInfoRecordDocPart as doktl_d preserving type) AS DocumentInfoRecordDocPart,
  docu.DocumentInfoRecord AS DocumentInfoRecord,
  docu.InternalDocumentStatus AS InternalDocumentStatus,
  link.LinkedSAPObject AS LinkedSAPObject,
  link.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  docu.ChangeNumber AS ChangeNumber,
  cast(docu.CreationDateTime as hp_created_at preserving type) AS CreationDateTime,
  docu.CreatedByUser AS CreatedByUser,
  cast(docu.ChangedDateTime as hp_changed_at preserving type) AS ChangedDateTime,
  docu.LastChangedByUser AS LastChangedByUser,
  note.ShiftNoteID AS ShiftNoteID,
  note.ShiftNoteType AS ShiftNoteType,
  link._Text AS _Text,
  docu._DocType AS _DocType,
  docu._DocNumber AS _DocNumber,
  docu._DocVersion AS _DocVersion,
  docu._DocPart AS _DocPart,
  docu._DocDesc AS _DocDesc
FROM I_ShiftNote AS note
INNER JOIN I_DocumentInfoRecordObjectLink AS link ON /* join condition not captured in parsed metadata */
INNER JOIN I_DocumentInfoRecord AS docu ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordAttachment AS _DocumentAttachment ON DocumentInfoRecordDocType = _DocumentAttachment.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocumentAttachment.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocumentAttachment.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _DocumentAttachment.DocumentInfoRecordDocPart  -- association [0..*]
;