I_WORKCENTERAVAILABLECAPACITY
Total Available Capacity of Work Center
I_WORKCENTERAVAILABLECAPACITY is a CDS View in S/4HANA. Total Available Capacity of Work Center. It contains 33 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_WrkCtrAvailableCapacityTP | view | from | TRANSACTIONAL | Total Available Capacity of Work Center |
Fields (33)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AvailableCapacityShift | AvailableCapacityShift | 1 |
| KEY | CalendarDate | CalendarDate | 1 |
| KEY | CapacityActiveVersion | CapacityActiveVersion | 1 |
| KEY | CapacityCategoryAllocation | CapacityCategoryAllocation | 1 |
| KEY | CapacityInternalID | CapacityInternalID | 1 |
| KEY | ValidityEndDate | ValidityEndDate | 1 |
| KEY | WeekDay | WeekDay | 1 |
| KEY | WorkCenterInternalID | WorkCenterInternalID | 1 |
| KEY | WorkCenterTypeCode | WorkCenterTypeCode | 1 |
| CalendarMonth | CalendarMonth | 1 | |
| CalendarWeek | CalendarWeek | 1 | |
| CalendarYear | CalendarYear | 1 | |
| CapacityBreakDuration | CapacityBreakDuration | 1 | |
| CapacityEndTime | CapacityEndTime | 1 | |
| CapacityNumberOfCapacities | CapacityNumberOfCapacities | 1 | |
| CapacityPlanUtilizationPercent | CapacityPlanUtilizationPercent | 1 | |
| CapacityStartTime | CapacityStartTime | 1 | |
| FactoryCalendar | FactoryCalendar | 1 | |
| OperatingCapacityDurationInHrs | OperatingCapacityDurationInHrs | 1 | |
| ShiftDefinition | ShiftDefinition | 1 | |
| ShiftDefinitionName | ShiftDefinitionName | 1 | |
| ShiftEndDate | ShiftEndDate | 1 | |
| ShiftEndTime | ShiftEndTime | 1 | |
| ShiftGrouping | ShiftGrouping | 1 | |
| ShiftName | ShiftName | 1 | |
| ShiftStartDate | ShiftStartDate | 1 | |
| ShiftStartTime | ShiftStartTime | 1 | |
| TotOperatingDurationInHours | TotOperatingDurationInHours | 1 | |
| ValidityBeginDate | ValidityBeginDate | 1 | |
| WorkCenterCapacityUnit | WorkCenterCapacityUnit | 1 | |
| WorkCenterUtilizationUnit | WorkCenterUtilizationUnit | 1 | |
| WorkDayRule | WorkDayRule | 1 | |
| WorkDays | WorkDays | 1 |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IWRKCTRAVAILCAP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Total Available Capacity of Work Center'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
define view I_WorkCenterAvailableCapacity
as select from P_WorkCenterAvailableCapacity as availCapa
association [0..*] to I_ShiftDefinitionText as _Text on $projection.ShiftDefinition = _Text.ShiftDefinition
and $projection.ShiftGrouping = _Text.ShiftGrouping
association [1..1] to I_Capacity as _Capacity on $projection.CapacityInternalID = _Capacity.CapacityInternalID
{
key availCapa.WorkCenterInternalID as WorkCenterInternalID,
key availCapa.WorkCenterTypeCode as WorkCenterTypeCode,
key availCapa.CapacityCategoryAllocation,
//key cast (availCapa.CapacityInternalID as kapid) as CapacityInternalID,
key availCapa.CapacityInternalID as CapacityInternalID,
key availCapa.CapacityActiveVersion as CapacityActiveVersion,
// key cast (availCapa.ValidityEndDate as datub) as ValidityEndDate,
key availCapa.ValidityEndDate as ValidityEndDate,
key availCapa.WeekDay,
key cast (availCapa.AvailableCapacityShift as char1) as AvailableCapacityShift,
//key cast (availCapa.CalendarDate as datub) as CalendarDate,
key availCapa.CalendarDate as CalendarDate,
cast (availCapa.ShiftStartDate as datub) as ShiftStartDate,
cast (availCapa.ShiftStartTime as kapbegzeit) as ShiftStartTime,
cast (availCapa.ShiftEndDate as datub) as ShiftEndDate,
cast (availCapa.ShiftEndTime as kapbegzeit) as ShiftEndTime,
fltp_to_dec(availCapa.CapacityBreakDuration as pph_cap_eval_breakhours) as CapacityBreakDuration,
availCapa.WorkCenterCapacityUnit,
availCapa.WorkCenterUtilizationUnit,
cast (availCapa.ValidityBeginDate as datub) as ValidityBeginDate,
availCapa.CalendarMonth,
availCapa.CalendarYear,
availCapa.CalendarWeek,
cast (availCapa.workdays as int4) as WorkDays,
//availCapa.WorkDays as WorkDays,
cast (availCapa.ShiftName as char4) as ShiftName,
availCapa.ShiftDefinition,
_Text[1:Language=$session.system_language].ShiftDefinitionName as ShiftDefinitionName,
availCapa.ShiftGrouping,
cast (availCapa.WorkDayRule as kapfabtag) as WorkDayRule,
availCapa.FactoryCalendar,
cast (availCapa.CapacityStartTime as kapbegzt) as CapacityStartTime,
cast( availCapa.CapacityEndTime as kapendzt) as CapacityEndTime,
//cast ( availCapa.CapacityNumberOfCapacities as kapanzahl) as CapacityNumberOfCapacities,
availCapa.CapacityNumberOfCapacities as CapacityNumberOfCapacities,
//cast (availCapa.CapacityPlanUtilizationPercent as nutzgrad) as CapacityPlanUtilizationPercent,
availCapa.CapacityPlanUtilizationPercent as CapacityPlanUtilizationPercent,
// fltp_to_dec(availCapa.TotOperatingDurationInHours as kapazit_eh) as TotOperatingDurationInHours,
cast(round(fltp_to_dec(availCapa.TotOperatingDurationInHours as abap.dec(10,5)),2) as kapazit_eh) as TotOperatingDurationInHours,
// fltp_to_dec(availCapa.TotOperatingDuration as kapazit_eh) as TotOperatingDuration,
// fltp_to_dec(availCapa.CapacityOperatingDuration as kapazit_h) as OperatingCapacityDurationInHrs,
cast(round(fltp_to_dec(availCapa.CapacityOperatingDuration as abap.dec(10,5)),2) as kapazit_h)as OperatingCapacityDurationInHrs,
// availCapa.CapacityQuantityUnit as CapacityQuantityUnit,
_Capacity
}