I_ORDERBASIC

CDS View
49 Fields 17 CDS Views

Order Header Basic

I_ORDERBASIC is a CDS View in S/4HANA. Order Header Basic. It contains 49 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_HCMTimeShtOrderVH view_entity from CONSUMPTION Receiver Order
C_IntOrdSettlmtRuleNtwkActyVH view_entity inner CONSUMPTION Internal Order Settlement Rule Network activity
FINOC_RULE_POI_BASE view inner Orgl Change-Rule: Purch. Order Item Base
I_ManufacturingOrderLongText view_entity inner COMPOSITE Manufacturing Order - Text
I_ManufacturingOrderStatus view_entity from COMPOSITE Manufacturing Order with Status
I_MfgOrderForExtraction view from BASIC Manufacturing Order
I_Order view from BASIC Order Header
I_OrderBasicVH view_entity from COMPOSITE Order Header
I_OrderComponent view inner BASIC Order Component
I_OrderConfirmation view inner BASIC Order Confirmation
I_ProductionOrderItem view_entity inner BASIC Production Order Item
I_ProductionOrderLongText view_entity inner COMPOSITE Production Order - Text
I_QualityCostCollector view from COMPOSITE QM Order
P_APIOrderStatus view_entity from COMPOSITE
P_CnsldtnOrder view from COMPOSITE
P_CnsldtnOrderT view from COMPOSITE
P_EventBasedOrderPostingRule view_entity inner TRANSACTIONAL

Fields (49)

KeyField CDS FieldsUsed in Views
KEY LongTextLanguage LongTextLanguage 3
KEY OrderID ManufacturingOrder,OrderID 2
_BusinessArea _BusinessArea 1
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 1
_ControllingObjectClass _ControllingObjectClass 1
_CostCenter _CostCenter 1
_Currency _Currency 1
_FunctionalArea _FunctionalArea 1
_LongText _LongText 1
_OrderCategory _OrderCategory 2
_OrderHierarchyNode _OrderHierarchyNode 1
_OrderType _OrderType 2
_ProductCostCtrlgOrder _ProductCostCtrlgOrder 1
_ProfitCenter _ProfitCenter 1
_ResponsibleCostCenter _ResponsibleCostCenter 1
BusinessArea BusinessArea 2
CompanyCode CompanyCode 5
ConditionApplication ConditionApplication 1
ControllingArea ControllingArea 4
CostCenter CostCenter 1
CostElement CostElement 1
CreatedByUser CreatedByUser 1
Currency CompanyCodeCurrency,Currency 2
EventBasedPostingMethod EventBasedPostingMethod 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
IsMarkedForDeletion IsMarkedForDeletion 2
IsStatisticalOrder IsStatisticalOrder 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LastChangeTime LastChangeTime 1
ObjectInternalID ObjectInternalID,OrderObjectInternalID 2
OrderActualCloseDate OrderActualCloseDate 1
OrderActualReleaseDate OrderActualReleaseDate 1
OrderCategory ManufacturingOrderCategory,OrderCategory 7
OrderDescription ManufacturingOrderText,OrderDescription,ProductionOrderText 3
OrderHasLongText ManufacturingOrderHasLongText,OrderHasLongText 2
OrderIsClosed OrderIsClosed 1
OrderIsCompleted OrderIsCompleted 1
OrderIsCreated OrderIsCreated 1
OrderIsReleased OrderIsReleased 1
OrderType ManufacturingOrderType,OrderType 4
Plant Plant 1
ProductCostCollector ProductCostCollector 1
ProfitCenter ProfitCenter 2
ReferenceOrder ReferenceOrder 1
ResponsibleCostCenter ResponsibleCostCenter 1
TechnicalCompletionDate MfgOrderActualCompletionDate,TechnicalCompletionDate 2

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 Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORDERBASIC (
    LONGTEXTLANGUAGE,
    ORDERID,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _CONTROLLINGOBJECTCLASS,
    _COSTCENTER,
    _CURRENCY,
    _FUNCTIONALAREA,
    _LONGTEXT,
    _ORDERCATEGORY,
    _ORDERHIERARCHYNODE,
    _ORDERTYPE,
    _PRODUCTCOSTCTRLGORDER,
    _PROFITCENTER,
    _RESPONSIBLECOSTCENTER,
    BUSINESSAREA,
    COMPANYCODE,
    CONDITIONAPPLICATION,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTELEMENT,
    CREATEDBYUSER,
    CURRENCY,
    EVENTBASEDPOSTINGMETHOD,
    FUNCTIONALAREA,
    GLACCOUNT,
    ISMARKEDFORDELETION,
    ISSTATISTICALORDER,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    OBJECTINTERNALID,
    ORDERACTUALCLOSEDATE,
    ORDERACTUALRELEASEDATE,
    ORDERCATEGORY,
    ORDERDESCRIPTION,
    ORDERHASLONGTEXT,
    ORDERISCLOSED,
    ORDERISCOMPLETED,
    ORDERISCREATED,
    ORDERISRELEASED,
    ORDERTYPE,
    PLANT,
    PRODUCTCOSTCOLLECTOR,
    PROFITCENTER,
    REFERENCEORDER,
    RESPONSIBLECOSTCENTER,
    TECHNICALCOMPLETIONDATE,
    PRIMARY KEY (LONGTEXTLANGUAGE, ORDERID)
);

Learn More