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.CostEstimate AS CostEstimate,
  invprice.CurrencyRole AS CurrencyRole,
  invprice.Ledger AS Ledger,
  dp.FiscalPeriod AS FiscalPeriod,
  cast( dp.FiscalYear as fins_gjahr ) AS FiscalYear,
  dp.FiscalYearPeriod AS FiscalYearPeriod,
  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,
  invprice.CompanyCode AS CompanyCode,
  invprice.ValuationQuantityUnit AS BaseUnit,
  hd.sobkz AS InventorySpecialStockType,
  hd.kzbws AS InventorySpecialStockValnType,
  hd.xobew AS IsSupplierStockValuation,
  hd.mlast AS PriceDeterminationControl,
  invprice.MaterialPriceControl AS MaterialPriceControl,
  invprice.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  invprice.Currency AS Currency,
  cast( invprice.MaterialPrice as fml_inventory_price ) AS InventoryPrice,
  cast( _ActualPrice.MaterialPrice as fml_actual_price ) AS ActualPrice,
  _CurrencyInfo.LedgerName AS LedgerName,
  _CurrencyInfo.CurrencyRoleName AS CurrencyRoleName,
  _CurrencyInfo.LegalCurrencyRole AS LegalCurrencyRole,
  _CurrencyInfo.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  cast(_CurrencyInfo.AccountingValuationView as fins_valutyp) AS AccountingValuationView,
  _CurrencyInfo.AcctgValnVwSubviewCombinedName AS AcctgValnVwSubviewCombinedName,
  _MLCurrencyInfo.LedgerValnCrcyRoleIsUsedInLogs AS LedgerValnCrcyRoleIsUsedInLogs
FROM I_MaterialLedgerPrice AS invprice
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]
;