I_WorkCenterCapacityShift

DDL: I_WORKCENTERCAPACITYSHIFT SQL: IWRKCTRCAPSHIFT Type: view COMPOSITE
21 Fields 1 Data Sources

Shifts of WorkCenter Capacity

I_WorkCenterCapacityShift is a Composite CDS View that provides data about "Shifts of WorkCenter Capacity" in SAP S/4HANA. It reads from 1 data source (P_WorkCenterCapacityDefinition) and exposes 21 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityActiveVersion.

Data Sources (1)

SourceAliasJoin Type
P_WorkCenterCapacityDefinition Shift from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IWRKCTRCAPSHIFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Shifts of WorkCenter Capacity view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID P_WorkCenterCapacityDefinition WorkCenterInternalID Work Center
KEY WorkCenterTypeCode P_WorkCenterCapacityDefinition WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation P_WorkCenterCapacityDefinition CapacityCategoryAllocation
KEY CapacityInternalID P_WorkCenterCapacityDefinition CapacityInternalID Capacity ID
KEY CapacityActiveVersion P_WorkCenterCapacityDefinition CapacityActiveVersion
KEY IntervalEndDate P_WorkCenterCapacityDefinition ValidityEndDate ValidTo
KEY WeekDay P_WorkCenterCapacityDefinition WeekDay Weekdays
KEY AvailableCapacityShift P_WorkCenterCapacityDefinition AvailableCapacityShift Capacity Shift
WorkCenter P_WorkCenterCapacityDefinition WorkCenter Work Center
Plant P_WorkCenterCapacityDefinition Plant Valuation Area
IntervalStartDate P_WorkCenterCapacityDefinition ValidityBeginDate
ShiftName P_WorkCenterCapacityDefinition ShiftName
ShiftDefValidityStart P_WorkCenterCapacityDefinition ShiftStartDate
ShiftDefValidityEnd P_WorkCenterCapacityDefinition ShiftEndDate
ShiftStartTime P_WorkCenterCapacityDefinition ShiftStartTime
ShiftEndTime P_WorkCenterCapacityDefinition ShiftEndTime
CapacityBreakDuration P_WorkCenterCapacityDefinition CapacityBreakDuration
CapacityPlanUtilizationPercent P_WorkCenterCapacityDefinition CapacityPlanUtilizationPercent
CapacityNumberOfCapacities P_WorkCenterCapacityDefinition CapacityNumberOfCapacities
TotOperatingDurationInHours
TotOperationDurationUnit

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.
-- 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.
-- SQL view name: IWRKCTRCAPSHIFT

CREATE VIEW I_WorkCenterCapacityShift AS
SELECT
  Shift.WorkCenterInternalID AS WorkCenterInternalID,
  Shift.WorkCenterTypeCode AS WorkCenterTypeCode,
  Shift.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  Shift.CapacityInternalID AS CapacityInternalID,
  Shift.CapacityActiveVersion AS CapacityActiveVersion,
  Shift.ValidityEndDate AS IntervalEndDate,
  Shift.WeekDay AS WeekDay,
  Shift.AvailableCapacityShift AS AvailableCapacityShift,
  Shift.WorkCenter AS WorkCenter,
  Shift.Plant AS Plant,
  Shift.ValidityBeginDate AS IntervalStartDate,
  Shift.ShiftName AS ShiftName,
  Shift.ShiftStartDate AS ShiftDefValidityStart,
  Shift.ShiftEndDate AS ShiftDefValidityEnd,
  Shift.ShiftStartTime AS ShiftStartTime,
  Shift.ShiftEndTime AS ShiftEndTime,
  Shift.CapacityBreakDuration AS CapacityBreakDuration,
  Shift.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  Shift.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  fltp_to_dec(Shift.TotOperatingDurationInHours as dec17_3) AS TotOperatingDurationInHours,
  cast('H' as meins) AS TotOperationDurationUnit
FROM P_WorkCenterCapacityDefinition AS Shift
;

Learn More