SAP ABAP Table ROIJ_EL_TICKET_I (IS-OIL TSW: Structure ticket item)

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	Table Relationship Diagram
Short Description	IS-OIL TSW: Structure ticket item

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

Foreign Keys

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

History

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