I_WrkCtrAvailableCapacityTP

DDL: I_WRKCTRAVAILABLECAPACITYTP SQL: IWCAVAILCAPTP Type: view TRANSACTIONAL Package: PPH_VDM_CAP_EVAL

Total Available Capacity of Work Center

I_WrkCtrAvailableCapacityTP is a Transactional CDS View that provides data about "Total Available Capacity of Work Center" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterAvailableCapacity) and exposes 37 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CalendarDate. It has 1 association to related views. Part of development package PPH_VDM_CAP_EVAL.

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterAvailableCapacity availCapa from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_WorkCenterCapOverviewTP _workCenterResponsible $projection.WorkCenterInternalID = _workCenterResponsible.WorkCenterInternalID and $projection.WorkCenterTypeCode = _workCenterResponsible.WorkCenterTypeCode and $projection.CapacityCategoryAllocation = _workCenterResponsible.CapacityCategoryAllocation and $projection.CapacityInternalID = _workCenterResponsible.CapacityInternalID

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IWCAVAILCAPTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence CFSWCAVAILCAP_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Total Available Capacity of Work Center view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterAvailableCapacity WorkCenterInternalID
KEY WorkCenterTypeCode I_WorkCenterAvailableCapacity WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WorkCenterAvailableCapacity CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterAvailableCapacity CapacityInternalID
KEY CalendarDate I_WorkCenterAvailableCapacity CalendarDate
KEY ValidityEndDate I_WorkCenterAvailableCapacity ValidityEndDate
KEY CapacityActiveVersion I_WorkCenterAvailableCapacity CapacityActiveVersion
KEY AvailableCapacityShift I_WorkCenterAvailableCapacity AvailableCapacityShift
KEY WeekDay I_WorkCenterAvailableCapacity WeekDay
ShiftStartDate I_WorkCenterAvailableCapacity ShiftStartDate
ShiftStartTime I_WorkCenterAvailableCapacity ShiftStartTime
ShiftEndDate I_WorkCenterAvailableCapacity ShiftEndDate
ShiftEndTime I_WorkCenterAvailableCapacity ShiftEndTime
CalendarMonth I_WorkCenterAvailableCapacity CalendarMonth
CalendarYear I_WorkCenterAvailableCapacity CalendarYear
CalendarWeek I_WorkCenterAvailableCapacity CalendarWeek
WorkDays I_WorkCenterAvailableCapacity WorkDays
ShiftName I_WorkCenterAvailableCapacity ShiftName
ShiftDefinition I_WorkCenterAvailableCapacity ShiftDefinition
ShiftDefinitionName I_WorkCenterAvailableCapacity ShiftDefinitionName
ShiftGrouping I_WorkCenterAvailableCapacity ShiftGrouping
WorkDayRule I_WorkCenterAvailableCapacity WorkDayRule
FactoryCalendar I_WorkCenterAvailableCapacity FactoryCalendar
CapacityStartTime I_WorkCenterAvailableCapacity CapacityStartTime
CapacityEndTime I_WorkCenterAvailableCapacity CapacityEndTime
CapacityBreakDuration I_WorkCenterAvailableCapacity CapacityBreakDuration
WorkCenterCapacityUnit I_WorkCenterAvailableCapacity WorkCenterCapacityUnit
CapacityNumberOfCapacities I_WorkCenterAvailableCapacity CapacityNumberOfCapacities
WorkCenterUtilizationUnit I_WorkCenterAvailableCapacity WorkCenterUtilizationUnit
CapacityPlanUtilizationPercent I_WorkCenterAvailableCapacity CapacityPlanUtilizationPercent
ValidityBeginDate I_WorkCenterAvailableCapacity ValidityBeginDate
ShiftStatusText
ShiftStatusCode
TotOperatingDurationInHours I_WorkCenterAvailableCapacity TotOperatingDurationInHours
OperatingCapacityDurationInHrs I_WorkCenterAvailableCapacity OperatingCapacityDurationInHrs
_workCenterResponsible _workCenterResponsible
_Capacity _Capacity
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IWCAVAILCAPTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#CHECK
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    modelCategory: #BUSINESS_OBJECT,
    draftEnabled: true,
    writeDraftPersistence: 'CFSWCAVAILCAP_D',
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    semanticKey: ['WorkCenterInternalID', 'WorkCenterTypeCode', 'CapacityCategoryAllocation' ,
                   'CapacityInternalID'],
    representativeKey: ['CapacityActiveVersion', 'AvailableCapacityShift', 'WeekDay',
                   'ValidityEndDate', 'CalendarDate']
}
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'Total Available Capacity of Work Center'

