SAP ABAP Table ROIJ_EL_TICKET_DISP (OIL-TSW : Ticket display structure)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	ROIJ_EL_TICKET_DISP	Table Relationship Diagram
Short Description	OIL-TSW : Ticket display 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	OIJ_TICKET_ICON	☐	OIJ_TICKET_ICON_D	ICON	CHAR	4	0	Icon for Ticket status	*
2	.INCLUDE	☐				0	0	Universal ticket 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
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	TICKET_TYPE	☐	OIJ_EL_TKT_TYPE	OIJ_EL_TKT_TYPE	CHAR	3	0	OIL-TSW: Ticket type	TOIJ_TKT_TYPE
8	TICKETNR	☐	OIJ_TKTNR	OIJ_TKTNR	CHAR	20	0	OIL-TSW: External ticket number	*
9	TKTSUBRC	☐	OIJ_TKTRC	OIJ_TKTRC	CHAR	2	0	OIL-TSW: Ticket process return code
10	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
11	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
12	IDOC_NUM	☐	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	0	IDoc number
13	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
14	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
15	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
16	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
17	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
18	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
19	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
21	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
22	CARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	*
23	CONSIGNE	☐	OIJ_CONSIGNEE	OIJ_PARTNR	CHAR	10	0	Consignee Partner
24	INSPECTOR	☐	OIJ_INSPECTOR	OIJ_PARTNR	CHAR	10	0	Inspector
25	SHIPPER	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	*
26	SUPPLIER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
27	TRADER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
28	TICKET_ITEM	☐	OIJ_EL_TKT_POSNR	OIJ_EL_TKT_POSNR	NUMC	6	0	OIL-TSW: Ticket item number
29	EXT_POSNR	☐	OIJ_EL_EXT_POS	CHAR6	CHAR	6	0	External position number
30	STATUS	☐	OIJ_ISTAT	OIJ_ISTAT	CHAR	1	0	Nomination Item status	*
31	SUBSTATUS	☐	OIJ_SSTAT	OIJ_SSTAT	CHAR	1	0	Nomination Item sub-status	*
32	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type
33	MVSCENARIO	☐	OIJ_MVSCEN	NUM02	NUMC	2	0	TSW: Movement scenario number
34	NOMNR	☐	OIJ_NOMNR	OIJ_NOMNR	CHAR	20	0	Nomination number
35	NOMTK	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	OIJNOMH
36	NOMIT	☐	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	OIJNOMI
37	RECEIVER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
38	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
39	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
40	MENGE	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
41	GROSQUAN	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
42	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
43	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
44	TANKAGE	☐	OIJ_TANKAGE	OIJ_PARTNR	CHAR	10	0	Tankage Partner
45	.INCLUDE	☐				0	0	OIL-TSW: Data for QCI
46	MTTMP	☐	OIB_MTTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Material Temperature: Observed Quantity
47	MTTEH	☐	OIB_MTTEH	MEINS	UNIT	3	0	Oil/Gas Material Temperature Unit: Observed Quantity	T006
48	O_API_GRAV	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
49	API_GRT_D	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
50	TSTMP	☐	OIB_TSTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Test Temperature: Observed Density
51	TSTEH	☐	OIB_TSTEH	MEINS	UNIT	3	0	Test Temperature Unit (Density): Measurement	T006
52	TDICH	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
53	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
54	CLOSE_NOMIT	☐	OIJ_EL_CLOSE_NOMIT	OIJ_EL_CLOSE_NOMIT	CHAR	1	0	IS OIL TSW: Indicator close nomination
55	EVENTTYPE	☐	OIJ_EVENTTYPE	OIJ_EVENTTYPE	CHAR	16	0	TSW event date type
56	EVENT_DATE	☐	OIJ_EVENT_DATE	DATUM	DATS	8	0	OIL-TSW: Event date
57	SHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	*
58	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
59	CHARG_O	☐	OIJ_CHARGO	CHARG	CHAR	10	0	Batch origin Location	*
60	WERKS_O	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
61	LGORT_O	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
62	CHARG_D	☐	OIJ_CHARGD	CHARG	CHAR	10	0	Batch destination Location	*
63	WERKS_D	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
64	LGORT_D	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
65	TIME_ST_LOAD_STA	☐	TMSTMP	CHAR14	CHAR	14	0	Time at which data was created (date and time)
66	TIME_ST_LOAD_END	☐	TMSTMP	CHAR14	CHAR	14	0	Time at which data was created (date and time)
67	TIME_ST_LED_OT	☐	TMSTMP	CHAR14	CHAR	14	0	Time at which data was created (date and time)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_EL_TICKET_DISP	LOCID	OIJLOC	LOCID
2	ROIJ_EL_TICKET_DISP	MANDT	T000	MANDT
3	ROIJ_EL_TICKET_DISP	MATNR	MARA	MATNR
4	ROIJ_EL_TICKET_DISP	MEINS	T006	MSEHI
5	ROIJ_EL_TICKET_DISP	MTTEH	T006	MSEHI
6	ROIJ_EL_TICKET_DISP	NOMIT	OIJNOMI	NOMIT
7	ROIJ_EL_TICKET_DISP	NOMTK	OIJNOMH	NOMTK
8	ROIJ_EL_TICKET_DISP	TICKET_TYPE	TOIJ_TKT_TYPE	TKT_TYPE
9	ROIJ_EL_TICKET_DISP	TPLST	TTDS	TPLST
10	ROIJ_EL_TICKET_DISP	TSTEH	T006	MSEHI
11	ROIJ_EL_TICKET_DISP	TSYST	OIJTS	TSYST
12	ROIJ_EL_TICKET_DISP	VEHICLE	OIGV	VEHICLE

History

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