SAP Table OIJSUBSTAT

OIL-TSW : Substatus Table

OIJSUBSTAT (OIL-TSW : Substatus Table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIJSUBSTAT to other SAP tables.

OIJSUBSTAT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TABNAME OIL-TSW: Reference table ID OIJ_REFTAB OIJSTATTAB CHAR 30 0
STATUS Nomination Item status OIJ_ISTAT OIJSTAT CHAR 1 0
SUBSTATUS Nomination Item sub-status OIJ_SSTAT CHAR 1 0
1 Original
2 2nd run
3 3rd run
4 Positive
5 Negative
6 Complete
7 Part1
8 Part2
9 Part3
A Partially complete
B Complete
C Planned
D Scheduled
E Confirmed
F Rejected

OIJSUBSTAT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIJSUBSTAT MANDT OIJSUBSTAT MANDT T000 Clients MANDT
OIJSUBSTAT STATUS OIJSUBSTAT STATUS OIJSTAT OIL-TSW : Status Table STATUS
OIJSUBSTAT STATUS OIJSUBSTAT MANDT OIJSTAT OIL-TSW : Status Table MANDT
OIJSUBSTAT STATUS OIJSUBSTAT TABNAME OIJSTAT OIL-TSW : Status Table TABNAME
OIJSUBSTAT TABNAME OIJSUBSTAT TABNAME OIJSTATTAB OIL-TSW: Permissible reference tables for stati TABNAME