I_WorkBreakSchedule

@AbapCatalog.sqlViewName: 'IPPWORKBREAKSCH'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.ranked: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #SEARCHABLE_ENTITY, #VALUE_HELP_PROVIDER]
@ObjectModel.representativeKey: 'WorkBreakSchedule'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Work Break Schedule'

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view I_WorkBreakSchedule
  as select distinct from tc37p as sched
  association [0..*] to I_WorkBreakScheduleText as _Text          on  $projection.WorkBreakSchedule = _Text.WorkBreakSchedule
  association [0..*] to I_WorkBreakScheduleText as _Text2         on  $projection.WorkBreakSchedule = _Text2.WorkBreakSchedule
                                                                  and $projection.ShiftGrouping     = _Text2.ShiftGrouping
  association [1..*] to I_WorkBreak             as _WorkBreak     on  $projection.WorkBreakSchedule = _WorkBreak.WorkBreakSchedule
  association [1..1] to I_ShiftGrouping         as _ShiftGrouping on  $projection.ShiftGrouping = _ShiftGrouping.ShiftGrouping
{
      @ObjectModel.foreignKey.association: '_ShiftGrouping'
  key sched.schgrup as ShiftGrouping,
      @ObjectModel.text.association: '_Text2'
      @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
  key sched.paplan  as WorkBreakSchedule,

      // Associations

      _ShiftGrouping,
      _WorkBreak,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: '_Text2'
      _Text,
      _Text2
};