I_ORDEROPERATIONDATETIME
Order Operation Date and Time as Timestamp
I_ORDEROPERATIONDATETIME is a CDS View in S/4HANA. Order Operation Date and Time as Timestamp. It contains 106 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_TeamOpenOpActyAssignment | view | inner | CONSUMPTION | Open operation activities assigned to a team |
| P_MfgOrderOperationDelayBasic | view | from | COMPOSITE | |
| P_OpActyInstanceWithUserAssgmt | view | inner | TRANSACTIONAL | |
| P_OperationActivityWorklist | view | inner | COMPOSITE | |
| P_ProcgExecOperationActivity | view | inner | COMPOSITE |
Fields (106)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OrderInternalID | OrderInternalID | 1 |
| KEY | OrderOperationInternalID | OrderOperationInternalID | 1 |
| _WorkCenter | _WorkCenter | 2 | |
| BillOfMaterialCategory | BillOfMaterialCategory | 1 | |
| BillOfMaterialInternalID | BillOfMaterialInternalID | 1 | |
| BillOfMaterialItemNodeNumber | BillOfMaterialItemNodeNumber | 1 | |
| BillOfOperationsGroup | BillOfOperationsGroup | 1 | |
| BillOfOperationsSequence | BillOfOperationsSequence | 1 | |
| BillOfOperationsType | BillOfOperationsType | 1 | |
| BillOfOperationsVariant | BillOfOperationsVariant | 1 | |
| BillOfOperationsVersion | BillOfOperationsVersion | 1 | |
| BOMItemNodeCount | BOMItemNodeCount | 1 | |
| BOOOperationInternalID | BOOOperationInternalID | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| CapacityRequirementItem | CapacityRequirementItem | 1 | |
| ChangeNumber | ChangeNumber | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ControllingObjectClass | ControllingObjectClass | 1 | |
| EmployeeSuitability | EmployeeSuitability | 1 | |
| EmployeeWageGroup | EmployeeWageGroup | 1 | |
| EmployeeWageType | EmployeeWageType | 1 | |
| EndDateOffsetDuration | EndDateOffsetDuration | 1 | |
| EndDateOffsetDurationUnit | EndDateOffsetDurationUnit | 1 | |
| EndDateOffsetReferenceCode | EndDateOffsetReferenceCode | 1 | |
| FactoryCalendar | FactoryCalendar | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Language | Language | 1 | |
| NumberOfConfirmationSlips | NumberOfConfirmationSlips | 1 | |
| NumberOfEmployees | NumberOfEmployees | 1 | |
| NumberOfOperationConfirmations | NumberOfOperationConfirmations | 1 | |
| NumberOfTimeTickets | NumberOfTimeTickets | 1 | |
| ObjectInternalID | ObjectInternalID | 1 | |
| OpActualExecutionEndDate | OpActualExecutionEndDate | 1 | |
| OpActualExecutionEndDateTime | OpActualExecutionEndDateTime | 1 | |
| OpActualExecutionEndTime | OpActualExecutionEndTime | 1 | |
| OpActualExecutionStartDate | OpActualExecutionStartDate | 2 | |
| OpActualExecutionStartDateTime | OpActualExecutionStartDateTime | 1 | |
| OpActualExecutionStartTime | OpActualExecutionStartTime | 2 | |
| OpActualProcessingEndDate | OpActualProcessingEndDate | 1 | |
| OpActualProcessingEndDateTime | OpActualProcessingEndDateTime | 1 | |
| OpActualProcessingEndTime | OpActualProcessingEndTime | 1 | |
| OpActualProcessingStartDate | OpActualProcessingStartDate | 1 | |
| OpActualProcessingStartDteTme | OpActualProcessingStartDteTme | 1 | |
| OpActualProcessingStartTime | OpActualProcessingStartTime | 1 | |
| OpActualSetupEndDate | OpActualSetupEndDate | 1 | |
| OpActualSetupEndDateTime | OpActualSetupEndDateTime | 1 | |
| OpActualSetupEndTime | OpActualSetupEndTime | 1 | |
| OpActualTeardownStartDate | OpActualTeardownStartDate | 1 | |
| OpActualTeardownStartDateTime | OpActualTeardownStartDateTime | 1 | |
| OpActualTeardownStartTme | OpActualTeardownStartTme | 1 | |
| Operation | ManufacturingOrderOperation,MfgOrderOperationOrSubOp,Operation | 4 | |
| OperationConfirmation | OperationConfirmation | 1 | |
| OperationConfirmedEndDate | OperationConfirmedEndDate | 1 | |
| OperationConfirmedReworkQty | OperationConfirmedReworkQty | 1 | |
| OperationConfirmedStartDate | OperationConfirmedStartDate | 1 | |
| OperationControlProfile | OperationControlProfile | 1 | |
| OperationImportance | OperationImportance | 1 | |
| OperationIsToBeDeleted | OperationIsToBeDeleted | 1 | |
| OperationReferenceQuantity | OperationReferenceQuantity | 1 | |
| OperationScrapPercent | OperationScrapPercent | 1 | |
| OperationText | MfgOrderOperationText,OperationText | 5 | |
| OperationUnit | OperationUnit | 2 | |
| OpErlstSchedldExecEndDte | OpErlstSchedldExecEndDte | 1 | |
| OpErlstSchedldExecEndDteTme | OpErlstSchedldExecEndDteTme | 1 | |
| OpErlstSchedldExecEndTme | OpErlstSchedldExecEndTme | 1 | |
| OpErlstSchedldExecStrtDte | OpErlstSchedldExecStrtDte | 1 | |
| OpErlstSchedldExecStrtDteTme | OpErlstSchedldExecStrtDteTme | 1 | |
| OpErlstSchedldExecStrtTme | OpErlstSchedldExecStrtTme | 1 | |
| OpErlstSchedldProcgStrtDte | OpErlstSchedldProcgStrtDte | 1 | |
| OpErlstSchedldProcgStrtDteTme | OpErlstSchedldProcgStrtDteTme | 1 | |
| OpErlstSchedldProcgStrtTme | OpErlstSchedldProcgStrtTme | 1 | |
| OpErlstSchedldTrdwnStrtDte | OpErlstSchedldTrdwnStrtDte | 1 | |
| OpErlstSchedldTrdwnStrtDteTme | OpErlstSchedldTrdwnStrtDteTme | 1 | |
| OpErlstSchedldTrdwnStrtTme | OpErlstSchedldTrdwnStrtTme | 1 | |
| OpLtstSchedldExecEndDte | OpLtstSchedldExecEndDte | 1 | |
| OpLtstSchedldExecEndDteTme | OpLtstSchedldExecEndDteTme | 1 | |
| OpLtstSchedldExecEndTme | OpLtstSchedldExecEndTme | 1 | |
| OpLtstSchedldExecStrtDte | OpLtstSchedldExecStrtDte | 2 | |
| OpLtstSchedldExecStrtDteTme | OpLtstSchedldExecStrtDteTme | 1 | |
| OpLtstSchedldExecStrtTme | OpLtstSchedldExecStrtTme | 2 | |
| OpLtstSchedldProcgStrtDte | OpLtstSchedldProcgStrtDte | 2 | |
| OpLtstSchedldProcgStrtDteTme | OpLtstSchedldProcgStrtDteTme | 1 | |
| OpLtstSchedldProcgStrtTme | OpLtstSchedldProcgStrtTme | 2 | |
| OpLtstSchedldTrdwnStrtDte | OpLtstSchedldTrdwnStrtDte | 2 | |
| OpLtstSchedldTrdwnStrtDteTme | OpLtstSchedldTrdwnStrtDteTme | 1 | |
| OpLtstSchedldTrdwnStrtTme | OpLtstSchedldTrdwnStrtTme | 2 | |
| OpPlannedScrapQuantity | OpPlannedScrapQuantity | 1 | |
| OpPlannedTotalQuantity | OpPlannedTotalQuantity | 2 | |
| OpTotalConfirmedScrapQty | OpTotalConfirmedScrapQty | 1 | |
| OpTotalConfirmedYieldQty | OpTotalConfirmedYieldQty | 1 | |
| Personnel | Personnel | 1 | |
| Plant | Plant,ProductionPlant | 5 | |
| PlantName | ProductionPlantName | 1 | |
| PlantTimeZone | PlantTimeZone | 1 | |
| ProduceOpActyNtwkInstance | ProduceOpActyNtwkInstance | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| Sequence | Sequence | 1 | |
| SetupOpActyNtwkInstance | SetupOpActyNtwkInstance | 1 | |
| StandardTextInternalID | StandardTextInternalID | 1 | |
| StartDateOffsetDuration | StartDateOffsetDuration | 1 | |
| StartDateOffsetDurationUnit | StartDateOffsetDurationUnit | 1 | |
| StartDateOffsetReferenceCode | StartDateOffsetReferenceCode | 1 | |
| TeardownOpActyNtwkInstance | TeardownOpActyNtwkInstance | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 4 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 4 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Order Operation Date and Time as Timestamp
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDEROPERATIONDATETIME (
ORDERINTERNALID,
ORDEROPERATIONINTERNALID,
_WORKCENTER,
BILLOFMATERIALCATEGORY,
BILLOFMATERIALINTERNALID,
BILLOFMATERIALITEMNODENUMBER,
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSSEQUENCE,
BILLOFOPERATIONSTYPE,
BILLOFOPERATIONSVARIANT,
BILLOFOPERATIONSVERSION,
BOMITEMNODECOUNT,
BOOOPERATIONINTERNALID,
BUSINESSAREA,
CAPACITYREQUIREMENT,
CAPACITYREQUIREMENTITEM,
CHANGENUMBER,
COMPANYCODE,
CONTROLLINGOBJECTCLASS,
EMPLOYEESUITABILITY,
EMPLOYEEWAGEGROUP,
EMPLOYEEWAGETYPE,
ENDDATEOFFSETDURATION,
ENDDATEOFFSETDURATIONUNIT,
ENDDATEOFFSETREFERENCECODE,
FACTORYCALENDAR,
FUNCTIONALAREA,
LANGUAGE,
NUMBEROFCONFIRMATIONSLIPS,
NUMBEROFEMPLOYEES,
NUMBEROFOPERATIONCONFIRMATIONS,
NUMBEROFTIMETICKETS,
OBJECTINTERNALID,
OPACTUALEXECUTIONENDDATE,
OPACTUALEXECUTIONENDDATETIME,
OPACTUALEXECUTIONENDTIME,
OPACTUALEXECUTIONSTARTDATE,
OPACTUALEXECUTIONSTARTDATETIME,
OPACTUALEXECUTIONSTARTTIME,
OPACTUALPROCESSINGENDDATE,
OPACTUALPROCESSINGENDDATETIME,
OPACTUALPROCESSINGENDTIME,
OPACTUALPROCESSINGSTARTDATE,
OPACTUALPROCESSINGSTARTDTETME,
OPACTUALPROCESSINGSTARTTIME,
OPACTUALSETUPENDDATE,
OPACTUALSETUPENDDATETIME,
OPACTUALSETUPENDTIME,
OPACTUALTEARDOWNSTARTDATE,
OPACTUALTEARDOWNSTARTDATETIME,
OPACTUALTEARDOWNSTARTTME,
OPERATION,
OPERATIONCONFIRMATION,
OPERATIONCONFIRMEDENDDATE,
OPERATIONCONFIRMEDREWORKQTY,
OPERATIONCONFIRMEDSTARTDATE,
OPERATIONCONTROLPROFILE,
OPERATIONIMPORTANCE,
OPERATIONISTOBEDELETED,
OPERATIONREFERENCEQUANTITY,
OPERATIONSCRAPPERCENT,
OPERATIONTEXT,
OPERATIONUNIT,
OPERLSTSCHEDLDEXECENDDTE,
OPERLSTSCHEDLDEXECENDDTETME,
OPERLSTSCHEDLDEXECENDTME,
OPERLSTSCHEDLDEXECSTRTDTE,
OPERLSTSCHEDLDEXECSTRTDTETME,
OPERLSTSCHEDLDEXECSTRTTME,
OPERLSTSCHEDLDPROCGSTRTDTE,
OPERLSTSCHEDLDPROCGSTRTDTETME,
OPERLSTSCHEDLDPROCGSTRTTME,
OPERLSTSCHEDLDTRDWNSTRTDTE,
OPERLSTSCHEDLDTRDWNSTRTDTETME,
OPERLSTSCHEDLDTRDWNSTRTTME,
OPLTSTSCHEDLDEXECENDDTE,
OPLTSTSCHEDLDEXECENDDTETME,
OPLTSTSCHEDLDEXECENDTME,
OPLTSTSCHEDLDEXECSTRTDTE,
OPLTSTSCHEDLDEXECSTRTDTETME,
OPLTSTSCHEDLDEXECSTRTTME,
OPLTSTSCHEDLDPROCGSTRTDTE,
OPLTSTSCHEDLDPROCGSTRTDTETME,
OPLTSTSCHEDLDPROCGSTRTTME,
OPLTSTSCHEDLDTRDWNSTRTDTE,
OPLTSTSCHEDLDTRDWNSTRTDTETME,
OPLTSTSCHEDLDTRDWNSTRTTME,
OPPLANNEDSCRAPQUANTITY,
OPPLANNEDTOTALQUANTITY,
OPTOTALCONFIRMEDSCRAPQTY,
OPTOTALCONFIRMEDYIELDQTY,
PERSONNEL,
PLANT,
PLANTNAME,
PLANTTIMEZONE,
PRODUCEOPACTYNTWKINSTANCE,
PROFITCENTER,
SEQUENCE,
SETUPOPACTYNTWKINSTANCE,
STANDARDTEXTINTERNALID,
STARTDATEOFFSETDURATION,
STARTDATEOFFSETDURATIONUNIT,
STARTDATEOFFSETREFERENCECODE,
TEARDOWNOPACTYNTWKINSTANCE,
WORKCENTERINTERNALID,
WORKCENTERTYPECODE,
PRIMARY KEY (ORDERINTERNALID, ORDEROPERATIONINTERNALID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA