I_WorkCenterCapacityShift_3

DDL: I_WORKCENTERCAPACITYSHIFT_3 Type: view_entity COMPOSITE Package: ODATA_PP_WORKCENTER_API
25 Fields 2 Data Sources

Capacity Shift Version 3

I_WorkCenterCapacityShift_3 is a Composite CDS View that provides data about "Capacity Shift Version 3" in SAP S/4HANA. It reads from 2 data sources (I_WorkCenterCapacityInterval_3, I_WorkCenterCapacityShift_2) and exposes 25 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityActiveVersion. Part of development package ODATA_PP_WORKCENTER_API.

Data Sources (2)

SourceAliasJoin Type
I_WorkCenterCapacityInterval_3 _Interval inner
I_WorkCenterCapacityShift_2 _Shift from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Capacity Shift Version 3 view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacityInterval_3 WorkCenterInternalID Work Center
KEY WorkCenterTypeCode I_WorkCenterCapacityInterval_3 WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation I_WorkCenterCapacityInterval_3 CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacityShift_2 CapacityInternalID Capacity ID
KEY CapacityActiveVersion I_WorkCenterCapacityShift_2 CapacityActiveVersion
KEY IntervalEndDate I_WorkCenterCapacityShift_2 IntervalEndDate
KEY WeekDay I_WorkCenterCapacityShift_2 WeekDay Weekdays
KEY AvailableCapacityShift I_WorkCenterCapacityShift_2 AvailableCapacityShift Capacity Shift
IntervalStartDate I_WorkCenterCapacityShift_2 IntervalStartDate
WorkDayRule I_WorkCenterCapacityShift_2 WorkDayRule Recurrence Weekdays
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
CapacityLastChangeDateTime I_WorkCenterCapacityShift_2 CapacityLastChangeDateTime
_AvailableCapacityType I_WorkCenterCapacityShift_2 _AvailableCapacityType
_Capacity I_WorkCenterCapacityShift_2 _Capacity
_EndDate I_WorkCenterCapacityShift_2 _EndDate
_WeekDay I_WorkCenterCapacityShift_2 _WeekDay

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 I_WorkCenterCapacityShift_3.
-- 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 I_WorkCenterCapacityShift_3 AS
SELECT
  _Interval.WorkCenterInternalID AS WorkCenterInternalID,
  _Interval.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Interval.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  _Shift.CapacityInternalID AS CapacityInternalID,
  _Shift.CapacityActiveVersion AS CapacityActiveVersion,
  _Shift.IntervalEndDate AS IntervalEndDate,
  _Shift.WeekDay AS WeekDay,
  _Shift.AvailableCapacityShift AS AvailableCapacityShift,
  _Shift.IntervalStartDate AS IntervalStartDate,
  _Shift.WorkDayRule AS WorkDayRule,
  _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,
  _Shift.CapacityLastChangeDateTime AS CapacityLastChangeDateTime,
  _Shift._AvailableCapacityType AS _AvailableCapacityType,
  _Shift._Capacity AS _Capacity,
  _Shift._EndDate AS _EndDate,
  _Shift._WeekDay AS _WeekDay
FROM I_WorkCenterCapacityShift_2 AS _Shift
INNER JOIN I_WorkCenterCapacityInterval_3 AS _Interval ON /* join condition not captured in parsed metadata */
;

Learn More