I_SchedulingWorkingTime

DDL: I_SCHEDULINGWORKINGTIME SQL: ISCHDWT Type: view BASIC

Scheduling Working Time

I_SchedulingWorkingTime is a Basic CDS View that provides data about "Scheduling Working Time" in SAP S/4HANA. It reads from 1 data source (ttstr) and exposes 4 fields with key fields SchedulingWorkingTimeType, SchedulingWorkingTimeID, SchedulingCalendar. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
ttstr ttstr from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SchedulingWorkingTimeText _Text $projection.SchedulingWorkingTimeType = _Text.SchedulingWorkingTimeType and $projection.SchedulingWorkingTimeID = _Text.SchedulingWorkingTimeID and $projection.SchedulingCalendar = _Text.SchedulingCalendar

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISCHDWT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Scheduling Working Time view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.representativeKey SchedulingWorkingTimeID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SchedulingWorkingTimeType tstrtype
KEY SchedulingWorkingTimeID tstreamid
KEY SchedulingCalendar calendarid
_Text _Text 
@AbapCatalog.sqlViewName: 'ISCHDWT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Scheduling Working Time'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'SchedulingWorkingTimeID'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
define root view I_SchedulingWorkingTime
  as select from ttstr
  association [0..*] to I_SchedulingWorkingTimeText as _Text on  $projection.SchedulingWorkingTimeType = _Text.SchedulingWorkingTimeType
                                                             and $projection.SchedulingWorkingTimeID   = _Text.SchedulingWorkingTimeID
                                                             and $projection.SchedulingCalendar        = _Text.SchedulingCalendar
{
      @ObjectModel.text.association: '_Text'
  key tstrtype   as SchedulingWorkingTimeType,
  key tstreamid  as SchedulingWorkingTimeID,
  key calendarid as SchedulingCalendar,

      _Text
}
where
  (
        tstrtype = 'TS'
    and tbgen    = 'TTSTRSD'
  )
  or    fbgen    = '/SAPAPO/TIMESTREAM_COMPILE'

Learn More