I_ORDER

CDS View
8 Fields 11 CDS Views

Order Header

I_ORDER is a CDS View in S/4HANA. Order Header. It contains 8 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_OrderMasterVH view from CONSUMPTION Order Master Value Help
FAC_orderVH view from Data Source for Order
finoc_hard_dependency_soi view_entity left_outer Orgl Change: SOI Hard Dependencies
finoc_hard_dependency_soi view_entity inner Orgl Change: SOI Hard Dependencies
FINOC_RT_ORD_FILL view inner Orgl Change: Fill Runtime for Order
FINOC_RULE_FA_BASE view inner Orgl Change: Fixed Asset Base
FINOC_RULE_FA_BASE view left_outer Orgl Change: Fixed Asset Base
I_FldLogsWorkOrderVH view from COMPOSITE Work Order Value Help Non Teco Orders
I_MM_LogisticsOrderVH view from COMPOSITE MM Purchasing Logistics Order Value Help
P_CtrlgSettlementObject view from COMPOSITE
P_WhereUsdPrftCtrOrder view from CONSUMPTION

Fields (8)

KeyField CDS FieldsUsed in Views
KEY OrderID OrderID 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
MRPController MRPController 1
OrderCategory OrderCategory 2
OrderDescription OrderDescription 1
OrderType OrderType 1
Plant Plant 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.

-- Order Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDER (
    ORDERID,
    COMPANYCODE,
    CONTROLLINGAREA,
    MRPCONTROLLER,
    ORDERCATEGORY,
    ORDERDESCRIPTION,
    ORDERTYPE,
    PLANT,
    PRIMARY KEY (ORDERID)
);

Learn More