SAP ABAP Table OIRC_SOCDIP (SSR Stocks - Dip readings history)

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_SOCDIP	Table Relationship Diagram
Short Description	SSR Stocks - Dip readings history

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in