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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Materials Management :: Invoice Verification
1	ERP EHP7	6.0	RBKP	144	3	Document Header: Invoice Receipt	Invoice Verification

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	BELNR	Document Number of an Invoice Document	nvarchar	10	0	CHAR	(N' ')	No		RE_BELNR	Allow NULL?
3	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
4	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	No	T003	BLART	Allow NULL?
5	BLDAT	Document Date in Document	nvarchar	8	0	DATS	(N'00000000')	No		BLDAT	Allow NULL?
6	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	No		BUDAT	Allow NULL?
7	USNAM	User name	nvarchar	12	0	CHAR	(N' ')	No	*	USNAM	Allow NULL?
8	TCODE	Transaction Code	nvarchar	20	0	CHAR	(N' ')	No	TSTC	TCODE	Allow NULL?
9	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	DATS	(N'00000000')	No		CPUDT	Allow NULL?
10	CPUTM	Time of Entry	nvarchar	6	0	TIMS	(N'000000')	No		CPUTM	Allow NULL?
11	VGART	Transaction Type in AG08 (Internal Document Type)	nvarchar	2	0	CHAR	(N' ')	No		M8VGA	Allow NULL?
12	XBLNR	Reference Document Number	nvarchar	16	0	CHAR	(N' ')	No		XBLNR1	Allow NULL?
13	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
14	LIFNR	Different Invoicing Party	nvarchar	10	0	CHAR	(N' ')	No	LFA1	LIFRE	Allow NULL?
15	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	No	TCURC	WAERS	Allow NULL?
16	KURSF	Exchange rate	decimal	9	5	DEC	((0))	No		KURSF
17	RMWWR	Gross invoice amount in document currency	decimal	13	2	CURR	((0))	No		RMWWR
18	BEZNK	Unplanned delivery costs	decimal	13	2	CURR	((0))	No		BEZNK
19	WMWST1	Tax Amount in Document Currency with +/- Sign	decimal	13	2	CURR	((0))	No		FWSTEV
20	MWSKZ1	Tax code	nvarchar	2	0	CHAR	(N' ')	No	TMRM007A	MWSKZ_MRM1	Allow NULL?
21	WMWST2	Obsolete: tax amount in document currency - do NOT use!	decimal	13	2	CURR	((0))	Yes		FWSTEV_OLD
22	MWSKZ2	Obsolete: sales tax code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ_MRMO	Allow NULL?
23	ZTERM	Terms of Payment Key	nvarchar	4	0	CHAR	(N' ')	No		DZTERM	Allow NULL?
24	ZBD1T	Cash discount days 1	decimal	3	0	DEC	((0))	No		DZBD1T
25	ZBD1P	Cash Discount Percentage 1	decimal	5	3	DEC	((0))	No		DZBD1P
26	ZBD2T	Cash discount days 2	decimal	3	0	DEC	((0))	No		DZBD2T
27	ZBD2P	Cash Discount Percentage 2	decimal	5	3	DEC	((0))	No		DZBD2P
28	ZBD3T	Net Payment Terms Period	decimal	3	0	DEC	((0))	No		DZBD3T
29	WSKTO	Cash discount amount in document currency	decimal	13	2	CURR	((0))	No		WSKTO
30	XRECH	Indicator: post invoice	char	1	0	CHAR	(N' ')	No		XRECH	Allow NULL?
31	BKTXT	Document Header Text	nvarchar	25	0	CHAR	(N' ')	No		BKTXT	Allow NULL?
32	SAPRL	SAP Release	nvarchar	4	0	CHAR	(N' ')	No		SAPRL	Allow NULL?
33	LOGSYS	Logical system	nvarchar	10	0	CHAR	(N' ')	No	*	LOGSYS	Allow NULL?
34	XMWST	Calculate tax automatically	char	1	0	CHAR	(N' ')	No		XMWST	Allow NULL?
35	STBLG	Reversal document number	nvarchar	10	0	CHAR	(N' ')	Yes		RE_STBLG	Allow NULL?
36	STJAH	Fiscal year of reversal document	nvarchar	4	0	NUMC	(N'0000')	Yes		RE_STJAH	Allow NULL?
37	MWSKZ_BNK	Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ_MRM	Allow NULL?
38	TXJCD_BNK	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	*	TXJCD	Allow NULL?
39	IVTYP	Origin of a Logistics Invoice Verification Document	char	1	0	CHAR	(N' ')	Yes		IVTYP	Allow NULL?
40	XRBTX	Indicator: more than one tax code	char	1	0	CHAR	(N' ')	Yes		XRBTX	Allow NULL?
41	REPART	Indicator: Invoice Verification Type	char	1	0	CHAR	(N' ')	Yes		REPART	Allow NULL?
42	RBSTAT	Invoice document status	char	1	0	CHAR	(N' ')	Yes		RBSTAT	Allow NULL?
43	KNUMVE	Document condition - own conditions	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMVE	Allow NULL?
44	KNUMVL	Document condition - vendor error	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMVL	Allow NULL?
45	ARKUEN	Automatic Invoice Reduction Amount (Net)	decimal	13	2	CURR	((0))	Yes		ARKUEN
46	ARKUEMW	Sales Tax Portion of Automatic Invoice Reduction Amount	decimal	13	2	CURR	((0))	Yes		ARKUEMW
47	MAKZN	Manually accepted net difference amount	decimal	13	2	CURR	((0))	Yes		MAKZN
48	MAKZMW	Tax Amount Accepted Manually	decimal	13	2	CURR	((0))	Yes		MAKZMW
49	LIEFFN	Vendor error (exclusive of tax)	decimal	13	2	CURR	((0))	Yes		LIEFFN
50	LIEFFMW	Tax in vendor error	decimal	13	2	CURR	((0))	Yes		LIEFFMW
51	XAUTAKZ	Indicates automatically accepted invoices	char	1	0	CHAR	(N' ')	Yes		XAUTAKZ	Allow NULL?
52	ESRNR	ISR Subscriber Number	nvarchar	11	0	CHAR	(N' ')	Yes		ESRNR	Allow NULL?
53	ESRPZ	ISR Check Digit	nvarchar	2	0	CHAR	(N' ')	Yes		ESRPZ	Allow NULL?
54	ESRRE	ISR Reference Number	nvarchar	27	0	CHAR	(N' ')	Yes		ESRRE	Allow NULL?
55	QSSHB	Withholding Tax Base Amount	decimal	13	2	CURR	((0))	Yes		QSSHB
56	QSFBT	Withholding Tax-Exempt Amount (in Document Currency)	decimal	13	2	CURR	((0))	Yes		QSFBT
57	QSSKZ	Withholding Tax Code	nvarchar	2	0	CHAR	(N' ')	Yes	T059Q	QSSKZ	Allow NULL?
58	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	CHAR	(N' ')	Yes		DIEKZ	Allow NULL?
59	LANDL	Supplying Country	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LANDL	Allow NULL?
60	LZBKZ	State Central Bank Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	T015L	LZBKZ	Allow NULL?
61	TXKRS	Exchange Rate for Taxes	decimal	9	5	DEC	((0))	Yes		TXKRS_BKPF
62	EMPFB	Payee/Payer	nvarchar	10	0	CHAR	(N' ')	Yes		EMPFB	Allow NULL?
63	BVTYP	Partner Bank Type	nvarchar	4	0	CHAR	(N' ')	Yes		BVTYP	Allow NULL?
64	HBKID	Short Key for a House Bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	HBKID	Allow NULL?
65	ZUONR	Assignment Number	nvarchar	18	0	CHAR	(N' ')	Yes		DZUONR	Allow NULL?
66	ZLSPR	Payment Block Key	char	1	0	CHAR	(N' ')	Yes	T008	DZLSPR	Allow NULL?
67	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	T042Z	DZLSCH	Allow NULL?
68	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	DATS	(N'00000000')	Yes		DZFBDT	Allow NULL?
69	KIDNO	Payment Reference	nvarchar	30	0	CHAR	(N' ')	Yes		KIDNO	Allow NULL?
70	REBZG	Invoice Reference: Document Number for Invoice Reference	nvarchar	10	0	CHAR	(N' ')	Yes		AWREF_REB	Allow NULL?
71	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	NUMC	(N'0000')	Yes		REBZJ	Allow NULL?
72	XINVE	Indicator: Capital Goods Affected?	char	1	0	CHAR	(N' ')	Yes		XINVE	Allow NULL?
73	EGMLD	Reporting Country for Delivery of Goods within the EU	nvarchar	3	0	CHAR	(N' ')	Yes	*	EGMLD_BSEZ	Allow NULL?
74	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	CHAR	(N' ')	Yes		XEGDR	Allow NULL?
75	VATDATE	Tax Reporting Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VATDATE	Allow NULL?
76	HKONT	General Ledger Account	nvarchar	10	0	CHAR	(N' ')	Yes	*	HKONT	Allow NULL?
77	J_1BNFTYPE	Nota Fiscal Type	nvarchar	2	0	CHAR	(N' ')	Yes	J_1BAA	J_1BNFTYPE	Allow NULL?
78	BRNCH	Branch Number	nvarchar	4	0	CHAR	(N' ')	Yes	J_1BBRANCH	J_1ABRNCH	Allow NULL?
79	ERFPR	Entry profile: Logistics Invoice Verification	nvarchar	12	0	CHAR	(N' ')	Yes	T169H	ERFPR	Allow NULL?
80	SECCO	Section Code	nvarchar	4	0	CHAR	(N' ')	Yes	SECCODE	SECCO	Allow NULL?
81	NAME1	Name 1	nvarchar	35	0	CHAR	(N' ')	Yes		NAME1_GP	Allow NULL?
82	NAME2	Name 2	nvarchar	35	0	CHAR	(N' ')	Yes		NAME2_GP	Allow NULL?
83	NAME3	Name 3	nvarchar	35	0	CHAR	(N' ')	Yes		NAME3_GP	Allow NULL?
84	NAME4	Name 4	nvarchar	35	0	CHAR	(N' ')	Yes		NAME4_GP	Allow NULL?
85	PSTLZ	Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTLZ	Allow NULL?
86	ORT01	City	nvarchar	35	0	CHAR	(N' ')	Yes		ORT01_GP	Allow NULL?
87	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	*	LAND1_GP	Allow NULL?
88	STRAS	House number and street	nvarchar	35	0	CHAR	(N' ')	Yes		STRAS_GP	Allow NULL?
89	PFACH	PO Box	nvarchar	10	0	CHAR	(N' ')	Yes		PFACH	Allow NULL?
90	PSTL2	P.O. Box Postal Code	nvarchar	10	0	CHAR	(N' ')	Yes		PSTL2	Allow NULL?
91	PSKTO	Account Number of Bank Account At Post Office	nvarchar	16	0	CHAR	(N' ')	Yes		PSKTO	Allow NULL?
92	BANKN	Bank account number	nvarchar	18	0	CHAR	(N' ')	Yes		BANKN	Allow NULL?
93	BANKL	Bank number	nvarchar	15	0	CHAR	(N' ')	Yes		BANKL	Allow NULL?
94	BANKS	Bank country key	nvarchar	3	0	CHAR	(N' ')	Yes	*	BANKS	Allow NULL?
95	STCD1	Tax Number 1	nvarchar	16	0	CHAR	(N' ')	Yes		STCD1	Allow NULL?
96	STCD2	Tax Number 2	nvarchar	11	0	CHAR	(N' ')	Yes		STCD2	Allow NULL?
97	STKZU	Liable for VAT	char	1	0	CHAR	(N' ')	Yes		STKZU	Allow NULL?
98	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	0	CHAR	(N' ')	Yes		STKZA	Allow NULL?
99	REGIO	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	*	REGIO	Allow NULL?
100	BKONT	Bank Control Key	nvarchar	2	0	CHAR	(N' ')	Yes		BKONT	Allow NULL?
101	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	CHAR	(N' ')	Yes	*	DTAWS	Allow NULL?
102	DTAMS	Indicator for Data Medium Exchange	char	1	0	CHAR	(N' ')	Yes		DTAMS	Allow NULL?
103	SPRAS	Character field of length 1	char	1	0	CHAR	(N' ')	Yes		CHAR_LG_01	Allow NULL?
104	XCPDK	Indicator: Is the account a one-time account?	char	1	0	CHAR	(N' ')	Yes		XCPDK	Allow NULL?
105	EMPFG	Payee code	nvarchar	16	0	CHAR	(N' ')	Yes		EMPFG	Allow NULL?
106	FITYP	Tax type	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1AFITP_D	Allow NULL?
107	STCDT	Tax Number Type	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_1ATOID	Allow NULL?
108	STKZN	Natural Person	char	1	0	CHAR	(N' ')	Yes		STKZN	Allow NULL?
109	STCD3	Tax Number 3	nvarchar	18	0	CHAR	(N' ')	Yes		STCD3	Allow NULL?
110	STCD4	Tax Number 4	nvarchar	18	0	CHAR	(N' ')	Yes		STCD4	Allow NULL?
111	BKREF	Reference specifications for bank details	nvarchar	20	0	CHAR	(N' ')	Yes		BKREF	Allow NULL?
112	J_1KFREPRE	Name of Representative	nvarchar	10	0	CHAR	(N' ')	Yes		REPRES	Allow NULL?
113	J_1KFTBUS	Type of Business	nvarchar	30	0	CHAR	(N' ')	Yes	*	GESTYP	Allow NULL?
114	J_1KFTIND	Type of Industry	nvarchar	30	0	CHAR	(N' ')	Yes	*	INDTYP	Allow NULL?
115	ANRED	Title	nvarchar	15	0	CHAR	(N' ')	Yes		ANRED	Allow NULL?
116	STCEG	VAT Registration Number	nvarchar	20	0	CHAR	(N' ')	Yes		STCEG	Allow NULL?
117	ERNAME	Entered by external system user	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAME	Allow NULL?
118	REINDAT	Invoice Receipt Date	nvarchar	8	0	DATS	(N'00000000')	Yes		REINDAT	Allow NULL?
119	UZAWE	Payment Method Supplement	nvarchar	2	0	CHAR	(N' ')	Yes	*	UZAWE	Allow NULL?
120	FDLEV	Planning level	nvarchar	2	0	CHAR	(N' ')	Yes	*	FDLEV	Allow NULL?
121	FDTAG	Planning date	nvarchar	8	0	DATS	(N'00000000')	Yes		FDTAG	Allow NULL?
122	ZBFIX	Fixed Payment Terms	char	1	0	CHAR	(N' ')	Yes		DZBFIX	Allow NULL?
123	FRGKZ	Indicator: Release Required	char	1	0	CHAR	(N' ')	Yes		DFRGKZ	Allow NULL?
124	ERFNAM	Name of the Processor Who Entered the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERFNAM	Allow NULL?
125	BUPLA	Business Place	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUPLA	Allow NULL?
126	FILKD	Account Number of the Branch	nvarchar	10	0	CHAR	(N' ')	Yes		FILKD	Allow NULL?
127	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	*	GSBER	Allow NULL?
128	LOTKZ	Lot Number for Documents	nvarchar	10	0	CHAR	(N' ')	Yes		LOTKZ	Allow NULL?
129	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
130	INV_TRAN	Transaction in Logistics Invoice Verification	char	1	0	CHAR	(N' ')	Yes		INV_TRAN	Allow NULL?
131	PREPAY_STATUS	Prepayment Status	char	1	0	CHAR	(N' ')	Yes		WRF_PREPAY_STATUS	Allow NULL?
132	PREPAY_AWKEY	Invoice Document Number Created for Prepayment	nvarchar	20	0	CHAR	(N' ')	Yes		WRF_PREPAY_AWKEY	Allow NULL?
133	ASSIGN_STATUS	Is the invoice in the assignment test process?	char	1	0	CHAR	(N' ')	Yes		WRF_MRM_ASSIGN_STATUS	Allow NULL?
134	ASSIGN_NEXT_DATE	Date of Next Assignment Test	nvarchar	8	0	DATS	(N'00000000')	Yes		WRF_MRM_ASSIGN_NEXT_DATE	Allow NULL?
135	ASSIGN_END_DATE	End Date of Assignment Test Period	nvarchar	8	0	DATS	(N'00000000')	Yes		WRF_MRM_ASSIGN_END_DATE	Allow NULL?
136	COPY_BY_BELNR	Invoice Document Number of Original Invoice	nvarchar	10	0	CHAR	(N' ')	Yes		COPY_BY_BELNR	Allow NULL?
137	COPY_BY_YEAR	Fiscal Year of Original Invoice	nvarchar	4	0	NUMC	(N'0000')	Yes		COPY_BY_YEAR	Allow NULL?
138	COPY_TO_BELNR	Invoice Document Number of Copied Invoice	nvarchar	10	0	CHAR	(N' ')	Yes		COPY_TO_BELNR	Allow NULL?
139	COPY_TO_YEAR	Fiscal Year of Copied Invoice	nvarchar	4	0	NUMC	(N'0000')	Yes		COPY_TO_YEAR	Allow NULL?
140	COPY_USER	User That Reversed and Copied the Invoice	nvarchar	12	0	CHAR	(N' ')	Yes		COPY_USER	Allow NULL?
141	KURSX	Market Data Exchange Rate	decimal	28	14	DEC	((0))	Yes		GLE_FXR_DTE_RATEX28
142	WWERT	Translation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WWERT_D	Allow NULL?
143	XREF3	Reference key for line item	nvarchar	20	0	CHAR	(N' ')	Yes		XREF3	Allow NULL?
144	J_1TPBUPL	Branch Code	nvarchar	5	0	CHAR	(N' ')	Yes		BCODE	Allow NULL?

Name	Primary	Unique	Type	Columns
RBKP~0	Yes	Yes	CLUSTERED	GJAHR, BELNR, MANDT
RBKP~3	No	No	NONCLUSTERED	IVTYP, RBSTAT, USNAM, MANDT
RBKP~5	No	No	NONCLUSTERED	IVTYP, RBSTAT, ERFNAM, 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

144 COLUMNS | 3 INDEXES | ERP 6.0 | RBKP TABLE

TOP ERP 6.0 | RBKP COLUMNS

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

144 COLUMNS | 3 INDEXES | ERP 6.0 | RBKP TABLE

TOPERP 6.0 | RBKP COLUMNS

TOPERP 6.0 | RBKP INDEXES

TOP ERP 6.0 | RBKP COLUMNS

TOP ERP 6.0 | RBKP INDEXES