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

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C