I_STATUSOBJECTSTATUSBASIC
Status Object Status Basic
I_STATUSOBJECTSTATUSBASIC is a CDS View in S/4HANA. Status Object Status Basic. It contains 4 fields. 43 CDS views read from this table.
CDS Views using this table (43)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_IntOrderOverallUserStatus | view_entity | from | CONSUMPTION | Internal order overall user status |
| C_Manageoperations | view_entity | left_outer | CONSUMPTION | Production Operations |
| C_OrderOperationSchedule | view_entity | left_outer | CONSUMPTION | Order Operation Schedule |
| C_ShopFloorOrderGenealogy | view | inner | CONSUMPTION | Shop Floor Order Genealogy |
| EWA_ALY_P_JST | view | from | ||
| I_EWA_WasteObjStatusMaxPrio | view_entity | from | COMPOSITE | Position of current status |
| I_InspectionOperationStatus | view | left_outer | BASIC | Inspection Operation Status |
| I_IntOrderActiveSystemStatus | view_entity | from | COMPOSITE | Internal Order Active System Status |
| I_IntOrderActiveUserStatus | view_entity | from | COMPOSITE | Internal Order Active User Status |
| I_MaintenanceObjectStatus | view_entity | from | BASIC | Maintenance Object Status |
| I_RFM_MfgOrderStatusObject | view | from | BASIC | Manufacturing Order Status Object |
| I_RSHMaintSchedExistingOp | view | left_outer | COMPOSITE | Existing Operations not part of Schedule |
| I_RSHOrderMaterialStatus | view | from | COMPOSITE | Order Material Status |
| I_StatusObjectStatus | view | from | COMPOSITE | Status Object Status |
| N_StatusObjectStatus | view | from | Status Object Status | |
| P_APIOrderStatus | view_entity | inner | COMPOSITE | |
| P_CoEvtBsdOrderMaxKeyStatus | view | from | COMPOSITE | |
| P_EBPCC_MaxKeyStatus | view_entity | from | COMPOSITE | Event-Based PCC Max Key Status |
| P_EBPCC_OrderActiveStatus | view | from | COMPOSITE | |
| P_EBPCC_OrderKeyStatus | view | from | COMPOSITE | |
| P_OrderIsShopFloorStatusBasic | view_entity | from | COMPOSITE | |
| P_OrderItemStatusBasic | view | from | COMPOSITE | |
| P_OrderOpCompStatusBasic | view | from | COMPOSITE | |
| P_OrderOperationStatusBasic | view | from | COMPOSITE | |
| P_OrderOpPRTStatusBasic | view | from | COMPOSITE | |
| P_OrderStatusBasic | view | from | COMPOSITE | |
| P_OrdFirstOper | view_entity | left_outer | CONSUMPTION | |
| P_Ordlatestoper | view_entity | left_outer | CONSUMPTION | |
| P_RealTimeMfgOrderStatus | view | from | COMPOSITE | |
| P_RealTimeMfgReleasedOrder | view | from | COMPOSITE | |
| P_RealTimeOrderKeyStatus | view | from | COMPOSITE | |
| P_RealTimeOrderKeyStatus | view | union_all | COMPOSITE | |
| P_RSHExOpsForScheduling | view | inner | CONSUMPTION | |
| P_RSHExOpsForScheduling | view | left_outer | CONSUMPTION | |
| P_RSHMaintSchedOperations | view | left_outer | CONSUMPTION | Operations from frozen schedule |
| P_RSHMaintSchedSmltdDueStatus | view | left_outer | CONSUMPTION | Processing Status |
| P_RSHOperationsForKPI | view | inner | CONSUMPTION | Operations and Sub Operations for overview page |
| P_RSHOperationsForKPI | view | left_outer | CONSUMPTION | Operations and Sub Operations for overview page |
| P_RTWIP_OrderMaxStatus | view | from | COMPOSITE | |
| P_ShopFloorOrderInformation | view | inner | CONSUMPTION | |
| P_WhereUsdPrftCtrSystemStatus | view | from | CONSUMPTION | Object System Status WUL Profit Centers |
| P_WhereUsdPrftCtrUsrStatBasic | view | from | CONSUMPTION | |
| R_IntOrdOverallSystemStatusTP | view_entity | from | TRANSACTIONAL | Overall system status |
Fields (4)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | StatusCode | StatusCode | 10 |
| KEY | StatusObject | ObjectInternalID,StatusObject | 16 |
| _StatusObject | _StatusObject | 1 | |
| StatusIsInactive | StatusIsInactive | 6 |
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.
-- Status Object Status Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STATUSOBJECTSTATUSBASIC (
STATUSCODE,
STATUSOBJECT,
_STATUSOBJECT,
STATUSISINACTIVE,
PRIMARY KEY (STATUSCODE, STATUSOBJECT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA