C_MassMaintCapShftSqncWeeklyVH

DDL: C_MASSMAINTCAPSHFTSQNCWEEKLYVH Type: view_entity CONSUMPTION
41 Fields 1 Data Sources 2 Associations 1 OData Services 1 Fiori Apps

Shift Sequence Weekly

C_MassMaintCapShftSqncWeeklyVH is a Consumption CDS View that provides data about "Shift Sequence Weekly" in SAP S/4HANA. It reads from 1 data source (I_MassMaintCapShiftSequence) and exposes 41 fields with key fields ShiftGrouping, ShiftSequence, ShiftNumber. It has 2 associations to related views. It is exposed through 1 OData service (UI_WORKCENTERCAPLIST_02). It is used in 1 Fiori application: Mass Maintenance Of Work Center Capacities.

Data Sources (1)

SourceAliasJoin Type
I_MassMaintCapShiftSequence _seq from

Parameters (2)

NameTypeDefault
P_IntervalStartDate endda
P_IntervalEndDate begda

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MassMaintCapShiftDefinition _Def _seq.ShiftGrouping = _Def.ShiftGrouping
[0..*] I_ShiftSequenceText _Text $projection.ShiftGrouping = _Text.ShiftGrouping and $projection.ShiftSequence = _Text.ShiftSequence

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Shift Sequence Weekly view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
UI_WORKCENTERCAPLIST_02 UI_WORKCENTERCAPLIST_02 V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5381 Mass Maintenance Of Work Center Capacities Transactional The application is used to perform a mass create of interval for selected work center capacities. As a Production Planner, you must manage the capacities of multiple work centers to meet future demands. When you foresee a spike in demand, you can create multiple intervals for a few or all capacities that belong to the work centers in a production line/Work Center group. Intervals can be created for both working and non-working days. Within the given interval, you can create shifts for a single day and allow it to repeat on a daily, weekly or monthly basis. On the other hand, you could also create weekly shifts. You can then define a shift order by either assigning existing shift sequences or create your own custom shift definitions. While creating intervals, you can choose to override the existing factory calendar and make edits to Utilization and number of capacities.

Mass Maintenance Of Work Center Capacities

Business Role: Production Planner

With this app, you can perform a mass create of interval for selected work center capacities. As a Production Planner, you must manage the capacities of multiple work centers to meet future demands. When you foresee a spike in demand, you can create multiple intervals for a few or all capacities that belong to the work centers in a production line/Work Center group. Intervals can be created for both working and non-working days. Within the given interval, you can create shifts for a single day and allow it to repeat on a daily, weekly or monthly basis. On the other hand, you could also create weekly shifts. You can then define a shift order by either assigning existing shift sequences or create your own custom shift definitions. While creating intervals, you can choose to override the existing factory calendar and make edits to Utilization and number of capacities.

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ShiftGrouping I_MassMaintCapShiftSequence ShiftGrouping Shift Grouping
KEY ShiftSequence I_MassMaintCapShiftSequence ShiftSequence Shift Sequence
KEY ShiftNumber I_MassMaintCapShiftSequence ShiftNumber Capacity Shift
ShiftSequenceName
ShiftDay1DefID I_MassMaintCapShiftSequence ShiftDay1DefID Shift Definition
ShiftDay1StartTime
ShiftDay1EndTime
ShiftDay1OpgDurn
ShiftDay1BreakDurn
ShiftDay2DefID I_MassMaintCapShiftSequence ShiftDay2DefID Shift Definition
ShiftDay2StartTime
ShiftDay2EndTime
ShiftDay2OpgDurn
ShiftDay2BreakDurn
ShiftDay3DefID I_MassMaintCapShiftSequence ShiftDay3DefID Shift Definition
ShiftDay3StartTime
ShiftDay3EndTime
ShiftDay3OpgDurn
ShiftDay3BreakDurn
ShiftDay4DefID I_MassMaintCapShiftSequence ShiftDay4DefID Shift Definition
ShiftDay4StartTime
ShiftDay4EndTime
ShiftDay4OpgDurn
ShiftDay4BreakDurn
ShiftDay5DefID I_MassMaintCapShiftSequence ShiftDay5DefID Shift Definition
ShiftDay5StartTime
ShiftDay5EndTime
ShiftDay5OpgDurn
ShiftDay5BreakDurn
ShiftDay6DefID I_MassMaintCapShiftSequence ShiftDay6DefID Shift Definition
ShiftDay6StartTime
ShiftDay6EndTime
ShiftDay6OpgDurn
ShiftDay6BreakDurn
ShiftDay7DefID I_MassMaintCapShiftSequence ShiftDay7DefID Shift Definition
ShiftDay7StartTime
ShiftDay7EndTime
ShiftDay7OpgDurn
ShiftDay7BreakDurn
timsendasShiftStartTime
timsendasShiftEndTime

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 C_MassMaintCapShftSqncWeeklyVH.
-- 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.
-- Parameters: P_IntervalStartDate : endda, P_IntervalEndDate : begda

