SAP ABAP Table OIRC_GMMH (SSR Meters - 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_GMMH	Table Relationship Diagram
Short Description	SSR Meters - 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	*
2	GMMNR	☑	OII_GMMNR	OII_GMMNR	CHAR	20	0	GMM: Number of general meter	*
3	ITMSTM	☑	OII_ITMSTM	TZNTSTMPS	DEC	15	0	GMM: Inverse timestamp
4	METEV	☑	OII_METEV	OII_METEV	CHAR	2	0	GMM: History record type	*
5	.INCLUDE	☐				0	0	SSR Meters - Meter history data
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	MCOUNT	☐	OIRC_MCOUNT	OII_MCOUNT	NUMC	12	0	GMM: Meter counter reading
8	CONFAC	☐	OII_CONFAC	OII_CONFAC	DEC	10	5	GMM: Conversion factor
9	BASME	☐	OII_BASME	MEINS	UNIT	3	0	Base UoM of material at event entry	T006
10	MENGE	☐	OIRC_MENGE	MENG13V	QUAN	13	3	SSR Fuels - Sales flow quantity
11	XMCOUNT	☐	OII_XMCOUN	OII_XMCOUN	NUMC	12	0	GMM: Previous meter reading
12	XMATNR	☐	OII_XMATNR	MATNR	CHAR	18	0	GMM: Previous material assigned	MARA
13	XCONFAC	☐	OII_XCONFA	OII_CONFAC	DEC	10	5	GMM: Previous conversion factor
14	.INCLUDE	☐				0	0	SSR Meters - Meter history data extension
15	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
16	PARFN	☐	OIF_PARFN	OIF_PARFN	CHAR	4	0	MRN business partner role / relation type	*
17	FTMSTM	☐	OIF_FTMSTM	OIF_TMSTM	NUMC	14	0	Start of partner function validity period: time stamp
18	PARPOS	☐	OIF_PARPOS	OIF_PARPOS	NUMC	3	0	Partner counter
19	TTMSTM	☐	OIF_TTMSTM	OIF_TMSTM	NUMC	14	0	End of partner function validity period - timestamp
20	METREV	☐	OIRC_METREV	OIRC_METREV	CHAR	2	0	SSR: Meter event type	OIRC_GMME
21	SEQNR	☐	OII_GSEQNR	OII_SEQNR	CHAR	10	0	GMM: Sequence number of meter assigned to customer
22	PR_NUMBER	☐	OIRC_PR_NUMBER	CHAR10	CHAR	10	0	SSR Fuels - Process number
23	MRDATE	☐	OIRC_DATUM	DATUM	DATS	8	0	SSR Fuels - local date
24	MRTIME	☐	OIRC_UZEIT	UZEIT	TIMS	6	0	SSR Fuels - Local time
25	TIME_ZONE	☐	OIRC_TIMEZONE	TZNZONE	CHAR	6	0	SSR Fuels - Service station time zone	*
26	SERVTYP	☐	OIRA_STYP	OIRA_STYP	CHAR	4	0	Service type	*
27	EQUNR	☐	OII_EQUNR	EQUNR	CHAR	18	0	Equipment number	EQUI
28	KBETR	☐	OIRC_KBETR	WERTV6	CURR	11	2	SSR Meters - Actual price
29	KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	TCURC
30	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
31	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
32	KWERT	☐	KWERT	WERTV7	CURR	13	2	Condition Value
33	XPARFN	☐	OIF_PARFN	OIF_PARFN	CHAR	4	0	MRN business partner role / relation type	*
34	XFTMSTM	☐	OIF_FTMSTM	OIF_TMSTM	NUMC	14	0	Start of partner function validity period: time stamp
35	XPARPOS	☐	OIF_PARPOS	OIF_PARPOS	NUMC	3	0	Partner counter
36	XTTMSTM	☐	OIF_TTMSTM	OIF_TMSTM	NUMC	14	0	End of partner function validity period - timestamp
37	XSERVTYP	☐	OIRC_XSTYP	OIRA_STYP	CHAR	4	0	SSR Meters - Previous service type	*
38	XKBETR	☐	OIRC_XKBETR	WERTV6	CURR	11	2	SSR Meters - Previous condition value
39	XKONWA	☐	OIRC_XKONWA	WAERS	CUKY	5	0	SSR Meters - Previous condition currency	*
40	XKPEIN	☐	OIRC_XKPEIN	KPEIN	DEC	5	0	SSR Meters - Previous condition pricing unit
41	XKMEIN	☐	OIRC_XKMEIN	MEINS	UNIT	3	0	SSR Meters - Previous condition unit	*
42	XKWERT	☐	OIRC_XKWERT	WERTV7	CURR	13	2	SSR Meters - Previous condition value
43	VKDAT	☐	OIRE_VKDAT	DATS	DATS	8	0	SSR PC: Sales date at the service station
44	STATUS_UPDATE	☐	OIRA_SKIP_ST_UPD	XFELD	CHAR	1	0	SSR: Indicator to cancel process status update
45	LINKNR	☐	OIRA_LINKNR	NUMC10	NUMC	10	0	Link number
46	ITLINKNR	☐	OIRA_ITLINKNR	POSNR	NUMC	6	0	Item link number	*
47	LINKYEAR	☐	OIRA_JAHR	GJAHR	NUMC	4	0	Document link number year
48	KBETR_TARGET	☐	OIRC_KBETR_TARGET	WERTV6	CURR	11	2	SSR Pricing - Target price
49	KONWA_TARGET	☐	OIRC_KONWA_TARGET	WAERS	CUKY	5	0	SSR Pricing - Target price currency	*
50	KPEIN_TARGET	☐	OIRC_KPEIN_TARGET	KPEIN	DEC	5	0	SSR Pricing - Target price pricing unit
51	KMEIN_TARGET	☐	OIRC_KMEIN_TARGET	MEINS	UNIT	3	0	SSR Pricing - Target price condition unit	*
52	ONLINE	☐	OIRC_ONLINE	YESNO	CHAR	1	0	SSR Meters - On-line process indicator
53	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
54	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
55	MRDATE_TARGET	☐	OIRC_DATUM	DATUM	DATS	8	0	SSR Fuels - local date
56	MRTIME_TARGET	☐	OIRC_UZEIT	UZEIT	TIMS	6	0	SSR Fuels - Local time
57	.INCLUDE	☐				0	0	Standard status field set (BDRP)
58	ERDAT	☐	OII_ERDAT	DATS	DATS	8	0	Date record created
59	ERZEIT	☐	OII_ERZEIT	TIME	TIMS	6	0	Time record created
60	ERNAM	☐	OII_ERNAM	USNAM	CHAR	12	0	User who created record
61	AEDAT	☐	OII_AEDAT	DATS	DATS	8	0	Date record changed
62	AEZEIT	☐	OII_AEZEIT	TIME	TIMS	6	0	Time record changed
63	AENAM	☐	OII_AENAM	USNAM	CHAR	12	0	User who changed record
64	BLOIND	☐	OII_BLOIND	XFELD	CHAR	1	0	Blocking indicator
65	DELIND	☐	OII_DELIND	XFELD	CHAR	1	0	Deletion indicator
66	.INCLUDE	☐				0	0	SSR Fuels - History data extension - Alternative key
67	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
68	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_GMMH	BASME	T006	MSEHI
2	OIRC_GMMH	EQUNR	EQUI	EQUNR
3	OIRC_GMMH	KMEIN	T006	MSEHI
4	OIRC_GMMH	KONWA	TCURC	WAERS
5	OIRC_GMMH	MATNR	MARA	MATNR
6	OIRC_GMMH	METREV	OIRC_GMME	METREV	REF	1	CN
7	OIRC_GMMH	XMATNR	MARA	MATNR

History

Last changed by/on	SAP	20110901
SAP Release Created in