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

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	ZBUKRS	Company Code	nvarchar	4	Allow NULL?
3	ZYEAR	Fiscal Year	nvarchar	4	Allow NULL?
4	XBLNR	Reference Document Number	nvarchar	16	Allow NULL?
5	ZYEAR1	Fiscal Year	nvarchar	4	Allow NULL?
6	ZRCPNO	Receipt number	nvarchar	10	Allow NULL?
7	ZPRINT	Print receipt	char	1	Allow NULL?
8	ZDATE	Date of reciept	nvarchar	8	Allow NULL?
9	ZUSER	User name	nvarchar	12	Allow NULL?
10	ZUONR	Allocation number	nvarchar	10	Allow NULL?
11	NAME1	Name 1	nvarchar	35	Allow NULL?
12	NAME2	Name 2	nvarchar	35	Allow NULL?
13	NAME3	Name 3	nvarchar	35	Allow NULL?
14	NAME4	Name 4	nvarchar	35	Allow NULL?
15	PSTLZ	Postal Code	nvarchar	10	Allow NULL?
16	ORT01	City	nvarchar	35	Allow NULL?
17	LAND1	Country Key	nvarchar	3	Allow NULL?
18	STRAS	House number and street	nvarchar	35	Allow NULL?
19	PFACH	PO Box	nvarchar	10	Allow NULL?
20	PSTL2	P.O. Box Postal Code	nvarchar	10	Allow NULL?
21	PSKTO	Account Number of Bank Account At Post Office	nvarchar	16	Allow NULL?
22	BANKN	Bank account number	nvarchar	18	Allow NULL?
23	BANKL	Bank Keys	nvarchar	15	Allow NULL?
24	BANKS	Bank country key	nvarchar	3	Allow NULL?
25	STCD1	Tax Number 1	nvarchar	16	Allow NULL?
26	STCD2	Tax Number 2	nvarchar	11	Allow NULL?
27	STKZU	Liable for VAT	char	1	Allow NULL?
28	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	Allow NULL?
29	REGIO	Region (State, Province, County)	nvarchar	3	Allow NULL?
30	BKONT	Bank Control Key	nvarchar	2	Allow NULL?
31	DTAWS	Instruction key for data medium exchange	nvarchar	2	Allow NULL?
32	DTAMS	Indicator for Data Medium Exchange	char	1	Allow NULL?
33	XCPDK	Indicator: Is the account a one-time account?	char	1	Allow NULL?
34	EMPFG	Payee code	nvarchar	16	Allow NULL?
35	STCEG	VAT Registration Number	nvarchar	20	Allow NULL?
36	SPRAS	Language Key	char	1	Allow NULL?
37	KOART	Account Type	char	1	Allow NULL?
38	KUNNR	Customer Number	nvarchar	10	Allow NULL?
39	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	Allow NULL?
40	HKONT	General Ledger Account	nvarchar	10	Allow NULL?
41	ZTERMNAM	Terminal Name	nvarchar	15	Allow NULL?
42	ZTERMNO	Terminal number	nvarchar	7	Allow NULL?
43	ZPROGVERS	Program version	nvarchar	10	Allow NULL?

Name	Primary	Unique	Type	Columns
/ATL/KPRCPT~0	Yes	Yes	CLUSTERED	XBLNR, ZYEAR, ZBUKRS, MANDT
/ATL/KPRCPT~1	No	No	NONCLUSTERED	MANDT, ZDATE, ZUONR, ZUSER, ZYEAR, ZBUKRS
/ATL/KPRCPT~2	No	No	NONCLUSTERED	MANDT, ZDATE, ZUONR, ZYEAR, ZBUKRS
/ATL/KPRCPT~3	No	No	NONCLUSTERED	ZUONR, ZBUKRS, 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

43 COLUMNS | 4 INDEXES | ERP 6.0 | /ATL/KPRCPT TABLE

TOP ERP 6.0 | /ATL/KPRCPT COLUMNS

TOP ERP 6.0 | /ATL/KPRCPT 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

43 COLUMNS | 4 INDEXES | ERP 6.0 | /ATL/KPRCPT TABLE

TOPERP 6.0 | /ATL/KPRCPT COLUMNS

TOPERP 6.0 | /ATL/KPRCPT INDEXES

TOP ERP 6.0 | /ATL/KPRCPT COLUMNS

TOP ERP 6.0 | /ATL/KPRCPT INDEXES