I_CntrlPurContractHeaderNotes

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_CntrlPurContractHeaderNotes.
-- 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: ICCTRHDRNOTE

CREATE VIEW I_CntrlPurContractHeaderNotes AS
SELECT
  noteid AS PurchasingDocumentNoteUUID,
  objectnodetype AS PurchasingDocumentObjNodeType,
  objectid AS PurchasingDocumentNoteObjectID,
  notetype AS PurchasingDocumentNoteType,
  langu AS PurchasingDocumentNoteLanguage,
  _NoteTypeDef.Description AS PurchasingDocumentNoteTitle,
  mimetype AS PurchasingDocumentNoteMimeType,
  length AS PurchasingDocumentNoteLength,
  creator AS PurgDocNoteCreatedBy,
  created AS PurgDocNoteCreationDateTime,
  changer AS PurgDocNoteLastChangedBy,
  changed AS PurgDocNoteLastChangedDateTime,
  content AS PurgDocNoteText
FROM Sgbt_Nte_Cds_Cont
LEFT OUTER JOIN Sgbt_Nte_Cds_Ntype AS _NoteTypeDef ON PurchasingDocumentNoteType = _NoteTypeDef.Name  -- association [1..1]
LEFT OUTER JOIN Sgbt_Nte_Cds_Langu AS _LanguageDef ON PurchasingDocumentNoteLanguage = _LanguageDef.LanguageISOCode  -- association [1..1]
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON PurchasingDocumentNoteObjectID = _CentralPurchaseContract.CentralPurchaseContract  -- association [0..1]
;