SAP table OIJSUBSTAT (OIL-TSW : Substatus Table)
SAP table OIJSUBSTAT has 4 primary key fields being MANDT,TABNAME,STATUS,SUBSTATUS.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
OIL-TSW: Reference table ID
CHAR
30
0
OIJSTATTAB
OIJ_REFTAB
Nomination Item status
CHAR
1
0
OIJSTAT
OIJ_ISTAT
Possible values
1
Planned
2
Scheduled
3
Accepted
4
Confirmed
5
Partially complete
6
Complete
7
Rejected
8
Dummy
9
Received
A
Sent
B
Checked
C
Processed
Nomination Item sub-status
CHAR
1
0
*
OIJ_SSTAT
Possible values
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
Check Table
Check Field
0 OIJSUBSTAT
MANDT
T000 Clients
MANDT
1 OIJSUBSTAT
STATUS
OIJSTAT OIL-TSW : Status Table
MANDT
1 OIJSUBSTAT
STATUS
OIJSTAT OIL-TSW : Status Table
TABNAME
1 OIJSUBSTAT
STATUS
OIJSTAT OIL-TSW : Status Table
STATUS
0 OIJSUBSTAT
TABNAME
OIJSTATTAB OIL-TSW: Permissible reference tables for stati
TABNAME