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
Cross-Application Components :: General Application Functions :: Correspondence Tool
1	ERP EHP7	6.0	DFKKCOH	75	4	Correspondence - Correspondence Header	Correspondence Tool

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	COTYP	Correspondence Type	nvarchar	4	0	Allow NULL?
3	COKEY	Correspondence key	nvarchar	36	0	Allow NULL?
4	UNAME	User Name	nvarchar	12	0	Allow NULL?
5	CDATE	Created On	nvarchar	8	0	Allow NULL?
6	CTIME	Time of Creation (to the Second)	nvarchar	6	0	Allow NULL?
7	GPART	Correspondence Recipient	nvarchar	10	0	Allow NULL?
8	GPART_GUID	Correspondence Recipient (GUID)	nvarchar	32	0	Allow NULL?
9	GPART_ADR_KIND	Address Type Of Correspondence Recipient	nvarchar	10	0	Allow NULL?
10	ORG_GPART	Original Correspondence Recipient	nvarchar	10	0	Allow NULL?
11	ORG_GPART_GUID	Original Correspondence Recipient (GUID)	nvarchar	32	0	Allow NULL?
12	ADD_GPART	Additional Business Partner for Correspondence Recipient	nvarchar	10	0	Allow NULL?
13	ADD_GPART_GUID	Addit. Business Partner for Correspondence Recipient GUID	nvarchar	32	0	Allow NULL?
14	ADD_GPART_CAT	Type of Additional Correspondence Recipient	char	1	0	Allow NULL?
15	VKONT	Contract Account Number	nvarchar	12	0	Allow NULL?
16	VTREF	Reference Specifications from Contract	nvarchar	20	0	Allow NULL?
17	ADR_VALID_ON	Address of Correspondence Recipient Valid On	decimal	15	0
18	ADRNR	Address Number of Correspondence Recipient	nvarchar	10	0	Allow NULL?
19	ADR_GUID	Address GUID of Correspondence Recipient	nvarchar	32	0	Allow NULL?
20	ADRNR_INDEP_COMM	Address Number for Address-Independent Communication	nvarchar	10	0	Allow NULL?
21	AGPART	Sending Business Partner	nvarchar	10	0	Allow NULL?
22	AGPART_GUID	Sender (GUID)	nvarchar	32	0	Allow NULL?
23	AGPART_ADR_KIND	Address Type Of Correspondence Recipient	nvarchar	10	0	Allow NULL?
24	AADRNR	Address Number of Correspondence Sender	nvarchar	10	0	Allow NULL?
25	AADR_GUID	Address GUID of Correspondence Sender	nvarchar	32	0	Allow NULL?
26	FORMKEY	Application form	nvarchar	30	0	Allow NULL?
27	FORMKEY_RDI	Application form	nvarchar	30	0	Allow NULL?
28	ENTID1	Correspondence data	nvarchar	4	0	Allow NULL?
29	DATA1	Correspondence Data Field	nvarchar	32	0	Allow NULL?
30	ENTID2	Correspondence data	nvarchar	4	0	Allow NULL?
31	DATA2	Correspondence Data Field	nvarchar	32	0	Allow NULL?
32	ENTID3	Correspondence data	nvarchar	4	0	Allow NULL?
33	DATA3	Correspondence Data Field	nvarchar	32	0	Allow NULL?
34	ENTID4	Correspondence data	nvarchar	4	0	Allow NULL?
35	DATA4	Correspondence Data Field	nvarchar	32	0	Allow NULL?
36	CSORT	Correspondence Sort Field	nvarchar	50	0	Allow NULL?
37	XCODT	Data Part Is Used	char	1	0	Allow NULL?
38	XCODT_CLUST	Cluster Data Part is Used	char	1	0	Allow NULL?
39	LAUFD	Date ID for Creation Run	nvarchar	8	0	Allow NULL?
40	LAUFI	Additional ID Characteristic for Creation Run	nvarchar	6	0	Allow NULL?
41	XTEST	Correspondence is Result of Test	char	1	0	Allow NULL?
42	COPRI	Print Date	nvarchar	8	0	Allow NULL?
43	COIDT	Date of Issue	nvarchar	8	0	Allow NULL?
44	COITM	Issue Time to the Second	nvarchar	6	0	Allow NULL?
45	SPRAS	Language Key	char	1	0	Allow NULL?
46	SALWA	Transaction Currency	nvarchar	5	0	Allow NULL?
47	SALBE	Amount in Local Currency with +/- Signs	decimal	13	2
48	SENDCONTROL	Dispatch Control	nvarchar	4	0	Allow NULL?
49	PERSNUMBER	Person number	nvarchar	10	0	Allow NULL?
50	APERSNUMBER	Person number	nvarchar	10	0	Allow NULL?
51	BUKRS	Company Code in Correspondence	nvarchar	4	0	Allow NULL?
52	CORR_ROLE	Correspondence Roles	nvarchar	4	0	Allow NULL?
53	COPRI_LAUFD	Date ID for Print Run	nvarchar	8	0	Allow NULL?
54	COPRI_LAUFI	ID Characteristic for Run	nvarchar	6	0	Allow NULL?
55	PROCESS_ID_	Business Process ID	nvarchar	36	0	Allow NULL?
56	NO_DOCPARTS	Number of Document Parts	nvarchar	4	0	Allow NULL?
57	DOCPART_ROLE	Document Part Role	char	1	0	Allow NULL?
58	XTRIAL	Correspondence Request is Test	char	1	0	Allow NULL?
59	XREPRINT	Recreate Correspondence	char	1	0	Allow NULL?
60	SUBAP	Subapplication Indicator in Correspondence	char	1	0	Allow NULL?
61	XDELETE	Correspondence Is Logically Deleted	char	1	0	Allow NULL?
62	PRINT_MODE	Business Partner Print Format	char	1	0	Allow NULL?
63	X_NO_ARC	SAP ArchiveLink Object ID Part Is Not Used	char	1	0	Allow NULL?
64	X_DOCPART_LIST	Document Part List Is Used	char	1	0	Allow NULL?
65	BKKRS	Bank Area	nvarchar	4	0	Allow NULL?
66	ACNUM_INT	Internal Account Number for Current Account	nvarchar	10	0	Allow NULL?
67	OBJECT_IDCMS	Object Identification Number	varbinary	16	0
68	FLG_ORIGINALCMS	Flag to indicate if the document is original or duplicate	char	1	0	Allow NULL?
69	SENDCONTROLCMS	Dispatch Control	nvarchar	4	0	Allow NULL?
70	PRODUCTTYPEFVD	Product Type	nvarchar	3	0	Allow NULL?
71	BP_ROLEFVD	BP Role	nvarchar	6	0	Allow NULL?
72	BP_ROLETYPEFVD	Business Partner Role Type	nvarchar	4	0	Allow NULL?
73	SOBJECTFVD	Internal key for object	nvarchar	10	0	Allow NULL?
74	CORR_ACTIVITYFVD	Correspondence activity	nvarchar	4	0	Allow NULL?
75	REFERENCEDATEFVD	Reference Date for Creating Correspondence	nvarchar	8	0	Allow NULL?

Name	Primary	Unique	Type	Columns
DFKKCOH~0	Yes	Yes	CLUSTERED	COKEY, COTYP, MANDT
DFKKCOH~001	No	No	NONCLUSTERED	DATA1, COTYP
DFKKCOH~104	No	No	NONCLUSTERED	COTYP, VKONT, GPART, MANDT
DFKKCOH~105	No	No	NONCLUSTERED	COTYP, VKONT, 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

75 COLUMNS | 4 INDEXES | ERP 6.0 | DFKKCOH TABLE

TOP ERP 6.0 | DFKKCOH COLUMNS

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

75 COLUMNS | 4 INDEXES | ERP 6.0 | DFKKCOH TABLE

TOPERP 6.0 | DFKKCOH COLUMNS

TOPERP 6.0 | DFKKCOH INDEXES

TOP ERP 6.0 | DFKKCOH COLUMNS

TOP ERP 6.0 | DFKKCOH INDEXES