I_LglCntntMNotesDet

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_LglCntntMNotesDet.
-- 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: ILCMNOTESDET

CREATE VIEW I_LglCntntMNotesDet AS
SELECT
  LglCntntMNoteUUID,
  LCMNote.LglCntntMParentNoteUUID AS LglCntntMParentNoteUUID,
  LCMNote.LglCntntMTopNoteUUID AS LglCntntMTopNoteUUID,
  LCMNote.LglCntntMStdNoteUUID AS LglCntntMStdNoteUUID,
  LglCntntMNoteLvl,
  LCMNote.LglCntntMObjType AS LglCntntMObjType,
  _LglCntntMNotesObjTypes.LglCntntMObjTypeDesc AS LglCntntMObjTypeDesc,
  LCMNote.LglCntntMObjUUID AS LglCntntMObjUUID,
  LCMNote.LglCntntMObjectID AS LglCntntMObjectID,
  ReplyCnt.LglCntntMNoteReplyCnt AS LglCntntMNoteReplyCnt,
  ThreadTime.LglCntntMNotesThreadUTCDteTme AS LglCntntMNotesThreadUTCDteTme,
  objectnodetype AS LglCntntMObjNodeType,
  notetype AS LglCntntMNoteType,
  cast( mimetype as w3conttype ) AS MimeType,
  content AS LglCntntMNoteCntnt,
  LCMNote.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  LCMNote.LglCntntMCreatedByUser AS LglCntntMCreatedByUser,
  LCMNote.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  LCMNote.LglCntntMChangedByUser AS LglCntntMChangedByUser
FROM I_LglCntntMNotes AS LCMNote
INNER JOIN Sgbt_Nte_Cds_Cont AS Note ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LglCntntMNotesReplyCnt AS ReplyCnt ON /* join condition not captured in parsed metadata */
INNER JOIN I_LglCntntMNotesThreadTime AS ThreadTime ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LglCntntMNotesObjTypes AS _LglCntntMNotesObjTypes ON _LglCntntMNotesObjTypes.LglCntntMObjType = LCMNote.LglCntntMObjType  -- association [1..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _CreatedByContactCard ON _CreatedByContactCard.ContactCardType = 'User' AND _CreatedByContactCard.ContactCardID = LglCntntMCreatedByUser AND _CreatedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _ChangedByContactCard ON _ChangedByContactCard.ContactCardType = 'User' AND _ChangedByContactCard.ContactCardID = LglCntntMChangedByUser AND _ChangedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
;