C_MassMaintCapCtrlrIntvlShft

DDL: C_MASSMAINTCAPCTRLRINTVLSHFT Type: view_entity CONSUMPTION

Capacity Controller Interval & Shifts

C_MassMaintCapCtrlrIntvlShft is a Consumption CDS View that provides data about "Capacity Controller Interval & Shifts" in SAP S/4HANA. It reads from 1 data source (R_MassMaintCapCtrlrIntvlShftTP) and exposes 17 fields with key fields BackgroundJobUUID, IntervalEndDate, WeekDay, AvailableCapacityShift.

Data Sources (1)

SourceAliasJoin Type
R_MassMaintCapCtrlrIntvlShftTP R_MassMaintCapCtrlrIntvlShftTP from

Annotations (8)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Capacity Controller Interval & Shifts view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BackgroundJobUUID BackgroundJobUUID
KEY IntervalEndDate IntervalEndDate
KEY WeekDay WeekDay Weekdays
KEY AvailableCapacityShift AvailableCapacityShift Capacity Shift
IntervalStartDate IntervalStartDate
WorkDayRule WorkDayRule Recurrence Weekdays
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn
ShiftSequence ShiftSequence Shift Sequence
ShiftDefinition ShiftDefinition
ShiftStartTime ShiftStartTime
ShiftEndTime ShiftEndTime
CapacityBreakDuration CapacityBreakDuration
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityChangeIsInterval CapacityChangeIsInterval
CapacityIntervalIsDeleted CapacityIntervalIsDeleted
_Header _Header

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_MassMaintCapCtrlrIntvlShft.
-- 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 C_MassMaintCapCtrlrIntvlShft AS
SELECT
  BackgroundJobUUID,
  IntervalEndDate,
  WeekDay,
  AvailableCapacityShift,
  IntervalStartDate,
  WorkDayRule,
  AvailableCapacityIntervalDurn,
  ShiftSequence,
  ShiftDefinition,
  ShiftStartTime,
  ShiftEndTime,
  CapacityBreakDuration,
  CapacityPlanUtilizationPercent,
  CapacityNumberOfCapacities,
  CapacityChangeIsInterval,
  CapacityIntervalIsDeleted
FROM R_MassMaintCapCtrlrIntvlShftTP
;