I_FACTORYCALENDAR

CDS View

Factory Calendar

I_FACTORYCALENDAR is a CDS View in S/4HANA. Factory Calendar. It contains 1 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 1 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_FactoryCalendarValueHelp view from CONSUMPTION Factory Calendar Value help
C_FactoryCalWeekendPostingVH view from CONSUMPTION Factory Calendar VH Excl Spcl Rules
C_InvoiceDatesVHTemp view from CONSUMPTION Value Help for Invoice Dates
I_CmmdtyHedgeFactoryCalendar view inner COMPOSITE Factory Calendar Dates
I_SetlMgmtSchedgWlCalendarIDVH view_entity from BASIC Schedg Worklist Calendar ID

Fields (1)

KeyField CDS FieldsUsed in Views
KEY FactoryCalendar FactoryCalendar 2 
@AbapCatalog.sqlViewName: 'IPPFACTORYCAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'FactoryCalendar'
@ObjectModel.semanticKey: 'FactoryCalendar'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #ORGANIZATIONAL}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Factory Calendar'
@ClientHandling.type: #INHERITED
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@Analytics:{ dataExtraction: { enabled : true  }}
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]



define view I_FactoryCalendar
  as select from tfacd as fcal
  association [0..*] to I_FactoryCalendarText as _Text              on $projection.FactoryCalendar = _Text.FactoryCalendar
  association [0..1] to I_CalendarYear        as _ValidityStartYear on $projection.ValidityStartYear = _ValidityStartYear.CalendarYear
  association [0..1] to I_CalendarYear        as _ValidityEndYear   on $projection.ValidityEndYear = _ValidityEndYear.CalendarYear

{
      @ObjectModel.text.association: '_Text'
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key cast(fcal.ident as cr_wfcid preserving type)  as FactoryCalendar,
      cast(fcal.hocid as hident preserving type)    as PublicHolidayCalendar,
      @Semantics.calendar.year: true
      cast(fcal.vjahr as pph_vjahr preserving type) as ValidityStartYear,
      @Semantics.calendar.year: true
      cast(fcal.bjahr as pph_bjahr preserving type) as ValidityEndYear,

      // Admin

      @Semantics.systemDate.createdAt: true
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'LastChangeDate'
      cast(fcal.crdat  as erdat preserving type)    as CreationDate,
      @Semantics.systemTime.createdAt: true
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'LastChangeTime'
      cast(fcal.crtime as erzet preserving type)    as CreationTime,
      cast(fcal.motag as tamotag preserving type)   as MondayIsWorkingDay,
      cast(fcal.ditag as taditag preserving type)   as TuesdayIsWorkingDay,
      cast(fcal.miwch as tamiwch preserving type)   as WednesdayIsWorkingDay,
      cast(fcal.dotag as tadotag preserving type)   as ThursdayIsWorkingDay,
      cast(fcal.frtag as tafrtag preserving type)   as FridayIsWorkingDay,
      cast(fcal.satag as tasatag preserving type)   as SaturdayIsWorkingDay,
      cast(fcal.sotag as tasotag preserving type)   as SundayIsWorkingDay,
      cast(fcal.fetag as tafetag preserving type)   as HolidayIsWorkingDay,
      basis                                         as FactoryCalendarStartDayValue,
      @Semantics.systemDate.lastChangedAt: true
      cast(fcal.crdat as laeda preserving type)     as LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      crtime                                        as LastChangeTime,
      cast(fcal.interv as tainterv preserving type) as FactoryCalSpclRulesAreExisting,

      // Associations

      _Text,
      _ValidityStartYear,
      _ValidityEndYear
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TFACD"
],
"ASSOCIATED":
[
"I_CALENDARYEAR",
"I_FACTORYCALENDARTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More