SAP ABAP Table ROIRC_DRUPLD (SSR Stocks - Dip readings upload structure)

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	INTTAB	Structure
Structure	ROIRC_DRUPLD	Table Relationship Diagram
Short Description	SSR Stocks - Dip readings upload structure

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in