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	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	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

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	ACCOUNT_NUMBER	Account Number	nvarchar	20	Allow NULL?
3	ACTIVE_FLAG	Active flag for cash account	char	1	Allow NULL?
4	ACCOUNT_STATUS	Cash Account Status	nvarchar	3	Allow NULL?
5	ACCOUNT_NAME	Cash Account Name	nvarchar	40	Allow NULL?
6	ACCOUNT_CATEGORY	Cash Account Group	nvarchar	4	Allow NULL?
7	ACCOUNT_TYPE	Cash Account Type	nvarchar	4	Allow NULL?
8	ORG_CONTACT_NAME	Name of Contact Person	nvarchar	20	Allow NULL?
9	ORG_CONTACT_TEL	Telephone Number	nvarchar	30	Allow NULL?
10	ORG_CONTACT_FAX	Fax Number	nvarchar	30	Allow NULL?
11	ORG_CONTACT_MAIL	E-Mail Address	nvarchar	241	Allow NULL?
12	ORG_CONTACT_PST	Postal Code	nvarchar	10	Allow NULL?
13	BANK_CONTACT_NAME	Name of Contact Person	nvarchar	20	Allow NULL?
14	BANK_CONTACT_TEL	Telephone Number	nvarchar	30	Allow NULL?
15	BANKS	Bank country key	nvarchar	3	Allow NULL?
16	BANKL	Bank Keys	nvarchar	15	Allow NULL?
17	WAERS	Currency Key	nvarchar	5	Allow NULL?
18	BNKACC_NAME	Bank Account Name	nvarchar	50	Allow NULL?
19	PLVAR	Plan Version	nvarchar	2	Allow NULL?
20	OTYPE	Object Type	nvarchar	2	Allow NULL?
21	OBJID	ID of Organizational Unit	nvarchar	8	Allow NULL?
22	BEGDA	Start Date	nvarchar	8	Allow NULL?
23	ENDDA	End Date	nvarchar	8	Allow NULL?
24	BUKRS	Company Code	nvarchar	4	Allow NULL?
25	HBKID	Short Key for a House Bank	nvarchar	5	Allow NULL?
26	HKTID	ID for account details	nvarchar	5	Allow NULL?
27	BNKACC_NO	Bank Account Number	nvarchar	24	Allow NULL?
28	BANK_AREA	Bank Area	nvarchar	4	Allow NULL?
29	IHC_ACCOUNT_NUMBER	Account Number for Current Account	nvarchar	35	Allow NULL?
30	ZLSPR	Payment Block Key	char	1	Allow NULL?
31	ACCOUNT_EPIC_FLAG	Used by Electronic Payment Integration for China	char	1	Allow NULL?
32	ERNAM	Name of Person who Created the Object	nvarchar	12	Allow NULL?
33	ERDAT	Date on which the Record Was Created	nvarchar	8	Allow NULL?
34	SORT1	Search Term 1	nvarchar	20	Allow NULL?
35	SORT2	Search Term 2	nvarchar	20	Allow NULL?
36	ADDRESS	Contact Person's Address	nvarchar	128	Allow NULL?
37	REFER	Internal Reference	nvarchar	16	Allow NULL?
38	ZUOND	Assignment	nvarchar	18	Allow NULL?
39	MERKM	Characteristics	nvarchar	25	Allow NULL?
40	POSTING_VARIANT	Posting Variant	nvarchar	3	Allow NULL?
41	RECONCILE_VARIANT	Reconciliation Variant	nvarchar	3	Allow NULL?
42	ACCOUNT_COMMENT	Text on COPC CHAR65ACCOUNT	nvarchar	255	Allow NULL?

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

42 COLUMNS | 1 INDEXES | ERP 6.0 | COPC_ACCOUNT TABLE

TOP ERP 6.0 | COPC_ACCOUNT COLUMNS

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

42 COLUMNS | 1 INDEXES | ERP 6.0 | COPC_ACCOUNT TABLE

TOPERP 6.0 | COPC_ACCOUNT COLUMNS

TOPERP 6.0 | COPC_ACCOUNT INDEXES

TOP ERP 6.0 | COPC_ACCOUNT COLUMNS

TOP ERP 6.0 | COPC_ACCOUNT INDEXES