I_InvtryPrcBasicByKeyDate

DDL: I_INVTRYPRCBASICBYKEYDATE SQL: IINVENPRCBYDATE Type: view COMPOSITE Package: FINS_ML_VDM

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. Part of development package FINS_ML_VDM.

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
}

Learn More