I_SchedProdnOperations

All scheduled operations | view: ISCHEDOPS | TRAN | Extraction: Not supported | Component: Capacity Evaluation
Tables used: AFKOKBEDKBEZAFPOKBKOJSTOJESTAFVCAFVUAFVVMARAADCPADRCPLPOTCA01PLASKAKOAUFKMDLVPLAFT001WCRTXMKALPPSCH_CHG_OPERPPSCH_USER_SIMT006T006ACRHDMKAL_AEND
Column Name Description
SimulationSessionID Simulation Session ID
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
OperationLatestStartDate Field of type DATS
OperationLatestStartTime Field of type TIMS
OperationLatestEndDate Field of type DATS
OperationLatestEndTime Field of type TIMS
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
ProductionVersIsChgd Indicator for version changed for an operation Show values
OperationIsPhase Indicator: Phase Show values
OrderOperationIsFirstInSqnc Is First Operation Indicator Show values
SchedulingDirection Scheduling direction for Capacity finite schedule production Show values
OrderHasConfiguration Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
Operation Operation/Activity Number VORNR
Product Product Number MATNR
MRPArea MRP Area BERID
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
WorkCenter Work Center ARBPL
PlantCurrentDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MainWorkCenter Work Center ARBPL
WorkCenterInternalID Object ID of the resource CR_OBJID
WorkCenterCategoryCode Work Center Category AP_VERWE
CapacityInternalID Capacity ID KAPID
CapacityCategoryCode Capacity Category KAPART
WorkCenterResponsible Person Responsible for the Work Center AP_VERAN
CapacityResponsiblePlanner Capacity Responsible Planner Group KAPPLANER
ProductionVersion Production Version VERID
ProductionLine Work Center ARBPL
IndustryType Application of the task list PLNAW
MainProductionLine Production Line for Repetitive Manufacturing ARBPL
LtstSchedldExecStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OrderOperationStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
LtstSchedldExecEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OrderOperationEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
UnitOfMeasure_E External Unit of Measurement in Commercial Format (3-Char.) MSEH3
RemainingCapReqExecutionDurn Required Capacity in Float PPH_CFS_SCH_REQUIRED_CAP_FLTP
SchedldOrdStartDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SchedldOrdEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ManufacturingOrder Order Number AUFNR
OrderInternalID Order Internal ID AUFPL
OrderIDForUsrInterface Order Number AUFNR
OrderIsChangedInSimulation null
StatusCode null
OperationSetupGroup Setup group key RUEFASCHLU
OperationSetupGroupCategory Setup group category RUEFAGRP
PlannedOrderIsFirm null
ScheduledOrderReceiptDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
MRPAreaText MRP Area Text BERTX
Master Data Relations Join Conditions
MRP Controller Group
  • Client
  • MRP Controller
  • Plant
  • I_SCHEDPRODNOPERATIONS.MANDT == T024D.MANDT
  • I_SCHEDPRODNOPERATIONS.MRPCONTROLLER == T024D.DISPO
  • I_SCHEDPRODNOPERATIONS.PLANT == T024D.WERKS
Planned Order
  • Client
  • Planned Order
  • I_SCHEDPRODNOPERATIONS.MANDT == PLAF.MANDT
  • I_SCHEDPRODNOPERATIONS.PLANNEDORDER == PLAF.PLNUM
Plant
  • Client
  • Plant
  • I_SCHEDPRODNOPERATIONS.MANDT == T001W.MANDT
  • I_SCHEDPRODNOPERATIONS.PLANT == T001W.WERKS
Material Group
  • Client
  • Product Group
  • I_SCHEDPRODNOPERATIONS.MANDT == T023.MANDT
  • I_SCHEDPRODNOPERATIONS.PRODUCTGROUP == T023.MATKL