R_MassMaintCapCtrlrIntvlShftTP

DDL: R_MASSMAINTCAPCTRLRINTVLSHFTTP Type: view_entity TRANSACTIONAL
17 Fields 1 Data Sources

Mass Maint Capacity Controller Interval & Shifts

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

Data Sources (1)

SourceAliasJoin Type
I_CapChgBackgroundJobIntvlShft I_CapChgBackgroundJobIntvlShft from

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 #NOT_REQUIRED view
EndUserText.label Mass Maint Capacity Controller Interval & Shifts view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BackgroundJobUUID BackgroundJobUUID UUID 22 char.
KEY IntervalEndDate IntervalEndDate Valid to
KEY WeekDay WeekDay Weekdays
KEY AvailableCapacityShift AvailableCapacityShift Capacity Shift
IntervalStartDate IntervalStartDate Valid-from date
WorkDayRule WorkDayRule Recurrence Weekdays
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn Number of days
ShiftSequence ShiftSequence Shift Sequence
ShiftDefinition ShiftDefinition Shift Definition
ShiftStartTime ShiftStartTime Start Time
ShiftEndTime ShiftEndTime End Time
CapacityBreakDuration CapacityBreakDuration Break Length
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent Utilization
CapacityNumberOfCapacities CapacityNumberOfCapacities Standard Pct.
CapacityChangeIsInterval CapacityChangeIsInterval TRUE
CapacityIntervalIsDeleted CapacityIntervalIsDeleted TRUE
_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 R_MassMaintCapCtrlrIntvlShftTP.
-- 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_MassMaintCapCtrlrIntvlShftTP AS
SELECT
  BackgroundJobUUID,
  IntervalEndDate,
  WeekDay,
  AvailableCapacityShift,
  IntervalStartDate,
  WorkDayRule,
  AvailableCapacityIntervalDurn,
  ShiftSequence,
  ShiftDefinition,
  ShiftStartTime,
  ShiftEndTime,
  CapacityBreakDuration,
  CapacityPlanUtilizationPercent,
  CapacityNumberOfCapacities,
  CapacityChangeIsInterval,
  CapacityIntervalIsDeleted
FROM I_CapChgBackgroundJobIntvlShft
;

Learn More