P_WrkCtrCapOpWrkDays

Capacity Load Distribution with working days | view: PWCCAPOPWRKDAYS | Extraction: Not supported | Component: Capacity Evaluation
Tables used: SCAL_TT_DATEAFKOKBKOKBEDKBEZAFPOJSTOJESTAFVCAFVUAFVVKAZYKAPAKAKOTC26TC26TAUFKPLAFT001WCRTXTC37ATC37PCRHDCRCA
Column Name Description
WorkCenterInternalID FK Object ID of the resource
WorkCenterTypeCode Object types of the CIM resource Show values
CapacityCategoryAllocation Capacity Category Allocation
CapacityInternalID FK Capacity ID
WeekDay null
ValidityEndDate null
CapacityActiveVersion null
AvailableCapacityShift null
CapacityRequirement FK ID of the Capacity Requirements Record
Operation Operation/Activity Number
CalendarDate null
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OrderPlannedTotalQty Total Order Quantity
Column Name Description
ValidityEndDate null
CalendarDate null
FactoryCalendarDate Calendar Date
OperationLatestStartDate Latest Start Date
OperationLatestStartTime Latest Start Time
OperationLatestEndDate Latest End Date
OperationLatestEndTime Latest End Time
OpLtstSchedldProcgStrtDte Latest Scheduled Start: Processing (Date)
OpLtstSchedldProcgStrtTme Latest Scheduled Start: Processing (Time)
OpLtstSchedldTrdwnStrtDte Latest Scheduled Start: Teardown (Date)
OpLtstSchedldTrdwnStrtTme Latest Scheduled Start: Teardown (Time)
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
CapacityRequirementOrigin Capacity Requirement Origin Show values
OrderCategory Order Category Show values
Column Name Description Domain name
ShiftName null
OrderID null
WorkCenter Work Center ARBPL
FactoryCalendar Factory Calendar ID WFCID
CalendarWeek Calendar Week NUM2
CalendarMonth Calendar Month NUM2
CalendarYear Calendar Year NUM4
CalCapacityInParallel null
CeiledCalCapInParellel null
TotOperatingDurationInSeconds null
CapacityStartTime null
CapacityEndTime null
isStartDay null
isEndDay null
NightSplitDate null
AvailableCapacityIntervalDurn null
WorkDayRule null
OrderInternalID Order Internal ID AUFPL
OperationPlanningStatusCode null
OpLtstSchedldExecStrtTme null
OpLtstSchedldExecEndTme null
RemainingCapReqOpSegSetupDurn null
RemainingCapReqOpSegProcgDurn null
RemainingCapReqOpSegTrdwnDurn null
RequirementHours null
TotRequirementInSeconds null
OrderStatusCode null
OrderFirmingStatusCode Single-Character Flag CHAR1
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_WRKCTRCAPOPWRKDAYS.BASEUNIT == T006.MSEHI
  • P_WRKCTRCAPOPWRKDAYS.MANDT == T006.MANDT
Capacity ID
  • Capacity ID
  • Client
  • P_WRKCTRCAPOPWRKDAYS.CAPACITYINTERNALID == KAKO.KAPID
  • P_WRKCTRCAPOPWRKDAYS.MANDT == KAKO.MANDT
Material Number for Order
  • Material Number for Order
  • Client
  • P_WRKCTRCAPOPWRKDAYS.MATERIAL == MARA.MATNR
  • P_WRKCTRCAPOPWRKDAYS.MANDT == MARA.MANDT
MRP Controller Group
  • MRP controller for the order
  • Plant
  • Client
  • P_WRKCTRCAPOPWRKDAYS.MRPCONTROLLER == T024D.DISPO
  • P_WRKCTRCAPOPWRKDAYS.PLANT == T024D.WERKS
  • P_WRKCTRCAPOPWRKDAYS.MANDT == T024D.MANDT
Order Type
  • Order Type
  • Client
  • P_WRKCTRCAPOPWRKDAYS.ORDERTYPE == T003O.AUART
  • P_WRKCTRCAPOPWRKDAYS.MANDT == T003O.CLIENT
Plant
  • Plant
  • Client
  • P_WRKCTRCAPOPWRKDAYS.PLANT == T001W.WERKS
  • P_WRKCTRCAPOPWRKDAYS.MANDT == T001W.MANDT
Production Version
  • Material Number for Order
  • Production Version
  • Client
  • ?
  • P_WRKCTRCAPOPWRKDAYS.MATERIAL == MKAL.MATNR
  • P_WRKCTRCAPOPWRKDAYS.PRODUCTIONVERSION == MKAL.VERID
  • P_WRKCTRCAPOPWRKDAYS.MANDT == MKAL.MANDT
  • P_WRKCTRCAPOPWRKDAYS.[column in domain "WERKS_D"] == MKAL.WERKS
Work Center Category
  • Work Center Category
  • Client
  • P_WRKCTRCAPOPWRKDAYS.WORKCENTERCATEGORYCODE == TC30.VERWE
  • P_WRKCTRCAPOPWRKDAYS.MANDT == TC30.MANDT
Object ID of the resource
  • Object types of the CIM resource
  • Client
  • Object ID of the resource
  • P_WRKCTRCAPOPWRKDAYS.WORKCENTERTYPECODE == CRID.OBJTY
  • P_WRKCTRCAPOPWRKDAYS.MANDT == CRID.MANDT
  • P_WRKCTRCAPOPWRKDAYS.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Person Responsible for the Work Center
  • Plant
  • Client
  • P_WRKCTRCAPOPWRKDAYS.WORKCENTERRESPONSIBLE == TC24.VERAN
  • P_WRKCTRCAPOPWRKDAYS.PLANT == TC24.WERKS
  • P_WRKCTRCAPOPWRKDAYS.MANDT == TC24.MANDT