OIRC_DRREJ SAP (SSR Stocks - Dip readings rejected records) Table details

Dictionary Type: Table
Description: SSR Stocks - Dip readings rejected records




ABAP Code to SELECT data from OIRC_DRREJ
Related tables to OIRC_DRREJ
Access table OIRC_DRREJ




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
PBLNRBusiness location identifier (IS-Oil MRN) OIF_PBLNRCHAR10OIFSPBLALPHAOIF_PBLNROI0OIFB
RNBTBusiness type OIRA_RNBTCHAR4OIRARNBTOIRA_RNBTOIRA_0
REC_SEQNRSSR Fuels - Sequential number OIRC_SEQNRNUMC5OIRC_SEQNR
SOCNRSOC: Storage object characteristic segment number OII_SOCNRCHAR20OIISOCKOII_SOCNR
ETMSTMSSR Stocks - Tank dip time stamp OIRC_TMSTMDEC15TZNTSTMPS
SOCEVSOC event OII_SOCEVCHAR2OIISOCEOII_SOCEV
SLVNRSOC: Linear/volumetric conversion (strap) set number OII_SLVNRCHAR20Assigned to domainOII_SLVNR
SLVINDSOC: recalibration index for strapping data OII_SLVINDNUMC5OII_SLVIND
TOTALHEIGHTTank dip, total height OII_TOTALHEIGHTQUAN13(3) MENGE
TOTALHEIGHT_FLTPSilo Mgmt: Tank strapping height in FLTP OII_HGT_FLTPFLTP16(16) TEMP_VALUE
WATERHEIGHTTank dip: water dip height OII_WATERHEIGHTQUAN13(3) MENGE
WATERHEIGHT_FLTPSilo Mgmt: Tank strapping height in FLTP OII_HGT_FLTPFLTP16(16) TEMP_VALUE
MDICHMaterial density (at ambient temperature) OII_MATDENSQUAN13(3) MENGE
DNSUNDensity UoM (Oil product/Silo) OII_DNSUNUNIT3Assigned to domainCUNITMEINS
QUAN_SKUQuantity in stock keeping unit/ base unit of measure OII_QUAN_SKUQUAN13(3) MENGE
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
QUAN_LVCMaterial volume in LVC set UoM OII_QUAN_LVCQUAN13(3) MENGE
WATR_LVCWater Volume in LVC set UoM OII_WATR_LVCQUAN13(3) MENGE
SHTMPSilo shell temperature OII_STTMPFLTP16(16) TEMP_VALUE
SHTEHSilo shell temperature unit OII_STTEHUNIT3Assigned to domainCUNITMEINS
UL_IN_INDDipping method (innage, ullage) OII_UL_IN_INDCHAR1OII_UL_IN_IND
VOLUNUoM - volumetric constant for lin./vol. conversion (BDRP) OII_VOLUNCUNIT3Assigned to domainCUNITMEINS
LENUNUoM - linear constant for lin./vol. conversion (BDRP) OII_LENUNCUNIT3Assigned to domainCUNITMEINS
UMRSLConversion Group (Oil, Natural Gas,..) OIB_UMRSLCHAR4OIB01OIB_UMRSL
CMODEConversion Mode OIB_CMODECHAR1OIB_CMODE
FDICHEHUnit for densities at standard/base conditions OIB_BDNEHUNIT3T006CUNITMEINS
FDICHFixed Density OIB_FDICHFLTP16(16) OIB_DICHT
COEFFQuantity Conversion Coefficient OIB_COEFFFLTP16(16) OIB_COEFF
BDICHEHUnit for densities at standard/base conditions OIB_BDNEHUNIT3T006CUNITMEINS
BDICHOil/gas density at standard/base conditions OIB_BDICHFLTP16(16) OIB_DICHT
BHVALEHHeating value unit at standard/base conditions (natural gas) OIB_BHVEHUNIT3T006CUNITMEINS
BHVALHeating value at standard/base conditions (natural gas) OIB_BHVALFLTP16(16) OIB_HVAL
TSTMPOil/Gas Test Temperature: Observed Density OIB_TSTMPFLTP16(16) TEMP_VALUE
TSTEHTest Temperature Unit (Density): Measurement OIB_TSTEHUNIT3T006CUNITMEINS
MTTMPOil/Gas Material Temperature: Observed Quantity OIB_MTTMPFLTP16(16) TEMP_VALUE
MTTEHOil/Gas Material Temperature Unit: Observed Quantity OIB_MTTEHUNIT3T006CUNITMEINS
THVALHeating value at test conditions (natural gas): observed OIB_THVALFLTP16(16) OIB_HVAL
TDICHEHUnit for densities of petroleum products and natural gas OIB_DNEHUNIT3T006CUNITMEINS
TDICHOil/Gas Test Density OIB_TDICHFLTP16(16) OIB_DICHT
MTPRESOil/gas material pressure: observed quantity OIB_MTPRESFLTP16(16) OIB_PRES
MTPRESEHOil/gas material pressure unit: observed quantity OIB_MTPRESEHUNIT3T006CUNITMEINS
TPREDOil/gas test pressure: metering (obs. density) OIB_TPREDFLTP16(16) OIB_PRES
TPREDEHOil/Gas test press. unit: metering (density) OIB_TPREDEHUNIT3T006CUNITMEINS
TPRHVNatural gas test pressure: combustion (obs. heating value ) OIB_TPRHVFLTP16(16) OIB_PRES
TPRHVEHNatural gas test pressure unit: combustion ( heating value ) OIB_TPRHVEHUNIT3T006CUNITMEINS
TTMPHVNatural gas test temperature: combustion (obs. heat. value ) OIB_TTMPHVFLTP16(16) TEMP_VALUE
TTMPHVEHNatural gas test temp. unit: combustion (heating value) OIB_TTMPHVEHUNIT3T006CUNITMEINS
ATPRESAtmospheric pressure of the air surrounding a product OIB_ATPRESFLTP16(16) OIB_PRES
ATPRESEHAtmospheric pressure unit OIB_ATPRESEHUNIT3T006CUNITMEINS
VAPRESVapor pressure of liquid petroleum gases (LPG) OIB_VAPRESFLTP16(16) OIB_PRES
VAPRESEHVapor pressure unit (LPG) OIB_VAPRESEHUNIT3T006CUNITMEINS
THVALEHHeating value unit OIB_HVEHUNIT3T006CUNITMEINS
MTCOMBTMPNatural gas material combustion temp.: observed quantity OIB_MTCOMBTMPFLTP16(16) TEMP_VALUE
MTCOMBTEHNatural gas material combustion temp. unit: obs. quantity OIB_MTCOMBTEHUNIT3T006CUNITMEINS
MTCOMBPRESNatural gas material combustion pressure: observed quantity OIB_MTCOMBPRESFLTP16(16) OIB_PRES
MTCOMBPRESEHNatural gas material combustion pres. unit: oberved quantity OIB_MTCOMBPRESEHUNIT3T006CUNITMEINS
TSTMPCALNatural gas: Calorimeter test temperature (density) OIB_TSTMPCALFLTP16(16) TEMP_VALUE
TSTMPCALEHNatural gas: unit for calorimeter test temperature (density) OIB_TSTMPCALEHUNIT3T006CUNITMEINS
TPREDCALNatural gas: Calorimeter test pressure (density) OIB_TPREDCALFLTP16(16) OIB_PRES
TPREDCALEHNatural gas: Unit for calorimeter test pressure (density) OIB_TPREDCALEHUNIT3T006CUNITMEINS
HYDROHydrometer Correction Indicator OIB_HYDROCHAR1OIB_XFELD
ABINDAir Bouyancy Indicator OIB_ABINDCHAR1OIB_XFELD
ABFACAir Bouyancy Factor OIB_ABFACDEC3(1) OIB_ABFAC
MCFMeter correction factor OIB_MCF1FLTP16(16) OIB_VCF
BSWCNBSW % OIB_BSWCNFLTP16(16) OIB_BSWCN
BSWCNEHBSW % unit (volume %, mol %, mass % or proportion ) OIB_BSWCNEHUNIT3T006CUNITMEINS
HVCLSHeating value class (calorific value class) OIB_HVCLSCHAR2OIB_HVCLS
HVCLS_TOHeating value class (calorific value class) OIB_HVCLSCHAR2OIB_HVCLS
DEFAULT_GUIDGUID in 'CHAR' Format in Uppercase GUID_32CHAR32SYSUUID_C
ERDATDate record created OII_ERDATDATS8DATS
ERZEITTime record created OII_ERZEITTIMS6TIME
ERNAMUser who created record OII_ERNAMCHAR12USNAM
AEDATDate record changed OII_AEDATDATS8DATS
AEZEITTime record changed OII_AEZEITTIMS6TIME
AENAMUser who changed record OII_AENAMCHAR12USNAM
BLOINDBlocking indicator OII_BLOINDCHAR1XFELD
DELINDDeletion indicator OII_DELINDCHAR1XFELD
CH4RATIONatural gas CH4 content (ratio) OIB_CH4RATFLTP16(16) OIB_RAT
N2RATIONatural gas N2 (nitrogen) content (ratio) OIB_N2RATFLTP16(16) OIB_RAT
CO2RATIONatural gas CO2 content (ratio) OIB_CO2RATFLTP16(16) OIB_RAT
C2H6RATIONatural gas C2H6 (ethane) content (ratio) OIB_C2H6RATFLTP16(16) OIB_RAT
C3H8RATIONatural gas C3H8 (propane) content (ratio) OIB_C3H8RATFLTP16(16) OIB_RAT
H2ORATIONatural gas H2O content (ratio) OIB_H2ORATFLTP16(16) OIB_RAT
H2SRATIONatural gas H2S content (ratio) OIB_H2SRATFLTP16(16) OIB_RAT
H2RATIONatural gas H2 (Hydrogen) content (ratio) OIB_H2RATFLTP16(16) OIB_RAT
CORATIONatural gas CO content (ratio) OIB_CORATFLTP16(16) OIB_RAT
O2RATIONatural gas oxygen (O2) content (ratio) OIB_O2RATFLTP16(16) OIB_RAT
ISOC4H10RATIONatural gas ISO-C4H10 (iso-butane ) content (ratio) OIB_ISOC4H10RATFLTP16(16) OIB_RAT
NC4H10RATIONatural gas n-C4H10 (n-butane ) content (ratio) OIB_NC4H10RATFLTP16(16) OIB_RAT
ISOC5H12RATIONatural gas ISO-C5H12 (ISO-pentane ) content (ratio) OIB_ISOC5H12RATFLTP16(16) OIB_RAT
NC5H12RATIONatural gas n-C5H12 (n-pentane ) content (ratio) OIB_NC5H12RATFLTP16(16) OIB_RAT
C6H14RATIONatural gas C6H14 (n-hexane ) content (ratio) OIB_C6H14RATFLTP16(16) OIB_RAT
C7H16RATIONatural gas C7H16 (n-heptane ) content (ratio) OIB_C7H16RATFLTP16(16) OIB_RAT
C8H18RATIONatural gas C8H18 (n-octane ) content (ratio) OIB_C8H18RATFLTP16(16) OIB_RAT
C9H20RATIONatural gas C9H20 (n-Nonane ) content (ratio) OIB_C9H20RATFLTP16(16) OIB_RAT
C10H22RATIONatural gas C10H22 (n-Decane ) content (ratio) OIB_C10H22RATFLTP16(16) OIB_RAT
HERATIONatural gas He (Helium) content (ratio) OIB_HERATFLTP16(16) OIB_RAT
ARRATIONatural gas Argon content (ratio) OIB_ARRATFLTP16(16) OIB_RAT
GASCOMPRATEHUnit (vol. %, mol % or mass % ) of natural gas composition OIB_GASCOMPRATEHUNIT3T006CUNITMEINS
MOLDENNatural gas molar density (mol/volume) at standard condition OIB_MOLDENFLTP16(16) OIB_DICHT
MOLDENEHUnit for molar density at base conditions ( nat.gas) OIB_MOLDENEHUNIT3T006CUNITMEINS
MOLWEIGHTMolecular weight of natural gas:return value from AGA c-code OIB_MOLWEIGHTFLTP16(16) OIB_MOLWEIGHT
HYDROCARBMOLFRACHydrocarbon mole fraction calculated from AGA c-code OIB_HYDROCARBMOLFRACFLTP16(16) OIB_FRAC
MOLWEIGHTEHUnit for molar mass OIB_MOLWEIGHTEHUNIT3T006CUNITMEINS
CUSTPARCHAR1Customer parameter character field 1 OIB_CUSTPARCHAR1CHAR3OIB_CUSTPARCHAR
CUSTPARFLOAT1Customer parameter float 1 OIB_CUSTPARFLOAT1FLTP16(16) OIB_CUSTPARFLO
CUSTEH1Customer parameter 1 unit OIB_CUSTEH1UNIT3T006CUNITMEINS
CUSTPARCHAR2Customer parameter character field 2 OIB_CUSTPARCHAR2CHAR3OIB_CUSTPARCHAR
CUSTPARFLOAT2Customer parameter float 2 OIB_CUSTPARFLOAT2FLTP16(16) OIB_CUSTPARFLO
CUSTEH2Customer parameter 2 unit OIB_CUSTEH2UNIT3T006CUNITMEINS
CUSTPARCHAR3Customer parameter character field 3 OIB_CUSTPARCHAR3CHAR3OIB_CUSTPARCHAR
CUSTPARFLOAT3Customer parameter float 3 OIB_CUSTPARFLOAT3FLTP16(16) OIB_CUSTPARFLO
CUSTEH3Customer parameter 3 unit OIB_CUSTEH3UNIT3T006CUNITMEINS
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
TNKNRSequence number of SO assigned to business location OII_BSEQNRCHAR10ALPHAOII_SEQNR
DRDATESSR Fuels - local date OIRC_DATUMDATS8DATUM
DRTIMESSR Fuels - Local time OIRC_UZEITTIMS6UZEIT
TIME_ZONESSR Fuels - Service station time zone OIRC_TIMEZONECHAR6Assigned to domainTZNZONE
PR_NUMBERSSR Fuels - Process number OIRC_PR_NUMBERCHAR10CHAR10
WERKSPlant for storage location assignment entry (IS-Oil MRN) OIF_WERKSLCHAR4T001WWERKS
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
RELSTOCKSSR Stocks - related stock at time of tank dip OIRC_RELSTOCKQUAN13(3) MENG13V
QTYPERSSR Stocks - Tolerance Percentage OIRC_QTYPERDEC6(2) PRZ32V
TOL_STATUSSSR Fuels - Tolerance status light OIRC_TOLSTCHAR4CHAR04
MM_QUANSSR Stocks - Difference Quantity OIRC_MM_QUANQUAN13(3) MENG13V
LINKNRLink number OIRA_LINKNRNUMC10NUMC10
ITLINKNRItem link number OIRA_ITLINKNRNUMC6Assigned to domainPOSNR
LINKYEARDocument link number year OIRA_JAHRNUMC4GJAHRGJAHR
CHECK_STATUSSSR Fuels - Status check light OIRC_CHKSTCHAR4CHAR04
ACTSTOCKSSR Stocks - Actual book stock OIRC_ACTSTOCKQUAN13(3) MENG13V
MM_QUAN_POSTEDSSR Stocks - Posted Quantity OIRC_MM_QUAN_POSTEDQUAN13(3) MENG13V
PROC_ONLINESSR Meters - On-line process indicator OIRC_ONLINECHAR1YESNO
PROC_TYPESSR Fuels - Process type OIRC_IND_PROCCHAR1OIRC_IND_PROC
STCODESSR Fuels - Status code OIRC_STCODE_SAPCHAR2Assigned to domainOIRC_STCODE_SAP
BEZEIDescription BEZEI40CHAR40TEXT40
BLOCKSSR Fuels - Indicator that identifies a blocking status OIRC_IND_BLKCHAR1OIRC_IND_BLK
BLOCK_RELEASESSR Fuels - Indicator for blocking status release OIRC_IND_BLKRLSCHAR1OIRC_IND_BLKRLS
USR_INDSSR Fuels - User error indicator OIRC_USR_INDCHAR1YESNO
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!