I_WrkCtrAvailableCapacityTP
Total Available Capacity of Work Center
I_WrkCtrAvailableCapacityTP is a Transactional CDS View that provides data about "Total Available Capacity of Work Center" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterAvailableCapacity) and exposes 37 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CalendarDate. It has 1 association to related views. Part of development package PPH_VDM_CAP_EVAL.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_WorkCenterAvailableCapacity | availCapa | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_WorkCenterCapOverviewTP | _workCenterResponsible | $projection.WorkCenterInternalID = _workCenterResponsible.WorkCenterInternalID and $projection.WorkCenterTypeCode = _workCenterResponsible.WorkCenterTypeCode and $projection.CapacityCategoryAllocation = _workCenterResponsible.CapacityCategoryAllocation and $projection.CapacityInternalID = _workCenterResponsible.CapacityInternalID |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | IWCAVAILCAPTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.modelCategory | #BUSINESS_OBJECT | view | |
| ObjectModel.draftEnabled | true | view | |
| ObjectModel.writeDraftPersistence | CFSWCAVAILCAP_D | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| EndUserText.label | Total Available Capacity of Work Center | view |
Fields (37)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | WorkCenterInternalID | I_WorkCenterAvailableCapacity | WorkCenterInternalID | |
| KEY | WorkCenterTypeCode | I_WorkCenterAvailableCapacity | WorkCenterTypeCode | |
| KEY | CapacityCategoryAllocation | I_WorkCenterAvailableCapacity | CapacityCategoryAllocation | |
| KEY | CapacityInternalID | I_WorkCenterAvailableCapacity | CapacityInternalID | |
| KEY | CalendarDate | I_WorkCenterAvailableCapacity | CalendarDate | |
| KEY | ValidityEndDate | I_WorkCenterAvailableCapacity | ValidityEndDate | |
| KEY | CapacityActiveVersion | I_WorkCenterAvailableCapacity | CapacityActiveVersion | |
| KEY | AvailableCapacityShift | I_WorkCenterAvailableCapacity | AvailableCapacityShift | |
| KEY | WeekDay | I_WorkCenterAvailableCapacity | WeekDay | |
| ShiftStartDate | I_WorkCenterAvailableCapacity | ShiftStartDate | ||
| ShiftStartTime | I_WorkCenterAvailableCapacity | ShiftStartTime | ||
| ShiftEndDate | I_WorkCenterAvailableCapacity | ShiftEndDate | ||
| ShiftEndTime | I_WorkCenterAvailableCapacity | ShiftEndTime | ||
| CalendarMonth | I_WorkCenterAvailableCapacity | CalendarMonth | ||
| CalendarYear | I_WorkCenterAvailableCapacity | CalendarYear | ||
| CalendarWeek | I_WorkCenterAvailableCapacity | CalendarWeek | ||
| WorkDays | I_WorkCenterAvailableCapacity | WorkDays | ||
| ShiftName | I_WorkCenterAvailableCapacity | ShiftName | ||
| ShiftDefinition | I_WorkCenterAvailableCapacity | ShiftDefinition | ||
| ShiftDefinitionName | I_WorkCenterAvailableCapacity | ShiftDefinitionName | ||
| ShiftGrouping | I_WorkCenterAvailableCapacity | ShiftGrouping | ||
| WorkDayRule | I_WorkCenterAvailableCapacity | WorkDayRule | ||
| FactoryCalendar | I_WorkCenterAvailableCapacity | FactoryCalendar | ||
| CapacityStartTime | I_WorkCenterAvailableCapacity | CapacityStartTime | ||
| CapacityEndTime | I_WorkCenterAvailableCapacity | CapacityEndTime | ||
| CapacityBreakDuration | I_WorkCenterAvailableCapacity | CapacityBreakDuration | ||
| WorkCenterCapacityUnit | I_WorkCenterAvailableCapacity | WorkCenterCapacityUnit | ||
| CapacityNumberOfCapacities | I_WorkCenterAvailableCapacity | CapacityNumberOfCapacities | ||
| WorkCenterUtilizationUnit | I_WorkCenterAvailableCapacity | WorkCenterUtilizationUnit | ||
| CapacityPlanUtilizationPercent | I_WorkCenterAvailableCapacity | CapacityPlanUtilizationPercent | ||
| ValidityBeginDate | I_WorkCenterAvailableCapacity | ValidityBeginDate | ||
| ShiftStatusText | ||||
| ShiftStatusCode | ||||
| TotOperatingDurationInHours | I_WorkCenterAvailableCapacity | TotOperatingDurationInHours | ||
| OperatingCapacityDurationInHrs | I_WorkCenterAvailableCapacity | OperatingCapacityDurationInHrs | ||
| _workCenterResponsible | _workCenterResponsible | |||
| _Capacity | _Capacity |
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IWCAVAILCAPTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#CHECK
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
modelCategory: #BUSINESS_OBJECT,
draftEnabled: true,
writeDraftPersistence: 'CFSWCAVAILCAP_D',
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
semanticKey: ['WorkCenterInternalID', 'WorkCenterTypeCode', 'CapacityCategoryAllocation' ,
'CapacityInternalID'],
representativeKey: ['CapacityActiveVersion', 'AvailableCapacityShift', 'WeekDay',
'ValidityEndDate', 'CalendarDate']
}
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'Total Available Capacity of Work Center'
define view I_WrkCtrAvailableCapacityTP
as select from I_WorkCenterAvailableCapacity as availCapa
association [1..1] to I_WorkCenterCapOverviewTP as _workCenterResponsible on $projection.WorkCenterInternalID = _workCenterResponsible.WorkCenterInternalID
and $projection.WorkCenterTypeCode = _workCenterResponsible.WorkCenterTypeCode
and $projection.CapacityCategoryAllocation = _workCenterResponsible.CapacityCategoryAllocation
and $projection.CapacityInternalID = _workCenterResponsible.CapacityInternalID
{
@ObjectModel.readOnly: true
@UI.hidden: true
key availCapa.WorkCenterInternalID,
@ObjectModel.readOnly: true
@UI.hidden: true
key availCapa.WorkCenterTypeCode,
@ObjectModel.readOnly: true
@UI.hidden: true
key availCapa.CapacityCategoryAllocation,
@ObjectModel.readOnly: true
@UI.hidden: true
key availCapa.CapacityInternalID,
@ObjectModel.readOnly: true
key availCapa.CalendarDate,
@ObjectModel.readOnly: true
@UI.hidden: true
key availCapa.ValidityEndDate,
@ObjectModel.readOnly: true
@UI.hidden: true
key availCapa.CapacityActiveVersion,
@ObjectModel.readOnly: true
@UI.hidden: true
key availCapa.AvailableCapacityShift,
@ObjectModel.readOnly: true
@UI.hidden: true
key availCapa.WeekDay,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.ShiftStartDate,
@ObjectModel.readOnly: false
availCapa.ShiftStartTime,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.ShiftEndDate,
@ObjectModel.readOnly: false
availCapa.ShiftEndTime,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.CalendarMonth,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.CalendarYear,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.CalendarWeek,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.WorkDays,
@ObjectModel.readOnly: true
availCapa.ShiftName,
@ObjectModel.readOnly: true
availCapa.ShiftDefinition,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.ShiftDefinitionName,
@ObjectModel.readOnly: true
availCapa.ShiftGrouping,
@ObjectModel.readOnly: true
availCapa.WorkDayRule,
@ObjectModel.readOnly: true
availCapa.FactoryCalendar,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.CapacityStartTime,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.CapacityEndTime,
@ObjectModel.readOnly: true
availCapa.CapacityBreakDuration,
@ObjectModel.readOnly: true
//@UI.hidden: true
availCapa.WorkCenterCapacityUnit,
// @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.readOnly: false
@ObjectModel.mandatory : true
availCapa.CapacityNumberOfCapacities,
@ObjectModel.readOnly: true
// @UI.hidden: true
availCapa.WorkCenterUtilizationUnit,
// @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@ObjectModel.readOnly: false
@ObjectModel.mandatory : true
availCapa.CapacityPlanUtilizationPercent,
@ObjectModel.readOnly: true
@UI.hidden: true
availCapa.ValidityBeginDate,
@ObjectModel.readOnly: true
@UI.hidden: true
cast ('' as char10 ) as ShiftStatusText,
@ObjectModel.readOnly: true
@UI.hidden: true
cast ('' as cfs_interval_change_status ) as ShiftStatusCode,
@ObjectModel.readOnly: true
availCapa.TotOperatingDurationInHours,
@ObjectModel.readOnly: true
availCapa.OperatingCapacityDurationInHrs,
@ObjectModel: {
association: {
type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
}
}
_workCenterResponsible,
_Capacity
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA