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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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 :: Master Data
1	ERP EHP7	6.0	EVER	94	6	IS-U Cont.	Master Data

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	VERTRAG	Contract	nvarchar	10	Allow NULL?
3	BUKRS	Company Code	nvarchar	4	Allow NULL?
4	SPARTE	Division	nvarchar	2	Allow NULL?
5	EIGENVERBR	Plant or company consumption	char	1	Allow NULL?
6	KOFIZ	Account determination ID for IS-U contracts	nvarchar	2	Allow NULL?
7	PORTION	Alternative portion	nvarchar	8	Allow NULL?
8	ABSLANFO	Budget billing request for debtor	char	1	Allow NULL?
9	ABSZYK	Overrriding BB cycle on contract level	nvarchar	2	Allow NULL?
10	ABSMNANP	Do not adjust budget billing amount automatically	char	1	Allow NULL?
11	GEMFAKT	Invoice Contracts Jointly (Mandatory Contracts)	char	1	Allow NULL?
12	MANABR	Bill contract manually	char	1	Allow NULL?
13	ABRSPERR	Reason for blocking billing	nvarchar	2	Allow NULL?
14	ABRFREIG	Reason for releasing billing	nvarchar	2	Allow NULL?
15	BSTATUS	Processing status	nvarchar	2	Allow NULL?
16	KOSTL	Cost Center	nvarchar	10	Allow NULL?
17	VBEZ	Text for contract	nvarchar	35	Allow NULL?
18	VBEGINN	Start of contract	nvarchar	8	Allow NULL?
19	EINZDAT_ALT	Move-in date from legacy system	nvarchar	8	Allow NULL?
20	VENDE	End of contract	nvarchar	8	Allow NULL?
21	KUENDDAT	Cancellation date of contract	nvarchar	8	Allow NULL?
22	KFRIST	Number of time units for cancellation	nvarchar	3	Allow NULL?
23	KUENPER	Time unit for cancellation	char	1	Allow NULL?
24	VBISDAT	Renewal date of contract	nvarchar	8	Allow NULL?
25	VERLAENG	Number of time units for renewal	nvarchar	3	Allow NULL?
26	VERPER	Time unit for renewal	char	1	Allow NULL?
27	VABSCHLEVU	Date on which utility concluded the contract	nvarchar	8	Allow NULL?
28	VABSCHLKND	Date on which customer concluded the contract	nvarchar	8	Allow NULL?
29	VABSCHLKNDTI	Time at which customer signed contract	nvarchar	6	Allow NULL?
30	PERSNR	Personnel Number	nvarchar	8	Allow NULL?
31	VREFER	Contract number from legacy system	nvarchar	20	Allow NULL?
32	ERDAT	Date on Which Record Was Created	nvarchar	8	Allow NULL?
33	ERNAM	Name of Person who Created the Object	nvarchar	12	Allow NULL?
34	AEDAT	Changed On	nvarchar	8	Allow NULL?
35	AENAM	Name of Person Who Changed Object	nvarchar	12	Allow NULL?
36	BEGRU	Authorization Group	nvarchar	4	Allow NULL?
37	LOEVM	Deletion Indicator	char	1	Allow NULL?
38	TXJCD	Tax Jurisdiction	nvarchar	15	Allow NULL?
39	MANOUTSORT	Reason for manual outsorting in billing	nvarchar	8	Allow NULL?
40	FAKTURIERT	Contract has already been invoiced	char	1	Allow NULL?
41	AUFNR	Order Number	nvarchar	12	Allow NULL?
42	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	Allow NULL?
43	PRCTR	Profit Center	nvarchar	10	Allow NULL?
44	COPAKONT	Indicator: Profitability segment assigned (CO-PA)	char	1	Allow NULL?
45	AUSGRUP	Outsorting check group for billing	nvarchar	8	Allow NULL?
46	OUTCOUNT	Number of manual outsortings to be carried out yet	nvarchar	2	Allow NULL?
47	PYPLT	Payment plan type	nvarchar	4	Allow NULL?
48	PYPLS	Starting month of payment plan	nvarchar	2	Allow NULL?
49	GSBER	Business Area	nvarchar	4	Allow NULL?
50	SEGMENT	Segment for Segmental Reporting	nvarchar	10	Allow NULL?
51	SERVICEID	Service Provider	nvarchar	10	Allow NULL?
52	SRVPRVREF	Reference number of service provider	nvarchar	30	Allow NULL?
53	BILLMETHOD	Billing method	nvarchar	2	Allow NULL?
54	STAGRUVER	Statistics group for contract	nvarchar	2	Allow NULL?
55	PYPLA	Alternative start month of payment plan	nvarchar	2	Allow NULL?
56	BILLFINIT	Contract terminated for billing reasons	char	1	Allow NULL?
57	BFA_DEB_STAT	Payment plan - BF amount not released for receivable	char	1	Allow NULL?
58	BFA_CRED_STAT	Payment plan - BF amount not released for credit	char	1	Allow NULL?
59	SALESEMPLOYEE	Sales employee	nvarchar	8	Allow NULL?
60	SALESPARTNER	Sales partners	nvarchar	10	Allow NULL?
61	SALESDOCUMENT	Sales and Distribution Document Number	nvarchar	10	Allow NULL?
62	PS_STARTDAT	Start Date of Payment Scheme (PS)	nvarchar	8	Allow NULL?
63	SERVPROV_PAY	Payment Class	nvarchar	4	Allow NULL?
64	INVOICING_PARTY	Service Provider That Invoices the Contract	nvarchar	10	Allow NULL?
65	COKEY	CO account assignment key, IS-U contract	nvarchar	10	Allow NULL?
66	BUPLA	Business Place	nvarchar	4	Allow NULL?
67	CONTRACTCLASS	Contract Class	nvarchar	4	Allow NULL?
68	CANCREASON	Reason for Cancellation of Contract	nvarchar	2	Allow NULL?
69	CANCREASON_NEW	Cancellation Reason (CRM)	nvarchar	4	Allow NULL?
70	EXTRAPOLWASTE	Category of Waste Disposal Budget Billing Extrapolation	nvarchar	2	Allow NULL?
71	PPM_CONTRACT	Identifies Contract as Prepayment Meter Contract	char	1	Allow NULL?
72	OSB_GROUP	On-Site Billing Group	nvarchar	3	Allow NULL?
73	OUCONT	Outline Contract	char	1	Allow NULL?
74	RULEGR	Rule Group for Outline Agreements	nvarchar	10	Allow NULL?
75	REGIOGROUP	Regional structure grouping	nvarchar	8	Allow NULL?
76	CMGRP	Collection Management: Master Data Group	nvarchar	2	Allow NULL?
77	STRAT	Collection Strategy	nvarchar	2	Allow NULL?
78	CPERS	Collections Contact Person	nvarchar	10	Allow NULL?
79	ANLAGE	Installation	nvarchar	10	Allow NULL?
80	VKONTO	Contract Account Number	nvarchar	12	Allow NULL?
81	KZSONDEINZ	Move-In Processing (Special Case)	char	1	Allow NULL?
82	KZSONDAUSZ	Special move-out processing case exists	char	1	Allow NULL?
83	AUTEIGEINZ	Automatic Owner Move-In	char	1	Allow NULL?
84	EINZDAT	Move-In Date	nvarchar	8	Allow NULL?
85	AUSZDAT	Move-Out Date	nvarchar	8	Allow NULL?
86	ABSSTOPDAT	Stop date for budget bill. requests in the case of move-out	nvarchar	8	Allow NULL?
87	SCHLFAKT	Joint final billing for move-in/out	char	1	Allow NULL?
88	MAHNV	Dunning Procedure	nvarchar	2	Allow NULL?
89	MAHNVUMZ	Move-in/out dunning procedure	nvarchar	2	Allow NULL?
90	MANSP	Dunning Lock Reason	char	1	Allow NULL?
91	BEZUG	Reference	char	1	Allow NULL?
92	TRANSVER	Transfer contract	nvarchar	10	Allow NULL?
93	SSWTCREASON	Reasons for contract change	nvarchar	2	Allow NULL?
94	XVERA	Contract created due to data transfer	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
EVER~0	Yes	Yes	CLUSTERED	VERTRAG, MANDT
EVER~ANL	No	No	NONCLUSTERED	ANLAGE, MANDT
EVER~POR	No	No	NONCLUSTERED	PORTION, MANDT
EVER~SRP	No	No	NONCLUSTERED	SERVICEID, MANDT
EVER~TVR	No	No	NONCLUSTERED	TRANSVER, MANDT
EVER~VKO	No	No	NONCLUSTERED	VKONTO, 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

94 COLUMNS | 6 INDEXES | ERP 6.0 | EVER TABLE

TOP ERP 6.0 | EVER COLUMNS

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

94 COLUMNS | 6 INDEXES | ERP 6.0 | EVER TABLE

TOPERP 6.0 | EVER COLUMNS

TOPERP 6.0 | EVER INDEXES

TOP ERP 6.0 | EVER COLUMNS

TOP ERP 6.0 | EVER INDEXES