I_WORKCENTERCAPACITYINTERVAL
WorkCenter Capacity Intervals
I_WORKCENTERCAPACITYINTERVAL is a CDS View in S/4HANA. WorkCenter Capacity Intervals. It contains 13 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_WorkCenterCapacityInterval | view | from | COMPOSITE | Capacity Interval |
| I_WrkCtrCapShiftIntervalTP | view | from | TRANSACTIONAL | Work Center Shift Interval |
| P_WorkCenterCapacityDefinition | view | left_outer | COMPOSITE |
Fields (13)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AvailableCapacityType | CapacityActiveVersion | 2 |
| KEY | CapacityCategoryAllocation | CapacityCategoryAllocation | 2 |
| KEY | CapacityInternalID | CapacityInternalID | 2 |
| KEY | ValidityEndDate | IntervalEndDate | 1 |
| KEY | WorkCenterInternalID | WorkCenterInternalID | 2 |
| KEY | WorkCenterTypeCode | WorkCenterTypeCode | 2 |
| AvailableCapacityIntervalDurn | AvailableCapacityIntervalDurn | 1 | |
| Plant | Plant | 1 | |
| ShiftSequence | ShiftSequence | 1 | |
| StdAvailableCapacityIsValid | StdAvailableCapacityIsValid | 1 | |
| ValidityBeginDate | IntervalStartDate | 1 | |
| WorkCenter | WorkCenter | 1 | |
| WorkDayRule | WorkDayRule | 1 |
@AbapCatalog.sqlViewName: 'IWRKCTRCAPINTVL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'WorkCenter Capacity Intervals'
define view I_WorkCenterCapacityInterval
as select distinct from I_WorkCenterCapacity as WorkCenterCapacity
left outer join P_WrkCtrAvailableCapInterval as ShiftInterval on WorkCenterCapacity.CapacityInternalID = ShiftInterval.CapacityInternalID
{
key WorkCenterCapacity.WorkCenterInternalID as WorkCenterInternalID,
key WorkCenterCapacity.WorkCenterTypeCode as WorkCenterTypeCode,
key WorkCenterCapacity.CapacityCategoryAllocation as CapacityCategoryAllocation,
key WorkCenterCapacity.CapacityInternalID as CapacityInternalID,
key
case
when _Capacity.CapacityActiveVersion = '00'
then _Capacity.CapacityActiveVersion
else coalesce( ShiftInterval.AvailableCapacityType,WorkCenterCapacity._Capacity.CapacityActiveVersion)
end as AvailableCapacityType,
key
case when _Capacity.CapacityActiveVersion = '00'
then WorkCenterCapacity.ValidityEndDate
else
coalesce( ShiftInterval.ValidityEndDate, WorkCenterCapacity.ValidityEndDate )
end as ValidityEndDate,
case when _Capacity.CapacityActiveVersion = '00'
then WorkCenterCapacity.ValidityStartDate
else
coalesce( dats_add_days(ShiftInterval.ValidityBeginDate,1,'FAIL'), WorkCenterCapacity.ValidityStartDate)
end as ValidityBeginDate,
WorkCenterCapacity.WorkCenter as WorkCenter,
WorkCenterCapacity.Plant as Plant,
case
when _Capacity.CapacityActiveVersion = '00'
then cast ('' as workdayrule)
else
coalesce( ShiftInterval.WorkDayRule, cast ('' as workdayrule))
end as WorkDayRule,
case
when _Capacity.CapacityActiveVersion = '00' or ShiftInterval.AvailableCapacityIntervalDurn is null or ShiftInterval.AvailableCapacityIntervalDurn = '00'
then '01'
else
ShiftInterval.AvailableCapacityIntervalDurn
end as AvailableCapacityIntervalDurn,
// coalesce( ShiftInterval.AvailableCapacityIntervalDurn,'01') as AvailableCapacityIntervalDurn,
cast ( case
when _Capacity.CapacityActiveVersion = '00'
then cast ('X' as kap_kopf)
else
coalesce(ShiftInterval.StdAvailableCapacityIsValid,cast('X' as kap_kopf))
end as kap_kopf preserving type) as StdAvailableCapacityIsValid,
case
when _Capacity.CapacityActiveVersion = '00'
then cast ('' as schprog )
else
coalesce(ShiftInterval.ShiftSequence,cast ('' as schprog ))
end as ShiftSequence,
case
when _Capacity.CapacityActiveVersion = '00'
then cast ( _Capacity.CapacityNumberOfCapacities as kapanzahl)
else
case
when ShiftInterval.StdAvailableCapacityIsValid = '' then
cast (ShiftInterval.CapacityNumberOfCapacities as kapanzahl)
else
cast (_Capacity.CapacityNumberOfCapacities as kapanzahl)
end
end as CapacityNumberOfCapacities,
case
when _Capacity.CapacityActiveVersion = '00'
then _Capacity.CapacityPlanUtilizationPercent
else
case
when ShiftInterval.StdAvailableCapacityIsValid = '' then
ShiftInterval.CapacityPlanUtilizationPercent
else
_Capacity.CapacityPlanUtilizationPercent
end
end as CapacityPlanUtilizationPercent,
_Capacity
}
where
ShiftInterval.AvailableCapacityType = WorkCenterCapacity._Capacity.CapacityActiveVersion
or ShiftInterval.AvailableCapacityType is null
or _Capacity.CapacityActiveVersion = '00'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPACITY",
"I_WORKCENTERCAPACITY",
"P_WRKCTRAVAILABLECAPINTERVAL"
],
"ASSOCIATED":
[
"I_CAPACITY"
],
"BASE":
[
"I_WORKCENTERCAPACITY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/