I_ORDERSEQUENCEBYSEMKEY

CDS View
26 Fields 3 CDS Views

Order Sequence by Semantic Key

I_ORDERSEQUENCEBYSEMKEY is a CDS View in S/4HANA. Order Sequence by Semantic Key. It contains 26 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_ManufacturingOrderSequence view_entity from CONSUMPTION Manufacturing Order Sequence
I_ManufacturingOrderSequence view from COMPOSITE Manufacturing Order Sequence
I_ProductionOrderSequence view_entity from COMPOSITE Production Order Sequence

Fields (26)

KeyField CDS FieldsUsed in Views
_BillOfOperationsGroup _BillOfOperationsGroup 2
_BillOfOperationsType _BillOfOperationsType 2
_BillOfOperationsUnit _BillOfOperationsUnit 2
_Language _Language 3
_LongText _LongText 1
_OrderInternalID _OrderInternalID 2
_OrderSequence _SequenceInternalID 2
_Plant _Plant 3
_SequenceCategory _SequenceCategory 3
_SequenceSchedulingAlignment _SequenceSchedulingAlignment 3
BillOfOperations BillOfOperationsVariant 2
BillOfOperationsGroup BillOfOperationsGroup 2
BillOfOperationsType BillOfOperationsType 2
BillOfOperationsUnit BillOfOperationsUnit 3
BranchOperationInternalID BranchOperationInternalID 1
MaximumLotSizeQuantity MaximumLotSizeQuantity 3
MinimumLotSizeQuantity MinimumLotSizeQuantity 3
ObjectInternalID ObjectInternalID 2
OrderInternalID OrderInternalID 3
ProductionPlant ProductionPlant 3
ReferenceSequence BillOfOperationsSequence,ReferenceSequence 3
ReturnOperationInternalID ReturnOperationInternalID 1
SequenceCategory MfgOrderSequenceCategory,SequenceCategory 3
SequenceHasLongText MfgOrderSequenceHasLongText,SequenceHasLongText 3
SequenceInternalID SequenceInternalID 3
SequenceSchedulingAlignment SequenceSchedulingAlignment 3

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 by Semantic Key
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDERSEQUENCEBYSEMKEY (
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    _BILLOFOPERATIONSUNIT,
    _LANGUAGE,
    _LONGTEXT,
    _ORDERINTERNALID,
    _ORDERSEQUENCE,
    _PLANT,
    _SEQUENCECATEGORY,
    _SEQUENCESCHEDULINGALIGNMENT,
    BILLOFOPERATIONS,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSUNIT,
    BRANCHOPERATIONINTERNALID,
    MAXIMUMLOTSIZEQUANTITY,
    MINIMUMLOTSIZEQUANTITY,
    OBJECTINTERNALID,
    ORDERINTERNALID,
    PRODUCTIONPLANT,
    REFERENCESEQUENCE,
    RETURNOPERATIONINTERNALID,
    SEQUENCECATEGORY,
    SEQUENCEHASLONGTEXT,
    SEQUENCEINTERNALID,
    SEQUENCESCHEDULINGALIGNMENT
);

Learn More