R_SetlMgmtSchedgWlRecurrenceTP

DDL: R_SETLMGMTSCHEDGWLRECURRENCETP Type: view_entity TRANSACTIONAL
27 Fields 1 Data Sources 6 Associations

Scheduling Worklist Recurrence - TP

R_SetlMgmtSchedgWlRecurrenceTP is a Transactional CDS View that provides data about "Scheduling Worklist Recurrence - TP" in SAP S/4HANA. It reads from 1 data source (R_SetlMgmtSchedgWlRecurrence) and exposes 27 fields with key field SettlmtMgmtSchedgWlUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SetlMgmtSchedgWlRecurrence R_SetlMgmtSchedgWlRecurrence from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_SetlMgmtSchedgWlPerdcGrnlty _PeriodicGranularity $projection.SetlMgmtSchedgWlPeriodicGrnlty = _PeriodicGranularity.SetlMgmtSchedgWlPeriodicGrnlty
[0..1] I_StlMnScdWlStrtRstrcnCode _StartRestrictionCode $projection.SetlMgmtSchedgWlStrtRstrcnCode = _StartRestrictionCode.SetlMgmtSchedgWlStrtRstrcnCode
[0..1] I_SetlMgmtSchedgWlShftDrctn _ShiftDirection $projection.SetlMgmtSchedgWlShiftDirection = _ShiftDirection.SetlMgmtSchedgWlShiftDirection
[0..1] I_SetlMgmtSchedgWlEndType _EndType $projection.SetlMgmtSchedgWlEndType = _EndType.SetlMgmtSchedgWlEndType
[0..1] I_SetlMgmtSchedgWlMonthWeek _MonthWeek $projection.SetlMgmtSchedgWlMonthWeek = _MonthWeek.SetlMgmtSchedgWlMonthWeek
[0..1] I_SetlMgmtSchedgWlCalendarIDVH _CalendarID $projection.SetlMgmtSchedgWlCalendarID = _CalendarID.SetlMgmtSchedgWlCalendarID

Annotations (8)

NameValueLevelField
EndUserText.label Scheduling Worklist Recurrence - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SettlmtMgmtSchedgWlUUID R_SetlMgmtSchedgWlRecurrence SettlmtMgmtSchedgWlUUID Scheduling Worklist UUID
SetlMgmtSchedgWlPeriodicGrnlty R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlPeriodicGrnlty Recurrence Pattern
SetlMgmtSchedgWlPeriodicValue R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlPeriodicValue Recurrence Frequency
SetlMgmtSchedgWlJobTimezone R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlJobTimezone Time Zone
SetlMgmtSchedgWlCalendarID R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlCalendarID Factory Calendar
SetlMgmtSchedgWlStrtRstrcnCode R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlStrtRstrcnCode Restrictions for Holidays
SetlMgmtSchedgWlRunsOnMon R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlRunsOnMon On Monday
SetlMgmtSchedgWlRunsOnTue R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlRunsOnTue Tuesday (Tu)
SetlMgmtSchedgWlRunsOnWed R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlRunsOnWed Wednesday (We)
SetlMgmtSchedgWlRunsOnThu R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlRunsOnThu Thursday (Th)
SetlMgmtSchedgWlRunsOnFri R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlRunsOnFri On Friday
SetlMgmtSchedgWlRunsOnSat R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlRunsOnSat Saturday (Sa)
SetlMgmtSchedgWlRunsOnSun R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlRunsOnSun Sunday (Su)
SetlMgmtSchedgWlMonthDay R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlMonthDay Month Day
SetlMgmtSchedgWlIsUsingWrkDays R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlIsUsingWrkDays Only Count Working Days
SetlMgmtSchedgWlShiftDirection R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlShiftDirection Type of Monthly Scheduling
SetlMgmtSchedgWlMonthWeek R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlMonthWeek Week of Month
SetlMgmtSchedgWlEndType R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlEndType End of Recurrence
SetlMgmtSchedgWlEndDateTime R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlEndDateTime Valid To Timestamp
SetlMgmtSchedgWlNmbrOfMaxRuns R_SetlMgmtSchedgWlRecurrence SetlMgmtSchedgWlNmbrOfMaxRuns Number
_Worklist _Worklist
_PeriodicGranularity _PeriodicGranularity
_StartRestrictionCode _StartRestrictionCode
_ShiftDirection _ShiftDirection
_EndType _EndType
_MonthWeek _MonthWeek
_CalendarID _CalendarID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_SetlMgmtSchedgWlRecurrenceTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_SetlMgmtSchedgWlRecurrenceTP AS
SELECT
  R_SetlMgmtSchedgWlRecurrence.SettlmtMgmtSchedgWlUUID AS SettlmtMgmtSchedgWlUUID,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlPeriodicGrnlty AS SetlMgmtSchedgWlPeriodicGrnlty,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlPeriodicValue AS SetlMgmtSchedgWlPeriodicValue,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlJobTimezone AS SetlMgmtSchedgWlJobTimezone,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlCalendarID AS SetlMgmtSchedgWlCalendarID,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlStrtRstrcnCode AS SetlMgmtSchedgWlStrtRstrcnCode,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlRunsOnMon AS SetlMgmtSchedgWlRunsOnMon,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlRunsOnTue AS SetlMgmtSchedgWlRunsOnTue,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlRunsOnWed AS SetlMgmtSchedgWlRunsOnWed,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlRunsOnThu AS SetlMgmtSchedgWlRunsOnThu,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlRunsOnFri AS SetlMgmtSchedgWlRunsOnFri,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlRunsOnSat AS SetlMgmtSchedgWlRunsOnSat,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlRunsOnSun AS SetlMgmtSchedgWlRunsOnSun,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlMonthDay AS SetlMgmtSchedgWlMonthDay,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlIsUsingWrkDays AS SetlMgmtSchedgWlIsUsingWrkDays,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlShiftDirection AS SetlMgmtSchedgWlShiftDirection,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlMonthWeek AS SetlMgmtSchedgWlMonthWeek,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlEndType AS SetlMgmtSchedgWlEndType,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlEndDateTime AS SetlMgmtSchedgWlEndDateTime,
  R_SetlMgmtSchedgWlRecurrence.SetlMgmtSchedgWlNmbrOfMaxRuns AS SetlMgmtSchedgWlNmbrOfMaxRuns
FROM R_SetlMgmtSchedgWlRecurrence
LEFT OUTER JOIN I_SetlMgmtSchedgWlPerdcGrnlty AS _PeriodicGranularity ON SetlMgmtSchedgWlPeriodicGrnlty = _PeriodicGranularity.SetlMgmtSchedgWlPeriodicGrnlty  -- association [0..1]
LEFT OUTER JOIN I_StlMnScdWlStrtRstrcnCode AS _StartRestrictionCode ON SetlMgmtSchedgWlStrtRstrcnCode = _StartRestrictionCode.SetlMgmtSchedgWlStrtRstrcnCode  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlShftDrctn AS _ShiftDirection ON SetlMgmtSchedgWlShiftDirection = _ShiftDirection.SetlMgmtSchedgWlShiftDirection  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlEndType AS _EndType ON SetlMgmtSchedgWlEndType = _EndType.SetlMgmtSchedgWlEndType  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlMonthWeek AS _MonthWeek ON SetlMgmtSchedgWlMonthWeek = _MonthWeek.SetlMgmtSchedgWlMonthWeek  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlCalendarIDVH AS _CalendarID ON SetlMgmtSchedgWlCalendarID = _CalendarID.SetlMgmtSchedgWlCalendarID  -- association [0..1]
;

Learn More