I_InvtryPrcBasicByKeyDate

DDL: I_INVTRYPRCBASICBYKEYDATE SQL: IINVENPRCBYDATE Type: view COMPOSITE

Basic view to display inventory Price at a specific date.

I_InvtryPrcBasicByKeyDate is a Composite CDS View that provides data about "Basic view to display inventory Price at a specific date." in SAP S/4HANA. It reads from 1 data source (P_InvPricesMaxFis) and exposes 5 fields with key field CostEstimate.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_InvPricesMaxFis P_InvPricesMaxFis from

Parameters (1)

NameTypeDefault
P_CalendarDate calendardate

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINVENPRCBYDATE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Basic view to display inventory Price at a specific date. view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate CostEstimate
ValuationArea ValuationArea
MaterialPriceUnitQty MaterialPriceUnitQty
Currency Currency
InventoryPrice InventoryPrice 
@AbapCatalog.sqlViewName: 'IINVENPRCBYDATE'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Basic view to display inventory Price at a specific date.'
//Basic view to display inventory Price at a specific date in local currency.

define view I_InvtryPrcBasicByKeyDate

  with parameters
    P_CalendarDate : calendardate

  as select from P_InvPricesMaxFis(P_CalendarDate : $parameters.P_CalendarDate) as it

{
  key  CostEstimate,
       ValuationArea,
       MaterialPriceUnitQty,
       Currency,
       InventoryPrice
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_INVPRICESMAXFIS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More