I_InventoryPriceByKeyDate

DDL: I_INVENTORYPRICEBYKEYDATE SQL: IINVPRKEYDATE Type: view COMPOSITE
30 Fields 1 Data Sources 2 Associations

Inventory Price By KeyDate

I_InventoryPriceByKeyDate is a Composite CDS View (Cube) that provides data about "Inventory Price By KeyDate" in SAP S/4HANA. It reads from 1 data source (P_InventoryPriceByKeydate) and exposes 30 fields with key fields CostEstimate, CurrencyRole. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Inventory Accounting
Data CategoryCube
Purpose
This CDS view provides the inventory price determined for all materials at the end of a fiscal period related to the key date. If the end of the fiscal period has not been reached yet, the CDS view specifies the price determined for the current date. This CDS view provides the data to answer the following business questions: What is the valid inventory price of a material at the end of the fiscal period? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Users who want to use this CDS view must have the authorization to access the companies and valuation areas.

Structure
Main input parameters The main input parameters are: P_CalendarDate used to specify the date on which the inventory price is valid Measures and attributes Some important measures and attributes are: Currency Role Coded representation of the currency and valuation type. Material Material for which the price is to be displayed. Valuation Area Organizational unit responsible for the valuation of the material. Company Code Organizational unit for financial accounting to which the material is assigned. Inventory Valuation Type Subdivision of the valuation category in split valuation. Fiscal Period Accounting period in which the material price is valid. Fiscal Year Fiscal year in which the material price is valid. Inventory Price Price at which the material inventory is valued. Currency Currency of the material price. Material Price Unit Quantity Unit and quantity on which the material price is based. Base Unit Unit of measure in which the material inventory is managed.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
P_InventoryPriceByKeydate P_InventoryPriceByKeydate from

Parameters (1)

NameTypeDefault
P_CalendarDate calendardate

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CurrencyRole _CurrencyRole $projection.CurrencyRole = _CurrencyRole.CurrencyRole
[0..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IINVPRKEYDATE view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inventory Price By KeyDate view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CostEstimate view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate Cost EstimateNo
KEY CurrencyRole CurrencyRole Curr./Val. Type
Ledger Ledger Ledger
FiscalPeriod FiscalPeriod Tax period
FiscalYear FiscalYear G/L Fiscal Year
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
Supplier Supplier Supplier
WBSElementInternalID WBSElementInternalID WBS Internal ID
CompanyCode CompanyCode Receiver Company Code
BaseUnit BaseUnit Unit of Measure
InventorySpecialStockType InventorySpecialStockType Special Stock Type
MaterialPriceControl MaterialPriceControl Price Control
MaterialPriceUnitQty MaterialPriceUnitQty Price unit
Currency Currency Valuation Crcy
InventoryPrice InventoryPrice Price
StandardPrice StandardPrice Standard price
ActualPrice ActualPrice Inventory Price
LedgerName LedgerName Ledger Name
CurrencyRoleName CurrencyRoleName
LegalCurrencyRole LegalCurrencyRole
LegalCurrencyRoleName LegalCurrencyRoleName
AccountingValuationView AccountingValuationView
AcctgValnVwSubviewCombinedName AcctgValnVwSubviewCombinedName
LedgerValnCrcyRoleIsUsedInLogs LedgerValnCrcyRoleIsUsedInLogs Is Log. Curr. Type
_Ledger _Ledger
_CurrencyRole _CurrencyRole

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 I_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: IINVPRKEYDATE
-- Parameters: P_CalendarDate : calendardate

CREATE VIEW I_InventoryPriceByKeyDate AS
SELECT
  CostEstimate,
  CurrencyRole,
  Ledger,
  FiscalPeriod,
  FiscalYear,
  Material,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  WBSElementInternalID,
  CompanyCode,
  BaseUnit,
  InventorySpecialStockType,
  MaterialPriceControl,
  MaterialPriceUnitQty,
  Currency,
  InventoryPrice,
  StandardPrice,
  ActualPrice,
  LedgerName,
  CurrencyRoleName,
  LegalCurrencyRole,
  LegalCurrencyRoleName,
  AccountingValuationView,
  AcctgValnVwSubviewCombinedName,
  LedgerValnCrcyRoleIsUsedInLogs
FROM P_InventoryPriceByKeydate
LEFT OUTER JOIN I_CurrencyRole AS _CurrencyRole ON CurrencyRole = _CurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
;

Learn More