P_MATVAL_MANAGE_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_MATVAL_MANAGE_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: PMATVALMGMCKML

CREATE VIEW P_MATVAL_MANAGE_CKML AS
SELECT
  pr.kalnr AS CostEstimate,
  lvcr.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  cr.bdatj AS FiscalYear,
  cr.poper AS FiscalPeriod,
  hd.bwkey AS ValuationArea,
  hd.matnr AS Material,
  hd.bwtar AS InventoryValuationType,
  hd.sobkz AS InvtryValnSpecialStockType,
  hd.vbeln AS SalesOrder,
  hd.posnr AS SalesOrderItem,
  hd.lifnr AS Supplier,
  hd.pspnr AS WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  concat(cr.bdatj, cr.poper) AS FiscalYearPeriod,
  hd.kzbws AS InventorySpecialStockValnType,
  cast(hd.mlast as fml_abst) AS PriceDeterminationControl,
  cast(pr.zkprs as fml_dzkprs) AS FuturePrice,
  cast(pr.zprsdat as fml_zprsdat) AS FuturePriceValidityStartDate,
  pr.zplpr AS FuturePlannedPrice,
  cast(cr.vprsv as inventoryvaluationprocedure) AS MaterialPriceControl,
  cr.peinh AS MaterialPriceUnitQty,
  cr.pvprs AS MovingAveragePrice,
  cr.stprs AS StandardPrice,
  cr.waers AS Currency,
  cast(pr.lplpx as fml_price_fixed) AS FxdPortnOfPlanPrcInCoCodeCrcy
FROM ckmlpr AS pr
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 v_mbew_md AS m ON /* join condition not captured in parsed metadata */
INNER JOIN t001k AS tk 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 ckmlcr AS cr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialLedgerPrice AS FUTURE ON /* join condition not captured in parsed metadata */
INNER JOIN t001k AS t ON /* join condition not captured in parsed metadata */
INNER JOIN fmlv_curtp_ml AS curtp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON hd.pspnr = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _STDPR ON _STDPR.CostEstimate = price.CostEstimate AND _STDPR.Ledger = price.Ledger AND _STDPR.CurrencyRole = price.CurrencyRole AND _STDPR.CompanyCode = price.CompanyCode AND _STDPR.ValuationArea = price.ValuationArea AND _STDPR.MaterialPriceType = 'STDPR' AND _STDPR.MaterialPriceSubtype = '' AND _STDPR.MatlPrcValdtyStrtFsclYearPerd <= price.MatlPrcValdtyStrtFsclYearPerd AND _STDPR.MatlPrcValdtyEndFsclYearPeriod >= price.MatlPrcValdtyEndFsclYearPeriod  -- 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.CompanyCode = price.CompanyCode AND _ACT.ValuationArea = price.ValuationArea 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.CompanyCode = price.CompanyCode AND _MAP.ValuationArea = price.ValuationArea AND _MAP.MaterialPriceType = 'MAP' AND _MAP.MaterialPriceSubtype = '' AND _MAP.MatlPrcValdtyStrtFsclYearPerd <= price.MatlPrcValdtyStrtFsclYearPerd AND _MAP.MatlPrcValdtyEndFsclYearPeriod >= price.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _FSTDCE ON _FSTDCE.CostEstimate = price.CostEstimate AND _FSTDCE.CurrencyRole = price.CurrencyRole AND _FSTDCE.Ledger = price.Ledger AND _FSTDCE.CompanyCode = price.CompanyCode AND _FSTDCE.ValuationArea = price.ValuationArea AND _FSTDCE.MaterialPriceType = 'FSTDCE' AND _FSTDCE.MaterialPriceSubtype = '' AND _FSTDCE.MatlPrcValdtyStrtFsclYearPerd = price.MatlPrcValdtyStrtFsclYearPerd  -- association [0..1]
-- UNION ALL with additional select branch(es): I_MaterialLedgerPrice, v_mbew_md
;