SAP ABAP Table E3OILU1 (OIL-TSW Carrier Ticket Information)

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	E3OILU1	Table Relationship Diagram
Short Description	OIL-TSW Carrier Ticket Information

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	NOMNR	☐	OIJ_NOMNR	OIJ_NOMNR	CHAR	20	0	Nomination number
2	MONTK	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	*
3	NOMIT	☐	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	*
4	TICKETNR	☐	OIJ_TKTNR	OIJ_TKTNR	CHAR	20	0	OIL-TSW: External ticket number	*
5	TICKETTYPE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
6	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
7	RTYPE	☐	OIJ_RTYPE	OIJ_RTYPE	CHAR	6	0	OIL-TSW: Role type	*
8	TKT_YEAR	☐	JAHR	GJAHR	NUMC	4	0	Year for which levy is to be carried out
9	TKT_MONTH	☐	OIJ_MONTH	AM_MONAT	NUMC	2	0	Calendar month
10	VERSION	☐	OIJ_TKTNR	OIJ_TKTNR	CHAR	20	0	OIL-TSW: External ticket number	*
11	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	*
12	LOCNAM	☐	OIJ_LOCNAM	OIJ_LOCNAM	CHAR	60	0	Location name (used by system owner)
13	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	*
14	TSNAM	☐	OIJ_TSNAM	OIJ_TSNAM	CHAR	60	0	OIL-TSW: Transport system name
15	CARRIER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
16	SHIPPER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
17	SUPPLIER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
18	CONSIGNE	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
19	RECEIVER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
20	CARRNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
21	SHIPPNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
22	SUPPNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
23	CONSINAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
24	RECNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
25	NETQUANT	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
26	UOM	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
27	MATNR_I	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
28	START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
29	START_TIME	☐	TIME	CHAR6	CHAR	6	0	Time in CHAR Format
30	END_DATE	☐	DATUM	DATUM	DATS	8	0	Date
31	END_TIME	☐	TIME	CHAR6	CHAR	6	0	Time in CHAR Format
32	O_API_GRAV	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
33	API_GRT_D	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
34	TSTMP	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
35	TSTEH	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
36	DIS_MET_F	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
37	COM_COR_F	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
38	VOL_WATER	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
39	AVG_PR_PSI	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
40	PRS_COR_F	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
41	OBS_TEMP	☐	OIJ_CHAR23	CHAR23	CHAR	23	0	OIL overall: Character field of 23 length
42	AVG_TEMP	☐	OIJ_CHAR23	CHAR23	CHAR	23	0	OIL overall: Character field of 23 length
43	MTTEH	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
44	TMP_COR_F	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
45	METER_FAC1	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
46	DIST_FAC1	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
47	METER_FAC2	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
48	DIST_FAC2	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
49	METER_FAC3	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
50	DIST_FAC3	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
51	METER_FAC4	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
52	DIST_FAC4	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
53	GROSS_QTY	☐	CHAR17	CHAR17	CHAR	17	0	17-Char. Field
54	SHIPTONAME	☐	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
55	TANKAGE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
56	TANK_CODE	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
57	METER_NBR1	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
58	PROVERRPT1	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
59	METER_NBR2	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
60	PROVERRPT2	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
61	METER_NBR3	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
62	PROVERRPT3	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
63	METER_NBR4	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
64	PROVERRPT4	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
65	TY_CODE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
66	TARIFF_NBR	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
67	METER_NBR	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
68	METER_FAC	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
69	BEGIN_READ	☐	TIME	CHAR6	CHAR	6	0	Time in CHAR Format
70	END_READ	☐	TIME	CHAR6	CHAR	6	0	Time in CHAR Format

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	E3OILU1	SITYP	TOIJ_EL_SITYPES	SITYP

History

Last changed by/on	SAP	20130529
SAP Release Created in