OIL_OIB01 SAP (Oil APPEND for core table) Append Structure details
Dictionary Type: Append Structure
Description: Oil APPEND for core table
Description: Oil APPEND for core table
Append Structure field list including key, data, relationships and ABAP select examples
OIL_OIB01 is a standard SAP Append Structure which is used to store Oil APPEND for core table data and is available within R/3 SAP systems depending on the version and release level.
The OIL_OIB01 table consists of various fields, each holding specific information or linking keys about Oil APPEND for core table data available in SAP. These include PDTYP (Oil product type), BSTMP (Oil/gas standard/base temperature), BSTEH (Oil/gas standard/base temperature unit), WQTYL (Lower warning tolerance limit for manual entries (in %)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIL_OIB01 append structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
PDTYP | Oil product type | OIB_PDTYP | CHAR | 1 | OIB_PDTYP | ||||
BSTMP | Oil/gas standard/base temperature | OIB_BSTMP | FLTP | 16(16) | TEMP_VALUE | ||||
BSTEH | Oil/gas standard/base temperature unit | OIB_BSTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
WQTYL | Lower warning tolerance limit for manual entries (in %) | OIB_WQTYL | FLTP | 16(16) | OIB_QTYPC | ||||
WQTYH | Upper warning tolerance limit for manual entries (in %) | OIB_WQTYH | FLTP | 16(16) | OIB_QTYPC | ||||
EQTYL | Lower Tolerance Limit for Manual Quantity Entries (in %) | OIB_EQTYL | FLTP | 16(16) | OIB_QTYPC | ||||
EQTYH | Upper Tolerance Limit for Manual Quantity Entries (in %) | OIB_EQTYH | FLTP | 16(16) | OIB_QTYPC | ||||
DNTYP | Density Type | OIB_DNTYP | CHAR | 1 | OIB_DNTYP | ||||
VCFLN | Volume correction factor | OIB_VCFLN | CHAR | 1 | OIB_VCFLN | ||||
MCFI | Meter correction factor indicator | OIB_MCFI | CHAR | 1 | XFELD | ||||
PDCL | Oil/Gas product conversion class | OIB_PDCL | CHAR | 2 | OIB_PDCL | ||||
HVTYP | Heating value type | OIB_HVTYP | CHAR | 2 | OIB_HVTYP | ||||
BPRESH | Natural Gas Base Pressure for Combustion (Heating Value) | OIB_BPRESH | FLTP | 16(16) | B_FLOAT | ||||
BPRESHEH | Natural gas std/base press.: combustion (heat. value): unit | OIB_BPRESHEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BSTMPH | Natural Gas Base Temperature of Combustion (Heating Value) | OIB_BSTMPH | FLTP | 16(16) | TEMP_VALUE | ||||
BSTMPHEH | Natural gas std/base temp.: combustion (heat. value): unit | OIB_BSTMPHEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
EXT_PROG_VERSION | Supported version of external routines | OIB_EXT_VERSION | CHAR | 1 | OIB_EXT_VERSION | ||||
BPRESV | Oil/gas standard/base pressure:metering (volume, density) | OIB_BPRESV | FLTP | 16(16) | OIB_PRES | ||||
BPRESVEH | Oil/gas standard/base pres.:metering (volume, density): unit | OIB_BPRESVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BTMPVP | Oil/gas standard/base temperature (vapor pressure) | OIB_BTMPVP | FLTP | 16(16) | TEMP_VALUE | ||||
BTMPVPEH | Oil/gas standard/base temperature unit (vapor pressure) | OIB_BTMPVPEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
CHGS | Conversion handling for gases | OIB_CHGS | CHAR | 1 | OIB_CHGS | ||||
CHLQ | Conversion handling for liquid products | OIB_CHLQ | CHAR | 1 | OIB_CHLQ | ||||
EXTDNUNIT | Unit for densities of petroleum products and natural gas | OIB_DNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
EXTHVUNIT | Heating value unit | OIB_HVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
EXTIND | External functions ind. (API c-codes, etc.) | OIB_EXTIND | CHAR | 1 | OIB_EXTIND | ||||
VCFLN_LPG | Volume correction factor LPG | OIB_VCFLN_LPG | CHAR | 1 | OIB_VCFLN_LPG | ||||
BSDNEH | Base density unit (at standard reference conditions) | OIB_BSDNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BSHVEH | Base heating value unit (at standard reference conditions) | OIB_BSHVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TDTHV | Test density/test heating value - parameter handling | OIB_TDTHV | CHAR | 1 | OIB_XFELD | ||||
BDBHV | Base density / base heating value parameter handling | OIB_BDBHV | CHAR | 1 | OIB_XFELD | ||||
AROMATICS | Industrial aromatic hydrocarbons: Type | OIB_AROMATICS | CHAR | 2 | OIB_AROMATICS | ||||
BHVCLS | Heating value class (calorific value class) | OIB_HVCLS | CHAR | 2 | OIB_HVCLS | ||||
IDGAS | Indicator for SAP natural gas routine (ideal/real gas) | OIB_IDGAS | CHAR | 1 | OIB_IDGAS | ||||
RFC_RELEASE | Release indicator for external (RFC) calls to QCI | OIB_RELEASE | CHAR | 1 | OIB_XFELD |
Key field | Non-key field |
How do I retrieve data from SAP append structure OIL_OIB01 using ABAP code?
As OIL_OIB01 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on OIL_OIB01 as there is no data to select. You could however select data from any tables that this append structure has been assigned too.How to access SAP table OIL_OIB01
Within an ECC or HANA version of SAP you can also view further information about OIL_OIB01 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects