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

History

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