SAP Table

OIB01 Definition of Conversion Groups

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

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

/ Fields

OIB01 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyUMRSL Conversion Group (Oil, Natural Gas,..) CHAR 4 0 OIB_UMRSL
PDTYP Oil product type CHAR 1 0 OIB_PDTYP
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
VCFLN Volume correction factor CHAR 1 0 OIB_VCFLN
MCFI Meter correction factor indicator CHAR 1 0 OIB_MCFI
PDCL Oil/Gas product conversion class CHAR 2 0 OIB_PDCL
HVTYP Heating value type CHAR 2 0 OIB_HVTYP
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
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
CHLQ Conversion handling for liquid products CHAR 1 0 OIB_CHLQ
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
VCFLN_LPG Volume correction factor LPG CHAR 1 0 OIB_VCFLN_LPG
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
BHVCLS Heating value class (calorific value class) CHAR 2 0 OIB_HVCLS
IDGAS Indicator for SAP natural gas routine (ideal/real gas) CHAR 1 0 OIB_IDGAS
RFC_RELEASE Release indicator for external (RFC) calls to QCI CHAR 1 0 OIB_RELEASE
/ Relationships

OIB01 foreign keys.

Table Field Check Table Description Check Field
OIB01 BPRESHEH T006 Units of Measurement MANDT
OIB01 BPRESVEH T006 Units of Measurement MANDT
OIB01 BSDNEH T006 Units of Measurement MANDT
OIB01 BSHVEH T006 Units of Measurement MANDT
OIB01 BSTEH T006 Units of Measurement MANDT
OIB01 BSTMPHEH T006 Units of Measurement MANDT
OIB01 BTMPVPEH T006 Units of Measurement MANDT
OIB01 EXTDNUNIT T006 Units of Measurement MANDT
OIB01 EXTHVUNIT T006 Units of Measurement MANDT
OIB01 MANDT T000 Clients MANDT
Back to SAP tables