SAP Table OIJRRA
OIL-TSW: Partner roles
OIJRRA (OIL-TSW: Partner roles) 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 OIJRRA to other SAP tables.
OIJRRA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||||||
| WERK | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||||||
| RTYPE | OIL-TSW: Role type | OIJ_RTYPE | OIJRRT | CHAR | 6 | 0 | ||||||
| RDIFF | OIL-TSW: Role differentiator | OIJ_RDIFF | CHAR | 20 | 0 | |||||||
| RPART | OIL-TSW: Role partner type | OIJ_RPART | OIJRRPART | CHAR | 2 | 0 | ||||||
| CPARID | Location Partner | OIJ_PARTNR | CHAR | 10 | 0 | |||||||
| PARNM | OIL-TSW: Common partner name | OIJ_PARNM | CHAR | 35 | 0 | |||||||
| TSYST | Transport system | OIJ_TSYST | OIJTS | CHAR | 10 | 0 | ||||||
| LOCID | Location ID | OIJ_LOCID | OIJLOC | CHAR | 10 | 0 | ||||||
| RULEID | OIL-TSW: Ticket number rules | OIJ_RULE | OIJHTNR | CHAR | 3 | 0 | ||||||
| TSPARID | OIL-TSW: Pipeline partner ID | OIJ_TSPARID | CHAR | 30 | 0 | |||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||
| ERZEIT | Time of creation | OI0_ERTIM | TIMS | 6 | 0 | |||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||
| AEZEIT | Time of day the record was changed | OI0_AETIM | TIMS | 6 | 0 | |||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||
| BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 1 | 0 |
Possible values
|
||||||
| DELIND | Deletion indicator | OIJ_DELIND | CHAR | 1 | 0 |
Possible values
|
||||||
OIJRRA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIJRRA | KUNNR | OIJRRA | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| OIJRRA | KUNNR | OIJRRA | MANDT | KNA1 | General Data in Customer Master | MANDT |
| OIJRRA | LGORT | OIJRRA | LGORT | T001L | Storage Locations | LGORT |
| OIJRRA | LGORT | OIJRRA | MANDT | T001L | Storage Locations | MANDT |
| OIJRRA | LGORT | OIJRRA | WERK | T001L | Storage Locations | WERKS |
| OIJRRA | LIFNR | OIJRRA | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| OIJRRA | LIFNR | OIJRRA | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| OIJRRA | LOCID | OIJRRA | MANDT | OIJLOC | Location table | MANDT |
| OIJRRA | LOCID | OIJRRA | LOCID | OIJLOC | Location table | LOCID |
| OIJRRA | MANDT | OIJRRA | MANDT | T000 | Clients | MANDT |
| OIJRRA | RPART | OIJRRA | MANDT | OIJRRPART | OIL-TSW : Partner Roles -> Role Partner Types | MANDT |
| OIJRRA | RPART | OIJRRA | RPART | OIJRRPART | OIL-TSW : Partner Roles -> Role Partner Types | RPART |
| OIJRRA | RTYPE | OIJRRA | MANDT | OIJRRT | OIL-TSW: Partner role types | MANDT |
| OIJRRA | RTYPE | OIJRRA | RTYPE | OIJRRT | OIL-TSW: Partner role types | RTYPE |
| OIJRRA | RULEID | OIJRRA | MANDT | OIJHTNR | OIL-TSW: Ticket Number Rules | MANDT |
| OIJRRA | RULEID | OIJRRA | RULEID | OIJHTNR | OIL-TSW: Ticket Number Rules | RULEID |
| OIJRRA | TSYST | OIJRRA | MANDT | OIJTS | Transport system (IS-Oil TSW standard/core object ) | MANDT |
| OIJRRA | TSYST | OIJRRA | TSYST | OIJTS | Transport system (IS-Oil TSW standard/core object ) | TSYST |
| OIJRRA | WERK | OIJRRA | MANDT | T001W | Plants/Branches | MANDT |
| OIJRRA | WERK | OIJRRA | WERK | T001W | Plants/Branches | WERKS |
