I_INTERNALORDER

CDS View
21 Fields 29 CDS Views

Internal Order

I_INTERNALORDER is a CDS View in S/4HANA. Internal Order. It contains 21 fields. 29 CDS views read from this table.

CDS Views using this table (29)

ViewTypeJoinVDMDescription
A_InternalOrder view from BASIC API Internal Order
C_InternalOrderQ0001 view from CONSUMPTION Internal Order
C_IntOrderOverallUserStatus view_entity inner CONSUMPTION Internal order overall user status
C_ReExAssignInternalOrder view from CONSUMPTION Internal Order
C_WhereUsdIntOrdVH view from CONSUMPTION WUIO Internal Orders
I_CnsldtnMasterData view union_all COMPOSITE Consolidation - Combined Master Data
I_InternalOrderSettlementRule view_entity inner COMPOSITE Internal Order Settlement Rule
I_InternalOrderStdVH view from COMPOSITE Internal Order
I_InternalOrderVH view from COMPOSITE Internal Order Value Help
I_IntOrderActiveSystemStatus view_entity inner COMPOSITE Internal Order Active System Status
I_IntOrderActiveUserStatus view_entity inner COMPOSITE Internal Order Active User Status
I_ProjectActualCostLineItem view_entity inner COMPOSITE Project Actual Cost
I_ProjectFinPlanByPlanCategory view_entity inner COMPOSITE Project Financial Cost by Plan category
I_ProjectObjectUnion view_entity union_all COMPOSITE Hierarchy data of the Project
I_REControllingObject view union_all COMPOSITE Real Estate Accounting Object
P_EventBasedOverheadOrderVH view union COMPOSITE Order details
P_InternalOrderSystemStatus view_entity inner COMPOSITE
P_ProjectActualCostLineItem view inner COMPOSITE
P_ProjectObject_2 view union_all COMPOSITE Project Object
P_ProjectPlanCostLineItem view inner COMPOSITE
P_RunOverheadOrder view union COMPOSITE
P_RunSettlementActualOrder view union COMPOSITE
P_SettlementSender view union_all CONSUMPTION
P_WhereUsdIntOrdAlloc view_entity from COMPOSITE
P_WhereUsdIntOrdAlloc view_entity union_all COMPOSITE
R_InternalOrderTP view_entity from TRANSACTIONAL Internal Order
R_IntOrderNumberedUserStatusTP view_entity inner TRANSACTIONAL Internal order user status with number
R_IntOrdOverallSystemStatusTP view_entity inner TRANSACTIONAL Overall system status
R_IntOrdUnnumberedUserStatusTP view_entity inner TRANSACTIONAL Int. order user status without number

Fields (21)

KeyField CDS FieldsUsed in Views
KEY InternalOrder InternalOrder,ProjectObjectExternalID 12
_CompanyCode _CompanyCode 1
_InternalOrderTypeText _InternalOrderTypeText 1
_IntOrderActiveSystemStatus _IntOrderActiveSystemStatus 1
_IntOrderActiveUserStatus _IntOrderActiveUserStatus 1
_LastChangedByUser _IntOrderLastChangedByUser 1
_SystemStatus _SystemStatus 1
BusinessArea BusinessArea 1
CompanyCode CompanyCode 4
ControllingArea ControllingArea 6
ControllingObject ControllingObject,InternalOrderControllingObject,ProjectObjectNode 7
Currency Currency 1
FunctionalArea FunctionalArea 1
InternalOrderDescription InternalOrderDescription,ProjectObjectDescription 6
InternalOrderResponsibleUser InternalOrderResponsibleUser 1
IsStatisticalOrder IsStatisticalOrder 1
OrderCategory OrderCategory 1
OrderType OrderType 10
Plant Plant 1
ProfitCenter ProfitCenter,ProjectObjectProfitCenter 6
ResponsibleCostCenter ResponsibleCostCenter 5

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.

-- Internal Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INTERNALORDER (
    INTERNALORDER,
    _COMPANYCODE,
    _INTERNALORDERTYPETEXT,
    _INTORDERACTIVESYSTEMSTATUS,
    _INTORDERACTIVEUSERSTATUS,
    _LASTCHANGEDBYUSER,
    _SYSTEMSTATUS,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    CURRENCY,
    FUNCTIONALAREA,
    INTERNALORDERDESCRIPTION,
    INTERNALORDERRESPONSIBLEUSER,
    ISSTATISTICALORDER,
    ORDERCATEGORY,
    ORDERTYPE,
    PLANT,
    PROFITCENTER,
    RESPONSIBLECOSTCENTER,
    PRIMARY KEY (INTERNALORDER)
);

Learn More