Sgbt_Nte_Cds_Api

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 Sgbt_Nte_Cds_Api.
-- 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: VGBTNTECDSAPI

CREATE VIEW Sgbt_Nte_Cds_Api AS
SELECT
  NoteContent.noteid AS NoteID,
  NoteContent.objectnodetype AS ObjectNodeType,
  NoteContent.objectid AS ObjectID,
  NoteContent.notetype AS NoteType,
  NoteTypeDef,
  NoteContent.langu AS Language,
  LanguageDef,
  NoteContent.title AS Title,
  NoteContent.mimetype AS MimeType,
  NoteContent.length AS Length,
  NoteContent.creator AS Creator,
  NoteContent.created AS Created,
  NoteContent.changer AS LastChanger,
  NoteContent.changed AS LastChanged,
  NoteContent.content AS Content
FROM Sgbt_Nte_Cds_Cont AS NoteContent
LEFT OUTER JOIN Sgbt_Nte_Cds_Ntype AS NoteTypeDef ON NoteType = NoteTypeDef.Name  -- association [1..1]
LEFT OUTER JOIN Sgbt_Nte_Cds_Langu AS LanguageDef ON Language = LanguageDef.LanguageISOCode  -- association [1..1]
;