P_SchedOperations_Version_2

Schedule Production Operations | view: PSCHEDOPERSVERS2 | Extraction: Not supported | Component: Capacity Evaluation
Tables used: AFKOKBEDKBEZAFPOKBKOJSTOJESTAFVCAFVUAFVVADCPADRCPLPOTCA01KAKOAUFKMDLVPLAFT001WCRTXMKALCRHD
Column Name Description
OrderID Order Number
CapacityRequirementItem Capacity Requirement Item
CapacityRqmtItemCapacity Individual Capacity of a Capacity Requirement Item
OrderCategory Order Category Show values
CapacityRequirement ID of the Capacity Requirements Record
Column Name Description
Column Name Description
OrderPlannedTotalQty Operation Total Quantity
Column Name Description
PlantCurrentDate null
PlantCurrentTime null
ScheduledBasicStartDate Scheduled start
ScheduledBasicStartTime Scheduled Start (Time)
ScheduledBasicEndDate Scheduled finish
ScheduledBasicEndTime Scheduled finish time
OperationLatestStartDate Latest Start Date
OperationLatestStartTime Latest Start Time
OperationLatestEndDate Latest End Date
OperationLatestEndTime Latest End Time
OpLtstSchedldProcgStrtDte Latest Scheduled Processing Start Date
OpLtstSchedldProcgStrtTme Latest Scheduled Processing Start Time
OpLtstSchedldTrdwnStrtDte Latest Scheduled Teardown Start Date
OpLtstSchedldTrdwnStrtTme Latest Scheduled Teardown Start Time
RequirementDate Basic finish date
BOOExplosionDate Date for Routing Explosion
BOMExplosionDate Date for Routing Explosion
PlndOrderPlannedStartDate Planned Order Start Date
PlndOrderPlannedEndDate Planned Order End Date
OriginallyScheduledStartDate Latest Start Date
OriginallyScheduledEndDate Latest End Date
Column Name Description
OrderCategory Order Category Show values
WorkCenterTypeCode Object types of the CIM resource Show values
OperationPlanningStatusCode Scheduling Status Show values
OperationIsPhase Indicator: Phase Show values
OrderOperationIsFirstInSqnc Is First Operation Indicator Show values
OrderHasConfiguration Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
Operation Operation/Activity Number VORNR
MRPArea MRP Area BERID
MRPAreaText MRP Area Text BERTX
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
OrderInternalID Order Internal ID AUFPL
ManufacturingOrder Order Number AUFNR
ProductionVersion Production Version VERID
ProductionLine Production Line for Repetitive Manufacturing ARBPL
IndustryType Application of the task list PLNAW
LtstSchedldExecStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LtstSchedldExecEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
RemCapReqOpSegSetupDurnInHours Remaining Capacity Requirements for Setup KAPBED
RemCapReqOpSegProcgDurnInHours null
RemCapReqOpSegTrdwnDurnInHours Remaining Capacity Requirements for Teardown KAPBED
PlannedOrderIsFirm null
StatusCode null
BillOfOperationsGroup Key for Task List Group PLNNR
ScheduledOrderReceiptDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Address time zone
  • Client
  • Address time zone
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == TTZZ.CLIENT
  • P_SCHEDOPERATIONS_VERSION_2.ADDRESSTIMEZONE == TTZZ.TZONE
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_SCHEDOPERATIONS_VERSION_2.BASEUNIT == T006.MSEHI
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == T006.MANDT
Task List Type
  • Client
  • Task List Type
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == TCA01.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Capacity Category
  • Client
  • Capacity Category
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == TC26.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.CAPACITYCATEGORYCODE == TC26.KAPAR
Capacity ID
  • Client
  • Capacity ID
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == KAKO.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.CAPACITYINTERNALID == KAKO.KAPID
Capacity Responsible Planner Group
  • Client
  • Capacity Responsible Planner Group
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == TC27.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.CAPACITYRESPONSIBLEPLANNER == TC27.PLANR
Material Number
  • Client
  • Material Number
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == MARA.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.MATERIAL == MARA.MATNR
MRP Controller Group
  • MRP Controller
  • Client
  • Plant
  • P_SCHEDOPERATIONS_VERSION_2.MRPCONTROLLER == T024D.DISPO
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == T024D.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.PLANT == T024D.WERKS
Setup group key
  • Client
  • Plant
  • Setup group category
  • Setup group key
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == T425.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.PLANT == T425.WERKS
  • P_SCHEDOPERATIONS_VERSION_2.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • P_SCHEDOPERATIONS_VERSION_2.OPERATIONSETUPGROUP == T425.RFSCH
Setup group category
  • Client
  • Plant
  • Setup group category
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == T426.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.PLANT == T426.WERKS
  • P_SCHEDOPERATIONS_VERSION_2.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
Planned Order
  • Client
  • Planned Order
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == PLAF.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.PLANNEDORDER == PLAF.PLNUM
Plant
  • Client
  • Plant
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == T001W.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.PLANT == T001W.WERKS
Work Center Category
  • Client
  • Work Center Category
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == TC30.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.WORKCENTERCATEGORYCODE == TC30.VERWE
Object ID of the resource
  • Client
  • Object ID of the resource
  • ?
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == CRID.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.WORKCENTERINTERNALID == CRID.OBJID
  • P_SCHEDOPERATIONS_VERSION_2.[column in domain "CR_OBJTY"] == CRID.OBJTY
Other Relations | to Master Data Relations ↑ Join Conditions
Person Responsible for the Work Center
  • Person Responsible for the Work Center
  • Client
  • Plant
  • P_SCHEDOPERATIONS_VERSION_2.WORKCENTERRESPONSIBLE == TC24.VERAN
  • P_SCHEDOPERATIONS_VERSION_2.MANDT == TC24.MANDT
  • P_SCHEDOPERATIONS_VERSION_2.PLANT == TC24.WERKS