P_PL_ExcessDelayFcCalMonBitMp

DDL: P_PL_EXCESSDELAYFCCALMONBITMP SQL: PEDGETFCBITMP Type: view_entity COMPOSITE Package: GLO_FIN_IS_PL

Gets Bit Map of Base net due date for two following monts

P_PL_ExcessDelayFcCalMonBitMp is a Composite CDS View that provides data about "Gets Bit Map of Base net due date for two following monts" in SAP S/4HANA. It reads from 2 data sources (I_FactoryCalWorkingDaysPerYr, I_YearMonth) and exposes 3 fields with key fields FactoryCalendar, CalendarYear, CalendarMonth. Part of development package GLO_FIN_IS_PL.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_FactoryCalWorkingDaysPerYr FactoryCalWorkingDaysPerYr from
I_YearMonth Months cross

Annotations (6)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY FactoryCalendar I_FactoryCalWorkingDaysPerYr FactoryCalendar
KEY CalendarYear I_FactoryCalWorkingDaysPerYr CalendarYear
KEY CalendarMonth I_YearMonth CalendarMonth 
//@AbapCatalog.sqlViewName: 'PEDGETFCBITMP'

//@AbapCatalog.compiler.compareFilter: true

@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@EndUserText.label: 'Get Bit Map of Base Due Date for 2 monts'

define view entity P_PL_ExcessDelayFcCalMonBitMp
  as select from I_FactoryCalWorkingDaysPerYr as FactoryCalWorkingDaysPerYr
  cross join I_YearMonth as Months
{
    key FactoryCalWorkingDaysPerYr.FactoryCalendar    as  FactoryCalendar,
    key FactoryCalWorkingDaysPerYr.CalendarYear       as  CalendarYear,
    key Months.CalendarMonth                          as  CalendarMonth,

    case
      when Months.CalendarMonth = '01'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month01WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month02WorkingDaysString)
      when Months.CalendarMonth = '02'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month02WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month03WorkingDaysString)
      when Months.CalendarMonth = '03'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month03WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month04WorkingDaysString)
      when Months.CalendarMonth = '04'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month04WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month05WorkingDaysString)
      when Months.CalendarMonth = '05'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month05WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month06WorkingDaysString)
      when Months.CalendarMonth = '06'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month06WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month07WorkingDaysString)
      when Months.CalendarMonth = '07'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month07WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month08WorkingDaysString)
      when Months.CalendarMonth = '08'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month08WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month09WorkingDaysString)
      when Months.CalendarMonth = '09'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month09WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month10WorkingDaysString)
      when Months.CalendarMonth = '10'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month10WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month11WorkingDaysString)
      when Months.CalendarMonth = '11'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month11WorkingDaysString,
            FactoryCalWorkingDaysPerYr.Month12WorkingDaysString)
      when Months.CalendarMonth = '12'
        then
          concat(
            FactoryCalWorkingDaysPerYr.Month12WorkingDaysString,
            '0111111111111111111111111111111')
      else '11111111111111111111111111111111111111111111111111111111111111'
    end as CalendarMonthBitMap
}
where FactoryCalWorkingDaysPerYr.FactoryCalendar = 'PL'
  and Months.YearMonth >= '200000'
  and Months.YearMonth <= '200012'

Learn More