I_CurrentMatlValnPrice
Current Material Valuation Price
I_CurrentMatlValnPrice is a Composite CDS View that provides data about "Current Material Valuation Price" in SAP S/4HANA. It reads from 1 data source (P_CURRENTMATLVALNPRICE) and exposes 33 fields with key fields CostEstimate, Ledger, CurrencyRole. Part of development package FINS_ML_VDM.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_CURRENTMATLVALNPRICE | P_CURRENTMATLVALNPRICE | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Current Material Valuation Price | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (33)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CostEstimate | CostEstimate | ||
| KEY | Ledger | Ledger | ||
| KEY | CurrencyRole | CurrencyRole | ||
| Material | Material | |||
| ValuationArea | ValuationArea | |||
| InventoryValuationType | InventoryValuationType | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| Supplier | Supplier | |||
| WBSElementInternalID | WBSElementInternalID | |||
| WBSElementExternalID | WBSElementExternalID | |||
| InvtryValnSpecialStockType | InvtryValnSpecialStockType | |||
| InventorySpecialStockValnType | InventorySpecialStockValnType | |||
| IsSupplierStockValuation | IsSupplierStockValuation | |||
| CompanyCode | CompanyCode | |||
| PriceDeterminationControl | PriceDeterminationControl | |||
| MaterialPriceControl | MaterialPriceControl | |||
| MaterialPriceUnitQty | MaterialPriceUnitQty | |||
| Currency | Currency | |||
| MovingAveragePrice | MovingAveragePrice | |||
| StandardPrice | StandardPrice | |||
| InventoryPrice | InventoryPrice | |||
| FuturePrice | FuturePrice | |||
| FuturePriceValidityStartDate | FuturePriceValidityStartDate | |||
| PlannedPrice | PlannedPrice | |||
| FutrCostEstValuationVariant | FutrCostEstValuationVariant | |||
| FutureCostEstFiscalYear | FutureCostEstFiscalYear | |||
| FutureCostEstimateFiscalPeriod | FutureCostEstimateFiscalPeriod | |||
| FutureCostEstCostingVersion | FutureCostEstCostingVersion | |||
| FixedPortionOfPlannedPrice | FixedPortionOfPlannedPrice | |||
| LedgerName | LedgerName | |||
| CurrencyRoleName | CurrencyRoleName | |||
| LedgerValnCrcyRoleIsUsedInLogs | LedgerValnCrcyRoleIsUsedInLogs |
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Current Material Valuation Price'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view entity I_CurrentMatlValnPrice
as select from P_CURRENTMATLVALNPRICE
{
key CostEstimate,
@ObjectModel.text.element: ['LedgerName']
key Ledger,
@ObjectModel.text.element: ['CurrencyRoleName']
key CurrencyRole,
Material,
ValuationArea,
InventoryValuationType,
SalesOrder,
SalesOrderItem,
Supplier,
WBSElementInternalID,
@ObjectModel.text.element:null
WBSElementExternalID,
InvtryValnSpecialStockType,
InventorySpecialStockValnType,
IsSupplierStockValuation,
CompanyCode,
PriceDeterminationControl,
MaterialPriceControl,
MaterialPriceUnitQty,
Currency,
@Semantics.amount.currencyCode: 'Currency'
MovingAveragePrice,
@Semantics.amount.currencyCode: 'Currency'
StandardPrice,
@Semantics.amount.currencyCode: 'Currency'
InventoryPrice,
@Semantics.amount.currencyCode: 'Currency'
FuturePrice,
FuturePriceValidityStartDate,
@Semantics.amount.currencyCode: 'Currency'
PlannedPrice,
FutrCostEstValuationVariant,
FutureCostEstFiscalYear,
FutureCostEstimateFiscalPeriod,
FutureCostEstCostingVersion,
//FutrPlanProjSlsOrdValnStrategy,
@Semantics.amount.currencyCode: 'Currency'
FixedPortionOfPlannedPrice,
@Semantics.text:true
LedgerName,
@Semantics.text:true
CurrencyRoleName,
LedgerValnCrcyRoleIsUsedInLogs
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- 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