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
Financial Accounting
1	ERP EHP7	6.0	BKPF	112	8	Accounting Document Header	Financial Accounting

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
3	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
4	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
5	BLART	Document Type	nvarchar	2	0	Allow NULL?
6	BLDAT	Document Date in Document	nvarchar	8	0	Allow NULL?
7	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
8	MONAT	Fiscal Period	nvarchar	2	0	Allow NULL?
9	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	Allow NULL?
10	CPUTM	Time of Entry	nvarchar	6	0	Allow NULL?
11	AEDAT	Date of the Last Document Change by Transaction	nvarchar	8	0	Allow NULL?
12	UPDDT	Date of the Last Document Update	nvarchar	8	0	Allow NULL?
13	WWERT	Translation Date	nvarchar	8	0	Allow NULL?
14	USNAM	User name	nvarchar	12	0	Allow NULL?
15	TCODE	Transaction Code	nvarchar	20	0	Allow NULL?
16	BVORG	Number of Cross-Company Code Posting Transaction	nvarchar	16	0	Allow NULL?
17	XBLNR	Reference Document Number	nvarchar	16	0	Allow NULL?
18	DBBLG	Recurring Entry Document Number	nvarchar	10	0	Allow NULL?
19	STBLG	Reverse Document Number	nvarchar	10	0	Allow NULL?
20	STJAH	Reverse document fiscal year	nvarchar	4	0	Allow NULL?
21	BKTXT	Document Header Text	nvarchar	25	0	Allow NULL?
22	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
23	KURSF	Exchange rate	decimal	9	5
24	KZWRS	Currency Key for the Group Currency	nvarchar	5	0	Allow NULL?
25	KZKRS	Group Currency Exchange Rate	decimal	9	5
26	BSTAT	Document Status	char	1	0	Allow NULL?
27	XNETB	Indicator: Document posted net ?	char	1	0	Allow NULL?
28	FRATH	Unplanned delivery costs	decimal	13	2
29	XRUEB	Indicator: Document is posted to a previous period	char	1	0	Allow NULL?
30	GLVOR	Business Transaction	nvarchar	4	0	Allow NULL?
31	GRPID	Batch Input Session Name	nvarchar	12	0	Allow NULL?
32	DOKID	Document Name in the Archive System	nvarchar	40	0	Allow NULL?
33	ARCID	Extract ID Document Header	nvarchar	10	0	Allow NULL?
34	IBLAR	Internal Document Type for Document Control	nvarchar	2	0	Allow NULL?
35	AWTYP	Reference Transaction	nvarchar	5	0	Allow NULL?
36	AWKEY	Reference Key	nvarchar	20	0	Allow NULL?
37	FIKRS	Financial Management Area	nvarchar	4	0	Allow NULL?
38	HWAER	Local Currency	nvarchar	5	0	Allow NULL?
39	HWAE2	Currency Key of Second Local Currency	nvarchar	5	0	Allow NULL?
40	HWAE3	Currency Key of Third Local Currency	nvarchar	5	0	Allow NULL?
41	KURS2	Exchange Rate for the Second Local Currency	decimal	9	5
42	KURS3	Exchange Rate for the Third Local Currency	decimal	9	5
43	BASW2	Source Currency for Currency Translation	char	1	0	Allow NULL?
44	BASW3	Source Currency for Currency Translation	char	1	0	Allow NULL?
45	UMRD2	Translation Date Type for Second Local Currency	char	1	0	Allow NULL?
46	UMRD3	Translation Date Type for Third Local Currency	char	1	0	Allow NULL?
47	XSTOV	Indicator: Document is flagged for reversal	char	1	0	Allow NULL?
48	STODT	Planned Date for the Reverse Posting	nvarchar	8	0	Allow NULL?
49	XMWST	Calculate tax automatically	char	1	0	Allow NULL?
50	CURT2	Currency Type of Second Local Currency	nvarchar	2	0	Allow NULL?
51	CURT3	Currency Type of Third Local Currency	nvarchar	2	0	Allow NULL?
52	KUTY2	Exchange Rate Type	nvarchar	4	0	Allow NULL?
53	KUTY3	Exchange Rate Type	nvarchar	4	0	Allow NULL?
54	XSNET	G/L account amounts entered exclude tax	char	1	0	Allow NULL?
55	AUSBK	Source Company Code	nvarchar	4	0	Allow NULL?
56	XUSVR	Indicator: US taxes changed at detail level ?	char	1	0	Allow NULL?
57	DUEFL	Status of Data Transfer into Subsequent Release	char	1	0	Allow NULL?
58	AWSYS	Logical System	nvarchar	10	0	Allow NULL?
59	TXKRS	Exchange Rate for Taxes	decimal	9	5
60	LOTKZ	Lot Number for Requests	nvarchar	10	0	Allow NULL?
61	XWVOF	Indicator: Customer bill of exchange payment before due date	char	1	0	Allow NULL?
62	STGRD	Reason for Reversal	nvarchar	2	0	Allow NULL?
63	PPNAM	Name of User Who Parked this Document	nvarchar	12	0	Allow NULL?
64	BRNCH	Branch Number	nvarchar	4	0	Allow NULL?
65	NUMPG	Number of pages of invoice	nvarchar	3	0	Allow NULL?
66	ADISC	Indicator: entry represents a discount document	char	1	0	Allow NULL?
67	XREF1_HD	Reference Key 1 Internal for Document Header	nvarchar	20	0	Allow NULL?
68	XREF2_HD	Reference Key 2 Internal for Document Header	nvarchar	20	0	Allow NULL?
69	XREVERSAL	Specifies whether doc. is reversal doc. or reversed doc.	char	1	0	Allow NULL?
70	REINDAT	Invoice Receipt Date	nvarchar	8	0	Allow NULL?
71	RLDNR	Ledger in General Ledger Accounting	nvarchar	2	0	Allow NULL?
72	LDGRP	Ledger Group	nvarchar	4	0	Allow NULL?
73	PROPMANO	Real Estate Management Mandate	nvarchar	13	0	Allow NULL?
74	XBLNR_ALT	Alternative Reference Number	nvarchar	26	0	Allow NULL?
75	VATDATE	Tax Reporting Date	nvarchar	8	0	Allow NULL?
76	DOCCAT	Classification of an FI Document	nvarchar	6	0	Allow NULL?
77	XSPLIT	FI Document Originates from Split Posting (Indicator)	char	1	0	Allow NULL?
78	CASH_ALLOC	Cash-Relevant Document	char	1	0	Allow NULL?
79	FOLLOW_ON	Follow-on document indicator	char	1	0	Allow NULL?
80	XREORG	Doc. Contains Open Item that Was Transferred During Reorg.	char	1	0	Allow NULL?
81	SUBSET	Defines subset of components for the FI/CO interface	nvarchar	4	0	Allow NULL?
82	KURST	Exchange Rate Type	nvarchar	4	0	Allow NULL?
83	KURSX	Market Data Exchange Rate	decimal	28	14
84	KUR2X	Market Data Exchange Rate 2	decimal	28	14
85	KUR3X	Market Data Exchange Rate 3	decimal	28	14
86	XMCA	Document Originates from Multi Currency Accounting	char	1	0	Allow NULL?
87	RESUBMISSION	Date of Resubmission	nvarchar	8	0	Allow NULL?
88	/SAPF15/STATUS		char	1	0	Allow NULL?
89	PSOTY	Document category payment requests	nvarchar	2	0	Allow NULL?
90	PSOAK	Reason	nvarchar	10	0	Allow NULL?
91	PSOKS	Region	nvarchar	10	0	Allow NULL?
92	PSOSG	Reason for reversal - IS-PS requests	char	1	0	Allow NULL?
93	PSOFN	IS-PS: File number	nvarchar	30	0	Allow NULL?
94	INTFORM	Interest Formula	nvarchar	4	0	Allow NULL?
95	INTDATE	Interest Calc. Date	nvarchar	8	0	Allow NULL?
96	PSOBT	Posting Day	nvarchar	8	0	Allow NULL?
97	PSOZL	Actual posting	char	1	0	Allow NULL?
98	PSODT	Changed On	nvarchar	8	0	Allow NULL?
99	PSOTM	Last changed at	nvarchar	6	0	Allow NULL?
100	FM_UMART	Type of Payment Transfer	char	1	0	Allow NULL?
101	CCINS	Payment cards: Card type	nvarchar	4	0	Allow NULL?
102	CCNUM	Payment cards: Card number	nvarchar	25	0	Allow NULL?
103	SSBLK	Payment Statistical Sampling Block	char	1	0	Allow NULL?
104	BATCH	Lot Number for Documents	nvarchar	10	0	Allow NULL?
105	SNAME	User Name	nvarchar	12	0	Allow NULL?
106	SAMPLED	Sampled Invoice by Payment Certification	char	1	0	Allow NULL?
107	EXCLUDE_FLAG	PPA Exclude Indicator	char	1	0	Allow NULL?
108	BLIND	Budgetary Ledger Indicator	char	1	0	Allow NULL?
109	OFFSET_STATUS	Treasury Offset Status	nvarchar	2	0	Allow NULL?
110	OFFSET_REFER_DAT	Date Record Referred to Treasury	nvarchar	8	0	Allow NULL?
111	PENRC	Reason for late payment	nvarchar	2	0	Allow NULL?
112	KNUMV	Number of the document condition	nvarchar	10	0	Allow NULL?

