P_Matval_Manage_Val_Chart

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 P_Matval_Manage_Val_Chart.
-- 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: PMATVALMGMVCH

CREATE VIEW P_Matval_Manage_Val_Chart AS
SELECT
  price.CostEstimate AS CostEstimate,
  fyp.FiscalYear AS FiscalYear,
  fyp.FiscalPeriod AS FiscalPeriod,
  lvcr.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  price.ValuationArea AS ValuationArea,
  price.CompanyCode AS CompanyCode,
  fyp.FiscalYearPeriod AS FiscalYearPeriod,
  price.MaterialPrice AS InventoryPrice,
  price.Currency AS CompanyCodeCurrency,
  case price.MaterialPriceControl when 'S' then case hd.PriceDeterminationControl when '2' then coalesce(_MAP.MaterialPrice, 0) when '3' then coalesce(_ACT.MaterialPrice, 0) end when 'V' then coalesce(price.MaterialPrice, 0) end as MovingAveragePrice AS MaterialPrice0endasMovingAveragePrice
FROM I_MaterialLedgerPrice AS price
INNER JOIN P_MatlCtrlRecdLdgrFiscalPeriod AS marvld ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalYearPeriodForCmpnyCode AS fyp ON /* join condition not captured in parsed metadata */
INNER JOIN I_MatlLedgerValnCrcyRoleName AS lvcr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialLedgerPrice AS _ACT ON _ACT.CostEstimate = price.CostEstimate AND _ACT.CurrencyRole = price.CurrencyRole AND _ACT.Ledger = price.Ledger AND _ACT.MaterialPriceType = 'ACT' AND _ACT.MaterialPriceSubtype = 'ACT' AND _ACT.MatlPrcValdtyStrtFsclYearPerd <= price.MatlPrcValdtyStrtFsclYearPerd AND _ACT.MatlPrcValdtyEndFsclYearPeriod >= price.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _MAP ON _MAP.CostEstimate = price.CostEstimate AND _MAP.CurrencyRole = price.CurrencyRole AND _MAP.Ledger = price.Ledger AND _MAP.MaterialPriceType = 'MAP' AND _MAP.MaterialPriceSubtype = '' AND _MAP.MatlPrcValdtyStrtFsclYearPerd <= price.MatlPrcValdtyStrtFsclYearPerd AND _MAP.MatlPrcValdtyEndFsclYearPeriod >= price.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
;