OIJ_EL_TKT_I_O1 SAP table for – Appendix: TSW Ticket item – Conversion Parameters

Here we would like to draw your attention to OIJ_EL_TKT_I_O1 table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIJ_EL_TKT_I_O1 is a SAP standard transp table used for storing Appendix: TSW Ticket item – Conversion Parameters related data in SAP. It comes under the package OIJ.

SAP OIJ_EL_TKT_I_O1 table

Table OIJ_EL_TKT_I_O1 technical data

TableOIJ_EL_TKT_I_O1
Data storingAppendix: TSW Ticket item – Conversion Parameters
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJ_EL_TKT_I_O1 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIJ_EL_TKT_I_O1 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TICKET_KEY : OIL-TSW: Ticket key
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • TICKET_ITEM : OIL-TSW: Ticket item number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • TICKET_VERSION : OIL-TSW: Ticket version
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • TICKET_PURPOSE : OIL-TSW: Ticket Purpose
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Quantity conversion interface – base parameters
  • UMRSL : Conversion Group (Oil, Natural Gas,..)
    Its data type is CHAR (Character String) with field length 4
  • CMODE : Conversion Mode
    Its data type is CHAR (Character String) with field length 1
  • FDICHEH : Unit for densities at standard/base conditions
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • FDICH : Fixed Density
    Its data type is FLTP (Floating point number) with field length 16
  • COEFF : Quantity Conversion Coefficient
    Its data type is FLTP (Floating point number) with field length 16
  • BDICHEH : Unit for densities at standard/base conditions
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BDICH : Oil/gas density at standard/base conditions
    Its data type is FLTP (Floating point number) with field length 16
  • BHVALEH : Heating value unit at standard/base conditions (natural gas)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BHVAL : Heating value at standard/base conditions (natural gas)
    Its data type is FLTP (Floating point number) with field length 16
  • .INCLUDE : Quantity conversion interface – conversion parameters
  • TSTMP : Oil/Gas Test Temperature: Observed Density
    Its data type is FLTP (Floating point number) with field length 16
  • TSTEH : Test Temperature Unit (Density): Measurement
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MTTMP : Oil/Gas Material Temperature: Observed Quantity
    Its data type is FLTP (Floating point number) with field length 16
  • MTTEH : Oil/Gas Material Temperature Unit: Observed Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • THVAL : Heating value at test conditions (natural gas): observed
    Its data type is FLTP (Floating point number) with field length 16
  • TDICHEH : Unit for densities of petroleum products and natural gas
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TDICH : Oil/Gas Test Density
    Its data type is FLTP (Floating point number) with field length 16
  • MTPRES : Oil/gas material pressure: observed quantity
    Its data type is FLTP (Floating point number) with field length 16
  • MTPRESEH : Oil/gas material pressure unit: observed quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TPRED : Oil/gas test pressure: metering (obs. density)
    Its data type is FLTP (Floating point number) with field length 16
  • TPREDEH : Oil/Gas test press. unit: metering (density)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TPRHV : Natural gas test pressure: combustion (obs. heating value )
    Its data type is FLTP (Floating point number) with field length 16
  • TPRHVEH : Natural gas test pressure unit: combustion ( heating value )
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TTMPHV : Natural gas test temperature: combustion (obs. heat. value )
    Its data type is FLTP (Floating point number) with field length 16
  • TTMPHVEH : Natural gas test temp. unit: combustion (heating value)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ATPRES : Atmospheric pressure of the air surrounding a product
    Its data type is FLTP (Floating point number) with field length 16
  • ATPRESEH : Atmospheric pressure unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • VAPRES : Vapor pressure of liquid petroleum gases (LPG)
    Its data type is FLTP (Floating point number) with field length 16
  • VAPRESEH : Vapor pressure unit (LPG)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • THVALEH : Heating value unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MTCOMBTMP : Natural gas material combustion temp.: observed quantity
    Its data type is FLTP (Floating point number) with field length 16
  • MTCOMBTEH : Natural gas material combustion temp. unit: obs. quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MTCOMBPRES : Natural gas material combustion pressure: observed quantity
    Its data type is FLTP (Floating point number) with field length 16
  • MTCOMBPRESEH : Natural gas material combustion pres. unit: oberved quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TSTMPCAL : Natural gas: Calorimeter test temperature (density)
    Its data type is FLTP (Floating point number) with field length 16
  • TSTMPCALEH : Natural gas: unit for calorimeter test temperature (density)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TPREDCAL : Natural gas: Calorimeter test pressure (density)
    Its data type is FLTP (Floating point number) with field length 16
  • TPREDCALEH : Natural gas: Unit for calorimeter test pressure (density)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Quantity conversion interface – other parts
  • HYDRO : Hydrometer Correction Indicator
    Its data type is CHAR (Character String) with field length 1
  • ABIND : Air Bouyancy Indicator
    Its data type is CHAR (Character String) with field length 1
  • ABFAC : Air Bouyancy Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • MCF : Meter correction factor
    Its data type is FLTP (Floating point number) with field length 16
  • BSWCN : BSW %
    Its data type is FLTP (Floating point number) with field length 16
  • BSWCNEH : BSW % unit (volume %, mol %, mass % or proportion )
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • HVCLS : Heating value class (calorific value class)
    Its data type is CHAR (Character String) with field length 2
  • HVCLS_TO : Heating value class (calorific value class)
    Its data type is CHAR (Character String) with field length 2
  • DEFAULT_GUID : GUID in ‘CHAR’ Format in Uppercase
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : HPM:QCI:chemical analysis data for natural gas (ISO comp.)
  • CH4RATIO : Natural gas CH4 content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • N2RATIO : Natural gas N2 (nitrogen) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • CO2RATIO : Natural gas CO2 content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • C2H6RATIO : Natural gas C2H6 (ethane) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • C3H8RATIO : Natural gas C3H8 (propane) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • H2ORATIO : Natural gas H2O content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • H2SRATIO : Natural gas H2S content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • H2RATIO : Natural gas H2 (Hydrogen) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • CORATIO : Natural gas CO content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • O2RATIO : Natural gas oxygen (O2) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • ISOC4H10RATIO : Natural gas ISO-C4H10 (iso-butane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • NC4H10RATIO : Natural gas n-C4H10 (n-butane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • ISOC5H12RATIO : Natural gas ISO-C5H12 (ISO-pentane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • NC5H12RATIO : Natural gas n-C5H12 (n-pentane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • C6H14RATIO : Natural gas C6H14 (n-hexane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • C7H16RATIO : Natural gas C7H16 (n-heptane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • C8H18RATIO : Natural gas C8H18 (n-octane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • C9H20RATIO : Natural gas C9H20 (n-Nonane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • C10H22RATIO : Natural gas C10H22 (n-Decane ) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • HERATIO : Natural gas He (Helium) content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • ARRATIO : Natural gas Argon content (ratio)
    Its data type is FLTP (Floating point number) with field length 16
  • GASCOMPRATEH : Unit (vol. %, mol % or mass % ) of natural gas composition
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MOLDEN : Natural gas molar density (mol/volume) at standard condition
    Its data type is FLTP (Floating point number) with field length 16
  • MOLDENEH : Unit for molar density at base conditions ( nat.gas)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MOLWEIGHT : Molecular weight of natural gas:return value from AGA c-code
    Its data type is FLTP (Floating point number) with field length 16
  • HYDROCARBMOLFRAC : Hydrocarbon mole fraction calculated from AGA c-code
    Its data type is FLTP (Floating point number) with field length 16
  • MOLWEIGHTEH : Unit for molar mass
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Strcuture for QCI parameters: customer defined fields
  • CUSTPARCHAR1 : Customer parameter character field 1
    Its data type is CHAR (Character String) with field length 3
  • CUSTPARFLOAT1 : Customer parameter float 1
    Its data type is FLTP (Floating point number) with field length 16
  • CUSTEH1 : Customer parameter 1 unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CUSTPARCHAR2 : Customer parameter character field 2
    Its data type is CHAR (Character String) with field length 3
  • CUSTPARFLOAT2 : Customer parameter float 2
    Its data type is FLTP (Floating point number) with field length 16
  • CUSTEH2 : Customer parameter 2 unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CUSTPARCHAR3 : Customer parameter character field 3
    Its data type is CHAR (Character String) with field length 3
  • CUSTPARFLOAT3 : Customer parameter float 3
    Its data type is FLTP (Floating point number) with field length 16
  • CUSTEH3 : Customer parameter 3 unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3