I_Sgbt_Nte_Cds_Apitp

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_Sgbt_Nte_Cds_Apitp.
-- 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: VIGBTNTECDSAPITP

CREATE VIEW I_Sgbt_Nte_Cds_Apitp AS
SELECT
  NoteContent.noteid AS noteid,
  NoteContent.objectid AS objectid,
  NoteContent.notetype AS notetype,
  NoteTypeDef,
  NoteContent.langu AS langu,
  LanguageDef,
  NoteContent.title AS title,
  NoteContent.mimetype AS mimetype,
  NoteContent.length AS length,
  NoteContent.creator AS creator,
  NoteContent.created AS created,
  NoteContent.changer AS changer,
  NoteContent.changed AS changed,
  NoteContent.content AS content,
  cast('' as nte_dp_key) AS dp_item_key,
  cast('' as nte_readonly) AS readonly
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 langu = LanguageDef.LanguageISOCode  -- association [1..1]
LEFT OUTER JOIN i_sgbt_nte_cds_attr AS _attr ON noteid = _attr.Noteid  -- association [0..*]
;