P_RBLSITMFORKEYDTEREPPERIOD

CDS View

P_RBLSITMFORKEYDTEREPPERIOD is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RblsItmForKeyDteDuePerd1 view from COMPOSITE
P_RblsItmForKeyDteDuePerd4A view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PRBLSKDATPERIO'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_RblsItmForKeyDteRepPeriod
  with parameters
    P_KeyDate    : bzdat,
    P_PeriodType : fis_period_type

  as select from I_FiscCalendarDateForCompCode as FiscalPeriod

  association [0..1] to I_CalendarDate as _CalendarDate on _CalendarDate.CalendarDate = $projection.CalendarDate

{
  key FiscalPeriod.CalendarDate,
  key FiscalPeriod.CompanyCode,

      case $parameters.P_PeriodType
           when 'F' then FiscalPeriod.FiscalYear
           when 'M' then _CalendarDate.CalendarYear
           when 'W' then _CalendarDate.CalendarYear
      end as ReportingYear,

      case $parameters.P_PeriodType
           when 'F' then FiscalPeriod.FiscalPeriod
           when 'M' then cast(_CalendarDate.CalendarMonth as char3)
           when 'W' then _CalendarDate.CalendarWeek
      end as ReportingPeriod,

      case $parameters.P_PeriodType
           when 'F' then FiscalPeriod.FiscalPeriodStartDate
           when 'M' then _CalendarDate.FirstDayOfMonthDate
           when 'W' then _CalendarDate.FirstDayOfWeekDate
      end as ReportingPeriodStartDate,

      case $parameters.P_PeriodType
           when 'F' then FiscalPeriod.FiscalPeriodEndDate
           when 'M' then dats_add_days(dats_add_months(_CalendarDate.FirstDayOfMonthDate, 1, 'UNCHANGED'), -1, 'UNCHANGED')
           when 'W' then dats_add_days(_CalendarDate.FirstDayOfWeekDate, 7, 'UNCHANGED')
      end as ReportingPeriodEndDate
}
where
  CalendarDate = $parameters.P_KeyDate

Learn More