SAP table OIJSTAT (OIL-TSW : Status Table)

SAP table OIJSTAT has 3 primary key fields being MANDT,TABNAME,STATUS.

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
MANDT Client CLNT 3 0 T000 MANDT
TABNAME OIL-TSW: Reference table ID CHAR 30 0 OIJSTATTAB OIJ_REFTAB
STATUS Nomination Item status CHAR 1 0 OIJ_ISTAT
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

OIJSTAT foreign key relationships

Table Field Check Table Check Field
0 OIJSTAT MANDT T000 Clients MANDT
1 OIJSTAT TABNAME OIJSTATTAB OIL-TSW: Permissible reference tables for stati TABNAME