R_ProductionOrderOperationTP

Prodn Order Operation (Transacl Procg) | view: RPRODNORDOPTP | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFKO, AFVC, AFVC, AFVU, AFVV, AUFK, CRHD
Column Name Description
MfgOrderInternalID Order Internal ID
OrderOperationInternalID Internal Identifier of an Operation or Activity
Column Name Description
💲 Currency Key (OpExternalProcessingCurrency):
OpExternalProcessingPrice Price
Column Name Description
📏 Unit for a Break Time (BreakDurationUnit):
PlannedBreakDuration Break Time
📏 Unit for the Minimum Overlap Time (OverlapMinimumDurationUnit):
OverlapMinimumDuration Minimum Overlap Time
📏 Unit for the Required Wait Time (MinimumWaitDurationUnit):
MaximumWaitDuration Maximum Wait Time
📏 Unit for the standard move time (StandardMoveDurationUnit):
MinimumWaitDuration Minimum Wait Time
📏 Unit for the Standard Queue Time (StandardQueueDurationUnit):
StandardMoveDuration Standard Move Time
📏 Unit for the Minimum Queue Time (MinimumQueueDurationUnit):
StandardQueueDuration Standard Queue Time
📏 Unit for the minimum move time (MinimumMoveDurationUnit):
MinimumQueueDuration Minimum Queue Time
MinimumMoveDuration Minimum Move Time
📏 Unit for Offset to Start (StartDateOffsetDurationUnit):
StartDateOffsetDuration Offset to sub-operation start
📏 Unit for Offset to Finish (EndDateOffsetDurationUnit):
EndDateOffsetDuration Offset to sub-operation finish
📏 Operation Unit of Measure (OperationUnit):
OperationReferenceQuantity Base Quantity
OpPlannedTotalQuantity Operation Total Quantity
OpPlannedScrapQuantity Operation Planned Scrap Quantity
OpTotalConfirmedYieldQty Total Confirmed Yield
OpTotalConfirmedScrapQty Total Scrap Quantity Confirmed
OperationConfirmedReworkQty Total Confirmed Rework Quantity
📏 Standard Work Quantity Unit 1 (WorkCenterStandardWorkQtyUnit1):
WorkCenterStandardWorkQty1 Standard Work Quantity 1
📏 Standard Work Quantity Unit 2 (WorkCenterStandardWorkQtyUnit2):
WorkCenterStandardWorkQty2 Standard Work Quantity 2
📏 Standard Work Quantity Unit 3 (WorkCenterStandardWorkQtyUnit3):
WorkCenterStandardWorkQty3 Standard Work Quantity 3
📏 Standard Work Quantity Unit 4 (WorkCenterStandardWorkQtyUnit4):
WorkCenterStandardWorkQty4 Standard Work Quantity 4
📏 Standard Work Quantity Unit 5 (WorkCenterStandardWorkQtyUnit5):
WorkCenterStandardWorkQty5 Standard Work Quantity 5
📏 Standard Work Quantity Unit 6 (WorkCenterStandardWorkQtyUnit6):
WorkCenterStandardWorkQty6 Standard Work Quantity 6
📏 Unit of Measure for Business Process Quantity (BusinessProcessEntryUnit):
BusinessProcessConfirmedQty Confirmed Quantity/Activity for Business Process
Column Name Description
OpErlstSchedldExecStrtDte Earliest Scheduled Execution Start Date
OpErlstSchedldExecStrtTme Earliest Scheduled Execution Start Time
OpErlstSchedldProcgStrtDte Earliest Scheduled Processing Start Date
OpErlstSchedldProcgStrtTme Earliest Scheduled Processing Start Time
OpErlstSchedldTrdwnStrtDte Earliest Scheduled Teardown Start Date
OpErlstSchedldTrdwnStrtTme Earliest Scheduled Teardown Start Time
OpErlstSchedldExecEndDte Earliest Scheduled Execution End Date
OpErlstSchedldExecEndTme Earliest Scheduled Execution End Time
OpLtstSchedldExecStrtDte Latest Scheduled Execution Start Date
OpLtstSchedldExecStrtTme Latest Scheduled Execution Start 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
OpLtstSchedldExecEndDte Latest Scheduled Execution End Date
OpLtstSchedldExecEndTme Latest Scheduled Execution End Time
SchedldFcstdLatestStartTime Latest Scheduled Forecast Start Time
OperationConfirmedStartDate Operation Confirmed Start Date
OperationConfirmedEndDate Operation Confirmed End Date
OpActualExecutionStartDate Confirmed Start Date of Execution
OpActualExecutionStartTime Confirmed Start Time of Execution
OpActualSetupEndDate Confirmed End Date of Setup
OpActualSetupEndTime Confirmed End Time of Setup
OpActualProcessingStartDate Confirmed Start Date of Processing
OpActualProcessingStartTime Confirmed Start Time of Processing
OpActualProcessingEndDate Confirmed End Date of Processing
OpActualProcessingEndTime Confirmed End Time of Processing
OpActualTeardownStartDate Confirmed Start Date of Teardown
OpActualTeardownStartTme Confirmed Start Time of Teardown
OpActualExecutionEndDate Confirmed End Date of Execution
OpActualExecutionEndTime Confirmed End Time of Execution
ActualForecastEndDate Actual Forecast End Date
ActualForecastEndTime Actual Forecast End Time
EarliestScheduledWaitStartDate Earliest Scheduled Wait Start Date
EarliestScheduledWaitStartTime Earliest Scheduled Wait Start Time
EarliestScheduledWaitEndDate Earliest Scheduled Wait End Date
EarliestScheduledWaitEndTime Earliest Scheduled Wait End Time
LatestScheduledWaitStartDate Latest Scheduled Wait Start Date
LatestScheduledWaitStartTime Latest Scheduled Wait Start Time
LatestScheduledWaitEndDate Latest Scheduled Wait End Date
LatestScheduledWaitEndTime Latest Scheduled Wait End Time
Column Name Description
OperationSplitIsRequired Splitting Required Show values
OpSchedldReductionLevel Reduction Level Which Reduces Operation Lead Time Show values
NoFurtherBusinessProcQtyIsExpd No Remaining Quantity Expected for Business Process Show values
Column Name Description Domain name
ManufacturingOrder Manufacturing Order ID AUFNR
ManufacturingOrderSequence Manufacturing Order Sequence PLNFOLGE
ManufacturingOrderOperation Operation or Phase Number VDM_VORNR
ManufacturingOrderSubOperation Sub-Operation or Secondary Resource Number VDM_VORNR
MfgOrderOperationText Manufacturing Order Operation Text TEXT40
NumberOfConfirmationSlips Number of Confirmation Slips NUM03
WorkCenter Work Center ARBPL
OperationConfirmation Completion confirmation number for the operation CO_RUECK
ExtProcgOperationHasSubcontrg Indicator: External Processing Operation with Subcontracting CHAR1
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
NumberOfOperationPriceUnits Material Price Unit Quantity PACK3
EmployeeWageType Employee Wage Type LOART
NumberOfTimeTickets Number of Time Tickets LOHNANZ
NumberOfEmployees Number of Employees ANZMA
MaximumNumberOfSplits Maximum Number of Splits SPLITTANZ
ScheduledMoveDuration Move Time used for Scheduling CX_ZEIT
ScheduledQueueDuration Queue Time Used for Scheduling CX_ZEIT
ScheduledWaitDuration Wait Time Used for Scheduling CX_ZEIT
OpPlannedSetupDurn Setup Time CX_ZEIT
OpPlannedProcessingDurn Processing Time CX_ZEIT
OpPlannedTeardownDurn Teardown CX_ZEIT
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
OperationScrapPercent Scrap factor AUSCHUFAK
BusinessProcess Business Process CO_PRZNR
Master Data Relations Join Conditions
Unit for a Break Time
  • Unit for a Break Time
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.BREAKDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Change Number
  • Change Number
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.CHANGENUMBER == AENR.AENNR
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == AENR.MANDT
Cost Center Activity Type 1
  • ?
  • Cost Center Activity Type 1
  • ?
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "KOKRS"] == CSLA.KOKRS
  • R_PRODUCTIONORDEROPERATIONTP.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "DATBI"] == CSLA.DATBI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == CSLA.MANDT
Cost Center Activity Type 2
  • ?
  • Cost Center Activity Type 2
  • ?
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "KOKRS"] == CSLA.KOKRS
  • R_PRODUCTIONORDEROPERATIONTP.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "DATBI"] == CSLA.DATBI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == CSLA.MANDT
Cost Center Activity Type 3
  • ?
  • Cost Center Activity Type 3
  • ?
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "KOKRS"] == CSLA.KOKRS
  • R_PRODUCTIONORDEROPERATIONTP.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "DATBI"] == CSLA.DATBI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == CSLA.MANDT
Cost Center Activity Type 4
  • ?
  • Cost Center Activity Type 4
  • ?
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "KOKRS"] == CSLA.KOKRS
  • R_PRODUCTIONORDEROPERATIONTP.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "DATBI"] == CSLA.DATBI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == CSLA.MANDT
Cost Center Activity Type 5
  • ?
  • Cost Center Activity Type 5
  • ?
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "KOKRS"] == CSLA.KOKRS
  • R_PRODUCTIONORDEROPERATIONTP.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "DATBI"] == CSLA.DATBI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == CSLA.MANDT
Cost Center Activity Type 6
  • ?
  • Cost Center Activity Type 6
  • ?
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "KOKRS"] == CSLA.KOKRS
  • R_PRODUCTIONORDEROPERATIONTP.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "DATBI"] == CSLA.DATBI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Cost Element
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "KTOPL"] == CSKA.KTOPL
  • R_PRODUCTIONORDEROPERATIONTP.COSTELEMENT == CSKA.KSTAR
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == CSKA.MANDT
Employee Suitability
  • Employee Suitability
  • Plant
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.EMPLOYEESUITABILITY == T423.QUALF
  • R_PRODUCTIONORDEROPERATIONTP.PLANT == T423.WERKS
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T423.MANDT
Employee Wage Group
  • Employee Wage Group
  • Plant
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.EMPLOYEEWAGEGROUP == T421.LOGRP
  • R_PRODUCTIONORDEROPERATIONTP.PLANT == T421.WERKS
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T421.MANDT
Unit for Offset to Finish
  • Unit for Offset to Finish
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Reference Date for Finish of Sub-Operation R_PRODUCTIONORDEROPERATIONTP.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF
Operation Lead Time Reduction Strategy
  • Operation Lead Time Reduction Strategy
  • Plant
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.LEADTIMEREDUCTIONSTRATEGY == T499Q.RSTRA
  • R_PRODUCTIONORDEROPERATIONTP.PLANT == T499Q.WERKS
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T499Q.MANDT
Unit for the Maximum Wait Time
  • Unit for the Maximum Wait Time
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.MAXIMUMWAITDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Unit for the minimum move time
  • Unit for the minimum move time
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.MINIMUMMOVEDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Unit for the Minimum Queue Time
  • Unit for the Minimum Queue Time
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.MINIMUMQUEUEDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Unit for the Required Wait Time
  • Unit for the Required Wait Time
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.MINIMUMWAITDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Operation Control Profile
  • ?
  • Operation Control Profile
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "PLNAW"] == T430.PLNAW
  • R_PRODUCTIONORDEROPERATIONTP.OPERATIONCONTROLPROFILE == T430.STEUS
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T430.MANDT
Operation Setup Group
  • Operation Setup Group Category
  • Plant
  • Client
  • Operation Setup Group
  • R_PRODUCTIONORDEROPERATIONTP.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • R_PRODUCTIONORDEROPERATIONTP.PLANT == T425.WERKS
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T425.MANDT
  • R_PRODUCTIONORDEROPERATIONTP.OPERATIONSETUPGROUP == T425.RFSCH
