I_YEARMONTH

CDS View

Year Month

I_YEARMONTH is a CDS View in S/4HANA. Year Month. It contains 1 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 1 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_SalesInsightYearMonthVH view from CONSUMPTION Sales Insight: Year Month Value Help
I_TeamCatsHoursTile view left_outer COMPOSITE Team Recorded Hours for the Last Three Months
I_YearMonthDateTime view from COMPOSITE Year Month with Timestamps
P_ARCalendarMnthTxt view inner COMPOSITE
P_GLEffectivityCalendar view inner COMPOSITE
P_Index view from CONSUMPTION
P_RSHStaffingRequestDatePeriod view from COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
KEY YearMonth CalendarYearMonth,YearMonth 2 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.representativeKey: 'YearMonth'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.sqlViewName: 'IYEARMONTH'
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Year Month'
@Analytics : {dataCategory: #DIMENSION, dataExtraction.enabled : true}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations:true

define view I_YearMonth
  as select from scal_tt_month as month
    inner join   scal_tt_year  as year on month.calendaryear = year.calendaryear
  association [0..1] to I_CalendarMonth   as _CalendarMonth   on $projection.CalendarMonth = _CalendarMonth.CalendarMonth
  association [1..1] to I_CalendarQuarter as _CalendarQuarter on $projection.CalendarQuarter = _CalendarQuarter.CalendarQuarter
{
  key month.yearmonth           as YearMonth,
      @ObjectModel.foreignKey.association:  '_CalendarMonth'
      month.calendarmonth       as CalendarMonth,

      month.calendaryear        as CalendarYear,
      @ObjectModel.foreignKey.association:  '_CalendarQuarter'
      month.calendarquarter     as CalendarQuarter,
      year.isleapyear           as IsLeapYear,
      month.numberofdays        as NumberOfDays,
      month.firstdayofmonthdate as FirstDayOfMonthDate,
      month.lastdayofmonthdate  as LastDayOfMonthDate,
      month.halfyear            as HalfYear,
      _CalendarMonth,
      _CalendarQuarter
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SCAL_TT_MONTH",
"SCAL_TT_YEAR"
],
"ASSOCIATED":
[
"I_CALENDARMONTH",
"I_CALENDARQUARTER"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More