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
Financial Accounting :: Localization
1	ERP EHP7	6.0	J_3RBUE_BK_TABLE	119	1	Transparent table for PurBook (ALV)	Localization

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_TRN	Accounting Document Number	nvarchar	10	0	Allow NULL?
4	GJAHR_TRN	Fiscal Year	nvarchar	4	0	Allow NULL?
5	BUZEI_TEST	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
6	MONAT_TRN	Fiscal Period	nvarchar	2	0	Allow NULL?
7	EX_INDEX	DE for EX index	nvarchar	10	0	Allow NULL?
8	EX_INDEX_POS	Extracts counter for PBOOK_03	nvarchar	10	0	Allow NULL?
9	LAUFI	Additional Identification	nvarchar	6	0	Allow NULL?
10	LAUFD	Date on Which the Program Is to Be Run	nvarchar	8	0	Allow NULL?
11	GSBER_TRN	Business Area	nvarchar	4	0	Allow NULL?
12	BLDAT_TRN	Document Date in Document	nvarchar	8	0	Allow NULL?
13	BUDAT_TRN	Posting Date in the Document	nvarchar	8	0	Allow NULL?
14	DMBTR_TRN	Amount in company code currency	decimal	15	2
15	DMBTR_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
16	WRBTR_TRN	Gross Amount in Document Currency	decimal	15	2
17	WRBTR_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
18	FLG_BELNR_TRN	Reversal (Tax Transfer)	char	1	0	Allow NULL?
19	BELNR_PAY	Accounting Document Number	nvarchar	10	0	Allow NULL?
20	GJAHR_PAY	Fiscal Year	nvarchar	4	0	Allow NULL?
21	BLDAT_PAY	Document Date in Document	nvarchar	8	0	Allow NULL?
22	BUDAT_PAY	Posting Date in the Document	nvarchar	8	0	Allow NULL?
23	DMBTR_PAY	Tax Base Amount in Local Currency	decimal	15	2
24	DMBTR_WRS_PAY	Currency Key	nvarchar	5	0	Allow NULL?
25	WRBTR_PAY	Tax Base Amount in Local Currency	decimal	15	2
26	WRBTR_WRS_PAY	Currency Key	nvarchar	5	0	Allow NULL?
27	FLG_BELNR_PAY	Reversal (Payment)	char	1	0	Allow NULL?
28	FLG_XRAGL_PAY	Indicator: Clearing was Reversed	char	1	0	Allow NULL?
29	BELNR_ORIGPAY	Accounting Document Number	nvarchar	10	0	Allow NULL?
30	GJAHR_ORIGPAY	Fiscal Year	nvarchar	4	0	Allow NULL?
31	BLDAT_ORIGPAY	Document Date in Document	nvarchar	8	0	Allow NULL?
32	BUDAT_ORIGPAY	Posting Date in the Document	nvarchar	8	0	Allow NULL?
33	XBLNR_ORIGPAY	Reference Document Number	nvarchar	16	0	Allow NULL?
34	BKTXT_ORIGPAY	Document Header Text	nvarchar	25	0	Allow NULL?
35	BELNR_INV	Accounting Document Number	nvarchar	10	0	Allow NULL?
36	GJAHR_INV	Fiscal Year	nvarchar	4	0	Allow NULL?
37	BLDAT_INV	Document Date in Document	nvarchar	8	0	Allow NULL?
38	BUDAT_INV	Posting Date in the Document	nvarchar	8	0	Allow NULL?
39	DMBTR_INV	Amount in company code currency	decimal	15	2
40	DMBTR_WRS_INV	Currency Key	nvarchar	5	0	Allow NULL?
41	WRBTR_INV	Gross Amount in Document Currency	decimal	15	2
42	WRBTR_WRS_INV	Currency Key	nvarchar	5	0	Allow NULL?
43	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
44	MWSKZ_INV	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
45	FLG_BELNR_INV	Reversal (Invoice)	char	1	0	Allow NULL?
46	FLG_BELNR_ALL	Reversal (Clearing)	char	1	0	Allow NULL?
47	BASGRUNO	Group Number for Tax Base Amounts	nvarchar	2	0	Allow NULL?
48	HWBAS_TRN	Tax Base Amount in Local Currency	decimal	15	2
49	HWBAS_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
50	FWBAS_TRN	Tax Base Amount in Local Currency	decimal	15	2
51	FWBAS_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
52	HWBAS2_TRN	Tax Base Amount in Local Currency	decimal	15	2
53	HWBAS2_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
54	FWBAS2_TRN	Tax Base Amount in Local Currency	decimal	15	2
55	FWBAS2_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
56	HWBAS3_TRN	Tax Base Amount in Local Currency	decimal	15	2
57	HWBAS3_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
58	FWBAS3_TRN	Tax Base Amount in Local Currency	decimal	15	2
59	FWBAS3_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
60	HWBAS4_TRN	Tax Base Amount in Local Currency	decimal	15	2
61	HWBAS4_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
62	FWBAS4_TRN	Tax Base Amount in Local Currency	decimal	15	2
63	FWBAS4_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
64	HWBAS5_TRN	Tax Base Amount in Local Currency	decimal	15	2
65	HWBAS5_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
66	FWBAS5_TRN	Tax Base Amount in Local Currency	decimal	15	2
67	FWBAS5_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
68	STEGRUNO	Group Number for Tax Amounts	nvarchar	2	0	Allow NULL?
69	HWSTE_TRN	Tax Base Amount in Local Currency	decimal	15	2
70	HWSTE_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
71	FWSTE_TRN	Tax Base Amount in Local Currency	decimal	15	2
72	FWSTE_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
73	HWSTE2_TRN	Tax Base Amount in Local Currency	decimal	15	2
74	HWSTE2_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
75	FWSTE2_TRN	Tax Base Amount in Local Currency	decimal	15	2
76	FWSTE2_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
77	HWSTE3_TRN	Tax Base Amount in Local Currency	decimal	15	2
78	HWSTE3_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
79	FWSTE3_TRN	Tax Base Amount in Local Currency	decimal	15	2
80	FWSTE3_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
81	HWSTE5_TRN	Tax Base Amount in Local Currency	decimal	15	2
82	HWSTE5_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
83	FWSTE5_TRN	Tax Base Amount in Local Currency	decimal	15	2
84	FWSTE5_WRS_TRN	Currency Key	nvarchar	5	0	Allow NULL?
85	BKTXT_TRN	Document Header Text	nvarchar	25	0	Allow NULL?
86	LIFNR_CRED	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
87	NAME1_CRED	Name 1	nvarchar	35	0	Allow NULL?
88	NAME2_CRED	Name 2	nvarchar	35	0	Allow NULL?
89	NAME3_CRED	Name 3	nvarchar	35	0	Allow NULL?
90	NAME4_CRED	Name 4	nvarchar	35	0	Allow NULL?
91	NAME1_CRED_R	Name 1	nvarchar	35	0	Allow NULL?
92	NAME2_CRED_R	Name 2	nvarchar	35	0	Allow NULL?
93	NAME3_CRED_R	Name 3	nvarchar	35	0	Allow NULL?
94	NAME4_CRED_R	Name 4	nvarchar	35	0	Allow NULL?
95	STCD1_CRED	Tax Number 1	nvarchar	16	0	Allow NULL?
96	STCD3_CRED	Tax Number 3	nvarchar	18	0	Allow NULL?
97	XBLNR_INV	Reference Document Number	nvarchar	16	0	Allow NULL?
98	BKTXT_INV	Document Header Text	nvarchar	25	0	Allow NULL?
99	XBLNR_PAY	Reference Document Number	nvarchar	16	0	Allow NULL?
100	BKTXT_PAY	Document Header Text	nvarchar	25	0	Allow NULL?
101	MM_INV_BUDAT	Date of Goods Receipt	nvarchar	8	0	Allow NULL?
102	MM_INV_EBLN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
103	MM_INV_VOISO	Prelim. doc.: ISO code of ctry issuing the preliminary doc.	nvarchar	2	0	Allow NULL?
104	PART_PAYMENT	Partial Payment	char	1	0	Allow NULL?
105	LIGHTS	Icon ID (incl. @)	nvarchar	4	0	Allow NULL?
106	BOX	Flag for mark rec 01	char	1	0	Allow NULL?
107	NUM_LINE	Accounting Document Number	nvarchar	10	0	Allow NULL?
108	MM_INV_EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
109	EKBE_BELNR_MM	Number of Material Document	nvarchar	10	0	Allow NULL?
110	XREF1_INV	Business partner reference key	nvarchar	12	0	Allow NULL?
111	XREF1_DAT	Document Date in Document	nvarchar	8	0	Allow NULL?
112	HKONT_INV	General Ledger Account	nvarchar	10	0	Allow NULL?
113	HKONT_TRN	General Ledger Account	nvarchar	10	0	Allow NULL?
114	HKONT_CLN	General Ledger Account	nvarchar	10	0	Allow NULL?
115	USNAM_INV	User name	nvarchar	12	0	Allow NULL?
116	USNAM_PAY	User name	nvarchar	12	0	Allow NULL?
117	USNAM_PAY_FCT	User name	nvarchar	12	0	Allow NULL?
118	RESERV		smallint	5	0
119	MM_INV_VORNU	Character String - 256 User-Defined Characters	nvarchar	256	0	Allow NULL?

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

119 COLUMNS | 1 INDEXES | ERP 6.0 | J_3RBUE_BK_TABLE TABLE

TOP ERP 6.0 | J_3RBUE_BK_TABLE COLUMNS

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

119 COLUMNS | 1 INDEXES | ERP 6.0 | J_3RBUE_BK_TABLE TABLE

TOPERP 6.0 | J_3RBUE_BK_TABLE COLUMNS

TOPERP 6.0 | J_3RBUE_BK_TABLE INDEXES

TOP ERP 6.0 | J_3RBUE_BK_TABLE COLUMNS

TOP ERP 6.0 | J_3RBUE_BK_TABLE INDEXES