OIJSUBSTT SAP table for – OIL-TSW : Substatus Table Texts

Here we would like to draw your attention to OIJSUBSTT table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIJSUBSTT is a SAP standard transp table used for storing OIL-TSW : Substatus Table Texts related data in SAP. It comes under the package OIJ.

SAP OIJSUBSTT table

Table OIJSUBSTT technical data

TableOIJSUBSTT
Data storingOIL-TSW : Substatus Table Texts
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassS – System table, data changes have the status of program changes
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJSUBSTT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIJSUBSTT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SPRAS : Language Key
    Its a key field. Its data type is LANG (Language key character with length 1) with field length 1
  • TABNAME : OIL-TSW: Reference table ID
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • STATUS : Nomination Item status
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SUBSTATUS : Nomination Item sub-status
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • STEXT : Short text
    Its data type is CHAR (Character String) with field length 15