SAP ABAP Table OIJ_EL_TICKET_H (Universal ticket 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_H	Table Relationship Diagram
Short Description	Universal ticket 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
3	TICKET_VERSION	☑	OIJ_EL_TKT_VERSION	OIJ_EL_TKT_VERSION	NUMC	3	0	OIL-TSW: Ticket version
4	TICKET_PURPOSE	☑	OIJ_EL_TKT_PURPOSE	OIJ_EL_TKT_PURPOSE	CHAR	1	0	OIL-TSW: Ticket Purpose
5	TICKET_TYPE	☐	OIJ_EL_TKT_TYPE	OIJ_EL_TKT_TYPE	CHAR	3	0	OIL-TSW: Ticket type	TOIJ_TKT_TYPE
6	TICKETNR	☐	OIJ_TKTNR	OIJ_TKTNR	CHAR	20	0	OIL-TSW: External ticket number	*
7	TKTSUBRC	☐	OIJ_TKTRC	OIJ_TKTRC	CHAR	2	0	OIL-TSW: Ticket process return code
8	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
9	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
10	IDOC_NUM	☐	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	0	IDoc number
11	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
14	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
17	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
18	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
19	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
20	CARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	*
21	CONSIGNE	☐	OIJ_CONSIGNEE	OIJ_PARTNR	CHAR	10	0	Consignee Partner
22	INSPECTOR	☐	OIJ_INSPECTOR	OIJ_PARTNR	CHAR	10	0	Inspector
23	SHIPPER	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	*
24	SUPPLIER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
25	TRADER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJ_EL_TICKET_H	MANDT	T000	MANDT
2	OIJ_EL_TICKET_H	TICKET_TYPE	TOIJ_TKT_TYPE	TKT_TYPE
3	OIJ_EL_TICKET_H	TPLST	TTDS	TPLST
4	OIJ_EL_TICKET_H	TSYST	OIJTS	TSYST

History

Last changed by/on	SAP	20050224
SAP Release Created in