R_MassMaintCapacityCtrlrTP

DDL: R_MASSMAINTCAPACITYCTRLRTP Type: view_entity TRANSACTIONAL
30 Fields 1 Data Sources 2 Associations

Mass Maintenance Capacity Controller

R_MassMaintCapacityCtrlrTP is a Transactional CDS View that provides data about "Mass Maintenance Capacity Controller" in SAP S/4HANA. It reads from 1 data source (I_CapacityChgBackgroundJobHdr) and exposes 30 fields with key field BackgroundJobUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CapacityChgBackgroundJobHdr I_CapacityChgBackgroundJobHdr from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_MassMaintCapCtrlrCapListTP _CapList
[0..*] R_MassMaintCapCtrlrIntvlShftTP _IntvlShft

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Mass Maintenance Capacity Controller view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY BackgroundJobUUID BackgroundJobUUID UUID 22 char.
CapacityUpdateIsMassChange CapacityUpdateIsMassChange TRUE
RecurrenceRepeat RecurrenceRepeat Recurrence Repeat
NumberOfRecurrenceInterval NumberOfRecurrenceInterval Recurrence Interval
RecurrenceDayOfMonth RecurrenceDayOfMonth RecurrenceDayofMonth
RecurrenceWeekDayOrderOfMonth RecurrenceWeekDayOrderOfMonth Recurrence week of M
IntervalHasWeekDay1 IntervalHasWeekDay1 TRUE
IntervalHasWeekDay2 IntervalHasWeekDay2 TRUE
IntervalHasWeekDay3 IntervalHasWeekDay3 TRUE
IntervalHasWeekDay4 IntervalHasWeekDay4 TRUE
IntervalHasWeekDay5 IntervalHasWeekDay5 TRUE
IntervalHasWeekDay6 IntervalHasWeekDay6 TRUE
IntervalHasWeekDay7 IntervalHasWeekDay7 TRUE
IntervalHasCapacityHeaderVals IntervalHasCapacityHeaderVals TRUE
BackgroundJobName BackgroundJobName Name of Send Process
BackgroundJob BackgroundJob Job number
ApplicationJobDescription ApplicationJobDescription External ID
BackgroundJobChangedDateTime BackgroundJobChangedDateTime CreationTS
JobProcessingMode JobProcessingMode Processing Mode
CapacityHeaderHasUpdate CapacityHeaderHasUpdate TRUE
IntervalHasExistingUtilization IntervalHasExistingUtilization TRUE
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent Utilization
IntvlHasExistingNmbrOfCap IntvlHasExistingNmbrOfCap TRUE
CapacityNumberOfCapacities CapacityNumberOfCapacities Number
CalendarWeek CalendarWeek Calendar Week
CalendarYear CalendarYear Year
CalendarMonth CalendarMonth Calendar Month
PreviewCapacityChgsMonthThld PreviewCapacityChgsMonthThld 3-Byte field
_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 R_MassMaintCapacityCtrlrTP.
-- 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_MassMaintCapacityCtrlrTP 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 I_CapacityChgBackgroundJobHdr
LEFT OUTER JOIN R_MassMaintCapCtrlrCapListTP AS _CapList ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MassMaintCapCtrlrIntvlShftTP AS _IntvlShft ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More