SAP ABAP Table OIJ_EL_TKT_I_O1 (Appendix: TSW Ticket item - Conversion Parameters)

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	TRANSP	Transparent table
Transparent table	OIJ_EL_TKT_I_O1	Table Relationship Diagram
Short Description	Appendix: TSW Ticket item - Conversion Parameters

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	OIJ_EL_TICKET_H
3	TICKET_ITEM	☑	OIJ_EL_TKT_POSNR	OIJ_EL_TKT_POSNR	NUMC	6	0	OIL-TSW: Ticket item number
4	TICKET_VERSION	☑	OIJ_EL_TKT_VERSION	OIJ_EL_TKT_VERSION	NUMC	3	0	OIL-TSW: Ticket version
5	TICKET_PURPOSE	☑	OIJ_EL_TKT_PURPOSE	OIJ_EL_TKT_PURPOSE	CHAR	1	0	OIL-TSW: Ticket Purpose
6	.INCLUDE	☐				0	0	Quantity conversion interface - base parameters
7	UMRSL	☐	OIB_UMRSL	OIB_UMRSL	CHAR	4	0	Conversion Group (Oil, Natural Gas,..)	OIB01
8	CMODE	☐	OIB_CMODE	OIB_CMODE	CHAR	1	0	Conversion Mode
9	FDICHEH	☐	OIB_BDNEH	MEINS	UNIT	3	0	Unit for densities at standard/base conditions	T006
10	FDICH	☐	OIB_FDICH	OIB_DICHT	FLTP	16	16	Fixed Density
11	COEFF	☐	OIB_COEFF	OIB_COEFF	FLTP	16	16	Quantity Conversion Coefficient
12	BDICHEH	☐	OIB_BDNEH	MEINS	UNIT	3	0	Unit for densities at standard/base conditions	T006
13	BDICH	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
14	BHVALEH	☐	OIB_BHVEH	MEINS	UNIT	3	0	Heating value unit at standard/base conditions (natural gas)	T006
15	BHVAL	☐	OIB_BHVAL	OIB_HVAL	FLTP	16	16	Heating value at standard/base conditions (natural gas)
16	.INCLUDE	☐				0	0	Quantity conversion interface - conversion parameters
17	TSTMP	☐	OIB_TSTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Test Temperature: Observed Density
18	TSTEH	☐	OIB_TSTEH	MEINS	UNIT	3	0	Test Temperature Unit (Density): Measurement	T006
19	MTTMP	☐	OIB_MTTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Material Temperature: Observed Quantity
20	MTTEH	☐	OIB_MTTEH	MEINS	UNIT	3	0	Oil/Gas Material Temperature Unit: Observed Quantity	T006
21	THVAL	☐	OIB_THVAL	OIB_HVAL	FLTP	16	16	Heating value at test conditions (natural gas): observed
22	TDICHEH	☐	OIB_DNEH	MEINS	UNIT	3	0	Unit for densities of petroleum products and natural gas	T006
23	TDICH	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
24	MTPRES	☐	OIB_MTPRES	OIB_PRES	FLTP	16	16	Oil/gas material pressure: observed quantity
25	MTPRESEH	☐	OIB_MTPRESEH	MEINS	UNIT	3	0	Oil/gas material pressure unit: observed quantity	T006
26	TPRED	☐	OIB_TPRED	OIB_PRES	FLTP	16	16	Oil/gas test pressure: metering (obs. density)
27	TPREDEH	☐	OIB_TPREDEH	MEINS	UNIT	3	0	Oil/Gas test press. unit: metering (density)	T006
28	TPRHV	☐	OIB_TPRHV	OIB_PRES	FLTP	16	16	Natural gas test pressure: combustion (obs. heating value )
29	TPRHVEH	☐	OIB_TPRHVEH	MEINS	UNIT	3	0	Natural gas test pressure unit: combustion ( heating value )	T006
30	TTMPHV	☐	OIB_TTMPHV	TEMP_VALUE	FLTP	16	16	Natural gas test temperature: combustion (obs. heat. value )
31	TTMPHVEH	☐	OIB_TTMPHVEH	MEINS	UNIT	3	0	Natural gas test temp. unit: combustion (heating value)	T006
32	ATPRES	☐	OIB_ATPRES	OIB_PRES	FLTP	16	16	Atmospheric pressure of the air surrounding a product
33	ATPRESEH	☐	OIB_ATPRESEH	MEINS	UNIT	3	0	Atmospheric pressure unit	T006
34	VAPRES	☐	OIB_VAPRES	OIB_PRES	FLTP	16	16	Vapor pressure of liquid petroleum gases (LPG)
35	VAPRESEH	☐	OIB_VAPRESEH	MEINS	UNIT	3	0	Vapor pressure unit (LPG)	T006
36	THVALEH	☐	OIB_HVEH	MEINS	UNIT	3	0	Heating value unit	T006
37	MTCOMBTMP	☐	OIB_MTCOMBTMP	TEMP_VALUE	FLTP	16	16	Natural gas material combustion temp.: observed quantity
38	MTCOMBTEH	☐	OIB_MTCOMBTEH	MEINS	UNIT	3	0	Natural gas material combustion temp. unit: obs. quantity	T006
39	MTCOMBPRES	☐	OIB_MTCOMBPRES	OIB_PRES	FLTP	16	16	Natural gas material combustion pressure: observed quantity
40	MTCOMBPRESEH	☐	OIB_MTCOMBPRESEH	MEINS	UNIT	3	0	Natural gas material combustion pres. unit: oberved quantity	T006
41	TSTMPCAL	☐	OIB_TSTMPCAL	TEMP_VALUE	FLTP	16	16	Natural gas: Calorimeter test temperature (density)
42	TSTMPCALEH	☐	OIB_TSTMPCALEH	MEINS	UNIT	3	0	Natural gas: unit for calorimeter test temperature (density)	T006
43	TPREDCAL	☐	OIB_TPREDCAL	OIB_PRES	FLTP	16	16	Natural gas: Calorimeter test pressure (density)
44	TPREDCALEH	☐	OIB_TPREDCALEH	MEINS	UNIT	3	0	Natural gas: Unit for calorimeter test pressure (density)	T006
45	.INCLUDE	☐				0	0	Quantity conversion interface - other parts
46	HYDRO	☐	OIB_HYDRO	OIB_XFELD	CHAR	1	0	Hydrometer Correction Indicator
47	ABIND	☐	OIB_ABIND	OIB_XFELD	CHAR	1	0	Air Bouyancy Indicator
48	ABFAC	☐	OIB_ABFAC	OIB_ABFAC	DEC	3	1	Air Bouyancy Factor
49	MCF	☐	OIB_MCF1	OIB_VCF	FLTP	16	16	Meter correction factor
50	BSWCN	☐	OIB_BSWCN	OIB_BSWCN	FLTP	16	16	BSW %
51	BSWCNEH	☐	OIB_BSWCNEH	MEINS	UNIT	3	0	BSW % unit (volume %, mol %, mass % or proportion )	T006
52	HVCLS	☐	OIB_HVCLS	OIB_HVCLS	CHAR	2	0	Heating value class (calorific value class)
53	HVCLS_TO	☐	OIB_HVCLS	OIB_HVCLS	CHAR	2	0	Heating value class (calorific value class)
54	DEFAULT_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
55	.INCLUDE	☐				0	0	HPM:QCI:chemical analysis data for natural gas (ISO comp.)
56	CH4RATIO	☐	OIB_CH4RAT	OIB_RAT	FLTP	16	16	Natural gas CH4 content (ratio)
57	N2RATIO	☐	OIB_N2RAT	OIB_RAT	FLTP	16	16	Natural gas N2 (nitrogen) content (ratio)
58	CO2RATIO	☐	OIB_CO2RAT	OIB_RAT	FLTP	16	16	Natural gas CO2 content (ratio)
59	C2H6RATIO	☐	OIB_C2H6RAT	OIB_RAT	FLTP	16	16	Natural gas C2H6 (ethane) content (ratio)
60	C3H8RATIO	☐	OIB_C3H8RAT	OIB_RAT	FLTP	16	16	Natural gas C3H8 (propane) content (ratio)
61	H2ORATIO	☐	OIB_H2ORAT	OIB_RAT	FLTP	16	16	Natural gas H2O content (ratio)
62	H2SRATIO	☐	OIB_H2SRAT	OIB_RAT	FLTP	16	16	Natural gas H2S content (ratio)
63	H2RATIO	☐	OIB_H2RAT	OIB_RAT	FLTP	16	16	Natural gas H2 (Hydrogen) content (ratio)
64	CORATIO	☐	OIB_CORAT	OIB_RAT	FLTP	16	16	Natural gas CO content (ratio)
65	O2RATIO	☐	OIB_O2RAT	OIB_RAT	FLTP	16	16	Natural gas oxygen (O2) content (ratio)
66	ISOC4H10RATIO	☐	OIB_ISOC4H10RAT	OIB_RAT	FLTP	16	16	Natural gas ISO-C4H10 (iso-butane ) content (ratio)
67	NC4H10RATIO	☐	OIB_NC4H10RAT	OIB_RAT	FLTP	16	16	Natural gas n-C4H10 (n-butane ) content (ratio)
68	ISOC5H12RATIO	☐	OIB_ISOC5H12RAT	OIB_RAT	FLTP	16	16	Natural gas ISO-C5H12 (ISO-pentane ) content (ratio)
69	NC5H12RATIO	☐	OIB_NC5H12RAT	OIB_RAT	FLTP	16	16	Natural gas n-C5H12 (n-pentane ) content (ratio)
70	C6H14RATIO	☐	OIB_C6H14RAT	OIB_RAT	FLTP	16	16	Natural gas C6H14 (n-hexane ) content (ratio)
71	C7H16RATIO	☐	OIB_C7H16RAT	OIB_RAT	FLTP	16	16	Natural gas C7H16 (n-heptane ) content (ratio)
72	C8H18RATIO	☐	OIB_C8H18RAT	OIB_RAT	FLTP	16	16	Natural gas C8H18 (n-octane ) content (ratio)
73	C9H20RATIO	☐	OIB_C9H20RAT	OIB_RAT	FLTP	16	16	Natural gas C9H20 (n-Nonane ) content (ratio)
74	C10H22RATIO	☐	OIB_C10H22RAT	OIB_RAT	FLTP	16	16	Natural gas C10H22 (n-Decane ) content (ratio)
75	HERATIO	☐	OIB_HERAT	OIB_RAT	FLTP	16	16	Natural gas He (Helium) content (ratio)
76	ARRATIO	☐	OIB_ARRAT	OIB_RAT	FLTP	16	16	Natural gas Argon content (ratio)
77	GASCOMPRATEH	☐	OIB_GASCOMPRATEH	MEINS	UNIT	3	0	Unit (vol. %, mol % or mass % ) of natural gas composition	T006
78	MOLDEN	☐	OIB_MOLDEN	OIB_DICHT	FLTP	16	16	Natural gas molar density (mol/volume) at standard condition
79	MOLDENEH	☐	OIB_MOLDENEH	MEINS	UNIT	3	0	Unit for molar density at base conditions ( nat.gas)	T006
80	MOLWEIGHT	☐	OIB_MOLWEIGHT	OIB_MOLWEIGHT	FLTP	16	16	Molecular weight of natural gas:return value from AGA c-code
81	HYDROCARBMOLFRAC	☐	OIB_HYDROCARBMOLFRAC	OIB_FRAC	FLTP	16	16	Hydrocarbon mole fraction calculated from AGA c-code
82	MOLWEIGHTEH	☐	OIB_MOLWEIGHTEH	MEINS	UNIT	3	0	Unit for molar mass	T006
83	.INCLUDE	☐				0	0	Strcuture for QCI parameters: customer defined fields
84	CUSTPARCHAR1	☐	OIB_CUSTPARCHAR1	OIB_CUSTPARCHAR	CHAR	3	0	Customer parameter character field 1
85	CUSTPARFLOAT1	☐	OIB_CUSTPARFLOAT1	OIB_CUSTPARFLO	FLTP	16	16	Customer parameter float 1
86	CUSTEH1	☐	OIB_CUSTEH1	MEINS	UNIT	3	0	Customer parameter 1 unit	T006
87	CUSTPARCHAR2	☐	OIB_CUSTPARCHAR2	OIB_CUSTPARCHAR	CHAR	3	0	Customer parameter character field 2
88	CUSTPARFLOAT2	☐	OIB_CUSTPARFLOAT2	OIB_CUSTPARFLO	FLTP	16	16	Customer parameter float 2
89	CUSTEH2	☐	OIB_CUSTEH2	MEINS	UNIT	3	0	Customer parameter 2 unit	T006
90	CUSTPARCHAR3	☐	OIB_CUSTPARCHAR3	OIB_CUSTPARCHAR	CHAR	3	0	Customer parameter character field 3
91	CUSTPARFLOAT3	☐	OIB_CUSTPARFLOAT3	OIB_CUSTPARFLO	FLTP	16	16	Customer parameter float 3
92	CUSTEH3	☐	OIB_CUSTEH3	MEINS	UNIT	3	0	Customer parameter 3 unit	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJ_EL_TKT_I_O1	ATPRESEH	T006	MSEHI
2	OIJ_EL_TKT_I_O1	BDICHEH	T006	MSEHI
3	OIJ_EL_TKT_I_O1	BHVALEH	T006	MSEHI
4	OIJ_EL_TKT_I_O1	BSWCNEH	T006	MSEHI
5	OIJ_EL_TKT_I_O1	CUSTEH1	T006	MSEHI
6	OIJ_EL_TKT_I_O1	CUSTEH2	T006	MSEHI
7	OIJ_EL_TKT_I_O1	CUSTEH3	T006	MSEHI
8	OIJ_EL_TKT_I_O1	FDICHEH	T006	MSEHI
9	OIJ_EL_TKT_I_O1	GASCOMPRATEH	T006	MSEHI
10	OIJ_EL_TKT_I_O1	MANDT	T000	MANDT
11	OIJ_EL_TKT_I_O1	MOLDENEH	T006	MSEHI
12	OIJ_EL_TKT_I_O1	MOLWEIGHTEH	T006	MSEHI
13	OIJ_EL_TKT_I_O1	MTCOMBPRESEH	T006	MSEHI
14	OIJ_EL_TKT_I_O1	MTCOMBTEH	T006	MSEHI
15	OIJ_EL_TKT_I_O1	MTPRESEH	T006	MSEHI
16	OIJ_EL_TKT_I_O1	MTTEH	T006	MSEHI
17	OIJ_EL_TKT_I_O1	TDICHEH	T006	MSEHI
18	OIJ_EL_TKT_I_O1	THVALEH	T006	MSEHI
19	OIJ_EL_TKT_I_O1	TICKET_KEY	OIJ_EL_TICKET_H	TICKET_KEY
20	OIJ_EL_TKT_I_O1	TPREDCALEH	T006	MSEHI
21	OIJ_EL_TKT_I_O1	TPREDEH	T006	MSEHI
22	OIJ_EL_TKT_I_O1	TPRHVEH	T006	MSEHI
23	OIJ_EL_TKT_I_O1	TSTEH	T006	MSEHI
24	OIJ_EL_TKT_I_O1	TSTMPCALEH	T006	MSEHI
25	OIJ_EL_TKT_I_O1	TTMPHVEH	T006	MSEHI
26	OIJ_EL_TKT_I_O1	UMRSL	OIB01	UMRSL
27	OIJ_EL_TKT_I_O1	VAPRESEH	T006	MSEHI

History

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