What is I_InventoryPriceByKeyDate_2 in SAP S/4HANA?

I_InventoryPriceByKeyDate_2 is a composite CDS view in SAP S/4HANA. Inventory Price By KeyDate It contains 32 fields.

Which tables does I_InventoryPriceByKeyDate_2 read from?

I_InventoryPriceByKeyDate_2 reads data from: R_InventoryPriceByKeyDate.

What VDM layer is I_InventoryPriceByKeyDate_2?

I_InventoryPriceByKeyDate_2 is classified as a Composite view that combines data from multiple basic views.

I_InventoryPriceByKeyDate_2

DDL: I_INVENTORYPRICEBYKEYDATE_2 Type: view_entity COMPOSITE Package: FINS_ML_VDM

32 Fields 1 Data Sources 2 Associations

Inventory Price By KeyDate

I_InventoryPriceByKeyDate_2 (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_InventoryPriceByKeyDate_2 is a Composite CDS View (Cube) that provides data about "Inventory Price By KeyDate" in SAP S/4HANA. It reads from 1 data source (R_InventoryPriceByKeyDate) and exposes 32 fields with key fields CostEstimate, Ledger, CurrencyRole. It has 2 associations to related views. Part of development package FINS_ML_VDM.

SAP Help Documentation

Category	CDS Views for Inventory Accounting
Data Category	Cube

Purpose
This CDS view is designed to provide analytical insights into inventory pricing based on a specified calendar date. It aggregates and presents data related to inventory valuation, including cost estimates, ledger information, currency roles, and various financial metrics associated with inventory items. 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
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Restriction Type ID Restriction Type BUKRS_GLRLDNR_GLRRCTY_GLRVERS Company Code/Ledger/Record Type/Version BWKEY Valuation Area You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Parameters The parameters of the CDS view are as follows: Parameter Name Label P_CalendarDate Calendar Date Important Fields Important fields in this view include the following: Field Name Label CostEstimate Cost EstimateNo Ledger Ledger CurrencyRole Currency/Valuation FiscalPriod Fiscal Period FiscalYear Fiscal Year FiscalYearPeriod Fiscal Year Period Material Material ValuationArea Valuation Area InventoryValuationType Valuation Type SalesOrder SD Document SalesOrderItem Item (SD) Supplier Supplier WBSElementInternalID WBS Element Internal ID CompanyCode Company Code ValuationQuantityUnit Valuation Unit BaseUnit Valuation Unit InventorySpecialStockType Special Stock MaterialPriceControl Price Control MaterialPriceUnitQty Price Unit Currency Currency InventoryPrice Inventory Price StandardPrice Standard Price ActualPrice Actual Price LedgerName Ledger Name CurrencyRoleName Crcy Type Desc. LegalCurrencyRole Currency Type LegalCurrencyRoleName Legal Currency Type AccountingValuationView Valuation View AcctgValnVwSubviewCombinedName Valuation View Name LedgerValnCrcyRoleIsUsedInLogs Is Log. Curr. Type

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Accounting and Financial Close
Application Component	CO-PC-ML-2CL
Capabilities	Data Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view is designed to provide analytical insights into inventory pricing based on a specified calendar date. It aggregates and presents data related to inventory valuation, including cost estimates, ledger information, currency roles, and various financial metrics associated with inventory items.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What is the valid inventory price of a material at the end of the fiscal period?</p></li> </ul> <p>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.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
R_InventoryPriceByKeyDate	R_InventoryPriceByKeyDate	from

Parameters (1)

Name	Type	Default
P_CalendarDate	calendardate

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_CurrencyRole	_CurrencyRole	`$projection.CurrencyRole = _CurrencyRole.CurrencyRole`
[0..1]	I_Ledger	_Ledger	`$projection.Ledger = _Ledger.Ledger`

Annotations (13)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
Analytics.technicalName	IINVPRKEYDATE2	view
Analytics.internalName	#LOCAL	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#NOT_REQUIRED	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
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (32)

Key	Field	Source Field	Description
KEY	CostEstimate	CostEstimate	Cost Estimate Number for Cost Est. w/o Qty Structure
KEY	Ledger	Ledger	Ledger in General Ledger Accounting
KEY	CurrencyRole	CurrencyRole	External Currency Type and Valuation View
	FiscalPeriod	FiscalPeriod	Fiscal Period
	FiscalYear	FiscalYear	G/L Fiscal Year
	FiscalYearPeriod	FiscalYearPeriod	Fiscal Year + Fiscal Period
	Material	Material	Material Number
	ValuationArea	ValuationArea	Valuation Area
	InventoryValuationType	InventoryValuationType	Valuation Type
	SalesOrder	SalesOrder	Sales and Distribution Document Number
	SalesOrderItem	SalesOrderItem	Item number of the SD document
	Supplier	Supplier	Account Number of Supplier
	WBSElementInternalID	WBSElementInternalID	WBS Element Internal ID
	CompanyCode	CompanyCode	Receiver Company Code
	ValuationQuantityUnit	ValuationQuantityUnit	Valuation Unit of Measure
	BaseUnit	BaseUnit	Valuation Unit of Measure
	InventorySpecialStockType	InventorySpecialStockType	Special Stock Indicator
	MaterialPriceControl	MaterialPriceControl	Price Control Indicator
	MaterialPriceUnitQty	MaterialPriceUnitQty	Price unit
	Currency	Currency	Valuation Crcy
	InventoryPrice	InventoryPrice	Inventory Price
	StandardPrice	StandardPrice	Standard price
	ActualPrice	ActualPrice	Actual Price (for materials as calculated by Actual Costing)
	LedgerName	LedgerName	Ledger Name
	CurrencyRoleName	CurrencyRoleName	Currency Type Description
	LegalCurrencyRole	LegalCurrencyRole	Currency Type (Reference in Legal Valuation Ledger) for ML
	LegalCurrencyRoleName	LegalCurrencyRoleName	Legal Currency Type Description
	AccountingValuationView	AccountingValuationView	Valuation View (for Transfer Prices)
	AcctgValnVwSubviewCombinedName	AcctgValnVwSubviewCombinedName	Accounting Valuation View Name
	LedgerValnCrcyRoleIsUsedInLogs	LedgerValnCrcyRoleIsUsedInLogs	Indicator: currency type is used in logistic reporting
	_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_2.
-- 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.
-- Parameters: P_CalendarDate : calendardate

CREATE VIEW I_InventoryPriceByKeyDate_2 AS
SELECT
  CostEstimate,
  Ledger,
  CurrencyRole,
  FiscalPeriod,
  FiscalYear,
  FiscalYearPeriod,
  Material,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  WBSElementInternalID,
  CompanyCode,
  ValuationQuantityUnit,
  BaseUnit,
  InventorySpecialStockType,
  MaterialPriceControl,
  MaterialPriceUnitQty,
  Currency,
  InventoryPrice,
  StandardPrice,
  ActualPrice,
  LedgerName,
  CurrencyRoleName,
  LegalCurrencyRole,
  LegalCurrencyRoleName,
  AccountingValuationView,
  AcctgValnVwSubviewCombinedName,
  LedgerValnCrcyRoleIsUsedInLogs
FROM R_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]
;

Depth:

I_InventoryPriceByKeyDate_2 view_entity

R_InventoryPriceByKeyDate view_entity