P_InventoryPriceByKeydate

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_InventoryPriceByKeydate.
-- 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: PINVPRKEYDATE
-- Parameters: P_CalendarDate : calendardate

CREATE VIEW P_InventoryPriceByKeydate AS
SELECT
  invprice_old.CostEstimate AS CostEstimate,
  invprice_old.CurrencyRole AS CurrencyRole,
  invprice_old.Ledger AS Ledger,
  dp.FiscalPeriod AS FiscalPeriod,
  cast( dp.FiscalYear as fins_gjahr ) AS FiscalYear,
  invprice_old.Material AS Material,
  invprice_old.ValuationArea AS ValuationArea,
  invprice_old.InventoryValuationType AS InventoryValuationType,
  invprice_old.SalesOrder AS SalesOrder,
  invprice_old.SalesOrderItem AS SalesOrderItem,
  invprice_old.Supplier AS Supplier,
  invprice_old.WBSElementInternalID AS WBSElementInternalID,
  invprice_old.CompanyCode AS CompanyCode,
  invprice_old.BaseUnit AS BaseUnit,
  invprice_old.InventorySpecialStockType AS InventorySpecialStockType,
  invprice_old.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  invprice_old.IsSupplierStockValuation AS IsSupplierStockValuation,
  invprice_old.PriceDeterminationControl AS PriceDeterminationControl,
  invprice_old.MaterialPriceControl AS MaterialPriceControl,
  invprice_old.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  invprice_old.Currency AS Currency,
  invprice_old.InventoryPrice AS InventoryPrice,
  invprice_old.StandardPrice AS StandardPrice,
  case invprice_old.MaterialPriceControl when 'V' then coalesce(invprice_old.InventoryPrice, 0) else coalesce(invprice_old.MovingAveragePrice, 0) end as ActualPrice AS MovingAveragePrice0endasActualPrice,
  invprice_old.LedgerName AS LedgerName,
  invprice_old.CurrencyRoleName AS CurrencyRoleName,
  invprice_old.LegalCurrencyRole AS LegalCurrencyRole,
  invprice_old.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  invprice_old.AccountingValuationView AS AccountingValuationView,
  invprice_old.AcctgValnVwSubviewCombinedName AS AcctgValnVwSubviewCombinedName,
  case invprice.MaterialPriceControl when 'S' then coalesce(invprice.MaterialPrice, 0) else coalesce(_StandardPrice.MaterialPrice, 0) end as StandardPrice AS MaterialPrice0endasStandardPrice,
  _ActualPrice.MaterialPrice AS ActualPrice,
  _MLCurrencyInfo.LedgerValnCrcyRoleIsUsedInLogs AS LedgerValnCrcyRoleIsUsedInLogs
FROM P_InvPrice_Union_Old
INNER JOIN R_MatlPriceDataMigrationStatus AS tf 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_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.MaterialPriceValidityStartDate <= $parameters.P_CalendarDate AND _StandardPrice.MaterialPriceValidityEndDate >= $parameters.P_CalendarDate  -- 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.MaterialPriceValidityStartDate <= $parameters.P_CalendarDate AND _ActualPrice.MaterialPriceValidityEndDate >= $parameters.P_CalendarDate  -- association [0..1]
LEFT OUTER JOIN R_LedgerValuationCrcyRole AS _CurrencyInfo ON _CurrencyInfo.CurrencyRole = invprice.CurrencyRole AND _CurrencyInfo.Ledger = invprice.Ledger  -- association [0..1]
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _MLCurrencyInfo ON _MLCurrencyInfo.CompanyCode = invprice.CompanyCode AND _MLCurrencyInfo.CurrencyRole = invprice.CurrencyRole AND _MLCurrencyInfo.Ledger = invprice.Ledger  -- association [0..1]
-- UNION ALL with additional select branch(es): I_MaterialLedgerPrice
;