define view I_WrkCtrAvailableCapacityTP
  as select from I_WorkCenterAvailableCapacity as availCapa
  association [1..1] to I_WorkCenterCapOverviewTP as _workCenterResponsible on  $projection.WorkCenterInternalID       = _workCenterResponsible.WorkCenterInternalID
                                                                            and $projection.WorkCenterTypeCode         = _workCenterResponsible.WorkCenterTypeCode
                                                                            and $projection.CapacityCategoryAllocation = _workCenterResponsible.CapacityCategoryAllocation
                                                                            and $projection.CapacityInternalID         = _workCenterResponsible.CapacityInternalID
{

      @ObjectModel.readOnly: true
      @UI.hidden: true
  key availCapa.WorkCenterInternalID,

      @ObjectModel.readOnly: true
      @UI.hidden: true
  key availCapa.WorkCenterTypeCode,

      @ObjectModel.readOnly: true
      @UI.hidden: true
  key availCapa.CapacityCategoryAllocation,

      @ObjectModel.readOnly: true
      @UI.hidden: true
  key availCapa.CapacityInternalID,

      @ObjectModel.readOnly: true
  key availCapa.CalendarDate,

      @ObjectModel.readOnly: true
      @UI.hidden: true
  key availCapa.ValidityEndDate,

      @ObjectModel.readOnly: true
      @UI.hidden: true
  key availCapa.CapacityActiveVersion,

      @ObjectModel.readOnly: true
      @UI.hidden: true
  key availCapa.AvailableCapacityShift,

      @ObjectModel.readOnly: true
      @UI.hidden: true
  key availCapa.WeekDay,
        
      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.ShiftStartDate,
      @ObjectModel.readOnly: false
      availCapa.ShiftStartTime,

      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.ShiftEndDate,
      @ObjectModel.readOnly: false
      availCapa.ShiftEndTime,

      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.CalendarMonth,
      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.CalendarYear,
      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.CalendarWeek,

      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.WorkDays,
      @ObjectModel.readOnly: true
      availCapa.ShiftName,
      @ObjectModel.readOnly: true
      availCapa.ShiftDefinition,
      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.ShiftDefinitionName,
      @ObjectModel.readOnly: true
      availCapa.ShiftGrouping,
      @ObjectModel.readOnly: true
      availCapa.WorkDayRule,
      @ObjectModel.readOnly: true
      availCapa.FactoryCalendar,
      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.CapacityStartTime,
      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.CapacityEndTime,
      @ObjectModel.readOnly: true
      availCapa.CapacityBreakDuration,
      @ObjectModel.readOnly: true
      //@UI.hidden: true

      availCapa.WorkCenterCapacityUnit,
      // @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.readOnly: false
      @ObjectModel.mandatory : true
      availCapa.CapacityNumberOfCapacities,
      @ObjectModel.readOnly: true
      // @UI.hidden: true

      availCapa.WorkCenterUtilizationUnit,
      // @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      @ObjectModel.readOnly: false
      @ObjectModel.mandatory : true
      availCapa.CapacityPlanUtilizationPercent,
      @ObjectModel.readOnly: true
      @UI.hidden: true
      availCapa.ValidityBeginDate,

      @ObjectModel.readOnly: true
      @UI.hidden: true
      cast ('' as char10 )                     as ShiftStatusText,
      @ObjectModel.readOnly: true
      @UI.hidden: true
      cast ('' as cfs_interval_change_status ) as ShiftStatusCode,

      @ObjectModel.readOnly: true
      availCapa.TotOperatingDurationInHours,

      @ObjectModel.readOnly: true
      availCapa.OperatingCapacityDurationInHrs,

      @ObjectModel: {
         association: {
             type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
         }
      }
      _workCenterResponsible,
      _Capacity



}