R_MassMaintCapIntervalShiftTP

DDL: R_MASSMAINTCAPINTERVALSHIFTTP Type: view_entity TRANSACTIONAL Package: ODATA_PP_WORKCENTER_API
24 Fields 2 Data Sources

capacity Interval Shift Data

R_MassMaintCapIntervalShiftTP is a Transactional CDS View that provides data about "capacity Interval Shift Data" in SAP S/4HANA. It reads from 2 data sources (I_WorkCenterCapacityInterval_2, I_WorkCenterCapacityShift_2) and exposes 24 fields with key fields CapacityInternalID, CapacityActiveVersion, IntervalEndDate, WeekDay, AvailableCapacityShift. Part of development package ODATA_PP_WORKCENTER_API.

Data Sources (2)

SourceAliasJoin Type
I_WorkCenterCapacityInterval_2 _Intrvl from
I_WorkCenterCapacityShift_2 _Shift inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label capacity Interval Shift Data view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_WorkCenterCapacityInterval_2 CapacityInternalID Capacity ID
KEY CapacityActiveVersion I_WorkCenterCapacityInterval_2 CapacityActiveVersion
KEY IntervalEndDate I_WorkCenterCapacityInterval_2 IntervalEndDate
KEY WeekDay I_WorkCenterCapacityShift_2 WeekDay Weekdays
KEY AvailableCapacityShift I_WorkCenterCapacityShift_2 AvailableCapacityShift Capacity Shift
IntervalStartDate I_WorkCenterCapacityInterval_2 IntervalStartDate
StdAvailableCapacityIsValid I_WorkCenterCapacityInterval_2 StdAvailableCapacityIsValid
ShiftSequence I_WorkCenterCapacityInterval_2 ShiftSequence Shift Sequence
WorkDayRule I_WorkCenterCapacityInterval_2 WorkDayRule Recurrence Weekdays
CapacityNumberOfShifts I_WorkCenterCapacityInterval_2 CapacityNumberOfShifts
AvailableCapacityIntervalDurn I_WorkCenterCapacityInterval_2 AvailableCapacityIntervalDurn
ShiftDefinition I_WorkCenterCapacityShift_2 ShiftDefinition
ShiftStartTime I_WorkCenterCapacityShift_2 ShiftStartTime
ShiftEndTime I_WorkCenterCapacityShift_2 ShiftEndTime
ShiftDefValidityStartDate I_WorkCenterCapacityShift_2 ShiftDefValidityStartDate
ShiftDefValidityEndDate I_WorkCenterCapacityShift_2 ShiftDefValidityEndDate
CapacityNumberOfCapacities I_WorkCenterCapacityShift_2 CapacityNumberOfCapacities
CapacityPlanUtilizationPercent I_WorkCenterCapacityShift_2 CapacityPlanUtilizationPercent
CapacityBreakDuration I_WorkCenterCapacityShift_2 CapacityBreakDuration
OperatingDurationInSeconds I_WorkCenterCapacityShift_2 OperatingDurationInSeconds
TotOperatingDurationInSeconds I_WorkCenterCapacityShift_2 TotOperatingDurationInSeconds
WorkCenterCapacityUnit
WorkCenterUtilizationUnit
_CapListHeader _CapListHeader

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_MassMaintCapIntervalShiftTP.
-- 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_MassMaintCapIntervalShiftTP AS
SELECT
  _Intrvl.CapacityInternalID AS CapacityInternalID,
  _Intrvl.CapacityActiveVersion AS CapacityActiveVersion,
  _Intrvl.IntervalEndDate AS IntervalEndDate,
  _Shift.WeekDay AS WeekDay,
  _Shift.AvailableCapacityShift AS AvailableCapacityShift,
  _Intrvl.IntervalStartDate AS IntervalStartDate,
  _Intrvl.StdAvailableCapacityIsValid AS StdAvailableCapacityIsValid,
  _Intrvl.ShiftSequence AS ShiftSequence,
  _Intrvl.WorkDayRule AS WorkDayRule,
  _Intrvl.CapacityNumberOfShifts AS CapacityNumberOfShifts,
  _Intrvl.AvailableCapacityIntervalDurn AS AvailableCapacityIntervalDurn,
  _Shift.ShiftDefinition AS ShiftDefinition,
  _Shift.ShiftStartTime AS ShiftStartTime,
  _Shift.ShiftEndTime AS ShiftEndTime,
  _Shift.ShiftDefValidityStartDate AS ShiftDefValidityStartDate,
  _Shift.ShiftDefValidityEndDate AS ShiftDefValidityEndDate,
  _Shift.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  _Shift.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  _Shift.CapacityBreakDuration AS CapacityBreakDuration,
  _Shift.OperatingDurationInSeconds AS OperatingDurationInSeconds,
  _Shift.TotOperatingDurationInSeconds AS TotOperatingDurationInSeconds,
  cast('H' as unit) AS WorkCenterCapacityUnit,
  cast('%' as unit) AS WorkCenterUtilizationUnit
FROM I_WorkCenterCapacityInterval_2 AS _Intrvl
INNER JOIN I_WorkCenterCapacityShift_2 AS _Shift ON /* join condition not captured in parsed metadata */
;

Learn More