_ORDERITEM

15 Fields

_ORDERITEM is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 1
KEY OrderInternalBillOfOperations OrderInternalBillOfOperations 1
_Material _Material 1
ManufacturingOrder ManufacturingOrder 1
ManufacturingOrderOperation ManufacturingOrderOperation 1
Material Material 5
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 1
MfgOrderOperationText MfgOrderOperationText 1
ObjectInternalID ObjectInternalID 1
OpActualExecutionStartDate OpActualExecutionStartDate 1
OpActualExecutionStartTime OpActualExecutionStartTime 1
OperationUnit OperationUnit 1
OpLtstSchedldExecEndDte OpLtstSchedldExecEndDte 1
OpLtstSchedldExecEndTme OpLtstSchedldExecEndTme 1
OpPlannedTotalQuantity OpPlannedTotalQuantity 1

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 _ORDERITEM (
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALBILLOFOPERATIONS,
    _MATERIAL,
    MANUFACTURINGORDER,
    MANUFACTURINGORDEROPERATION,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MFGORDEROPERATIONTEXT,
    OBJECTINTERNALID,
    OPACTUALEXECUTIONSTARTDATE,
    OPACTUALEXECUTIONSTARTTIME,
    OPERATIONUNIT,
    OPLTSTSCHEDLDEXECENDDTE,
    OPLTSTSCHEDLDEXECENDTME,
    OPPLANNEDTOTALQUANTITY,
    PRIMARY KEY (ORDERINTBILLOFOPERATIONSITEM, ORDERINTERNALBILLOFOPERATIONS)
);

Learn More