I_InventoryPriceByKeyDate
Inventory Price By KeyDate
I_InventoryPriceByKeyDate (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 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 31 fields with key fields CostEstimate, 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 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.
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.
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 provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What is (or was) the valid inventory price of a material on a particular date?</p></li> </ul> |
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 (14)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #COMPOSITE | view | |
| Analytics.dataCategory | #CUBE | view | |
| Analytics.technicalName | IINVPRKEYDATE | 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 | |
| ObjectModel.representativeKey | CostEstimate | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | I_InventoryPriceByKeyDate_2 | view |
Fields (31)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CostEstimate | CostEstimate | Cost Estimate Number for Cost Est. w/o Qty Structure | |
| KEY | CurrencyRole | CurrencyRole | External Currency Type and Valuation View | |
| Ledger | Ledger | Ledger in General Ledger Accounting | ||
| 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 | ||
| 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 | Valuation View | |||
| 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.
-- 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 AS
SELECT
CostEstimate,
CurrencyRole,
Ledger,
FiscalPeriod,
FiscalYear,
FiscalYearPeriod,
Material,
ValuationArea,
InventoryValuationType,
SalesOrder,
SalesOrderItem,
Supplier,
WBSElementInternalID,
CompanyCode,
BaseUnit,
InventorySpecialStockType,
MaterialPriceControl,
MaterialPriceUnitQty,
Currency,
InventoryPrice,
StandardPrice,
ActualPrice,
LedgerName,
CurrencyRoleName,
LegalCurrencyRole,
LegalCurrencyRoleName,
cast(AccountingValuationView as fins_valutyp) AS 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]
;Learn More
- S/4HANA CDS View Deprecation: What You Need to Know
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA