R_WorkCenterCapacityIntervalTP

DDL: R_WORKCENTERCAPACITYINTERVALTP SQL: RWKCCAPINTVLTP Type: view_entity TRANSACTIONAL

Capacity Interval

R_WorkCenterCapacityIntervalTP is a Transactional CDS View that provides data about "Capacity Interval" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapacityInterval_3) and exposes 18 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, CapacityActiveVersion. It has 1 association to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacityInterval_3 I_WorkCenterCapacityInterval_3 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 (18)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
KEY CapacityCategoryAllocation CapacityCategoryAllocation
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
_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
  -- 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 WorkCenterInternalID,
  key WorkCenterTypeCode,
  key CapacityCategoryAllocation,
  key CapacityInternalID,
  key CapacityActiveVersion,
  key IntervalEndDate,
      IntervalStartDate,
      StdAvailableCapacityIsValid,
      AvailableCapacityIntervalDurn,
      ShiftSequence,
      WorkDayRule,
      CapacityNumberOfShifts,
      CapacityNumberOfCapacities,
      CapacityPlanUtilizationPercent,
      CapacityLastChangeDateTime,
      /*Associations*/
      @Consumption.hidden: true
      _CapHeader,
      _Shift,
      _Header
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERCAPACITYINTERVAL_3"
],
"ASSOCIATED":
[
"R_WORKCENTERCAPACITYSHIFTTP",
"R_WORKCENTERCAPACITYTP",
"R_WORKCENTERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More