P_CURRENTMATLVALNPRICE

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_CURRENTMATLVALNPRICE.
-- 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: PCURMATLVALNPRC

CREATE VIEW P_CURRENTMATLVALNPRICE AS
SELECT
  crjoin.CostEstimate AS CostEstimate,
  coalesce(_MLCurrencyInfo.Ledger, cast(' ' as fins_ledger)) AS Ledger,
  cast( crjoin.CurrencyRole as fins_ext_curtype preserving type ) AS CurrencyRole,
  hd.matnr AS Material,
  hd.bwkey AS ValuationArea,
  hd.bwtar AS InventoryValuationType,
  hd.vbeln AS SalesOrder,
  hd.posnr AS SalesOrderItem,
  hd.lifnr AS Supplier,
  hd.pspnr AS WBSElementInternalID,
  ps.posid_edit AS WBSElementExternalID,
  hd.sobkz AS InvtryValnSpecialStockType,
  hd.kzbws AS InventorySpecialStockValnType,
  hd.xobew AS IsSupplierStockValuation,
  hd.mlast AS PriceDeterminationControl,
  tk.bukrs AS CompanyCode,
  crjoin.MaterialPriceControl AS MaterialPriceControl,
  crjoin.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  crjoin.Currency AS Currency,
  crjoin.MovingAveragePrice AS MovingAveragePrice,
  crjoin.StandardPrice AS StandardPrice,
  crjoin.InventoryPrice AS InventoryPrice,
  pr.zkprs AS FuturePrice,
  pr.zprsdat AS FuturePriceValidityStartDate,
  cast(pr.zplpr as fml_plpr) AS PlannedPrice,
  pr.bwva1 AS FutrCostEstValuationVariant,
  pr.pdatz AS FutureCostEstFiscalYear,
  pr.pprdz AS FutureCostEstimateFiscalPeriod,
  pr.vers1 AS FutureCostEstCostingVersion,
  cast(pr.fplpx as fml_plpx) AS FixedPortionOfPlannedPrice,
  _MLCurrencyInfo.LedgerName AS LedgerName,
  _MLCurrencyInfo.CurrencyRoleName AS CurrencyRoleName,
  case invprice.MaterialPriceControl when 'S' then case hd.mlast when '2' then coalesce(_MvgAvgPrice.MaterialPrice, 0) when '3' then coalesce(_ActualPrice.MaterialPrice, 0) else cast (0 as fml_price ) end else coalesce(invprice.MaterialPrice, 0) end as MovingAveragePrice AS MaterialPrice0endasMovingAveragePrice,
  case invprice.MaterialPriceControl when 'S' then coalesce(invprice.MaterialPrice, 0) else coalesce(_StandardPrice.MaterialPrice, 0) end as StandardPrice AS MaterialPrice0endasStandardPrice,
  _MLCurrencyInfo.LedgerValnCrcyRoleIsUsedInLogs AS LedgerValnCrcyRoleIsUsedInLogs
FROM P_CURMATLVALNPRICE_CR_JOIN AS crjoin
INNER JOIN R_MatlPriceDataMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlhd AS hd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlpr AS pr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN prps AS ps ON /* join condition not captured in parsed metadata */
INNER JOIN ckmlhd AS hd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _MLCurrencyInfo ON _MLCurrencyInfo.LedgerValuationCurrencyRole = crjoin.CurrencyRole AND _MLCurrencyInfo.CompanyCode = tk.bukrs  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _StandardPrice ON _StandardPrice.CostEstimate = invprice.CostEstimate AND _StandardPrice.Ledger = invprice.Ledger AND _StandardPrice.CurrencyRole = invprice.CurrencyRole AND _StandardPrice.MaterialPriceType = 'STDPR' AND _StandardPrice.MaterialPriceSubtype = ' ' AND _StandardPrice.MaterialPriceValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _ActualPrice ON _ActualPrice.CostEstimate = invprice.CostEstimate AND _ActualPrice.Ledger = invprice.Ledger AND _ActualPrice.CurrencyRole = invprice.CurrencyRole AND _ActualPrice.MaterialPriceType = 'ACT' AND _ActualPrice.MaterialPriceSubtype = 'ACT' AND _ActualPrice.MaterialPriceValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _MvgAvgPrice ON _MvgAvgPrice.CostEstimate = invprice.CostEstimate AND _MvgAvgPrice.Ledger = invprice.Ledger AND _MvgAvgPrice.CurrencyRole = invprice.CurrencyRole AND _MvgAvgPrice.MaterialPriceType = 'MAP' AND _MvgAvgPrice.MaterialPriceSubtype = ' ' AND _MvgAvgPrice.MaterialPriceValidityEndDate = '99991231'  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _FuturePrice ON _FuturePrice.CostEstimate = invprice.CostEstimate AND _FuturePrice.Ledger = invprice.Ledger AND _FuturePrice.CurrencyRole = invprice.CurrencyRole AND _FuturePrice.MaterialPriceType = 'FUTURE' AND _FuturePrice.MaterialPriceSubtype = ' '  -- association [0..1]
LEFT OUTER JOIN I_MLPrExtRefCostEstimate AS _FutureStdPrice ON _FutureStdPrice.CostEstimate = invprice.CostEstimate AND _FutureStdPrice.Ledger = invprice.Ledger AND _FutureStdPrice.CurrencyRole = invprice.CurrencyRole AND _FutureStdPrice.MaterialPriceType = 'FSTDCE' AND _FutureStdPrice.MaterialPriceSubtype = ' '  -- association [0..1]
-- UNION ALL with additional select branch(es): I_MaterialLedgerPrice
;