I_CntrlPurContractItemNotes

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_CntrlPurContractItemNotes.
-- 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: ICCTRITMNOTE

CREATE VIEW I_CntrlPurContractItemNotes 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,
  left( objectid, 10) AS CentralPurchaseContract
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 CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
;