OIJ_EL_TICKET_I - Universal ticket item table

Universal ticket item table information is stored in SAP table OIJ_EL_TICKET_I.
It is part of development package OIJ_EL in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Trader's and Scheduler's Workbench - Execution Layer".

Fields for table OIJ_EL_TICKET_I

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
TICKET_KEY	OIL-TSW: Ticket key	X	OIJ_EL_TKT_KEY	CHAR	40	OIJ_EL_TICKET_H
TICKET_ITEM	OIL-TSW: Ticket item number	X	OIJ_EL_TKT_POSNR	NUMC	12
TICKET_VERSION	OIL-TSW: Ticket version	X	OIJ_EL_TKT_VERSION	NUMC	6
TICKET_PURPOSE	OIL-TSW: Ticket Purpose	X	OIJ_EL_TKT_PURPOSE	CHAR	2
EXT_POSNR	External position number		OIJ_EL_EXT_POS	CHAR	12
STATUS	Nomination Item status		OIJ_ISTAT	CHAR	2
SUBSTATUS	Nomination Item sub-status		OIJ_SSTAT	CHAR	2
SITYP	Schedule type		OIJ_SITYP	CHAR	4	TOIJ_EL_SITYPES
TKTSUBRC	OIL-TSW: Ticket process return code		OIJ_TKTRC	CHAR	4
MVSCENARIO	TSW: Movement scenario number		OIJ_MVSCEN	NUMC	4	TOIJ_EL_MVSCEN
NOMNR	Nomination number		OIJ_NOMNR	CHAR	40
NOMTK	Nomination (technical) Key		OIJ_NOMTK	CHAR	40	OIJNOMH
NOMIT	Nomination Key Item		OIJ_ITEM	NUMC	20	OIJNOMI
RECEIVER	Location Partner		OIJ_PARTNR	CHAR	20
LOCID	Location ID		OIJ_LOCID	CHAR	20	OIJLOC
TANKNR	Sequence number of tank assigned to a business location		OIJ_BSEQNR	CHAR	20
VEHICLE	TD Vehicle Number		OIG_VHLNMR	CHAR	20	OIGV
MENGE	Scheduled qty		OIJ_MENGE	QUAN	7
GROSQUAN	Scheduled qty		OIJ_MENGE	QUAN	7
MEINS	Base Unit of Measure		MEINS	UNIT	6	T006
MATNR	Material Number		MATNR	CHAR	80	MARA
TANKAGE	Tankage Partner		OIJ_TANKAGE	CHAR	20
SUPPLIER	Location Partner		OIJ_PARTNR	CHAR	20
CONSIGNE	Consignee Partner		OIJ_CONSIGNEE	CHAR	20
AGREED_QTY	agreed qty. between ship. measr. and shore measrd. quants.		OIJ_AGGRDQTY	QUAN	7
AGREED_QTY_UOM	Loaded/Discharged Material UOM		OIJ_LDUOM	UNIT	6
SHIP_QTY	ship measured ld/disc. material quantity		OIJ_SHIPQTY	QUAN	7
SHIP_QTY_UOM	Loaded/Discharged Material UOM		OIJ_LDUOM	UNIT	6
.INCLUDE				OIJ_EL_QCI	0
MTTMP	Oil/Gas Material Temperature: Observed Quantity		OIB_MTTMP	FLTP	8
MTTEH	Oil/Gas Material Temperature Unit: Observed Quantity		OIB_MTTEH	UNIT	6	T006
O_API_GRAV	Oil/Gas Test Density		OIB_TDICH	FLTP	8
API_GRT_D	Oil/Gas Test Density		OIB_TDICH	FLTP	8
TSTMP	Oil/Gas Test Temperature: Observed Density		OIB_TSTMP	FLTP	8
TSTEH	Test Temperature Unit (Density): Measurement		OIB_TSTEH	UNIT	6	T006
TDICH	Oil/Gas Test Density		OIB_TDICH	FLTP	8
.INCLUDE				ROIJSTAT	0
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERZEIT	Time of creation		OI0_ERTIM	TIMS	12
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
AEDAT	Last Changed On		AEDAT	DATS	16
AEZEIT	Time of day the record was changed		OI0_AETIM	TIMS	12
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24
BLOIND	Blocking indicator		OIJ_BLOIND	CHAR	2
DELIND	Deletion indicator		OIJ_DELIND	CHAR	2
TKTSELECT	Flag to Set Tickets Selectable		OIJ_TKTSELECT	CHAR	2
BUDAT	Posting Date in the Document		BUDAT	DATS	16
CLOSE_NOMIT	IS OIL TSW: Indicator close nomination		OIJ_EL_CLOSE_NOMIT	CHAR	2
EVENTTYPE	TSW event date type		OIJ_EVENTTYPE	CHAR	32	OIJ_EL_EVT_TYPE
EVENT_DATE	OIL-TSW: Event date		OIJ_EVENT_DATE	DATS	16
.INCLUDE				ROIJMETER	0
GMMNR	GMM: Number of general meter		OII_GMMNR	CHAR	40	*
O_ITMSTM	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
O_METEV	GMM: History record type		OII_METEV	CHAR	4	*
C_ITMSTM	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TIMESTAMP	DEC	8
C_METEV	GMM: History record type		OII_METEV	CHAR	4	*
STOPRDG	GMM: End counter reading		OII_ENCOUN	NUMC	24
STM_QUANTITY	Stop meter calculation Quantity		OIJ_STM_QUANT	QUAN	7
STM_UOM	Stop meter calculation UOM		OIJ_STM_UOM	UNIT	6	*
.INCLUDE				ROIJGAUGE	0
SOCNR	SOC: Storage object characteristic segment number		OII_SOCNR	CHAR	40	*
O_DIP_READ	Open dip reading		OIJ_O_DIP_READ	QUAN	7
O_DIP_READ_UOM	Length UoM (Oil BDRP)		OII_LENUN	UNIT	6	*
O_ETMSTM	Tank dip time stamp		OIB_TMSTM	NUMC	28
O_SOCEV	Events in silo management tank dips		OIB_DIP_EVENTKEY	CHAR	4
C_DIP_READ	Close Dip reading		OIJ_C_DIP_READ	QUAN	7
C_DIP_READ_UOM	Length UoM (Oil BDRP)		OII_LENUN	UNIT	6	*
C_ETMSTM	Tank dip time stamp		OIB_TMSTM	NUMC	28
C_SOCEV	Events in silo management tank dips		OIB_DIP_EVENTKEY	CHAR	4
STOPDIP	Tank dip, total height		OII_TOTALHEIGHT	QUAN	7
STOPDIP_UOM	Length UoM (Oil BDRP)		OII_LENUN	UNIT	6	*
STP_GAU_QUAN	Stop gauge calculation - Quantity		OIJ_STG_QUAN	QUAN	7
STP_GAU_UOM	Stop gauge calculation UOM		OIJ_STG_UOM	UNIT	6	*
GAU_QUANTITY	Calculated Gauge Quantity		OIJ_GAU_QUAN	QUAN	7
GAU_UOM	Gauge Calculation UoM		OIJ_GAU_UOM	UNIT	6	*
SHTYPE	TD shipment type		OIG_TDSTYP	CHAR	8	TOIGS
VSTEL	Shipping Point / Receiving Point		VSTEL	CHAR	8	TVST
CHARG_O	Batch origin Location		OIJ_CHARGO	CHAR	20	MCH1
WERKS_O	Plant		WERKS_D	CHAR	8	T001W
LGORT_O	Storage location		LGORT_D	CHAR	8	T001L
CHARG_D	Batch destination Location		OIJ_CHARGD	CHAR	20	MCH1
WERKS_D	Plant		WERKS_D	CHAR	8	T001W
LGORT_D	Storage location		LGORT_D	CHAR	8	T001L
TIME_ST_LOAD_STA	Time at Which Data Was Created (Date and Time)		TMSTMP	CHAR	28
TIME_ST_LOAD_END	Time at Which Data Was Created (Date and Time)		TMSTMP	CHAR	28
TIME_ST_LED_OT	Time at Which Data Was Created (Date and Time)		TMSTMP	CHAR	28
CHARG_D_CREATE	Destination Batch create new flag		OIJ_CHARG_D_C	CHAR	2
OIB_BLTIME	Posting time in the document		OIB_BLTIME	TIMS	12
CHARG_L	Batch load		OIJ_CHARGL	CHAR	20
CHARG_L_CREATE	Load Batch create new flag		OIJ_CHARG_L_C	CHAR	2
SHTYP	Shipment type		SHTYP	CHAR	8	TVTK
.INCLUDE				ROIJ_TIC_CWM	0
MENGE_PAR	Scheduled Parallel quantity		OIJ_MENGE_PAR	QUAN	7
UNIT_I_PAR	Parallel Unit of measure		OIJ_UNIT_PAR	UNIT	6	*
.INCLUDE				ROIJTIC_RU_I	0
RAILCARQTY	Number of Railcars		OIJ_RU_RAILQTY	INT4	4
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16
.INCLUDE				TKTITM_INCL_EEW_PS	0
DUMMY_TKTITM_INCL_EEW_PS	Data Element for Extension Fields: Sample		OIJ07_EXTN	NUMC	20