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	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
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	RFITEMAP_NO_ITEM	147	1	Item wise detail for the Vendor Transactions	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	KONTO	Account Number	nvarchar	10	0	Allow NULL?
4	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
5	SEQNO	Numeric Character Field, Length 10	nvarchar	10	0	Allow NULL?
6	UNAME	User Name	nvarchar	12	0	Allow NULL?
7	ACTIV	List Level in which the Line Item is Active	nvarchar	2	0	Allow NULL?
8	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
9	ANLN2	New asset subnumber, 4 characters	nvarchar	4	0	Allow NULL?
10	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	Allow NULL?
12	AUGDT	Clearing Date	nvarchar	8	0	Allow NULL?
13	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
14	BLART	Document Type	nvarchar	2	0	Allow NULL?
15	BLDAT	Document Date in Document	nvarchar	8	0	Allow NULL?
16	BSCHL	Posting Key	nvarchar	2	0	Allow NULL?
17	BSTAT	Document Status	char	1	0	Allow NULL?
18	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
19	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
20	BWWRT	Valuated Amount in Local Currency	decimal	15	2
21	BWWRC	Valuated Amount in Local Currency	decimal	15	2
22	BWWR2	Amount Valuated in Local Currency 2	decimal	15	2
23	BWWR3	Amount Valuated in Local Currency 3	decimal	15	2
24	DMSHB	Amount in Local Currency with +/- Signs	decimal	15	2
25	HWAER	Local Currency	nvarchar	5	0	Allow NULL?
26	DMBE2	Amount in Second Local Currency	decimal	15	2
27	HWAE2	Currency Key of Second Local Currency	nvarchar	5	0	Allow NULL?
28	DMBE3	Amount in Third Local Currency	decimal	15	2
29	HWAE3	Currency Key of Third Local Currency	nvarchar	5	0	Allow NULL?
30	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
31	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
32	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	Allow NULL?
33	FAEDT	Net Due Date	nvarchar	8	0	Allow NULL?
34	FILKD	Account Number of the Branch	nvarchar	10	0	Allow NULL?
35	GSBER	Business Area	nvarchar	4	0	Allow NULL?
36	JAMON	Fiscal Year/Posting Period from Posting Date	nvarchar	7	0	Allow NULL?
37	KOART	Account Type	char	1	0	Allow NULL?
38	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
39	MABER	Dunning Area	nvarchar	2	0	Allow NULL?
40	MADAT	Last dunned on	nvarchar	8	0	Allow NULL?
41	MANSP	Dunning block	char	1	0	Allow NULL?
42	MANST	Dunning level	char	1	0	Allow NULL?
43	MONAT	Fiscal Period	nvarchar	2	0	Allow NULL?
44	MSCHL	Dunning key	char	1	0	Allow NULL?
45	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
46	POSN2	Sales Document Item	nvarchar	6	0	Allow NULL?
47	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
48	QBSHB	Withholding Tax Amount in Document Currency	decimal	15	2
49	QSFBT	Withholding Tax Exempt Amount in Document Currency	decimal	15	2
50	QSSHB	Withholding Tax Base Amount in Document Currency	decimal	15	2
51	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
52	SAMNR	Invoice List Number	nvarchar	8	0	Allow NULL?
53	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
54	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
55	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	15	2
56	WSKTO	Cash Discount Amount in Document Currency	decimal	15	2
57	SKNTO	Cash Discount Amount in Local Currency	decimal	15	2
58	STAKZ	Indicator: Statistical document ?	char	1	0	Allow NULL?
59	UMSKS	Special G/L Transaction Type	char	1	0	Allow NULL?
60	UMSKZ	Special G/L Indicator	char	1	0	Allow NULL?
61	UZAWE	Payment Method Supplement	nvarchar	2	0	Allow NULL?
62	VALUT	Value date	nvarchar	8	0	Allow NULL?
63	VBEL2	Sales Document	nvarchar	10	0	Allow NULL?
64	VBELN	Billing Document	nvarchar	10	0	Allow NULL?
65	VBEWA	Flow Type	nvarchar	4	0	Allow NULL?
66	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
67	VERTN	Contract Number	nvarchar	13	0	Allow NULL?
68	VERTT	Contract Type	char	1	0	Allow NULL?
69	VERZ1	Days in Arrears for Cash Discount Terms 1	decimal	5	0
70	VERZN	Days in Arrears by Net Due Date	decimal	5	0
71	WERKS	Plant	nvarchar	4	0	Allow NULL?
72	WRSHB	Amount in Document Currency (Foreign Currency)	decimal	15	2
73	WRSHC	Amount in Document Currency (Foreign Currency)	decimal	15	2
74	WAERS	Document Currency (Key)	nvarchar	5	0	Allow NULL?
75	WVERW	Bill of exchange usage type	char	1	0	Allow NULL?
76	XBLNR	Reference Document Number	nvarchar	16	0	Allow NULL?
77	XSTRP	Indicator: Disputed item?	char	1	0	Allow NULL?
78	XZAHL	Indicator: Is the posting key used in a payment transaction?	char	1	0	Allow NULL?
79	ZALDT	Probable Payment Date (Cash Discount 1 Due)	nvarchar	8	0	Allow NULL?
80	ZBD1P	Cash Discount Percentage 1	decimal	5	3
81	ZBD1T	Cash discount days 1	decimal	3	0
82	ZBD2P	Cash Discount Percentage 2	decimal	5	3
83	ZBD2T	Cash discount days 2	decimal	3	0
84	ZBD3T	Net Payment Terms Period	decimal	3	0
85	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	Allow NULL?
86	ZINSZ	Interest Calculation Numerator (Days in Arrears * Amount)	decimal	15	2
87	ZLSCH	Payment Method	char	1	0	Allow NULL?
88	ZLSPR	Payment Block Key	char	1	0	Allow NULL?
89	ZTERM	Terms of Payment Key	nvarchar	4	0	Allow NULL?
90	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
91	XREF1	Business partner reference key	nvarchar	12	0	Allow NULL?
92	XREF2	Business partner reference key	nvarchar	12	0	Allow NULL?
93	XARCH	Indicator: Document already archived ?	char	1	0	Allow NULL?
94	RSTGR	Reason Code for Payments	nvarchar	3	0	Allow NULL?
95	ASKTO	Current Cash Discount Amount in Document Currency	decimal	15	2
96	KURSE	Effective Exchange Rate in the Line Item	decimal	9	5
97	REBZT	Follow-On Document Type	char	1	0	Allow NULL?
98	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	Allow NULL?
99	PSWBT	Amount for General Ledger Update (Absolute)	decimal	15	2
100	HKONT	General Ledger Account	nvarchar	10	0	Allow NULL?
101	XNEGP	Indicator: Negative posting	char	1	0	Allow NULL?
102	ZBFIX	Fixed Payment Terms	char	1	0	Allow NULL?
103	RFZEI	Payment Card Item	nvarchar	3	0	Allow NULL?
104	CCBTC	Payment cards: Settlement run	nvarchar	10	0	Allow NULL?
105	KKBER	Credit control area	nvarchar	4	0	Allow NULL?
106	XREF3	Reference key for line item	nvarchar	20	0	Allow NULL?
107	DTWS1	Instruction key 1	nvarchar	2	0	Allow NULL?
108	DTWS2	Instruction key 2	nvarchar	2	0	Allow NULL?
109	DTWS3	Instruction key 3	nvarchar	2	0	Allow NULL?
110	DTWS4	Instruction key 4	nvarchar	2	0	Allow NULL?
111	ABSBT	Credit Management: Hedged Amount (Absolute)	decimal	15	2
112	KKBWR	Currency of Credit Control Area	nvarchar	5	0	Allow NULL?
113	PROJK	Individual Structural Element (WBS Element) in Ext. Format	nvarchar	24	0	Allow NULL?
114	XPYPR	Indicator: Items from Payment Program Blocked	char	1	0	Allow NULL?
115	KIDNO	Payment Reference	nvarchar	30	0	Allow NULL?
116	XAUGP	Indicator: Item has been cleared?	char	1	0	Allow NULL?
117	BUPLA	Business Place	nvarchar	4	0	Allow NULL?
118	SECCO	Section Code	nvarchar	4	0	Allow NULL?
119	GKART	Offsetting Account Type	char	1	0	Allow NULL?
120	GKONT	Offsetting Account Number	nvarchar	10	0	Allow NULL?
121	PYCUR	Currency for Automatic Payment	nvarchar	5	0	Allow NULL?
122	PYAMT	Amount in Automatic Payment Currency (Absolute)	decimal	15	2
123	PYORD	Payment Order	nvarchar	10	0	Allow NULL?
124	XTEXT	Indicator: Texts exist ?	char	1	0	Allow NULL?
125	TDID	Text ID	nvarchar	4	0	Allow NULL?
126	XDUEN	Indicator: Item is due net?	char	1	0	Allow NULL?
127	XDUE1	Indicator: Cash discount term 1 is due on item?	char	1	0	Allow NULL?
128	XRAGL	Indicator: Clearing was Reversed	char	1	0	Allow NULL?
129	XSELP	Item selected (selected, chosen, ...)	char	1	0	Allow NULL?
130	COLOR	Color of Line Item in the List	nvarchar	3	0	Allow NULL?
131	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	Allow NULL?
132	BUZID	Identification of the Line Item	char	1	0	Allow NULL?
133	AUGGJ	Fiscal Year of Clearing Document	nvarchar	4	0	Allow NULL?
134	AGZEI	Clearing Item	decimal	5	0
135	SYM_AUGP	Item Status Symbol	nvarchar	2	0	Allow NULL?
136	ICO_AUGP	Cleared/Open Items Symbol	nvarchar	34	0	Allow NULL?
137	ICO_DUE	Net Due Date Symbol	nvarchar	34	0	Allow NULL?
138	ICO_DUE1	Discount 1 Due Date Symbol	nvarchar	34	0	Allow NULL?
139	SORT	Sort Key for Line Item Report	int	10	0	Allow NULL?
140	U_STBLG	Reverse Document Number	nvarchar	10	0	Allow NULL?
141	U_BWSHB1	Valuation Difference for Line Item Display	decimal	15	2
142	U_PSTLZ	Postal Code	nvarchar	10	0	Allow NULL?
143	U_FWBAS	Tax Base Amount in Document Currency	decimal	13	2
144	U_REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
145	U_CHECF	Check Number From	nvarchar	13	0	Allow NULL?
146	STCEG	VAT Registration Number	nvarchar	20	0	Allow NULL?
147	ACNAM	G/L Account Long Text	nvarchar	50	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

147 COLUMNS | 1 INDEXES | ERP 6.0 | RFITEMAP_NO_ITEM TABLE

TOP ERP 6.0 | RFITEMAP_NO_ITEM COLUMNS

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

147 COLUMNS | 1 INDEXES | ERP 6.0 | RFITEMAP_NO_ITEM TABLE

TOPERP 6.0 | RFITEMAP_NO_ITEM COLUMNS

TOPERP 6.0 | RFITEMAP_NO_ITEM INDEXES

TOP ERP 6.0 | RFITEMAP_NO_ITEM COLUMNS

TOP ERP 6.0 | RFITEMAP_NO_ITEM INDEXES