CREATE VIEW C_MassMaintCapShftSqncWeeklyVH AS
SELECT
  _seq.ShiftGrouping AS ShiftGrouping,
  _seq.ShiftSequence AS ShiftSequence,
  _seq.ShiftNumber AS ShiftNumber,
  _Text[1:Language=$session.system_language].ShiftSequenceName AS ShiftSequenceName,
  _seq.ShiftDay1DefID AS ShiftDay1DefID,
  _Def[1:ShiftDefinition=ShiftDay1DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime AS ShiftDay1StartTime,
  _Def[1:ShiftDefinition=ShiftDay1DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime AS ShiftDay1EndTime,
  _Def[1:ShiftDefinition=ShiftDay1DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].OperatingDurationInSeconds AS ShiftDay1OpgDurn,
  cast(0 as abap.int4(10)) AS ShiftDay1BreakDurn,
  _seq.ShiftDay2DefID AS ShiftDay2DefID,
  _Def[1:ShiftDefinition=ShiftDay2DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime AS ShiftDay2StartTime,
  _Def[1:ShiftDefinition=ShiftDay2DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime AS ShiftDay2EndTime,
  _Def[1:ShiftDefinition=ShiftDay2DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].OperatingDurationInSeconds AS ShiftDay2OpgDurn,
  cast(0 as abap.int4(10)) AS ShiftDay2BreakDurn,
  _seq.ShiftDay3DefID AS ShiftDay3DefID,
  _Def[1:ShiftDefinition=ShiftDay3DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime AS ShiftDay3StartTime,
  _Def[1:ShiftDefinition=ShiftDay3DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime AS ShiftDay3EndTime,
  _Def[1:ShiftDefinition=ShiftDay3DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].OperatingDurationInSeconds AS ShiftDay3OpgDurn,
  cast(0 as abap.int4(10)) AS ShiftDay3BreakDurn,
  _seq.ShiftDay4DefID AS ShiftDay4DefID,
  _Def[1:ShiftDefinition=ShiftDay4DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime AS ShiftDay4StartTime,
  _Def[1:ShiftDefinition=ShiftDay4DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime AS ShiftDay4EndTime,
  _Def[1:ShiftDefinition=ShiftDay4DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].OperatingDurationInSeconds AS ShiftDay4OpgDurn,
  cast(0 as abap.int4(10)) AS ShiftDay4BreakDurn,
  _seq.ShiftDay5DefID AS ShiftDay5DefID,
  _Def[1:ShiftDefinition=ShiftDay5DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime AS ShiftDay5StartTime,
  _Def[1:ShiftDefinition=ShiftDay5DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime AS ShiftDay5EndTime,
  _Def[1:ShiftDefinition=ShiftDay5DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].OperatingDurationInSeconds AS ShiftDay5OpgDurn,
  cast(0 as abap.int4(10)) AS ShiftDay5BreakDurn,
  _seq.ShiftDay6DefID AS ShiftDay6DefID,
  _Def[1:ShiftDefinition=ShiftDay6DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime AS ShiftDay6StartTime,
  _Def[1:ShiftDefinition=ShiftDay6DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime AS ShiftDay6EndTime,
  _Def[1:ShiftDefinition=ShiftDay6DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].OperatingDurationInSeconds AS ShiftDay6OpgDurn,
  cast(0 as abap.int4(10)) AS ShiftDay6BreakDurn,
  _seq.ShiftDay7DefID AS ShiftDay7DefID,
  _Def[1:ShiftDefinition=ShiftDay7DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime AS ShiftDay7StartTime,
  _Def[1:ShiftDefinition=ShiftDay7DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime AS ShiftDay7EndTime,
  _Def[1:ShiftDefinition=ShiftDay7DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].OperatingDurationInSeconds AS ShiftDay7OpgDurn,
  cast(0 as abap.int4(10)) AS ShiftDay7BreakDurn,
  case when ShiftDay1DefID != '' then _Def[1:ShiftDefinition=ShiftDay1DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime when ShiftDay2DefID != '' then _Def[1:ShiftDefinition=ShiftDay2DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime when ShiftDay3DefID != '' then _Def[1:ShiftDefinition=ShiftDay3DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime when ShiftDay4DefID != '' then _Def[1:ShiftDefinition=ShiftDay4DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime when ShiftDay5DefID != '' then _Def[1:ShiftDefinition=ShiftDay5DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime when ShiftDay6DefID != '' then _Def[1:ShiftDefinition=ShiftDay6DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime when ShiftDay7DefID != '' then _Def[1:ShiftDefinition=ShiftDay7DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime else cast('000000' as abap.tims) end as ShiftStartTime AS timsendasShiftStartTime,
  case when ShiftDay1DefID != '' then _Def[1:ShiftDefinition=ShiftDay1DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime when ShiftDay2DefID != '' then _Def[1:ShiftDefinition=ShiftDay2DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime when ShiftDay3DefID != '' then _Def[1:ShiftDefinition=ShiftDay3DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime when ShiftDay4DefID != '' then _Def[1:ShiftDefinition=ShiftDay4DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime when ShiftDay5DefID != '' then _Def[1:ShiftDefinition=ShiftDay5DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime when ShiftDay6DefID != '' then _Def[1:ShiftDefinition=ShiftDay6DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime when ShiftDay7DefID != '' then _Def[1:ShiftDefinition=ShiftDay7DefID and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime else cast('000000' as abap.tims) end as ShiftEndTime AS timsendasShiftEndTime
FROM I_MassMaintCapShiftSequence AS _seq
LEFT OUTER JOIN I_MassMaintCapShiftDefinition AS _Def ON _seq.ShiftGrouping = _Def.ShiftGrouping  -- association [0..*]
LEFT OUTER JOIN I_ShiftSequenceText AS _Text ON ShiftGrouping = _Text.ShiftGrouping AND ShiftSequence = _Text.ShiftSequence  -- association [0..*]
;

Learn More