A_WorkCenterCapacityShift

DDL: A_WORKCENTERCAPACITYSHIFT SQL: AWRKCTRCAPSHIFT Type: view COMPOSITE
21 Fields 1 Data Sources

Capacity Shift

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

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacityShift Shift from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName AWRKCTRCAPSHIFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Capacity Shift view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacityShift WorkCenterInternalID Work Center
KEY WorkCenterTypeCode I_WorkCenterCapacityShift WorkCenterTypeCode Object Type
KEY CapacityCategoryAllocation I_WorkCenterCapacityShift CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacityShift CapacityInternalID Capacity ID
KEY CapacityActiveVersion I_WorkCenterCapacityShift CapacityActiveVersion
KEY IntervalEndDate I_WorkCenterCapacityShift IntervalEndDate ValidTo
KEY WeekDay I_WorkCenterCapacityShift WeekDay Weekdays
KEY AvailableCapacityShift I_WorkCenterCapacityShift AvailableCapacityShift Capacity Shift
WorkCenter I_WorkCenterCapacityShift WorkCenter Work Center
Plant I_WorkCenterCapacityShift Plant Valuation Area
IntervalStartDate I_WorkCenterCapacityShift IntervalStartDate
ShiftName I_WorkCenterCapacityShift ShiftName
ShiftDefValidityStart I_WorkCenterCapacityShift ShiftDefValidityStart
ShiftDefValidityEnd I_WorkCenterCapacityShift ShiftDefValidityEnd
ShiftStartTime I_WorkCenterCapacityShift ShiftStartTime
ShiftEndTime I_WorkCenterCapacityShift ShiftEndTime
CapacityBreakDuration I_WorkCenterCapacityShift CapacityBreakDuration
CapacityPlanUtilizationPercent I_WorkCenterCapacityShift CapacityPlanUtilizationPercent
CapacityNumberOfCapacities I_WorkCenterCapacityShift CapacityNumberOfCapacities
TotOperatingDurationInHours I_WorkCenterCapacityShift TotOperatingDurationInHours
TotOperationDurationUnit I_WorkCenterCapacityShift 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 A_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: AWRKCTRCAPSHIFT

CREATE VIEW A_WorkCenterCapacityShift AS
SELECT
  Shift.WorkCenterInternalID AS WorkCenterInternalID,
  Shift.WorkCenterTypeCode AS WorkCenterTypeCode,
  Shift.CapacityCategoryAllocation AS CapacityCategoryAllocation,
  Shift.CapacityInternalID AS CapacityInternalID,
  Shift.CapacityActiveVersion AS CapacityActiveVersion,
  Shift.IntervalEndDate AS IntervalEndDate,
  Shift.WeekDay AS WeekDay,
  Shift.AvailableCapacityShift AS AvailableCapacityShift,
  Shift.WorkCenter AS WorkCenter,
  Shift.Plant AS Plant,
  Shift.IntervalStartDate AS IntervalStartDate,
  Shift.ShiftName AS ShiftName,
  Shift.ShiftDefValidityStart AS ShiftDefValidityStart,
  Shift.ShiftDefValidityEnd AS ShiftDefValidityEnd,
  Shift.ShiftStartTime AS ShiftStartTime,
  Shift.ShiftEndTime AS ShiftEndTime,
  Shift.CapacityBreakDuration AS CapacityBreakDuration,
  Shift.CapacityPlanUtilizationPercent AS CapacityPlanUtilizationPercent,
  Shift.CapacityNumberOfCapacities AS CapacityNumberOfCapacities,
  Shift.TotOperatingDurationInHours AS TotOperatingDurationInHours,
  Shift.TotOperationDurationUnit AS TotOperationDurationUnit
FROM I_WorkCenterCapacityShift AS Shift
;

Learn More