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

	Product	Version	Table	Columns	Indexes	Description	Module
Controlling :: Overhead Cost Controlling
1	ERP EHP7	6.0	COBK	42	2	CO Object: Document Header	Overhead Cost Controlling

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	KOKRS	Controlling Area	nvarchar	4	Allow NULL?
3	BELNR	Document Number	nvarchar	10	Allow NULL?
4	GJAHR	Fiscal Year	nvarchar	4	Allow NULL?
5	VERSN	Version in CO Document Header	nvarchar	3	Allow NULL?
6	VRGNG	CO Business Transaction	nvarchar	4	Allow NULL?
7	TIMESTMP	Time created (Greenwich Meantime)	decimal	16
8	PERAB	From Period	nvarchar	3	Allow NULL?
9	PERBI	To period	nvarchar	3	Allow NULL?
10	BLDAT	Document Date	nvarchar	8	Allow NULL?
11	BUDAT	Posting Date	nvarchar	8	Allow NULL?
12	CPUDT	Date Document Was Created	nvarchar	8	Allow NULL?
13	USNAM	User Name	nvarchar	12	Allow NULL?
14	BLTXT	Document Header Text	nvarchar	50	Allow NULL?
15	STFLG	Identifier for reversal document	char	1	Allow NULL?
16	STOKZ	Indicator: Document Has Been Reversed	char	1	Allow NULL?
17	REFBT	Document type of reference document	char	1	Allow NULL?
18	REFBN	Reference Document Number	nvarchar	10	Allow NULL?
19	REFBK	Company code of FI document	nvarchar	4	Allow NULL?
20	REFGJ	Fiscal year of reference document	nvarchar	4	Allow NULL?
21	BLART	Document type of FI reference document	nvarchar	2	Allow NULL?
22	ORGVG	Original CO business transaction	nvarchar	4	Allow NULL?
23	SUMBZ	Number of posting lines for local objects	nvarchar	3	Allow NULL?
24	DELBZ	Number of deleted line items	nvarchar	3	Allow NULL?
25	WSDAT	Value Date for Currency Translation	nvarchar	8	Allow NULL?
26	KURST	Exchange Rate Type	nvarchar	4	Allow NULL?
27	VARNR	CO actual postings fast input: Variant	nvarchar	5	Allow NULL?
28	KWAER	Controlling area currency	nvarchar	5	Allow NULL?
29	CTYP1	Currency Type 1 in CO Standard Ledger	nvarchar	2	Allow NULL?
30	CTYP2	Currency Type 2 in CO Standard Ledger	nvarchar	2	Allow NULL?
31	CTYP3	Currency Type 3 in CO Standard Ledger	nvarchar	2	Allow NULL?
32	CTYP4	Currency Type 4 in CO Standard Ledger	nvarchar	2	Allow NULL?
33	AWTYP	Reference Transaction	nvarchar	5	Allow NULL?
34	AWORG	Reference Organizational Units	nvarchar	10	Allow NULL?
35	LOGSYSTEM	Logical System	nvarchar	10	Allow NULL?
36	CPUTM	Time of Entry	nvarchar	6	Allow NULL?
37	ALEBZ	Number of posting rows sent to external systems	nvarchar	3	Allow NULL?
38	ALEBN	For ALE: CO Document Number in Generating System	nvarchar	10	Allow NULL?
39	AWSYS	Logical system of source document	nvarchar	10	Allow NULL?
40	AWREF_REV	Reversal: Reverse Document Reference Document Number	nvarchar	10	Allow NULL?
41	AWORG_REV	Reversal: Reverse Document Reference Organization	nvarchar	10	Allow NULL?
42	VALDT	Special Valuation Date for Cost Accounting	nvarchar	8	Allow NULL?

Name	Primary	Unique	Type	Columns
COBK~0	Yes	Yes	CLUSTERED	BELNR, KOKRS, MANDT
COBK~O	No	No	NONCLUSTERED	REFGJ, REFBK, AWSYS, REFBT, AWORG, AWTYP, REFBN, 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

42 COLUMNS | 2 INDEXES | ERP 6.0 | COBK TABLE

TOP ERP 6.0 | COBK COLUMNS

TOP ERP 6.0 | COBK 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 | 2 INDEXES | ERP 6.0 | COBK TABLE

TOPERP 6.0 | COBK COLUMNS

TOPERP 6.0 | COBK INDEXES

TOP ERP 6.0 | COBK COLUMNS

TOP ERP 6.0 | COBK INDEXES