R_WorkCenterCapacityIntervalTP

DDL: R_WORKCENTERCAPACITYINTERVALTP SQL: RWKCCAPINTVLTP Type: view_entity TRANSACTIONAL Package: VDM_PP_MD_WKC

Capacity Interval

R_WorkCenterCapacityIntervalTP is a Transactional CDS View that provides data about "Capacity Interval" in SAP S/4HANA. It reads from 2 data sources (R_WorkCenterCapacityTP, I_WorkCenterCapacityInterval_3) and exposes 19 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityActiveVersion. It has 1 association to related views. Part of development package VDM_PP_MD_WKC.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
R_WorkCenterCapacityTP _Cap inner
I_WorkCenterCapacityInterval_3 _Intvl from

Associations (1)

CardinalityTargetAliasCondition
[1..*] R_WorkCenterCapacityShiftTP _Shift

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Capacity Interval view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenterCapacityInterval_3 WorkCenterInternalID
KEY WorkCenterTypeCode I_WorkCenterCapacityInterval_3 WorkCenterTypeCode
KEY CapacityCategoryAllocation I_WorkCenterCapacityInterval_3 CapacityCategoryAllocation
KEY CapacityInternalID I_WorkCenterCapacityInterval_3 CapacityInternalID
KEY CapacityActiveVersion I_WorkCenterCapacityInterval_3 CapacityActiveVersion
KEY IntervalEndDate I_WorkCenterCapacityInterval_3 IntervalEndDate
IntervalStartDate I_WorkCenterCapacityInterval_3 IntervalStartDate
StdAvailableCapacityIsValid I_WorkCenterCapacityInterval_3 StdAvailableCapacityIsValid
AvailableCapacityIntervalDurn I_WorkCenterCapacityInterval_3 AvailableCapacityIntervalDurn
ShiftSequence I_WorkCenterCapacityInterval_3 ShiftSequence
WorkDayRule I_WorkCenterCapacityInterval_3 WorkDayRule
CapacityNumberOfShifts I_WorkCenterCapacityInterval_3 CapacityNumberOfShifts
CapacityNumberOfCapacities I_WorkCenterCapacityInterval_3 CapacityNumberOfCapacities
CapacityPlanUtilizationPercent I_WorkCenterCapacityInterval_3 CapacityPlanUtilizationPercent
CapacityLastChangeDateTime I_WorkCenterCapacityInterval_3 CapacityLastChangeDateTime
CapIntervalIsGeneratedInBuffer
_CapHeader _CapHeader
_Shift _Shift
_Header _Header 
//@AbapCatalog.sqlViewName: 'RWKCCAPINTVLTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Capacity Interval'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
define view entity R_WorkCenterCapacityIntervalTP
  as select from I_WorkCenterCapacityInterval_3 as _Intvl
    inner join   R_WorkCenterCapacityTP         as _Cap on  _Intvl.CapacityInternalID         = _Cap.CapacityInternalID
                                                        and _Intvl.CapacityCategoryAllocation = _Cap.CapacityCategoryAllocation
                                                        and _Intvl.WorkCenterInternalID       = _Cap.WorkCenterInternalID
                                                        and _Intvl.WorkCenterTypeCode         = _Cap.WorkCenterTypeCode

  -- to Capacity Shift
  composition [1..*] of R_WorkCenterCapacityShiftTP as _Shift

  association to parent R_WorkCenterCapacityTP      as _CapHeader on  $projection.CapacityInternalID         = _CapHeader.CapacityInternalID
                                                                  and $projection.CapacityCategoryAllocation = _CapHeader.CapacityCategoryAllocation
                                                                  and $projection.WorkCenterInternalID       = _CapHeader.WorkCenterInternalID
                                                                  and $projection.WorkCenterTypeCode         = _CapHeader.WorkCenterTypeCode
  /*Association To Header*/
  association to R_WorkCenterTP                     as _Header    on  $projection.WorkCenterInternalID = _Header.WorkCenterInternalID
                                                                  and $projection.WorkCenterTypeCode   = _Header.WorkCenterTypeCode

{
      //I_WorkCenterCapacityInterval_3

  key _Intvl.WorkCenterInternalID,
  key _Intvl.WorkCenterTypeCode,
  key _Intvl.CapacityCategoryAllocation,
  key _Intvl.CapacityInternalID,
  key _Intvl.CapacityActiveVersion,
  key _Intvl.IntervalEndDate,
      _Intvl.IntervalStartDate,
      _Intvl.StdAvailableCapacityIsValid,
      _Intvl.AvailableCapacityIntervalDurn,
      _Intvl.ShiftSequence,
      _Intvl.WorkDayRule,
      _Intvl.CapacityNumberOfShifts,
      _Intvl.CapacityNumberOfCapacities,
      _Intvl.CapacityPlanUtilizationPercent,
      _Intvl.CapacityLastChangeDateTime,
      cast( '' as kap_kopf ) as CapIntervalIsGeneratedInBuffer,
      /*Associations*/
      @Consumption.hidden: true
      _CapHeader,
      _Shift,
      _Header
}

Learn More