A_WorkCenterCapacity

DDL: A_WORKCENTERCAPACITY SQL: AWRKCTRCAP Type: view COMPOSITE

Capacity Header

A_WorkCenterCapacity is a Composite CDS View that provides data about "Capacity Header" in SAP S/4HANA. It reads from 1 data source (I_Capacity) and exposes 26 fields with key field CapacityInternalID. It has 2 associations to related views.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_Capacity I_Capacity from

Associations (2)

CardinalityTargetAliasCondition
[1..*] A_WorkCenterCapacityText _CapacityText $projection.CapacityInternalID = _CapacityText.CapacityInternalID
[1..*] A_WorkCenterCapacityInterval_2 _CapacityInterval $projection.CapacityInternalID = _CapacityInterval.CapacityInternalID and $projection.CapacityActiveVersion = _CapacityInterval.CapacityActiveVersion

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AWRKCTRCAP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Capacity Header view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.updateEnabled true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID
Capacity Capacity
CapacityCategoryCode CapacityCategoryCode
CapacityActiveVersion CapacityActiveVersion
CapacityIsFinite CapacityIsFinite
CapacityIsPooled CapacityIsPooled
CapacityHasIndivCapacities CapacityHasIndivCapacities
CapacityIsExcldFrmLongTermPlng CapacityIsExcldFrmLongTermPlng
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityResponsiblePlanner CapacityResponsiblePlanner
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
CapacityBreakDuration CapacityBreakDuration
Plant Plant
FactoryCalendar FactoryCalendar
AuthorizationGroup AuthorizationGroup
ShiftGroup ShiftGroup
CapacityStartTime CapacityStartTime
CapacityEndTime CapacityEndTime
CapIsUsedInMultiOperations CapIsUsedInMultiOperations
ReferencedCapacityInternalID ReferencedCapacityInternalID
CapOverloadThresholdInPercent CapOverloadThresholdInPercent
CapacityQuantityUnit CapacityQuantityUnit
CapacityBaseQtyUnit CapacityBaseQtyUnit
CapacityLastChangeDateTime CapacityLastChangeDateTime
_CapacityText _CapacityText
_CapacityInterval _CapacityInterval 
@AbapCatalog.sqlViewName: 'AWRKCTRCAP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Capacity Header'
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #S, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@ObjectModel.updateEnabled: true
define view A_WorkCenterCapacity
  as select from I_Capacity
  association [1..*] to A_WorkCenterCapacityText       as _CapacityText     on  $projection.CapacityInternalID = _CapacityText.CapacityInternalID
  association [1..*] to A_WorkCenterCapacityInterval_2 as _CapacityInterval on  $projection.CapacityInternalID    = _CapacityInterval.CapacityInternalID
                                                                            and $projection.CapacityActiveVersion = _CapacityInterval.CapacityActiveVersion
{

  key CapacityInternalID,
      // Attributes

      Capacity,
      CapacityCategoryCode,
      CapacityActiveVersion,
      CapacityIsFinite,
      CapacityIsPooled,
      CapacityHasIndivCapacities,
      CapacityIsExcldFrmLongTermPlng,
      CapacityNumberOfCapacities,
      CapacityResponsiblePlanner,
      CapacityPlanUtilizationPercent,
      CapacityBreakDuration,

      // Assignments

      Plant,
      FactoryCalendar,
      AuthorizationGroup,
      ShiftGroup,

      // Times

      CapacityStartTime,
      CapacityEndTime,

      CapIsUsedInMultiOperations,
      ReferencedCapacityInternalID,
      CapOverloadThresholdInPercent,

      // Unit of Measures

      @Semantics.unitOfMeasure: true
      CapacityQuantityUnit,
      @Semantics.unitOfMeasure: true
      CapacityBaseQtyUnit,
      
      CapacityLastChangeDateTime,

      _CapacityText,
      _CapacityInterval
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPACITY"
],
"ASSOCIATED":
[
"A_WORKCENTERCAPACITYINTERVAL_2",
"A_WORKCENTERCAPACITYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More