I_FACTORYCALWORKINGDAYSPERYR

CDS View

Factory Calendar Working Days Per Year

I_FACTORYCALWORKINGDAYSPERYR is a CDS View in S/4HANA. Factory Calendar Working Days Per Year. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PL_ExcessDelayFcCalMonBitMp view_entity from COMPOSITE Gets Bit Map of Base net due date for two following monts
P_WrkCtrWorkDays view_entity inner COMPOSITE Work Days of a Factory Calendar

Fields (2)

KeyField CDS FieldsUsed in Views
KEY CalendarYear CalendarYear 1
KEY FactoryCalendar FactoryCalendar 2 
@AbapCatalog.sqlViewName: 'IFCTRYCALWD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Factory Calendar Working Days Per Year'
@AccessControl.authorizationCheck: #NOT_REQUIRED  
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #BASIC  
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:#CUSTOMIZING
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@ObjectModel.representativeKey: 'FactoryCalendar'
@Analytics:{ dataExtraction: { enabled : true  }}
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]

define view I_FactoryCalWorkingDaysPerYr as select from tfacs as fcal 
association [0..1] to I_CalendarYear as _CalendarYear on $projection.CalendarYear = _CalendarYear.CalendarYear
{
//TFACS

key ident as FactoryCalendar,
 @ObjectModel.foreignKey.association: '_CalendarYear'
key jahr as CalendarYear,
cast(fcal.mon01 as tamon01 preserving type) as Month01WorkingDaysString,
cast(fcal.mon02 as tamon02 preserving type) as Month02WorkingDaysString,
cast(fcal.mon03 as tamon03 preserving type) as Month03WorkingDaysString,
cast(fcal.mon04 as tamon04 preserving type) as Month04WorkingDaysString,
cast(fcal.mon05 as tamon05 preserving type) as Month05WorkingDaysString,
cast(fcal.mon06 as tamon06 preserving type) as Month06WorkingDaysString,
cast(fcal.mon07 as tamon07 preserving type) as Month07WorkingDaysString,
cast(fcal.mon08 as tamon08 preserving type) as Month08WorkingDaysString,
cast(fcal.mon09 as tamon09 preserving type) as Month09WorkingDaysString,
cast(fcal.mon10 as tamon10 preserving type) as Month10WorkingDaysString,
cast(fcal.mon11 as tamon11 preserving type) as Month11WorkingDaysString,
cast(fcal.mon12 as tamon12 preserving type) as Month12WorkingDaysString,
basis as FactoryCalYearStartDayValue,
fenum as NumberOfNonWorkingDays,
wenum as NumberOfWorkingDays,
 // Associations

      _CalendarYear
}

Learn More