R_WrkCtrPooledCapIntervalTP

DDL: R_WRKCTRPOOLEDCAPINTERVALTP SQL: RWRKCTRCAPINTVL Type: view_entity TRANSACTIONAL

Work Center Pooled Capacity Interval

R_WrkCtrPooledCapIntervalTP is a Transactional CDS View that provides data about "Work Center Pooled Capacity Interval" in SAP S/4HANA. It reads from 2 data sources (I_WorkCenterCapacityInterval_2, I_WorkCenterPooledCapacity) and exposes 15 fields with key fields CapacityInternalID, CapacityActiveVersion, IntervalEndDate. It has 1 association to related views.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkCenterCapacityInterval_2 _Interval from
I_WorkCenterPooledCapacity _PooledCapHeader inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] R_WorkCenterPooledCapShiftTP _Shift

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Pooled 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 (15)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID I_WorkCenterCapacityInterval_2 CapacityInternalID
KEY CapacityActiveVersion I_WorkCenterCapacityInterval_2 CapacityActiveVersion
KEY IntervalEndDate I_WorkCenterCapacityInterval_2 IntervalEndDate
IntervalStartDate I_WorkCenterCapacityInterval_2 IntervalStartDate
StdAvailableCapacityIsValid I_WorkCenterCapacityInterval_2 StdAvailableCapacityIsValid
ShiftSequence I_WorkCenterCapacityInterval_2 ShiftSequence
WorkDayRule I_WorkCenterCapacityInterval_2 WorkDayRule
CapacityNumberOfShifts I_WorkCenterCapacityInterval_2 CapacityNumberOfShifts
AvailableCapacityIntervalDurn I_WorkCenterCapacityInterval_2 AvailableCapacityIntervalDurn
CapacityNumberOfCapacities I_WorkCenterCapacityInterval_2 CapacityNumberOfCapacities
CapacityPlanUtilizationPercent I_WorkCenterCapacityInterval_2 CapacityPlanUtilizationPercent
CapacityLastChangeDateTime I_WorkCenterCapacityInterval_2 CapacityLastChangeDateTime
CapIntervalIsGeneratedInBuffer
_Header _Header
_Shift _Shift 
//@AbapCatalog.sqlViewName: 'RWRKCTRCAPINTVL'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Pooled 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_WrkCtrPooledCapIntervalTP
  as select from I_WorkCenterCapacityInterval_2 as _Interval
    inner join   I_WorkCenterPooledCapacity     as _PooledCapHeader on _Interval.CapacityInternalID = _PooledCapHeader.CapacityInternalID
  composition [1..*] of R_WorkCenterPooledCapShiftTP as _Shift
  association to parent R_WorkCenterPooledCapacityTP as _Header on $projection.CapacityInternalID = _Header.CapacityInternalID
{
  key _Interval.CapacityInternalID,
  key _Interval.CapacityActiveVersion,
  key _Interval.IntervalEndDate,
      _Interval.IntervalStartDate,
      _Interval.StdAvailableCapacityIsValid,
      _Interval.ShiftSequence,
      _Interval.WorkDayRule,
      _Interval.CapacityNumberOfShifts,
      _Interval.AvailableCapacityIntervalDurn,
      _Interval.CapacityNumberOfCapacities,
      _Interval.CapacityPlanUtilizationPercent,
      _Interval.CapacityLastChangeDateTime,
      cast( '' as kap_kopf ) as CapIntervalIsGeneratedInBuffer,
      /* Associations */
      _Header,
      _Shift
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERCAPACITYINTERVAL_2",
"I_WORKCENTERPOOLEDCAPACITY"
],
"ASSOCIATED":
[
"R_WORKCENTERPOOLEDCAPACITYTP",
"R_WORKCENTERPOOLEDCAPSHIFTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More