A_WorkCenterCapacityInterval_2

DDL: A_WORKCENTERCAPACITYINTERVAL_2 SQL: AWRKCTRCAPINTVL2 Type: view COMPOSITE

Capacity Interval Version 2

A_WorkCenterCapacityInterval_2 is a Composite CDS View that provides data about "Capacity Interval Version 2" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapacityInterval_2) and exposes 13 fields with key fields CapacityInternalID, CapacityActiveVersion, IntervalEndDate. It has 1 association to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacityInterval_2 I_WorkCenterCapacityInterval_2 from

Associations (1)

CardinalityTargetAliasCondition
[1..*] A_WorkCenterCapacityShift_2 _CapacityShift $projection.CapacityInternalID = _CapacityShift.CapacityInternalID and $projection.CapacityActiveVersion = _CapacityShift.CapacityActiveVersion and $projection.IntervalEndDate = _CapacityShift.IntervalEndDate

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName AWRKCTRCAPINTVL2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Capacity Interval Version 2 view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C 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 (13)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID
KEY CapacityActiveVersion CapacityActiveVersion
KEY IntervalEndDate IntervalEndDate
IntervalStartDate IntervalStartDate
StdAvailableCapacityIsValid StdAvailableCapacityIsValid
AvailableCapacityIntervalDurn AvailableCapacityIntervalDurn
ShiftSequence ShiftSequence
WorkDayRule WorkDayRule
CapacityNumberOfShifts CapacityNumberOfShifts
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
CapacityLastChangeDateTime CapacityLastChangeDateTime
_CapacityShift _CapacityShift 
@AbapCatalog.sqlViewName: 'AWRKCTRCAPINTVL2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Capacity Interval Version 2'
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@ObjectModel.updateEnabled: true
@ObjectModel.createEnabled: true
define view A_WorkCenterCapacityInterval_2
  as select from I_WorkCenterCapacityInterval_2
  association [1..*] to A_WorkCenterCapacityShift_2 as _CapacityShift on  $projection.CapacityInternalID    = _CapacityShift.CapacityInternalID
                                                                      and $projection.CapacityActiveVersion = _CapacityShift.CapacityActiveVersion
                                                                      and $projection.IntervalEndDate       = _CapacityShift.IntervalEndDate
{
  key CapacityInternalID,
  key CapacityActiveVersion,
  key IntervalEndDate,
      IntervalStartDate,
      StdAvailableCapacityIsValid,
      AvailableCapacityIntervalDurn,
      ShiftSequence,
      WorkDayRule,
      CapacityNumberOfShifts,
      CapacityNumberOfCapacities,
      CapacityPlanUtilizationPercent,
      CapacityLastChangeDateTime,
      _CapacityShift
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERCAPACITYINTERVAL_2"
],
"ASSOCIATED":
[
"A_WORKCENTERCAPACITYSHIFT_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More