ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

B1 8.8: Top 10 requests

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry Solution Oil :: Downstream :: Service Station Retailing
1	ERP EHP7	6.0	OIRC_GMMH	64	3	SSR Meters - History	Service Station Retailing

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	GMMNR	GMM: Number of general meter	nvarchar	20	0	Allow NULL?
3	ITMSTM	GMM: Inverse timestamp	decimal	15	0
4	METEV	GMM: History record type	nvarchar	2	0	Allow NULL?
5	MATNR	Material Number	nvarchar	18	0	Allow NULL?
6	MCOUNT	GMM: Meter counter reading	nvarchar	12	0	Allow NULL?
7	CONFAC	GMM: Conversion factor	decimal	10	5
8	BASME	Base UoM of material at event entry	nvarchar	3	0	Allow NULL?
9	MENGE	SSR Fuels - Sales flow quantity	decimal	13	3
10	XMCOUNT	GMM: Previous meter reading	nvarchar	12	0	Allow NULL?
11	XMATNR	GMM: Previous material assigned	nvarchar	18	0	Allow NULL?
12	XCONFAC	GMM: Previous conversion factor	decimal	10	5
13	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
14	PARFN	MRN business partner role / relation type	nvarchar	4	0	Allow NULL?
15	FTMSTM	Start of partner function validity period: time stamp	nvarchar	14	0	Allow NULL?
16	PARPOS	Partner counter	nvarchar	3	0	Allow NULL?
17	TTMSTM	End of partner function validity period - timestamp	nvarchar	14	0	Allow NULL?
18	METREV	SSR: Meter event type	nvarchar	2	0	Allow NULL?
19	SEQNR	GMM: Sequence number of meter assigned to customer	nvarchar	10	0	Allow NULL?
20	PR_NUMBER	SSR Fuels - Process number	nvarchar	10	0	Allow NULL?
21	MRDATE	SSR Fuels - local date	nvarchar	8	0	Allow NULL?
22	MRTIME	SSR Fuels - Local time	nvarchar	6	0	Allow NULL?
23	TIME_ZONE	SSR Fuels - Service station time zone	nvarchar	6	0	Allow NULL?
24	SERVTYP	Service type	nvarchar	4	0	Allow NULL?
25	EQUNR	Equipment number	nvarchar	18	0	Allow NULL?
26	KBETR	SSR Meters - Actual price	decimal	11	2
27	KONWA	Rate unit (currency or percentage)	nvarchar	5	0	Allow NULL?
28	KPEIN	Condition pricing unit	decimal	5	0
29	KMEIN	Condition unit	nvarchar	3	0	Allow NULL?
30	KWERT	Condition value	decimal	13	2
31	XPARFN	MRN business partner role / relation type	nvarchar	4	0	Allow NULL?
32	XFTMSTM	Start of partner function validity period: time stamp	nvarchar	14	0	Allow NULL?
33	XPARPOS	Partner counter	nvarchar	3	0	Allow NULL?
34	XTTMSTM	End of partner function validity period - timestamp	nvarchar	14	0	Allow NULL?
35	XSERVTYP	SSR Meters - Previous service type	nvarchar	4	0	Allow NULL?
36	XKBETR	SSR Meters - Previous condition value	decimal	11	2
37	XKONWA	SSR Meters - Previous condition currency	nvarchar	5	0	Allow NULL?
38	XKPEIN	SSR Meters - Previous condition pricing unit	decimal	5	0
39	XKMEIN	SSR Meters - Previous condition unit	nvarchar	3	0	Allow NULL?
40	XKWERT	SSR Meters - Previous condition value	decimal	13	2
41	VKDAT	SSR PC: Sales date at the service station	nvarchar	8	0	Allow NULL?
42	STATUS_UPDATE	SSR: Indicator to cancel process status update	char	1	0	Allow NULL?
43	LINKNR	Link number	nvarchar	10	0	Allow NULL?
44	ITLINKNR	Item link number	nvarchar	6	0	Allow NULL?
45	LINKYEAR	Document link number year	nvarchar	4	0	Allow NULL?
46	KBETR_TARGET	SSR Pricing - Target price	decimal	11	2
47	KONWA_TARGET	SSR Pricing - Target price currency	nvarchar	5	0	Allow NULL?
48	KPEIN_TARGET	SSR Pricing - Target price pricing unit	decimal	5	0
49	KMEIN_TARGET	SSR Pricing - Target price condition unit	nvarchar	3	0	Allow NULL?
50	ONLINE	SSR Meters - On-line process indicator	char	1	0	Allow NULL?
51	WERKS	Plant	nvarchar	4	0	Allow NULL?
52	LGORT	Storage Location	nvarchar	4	0	Allow NULL?
53	MRDATE_TARGET	SSR Fuels - local date	nvarchar	8	0	Allow NULL?
54	MRTIME_TARGET	SSR Fuels - Local time	nvarchar	6	0	Allow NULL?
55	ERDAT	Date record created	nvarchar	8	0	Allow NULL?
56	ERZEIT	Time record created	nvarchar	6	0	Allow NULL?
57	ERNAM	User who created record	nvarchar	12	0	Allow NULL?
58	AEDAT	Date record changed	nvarchar	8	0	Allow NULL?
59	AEZEIT	Time record changed	nvarchar	6	0	Allow NULL?
60	AENAM	User who changed record	nvarchar	12	0	Allow NULL?
61	BLOIND	Blocking indicator	char	1	0	Allow NULL?
62	DELIND	Deletion indicator	char	1	0	Allow NULL?
63	PBLNR	Business location identifier (IS-Oil MRN)	nvarchar	10	0	Allow NULL?
64	RNBT	Business type	nvarchar	4	0	Allow NULL?

Name	Primary	Unique	Type	Columns
OIRC_GMMH~0	Yes	Yes	CLUSTERED	METEV, ITMSTM, GMMNR, MANDT
OIRC_GMMH~LNK	No	No	NONCLUSTERED	ITLINKNR, LINKNR, LINKYEAR, MANDT
OIRC_GMMH~PBL	No	No	NONCLUSTERED	SERVTYP, MATNR, PBLNR, RNBT, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

64 COLUMNS | 3 INDEXES | ERP 6.0 | OIRC_GMMH TABLE

TOP ERP 6.0 | OIRC_GMMH COLUMNS

TOP ERP 6.0 | OIRC_GMMH INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

64 COLUMNS | 3 INDEXES | ERP 6.0 | OIRC_GMMH TABLE

TOPERP 6.0 | OIRC_GMMH COLUMNS

TOPERP 6.0 | OIRC_GMMH INDEXES

TOP ERP 6.0 | OIRC_GMMH COLUMNS

TOP ERP 6.0 | OIRC_GMMH INDEXES