P_CATS_CALENDARDATE_3MONTH

DDL: P_CATS_CALENDARDATE_3MONTH SQL: PCATSCALDATE3 Type: view COMPOSITE

CATS: Three month dates

P_CATS_CALENDARDATE_3MONTH is a Composite CDS View that provides data about "CATS: Three month dates" in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 19 fields with key field CalendarDate.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Parameters (1)

NameTypeDefault
P_Date datum

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCATSCALDATE3 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label CATS: Three month dates view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate CalendarDate
CalendarYear CalendarYear
CalendarQuarter CalendarQuarter
CalendarMonth CalendarMonth
CalendarWeek CalendarWeek
CalendarDay CalendarDay
YearMonth YearMonth
YearQuarter YearQuarter
YearWeek YearWeek
WeekDay WeekDay
FirstDayOfWeekDate FirstDayOfWeekDate
FirstDayOfMonthDate FirstDayOfMonthDate
CalendarDayOfYear CalendarDayOfYear
YearDay YearDay
_CalendarMonth _CalendarMonth
_CalendarQuarter _CalendarQuarter
_CalendarYear _CalendarYear
_WeekDay _WeekDay
_YearMonth _YearMonth 
@AbapCatalog.sqlViewName: 'PCATSCALDATE3'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
@EndUserText.label: 'CATS: Three month dates'
define view P_CATS_CALENDARDATE_3MONTH
  with parameters
    P_Date : datum
  as select from I_CalendarDate
{
  key CalendarDate,
      CalendarYear,
      CalendarQuarter,
      CalendarMonth,
      CalendarWeek,
      CalendarDay,
      YearMonth,
      YearQuarter,
      YearWeek,
      WeekDay,
      FirstDayOfWeekDate,
      FirstDayOfMonthDate,
      CalendarDayOfYear,
      YearDay,
      /* Associations */
      _CalendarMonth,
      _CalendarQuarter,
      _CalendarYear,
      _WeekDay,
      _YearMonth
}
where CalendarDate between concat( substring( DATS_ADD_MONTHS( :P_Date, - 2, 'UNCHANGED' ), 1, 6 ), '01' ) 
  and DATS_ADD_DAYS( cast( concat( substring( DATS_ADD_MONTHS( :P_Date, 1, 'UNCHANGED' ), 1, 6 ), '01' ) as abap.dats ), - 1, 'UNCHANGED' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[
"I_CALENDARMONTH",
"I_CALENDARQUARTER",
"I_CALENDARYEAR",
"I_WEEKDAY",
"I_YEARMONTH"
],
"BASE":
[
"I_CALENDARDATE"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More