OIJRRA SAP table for – OIL-TSW: Partner roles

Here we would like to draw your attention to OIJRRA 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). OIJRRA is a SAP standard transp table used for storing OIL-TSW: Partner roles related data in SAP. It comes under the package OIJ.

SAP OIJRRA table

Table OIJRRA technical data

TableOIJRRA
Data storingOIL-TSW: Partner roles
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJRRA 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 OIJRRA table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • KUNNR : Customer Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • LIFNR : Account Number of Vendor or Creditor
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • WERK : Plant
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • LGORT : Storage location
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RTYPE : OIL-TSW: Role type
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • RDIFF : OIL-TSW: Role differentiator
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • RPART : OIL-TSW: Role partner type
    Its data type is CHAR (Character String) with field length 2
  • CPARID : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • PARNM : OIL-TSW: Common partner name
    Its data type is CHAR (Character String) with field length 35
  • TSYST : Transport system
    Its data type is CHAR (Character String) with field length 10
  • LOCID : Location ID
    Its data type is CHAR (Character String) with field length 10
  • RULEID : OIL-TSW: Ticket number rules
    Its data type is CHAR (Character String) with field length 3
  • TSPARID : OIL-TSW: Pipeline partner ID
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : OIL-TSW: Standard status field set (TSW)
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1