C_PurCtrItemnotes

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 C_PurCtrItemnotes.
-- 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: CTRITNOTES

CREATE VIEW C_PurCtrItemnotes AS
SELECT
  Document.Language AS Language,
  Document.DocumentText AS DocumentText,
  Document.ArchObjectNumber AS ArchObjectNumber,
  Document.TechnicalObjectType AS TechnicalObjectType,
  Document.PurchaseContractItem AS PurchaseContractItem,
  Document.PurchaseContract AS PurchaseContract,
  Document.ArchObjectNumberForEdit AS ArchObjectNumberForEdit,
  Document.PurchaseContractForEdit AS PurchaseContractForEdit,
  Document.PurchaseContractItemForEdit AS PurchaseContractItemForEdit,
  Document.TechnicalObjectTypeForEdit AS TechnicalObjectTypeForEdit,
  Document.DocumentTextForEdit AS DocumentTextForEdit,
  Document.LanguageForEdit AS LanguageForEdit,
  Document.NoteDescription AS NoteDescription,
  Document.FixedIndicator AS FixedIndicator
FROM I_PurctritnotesWD AS Document
LEFT OUTER JOIN C_ContractMaintainItem AS _PurchaseContractItemWD ON _PurchaseContractItemWD.PurchaseContract = PurchaseContract AND _PurchaseContractItemWD.PurchaseContractItem = PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_ContractMaintain AS _PurchaseContractWD ON _PurchaseContractWD.PurchaseContract = PurchaseContract  -- association [1..1]
;