SAP table OIB01 (Definition of Conversion Groups)

SAP table OIB01 has 2 primary key fields being MANDT,UMRSL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
UMRSL Conversion Group (Oil, Natural Gas,..) CHAR 4 0 OIB_UMRSL
PDTYP Oil product type CHAR 1 0 OIB_PDTYP
1 Crude Oil (Before Processing)
2 Oil products (gasoline, diesel, etc.)
3 Chemicals
4 Lubes
5 Asphalt/Bitumen
6 Natural Gas (gaseous)
7 Liquefied Natural Gas (LNG)
8 Liquid petroleum gas (LPG/NGL)
9 Condensate
A Water
B General Gases (Pure, Inert)
I Industrial Aromatic Hydrocarbons
R Raw materials
X User defined
Y User defined
Z User defined
BSTMP Oil/gas standard/base temperature FLTP 16 16 OIB_BSTMP
BSTEH Oil/gas standard/base temperature unit UNIT 3 0 T006 OIB_BSTEH
WQTYL Lower warning tolerance limit for manual entries (in %) FLTP 16 16 OIB_WQTYL
WQTYH Upper warning tolerance limit for manual entries (in %) FLTP 16 16 OIB_WQTYH
EQTYL Lower Tolerance Limit for Manual Quantity Entries (in %) FLTP 16 16 OIB_EQTYL
EQTYH Upper Tolerance Limit for Manual Quantity Entries (in %) FLTP 16 16 OIB_EQTYH
DNTYP Density Type CHAR 1 0 OIB_DNTYP
1 API Gravity, Liquids
2 Relative Density (relative to water at standard conditions)
3 Density (absolute)
4 Relative Density (relative to air at standard conditions)
VCFLN Volume correction factor CHAR 1 0 OIB_VCFLN
1 First Volume Correction Factor (5 decimal places)
2 Second Volume Correction Factor (4 decimal places)
MCFI Meter correction factor indicator CHAR 1 0 OIB_MCFI
PDCL Oil/Gas product conversion class CHAR 2 0 OIB_PDCL
01 SAP standard delivered conversion
02 SAP E&P specific formulas
03 Customer specific 01
04 Customer specific 02
HVTYP Heating value type CHAR 2 0 OIB_HVTYP
01 Energy / Volume
02 Energy / Mass
03 Energy / Mol
BPRESH Natural Gas Base Pressure for Combustion (Heating Value) FLTP 16 16 OIB_BPRESH
BPRESHEH Natural gas std/base press.: combustion (heat. value): unit UNIT 3 0 T006 OIB_BPRESHEH
BSTMPH Natural Gas Base Temperature of Combustion (Heating Value) FLTP 16 16 OIB_BSTMPH
BSTMPHEH Natural gas std/base temp.: combustion (heat. value): unit UNIT 3 0 T006 OIB_BSTMPHEH
EXT_PROG_VERSION Supported version of external routines CHAR 1 0 OIB_EXT_VERSION
AGA and API 1980 - 2004
1 API 1250-04
BPRESV Oil/gas standard/base pressure:metering (volume, density) FLTP 16 16 OIB_BPRESV
BPRESVEH Oil/gas standard/base pres.:metering (volume, density): unit UNIT 3 0 T006 OIB_BPRESVEH
BTMPVP Oil/gas standard/base temperature (vapor pressure) FLTP 16 16 OIB_BTMPVP
BTMPVPEH Oil/gas standard/base temperature unit (vapor pressure) UNIT 3 0 T006 OIB_BTMPVPEH
CHGS Conversion handling for gases CHAR 1 0 OIB_CHGS
external routines are not called
1 call AGA routines, use gross method 1
2 call AGA routines, use gross method 2
3 call AGA routines, use detail method, using 21 comp. an.
4 use customer specific function
5 call AGA routines, use gross method 1 , no 2nd external call
6 call AGA routines, use gross method 2, no 2nd external call
7 call AGA routines, use detail method, no 2nd external call
8 use customer specific function, no 2nd external call
CHLQ Conversion handling for liquid products CHAR 1 0 OIB_CHLQ
call external routines
1 external routines are not called
EXTDNUNIT Unit for densities of petroleum products and natural gas UNIT 3 0 T006 OIB_DNEH
EXTHVUNIT Heating value unit UNIT 3 0 T006 OIB_HVEH
EXTIND External functions ind. (API c-codes, etc.) CHAR 1 0 OIB_EXTIND
0 calculate LPG equilibrium vapor pressure
1 use input equilibrium vapor pressure for LPG calculation
VCFLN_LPG Volume correction factor LPG CHAR 1 0 OIB_VCFLN_LPG
1 use combined temperature-pressure volume correction factor
2 use temperature correction factor only
3 use pressure correction factor only
BSDNEH Base density unit (at standard reference conditions) UNIT 3 0 T006 OIB_BSDNEH
BSHVEH Base heating value unit (at standard reference conditions) UNIT 3 0 T006 OIB_BSHVEH
TDTHV Test density/test heating value - parameter handling CHAR 1 0 OIB_TDTHV
BDBHV Base density / base heating value parameter handling CHAR 1 0 OIB_BDBHV
AROMATICS Industrial aromatic hydrocarbons: Type CHAR 2 0 OIB_AROMATICS
1 Benzene
10 300-350°F/148.9-176.7°C aromatic hc
11 350-400°F/176.7-204.4°C aromatic hc
2 Toluene
3 m-Xylene and mixed Xylenes
4 Styrene
5 o-Xylene
6 p-Xylene
7 Cyclohexane
8 Ethylbenzene
9 Cumene
BHVCLS Heating value class (calorific value class) CHAR 2 0 OIB_HVCLS
ID ( inferior / dry ), equiv.: ( net,lower / dry)
IW ( inferior / wet ), equiv.: ( net,lower / saturated)
SD ( superior / dry ), equiv.: ( gross,upper,total / dry )
SW ( superior / wet ), equiv.: ( gross,upper,total / saturated)
IDGAS Indicator for SAP natural gas routine (ideal/real gas) CHAR 1 0 OIB_IDGAS
Use ideal gas routine
1 Use real gas routine
RFC_RELEASE Release indicator for external (RFC) calls to QCI CHAR 1 0 OIB_RELEASE

OIB01 foreign key relationships

Table Field Check Table Check Field
0 OIB01 BPRESHEH T006 Units of Measurement MANDT
1 OIB01 BPRESVEH T006 Units of Measurement MANDT
0 OIB01 BSDNEH T006 Units of Measurement MANDT
1 OIB01 BSHVEH T006 Units of Measurement MANDT
0 OIB01 BSTEH T006 Units of Measurement MANDT
1 OIB01 BSTMPHEH T006 Units of Measurement MANDT
0 OIB01 BTMPVPEH T006 Units of Measurement MANDT
1 OIB01 EXTDNUNIT T006 Units of Measurement MANDT
0 OIB01 EXTHVUNIT T006 Units of Measurement MANDT
1 OIB01 MANDT T000 Clients MANDT