A_WorkCenterCapacityInterval

DDL: A_WORKCENTERCAPACITYINTERVAL SQL: AWRKCTRCAPINTVL Type: view COMPOSITE

Capacity Interval

A_WorkCenterCapacityInterval is a Composite CDS View that provides data about "Capacity Interval" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapacityInterval) and exposes 14 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityActiveVersion. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacityInterval Interval from

Associations (1)

CardinalityTargetAliasCondition
[1..*] A_WorkCenterCapacityShift _WorkCenterShift $projection.WorkCenterInternalID = _WorkCenterShift.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenterShift.WorkCenterTypeCode and $projection.CapacityInternalID = _WorkCenterShift.CapacityInternalID and $projection.CapacityCategoryAllocation = _WorkCenterShift.CapacityCategoryAllocation and $projection.CapacityActiveVersion = _WorkCenterShift.CapacityActiveVersion and $projection.IntervalEndDate = _WorkCenterShift.IntervalEndDate

Annotations (14)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacityInterval WorkCenterInternalID
KEY WorkCenterTypeCode I_WorkCenterCapacityInterval WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WorkCenterCapacityInterval CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacityInterval CapacityInternalID
KEY CapacityActiveVersion I_WorkCenterCapacityInterval AvailableCapacityType
KEY IntervalEndDate I_WorkCenterCapacityInterval ValidityEndDate
IntervalStartDate I_WorkCenterCapacityInterval ValidityBeginDate
WorkCenter I_WorkCenterCapacityInterval WorkCenter
Plant I_WorkCenterCapacityInterval Plant
WorkDayRule I_WorkCenterCapacityInterval WorkDayRule
AvailableCapacityIntervalDurn I_WorkCenterCapacityInterval AvailableCapacityIntervalDurn
ShiftSequence I_WorkCenterCapacityInterval ShiftSequence
StdAvailableCapacityIsValid I_WorkCenterCapacityInterval StdAvailableCapacityIsValid
_WorkCenterShift _WorkCenterShift 
@AbapCatalog.sqlViewName: 'AWRKCTRCAPINTVL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Capacity Interval'
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true

define view A_WorkCenterCapacityInterval
  as select from I_WorkCenterCapacityInterval as Interval
  association [1..*] to A_WorkCenterCapacityShift as _WorkCenterShift on  $projection.WorkCenterInternalID       = _WorkCenterShift.WorkCenterInternalID
                                                                      and $projection.WorkCenterTypeCode         = _WorkCenterShift.WorkCenterTypeCode
                                                                      and $projection.CapacityInternalID         = _WorkCenterShift.CapacityInternalID
                                                                      and $projection.CapacityCategoryAllocation = _WorkCenterShift.CapacityCategoryAllocation
                                                                      and $projection.CapacityActiveVersion      = _WorkCenterShift.CapacityActiveVersion
                                                                      and $projection.IntervalEndDate            = _WorkCenterShift.IntervalEndDate

{

  key Interval.WorkCenterInternalID                                                                             as WorkCenterInternalID,
  key Interval.WorkCenterTypeCode                                                                               as WorkCenterTypeCode,
  key Interval.CapacityCategoryAllocation                                                                       as CapacityCategoryAllocation,
  key Interval.CapacityInternalID                                                                               as CapacityInternalID,
  key Interval.AvailableCapacityType                                                                            as CapacityActiveVersion,
  key Interval.ValidityEndDate                                                                                  as IntervalEndDate,
      Interval.ValidityBeginDate                                                                                as IntervalStartDate,
      Interval.WorkCenter                                                                                       as WorkCenter,
      Interval.Plant                                                                                            as Plant,
      Interval.WorkDayRule                                                                                      as WorkDayRule,
      Interval.AvailableCapacityIntervalDurn                                                                    as AvailableCapacityIntervalDurn,
      Interval.ShiftSequence                                                                                    as ShiftSequence,
      Interval.StdAvailableCapacityIsValid                                                                      as StdAvailableCapacityIsValid,
      _WorkCenterShift
}
where
  ValidityEndDate >= $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERCAPACITYINTERVAL"
],
"ASSOCIATED":
[
"A_WORKCENTERCAPACITYSHIFT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More