SAP ABAP Table ROIJRRAEXP (OIL-TSW: Partner roles expanded Structure (with Text Fields))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	ROIJRRAEXP	Table Relationship Diagram
Short Description	OIL-TSW: Partner roles expanded Structure (with Text Fields)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	OIL-TSW: Partner roles
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
4	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
5	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
7	RTYPE	☐	OIJ_RTYPE	OIJ_RTYPE	CHAR	6	0	OIL-TSW: Role type	OIJRRT
8	RDIFF	☐	OIJ_RDIFF		CHAR	20	0	OIL-TSW: Role differentiator
9	RPART	☐	OIJ_RPART	OIJ_RPART	CHAR	2	0	OIL-TSW: Role partner type	OIJRRPART
10	CPARID	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
11	PARNM	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
12	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
13	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
14	RULEID	☐	OIJ_RULE	OIJ_RULE	CHAR	3	0	OIL-TSW: Ticket number rules	OIJHTNR
15	TSPARID	☐	OIJ_TSPARID	CHAR30	CHAR	30	0	OIL-TSW: Pipeline partner ID
16	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
17	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
18	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
19	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
21	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
22	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
23	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
24	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
25	MTEXT	☐	OIJ_TXT25	TEXT25	CHAR	25	0	Medium Text
26	TSNAM	☐	OIJ_TSNAM	OIJ_TSNAM	CHAR	60	0	OIL-TSW: Transport system name
27	LOCNAM	☐	OIJ_LOCNAM	OIJ_LOCNAM	CHAR	60	0	Location name (used by system owner)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJRRAEXP	KUNNR	KNA1	KUNNR
2	ROIJRRAEXP	LGORT	T001L	LGORT
3	ROIJRRAEXP	LIFNR	LFA1	LIFNR
4	ROIJRRAEXP	LOCID	OIJLOC	LOCID
5	ROIJRRAEXP	MANDT	T000	MANDT
6	ROIJRRAEXP	RPART	OIJRRPART	RPART	KEY	1	CN
7	ROIJRRAEXP	RTYPE	OIJRRT	RTYPE	KEY	1	CN
8	ROIJRRAEXP	RULEID	OIJHTNR	RULEID
9	ROIJRRAEXP	TSYST	OIJTS	TSYST
10	ROIJRRAEXP	WERK	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in