SAP Table ROIJRRAEXP01

Partner roles (process structure); extended

ROIJRRAEXP01 (Partner roles (process structure); extended) 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 ROIJRRAEXP01 to other SAP tables.

Source: ROIJRRAEXP01 (Partner roles (process structure); extended)

ROIJRRAEXP01 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
X Yes
NULL No
DELIND Deletion indicator OIJ_DELIND CHAR 1 0
X Yes
NULL No
SELECTFLAG General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
UPDATEFLAG Transaction type TRTYP CHAR 1 0
* Masked
A Display
B Edit
C Display from archive
E Single-item planning
H Add
V Change
X Initial transaction
S Standard parameter: normal mode
U Convert indiv. planned order
L Delete
P Planning file entry
K Copy reference
D Print
MTEXT Medium Text OIJ_TXT25 CHAR 25 0
TSNAM OIL-TSW: Transport system name OIJ_TSNAM CHAR 60 0
LOCNAM Location name (used by system owner) OIJ_LOCNAM CHAR 60 0

ROIJRRAEXP01 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROIJRRAEXP01 KUNNR ROIJRRAEXP01 KUNNR KNA1 General Data in Customer Master KUNNR
ROIJRRAEXP01 KUNNR ROIJRRAEXP01 MANDT KNA1 General Data in Customer Master MANDT
ROIJRRAEXP01 LGORT ROIJRRAEXP01 MANDT T001L Storage Locations MANDT
ROIJRRAEXP01 LGORT ROIJRRAEXP01 WERK T001L Storage Locations WERKS
ROIJRRAEXP01 LGORT ROIJRRAEXP01 LGORT T001L Storage Locations LGORT
ROIJRRAEXP01 LIFNR ROIJRRAEXP01 LIFNR LFA1 Vendor Master (General Section) LIFNR
ROIJRRAEXP01 LIFNR ROIJRRAEXP01 MANDT LFA1 Vendor Master (General Section) MANDT
ROIJRRAEXP01 LOCID ROIJRRAEXP01 LOCID OIJLOC Location table LOCID
ROIJRRAEXP01 LOCID ROIJRRAEXP01 MANDT OIJLOC Location table MANDT
ROIJRRAEXP01 MANDT ROIJRRAEXP01 MANDT T000 Clients MANDT
ROIJRRAEXP01 RPART ROIJRRAEXP01 MANDT OIJRRPART OIL-TSW : Partner Roles -> Role Partner Types MANDT
ROIJRRAEXP01 RPART ROIJRRAEXP01 RPART OIJRRPART OIL-TSW : Partner Roles -> Role Partner Types RPART
ROIJRRAEXP01 RTYPE ROIJRRAEXP01 MANDT OIJRRT OIL-TSW: Partner role types MANDT
ROIJRRAEXP01 RTYPE ROIJRRAEXP01 RTYPE OIJRRT OIL-TSW: Partner role types RTYPE
ROIJRRAEXP01 RULEID ROIJRRAEXP01 MANDT OIJHTNR OIL-TSW: Ticket Number Rules MANDT
ROIJRRAEXP01 RULEID ROIJRRAEXP01 RULEID OIJHTNR OIL-TSW: Ticket Number Rules RULEID
ROIJRRAEXP01 TSYST ROIJRRAEXP01 TSYST OIJTS Transport system (IS-Oil TSW standard/core object ) TSYST
ROIJRRAEXP01 TSYST ROIJRRAEXP01 MANDT OIJTS Transport system (IS-Oil TSW standard/core object ) MANDT
ROIJRRAEXP01 WERK ROIJRRAEXP01 WERK T001W Plants/Branches WERKS
ROIJRRAEXP01 WERK ROIJRRAEXP01 MANDT T001W Plants/Branches MANDT