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

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
     ⤷ OIR_C (Package) SSR Fuels processing (IS-Oil Sevice Station Retailing)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIRC_DRREJ	Table Relationship Diagram
Short Description	SSR Stocks - Dip readings rejected records

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PBLNR	☑	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
3	RNBT	☑	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRARNBT
4	REC_SEQNR	☑	OIRC_SEQNR	OIRC_SEQNR	NUMC	5	0	SSR Fuels - Sequential number
5	.INCLUDE	☐				0	0	SSR Stocks - Dip readings rejected records
6	SOCNR	☐	OII_SOCNR	OII_SOCNR	CHAR	20	0	SOC: Storage object characteristic segment number	OIISOCK
7	ETMSTM	☐	OIRC_TMSTM	TZNTSTMPS	DEC	15	0	SSR Stocks - Tank dip time stamp
8	SOCEV	☐	OII_SOCEV	OII_SOCEV	CHAR	2	0	SOC event	OIISOCE
9	.INCLUDE	☐				0	0	SSR Stocks - Dip readings maintenance structure
10	.INCLUDE	☐				0	0	Tank strapping history structure
11	SLVNR	☐	OII_SLVNR	OII_SLVNR	CHAR	20	0	SOC: Linear/volumetric conversion (strap) set number	*
12	SLVIND	☐	OII_SLVIND	OII_SLVIND	NUMC	5	0	SOC: recalibration index for strapping data
13	TOTALHEIGHT	☐	OII_TOTALHEIGHT	MENGE	QUAN	13	3	Tank dip, total height
14	TOTALHEIGHT_FLTP	☐	OII_HGT_FLTP	TEMP_VALUE	FLTP	16	16	Silo Mgmt: Tank strapping height in FLTP
15	WATERHEIGHT	☐	OII_WATERHEIGHT	MENGE	QUAN	13	3	Tank dip: water dip height
16	WATERHEIGHT_FLTP	☐	OII_HGT_FLTP	TEMP_VALUE	FLTP	16	16	Silo Mgmt: Tank strapping height in FLTP
17	MDICH	☐	OII_MATDENS	MENGE	QUAN	13	3	Material density (at ambient temperature)
18	DNSUN	☐	OII_DNSUN	MEINS	UNIT	3	0	Density UoM (Oil product/Silo)	*
19	QUAN_SKU	☐	OII_QUAN_SKU	MENGE	QUAN	13	3	Quantity in stock keeping unit/ base unit of measure
20	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	QUAN_LVC	☐	OII_QUAN_LVC	MENGE	QUAN	13	3	Material volume in LVC set UoM
22	WATR_LVC	☐	OII_WATR_LVC	MENGE	QUAN	13	3	Water Volume in LVC set UoM
23	SHTMP	☐	OII_STTMP	TEMP_VALUE	FLTP	16	16	Silo shell temperature
24	SHTEH	☐	OII_STTEH	MEINS	UNIT	3	0	Silo shell temperature unit	*
25	UL_IN_IND	☐	OII_UL_IN_IND	OII_UL_IN_IND	CHAR	1	0	Dipping method (innage, ullage)
26	.INCLUDE	☐				0	0	Unit of measure set - lin/vol conversion (BDRP)
27	VOLUN	☐	OII_VOLUNC	MEINS	UNIT	3	0	UoM - volumetric constant for lin./vol. conversion (BDRP)	*
28	LENUN	☐	OII_LENUNC	MEINS	UNIT	3	0	UoM - linear constant for lin./vol. conversion (BDRP)	*
29	.INCLUDE	☐				0	0	Quantity conversion interface - base parameters
30	UMRSL	☐	OIB_UMRSL	OIB_UMRSL	CHAR	4	0	Conversion Group (Oil, Natural Gas,..)	OIB01
31	CMODE	☐	OIB_CMODE	OIB_CMODE	CHAR	1	0	Conversion Mode
32	FDICHEH	☐	OIB_BDNEH	MEINS	UNIT	3	0	Unit for densities at standard/base conditions	T006
33	FDICH	☐	OIB_FDICH	OIB_DICHT	FLTP	16	16	Fixed Density
34	COEFF	☐	OIB_COEFF	OIB_COEFF	FLTP	16	16	Quantity Conversion Coefficient
35	BDICHEH	☐	OIB_BDNEH	MEINS	UNIT	3	0	Unit for densities at standard/base conditions	T006
36	BDICH	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
37	BHVALEH	☐	OIB_BHVEH	MEINS	UNIT	3	0	Heating value unit at standard/base conditions (natural gas)	T006
38	BHVAL	☐	OIB_BHVAL	OIB_HVAL	FLTP	16	16	Heating value at standard/base conditions (natural gas)
39	.INCLUDE	☐				0	0	Quantity conversion interface - conversion parameters
40	TSTMP	☐	OIB_TSTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Test Temperature: Observed Density
41	TSTEH	☐	OIB_TSTEH	MEINS	UNIT	3	0	Test Temperature Unit (Density): Measurement	T006
42	MTTMP	☐	OIB_MTTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Material Temperature: Observed Quantity
43	MTTEH	☐	OIB_MTTEH	MEINS	UNIT	3	0	Oil/Gas Material Temperature Unit: Observed Quantity	T006
44	THVAL	☐	OIB_THVAL	OIB_HVAL	FLTP	16	16	Heating value at test conditions (natural gas): observed
45	TDICHEH	☐	OIB_DNEH	MEINS	UNIT	3	0	Unit for densities of petroleum products and natural gas	T006
46	TDICH	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
47	MTPRES	☐	OIB_MTPRES	OIB_PRES	FLTP	16	16	Oil/gas material pressure: observed quantity
48	MTPRESEH	☐	OIB_MTPRESEH	MEINS	UNIT	3	0	Oil/gas material pressure unit: observed quantity	T006
49	TPRED	☐	OIB_TPRED	OIB_PRES	FLTP	16	16	Oil/gas test pressure: metering (obs. density)
50	TPREDEH	☐	OIB_TPREDEH	MEINS	UNIT	3	0	Oil/Gas test press. unit: metering (density)	T006
51	TPRHV	☐	OIB_TPRHV	OIB_PRES	FLTP	16	16	Natural gas test pressure: combustion (obs. heating value )
52	TPRHVEH	☐	OIB_TPRHVEH	MEINS	UNIT	3	0	Natural gas test pressure unit: combustion ( heating value )	T006
53	TTMPHV	☐	OIB_TTMPHV	TEMP_VALUE	FLTP	16	16	Natural gas test temperature: combustion (obs. heat. value )
54	TTMPHVEH	☐	OIB_TTMPHVEH	MEINS	UNIT	3	0	Natural gas test temp. unit: combustion (heating value)	T006
55	ATPRES	☐	OIB_ATPRES	OIB_PRES	FLTP	16	16	Atmospheric pressure of the air surrounding a product
56	ATPRESEH	☐	OIB_ATPRESEH	MEINS	UNIT	3	0	Atmospheric pressure unit	T006
57	VAPRES	☐	OIB_VAPRES	OIB_PRES	FLTP	16	16	Vapor pressure of liquid petroleum gases (LPG)
58	VAPRESEH	☐	OIB_VAPRESEH	MEINS	UNIT	3	0	Vapor pressure unit (LPG)	T006
59	THVALEH	☐	OIB_HVEH	MEINS	UNIT	3	0	Heating value unit	T006
60	MTCOMBTMP	☐	OIB_MTCOMBTMP	TEMP_VALUE	FLTP	16	16	Natural gas material combustion temp.: observed quantity
61	MTCOMBTEH	☐	OIB_MTCOMBTEH	MEINS	UNIT	3	0	Natural gas material combustion temp. unit: obs. quantity	T006
62	MTCOMBPRES	☐	OIB_MTCOMBPRES	OIB_PRES	FLTP	16	16	Natural gas material combustion pressure: observed quantity
63	MTCOMBPRESEH	☐	OIB_MTCOMBPRESEH	MEINS	UNIT	3	0	Natural gas material combustion pres. unit: oberved quantity	T006
64	TSTMPCAL	☐	OIB_TSTMPCAL	TEMP_VALUE	FLTP	16	16	Natural gas: Calorimeter test temperature (density)
65	TSTMPCALEH	☐	OIB_TSTMPCALEH	MEINS	UNIT	3	0	Natural gas: unit for calorimeter test temperature (density)	T006
66	TPREDCAL	☐	OIB_TPREDCAL	OIB_PRES	FLTP	16	16	Natural gas: Calorimeter test pressure (density)
67	TPREDCALEH	☐	OIB_TPREDCALEH	MEINS	UNIT	3	0	Natural gas: Unit for calorimeter test pressure (density)	T006
68	.INCLUDE	☐				0	0	Quantity conversion interface - other parts
69	HYDRO	☐	OIB_HYDRO	OIB_XFELD	CHAR	1	0	Hydrometer Correction Indicator
70	ABIND	☐	OIB_ABIND	OIB_XFELD	CHAR	1	0	Air Bouyancy Indicator
71	ABFAC	☐	OIB_ABFAC	OIB_ABFAC	DEC	3	1	Air Bouyancy Factor
72	MCF	☐	OIB_MCF1	OIB_VCF	FLTP	16	16	Meter correction factor
73	BSWCN	☐	OIB_BSWCN	OIB_BSWCN	FLTP	16	16	BSW %
74	BSWCNEH	☐	OIB_BSWCNEH	MEINS	UNIT	3	0	BSW % unit (volume %, mol %, mass % or proportion )	T006
75	HVCLS	☐	OIB_HVCLS	OIB_HVCLS	CHAR	2	0	Heating value class (calorific value class)
76	HVCLS_TO	☐	OIB_HVCLS	OIB_HVCLS	CHAR	2	0	Heating value class (calorific value class)
77	DEFAULT_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
78	.INCLUDE	☐				0	0	Standard status field set (BDRP)
79	ERDAT	☐	OII_ERDAT	DATS	DATS	8	0	Date record created
80	ERZEIT	☐	OII_ERZEIT	TIME	TIMS	6	0	Time record created
81	ERNAM	☐	OII_ERNAM	USNAM	CHAR	12	0	User who created record
82	AEDAT	☐	OII_AEDAT	DATS	DATS	8	0	Date record changed
83	AEZEIT	☐	OII_AEZEIT	TIME	TIMS	6	0	Time record changed
84	AENAM	☐	OII_AENAM	USNAM	CHAR	12	0	User who changed record
85	BLOIND	☐	OII_BLOIND	XFELD	CHAR	1	0	Blocking indicator
86	DELIND	☐	OII_DELIND	XFELD	CHAR	1	0	Deletion indicator
87	.INCLUDE	☐				0	0	HPM:QCI:chemical analysis data for natural gas (ISO comp.)
88	CH4RATIO	☐	OIB_CH4RAT	OIB_RAT	FLTP	16	16	Natural gas CH4 content (ratio)
89	N2RATIO	☐	OIB_N2RAT	OIB_RAT	FLTP	16	16	Natural gas N2 (nitrogen) content (ratio)
90	CO2RATIO	☐	OIB_CO2RAT	OIB_RAT	FLTP	16	16	Natural gas CO2 content (ratio)
91	C2H6RATIO	☐	OIB_C2H6RAT	OIB_RAT	FLTP	16	16	Natural gas C2H6 (ethane) content (ratio)
92	C3H8RATIO	☐	OIB_C3H8RAT	OIB_RAT	FLTP	16	16	Natural gas C3H8 (propane) content (ratio)
93	H2ORATIO	☐	OIB_H2ORAT	OIB_RAT	FLTP	16	16	Natural gas H2O content (ratio)
94	H2SRATIO	☐	OIB_H2SRAT	OIB_RAT	FLTP	16	16	Natural gas H2S content (ratio)
95	H2RATIO	☐	OIB_H2RAT	OIB_RAT	FLTP	16	16	Natural gas H2 (Hydrogen) content (ratio)
96	CORATIO	☐	OIB_CORAT	OIB_RAT	FLTP	16	16	Natural gas CO content (ratio)
97	O2RATIO	☐	OIB_O2RAT	OIB_RAT	FLTP	16	16	Natural gas oxygen (O2) content (ratio)
98	ISOC4H10RATIO	☐	OIB_ISOC4H10RAT	OIB_RAT	FLTP	16	16	Natural gas ISO-C4H10 (iso-butane ) content (ratio)
99	NC4H10RATIO	☐	OIB_NC4H10RAT	OIB_RAT	FLTP	16	16	Natural gas n-C4H10 (n-butane ) content (ratio)
100	ISOC5H12RATIO	☐	OIB_ISOC5H12RAT	OIB_RAT	FLTP	16	16	Natural gas ISO-C5H12 (ISO-pentane ) content (ratio)
101	NC5H12RATIO	☐	OIB_NC5H12RAT	OIB_RAT	FLTP	16	16	Natural gas n-C5H12 (n-pentane ) content (ratio)
102	C6H14RATIO	☐	OIB_C6H14RAT	OIB_RAT	FLTP	16	16	Natural gas C6H14 (n-hexane ) content (ratio)
103	C7H16RATIO	☐	OIB_C7H16RAT	OIB_RAT	FLTP	16	16	Natural gas C7H16 (n-heptane ) content (ratio)
104	C8H18RATIO	☐	OIB_C8H18RAT	OIB_RAT	FLTP	16	16	Natural gas C8H18 (n-octane ) content (ratio)
105	C9H20RATIO	☐	OIB_C9H20RAT	OIB_RAT	FLTP	16	16	Natural gas C9H20 (n-Nonane ) content (ratio)
106	C10H22RATIO	☐	OIB_C10H22RAT	OIB_RAT	FLTP	16	16	Natural gas C10H22 (n-Decane ) content (ratio)
107	HERATIO	☐	OIB_HERAT	OIB_RAT	FLTP	16	16	Natural gas He (Helium) content (ratio)
108	ARRATIO	☐	OIB_ARRAT	OIB_RAT	FLTP	16	16	Natural gas Argon content (ratio)
109	GASCOMPRATEH	☐	OIB_GASCOMPRATEH	MEINS	UNIT	3	0	Unit (vol. %, mol % or mass % ) of natural gas composition	T006
110	MOLDEN	☐	OIB_MOLDEN	OIB_DICHT	FLTP	16	16	Natural gas molar density (mol/volume) at standard condition
111	MOLDENEH	☐	OIB_MOLDENEH	MEINS	UNIT	3	0	Unit for molar density at base conditions ( nat.gas)	T006
112	MOLWEIGHT	☐	OIB_MOLWEIGHT	OIB_MOLWEIGHT	FLTP	16	16	Molecular weight of natural gas:return value from AGA c-code
113	HYDROCARBMOLFRAC	☐	OIB_HYDROCARBMOLFRAC	OIB_FRAC	FLTP	16	16	Hydrocarbon mole fraction calculated from AGA c-code
114	MOLWEIGHTEH	☐	OIB_MOLWEIGHTEH	MEINS	UNIT	3	0	Unit for molar mass	T006
115	.INCLUDE	☐				0	0	Strcuture for QCI parameters: customer defined fields
116	CUSTPARCHAR1	☐	OIB_CUSTPARCHAR1	OIB_CUSTPARCHAR	CHAR	3	0	Customer parameter character field 1
117	CUSTPARFLOAT1	☐	OIB_CUSTPARFLOAT1	OIB_CUSTPARFLO	FLTP	16	16	Customer parameter float 1
118	CUSTEH1	☐	OIB_CUSTEH1	MEINS	UNIT	3	0	Customer parameter 1 unit	T006
119	CUSTPARCHAR2	☐	OIB_CUSTPARCHAR2	OIB_CUSTPARCHAR	CHAR	3	0	Customer parameter character field 2
120	CUSTPARFLOAT2	☐	OIB_CUSTPARFLOAT2	OIB_CUSTPARFLO	FLTP	16	16	Customer parameter float 2
121	CUSTEH2	☐	OIB_CUSTEH2	MEINS	UNIT	3	0	Customer parameter 2 unit	T006
122	CUSTPARCHAR3	☐	OIB_CUSTPARCHAR3	OIB_CUSTPARCHAR	CHAR	3	0	Customer parameter character field 3
123	CUSTPARFLOAT3	☐	OIB_CUSTPARFLOAT3	OIB_CUSTPARFLO	FLTP	16	16	Customer parameter float 3
124	CUSTEH3	☐	OIB_CUSTEH3	MEINS	UNIT	3	0	Customer parameter 3 unit	T006
125	.INCLUDE	☐				0	0	SSR Stocks - Dip readings maintenance (SSR fields)
126	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
127	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
128	TNKNR	☐	OII_BSEQNR	OII_SEQNR	CHAR	10	0	Sequence number of SO assigned to business location
129	DRDATE	☐	OIRC_DATUM	DATUM	DATS	8	0	SSR Fuels - local date
130	DRTIME	☐	OIRC_UZEIT	UZEIT	TIMS	6	0	SSR Fuels - Local time
131	TIME_ZONE	☐	OIRC_TIMEZONE	TZNZONE	CHAR	6	0	SSR Fuels - Service station time zone	*
132	PR_NUMBER	☐	OIRC_PR_NUMBER	CHAR10	CHAR	10	0	SSR Fuels - Process number
133	WERKS	☐	OIF_WERKSL	WERKS	CHAR	4	0	Plant for storage location assignment entry (IS-Oil MRN)	T001W
134	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
135	RELSTOCK	☐	OIRC_RELSTOCK	MENG13V	QUAN	13	3	SSR Stocks - related stock at time of tank dip
136	QTYPER	☐	OIRC_QTYPER	PRZ32V	DEC	6	2	SSR Stocks - Tolerance Percentage
137	TOL_STATUS	☐	OIRC_TOLST	CHAR04	CHAR	4	0	SSR Fuels - Tolerance status light
138	MM_QUAN	☐	OIRC_MM_QUAN	MENG13V	QUAN	13	3	SSR Stocks - Difference Quantity
139	LINKNR	☐	OIRA_LINKNR	NUMC10	NUMC	10	0	Link number
140	ITLINKNR	☐	OIRA_ITLINKNR	POSNR	NUMC	6	0	Item link number	*
141	LINKYEAR	☐	OIRA_JAHR	GJAHR	NUMC	4	0	Document link number year
142	CHECK_STATUS	☐	OIRC_CHKST	CHAR04	CHAR	4	0	SSR Fuels - Status check light
143	ACTSTOCK	☐	OIRC_ACTSTOCK	MENG13V	QUAN	13	3	SSR Stocks - Actual book stock
144	MM_QUAN_POSTED	☐	OIRC_MM_QUAN_POSTED	MENG13V	QUAN	13	3	SSR Stocks - Posted Quantity
145	PROC_ONLINE	☐	OIRC_ONLINE	YESNO	CHAR	1	0	SSR Meters - On-line process indicator
146	PROC_TYPE	☐	OIRC_IND_PROC	OIRC_IND_PROC	CHAR	1	0	SSR Fuels - Process type
147	STCODE	☐	OIRC_STCODE_SAP	OIRC_STCODE_SAP	CHAR	2	0	SSR Fuels - Status code	*
148	BEZEI	☐	BEZEI40	TEXT40	CHAR	40	0	Description
149	BLOCK	☐	OIRC_IND_BLK	OIRC_IND_BLK	CHAR	1	0	SSR Fuels - Indicator that identifies a blocking status
150	BLOCK_RELEASE	☐	OIRC_IND_BLKRLS	OIRC_IND_BLKRLS	CHAR	1	0	SSR Fuels - Indicator for blocking status release
151	USR_IND	☐	OIRC_USR_IND	YESNO	CHAR	1	0	SSR Fuels - User error indicator
152	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIRC_DRREJ	ATPRESEH	T006	MSEHI
2	OIRC_DRREJ	BDICHEH	T006	MSEHI
3	OIRC_DRREJ	BHVALEH	T006	MSEHI
4	OIRC_DRREJ	BSWCNEH	T006	MSEHI
5	OIRC_DRREJ	CUSTEH1	T006	MSEHI
6	OIRC_DRREJ	CUSTEH2	T006	MSEHI
7	OIRC_DRREJ	CUSTEH3	T006	MSEHI
8	OIRC_DRREJ	FDICHEH	T006	MSEHI
9	OIRC_DRREJ	GASCOMPRATEH	T006	MSEHI
10	OIRC_DRREJ	LGORT	T001L	LGORT
11	OIRC_DRREJ	MEINS	T006	MSEHI
12	OIRC_DRREJ	MOLDENEH	T006	MSEHI
13	OIRC_DRREJ	MOLWEIGHTEH	T006	MSEHI
14	OIRC_DRREJ	MTCOMBPRESEH	T006	MSEHI
15	OIRC_DRREJ	MTCOMBTEH	T006	MSEHI
16	OIRC_DRREJ	MTPRESEH	T006	MSEHI
17	OIRC_DRREJ	MTTEH	T006	MSEHI
18	OIRC_DRREJ	PBLNR	OIFSPBL	PBLNR
19	OIRC_DRREJ	RNBT	OIRARNBT	RNBT
20	OIRC_DRREJ	SOCEV	OIISOCE	SOCEV
21	OIRC_DRREJ	SOCNR	OIISOCK	SOCNR
22	OIRC_DRREJ	TDICHEH	T006	MSEHI
23	OIRC_DRREJ	THVALEH	T006	MSEHI
24	OIRC_DRREJ	TPREDCALEH	T006	MSEHI
25	OIRC_DRREJ	TPREDEH	T006	MSEHI
26	OIRC_DRREJ	TPRHVEH	T006	MSEHI
27	OIRC_DRREJ	TSTEH	T006	MSEHI
28	OIRC_DRREJ	TSTMPCALEH	T006	MSEHI
29	OIRC_DRREJ	TTMPHVEH	T006	MSEHI
30	OIRC_DRREJ	UMRSL	OIB01	UMRSL
31	OIRC_DRREJ	VAPRESEH	T006	MSEHI
32	OIRC_DRREJ	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in