P_Referencedates

DDL: P_REFERENCEDATES SQL: PDFREFDATES Type: view CONSUMPTION

P_Referencedates is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 3 fields.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Parameters (1)

NameTypeDefault
P_DateFunctionValidityDate sydats

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PDFREFDATES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
CalendarDate CalendarDate
LastYearDate
NextYearDate 
@AbapCatalog.sqlViewName: 'PDFREFDATES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
//@EndUserText.label: 'Calculate Last and Next Year for a date'

@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_Referencedates with parameters
    P_DateFunctionValidityDate: sydats
as select from I_CalendarDate
{

  CalendarDate,
  dats_add_months( CalendarDate, -12, 'FAIL') as LastYearDate,
  dats_add_months( CalendarDate, 12, 'FAIL')  as NextYearDate
}
where
  CalendarDate = $parameters.P_DateFunctionValidityDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More