I_CurrentMatlValnPrice

DDL: I_CURRENTMATLVALNPRICE SQL: ICURMATLVALNPRC Type: view BASIC

Current Material Valuation Price

I_CurrentMatlValnPrice is a Basic 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.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
P_CURRENTMATLVALNPRICE P_CURRENTMATLVALNPRICE from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICURMATLVALNPRC view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE 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)

KeyFieldSource TableSource FieldDescription
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 
@AbapCatalog.sqlViewName: 'ICURMATLVALNPRC'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Current Material Valuation Price'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view 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,
                 WBSElementExternalID,
                 InvtryValnSpecialStockType,
                 InventorySpecialStockValnType,
                 IsSupplierStockValuation,
                 CompanyCode,

                 PriceDeterminationControl,
                 MaterialPriceControl,
                 MaterialPriceUnitQty,
                 Currency,
                 MovingAveragePrice,
                 StandardPrice,
                 InventoryPrice,

                 // CurrentPlanPrice,

                 FuturePrice,
                 FuturePriceValidityStartDate,
                 PlannedPrice,
                 FutrCostEstValuationVariant,
                 FutureCostEstFiscalYear,
                 FutureCostEstimateFiscalPeriod,
                 FutureCostEstCostingVersion,
                 //FutrPlanProjSlsOrdValnStrategy,

                 FixedPortionOfPlannedPrice,

                 LedgerName,
                 CurrencyRoleName,
//                 LegalCurrencyRole,

//                 LegalCurrencyRoleName,

//                 AccountingValuationView,

//                 AcctgValnVwSubviewCombinedName,

                 LedgerValnCrcyRoleIsUsedInLogs
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CURRENTMATLVALNPRICE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More