C_MassMaintCapacityController

DDL: C_MASSMAINTCAPACITYCONTROLLER Type: view_entity CONSUMPTION

Mass Maintenance Capacity Controller

C_MassMaintCapacityController is a Consumption CDS View that provides data about "Mass Maintenance Capacity Controller" in SAP S/4HANA. It reads from 1 data source (R_MassMaintCapacityCtrlrTP) and exposes 30 fields with key field BackgroundJobUUID. 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
R_MassMaintCapacityCtrlrTP R_MassMaintCapacityCtrlrTP from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_MassMaintCapCtrlrCapList _CapList
[0..*] C_MassMaintCapCtrlrIntvlShft _IntvlShft

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 Mass Maintenance Capacity Controller 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 (30)

KeyFieldSource TableSource FieldDescription
KEY BackgroundJobUUID BackgroundJobUUID
CapacityUpdateIsMassChange CapacityUpdateIsMassChange
RecurrenceRepeat RecurrenceRepeat Recurrence Repeat
NumberOfRecurrenceInterval NumberOfRecurrenceInterval
RecurrenceDayOfMonth RecurrenceDayOfMonth RecurrenceDayofMonth
RecurrenceWeekDayOrderOfMonth RecurrenceWeekDayOrderOfMonth
IntervalHasWeekDay1 IntervalHasWeekDay1
IntervalHasWeekDay2 IntervalHasWeekDay2
IntervalHasWeekDay3 IntervalHasWeekDay3
IntervalHasWeekDay4 IntervalHasWeekDay4
IntervalHasWeekDay5 IntervalHasWeekDay5
IntervalHasWeekDay6 IntervalHasWeekDay6
IntervalHasWeekDay7 IntervalHasWeekDay7
IntervalHasCapacityHeaderVals IntervalHasCapacityHeaderVals
BackgroundJobName BackgroundJobName
BackgroundJob BackgroundJob
ApplicationJobDescription ApplicationJobDescription External ID
BackgroundJobChangedDateTime BackgroundJobChangedDateTime
JobProcessingMode JobProcessingMode
CapacityHeaderHasUpdate CapacityHeaderHasUpdate
IntervalHasExistingUtilization IntervalHasExistingUtilization
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
IntvlHasExistingNmbrOfCap IntvlHasExistingNmbrOfCap
CapacityNumberOfCapacities CapacityNumberOfCapacities
CalendarWeek CalendarWeek Calendar Week
CalendarYear CalendarYear Year
CalendarMonth CalendarMonth Calendar Month
PreviewCapacityChgsMonthThld PreviewCapacityChgsMonthThld
_CapList _CapList
_IntvlShft _IntvlShft

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_MassMaintCapacityController.
-- 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_MassMaintCapacityController AS
SELECT
  BackgroundJobUUID,
  CapacityUpdateIsMassChange,
  RecurrenceRepeat,
  NumberOfRecurrenceInterval,
  RecurrenceDayOfMonth,
  RecurrenceWeekDayOrderOfMonth,
  IntervalHasWeekDay1,
  IntervalHasWeekDay2,
  IntervalHasWeekDay3,
  IntervalHasWeekDay4,
  IntervalHasWeekDay5,
  IntervalHasWeekDay6,
  IntervalHasWeekDay7,
  IntervalHasCapacityHeaderVals,
  BackgroundJobName,
  BackgroundJob,
  ApplicationJobDescription,
  BackgroundJobChangedDateTime,
  JobProcessingMode,
  CapacityHeaderHasUpdate,
  IntervalHasExistingUtilization,
  CapacityPlanUtilizationPercent,
  IntvlHasExistingNmbrOfCap,
  CapacityNumberOfCapacities,
  CalendarWeek,
  CalendarYear,
  CalendarMonth,
  PreviewCapacityChgsMonthThld
FROM R_MassMaintCapacityCtrlrTP
LEFT OUTER JOIN C_MassMaintCapCtrlrCapList AS _CapList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_MassMaintCapCtrlrIntvlShft AS _IntvlShft ON /* condition not available in parsed metadata */  -- association [0..*]
;