I_YearMonthDateTime

DDL: I_YEARMONTHDATETIME Type: view COMPOSITE

Year Month with Timestamps

I_YearMonthDateTime is a Composite CDS View (Dimension) that provides data about "Year Month with Timestamps" in SAP S/4HANA. It reads from 1 data source (I_YearMonth).

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
I_YearMonth I_YearMonth from

Annotations (12)

NameValueLevelField
EndUserText.label Year Month with Timestamps view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey YearMonth view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IYEARMONTHDTETME view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view 
@EndUserText:   {label:              'Year Month with Timestamps'}
@Analytics:     {dataCategory:       #DIMENSION,
                 internalName:       #LOCAL}
@ObjectModel:   {representativeKey:  'YearMonth',
                 usageType:          {serviceQuality: #A,
                                      sizeCategory:   #S,
                                      dataClass:      #CUSTOMIZING}}
@VDM:           {viewType:           #COMPOSITE}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'IYEARMONTHDTETME'}
@AccessControl: {authorizationCheck: #NOT_REQUIRED}                 
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_YearMonthDateTime
  as select from I_YearMonth
{
      @Semantics.calendar.yearMonth: true
  key YearMonth,
      //      @ObjectModel.foreignKey.association:  '_CalendarMonth'

      //      @Semantics.calendar.month: true  --> NUMC 2 oder yearmonth NUMC 6 ?

      CalendarMonth,
      //*    @ObjectModel.foreignKey.association:  '_CalendarYear'

      @Semantics.calendar.year: true
      CalendarYear,
      //      @ObjectModel.foreignKey.association:  '_CalendarQuarter'

      @Semantics.calendar.quarter: true
      CalendarQuarter,
      IsLeapYear                                                                                                                   as IsLeapYear,
      NumberOfDays,
      FirstDayOfMonthDate,
      LastDayOfMonthDate,
      HalfYear,

      cast(cast(cast(concat(FirstDayOfMonthDate, '000000') as abap.numc(15)) as abap.dec(15,0)) as /scmtms/vdm_month_begin_dtetme preserving type) as StartOfMonthDateTime,
      cast(cast(cast(case
          when CalendarMonth = '01'
              then concat(concat(YearMonth, '31'), '235959')
          when CalendarMonth = '02' and IsLeapYear <> 'X'
              then concat(concat(YearMonth, '28'), '235959')
          when CalendarMonth = '02' and IsLeapYear = 'X'
              then concat(concat(YearMonth, '29'), '235959')
          when CalendarMonth = '03'
              then concat(concat(YearMonth, '31'), '235959')
          when CalendarMonth = '04'
              then concat(concat(YearMonth, '30'), '235959')
          when CalendarMonth = '05'
              then concat(concat(YearMonth, '31'), '235959')
          when CalendarMonth = '06'
              then concat(concat(YearMonth, '30'), '235959')
          when CalendarMonth = '07'
              then concat(concat(YearMonth, '31'), '235959')
          when CalendarMonth = '08'
              then concat(concat(YearMonth, '31'), '235959')
          when CalendarMonth = '09'
              then concat(concat(YearMonth, '30'), '235959')
          when CalendarMonth = '10'
              then concat(concat(YearMonth, '31'), '235959')
          when CalendarMonth = '11'
              then concat(concat(YearMonth, '30'), '235959')
          when CalendarMonth = '12'
              then concat(concat(YearMonth, '31'), '235959')
          else '000000000000'
      end as abap.numc(15)) as abap.dec(15,0)) as /scmtms/vdm_month_end_dtetme preserving type)                                                    as EndOfMonthDateTime,

      /* Associations */
      //*    _CalendarYear,

      _CalendarMonth,
      _CalendarQuarter
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_YEARMONTH"
],
"ASSOCIATED":
[
"I_CALENDARMONTH",
"I_CALENDARQUARTER"
],
"BASE":
[
"I_YEARMONTH"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More