I_PriceChangeDocument

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_PriceChangeDocument.
-- 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: IMLPRCHDOCUMENT

CREATE VIEW I_PriceChangeDocument AS
SELECT
  header.PriceChangeDocument AS PriceChangeDocument,
  header.MaterialLedgerDocumentYear AS MaterialLedgerDocumentYear,
  header.MaterialLedgerTransactionType AS MaterialLedgerTransactionType,
  header.LedgerGroup AS LedgerGroup,
  header.ReferenceDocumentType AS ReferenceDocumentType,
  header.ReferenceDocument AS ReferenceDocument,
  header.ReferenceDocumentContext AS ReferenceDocumentContext,
  header.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  header.IsReversalDocument AS IsReversalDocument,
  header.DocumentDate AS DocumentDate,
  header.CreationDate AS CreationDate,
  header.CreationTime AS CreationTime,
  header.CreatedByUser AS CreatedByUser,
  header.ExecutedTransaction AS ExecutedTransaction,
  header.BusinessTransactionType AS BusinessTransactionType,
  header.LogicalSystem AS LogicalSystem,
  header.DocumentHeaderText AS DocumentHeaderText,
  header.MatlPrChgAcctDetnDiffntnRsn AS MatlPrChgAcctDetnDiffntnRsn
FROM R_PriceChangeDocument AS header
LEFT OUTER JOIN I_PriceChangeDocumentItem AS _Details ON header.PriceChangeDocument = _Details.MaterialLedgerDocument AND header.MaterialLedgerDocumentYear = _Details.MaterialLedgerDocumentYear  -- association [1..*]
;