_ORDEROPERATION
_ORDEROPERATION is an SAP database table in S/4HANA. It contains 55 fields.
Fields (55)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CapacityRequirement | CapacityRequirement | 2 |
| KEY | CapacityRequirementItem | CapacityRequirementItem | 2 |
| KEY | CapacityRqmtItemCapacity | CapacityRqmtItemCapacity | 2 |
| KEY | OrderCategory | OrderCategory | 2 |
| KEY | OrderID | OrderID | 1 |
| KEY | SimulationSessionID | SimulationSessionID | 1 |
| BillOfOperationsGroup | BillOfOperationsGroup | 1 | |
| BillOfOperationsType | BillOfOperationsType | 1 | |
| IndustryType | IndustryType | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LtstSchedldExecEndDteTme | LtstSchedldExecEndDteTme | 1 | |
| LtstSchedldExecStrtDteTme | LtstSchedldExecStrtDteTme | 1 | |
| MfgOrderOperationIsPhase | MfgOrderOperationIsPhase | 1 | |
| MRPAreaText | MRPAreaText | 1 | |
| MRPController | MRPController | 1 | |
| Operation | Operation | 2 | |
| OperationLatestEndDateTime | OperationLatestEndDateTime | 1 | |
| OperationLatestStartDateTime | OperationLatestStartDateTime | 1 | |
| OperationPlanningStatusCode | OperationPlanningStatusCode | 1 | |
| OperationSetupGroup | OperationSetupGroup | 1 | |
| OperationSetupGroupCategory | OperationSetupGroupCategory | 1 | |
| OpLtstSchedldProcgStrtDte | OpLtstSchedldProcgStrtDte | 1 | |
| OpLtstSchedldProcgStrtTme | OpLtstSchedldProcgStrtTme | 1 | |
| OpLtstSchedldTrdwnStrtDte | OpLtstSchedldTrdwnStrtDte | 1 | |
| OpLtstSchedldTrdwnStrtTme | OpLtstSchedldTrdwnStrtTme | 1 | |
| OrderCategoryName | OrderCategoryName | 1 | |
| OrderHasConfiguration | OrderHasConfiguration | 1 | |
| OrderIDForUsrInterface | OrderIDForUsrInterface | 1 | |
| OrderInternalID | OrderInternalID | 1 | |
| OrderIsDependentCollvOrder | OrderIsDependentCollvOrder | 1 | |
| OrderOperationInternalID | OrderOperationInternalID | 1 | |
| OrderType | OrderType | 2 | |
| PlannedOrderIsFirm | PlannedOrderIsFirm | 1 | |
| Plant | Plant | 2 | |
| PlantCurrentDateTime | PlantCurrentDateTime | 1 | |
| PlantTimeZone | PlantTimeZone | 2 | |
| ProductCollection | ProductCollection | 1 | |
| ProductConfiguration | ProductConfiguration | 1 | |
| ProductSeason | ProductSeason | 1 | |
| ProductSeasonYear | ProductSeasonYear | 1 | |
| ProductTheme | ProductTheme | 1 | |
| RemainingCapReqExecutionDurn | RemainingCapReqExecutionDurn | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| SchedldOrdEndDteTme | SchedldOrdEndDteTme | 1 | |
| SchedldOrdStartDteTme | SchedldOrdStartDteTme | 1 | |
| ScheduledOrderReceiptDateTime | ScheduledOrderReceiptDateTime | 2 | |
| SchedulingStatusText | SchedulingStatusText | 1 | |
| Sequence | Sequence | 1 | |
| StockSegment | StockSegment | 1 | |
| UnitOfMeasure | UnitOfMeasure | 1 | |
| UnitOfMeasure_E | UnitOfMeasure_E | 1 | |
| WorkCenter | WorkCenter | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 | |
| WORKCENTERTEXT | WORKCENTERTEXT | 2 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ORDEROPERATION (
CAPACITYREQUIREMENT,
CAPACITYREQUIREMENTITEM,
CAPACITYRQMTITEMCAPACITY,
ORDERCATEGORY,
ORDERID,
SIMULATIONSESSIONID,
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSTYPE,
INDUSTRYTYPE,
LASTCHANGEDATETIME,
LTSTSCHEDLDEXECENDDTETME,
LTSTSCHEDLDEXECSTRTDTETME,
MFGORDEROPERATIONISPHASE,
MRPAREATEXT,
MRPCONTROLLER,
OPERATION,
OPERATIONLATESTENDDATETIME,
OPERATIONLATESTSTARTDATETIME,
OPERATIONPLANNINGSTATUSCODE,
OPERATIONSETUPGROUP,
OPERATIONSETUPGROUPCATEGORY,
OPLTSTSCHEDLDPROCGSTRTDTE,
OPLTSTSCHEDLDPROCGSTRTTME,
OPLTSTSCHEDLDTRDWNSTRTDTE,
OPLTSTSCHEDLDTRDWNSTRTTME,
ORDERCATEGORYNAME,
ORDERHASCONFIGURATION,
ORDERIDFORUSRINTERFACE,
ORDERINTERNALID,
ORDERISDEPENDENTCOLLVORDER,
ORDEROPERATIONINTERNALID,
ORDERTYPE,
PLANNEDORDERISFIRM,
PLANT,
PLANTCURRENTDATETIME,
PLANTTIMEZONE,
PRODUCTCOLLECTION,
PRODUCTCONFIGURATION,
PRODUCTSEASON,
PRODUCTSEASONYEAR,
PRODUCTTHEME,
REMAININGCAPREQEXECUTIONDURN,
SALESORDER,
SALESORDERITEM,
SCHEDLDORDENDDTETME,
SCHEDLDORDSTARTDTETME,
SCHEDULEDORDERRECEIPTDATETIME,
SCHEDULINGSTATUSTEXT,
SEQUENCE,
STOCKSEGMENT,
UNITOFMEASURE,
UNITOFMEASURE_E,
WORKCENTER,
WORKCENTERINTERNALID,
WORKCENTERTEXT,
PRIMARY KEY (CAPACITYREQUIREMENT, CAPACITYREQUIREMENTITEM, CAPACITYRQMTITEMCAPACITY, ORDERCATEGORY, ORDERID, SIMULATIONSESSIONID)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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