SAP ABAP Table OIJ_EL_TICKET_I (Universal ticket item table)

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	TRANSP	Transparent table
Transparent table	OIJ_EL_TICKET_I	Table Relationship Diagram
Short Description	Universal ticket item table

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20070914
SAP Release Created in