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.

CREATE VIEW P_Matval_Manage_Ckml AS
SELECT
  price.CostEstimate AS CostEstimate,
  lvcr.LedgerValuationCurrencyRole AS LedgerValuationCurrencyRole,
  INVPR.MatlPrcValidityStartFiscalYear AS FiscalYear,
  INVPR.MatlPrcValdtyStartFiscalPeriod AS FiscalPeriod,
  price.ValuationArea AS ValuationArea,
  price.Material AS Material,
  price.InventoryValuationType AS InventoryValuationType,
  price.InvtryValnSpecialStockType AS InvtryValnSpecialStockType,
  hd.SalesOrder AS SalesOrder,
  hd.SalesOrderItem AS SalesOrderItem,
  hd.Supplier AS Supplier,
  hd.WBSElementInternalID AS WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  INVPR.MatlPrcValdtyStrtFsclYearPerd AS FiscalYearPeriod,
  hd.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  hd.PriceDeterminationControl AS PriceDeterminationControl,
  price.MaterialPrice AS FuturePrice,
  price.MaterialPriceValidityStartDate AS FuturePriceValidityStartDate,
  _FSTDCE.MaterialPrice AS FuturePlannedPrice,
  INVPR.MaterialPriceControl AS MaterialPriceControl,
  price.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  case INVPR.MaterialPriceControl when 'S' then case hd.PriceDeterminationControl when '2' then coalesce(_MAP.MaterialPrice,abap.curr'0.00') when '3' then coalesce(_ACT.MaterialPrice,abap.curr'0.00') end when 'V' then coalesce(INVPR.MaterialPrice,abap.curr'0.00') end as MovingAveragePrice AS 00endasMovingAveragePrice,
  case INVPR.MaterialPriceControl when 'S' then coalesce(INVPR.MaterialPrice,abap.curr'0.00') else coalesce(_STDPR.MaterialPrice,abap.curr'0.00') end as StandardPrice AS 00endasStandardPrice,
  price.Currency AS Currency
FROM I_MaterialLedgerPrice AS price
INNER JOIN R_MatlLedgerValnCrcyRole AS lvcr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialLedgerPrice AS INVPR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlValnSemKeyMappg AS hd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON hd.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _STDPR ON price.CostEstimate = _STDPR.CostEstimate AND price.Ledger = _STDPR.Ledger AND price.CurrencyRole = _STDPR.CurrencyRole AND price.CompanyCode = _STDPR.CompanyCode AND price.ValuationArea = _STDPR.ValuationArea AND _STDPR.MaterialPriceType = 'STDPR' AND _STDPR.MaterialPriceSubtype = '' AND _STDPR.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd AND _STDPR.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _ACT ON _ACT.CostEstimate = INVPR.CostEstimate AND _ACT.CurrencyRole = INVPR.CurrencyRole AND _ACT.Ledger = INVPR.Ledger AND _ACT.CompanyCode = INVPR.CompanyCode AND _ACT.ValuationArea = INVPR.ValuationArea AND _ACT.MaterialPriceType = 'ACT' AND _ACT.MaterialPriceSubtype = 'ACT' AND _ACT.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd AND _ACT.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _MAP ON _MAP.CostEstimate = INVPR.CostEstimate AND _MAP.CurrencyRole = INVPR.CurrencyRole AND _MAP.Ledger = INVPR.Ledger AND _MAP.CompanyCode = INVPR.CompanyCode AND _MAP.ValuationArea = INVPR.ValuationArea AND _MAP.MaterialPriceType = 'MAP' AND _MAP.MaterialPriceSubtype = '' AND _MAP.MatlPrcValdtyStrtFsclYearPerd <= INVPR.MatlPrcValdtyStrtFsclYearPerd AND _MAP.MatlPrcValdtyEndFsclYearPeriod >= INVPR.MatlPrcValdtyEndFsclYearPeriod  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPrice AS _FSTDCE ON _FSTDCE.CostEstimate = INVPR.CostEstimate AND _FSTDCE.CurrencyRole = INVPR.CurrencyRole AND _FSTDCE.Ledger = INVPR.Ledger AND _FSTDCE.CompanyCode = INVPR.CompanyCode AND _FSTDCE.ValuationArea = INVPR.ValuationArea AND _FSTDCE.MaterialPriceType = 'FSTDCE' AND _FSTDCE.MaterialPriceSubtype = '' AND _FSTDCE.MatlPrcValdtyStrtFsclYearPerd = INVPR.MatlPrcValdtyStrtFsclYearPerd  -- association [0..1]
;