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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Utilities :: Device Management :: Meter Reading
1	ERP EHP7	6.0	EABL	82	4	MR Document	Meter Reading

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	ABLBELNR	Internal ID for meter reading document	nvarchar	20	0	Allow NULL?
3	GERNR	Device	nvarchar	18	0	Allow NULL?
4	EQUNR	Equipment Number	nvarchar	18	0	Allow NULL?
5	ZWNUMMER	Register	nvarchar	3	0	Allow NULL?
6	ADAT	Meter reading date relevant to billing	nvarchar	8	0	Allow NULL?
7	ATIM	Meter reading time (relevant to billing)	nvarchar	4	0	Allow NULL?
8	V_ZWSTAND	Places Before Decimal Point in Meter Reading	decimal	17	0
9	N_ZWSTAND	Places After Decimal Point in the Meter Reading	decimal	14	14
10	V_ZWSTNDAB	Predecimal Places in Billed Meter Reading	decimal	17	0
11	N_ZWSTNDAB	Decimal Places in the Billed Meter Reading	decimal	14	14
12	MASSREAD	Unit of measurement for meter reading	nvarchar	3	0	Allow NULL?
13	MASSBILL	Unit of measurement for billing	nvarchar	3	0	Allow NULL?
14	STANZVOR	Number of predecimal places for register	nvarchar	2	0	Allow NULL?
15	STANZNAC	Number of decimal places for register	nvarchar	2	0	Allow NULL?
16	SCHAEVER	Estimation procedure	nvarchar	2	0	Allow NULL?
17	SCHAEGR	Estimation reason	nvarchar	2	0	Allow NULL?
18	AKTIV	Meter reading active	char	1	0	Allow NULL?
19	ADATSOLL	Scheduled meter reading date	nvarchar	8	0	Allow NULL?
20	ADATMAX	Date of maximum meter reading	nvarchar	8	0	Allow NULL?
21	ATIMMAX	Time of maximum meter reading	nvarchar	4	0	Allow NULL?
22	ADATTATS	Actual meter reading date	nvarchar	8	0	Allow NULL?
23	ATIMTATS	Actual meter reading time	nvarchar	4	0	Allow NULL?
24	ADATERZ	Meter reading date of implausible meter reading result	nvarchar	8	0	Allow NULL?
25	ATIMERZ	Meter reading time of implausible meter reading result	nvarchar	4	0	Allow NULL?
26	ADATPROG	Meter reading date from which forecast is made	nvarchar	8	0	Allow NULL?
27	ATIMPROG	Meter reading time from which consumption is determined	nvarchar	4	0	Allow NULL?
28	ZUORDDAT	Meter reading allocation date	nvarchar	8	0	Allow NULL?
29	THGDATUM	Gas allocation date	nvarchar	8	0	Allow NULL?
30	PRUEFZAHL	Check number	nvarchar	2	0	Allow NULL?
31	BAPERTYP	Base period category	char	1	0	Allow NULL?
32	ABLSTAT	Meter Reading Status	char	1	0	Allow NULL?
33	PRUEFPKT	Independent validation	nvarchar	2	0	Allow NULL?
34	POPCODE	Dependent validation	nvarchar	2	0	Allow NULL?
35	PRUEFTYP	Validation category for meter readings	char	1	0	Allow NULL?
36	ABLHINW	Note from meter reader	nvarchar	4	0	Allow NULL?
37	STABLHW	Control of follow-up action for MR result with MR note	nvarchar	2	0	Allow NULL?
38	KONTRVRF	Indicator: dummy record from automatic control procedure	char	1	0	Allow NULL?
39	ABLESART	Scheduled meter reading category	nvarchar	2	0	Allow NULL?
40	ABLESER	Meter reader number	nvarchar	3	0	Allow NULL?
41	NACHERF	Meter reading result inserted or modified	char	1	0	Allow NULL?
42	MDENR	Number for mobile data entry (MDE)	nvarchar	3	0	Allow NULL?
43	MDEUPL	Order has been output	char	1	0	Allow NULL?
44	E_ZEITVBL	Multiple meter reading order creation	char	1	0	Allow NULL?
45	E_ZVLZUORD	Multiple allocation	nvarchar	3	0	Allow NULL?
46	STEUERGRP	Control group for multiple meter reading order creation	nvarchar	4	0	Allow NULL?
47	ARBAUF	Control Meter Reading Order ID Printed	char	1	0	Allow NULL?
48	KSTATUS	Status for automatic monitoring of meter reading order	char	1	0	Allow NULL?
49	ERDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
50	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
51	AEDAT	Changed On	nvarchar	8	0	Allow NULL?
52	AENAM	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
53	ENTRYNUMB	Entry number for fast entry	nvarchar	8	0	Allow NULL?
54	ACTOR	Concatenated Identification (Type and ID) of Org.Objects	nvarchar	14	0	Allow NULL?
55	ISTABLART	Meter reading type	nvarchar	2	0	Allow NULL?
56	ABLESTYP	Meter reading category	nvarchar	2	0	Allow NULL?
57	E_ZVBL_BEZDAT	Scheduled meter reading date for base meter reading	nvarchar	8	0	Allow NULL?
58	SM_AUFNR	Service order or notification	nvarchar	12	0	Allow NULL?
59	DOC_TYPE	Document category for plant maintenance and customer service	char	1	0	Allow NULL?
60	ADATREAL	[JBP] Real Meter Reading Date	nvarchar	8	0	Allow NULL?
61	ATIMREAL	[JBP] Real Meter Reading Time	nvarchar	4	0	Allow NULL?
62	S_ISTABLART	[JBP] Meter Reading Type for Original Meter Reading	nvarchar	2	0	Allow NULL?
63	S_AKTIV	[JBP] Orig. Meter Reading: Meter Reading Active	char	1	0	Allow NULL?
64	S_ABLSTAT	[JBP] Original Meter Reading Status	char	1	0	Allow NULL?
65	S_V_ZWSTAND	[JBP] Orig. MR: Decimal Places Before Meter reading	decimal	17	0
66	S_N_ZWSTAND	[JBP] Decimal Places of Meter Readings for Original MR	decimal	14	14
67	S_V_ZWSTNDAB	[JBP] Predecimal Places of Billed MR for Original MR	decimal	17	0
68	S_N_ZWSTNDAB	[JBP] Decimal Places of Billed Orginal Meter Reading	decimal	14	14
69	REMOVED	[JBP] Status Indicator: MR Result Suppressed	char	1	0	Allow NULL?
70	BP	Selection of Billing Period: Standard or JBP	char	1	0	Allow NULL?
71	REM_ABLBELNR	[JBP] Suppressed MR Document Number	nvarchar	20	0	Allow NULL?
72	REM_ABLESER	Meter Reader Number of Suppressed Meter Reading	nvarchar	3	0	Allow NULL?
73	S_ADATSOLL	Scheduled meter reading date	nvarchar	8	0	Allow NULL?
74	S_ZVBL_BEZDAT	Scheduled meter reading date for base meter reading	nvarchar	8	0	Allow NULL?
75	AMS	Advanced Metering System	nvarchar	4	0	Allow NULL?
76	TRANSSTAT	Transfer Status Code	nvarchar	5	0	Allow NULL?
77	TRANSTSTAMP	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
78	SOURCESYST	Source System From Which Data is Requested	char	1	0	Allow NULL?
79	QNT	Quantity Determined from Meter Reading in Internal Format	decimal	31	14
80	QDSTAT	Status of Quantity Determination	nvarchar	2	0	Allow NULL?
81	QDPROC	Qty Determination Procedure During Meter Reading / Billing	nvarchar	2	0	Allow NULL?
82	PREV_MRDOC	Internal ID of Previous Meter Reading Result Document	nvarchar	20	0	Allow NULL?

Name	Primary	Unique	Type	Columns
EABL~0	Yes	Yes	CLUSTERED	ABLBELNR, MANDT
EABL~ECL	No	No	NONCLUSTERED	ACTOR, MANDT
EABL~ENU	No	No	NONCLUSTERED	ENTRYNUMB, ADATSOLL, MANDT
EABL~EQN	No	No	NONCLUSTERED	ABLSTAT, ZWNUMMER, EQUNR, 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

82 COLUMNS | 4 INDEXES | ERP 6.0 | EABL TABLE

TOP ERP 6.0 | EABL COLUMNS

TOP ERP 6.0 | EABL 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

82 COLUMNS | 4 INDEXES | ERP 6.0 | EABL TABLE

TOPERP 6.0 | EABL COLUMNS

TOPERP 6.0 | EABL INDEXES

TOP ERP 6.0 | EABL COLUMNS

TOP ERP 6.0 | EABL INDEXES