P_MfgOrderOperationDelayBasic

Manufacturing Order Operation Delay Basic Data | view: PMFGOROPDELYBSC | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFKOAFVCAFVUAFVVAUFK
Column Name Description
OrderInternalID Routing number of operations in the order
OrderOperationInternalID General counter for order
Column Name Description
Column Name Description
StartDateOffsetDuration Offset to sub-operation start
EndDateOffsetDuration Offset to sub-operation finish
OpPlannedYieldQuantity null
📏 Unit of measure for activity (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
Column Name Description
OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date)
OpErlstSchedldExecStrtTme Earliest scheduled start: Execution (time)
OpErlstSchedldProcgStrtDte Earliest scheduled start: Processing (date)
OpErlstSchedldProcgStrtTme Earliest Scheduled Start: Processing (Time)
OpErlstSchedldTrdwnStrtDte Earliest scheduled start: Teardown (date)
OpErlstSchedldTrdwnStrtTme Earliest Scheduled Start: Teardown (Time)
OpErlstSchedldExecEndDte Earliest scheduled finish: Execution (date)
OpErlstSchedldExecEndTme Earliest scheduled finish: Execution (time)
OpLtstSchedldExecStrtDte Latest scheduled start: Execution (date)
OpLtstSchedldExecStrtTme Latest scheduled start: Execution (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)
OpLtstSchedldExecEndDte Latest scheduled finish: Execution (date)
OpLtstSchedldExecEndTme Latest scheduled finish: Execution (time)
OperationConfirmedStartDate Actual Operation Start Date
OperationConfirmedEndDate Actual Operation End Date
OpActualExecutionStartDate Actual Execution Start Date
OpActualExecutionStartTime Actual Execution Start Time
OpActualSetupEndDate Actual Setup End Date
OpActualSetupEndTime Actual Setup End Time
OpActualProcessingStartDate Actual Processing Start Date
OpActualProcessingStartTime Actual Processing Start Time
OpActualProcessingEndDate Actual Processing End Date
OpActualProcessingEndTime Actual Processing End Time
OpActualTeardownStartDate Actual Teardown Start Date
OpActualTeardownStartTme Actual Teardown Start Time
OpActualExecutionEndDate Actual Execution End Date
OpActualExecutionEndTime Actual Execution End Time
Column Name Description
ManufacturingOrderCategory Order Category Show values
ProdnProcgIsFlexible Flexible Processing Show values
OperationIsToBeDeleted Deletion Flag Show values
BillOfMaterialCategory BOM category Show values
ControllingObjectClass Controlling Object Class Show values
Column Name Description Domain name
ManufacturingOrder Order Number AUFNR
Sequence Sequence PLNFOLGE
Operation Operation/Activity Number VORNR
ProductConfiguration Configuration (internal object number) CUOBJ
InspectionLot Inspection Lot Number QPLOS
Reservation Number of reservation/dependent requirements RSNUM
ManufacturingOrderImportance Order Importance Code CHAR1
OperationText Operation Short Text TEXT40
NumberOfCapacities Number of Capacities Required INT1
NumberOfConfirmationSlips Number of Confirmation Slips NUM03
WorkCenterTypeCode null
OperationConfirmation Completion confirmation number for the operation CO_RUECK
NumberOfOperationConfirmations Confirmation counter CIM_COUNT
CapacityRequirement ID of the Capacity Requirements Record BEDID
CapacityRequirementItem Internal counter CIM_COUNT
BillOfOperationsGroup Key for Task List Group PLNNR
BillOfOperationsVariant Group Counter ALTNR
BillOfOperationsSequence Sequence PLNFOLGE
BOOOperationInternalID Number of the Task List Node KNTNR
BillOfOperationsVersion Routing Version PLNVERSN
BillOfMaterialInternalID Bill of Material STNUM
BillOfMaterialItemNodeNumber BOM item node number KNTNR
BOMItemNodeCount Internal counter CIM_COUNT
EmployeeWageType Wage type LOART
NumberOfTimeTickets Number of Time Tickets LOHNANZ
Personnel Personnel number PERNR
NumberOfEmployees Number of employees ANZMA
PlannedCurrentStrtDateDvtnDurn null
PlannedCurrentEndDateDvtnDurn null
PlannedActualStartDateDvtnDurn null
PlannedActualEndDateDvtnDurn null
OperationScrapPercent Scrap factor AUSCHUFAK
SetupOpActyNtwkInstance Operation Activity Network: Instance ID
ProduceOpActyNtwkInstance Operation Activity Network: Instance ID
TeardownOpActyNtwkInstance Operation Activity Network: Instance ID
Master Data Relations Join Conditions
Task List Type
  • Client
  • Task List Type
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == TCA01.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Business Area
  • Client
  • Business Area
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == TGSB.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.BUSINESSAREA == TGSB.GSBER
Change Number
  • Client
  • Change Number
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == AENR.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.CHANGENUMBER == AENR.AENNR
Company Code
  • Company Code
  • Client
  • P_MFGORDEROPERATIONDELAYBASIC.COMPANYCODE == T001.BUKRS
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_MFGORDEROPERATIONDELAYBASIC.CONTROLLINGAREA == TKA01.KOKRS
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == TKA01.MANDT
Suitability
  • Suitability
  • Client
  • Plant
  • P_MFGORDEROPERATIONDELAYBASIC.EMPLOYEESUITABILITY == T423.QUALF
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T423.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.PLANT == T423.WERKS
Wage Group
  • Client
  • Plant
  • Wage Group
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T421.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.PLANT == T421.WERKS
  • P_MFGORDEROPERATIONDELAYBASIC.EMPLOYEEWAGEGROUP == T421.LOGRP
