I_ORDERTYPE

CDS View
15 Fields 11 CDS Views

Order Type

I_ORDERTYPE is a CDS View in S/4HANA. Order Type. It contains 15 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
A_MfgOrderType view from BASIC Production Order Type
C_EvtBsdMfgOrderTypeVH view from CONSUMPTION Order Type
C_MaintItemMaintOrderTypeVH view from CONSUMPTION Maintenance Item Maintenance Order Type
C_MaintOrderTypeVH view from CONSUMPTION Maintenance Order Type Value Help
C_RealTmeWrkInProcOrderTypeVH view from CONSUMPTION Order Type
FAC_AUDIT_Z3_OrderType view from Order Type
I_MfgOrderType view_entity from BASIC Manufacturing Order Type
I_MfgOrderTypeVH view from COMPOSITE Manufacturing Order Type Value Help
I_OrderTypeVH view from COMPOSITE Order Type
I_ProdnAcctAssgmtObjTypeVH view from COMPOSITE Production Account Assignment Object Type
I_ProductionOrderType view_entity from BASIC Production Order Type

Fields (15)

KeyField CDS FieldsUsed in Views
KEY OrderType MaintenanceOrderType,OrderType 4
BudgetProfile BudgetProfile 1
CollectiveOrderHasAutoGoodsMvt CollectiveOrderHasAutoGoodsMvt 1
ControllingSettlementProfile ControllingSettlementProfile 1
OperationStatusProfile OperationStatusProfile 1
OrderCategory OrderCategory 1
OrderHasStatusChangeDocuments OrderHasStatusChangeDocuments 1
OrderIsReleasedUponCreation OrderIsReleasedUponCreation 1
OrderIsToBeClassified OrderIsToBeClassified 1
OrderNumberRange OrderNumberRange 1
PlanningProfile PlanningProfile 1
ResidenceTime1 ResidenceTime1 1
ResidenceTime2 ResidenceTime2 1
SettlementIsNotRequired SettlementIsNotRequired 1
StatusProfile StatusProfile 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 Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDERTYPE (
    ORDERTYPE,
    BUDGETPROFILE,
    COLLECTIVEORDERHASAUTOGOODSMVT,
    CONTROLLINGSETTLEMENTPROFILE,
    OPERATIONSTATUSPROFILE,
    ORDERCATEGORY,
    ORDERHASSTATUSCHANGEDOCUMENTS,
    ORDERISRELEASEDUPONCREATION,
    ORDERISTOBECLASSIFIED,
    ORDERNUMBERRANGE,
    PLANNINGPROFILE,
    RESIDENCETIME1,
    RESIDENCETIME2,
    SETTLEMENTISNOTREQUIRED,
    STATUSPROFILE,
    PRIMARY KEY (ORDERTYPE)
);

Learn More