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
Project System :: Payments :: Actual Payments and Forecast
1	ERP EHP7	6.0	COFP	68	6	Document Lines (project cash management)	Actual Payments and Forecast

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
3	BELNR	Document Number	nvarchar	10	0	Allow NULL?
4	BUZEI	Posting row	nvarchar	3	0	Allow NULL?
5	TWAER	Transaction Currency	nvarchar	5	0	Allow NULL?
6	ZHLDT	Funds Management - Update Date	nvarchar	8	0	Allow NULL?
7	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
8	PERIO	Period	nvarchar	3	0	Allow NULL?
9	WRTTP	Value Type	nvarchar	2	0	Allow NULL?
10	VRGNG	CO Business Transaction	nvarchar	4	0	Allow NULL?
11	POSIT	Internal commitment item (8 chars)	nvarchar	8	0	Allow NULL?
12	OBJNR	Object number	nvarchar	22	0	Allow NULL?
13	HKONT	General Ledger Account	nvarchar	10	0	Allow NULL?
14	WKGBTR	Total Value in Controlling Area Currency	decimal	15	2
15	WKGBTRO	Original value in controlling area currency	decimal	15	2
16	WTGBTR	Total Value in Transaction Currency	decimal	15	2
17	WTGBTRO	Original value in transaction currency	decimal	15	2
18	WOGBTR	Total Value in Object Currency	decimal	15	2
19	WOGBTRO	Original value in object currency	decimal	15	2
20	BUKRS1	Company Code	nvarchar	4	0	Allow NULL?
21	GJAHR1	Fiscal Year	nvarchar	4	0	Allow NULL?
22	BELNR1	Accounting Document Number	nvarchar	10	0	Allow NULL?
23	BUZEI1	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
24	BUKRS2	Company Code	nvarchar	4	0	Allow NULL?
25	GJAHR2	Fiscal Year	nvarchar	4	0	Allow NULL?
26	BELNR2	Accounting Document Number	nvarchar	10	0	Allow NULL?
27	BUZEI2	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
28	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
29	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
30	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	Allow NULL?
31	ETENRM	Delivery Schedule Line Number	nvarchar	4	0	Allow NULL?
32	STUNR	Step number	nvarchar	3	0	Allow NULL?
33	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
34	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
35	GSBER	Business Area	nvarchar	4	0	Allow NULL?
36	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
37	EINDT	Item Delivery Date	nvarchar	8	0	Allow NULL?
38	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
39	GEBER	Fund	nvarchar	10	0	Allow NULL?
40	KURSF	Exchange rate	decimal	9	5
41	KUFIX	Indicator: Fixing of Exchange Rate	char	1	0	Allow NULL?
42	GBETR	Hedged Amount in Foreign Currency	decimal	13	2
43	KURSR	Hedged Exchange Rate	decimal	9	5
44	KURSFIKRS	Exchange rate	decimal	9	5
45	KZKRS	Group Currency Exchange Rate	decimal	9	5
46	UMBKZ	Transfer flag	char	1	0	Allow NULL?
47	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	Allow NULL?
48	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	Allow NULL?
49	HI_FIVOR	Financial transaction	nvarchar	2	0	Allow NULL?
50	LO_FIVOR	Financial transaction	nvarchar	2	0	Allow NULL?
51	HI_ACCOUNT	General Ledger Account	nvarchar	10	0	Allow NULL?
52	LO_ACCOUNT	General Ledger Account	nvarchar	10	0	Allow NULL?
53	HI_LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
54	LO_LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
55	HI_KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
56	LO_KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
57	XDELETE	Checkbox	char	1	0	Allow NULL?
58	HI_XOPVW	Indicator: Open Item Management?	char	1	0	Allow NULL?
59	LO_XOPVW	Indicator: Open Item Management?	char	1	0	Allow NULL?
60	ZAEHK	Condition counter	nvarchar	2	0	Allow NULL?
61	CHAINBELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
62	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
63	LEDNR	Budget/Planning Ledger	nvarchar	4	0	Allow NULL?
64	BELTP	Debit type	char	1	0	Allow NULL?
65	VERSN	Version	nvarchar	3	0	Allow NULL?
66	OWAER	Currency Key	nvarchar	5	0	Allow NULL?
67	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	Allow NULL?
68	CPUTM	Time of Entry	nvarchar	6	0	Allow NULL?

Name	Primary	Unique	Type	Columns
COFP~0	Yes	Yes	CLUSTERED	BUZEI, BELNR, KOKRS, MANDT
COFP~C	No	No	NONCLUSTERED	MANDT, GSBER, TWAER, POSIT, VRGNG, WRTTP, GJAHR, OBJNR
COFP~K	No	No	NONCLUSTERED	BUKRS1, GJAHR1, BELNR1
COFP~M	No	No	NONCLUSTERED	EBELN
COFP~V	No	No	NONCLUSTERED	BELNR2, GJAHR2, BUKRS2
COFP~X	No	No	NONCLUSTERED	KBLPOS, KBLNR

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

68 COLUMNS | 6 INDEXES | ERP 6.0 | COFP TABLE

TOP ERP 6.0 | COFP COLUMNS

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

68 COLUMNS | 6 INDEXES | ERP 6.0 | COFP TABLE

TOPERP 6.0 | COFP COLUMNS

TOPERP 6.0 | COFP INDEXES

TOP ERP 6.0 | COFP COLUMNS

TOP ERP 6.0 | COFP INDEXES