OIRC_DRREJ SAP table for – SSR Stocks – Dip readings rejected records

Here we would like to draw your attention to OIRC_DRREJ 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). OIRC_DRREJ is a SAP standard transp table used for storing SSR Stocks – Dip readings rejected records related data in SAP. It comes under the package OIR_C.

SAP OIRC_DRREJ table

Table OIRC_DRREJ technical data

TableOIRC_DRREJ
Data storingSSR Stocks – Dip readings rejected records
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR_C
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIRC_DRREJ 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 OIRC_DRREJ table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PBLNR : Business location identifier (IS-Oil MRN)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • RNBT : Business type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • REC_SEQNR : SSR Fuels – Sequential number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • .INCLUDE : SSR Stocks – Dip readings rejected records
  • SOCNR : SOC: Storage object characteristic segment number
    Its data type is CHAR (Character String) with field length 20
  • ETMSTM : SSR Stocks – Tank dip time stamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOCEV : SOC event
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : SSR Stocks – Dip readings maintenance structure
  • .INCLUDE : Tank strapping history structure
  • SLVNR : SOC: Linear/volumetric conversion (strap) set number
    Its data type is CHAR (Character String) with field length 20
  • SLVIND : SOC: recalibration index for strapping data
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • TOTALHEIGHT : Tank dip, total height
    Its data type is QUAN (Quantity field) with field length 13
  • TOTALHEIGHT_FLTP : Silo Mgmt: Tank strapping height in FLTP
    Its data type is FLTP (Floating point number) with field length 16
  • WATERHEIGHT : Tank dip: water dip height
    Its data type is QUAN (Quantity field) with field length 13
  • WATERHEIGHT_FLTP : Silo Mgmt: Tank strapping height in FLTP
    Its data type is FLTP (Floating point number) with field length 16
  • MDICH : Material density (at ambient temperature)
    Its data type is QUAN (Quantity field) with field length 13
  • DNSUN : Density UoM (Oil product/Silo)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • QUAN_SKU : Quantity in stock keeping unit/ base unit of measure
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • QUAN_LVC : Material volume in LVC set UoM
    Its data type is QUAN (Quantity field) with field length 13
  • WATR_LVC : Water Volume in LVC set UoM
    Its data type is QUAN (Quantity field) with field length 13
  • SHTMP : Silo shell temperature
    Its data type is FLTP (Floating point number) with field length 16
  • SHTEH : Silo shell temperature unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UL_IN_IND : Dipping method (innage, ullage)
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Unit of measure set – lin/vol conversion (BDRP)
  • VOLUN : UoM – volumetric constant for lin./vol. conversion (BDRP)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • LENUN : UoM – linear constant for lin./vol. conversion (BDRP)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .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 : Standard status field set (BDRP)
  • ERDAT : Date record created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time record created
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : User who created record
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Date record changed
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time record changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : User who changed record
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • .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
  • .INCLUDE : SSR Stocks – Dip readings maintenance (SSR fields)
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • TNKNR : Sequence number of SO assigned to business location
    Its data type is CHAR (Character String) with field length 10
  • DRDATE : SSR Fuels – local date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DRTIME : SSR Fuels – Local time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • TIME_ZONE : SSR Fuels – Service station time zone
    Its data type is CHAR (Character String) with field length 6
  • PR_NUMBER : SSR Fuels – Process number
    Its data type is CHAR (Character String) with field length 10
  • WERKS : Plant for storage location assignment entry (IS-Oil MRN)
    Its data type is CHAR (Character String) with field length 4
  • LGORT : Storage location
    Its data type is CHAR (Character String) with field length 4
  • RELSTOCK : SSR Stocks – related stock at time of tank dip
    Its data type is QUAN (Quantity field) with field length 13
  • QTYPER : SSR Stocks – Tolerance Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • TOL_STATUS : SSR Fuels – Tolerance status light
    Its data type is CHAR (Character String) with field length 4
  • MM_QUAN : SSR Stocks – Difference Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • LINKNR : Link number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ITLINKNR : Item link number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • LINKYEAR : Document link number year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • CHECK_STATUS : SSR Fuels – Status check light
    Its data type is CHAR (Character String) with field length 4
  • ACTSTOCK : SSR Stocks – Actual book stock
    Its data type is QUAN (Quantity field) with field length 13
  • MM_QUAN_POSTED : SSR Stocks – Posted Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • PROC_ONLINE : SSR Meters – On-line process indicator
    Its data type is CHAR (Character String) with field length 1
  • PROC_TYPE : SSR Fuels – Process type
    Its data type is CHAR (Character String) with field length 1
  • STCODE : SSR Fuels – Status code
    Its data type is CHAR (Character String) with field length 2
  • BEZEI : Description
    Its data type is CHAR (Character String) with field length 40
  • BLOCK : SSR Fuels – Indicator that identifies a blocking status
    Its data type is CHAR (Character String) with field length 1
  • BLOCK_RELEASE : SSR Fuels – Indicator for blocking status release
    Its data type is CHAR (Character String) with field length 1
  • USR_IND : SSR Fuels – User error indicator
    Its data type is CHAR (Character String) with field length 1
  • MAKTX : Material description
    Its data type is CHAR (Character String) with field length 40