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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in