R_NoteBasic

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 R_NoteBasic.
-- 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 R_NoteBasic AS
SELECT
  noteid AS NoteBasicUUID,
  cast(objectnodetype as sap_object_node_type preserving type ) AS NoteBasicObjectNodeType,
  objectid AS NoteBasicObject,
  notetype AS NoteBasicType,
  langu AS NoteBasicLanguage,
  title AS NoteBasicTitle,
  mimetype AS NoteBasicMIMEType,
  length AS NoteBasicLength,
  creator AS NoteBasicCreatedByUser,
  created AS NoteBasicCreationDateTime,
  changer AS NoteBasicLastChangedByUser,
  changed AS NoteBasicLastChangeDateTime,
  content AS NoteBasicContent,
  upper(objectnodetype) AS NoteBasicObjectNodeTypeUpper
FROM sgbt_nte_cont
LEFT OUTER JOIN I_NoteBasicType AS _NoteBasicType ON NoteBasicType = _NoteBasicType.NoteBasicType AND NoteBasicObjectNodeTypeUpper = _NoteBasicType.NoteBasicObjectNodeType  -- association [1]
LEFT OUTER JOIN I_Language AS _Language ON NoteBasicLanguage = _Language.LanguageISOCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON NoteBasicLastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON NoteBasicCreatedByUser = _CreatedByUser.UserID  -- association [0..1]
;