P_Index

DDL: P_INDEX SQL: PVINDEX Type: view CONSUMPTION

P_Index is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_YearMonth) and exposes 1 field with key field CurrencyIndex.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_YearMonth I_YearMonth from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PVINDEX view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY CurrencyIndex CalendarMonth 
@AbapCatalog.sqlViewName: 'PVINDEX'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_Index as select from I_YearMonth {
  
  key CalendarMonth as CurrencyIndex
  
}
where CalendarYear = '1900'
and CalendarMonth <= '10' 
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_YEARMONTH"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More