SAP ABAP Table ROIJ_EL_TICKET_I_IO (TSW ticket item table Communication Structure)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ_EL (Package) TSW Trader's and Scheduler's Workbench - Execution Layer

Basic Data

Table Category	INTTAB	Structure
Structure	ROIJ_EL_TICKET_I_IO	Table Relationship Diagram
Short Description	TSW ticket item table Communication Structure

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	TSW Universal ticket item table Update Structure
2	.INCLUDE	☐				0	0	Universal ticket item table
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	TICKET_KEY	☐	OIJ_EL_TKT_KEY	OIJ_EL_TKT_KEY	CHAR	20	0	OIL-TSW: Ticket key	OIJ_EL_TICKET_H
5	TICKET_ITEM	☐	OIJ_EL_TKT_POSNR	OIJ_EL_TKT_POSNR	NUMC	6	0	OIL-TSW: Ticket item number
6	TICKET_VERSION	☐	OIJ_EL_TKT_VERSION	OIJ_EL_TKT_VERSION	NUMC	3	0	OIL-TSW: Ticket version
7	TICKET_PURPOSE	☐	OIJ_EL_TKT_PURPOSE	OIJ_EL_TKT_PURPOSE	CHAR	1	0	OIL-TSW: Ticket Purpose
8	EXT_POSNR	☐	OIJ_EL_EXT_POS	CHAR6	CHAR	6	0	External position number
9	STATUS	☐	OIJ_ISTAT	OIJ_ISTAT	CHAR	1	0	Nomination Item status	*
10	SUBSTATUS	☐	OIJ_SSTAT	OIJ_SSTAT	CHAR	1	0	Nomination Item sub-status	*
11	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
12	TKTSUBRC	☐	OIJ_TKTRC	OIJ_TKTRC	CHAR	2	0	OIL-TSW: Ticket process return code
13	MVSCENARIO	☐	OIJ_MVSCEN	NUM02	NUMC	2	0	TSW: Movement scenario number	TOIJ_EL_MVSCEN
14	NOMNR	☐	OIJ_NOMNR	OIJ_NOMNR	CHAR	20	0	Nomination number
15	NOMTK	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	OIJNOMH
16	NOMIT	☐	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	OIJNOMI
17	RECEIVER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
18	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
19	TANKNR	☐	OIJ_BSEQNR	OII_SEQNR	CHAR	10	0	Sequence number of tank assigned to a business location
20	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
21	MENGE	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
22	GROSQUAN	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
23	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
24	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
25	TANKAGE	☐	OIJ_TANKAGE	OIJ_PARTNR	CHAR	10	0	Tankage Partner
26	SUPPLIER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
27	CONSIGNE	☐	OIJ_CONSIGNEE	OIJ_PARTNR	CHAR	10	0	Consignee Partner
28	AGREED_QTY	☐	OIJ_AGGRDQTY	MENGE	QUAN	13	3	agreed qty. between ship. measr. and shore measrd. quants.
29	AGREED_QTY_UOM	☐	OIJ_LDUOM	MEINS	UNIT	3	0	Loaded/Discharged Material UOM	*
30	SHIP_QTY	☐	OIJ_SHIPQTY	MENGE	QUAN	13	3	ship measured ld/disc. material quantity
31	SHIP_QTY_UOM	☐	OIJ_LDUOM	MEINS	UNIT	3	0	Loaded/Discharged Material UOM	*
32	.INCLUDE	☐				0	0	OIL-TSW: Data for QCI
33	MTTMP	☐	OIB_MTTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Material Temperature: Observed Quantity
34	MTTEH	☐	OIB_MTTEH	MEINS	UNIT	3	0	Oil/Gas Material Temperature Unit: Observed Quantity	T006
35	O_API_GRAV	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
36	API_GRT_D	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
37	TSTMP	☐	OIB_TSTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Test Temperature: Observed Density
38	TSTEH	☐	OIB_TSTEH	MEINS	UNIT	3	0	Test Temperature Unit (Density): Measurement	T006
39	TDICH	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
40	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
41	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
42	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
43	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
44	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
45	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
46	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
47	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
48	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
49	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
50	CLOSE_NOMIT	☐	OIJ_EL_CLOSE_NOMIT	OIJ_EL_CLOSE_NOMIT	CHAR	1	0	IS OIL TSW: Indicator close nomination
51	EVENTTYPE	☐	OIJ_EVENTTYPE	OIJ_EVENTTYPE	CHAR	16	0	TSW event date type	OIJ_EL_EVT_TYPE
52	EVENT_DATE	☐	OIJ_EVENT_DATE	DATUM	DATS	8	0	OIL-TSW: Event date
53	.INCLUDE	☐				0	0	Meter Details in Ticket Item
54	GMMNR	☐	OII_GMMNR	OII_GMMNR	CHAR	20	0	GMM: Number of general meter	*
55	O_ITMSTM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
56	O_METEV	☐	OII_METEV	OII_METEV	CHAR	2	0	GMM: History record type	*
57	C_ITMSTM	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
58	C_METEV	☐	OII_METEV	OII_METEV	CHAR	2	0	GMM: History record type	*
59	STOPRDG	☐	OII_ENCOUN	OII_MCOUNT	NUMC	12	0	GMM: End counter reading
60	STM_QUANTITY	☐	OIJ_STM_QUANT	MENG13	QUAN	13	3	Stop meter calculation Quantity
61	STM_UOM	☐	OIJ_STM_UOM	MEINS	UNIT	3	0	Stop meter calculation UOM	*
62	.INCLUDE	☐				0	0	Tank details structure
63	SOCNR	☐	OII_SOCNR	OII_SOCNR	CHAR	20	0	SOC: Storage object characteristic segment number	*
64	O_DIP_READ	☐	OIJ_O_DIP_READ	MENGE	QUAN	13	3	Open dip reading
65	O_DIP_READ_UOM	☐	OII_LENUN	MEINS	UNIT	3	0	Length UoM (Oil BDRP)	*
66	O_ETMSTM	☐	OIB_TMSTM	OII_TIMEST	NUMC	14	0	Tank dip time stamp
67	O_SOCEV	☐	OIB_DIP_EVENTKEY	OIB_DIP_EVENTKEY	CHAR	2	0	Events in silo management tank dips
68	C_DIP_READ	☐	OIJ_C_DIP_READ	MENGE	QUAN	13	3	Close Dip reading
69	C_DIP_READ_UOM	☐	OII_LENUN	MEINS	UNIT	3	0	Length UoM (Oil BDRP)	*
70	C_ETMSTM	☐	OIB_TMSTM	OII_TIMEST	NUMC	14	0	Tank dip time stamp
71	C_SOCEV	☐	OIB_DIP_EVENTKEY	OIB_DIP_EVENTKEY	CHAR	2	0	Events in silo management tank dips
72	STOPDIP	☐	OII_TOTALHEIGHT	MENGE	QUAN	13	3	Tank dip, total height
73	STOPDIP_UOM	☐	OII_LENUN	MEINS	UNIT	3	0	Length UoM (Oil BDRP)	*
74	STP_GAU_QUAN	☐	OIJ_STG_QUAN	MENG13	QUAN	13	3	Stop gauge calculation - Quantity
75	STP_GAU_UOM	☐	OIJ_STG_UOM	MEINS	UNIT	3	0	Stop gauge calculation UOM	*
76	GAU_QUANTITY	☐	OIJ_GAU_QUAN	MENG13	QUAN	13	3	Calculated Gauge Quantity
77	GAU_UOM	☐	OIJ_GAU_UOM	MEINS	UNIT	3	0	Gauge Calculation UoM	*
78	SHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	TOIGS
79	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
80	CHARG_O	☐	OIJ_CHARGO	CHARG	CHAR	10	0	Batch origin Location	MCH1
81	WERKS_O	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
82	LGORT_O	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
83	CHARG_D	☐	OIJ_CHARGD	CHARG	CHAR	10	0	Batch destination Location	MCH1
84	WERKS_D	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
85	LGORT_D	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
86	TIME_ST_LOAD_STA	☐	TMSTMP	CHAR14	CHAR	14	0	Time at which data was created (date and time)
87	TIME_ST_LOAD_END	☐	TMSTMP	CHAR14	CHAR	14	0	Time at which data was created (date and time)
88	TIME_ST_LED_OT	☐	TMSTMP	CHAR14	CHAR	14	0	Time at which data was created (date and time)
89	CHARG_D_CREATE	☐	OIJ_CHARG_D_C	XFELD	CHAR	1	0	Destination Batch create new flag
90	OIB_BLTIME	☐	OIB_BLTIME	TIMES	TIMS	6	0	Posting time in the document
91	CHARG_L	☐	OIJ_CHARGL	CHARG	CHAR	10	0	Batch load	*
92	CHARG_L_CREATE	☐	OIJ_CHARG_L_C	XFELD	CHAR	1	0	Load Batch create new flag
93	.INCLUDE	☐				0	0	Universal ticket table Item Update Fields
94	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_EL_TICKET_I_IO	CHARG_D	MCH1	CHARG
2	ROIJ_EL_TICKET_I_IO	CHARG_O	MCH1	CHARG
3	ROIJ_EL_TICKET_I_IO	EVENTTYPE	OIJ_EL_EVT_TYPE	EVENTTYPE
4	ROIJ_EL_TICKET_I_IO	LGORT_D	T001L	LGORT
5	ROIJ_EL_TICKET_I_IO	LGORT_O	T001L	LGORT
6	ROIJ_EL_TICKET_I_IO	LOCID	OIJLOC	LOCID
7	ROIJ_EL_TICKET_I_IO	MANDT	T000	MANDT
8	ROIJ_EL_TICKET_I_IO	MATNR	MARA	MATNR
9	ROIJ_EL_TICKET_I_IO	MEINS	T006	MSEHI
10	ROIJ_EL_TICKET_I_IO	MTTEH	T006	MSEHI
11	ROIJ_EL_TICKET_I_IO	MVSCENARIO	TOIJ_EL_MVSCEN	MVSCENARIO
12	ROIJ_EL_TICKET_I_IO	NOMIT	OIJNOMI	NOMIT
13	ROIJ_EL_TICKET_I_IO	NOMTK	OIJNOMH	NOMTK
14	ROIJ_EL_TICKET_I_IO	SHTYPE	TOIGS	SHTYP
15	ROIJ_EL_TICKET_I_IO	SITYP	TOIJ_EL_SITYPES	SITYP
16	ROIJ_EL_TICKET_I_IO	TICKET_KEY	OIJ_EL_TICKET_H	TICKET_KEY
17	ROIJ_EL_TICKET_I_IO	TSTEH	T006	MSEHI
18	ROIJ_EL_TICKET_I_IO	VEHICLE	OIGV	VEHICLE
19	ROIJ_EL_TICKET_I_IO	VSTEL	TVST	VSTEL
20	ROIJ_EL_TICKET_I_IO	WERKS_D	T001W	WERKS
21	ROIJ_EL_TICKET_I_IO	WERKS_O	T001W	WERKS

History

Last changed by/on	SAP	20070914
SAP Release Created in	46C