P_Ml_Prices_Ckml

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_Ml_Prices_Ckml.
-- 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: PMLPRICESCKML

CREATE VIEW P_Ml_Prices_Ckml AS
SELECT
  pr.kalnr AS CostEstimate,
  pr.curtp AS CurrencyRole,
  cr.bdatj AS FiscalYear,
  cr.poper AS FiscalPeriod,
  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 AS WBSElement,
  hd.sobkz AS InvtryValnSpecialStockType,
  hd.kzbws AS InventorySpecialStockValnType,
  hd.xobew AS IsSupplierStockValuation,
  concat(cr.bdatj, cr.poper) AS FiscalYearPeriod,
  hd.mlast AS PriceDeterminationControl,
  cr.vprsv AS MaterialPriceControl,
  cr.peinh AS MaterialPriceUnitQty,
  cr.waers AS Currency,
  cr.pvprs AS MovingAveragePrice,
  cr.stprs AS StandardPrice,
  case cr.vprsv when 'S' then COALESCE(cr.stprs, 0) when 'V' then COALESCE(cr.pvprs, 0) else COALESCE(cr.stprs, 0) end as InventoryPrice AS stprs0endasInventoryPrice,
  pr.lplpr AS CurrentPlanPrice,
  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,
  pr.zbwst AS FutrPlanProjSlsOrdValnStrategy,
  cast(pr.fplpx as fml_plpx) AS FixedPortionOfPlannedPrice
FROM ckmlpr AS pr
LEFT OUTER JOIN ckmlhd AS hd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ckmlcr AS cr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN prps AS ps ON /* join condition not captured in parsed metadata */
;