SAP table ROIJRRAEXP01 (Partner roles (process structure); extended)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
WERK Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
RTYPE OIL-TSW: Role type CHAR 6 0 OIJRRT OIJ_RTYPE
RDIFF OIL-TSW: Role differentiator CHAR 20 0 OIJ_RDIFF
RPART OIL-TSW: Role partner type CHAR 2 0 OIJRRPART OIJ_RPART
CPARID Location Partner CHAR 10 0 OIJ_PARTNR
PARNM OIL-TSW: Common partner name CHAR 35 0 OIJ_PARNM
TSYST Transport system CHAR 10 0 OIJTS OIJ_TSYST
LOCID Location ID CHAR 10 0 OIJLOC OIJ_LOCID
RULEID OIL-TSW: Ticket number rules CHAR 3 0 OIJHTNR OIJ_RULE
TSPARID OIL-TSW: Pipeline partner ID CHAR 30 0 OIJ_TSPARID
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZEIT Time of creation TIMS 6 0 OI0_ERTIM
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZEIT Time of day the record was changed TIMS 6 0 OI0_AETIM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BLOIND Blocking indicator CHAR 1 0 OIJ_BLOIND
DELIND Deletion indicator CHAR 1 0 OIJ_DELIND
TKTSELECT Flag to Set Tickets Selectable CHAR 1 0 OIJ_TKTSELECT
SELECTFLAG General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
UPDATEFLAG Transaction type CHAR 1 0 TRTYP
* Masked
A Display
B Edit
C Display from archive
D Print
E Single-item planning
H Add
K Copy reference
L Delete
P Planning file entry
S Standard parameter: normal mode
U Convert indiv. planned order
V Change
X Initial transaction
MTEXT Medium Text CHAR 25 0 OIJ_TXT25
TSNAM OIL-TSW: Transport system name CHAR 60 0 OIJ_TSNAM
LOCNAM Location name (used by system owner) CHAR 60 0 OIJ_LOCNAM

ROIJRRAEXP01 foreign key relationships

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