I_ORDERSEQUENCE

CDS View
39 Fields 10 CDS Views

Order Sequence

I_ORDERSEQUENCE is a CDS View in S/4HANA. Order Sequence. It contains 39 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_MfgOrdOpDetsForOpActyExec view inner CONSUMPTION Manufacturing order operation details for OA execution
I_MfgOrderSequence view from COMPOSITE Manufacturing Order Sequence
I_MfgOrderSequenceBasic view from BASIC Manufacturing Order Sequence Basic View
I_MfgOrderSequenceLongText view_entity inner COMPOSITE Manufacturing Order Sequence - Text
I_MfgOrdOpDatesBySemKeyStdVH view inner COMPOSITE Manufacturing Order Operation Dates By Semantic Key
I_OrderSequenceBySemKey view from BASIC Order Sequence by Semantic Key
I_ProdnOrderSequenceLongText view_entity inner COMPOSITE Production Order Sequence - Text
P_DemandDrivenOpAggr view left_outer CONSUMPTION Latest Operation in Expedite
P_MfgOrderHasParallelSequence view from COMPOSITE
P_OperationSequence view_entity from CONSUMPTION View to retrieve the sequence category branch to and from

Fields (39)

KeyField CDS FieldsUsed in Views
KEY OrderID ManufacturingOrder,OrderID 3
KEY OrderInternalID OrderInternalBillOfOperations,OrderInternalID 6
KEY Sequence Sequence 2
KEY SequenceInternalID OrderIntBillOfOperationsItem,SequenceInternalID 6
_BillOfOperationsGroup _BillOfOperationsGroup 2
_BillOfOperationsType _BillOfOperationsType 3
_BillOfOperationsUnit _BillOfOperationsUnit 3
_BillOfOperationsVariant _BillOfOperationsVariant 3
_Language _Language 3
_LongText _LongText 2
_Order _Order 1
_OrderCategory _OrderCategory 1
_OrderInternalID _OrderInternalID 4
_OrderType _OrderType 1
_Plant _Plant 3
_ProductionSupervisor _ProductionSupervisor 1
_ReferenceSequence _ReferenceSequence 1
_SequenceCategory _SequenceCategory 4
_SequenceSchedulingAlignment _SequenceSchedulingAlignment 3
BillOfOperations BillOfOperations 2
BillOfOperationsGroup BillOfOperationsGroup 3
BillOfOperationsType BillOfOperationsType 3
BillOfOperationsUnit BillOfOperationsUnit 3
BillOfOperationsVariant BillOfOperations,BillOfOperationsVariant 3
BranchOperationInternalID BranchOperationInternalID 3
Language Language 3
MaximumLotSizeQuantity MaximumLotSizeQuantity 3
MinimumLotSizeQuantity MinimumLotSizeQuantity 3
ObjectInternalID ObjectInternalID 3
OrderCategory OrderCategory 2
OrderType OrderType 1
ProductionPlant ProductionPlant 3
ProductionSupervisor ProductionSupervisor 2
ReferenceSequence ReferenceSequence 3
ReturnOperationInternalID ReturnOperationInternalID 3
SequenceCategory MfgOrderSequenceCategory,SequenceCategory 4
SequenceHasLongText SequenceHasLongText 1
SequenceSchedulingAlignment SequenceSchedulingAlignment 3
SequenceText MfgOrderSequenceText,ProductionOrderSequenceText,SequenceText 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 Sequence
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDERSEQUENCE (
    ORDERID,
    ORDERINTERNALID,
    SEQUENCE,
    SEQUENCEINTERNALID,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _BILLOFOPERATIONSUNIT,
    _BILLOFOPERATIONSVARIANT,
    _LANGUAGE,
    _LONGTEXT,
    _ORDER,
    _ORDERCATEGORY,
    _ORDERINTERNALID,
    _ORDERTYPE,
    _PLANT,
    _PRODUCTIONSUPERVISOR,
    _REFERENCESEQUENCE,
    _SEQUENCECATEGORY,
    _SEQUENCESCHEDULINGALIGNMENT,
    BILLOFOPERATIONS,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSUNIT,
    BILLOFOPERATIONSVARIANT,
    BRANCHOPERATIONINTERNALID,
    LANGUAGE,
    MAXIMUMLOTSIZEQUANTITY,
    MINIMUMLOTSIZEQUANTITY,
    OBJECTINTERNALID,
    ORDERCATEGORY,
    ORDERTYPE,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    REFERENCESEQUENCE,
    RETURNOPERATIONINTERNALID,
    SEQUENCECATEGORY,
    SEQUENCEHASLONGTEXT,
    SEQUENCESCHEDULINGALIGNMENT,
    SEQUENCETEXT,
    PRIMARY KEY (ORDERID, ORDERINTERNALID, SEQUENCE, SEQUENCEINTERNALID)
);

Learn More