P_MlPrice_By_Periodtype

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_MlPrice_By_Periodtype.
-- 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: PFMLTPRICEPTYPE

CREATE VIEW P_MlPrice_By_Periodtype AS
SELECT
  invprice.CostEstimate AS CostEstimate,
  invprice.Ledger AS Ledger,
  invprice.CurrencyRole AS CurrencyRole,
  marvld.CurrentFiscalYear AS FiscalYear,
  marvld.CurrentFiscalPeriod AS FiscalPeriod,
  'LF' AS PeriodType,
  'LF' AS FiscalPeriodType,
  invprice.MatlPrcValdtyStrtFsclYearPerd AS MatlPrcValdtyStrtFsclYearPerd,
  invprice.Material AS Material,
  invprice.ValuationArea AS ValuationArea,
  invprice.InventoryValuationType AS InventoryValuationType,
  hd.vbeln AS SalesOrder,
  hd.posnr AS SalesOrderItem,
  hd.lifnr AS Supplier,
  ps.WBSElementInternalID AS WBSElementInternalID,
  ps.WBSElementExternalID AS WBSElementExternalID,
  hd.sobkz AS InvtryValnSpecialStockType,
  hd.kzbws AS InventorySpecialStockValnType,
  hd.xobew AS IsSupplierStockValuation,
  invprice.CompanyCode AS CompanyCode,
  hd.mlast AS PriceDeterminationControl,
  invprice.MaterialPriceControl AS MaterialPriceControl,
  invprice.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  invprice.Currency AS Currency,
  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,
  invprice.MaterialPrice AS InventoryPrice,
  _FuturePrice.MaterialPrice AS FuturePrice,
  _FuturePrice.MaterialPriceValidityStartDate AS FuturePriceValidityStartDate,
  _FutureStdPrice.MaterialPrice AS PlannedPrice,
  _FutureStdPrice.ValuationVariant AS FutrCostEstValuationVariant,
  _FutureStdPrice.MatlPrcValidityStartFiscalYear AS FutureCostEstFiscalYear,
  _FutureStdPrice.MatlPrcValdtyStartFiscalPeriod AS FutureCostEstimateFiscalPeriod,
  _FutureStdPrice.CostingVersion AS FutureCostEstCostingVersion,
  _FutureStdPrice.FixedPortionOfMaterialPrice AS FixedPortionOfPlannedPrice,
  hd.price_sdm_yearper AS CostEstimateasCostEstimate
FROM I_MaterialLedgerPrice AS invprice
INNER JOIN ckmlhd AS hd ON /* join condition not captured in parsed metadata */
INNER JOIN I_MatlCtrlRecdLdgrFiscalPeriod AS marvld ON /* join condition not captured in parsed metadata */
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.MatlPrcValdtyStrtFsclYearPerd <= marvld.CurrentFiscalYearPeriod AND _ActualPrice.MatlPrcValdtyEndFsclYearPeriod >= marvld.CurrentFiscalYearPeriod  -- 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.MatlPrcValdtyStrtFsclYearPerd <= marvld.CurrentFiscalYearPeriod AND _MvgAvgPrice.MatlPrcValdtyEndFsclYearPeriod >= marvld.CurrentFiscalYearPeriod  -- 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 = ' ' AND _FuturePrice.MaterialPriceValidityStartDate <= $session.system_date AND _FuturePrice.MaterialPriceValidityEndDate >= $session.system_date  -- 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 = ' ' AND _FutureStdPrice.MaterialPriceValidityStartDate <= $session.system_date AND _FutureStdPrice.MaterialPriceValidityEndDate >= $session.system_date  -- association [0..1]
-- UNION ALL with additional select branch(es): I_MaterialLedgerPrice
;