R_WorkCenterCapacityTP

DDL: R_WORKCENTERCAPACITYTP SQL: RWRKCTRCAPTP Type: view_entity TRANSACTIONAL

Work Center Capacity

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

1 data source(s) 41 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapacity_2 I_WorkCenterCapacity_2 from

Associations (2)

CardinalityTargetAliasCondition
[1..*] R_WorkCenterCapacityIntervalTP _Interval
[1..*] R_WorkCenterCapacityTextTP _CapDescription

Annotations (7)

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

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID
KEY WorkCenterTypeCode WorkCenterTypeCode
KEY CapacityCategoryAllocation CapacityCategoryAllocation
KEY CapacityInternalID CapacityInternalID
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
WorkCenter WorkCenter
WorkCenterCategoryCode WorkCenterCategoryCode
SetupCapRequirementFormula SetupCapRequirementFormula
ProcgCapRequirementFormula ProcgCapRequirementFormula
TeardownCapRequirementFormula TeardownCapRequirementFormula
OtherCapRequirementFormula OtherCapRequirementFormula
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
WorkCenterLastChangeDateTime WorkCenterLastChangeDateTime
Capacity Capacity
CapacityCategoryCode CapacityCategoryCode
CapacityActiveVersion CapacityActiveVersion
CapacityIsFinite CapacityIsFinite
CapacityIsPooled CapacityIsPooled
CapacityHasIndivCapacities CapacityHasIndivCapacities
CapacityIsExcldFrmLongTermPlng CapacityIsExcldFrmLongTermPlng
CapacityNumberOfCapacities CapacityNumberOfCapacities
CapacityResponsiblePlanner CapacityResponsiblePlanner
CapacityPlanUtilizationPercent CapacityPlanUtilizationPercent
CapacityBreakDuration CapacityBreakDuration
Plant Plant
FactoryCalendar FactoryCalendar
AuthorizationGroup AuthorizationGroup
ShiftGroup ShiftGroup
CapacityStartTimeID CapacityStartTimeID
CapacityEndTimeID CapacityEndTimeID
CapIsUsedInMultiOperations CapIsUsedInMultiOperations
ReferencedCapacityInternalID ReferencedCapacityInternalID
CapOverloadThresholdInPercent CapOverloadThresholdInPercent
CapacityQuantityUnit CapacityQuantityUnit
CapacityBaseQtyUnit CapacityBaseQtyUnit
CapacityLastChangeDateTime CapacityLastChangeDateTime
_Header _Header
_Interval _Interval
_CapDescription _CapDescription 
//@AbapCatalog.sqlViewName: 'RWRKCTRCAPTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Work Center Capacity'
//@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_WorkCenterCapacityTP
  as select from I_WorkCenterCapacity_2
  -- to Capacity Interval
  composition [1..*] of R_WorkCenterCapacityIntervalTP as _Interval

  --to Capacity Text
  composition [1..*] of R_WorkCenterCapacityTextTP     as _CapDescription

  association to parent R_WorkCenterTP                 as _Header on  $projection.WorkCenterTypeCode   = _Header.WorkCenterTypeCode
                                                                  and $projection.WorkCenterInternalID = _Header.WorkCenterInternalID

{
  key WorkCenterInternalID,
  key WorkCenterTypeCode,
  key CapacityCategoryAllocation,
  key CapacityInternalID,

      // Capacity Alloc Attributes

      LastChangeDate,
      LastChangedByUser,
      WorkCenter,
      WorkCenterCategoryCode,
      SetupCapRequirementFormula,
      ProcgCapRequirementFormula,
      TeardownCapRequirementFormula,
      OtherCapRequirementFormula,
      ValidityStartDate,
      ValidityEndDate,
      WorkCenterLastChangeDateTime,

      // Capacity Attributes

      Capacity,
      CapacityCategoryCode,
      CapacityActiveVersion,
      CapacityIsFinite,
      CapacityIsPooled,
      CapacityHasIndivCapacities,
      CapacityIsExcldFrmLongTermPlng,
      CapacityNumberOfCapacities,
      CapacityResponsiblePlanner,
      CapacityPlanUtilizationPercent,
      CapacityBreakDuration,

      // Assignments

      Plant,
      FactoryCalendar,
      AuthorizationGroup,
      ShiftGroup,

      // Times

      @Semantics.durationInSeconds:true
      CapacityStartTimeID,
      @Semantics.durationInSeconds:true
      CapacityEndTimeID,

      CapIsUsedInMultiOperations,
      ReferencedCapacityInternalID,
      CapOverloadThresholdInPercent,

      // Unit of Measures

      //      @Semantics.unitOfMeasure: true

      CapacityQuantityUnit,
      //      @Semantics.unitOfMeasure: true

      CapacityBaseQtyUnit,

      CapacityLastChangeDateTime,

      /*Associations*/
      @Consumption.hidden: true
      _Header,
      _Interval,
      _CapDescription
}
where
      CapacityIsPooled is initial
  and Capacity         is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTERCAPACITY_2"
],
"ASSOCIATED":
[
"R_WORKCENTERCAPACITYINTERVALTP",
"R_WORKCENTERCAPACITYTEXTTP",
"R_WORKCENTERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More