Name	Primary	Unique	Type	Columns
BKPF~0	Yes	Yes	CLUSTERED	GJAHR, BELNR, BUKRS, MANDT
BKPF~1	No	No	NONCLUSTERED	XBLNR, BSTAT, BUKRS, MANDT
BKPF~2	No	No	NONCLUSTERED	BUDAT, BSTAT, BUKRS, MANDT
BKPF~3	No	No	NONCLUSTERED	BLART, BSTAT, BUKRS, MANDT
BKPF~4	No	No	NONCLUSTERED	AWSYS, AWKEY, AWTYP, MANDT
BKPF~5	No	No	NONCLUSTERED	BSTAT, CPUDT, BUKRS, MANDT
BKPF~6	No	No	NONCLUSTERED	BSTAT, BLDAT, BUKRS, MANDT
BKPF~BUT	No	No	NONCLUSTERED	BUKRS, 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

112 COLUMNS | 8 INDEXES | ERP 6.0 | BKPF TABLE

TOP ERP 6.0 | BKPF COLUMNS

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

112 COLUMNS | 8 INDEXES | ERP 6.0 | BKPF TABLE

TOPERP 6.0 | BKPF COLUMNS

TOPERP 6.0 | BKPF INDEXES

TOP ERP 6.0 | BKPF COLUMNS

TOP ERP 6.0 | BKPF INDEXES