_ORDEROPERATION

_ORDEROPERATION is an SAP database table in S/4HANA. It contains 55 fields.

Fields (55)

KeyField CDS FieldsUsed 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)
);