OIRC_DRREJ SAP (SSR Stocks - Dip readings rejected records) Table details
Dictionary Type: Table
Description: SSR Stocks - Dip readings rejected records
Description: SSR Stocks - Dip readings rejected records
Table field list including key, data, relationships and ABAP select examples
OIRC_DRREJ is a standard SAP Table which is used to store SSR Stocks - Dip readings rejected records data and is available within R/3 SAP systems depending on the version and release level.
The OIRC_DRREJ table consists of various fields, each holding specific information or linking keys about SSR Stocks - Dip readings rejected records data available in SAP. These include PBLNR (Business location identifier (IS-Oil MRN)), RNBT (Business type), REC_SEQNR (SSR Fuels - Sequential number), SOCNR (SOC: Storage object characteristic segment number).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIRC_DRREJ table 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PBLNR | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | OIFSPBL | ALPHA | OIF_PBLNR | OI0 | OIFB |
RNBT | Business type | OIRA_RNBT | CHAR | 4 | OIRARNBT | OIRA_RNBT | OIRA_0 | ||
REC_SEQNR | SSR Fuels - Sequential number | OIRC_SEQNR | NUMC | 5 | OIRC_SEQNR | ||||
SOCNR | SOC: Storage object characteristic segment number | OII_SOCNR | CHAR | 20 | OIISOCK | OII_SOCNR | |||
ETMSTM | SSR Stocks - Tank dip time stamp | OIRC_TMSTM | DEC | 15 | TZNTSTMPS | ||||
SOCEV | SOC event | OII_SOCEV | CHAR | 2 | OIISOCE | OII_SOCEV | |||
SLVNR | SOC: Linear/volumetric conversion (strap) set number | OII_SLVNR | CHAR | 20 | Assigned to domain | OII_SLVNR | |||
SLVIND | SOC: recalibration index for strapping data | OII_SLVIND | NUMC | 5 | OII_SLVIND | ||||
TOTALHEIGHT | Tank dip, total height | OII_TOTALHEIGHT | QUAN | 13(3) | MENGE | ||||
TOTALHEIGHT_FLTP | Silo Mgmt: Tank strapping height in FLTP | OII_HGT_FLTP | FLTP | 16(16) | TEMP_VALUE | ||||
WATERHEIGHT | Tank dip: water dip height | OII_WATERHEIGHT | QUAN | 13(3) | MENGE | ||||
WATERHEIGHT_FLTP | Silo Mgmt: Tank strapping height in FLTP | OII_HGT_FLTP | FLTP | 16(16) | TEMP_VALUE | ||||
MDICH | Material density (at ambient temperature) | OII_MATDENS | QUAN | 13(3) | MENGE | ||||
DNSUN | Density UoM (Oil product/Silo) | OII_DNSUN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUAN_SKU | Quantity in stock keeping unit/ base unit of measure | OII_QUAN_SKU | QUAN | 13(3) | MENGE | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
QUAN_LVC | Material volume in LVC set UoM | OII_QUAN_LVC | QUAN | 13(3) | MENGE | ||||
WATR_LVC | Water Volume in LVC set UoM | OII_WATR_LVC | QUAN | 13(3) | MENGE | ||||
SHTMP | Silo shell temperature | OII_STTMP | FLTP | 16(16) | TEMP_VALUE | ||||
SHTEH | Silo shell temperature unit | OII_STTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UL_IN_IND | Dipping method (innage, ullage) | OII_UL_IN_IND | CHAR | 1 | OII_UL_IN_IND | ||||
VOLUN | UoM - volumetric constant for lin./vol. conversion (BDRP) | OII_VOLUNC | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LENUN | UoM - linear constant for lin./vol. conversion (BDRP) | OII_LENUNC | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMRSL | Conversion Group (Oil, Natural Gas,..) | OIB_UMRSL | CHAR | 4 | OIB01 | OIB_UMRSL | |||
CMODE | Conversion Mode | OIB_CMODE | CHAR | 1 | OIB_CMODE | ||||
FDICHEH | Unit for densities at standard/base conditions | OIB_BDNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
FDICH | Fixed Density | OIB_FDICH | FLTP | 16(16) | OIB_DICHT | ||||
COEFF | Quantity Conversion Coefficient | OIB_COEFF | FLTP | 16(16) | OIB_COEFF | ||||
BDICHEH | Unit for densities at standard/base conditions | OIB_BDNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BDICH | Oil/gas density at standard/base conditions | OIB_BDICH | FLTP | 16(16) | OIB_DICHT | ||||
BHVALEH | Heating value unit at standard/base conditions (natural gas) | OIB_BHVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BHVAL | Heating value at standard/base conditions (natural gas) | OIB_BHVAL | FLTP | 16(16) | OIB_HVAL | ||||
TSTMP | Oil/Gas Test Temperature: Observed Density | OIB_TSTMP | FLTP | 16(16) | TEMP_VALUE | ||||
TSTEH | Test Temperature Unit (Density): Measurement | OIB_TSTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MTTMP | Oil/Gas Material Temperature: Observed Quantity | OIB_MTTMP | FLTP | 16(16) | TEMP_VALUE | ||||
MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | OIB_MTTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
THVAL | Heating value at test conditions (natural gas): observed | OIB_THVAL | FLTP | 16(16) | OIB_HVAL | ||||
TDICHEH | Unit for densities of petroleum products and natural gas | OIB_DNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TDICH | Oil/Gas Test Density | OIB_TDICH | FLTP | 16(16) | OIB_DICHT | ||||
MTPRES | Oil/gas material pressure: observed quantity | OIB_MTPRES | FLTP | 16(16) | OIB_PRES | ||||
MTPRESEH | Oil/gas material pressure unit: observed quantity | OIB_MTPRESEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TPRED | Oil/gas test pressure: metering (obs. density) | OIB_TPRED | FLTP | 16(16) | OIB_PRES | ||||
TPREDEH | Oil/Gas test press. unit: metering (density) | OIB_TPREDEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TPRHV | Natural gas test pressure: combustion (obs. heating value ) | OIB_TPRHV | FLTP | 16(16) | OIB_PRES | ||||
TPRHVEH | Natural gas test pressure unit: combustion ( heating value ) | OIB_TPRHVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TTMPHV | Natural gas test temperature: combustion (obs. heat. value ) | OIB_TTMPHV | FLTP | 16(16) | TEMP_VALUE | ||||
TTMPHVEH | Natural gas test temp. unit: combustion (heating value) | OIB_TTMPHVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
ATPRES | Atmospheric pressure of the air surrounding a product | OIB_ATPRES | FLTP | 16(16) | OIB_PRES | ||||
ATPRESEH | Atmospheric pressure unit | OIB_ATPRESEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VAPRES | Vapor pressure of liquid petroleum gases (LPG) | OIB_VAPRES | FLTP | 16(16) | OIB_PRES | ||||
VAPRESEH | Vapor pressure unit (LPG) | OIB_VAPRESEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
THVALEH | Heating value unit | OIB_HVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MTCOMBTMP | Natural gas material combustion temp.: observed quantity | OIB_MTCOMBTMP | FLTP | 16(16) | TEMP_VALUE | ||||
MTCOMBTEH | Natural gas material combustion temp. unit: obs. quantity | OIB_MTCOMBTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MTCOMBPRES | Natural gas material combustion pressure: observed quantity | OIB_MTCOMBPRES | FLTP | 16(16) | OIB_PRES | ||||
MTCOMBPRESEH | Natural gas material combustion pres. unit: oberved quantity | OIB_MTCOMBPRESEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TSTMPCAL | Natural gas: Calorimeter test temperature (density) | OIB_TSTMPCAL | FLTP | 16(16) | TEMP_VALUE | ||||
TSTMPCALEH | Natural gas: unit for calorimeter test temperature (density) | OIB_TSTMPCALEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TPREDCAL | Natural gas: Calorimeter test pressure (density) | OIB_TPREDCAL | FLTP | 16(16) | OIB_PRES | ||||
TPREDCALEH | Natural gas: Unit for calorimeter test pressure (density) | OIB_TPREDCALEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
HYDRO | Hydrometer Correction Indicator | OIB_HYDRO | CHAR | 1 | OIB_XFELD | ||||
ABIND | Air Bouyancy Indicator | OIB_ABIND | CHAR | 1 | OIB_XFELD | ||||
ABFAC | Air Bouyancy Factor | OIB_ABFAC | DEC | 3(1) | OIB_ABFAC | ||||
MCF | Meter correction factor | OIB_MCF1 | FLTP | 16(16) | OIB_VCF | ||||
BSWCN | BSW % | OIB_BSWCN | FLTP | 16(16) | OIB_BSWCN | ||||
BSWCNEH | BSW % unit (volume %, mol %, mass % or proportion ) | OIB_BSWCNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
HVCLS | Heating value class (calorific value class) | OIB_HVCLS | CHAR | 2 | OIB_HVCLS | ||||
HVCLS_TO | Heating value class (calorific value class) | OIB_HVCLS | CHAR | 2 | OIB_HVCLS | ||||
DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
ERDAT | Date record created | OII_ERDAT | DATS | 8 | DATS | ||||
ERZEIT | Time record created | OII_ERZEIT | TIMS | 6 | TIME | ||||
ERNAM | User who created record | OII_ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Date record changed | OII_AEDAT | DATS | 8 | DATS | ||||
AEZEIT | Time record changed | OII_AEZEIT | TIMS | 6 | TIME | ||||
AENAM | User who changed record | OII_AENAM | CHAR | 12 | USNAM | ||||
BLOIND | Blocking indicator | OII_BLOIND | CHAR | 1 | XFELD | ||||
DELIND | Deletion indicator | OII_DELIND | CHAR | 1 | XFELD | ||||
CH4RATIO | Natural gas CH4 content (ratio) | OIB_CH4RAT | FLTP | 16(16) | OIB_RAT | ||||
N2RATIO | Natural gas N2 (nitrogen) content (ratio) | OIB_N2RAT | FLTP | 16(16) | OIB_RAT | ||||
CO2RATIO | Natural gas CO2 content (ratio) | OIB_CO2RAT | FLTP | 16(16) | OIB_RAT | ||||
C2H6RATIO | Natural gas C2H6 (ethane) content (ratio) | OIB_C2H6RAT | FLTP | 16(16) | OIB_RAT | ||||
C3H8RATIO | Natural gas C3H8 (propane) content (ratio) | OIB_C3H8RAT | FLTP | 16(16) | OIB_RAT | ||||
H2ORATIO | Natural gas H2O content (ratio) | OIB_H2ORAT | FLTP | 16(16) | OIB_RAT | ||||
H2SRATIO | Natural gas H2S content (ratio) | OIB_H2SRAT | FLTP | 16(16) | OIB_RAT | ||||
H2RATIO | Natural gas H2 (Hydrogen) content (ratio) | OIB_H2RAT | FLTP | 16(16) | OIB_RAT | ||||
CORATIO | Natural gas CO content (ratio) | OIB_CORAT | FLTP | 16(16) | OIB_RAT | ||||
O2RATIO | Natural gas oxygen (O2) content (ratio) | OIB_O2RAT | FLTP | 16(16) | OIB_RAT | ||||
ISOC4H10RATIO | Natural gas ISO-C4H10 (iso-butane ) content (ratio) | OIB_ISOC4H10RAT | FLTP | 16(16) | OIB_RAT | ||||
NC4H10RATIO | Natural gas n-C4H10 (n-butane ) content (ratio) | OIB_NC4H10RAT | FLTP | 16(16) | OIB_RAT | ||||
ISOC5H12RATIO | Natural gas ISO-C5H12 (ISO-pentane ) content (ratio) | OIB_ISOC5H12RAT | FLTP | 16(16) | OIB_RAT | ||||
NC5H12RATIO | Natural gas n-C5H12 (n-pentane ) content (ratio) | OIB_NC5H12RAT | FLTP | 16(16) | OIB_RAT | ||||
C6H14RATIO | Natural gas C6H14 (n-hexane ) content (ratio) | OIB_C6H14RAT | FLTP | 16(16) | OIB_RAT | ||||
C7H16RATIO | Natural gas C7H16 (n-heptane ) content (ratio) | OIB_C7H16RAT | FLTP | 16(16) | OIB_RAT | ||||
C8H18RATIO | Natural gas C8H18 (n-octane ) content (ratio) | OIB_C8H18RAT | FLTP | 16(16) | OIB_RAT | ||||
C9H20RATIO | Natural gas C9H20 (n-Nonane ) content (ratio) | OIB_C9H20RAT | FLTP | 16(16) | OIB_RAT | ||||
C10H22RATIO | Natural gas C10H22 (n-Decane ) content (ratio) | OIB_C10H22RAT | FLTP | 16(16) | OIB_RAT | ||||
HERATIO | Natural gas He (Helium) content (ratio) | OIB_HERAT | FLTP | 16(16) | OIB_RAT | ||||
ARRATIO | Natural gas Argon content (ratio) | OIB_ARRAT | FLTP | 16(16) | OIB_RAT | ||||
GASCOMPRATEH | Unit (vol. %, mol % or mass % ) of natural gas composition | OIB_GASCOMPRATEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MOLDEN | Natural gas molar density (mol/volume) at standard condition | OIB_MOLDEN | FLTP | 16(16) | OIB_DICHT | ||||
MOLDENEH | Unit for molar density at base conditions ( nat.gas) | OIB_MOLDENEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MOLWEIGHT | Molecular weight of natural gas:return value from AGA c-code | OIB_MOLWEIGHT | FLTP | 16(16) | OIB_MOLWEIGHT | ||||
HYDROCARBMOLFRAC | Hydrocarbon mole fraction calculated from AGA c-code | OIB_HYDROCARBMOLFRAC | FLTP | 16(16) | OIB_FRAC | ||||
MOLWEIGHTEH | Unit for molar mass | OIB_MOLWEIGHTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
CUSTPARCHAR1 | Customer parameter character field 1 | OIB_CUSTPARCHAR1 | CHAR | 3 | OIB_CUSTPARCHAR | ||||
CUSTPARFLOAT1 | Customer parameter float 1 | OIB_CUSTPARFLOAT1 | FLTP | 16(16) | OIB_CUSTPARFLO | ||||
CUSTEH1 | Customer parameter 1 unit | OIB_CUSTEH1 | UNIT | 3 | T006 | CUNIT | MEINS | ||
CUSTPARCHAR2 | Customer parameter character field 2 | OIB_CUSTPARCHAR2 | CHAR | 3 | OIB_CUSTPARCHAR | ||||
CUSTPARFLOAT2 | Customer parameter float 2 | OIB_CUSTPARFLOAT2 | FLTP | 16(16) | OIB_CUSTPARFLO | ||||
CUSTEH2 | Customer parameter 2 unit | OIB_CUSTEH2 | UNIT | 3 | T006 | CUNIT | MEINS | ||
CUSTPARCHAR3 | Customer parameter character field 3 | OIB_CUSTPARCHAR3 | CHAR | 3 | OIB_CUSTPARCHAR | ||||
CUSTPARFLOAT3 | Customer parameter float 3 | OIB_CUSTPARFLOAT3 | FLTP | 16(16) | OIB_CUSTPARFLO | ||||
CUSTEH3 | Customer parameter 3 unit | OIB_CUSTEH3 | UNIT | 3 | T006 | CUNIT | MEINS | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
TNKNR | Sequence number of SO assigned to business location | OII_BSEQNR | CHAR | 10 | ALPHA | OII_SEQNR | |||
DRDATE | SSR Fuels - local date | OIRC_DATUM | DATS | 8 | DATUM | ||||
DRTIME | SSR Fuels - Local time | OIRC_UZEIT | TIMS | 6 | UZEIT | ||||
TIME_ZONE | SSR Fuels - Service station time zone | OIRC_TIMEZONE | CHAR | 6 | Assigned to domain | TZNZONE | |||
PR_NUMBER | SSR Fuels - Process number | OIRC_PR_NUMBER | CHAR | 10 | CHAR10 | ||||
WERKS | Plant for storage location assignment entry (IS-Oil MRN) | OIF_WERKSL | CHAR | 4 | T001W | WERKS | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
RELSTOCK | SSR Stocks - related stock at time of tank dip | OIRC_RELSTOCK | QUAN | 13(3) | MENG13V | ||||
QTYPER | SSR Stocks - Tolerance Percentage | OIRC_QTYPER | DEC | 6(2) | PRZ32V | ||||
TOL_STATUS | SSR Fuels - Tolerance status light | OIRC_TOLST | CHAR | 4 | CHAR04 | ||||
MM_QUAN | SSR Stocks - Difference Quantity | OIRC_MM_QUAN | QUAN | 13(3) | MENG13V | ||||
LINKNR | Link number | OIRA_LINKNR | NUMC | 10 | NUMC10 | ||||
ITLINKNR | Item link number | OIRA_ITLINKNR | NUMC | 6 | Assigned to domain | POSNR | |||
LINKYEAR | Document link number year | OIRA_JAHR | NUMC | 4 | GJAHR | GJAHR | |||
CHECK_STATUS | SSR Fuels - Status check light | OIRC_CHKST | CHAR | 4 | CHAR04 | ||||
ACTSTOCK | SSR Stocks - Actual book stock | OIRC_ACTSTOCK | QUAN | 13(3) | MENG13V | ||||
MM_QUAN_POSTED | SSR Stocks - Posted Quantity | OIRC_MM_QUAN_POSTED | QUAN | 13(3) | MENG13V | ||||
PROC_ONLINE | SSR Meters - On-line process indicator | OIRC_ONLINE | CHAR | 1 | YESNO | ||||
PROC_TYPE | SSR Fuels - Process type | OIRC_IND_PROC | CHAR | 1 | OIRC_IND_PROC | ||||
STCODE | SSR Fuels - Status code | OIRC_STCODE_SAP | CHAR | 2 | Assigned to domain | OIRC_STCODE_SAP | |||
BEZEI | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
BLOCK | SSR Fuels - Indicator that identifies a blocking status | OIRC_IND_BLK | CHAR | 1 | OIRC_IND_BLK | ||||
BLOCK_RELEASE | SSR Fuels - Indicator for blocking status release | OIRC_IND_BLKRLS | CHAR | 1 | OIRC_IND_BLKRLS | ||||
USR_IND | SSR Fuels - User error indicator | OIRC_USR_IND | CHAR | 1 | YESNO | ||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 |
Key field | Non-key field |
How do I retrieve data from SAP table OIRC_DRREJ using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIRC_DRREJ to SELECT all data from the tableDATA: WA_OIRC_DRREJ TYPE OIRC_DRREJ.
SELECT SINGLE *
FROM OIRC_DRREJ
INTO CORRESPONDING FIELDS OF WA_OIRC_DRREJ
WHERE...
How to access SAP table OIRC_DRREJ
Within an ECC or HANA version of SAP you can also view further information about OIRC_DRREJ 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