Unit for Offset to Finish
  • Client
  • Unit for Offset to Finish
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T006.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
Reference Date for Finish of Sub-Operation P_MFGORDEROPERATIONDELAYBASIC.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF
Factory Calendar P_MFGORDEROPERATIONDELAYBASIC.FACTORYCALENDAR == TFACD.IDENT
Functional Area
  • Functional Area
  • Client
  • P_MFGORDEROPERATIONDELAYBASIC.FUNCTIONALAREA == TFKB.FKBER
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == TFKB.MANDT
Language Key P_MFGORDEROPERATIONDELAYBASIC.LANGUAGE == T002.SPRAS
Order Type
  • Order Type
  • Client
  • P_MFGORDEROPERATIONDELAYBASIC.MANUFACTURINGORDERTYPE == T003O.AUART
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T003O.CLIENT
MRP Controller Group
  • Client
  • MRP controller for the order
  • Plant
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T024D.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.MRPCONTROLLER == T024D.DISPO
  • P_MFGORDEROPERATIONDELAYBASIC.PLANT == T024D.WERKS
Control key
  • Client
  • ?
  • Control key
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T430.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.[column in domain "PLNAW"] == T430.PLNAW
  • P_MFGORDEROPERATIONDELAYBASIC.OPERATIONCONTROLPROFILE == T430.STEUS
Priority
  • Client
  • Priority
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == TCN07.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.OPERATIONIMPORTANCE == TCN07.NPRIO
Unit of measure for activity
  • Client
  • Unit of measure for activity
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T006.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.OPERATIONUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T001W.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.PLANT == T001W.WERKS
Production Supervisor
  • Client
  • Plant
  • Production Supervisor
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T024F.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.PLANT == T024F.WERKS
  • P_MFGORDEROPERATIONDELAYBASIC.PRODUCTIONSUPERVISOR == T024F.FEVOR
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • P_MFGORDEROPERATIONDELAYBASIC.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_MFGORDEROPERATIONDELAYBASIC.[column in domain "DATBI"] == CEPC.DATBI
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == CEPC.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.PROFITCENTER == CEPC.PRCTR
Standard text key
  • Client
  • Standard text key
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T435.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.STANDARDTEXTINTERNALID == T435.VLSCH
Unit for Offset to Start
  • Client
  • Unit for Offset to Start
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T006.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
Reference Date for Start of Sub-Operation P_MFGORDEROPERATIONDELAYBASIC.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == CRID.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MFGORDEROPERATIONDELAYBASIC.WORKCENTERINTERNALID == CRID.OBJID
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Responsible Planner Group or Department
  • Client
  • Plant
  • P_MFGORDEROPERATIONDELAYBASIC.RESPONSIBLEPLANNERGROUP == T024A.FEVOR
  • P_MFGORDEROPERATIONDELAYBASIC.MANDT == T024A.MANDT
  • P_MFGORDEROPERATIONDELAYBASIC.PLANT == T024A.WERKS