I_WORKCENTERCAPACITYSHIFT
Shifts of WorkCenter Capacity
I_WORKCENTERCAPACITYSHIFT is a CDS View in S/4HANA. Shifts of WorkCenter Capacity. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_WorkCenterCapacityShift | view | from | COMPOSITE | Capacity Shift |
Fields (21)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AvailableCapacityShift | AvailableCapacityShift | 1 |
| KEY | CapacityActiveVersion | CapacityActiveVersion | 1 |
| KEY | CapacityCategoryAllocation | CapacityCategoryAllocation | 1 |
| KEY | CapacityInternalID | CapacityInternalID | 1 |
| KEY | IntervalEndDate | IntervalEndDate | 1 |
| KEY | WeekDay | WeekDay | 1 |
| KEY | WorkCenterInternalID | WorkCenterInternalID | 1 |
| KEY | WorkCenterTypeCode | WorkCenterTypeCode | 1 |
| CapacityBreakDuration | CapacityBreakDuration | 1 | |
| CapacityNumberOfCapacities | CapacityNumberOfCapacities | 1 | |
| CapacityPlanUtilizationPercent | CapacityPlanUtilizationPercent | 1 | |
| IntervalStartDate | IntervalStartDate | 1 | |
| Plant | Plant | 1 | |
| ShiftDefValidityEnd | ShiftDefValidityEnd | 1 | |
| ShiftDefValidityStart | ShiftDefValidityStart | 1 | |
| ShiftEndTime | ShiftEndTime | 1 | |
| ShiftName | ShiftName | 1 | |
| ShiftStartTime | ShiftStartTime | 1 | |
| TotOperatingDurationInHours | TotOperatingDurationInHours | 1 | |
| TotOperationDurationUnit | TotOperationDurationUnit | 1 | |
| WorkCenter | WorkCenter | 1 |
@AbapCatalog.sqlViewName: 'IWRKCTRCAPSHIFT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Shifts of WorkCenter Capacity'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
define view I_WorkCenterCapacityShift
as select from P_WorkCenterCapacityDefinition as Shift
{
key Shift.WorkCenterInternalID as WorkCenterInternalID,
key Shift.WorkCenterTypeCode as WorkCenterTypeCode,
key Shift.CapacityCategoryAllocation as CapacityCategoryAllocation,
key Shift.CapacityInternalID as CapacityInternalID,
key Shift.CapacityActiveVersion as CapacityActiveVersion,
key Shift.ValidityEndDate as IntervalEndDate,
key Shift.WeekDay as WeekDay,
key 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,
@Semantics.quantity.unitOfMeasure: 'TotOperationDurationUnit'
fltp_to_dec(Shift.TotOperatingDurationInHours as dec17_3) as TotOperatingDurationInHours,
@Semantics.unitOfMeasure: true
cast('H' as meins) as TotOperationDurationUnit
}