A_WorkCenterCapacityShift_2

DDL: A_WORKCENTERCAPACITYSHIFT_2 SQL: AWRKCTRCAPSHIFT2 Type: view COMPOSITE

Capacity Shift Version 2

A_WorkCenterCapacityShift_2 is a Composite CDS View that provides data about "Capacity Shift Version 2" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapacityShift_2) and exposes 18 fields with key fields CapacityInternalID, CapacityActiveVersion, IntervalEndDate, WeekDay, AvailableCapacityShift.

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacityShift_2 I_WorkCenterCapacityShift_2 from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName AWRKCTRCAPSHIFT2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Capacity Shift Version 2 view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true 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.updateEnabled true view
ObjectModel.createEnabled true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID
KEY CapacityActiveVersion CapacityActiveVersion
KEY IntervalEndDate IntervalEndDate
KEY WeekDay WeekDay
KEY AvailableCapacityShift AvailableCapacityShift
IntervalStartDate IntervalStartDate
WorkDayRule WorkDayRule
ShiftDefinition ShiftDefinition
ShiftStartTime ShiftStartTime
ShiftEndTime ShiftEndTime
ShiftDefValidityStartDate ShiftDefValidityStartDate
ShiftDefValidityEndDate ShiftDefValidityEndDate
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
CapacityBreakDuration CapacityBreakDuration
OperatingDurationInSeconds OperatingDurationInSeconds
TotOperatingDurationInSeconds TotOperatingDurationInSeconds
CapacityLastChangeDateTime CapacityLastChangeDateTime
@AbapCatalog.sqlViewName: 'AWRKCTRCAPSHIFT2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Capacity Shift Version 2'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel.updateEnabled: true
@ObjectModel.createEnabled: true
define view A_WorkCenterCapacityShift_2
  as select from I_WorkCenterCapacityShift_2
{
  key CapacityInternalID,
  key CapacityActiveVersion,
  key IntervalEndDate,
  key WeekDay,
  key AvailableCapacityShift,
      IntervalStartDate,
      WorkDayRule,
      ShiftDefinition,
      ShiftStartTime,
      ShiftEndTime,
      ShiftDefValidityStartDate,
      ShiftDefValidityEndDate,
      CapacityNumberOfCapacities,
      CapacityPlanUtilizationPercent,
      CapacityBreakDuration,
      OperatingDurationInSeconds,
      TotOperatingDurationInSeconds,
      CapacityLastChangeDateTime
}