Operation Setup Group Category
  • Operation Setup Group Category
  • Plant
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
  • R_PRODUCTIONORDEROPERATIONTP.PLANT == T426.WERKS
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T426.MANDT
Operation Setup Type
  • Plant
  • Client
  • Operation Setup Type
  • R_PRODUCTIONORDEROPERATIONTP.PLANT == T428.WERKS
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T428.MANDT
  • R_PRODUCTIONORDEROPERATIONTP.OPERATIONSETUPTYPE == T428.RASCH
Operation Standard Text Internal ID
  • Operation Standard Text Internal ID
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.OPERATIONSTANDARDTEXTCODE == T435.VLSCH
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T435.MANDT
Operation Unit of Measure
  • Client
  • Operation Unit of Measure
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
  • R_PRODUCTIONORDEROPERATIONTP.OPERATIONUNIT == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == TCURC.MANDT
  • R_PRODUCTIONORDEROPERATIONTP.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS
Unit for the Minimum Overlap Time
  • Client
  • Unit for the Minimum Overlap Time
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
  • R_PRODUCTIONORDEROPERATIONTP.OVERLAPMINIMUMDURATIONUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.PLANT == T001W.WERKS
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T001W.MANDT
Purchasing Group for External Processing Activity
  • Purchasing Group for External Processing Activity
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.PURCHASINGGROUP == T024.EKGRP
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T024.MANDT
Purchasing Info Record
  • Purchasing Info Record
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.PURCHASINGINFORECORD == EINA.INFNR
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == EINA.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.PURCHASINGORGANIZATION == T024E.EKORG
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T024E.MANDT
Unit for the standard move time
  • Unit for the standard move time
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.STANDARDMOVEDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Unit for the Standard Queue Time
  • Unit for the Standard Queue Time
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.STANDARDQUEUEDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Unit for Offset to Start
  • Unit for Offset to Start
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Reference Date for Start of Sub-Operation R_PRODUCTIONORDEROPERATIONTP.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.SUPPLIER == LFA1.LIFNR
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == LFA1.MANDT
Work Center Internal ID
  • Work Center Internal ID
  • ?
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.WORKCENTERINTERNALID == CRID.OBJID
  • R_PRODUCTIONORDEROPERATIONTP.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == CRID.MANDT
Standard Work Quantity Unit 1
  • Standard Work Quantity Unit 1
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.WORKCENTERSTANDARDWORKQTYUNIT1 == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Standard Work Quantity Unit 2
  • Standard Work Quantity Unit 2
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.WORKCENTERSTANDARDWORKQTYUNIT2 == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Standard Work Quantity Unit 3
  • Client
  • Standard Work Quantity Unit 3
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
  • R_PRODUCTIONORDEROPERATIONTP.WORKCENTERSTANDARDWORKQTYUNIT3 == T006.MSEHI
Standard Work Quantity Unit 4
  • Standard Work Quantity Unit 4
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.WORKCENTERSTANDARDWORKQTYUNIT4 == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Standard Work Quantity Unit 5
  • Standard Work Quantity Unit 5
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.WORKCENTERSTANDARDWORKQTYUNIT5 == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT
Standard Work Quantity Unit 6
  • Standard Work Quantity Unit 6
  • Client
  • R_PRODUCTIONORDEROPERATIONTP.WORKCENTERSTANDARDWORKQTYUNIT6 == T006.MSEHI
  • R_PRODUCTIONORDEROPERATIONTP.MANDT == T006.MANDT