I_WorkCenterCapOverviewTP

DDL: I_WORKCENTERCAPOVERVIEWTP SQL: IWCCAPOVWTP Type: view TRANSACTIONAL

Work Center Capacity Overview

I_WorkCenterCapOverviewTP is a Transactional CDS View that provides data about "Work Center Capacity Overview" in SAP S/4HANA. It reads from 1 data source (I_WrkCtrCapByAreaOfRespy) and exposes 15 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID. It has 2 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_WrkCtrCapByAreaOfRespy _WorkCenterAOR from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_WrkCtrAvailableCapacityTP _availableCapacity $projection.WorkCenterInternalID = _availableCapacity.WorkCenterInternalID and $projection.WorkCenterTypeCode = _availableCapacity.WorkCenterTypeCode and $projection.CapacityCategoryAllocation = _availableCapacity.CapacityCategoryAllocation and $projection.CapacityInternalID = _availableCapacity.CapacityInternalID
[1..*] I_WrkCtrCapShiftIntervalTP _availableInterval $projection.WorkCenterInternalID = _availableInterval.WorkCenterInternalID and $projection.WorkCenterTypeCode = _availableInterval.WorkCenterTypeCode and $projection.CapacityCategoryAllocation = _availableInterval.CapacityCategoryAllocation and $projection.CapacityInternalID = _availableInterval.CapacityInternalID

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IWCCAPOVWTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence CFSWCCAPOVW_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.entityChangeStateId CapacityLastChangeDateTime view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Work Center Capacity Overview view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WrkCtrCapByAreaOfRespy WorkCenterInternalID
KEY WorkCenterTypeCode I_WrkCtrCapByAreaOfRespy WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WrkCtrCapByAreaOfRespy CapacityCategoryAllocation
KEY CapacityInternalID I_WrkCtrCapByAreaOfRespy CapacityInternalID
LastChangeDateTime
Plant Plant
WorkCenter WorkCenter
CapacityCategoryCode CapacityCategoryCode
Capacity Capacity
CapacityActiveVersion I_WrkCtrCapByAreaOfRespy CapacityActiveVersion
WorkCenterResponsible I_WrkCtrCapByAreaOfRespy WorkCenterResponsible
ShiftTableHasChanged
CapacityLastChangeDateTime CapacityLastChangeDateTime
_availableCapacity _availableCapacity
_availableInterval _availableInterval 
@AbapCatalog.sqlViewName: 'IWCCAPOVWTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    modelCategory: #BUSINESS_OBJECT,
    compositionRoot: true,
    transactionalProcessingEnabled: true,
    draftEnabled: true,
    writeDraftPersistence: 'CFSWCCAPOVW_D',
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    semanticKey: ['WorkCenterInternalID', 'WorkCenterTypeCode', 'CapacityCategoryAllocation' ,
                   'CapacityInternalID'],
   entityChangeStateId: 'CapacityLastChangeDateTime' -- 'ETag' for handling the optimistic lock phase
}
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'Work Center Capacity Overview'


define view I_WorkCenterCapOverviewTP
  as select from I_WrkCtrCapByAreaOfRespy as _WorkCenterAOR
  association [1..*] to I_WrkCtrAvailableCapacityTP as _availableCapacity on  $projection.WorkCenterInternalID       = _availableCapacity.WorkCenterInternalID
                                                                          and $projection.WorkCenterTypeCode         = _availableCapacity.WorkCenterTypeCode
                                                                          and $projection.CapacityCategoryAllocation = _availableCapacity.CapacityCategoryAllocation
                                                                          and $projection.CapacityInternalID         = _availableCapacity.CapacityInternalID

  association [1..*] to I_WrkCtrCapShiftIntervalTP  as _availableInterval on  $projection.WorkCenterInternalID       = _availableInterval.WorkCenterInternalID
                                                                          and $projection.WorkCenterTypeCode         = _availableInterval.WorkCenterTypeCode
                                                                          and $projection.CapacityCategoryAllocation = _availableInterval.CapacityCategoryAllocation
                                                                          and $projection.CapacityInternalID         = _availableInterval.CapacityInternalID

{

      @ObjectModel.readOnly: true
  key _WorkCenterAOR.WorkCenterInternalID,

      @ObjectModel.readOnly: true
  key _WorkCenterAOR.WorkCenterTypeCode,

      @ObjectModel.readOnly: true
  key _WorkCenterAOR.CapacityCategoryAllocation,

      @ObjectModel.readOnly: true
  key _WorkCenterAOR.CapacityInternalID,

      @ObjectModel.readOnly: true
      cast (LastChangeDateTime as dec15) as LastChangeDateTime,

      @ObjectModel.readOnly: true
      Plant,

      @ObjectModel.readOnly: true
      WorkCenter,

      @ObjectModel.readOnly: true
      CapacityCategoryCode,

      @ObjectModel.readOnly: true
      Capacity,

      @ObjectModel.readOnly: true
      _WorkCenterAOR.CapacityActiveVersion,

      @ObjectModel.readOnly: true
      _WorkCenterAOR.WorkCenterResponsible,
      
      cast('X' as boolean)               as ShiftTableHasChanged,
      CapacityLastChangeDateTime,


      @ObjectModel: {
          association: { type: [#TO_COMPOSITION_CHILD ] }
      }
      _availableCapacity,

      @ObjectModel: {
          association: { type: [#TO_COMPOSITION_CHILD ] }
      }
      _availableInterval    


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WRKCTRCAPBYAREAOFRESPY"
],
"ASSOCIATED":
[
"I_WRKCTRAVAILABLECAPACITYTP",
"I_WRKCTRCAPSHIFTINTERVALTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More