P_MaterialValuation

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_MaterialValuation.
-- 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: PMATLVALN

CREATE VIEW P_MaterialValuation AS
SELECT
  price.CostEstimate AS CostEstimate,
  price.CurrencyRole AS CurrencyRole,
  price.Ledger AS Ledger,
  price.Material AS Material,
  price.ValuationArea AS ValuationArea,
  price.InventoryValuationType AS InventoryValuationType,
  price.CompanyCode AS CompanyCode,
  xbew.InventoryValuationCategory AS InventoryValuationCategory,
  xbew.MaterialValuationClass AS MaterialValuationClass,
  xbew.SDDocument AS SalesOrder,
  xbew.SDDocumentItem AS SalesOrderItem,
  xbew.Supplier AS Supplier,
  ps.WBSElementInternalID AS WBSElementInternalID,
  xbew.InventorySpecialStockType AS InventorySpecialStockType,
  xbew.PriceDeterminationControl AS PriceDeterminationControl,
  price.ValuationQuantityUnit AS BaseUnit,
  price.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  price.Currency AS Currency,
  price.MaterialPriceControl AS MaterialPriceControl,
  price.MaterialPrice AS InventoryPrice,
  case price.MaterialPriceControl when 'S' then case xbew.PriceDeterminationControl when '2' then coalesce(_MAP.MaterialPrice,0) when '3' then coalesce(_ACT.MaterialPrice,0) else cast (0 as fml_price ) end else price.MaterialPrice end as MovingAveragePrice AS MaterialPriceendasMovingAveragePrice,
  case price.MaterialPriceControl when 'S' then price.MaterialPrice else coalesce(_STDPR.MaterialPrice,0) end as StandardPrice AS MaterialPrice0endasStandardPrice,
  price.CurPlanProjSlsOrdValnStrategy AS CurPlanProjSlsOrdValnStrategy,
  cast ( coalesce(bal.AmountInCompanyCodeCurrency, 0) as fins_vhcur12) AS AmountInCompanyCodeCurrency,
  cast ( coalesce(bal.TotalVltdStockQuantity, 0) as fin_qtyval) AS TotalVltdStockQuantity,
  crcy.LedgerValnCrcyRoleIsUsedInLogs AS LedgerValnCrcyRoleIsUsedInLogs,
  cast(crcy.AccountingValuationView as fins_valutyp) AS AccountingValuationView,
  crcy.LedgerName AS LedgerName,
  coalesce(_INVPR.MaterialPrice,0) AS MovingAveragePrice,
  coalesce(_STDPR.MaterialPrice,0) AS StandardPrice,
  crcy.CurrencyRoleName AS CurrencyRoleName
FROM I_MaterialLedgerPrice AS price
LEFT OUTER JOIN I_MaterialLedgerPrice AS _STDPR ON _STDPR.CostEstimate = price.CostEstimate AND _STDPR.Ledger = price.Ledger AND _STDPR.CurrencyRole = price.CurrencyRole AND _STDPR.MaterialPriceType = 'STDPR' AND _STDPR.MaterialPriceSubtype = '' AND _STDPR.MatlPrcValdtyEndFsclYearPeriod = '9999012'  -- association [0..1]
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.MatlPrcValdtyEndFsclYearPeriod = '9999012'  -- 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.MatlPrcValdtyEndFsclYearPeriod = '9999012'  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS ps ON ps.WBSElementInternalID = xbew.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _INVPR ON _INVPR.CostEstimate = md.CostEstimate AND _INVPR.Ledger = md.Ledger AND _INVPR.CurrencyRole = md.CurrencyRole AND _INVPR.MaterialPriceType = 'INVPR' AND _INVPR.MaterialPriceSubtype = '' AND _INVPR.MatlPrcValdtyEndFsclYearPeriod = '9999012'  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _FUTURE ON _FUTURE.CostEstimate = md.CostEstimate AND _FUTURE.Ledger = md.Ledger AND _FUTURE.CurrencyRole = md.CurrencyRole AND _FUTURE.MaterialPriceType = 'FUTURE' AND _FUTURE.MaterialPriceSubtype = '' AND _FUTURE.MatlPrcValdtyEndFsclYearPeriod = '9999012'  -- association [0..1]
-- UNION ALL with additional select branch(es): P_Matval_Manage_Md2
;