C_MassMaintCapShiftSqncDailyVH

DDL: C_MASSMAINTCAPSHIFTSQNCDAILYVH Type: view_entity CONSUMPTION
9 Fields 2 Associations

Shift Sequence Daily

C_MassMaintCapShiftSqncDailyVH is a Consumption CDS View that provides data about "Shift Sequence Daily" in SAP S/4HANA. It has 2 associations to related views.

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 Daily 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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ShiftGrouping _Seq ShiftGrouping Shift Grouping
KEY ShiftSequence _Seq ShiftSequence Shift Sequence
KEY ShiftNumber _Seq ShiftNumber
ShiftSequenceName
ShiftDefinition _Seq ShiftDay1DefID
ShiftStartTime
ShiftEndTime
OperatingDurationInSeconds
BreakDurationInSeconds

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_MassMaintCapShiftSqncDailyVH.
-- 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_MassMaintCapShiftSqncDailyVH 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 ShiftDefinition,
  _Def[1:ShiftDefinition=ShiftDefinition and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftStartTime AS ShiftStartTime,
  _Def[1:ShiftDefinition=ShiftDefinition and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].ShiftEndTime AS ShiftEndTime,
  _Def[1:ShiftDefinition=ShiftDefinition and ShiftGrouping=ShiftGrouping and ShiftStartDate <= $parameters.P_IntervalStartDate and ShiftEndDate >= $parameters.P_IntervalEndDate ].OperatingDurationInSeconds AS OperatingDurationInSeconds,
  cast(0 as abap.int4(10)) AS BreakDurationInSeconds
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