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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	LAUFD	Date on Which the Program Is to Be Run	nvarchar	8	0	Allow NULL?
3	LAUFI	Additional Identification	nvarchar	6	0	Allow NULL?
4	XVORL	Indicator: Only Proposal Run?	char	1	0	Allow NULL?
5	ZBUKR	Paying company code	nvarchar	4	0	Allow NULL?
6	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
7	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
8	EMPFG	Payee code	nvarchar	16	0	Allow NULL?
9	VBLNR	Document Number of the Payment Document	nvarchar	10	0	Allow NULL?
10	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
11	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
12	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
13	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
14	FILKD	Account Number of the Branch	nvarchar	10	0	Allow NULL?
15	ZLSCH	Payment Method	char	1	0	Allow NULL?
16	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
17	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
18	BVTYP	Partner Bank Type	nvarchar	4	0	Allow NULL?
19	POKEN	Item Indicator	nvarchar	3	0	Allow NULL?
20	XBLNR	Reference Document Number	nvarchar	16	0	Allow NULL?
21	BLART	Document Type	nvarchar	2	0	Allow NULL?
22	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
23	BLDAT	Document Date in Document	nvarchar	8	0	Allow NULL?
24	KOART	Account Type	char	1	0	Allow NULL?
25	BSCHL	Posting Key	nvarchar	2	0	Allow NULL?
26	HKONT	General Ledger Account	nvarchar	10	0	Allow NULL?
27	SAKNR	G/L Account Number	nvarchar	10	0	Allow NULL?
28	UMSKZ	Special G/L Indicator	char	1	0	Allow NULL?
29	UMSKS	Special G/L Transaction Type	char	1	0	Allow NULL?
30	ZUMSK	Target Special G/L Indicator	char	1	0	Allow NULL?
31	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
32	DMBTR	Amount in Local Currency	decimal	13	2
33	WRBTR	Amount in document currency	decimal	13	2
34	BDIFF	Valuation Difference	decimal	13	2
35	GSBER	Business Area	nvarchar	4	0	Allow NULL?
36	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
37	MWSTS	Tax Amount in Local Currency	decimal	13	2
38	WMWST	Tax amount in document currency	decimal	13	2
39	MWSK1	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
40	DMBT1	Amount in Local Currency for Tax Distribution	decimal	13	2
41	WRBT1	Amount in foreign currency for tax breakdown	decimal	13	2
42	MWSK2	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
43	DMBT2	Amount in Local Currency for Tax Distribution	decimal	13	2
44	WRBT2	Amount in foreign currency for tax breakdown	decimal	13	2
45	MWSK3	Tax Code for Distribution	nvarchar	2	0	Allow NULL?
46	DMBT3	Amount in Local Currency for Tax Distribution	decimal	13	2
47	WRBT3	Amount in foreign currency for tax breakdown	decimal	13	2
48	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
49	ZFBDT	Baseline Date for Due Date Calculation	nvarchar	8	0	Allow NULL?
50	ZTERM	Terms of Payment Key	nvarchar	4	0	Allow NULL?
51	ZBD1T	Cash discount days 1	decimal	3	0
52	ZBD2T	Cash discount days 2	decimal	3	0
53	ZBD3T	Net Payment Terms Period	decimal	3	0
54	ZBD1P	Cash Discount Percentage 1	decimal	5	3
55	ZBD2P	Cash Discount Percentage 2	decimal	5	3
56	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2
57	SKNTO	Cash discount amount in local currency	decimal	13	2
58	WSKTO	Cash discount amount in document currency	decimal	13	2
59	ZBFIX	Fixed Payment Terms	char	1	0	Allow NULL?
60	ZLSPR	Payment Block Key	char	1	0	Allow NULL?
61	SPLEV	Level on Which a Payment Block has Taken Place	char	1	0	Allow NULL?
62	XREBZ	Indicator: Item is an Invoice-Related Credit Memo	char	1	0	Allow NULL?
63	ZOLLT	Customs Tariff Number	nvarchar	8	0	Allow NULL?
64	ZOLLD	Customs Date	nvarchar	8	0	Allow NULL?
65	LZBKZ	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
66	LANDL	Supplying Country	nvarchar	3	0	Allow NULL?
67	DIEKZ	Service Indicator (Foreign Payment)	char	1	0	Allow NULL?
68	QSSKZ	Withholding Tax Code	nvarchar	2	0	Allow NULL?
69	QSSHB	Withholding Tax Base Amount	decimal	13	2
70	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2
71	QBSHH	Withholding Tax Amount (in Local Currency)	decimal	13	2
72	ESRNR	ISR Subscriber Number	nvarchar	11	0	Allow NULL?
73	ESRRE	ISR Reference Number	nvarchar	27	0	Allow NULL?
74	ESRPZ	ISR Check Digit	nvarchar	2	0	Allow NULL?
75	ZBDXT	Selected cash discount days	decimal	3	0
76	ZBDXP	Selected cash discount percentage rate	decimal	5	3
77	MSHBT	Maximum Cash Discount Amount in Local Currency	decimal	13	2
78	MSFBT	Maximum Cash Discount Amount in Foreign Currency	decimal	13	2
79	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	Allow NULL?
80	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
81	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
82	ANLN2	Asset Subnumber	nvarchar	4	0	Allow NULL?
83	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
84	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
85	XANET	Indicator: Down payment in net procedure ?	char	1	0	Allow NULL?
86	XNETB	Indicator: Document posted net ?	char	1	0	Allow NULL?
87	XNACH	Indicator: Document Data Must be Reread	char	1	0	Allow NULL?
88	ZWELS	List of the Payment Methods to be Considered	nvarchar	10	0	Allow NULL?
89	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
90	STCEG	VAT Registration Number	nvarchar	20	0	Allow NULL?
91	EGBLD	Country of Destination for Delivery of Goods	nvarchar	3	0	Allow NULL?
92	EGLLD	Supplying Country for Delivery of Goods	nvarchar	3	0	Allow NULL?
93	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	Allow NULL?
94	BDIF2	Valuation Difference for the Second Local Currency	decimal	13	2
95	DSKVH	Impending Lost Cash Discount in Local Currency	decimal	13	2
96	POKLA	Item Classification for Online Check Printing	char	1	0	Allow NULL?
97	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
98	PROJK	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
99	NPLNR	Network Number for Account Assignment	nvarchar	12	0	Allow NULL?
100	AUFPL	Routing number of operations in the order	nvarchar	10	0	Allow NULL?
101	APLZL	Internal counter	nvarchar	8	0	Allow NULL?
102	XEGDR	Indicator: Triangular deal within the EU ?	char	1	0	Allow NULL?
103	BDIF3	Valuation Difference for the Third Local Currency	decimal	13	2
104	DMBE2	Amount in Second Local Currency	decimal	13	2
105	DMBE3	Amount in Third Local Currency	decimal	13	2
106	MWST2	Tax Amount in Second Local Currency	decimal	13	2
107	SKNT2	Cash Discount Amount in Second Local Currency	decimal	13	2
108	SKNT3	Cash Discount Amount in Third Local Currency	decimal	13	2
109	QBSH2	Withholding Tax Amount in Second Local Currency	decimal	13	2
110	QBSH3	Withholding Tax Amount in Third Local Currency	decimal	13	2
111	DMB21	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
112	DMB22	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
113	DMB23	Amount in Second Local Currency for Tax Breakdown	decimal	13	2
114	DMB31	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
115	DMB32	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
116	DMB33	Amount in Third Local Currency for Tax Breakdown	decimal	13	2
117	UZAWE	Payment Method Supplement	nvarchar	2	0	Allow NULL?
118	MWST3	Tax Amount in Third Local Currency	decimal	13	2
119	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
120	OSKTO	Cash discount amount in local currency	decimal	13	2
121	VERTN	Contract Number	nvarchar	13	0	Allow NULL?
122	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	Allow NULL?
123	REBZT	Follow-On Document Type	char	1	0	Allow NULL?
124	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
125	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	Allow NULL?
126	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	Allow NULL?
127	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
128	XINVE	Indicator: Capital Goods Affected?	char	1	0	Allow NULL?
129	VBEL2	Sales Document	nvarchar	10	0	Allow NULL?
130	VPOS2	Numeric field: Length 6	nvarchar	6	0	Allow NULL?
131	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	Allow NULL?
132	POSN2	Sales Document Item	nvarchar	6	0	Allow NULL?
133	ETEN2	Delivery Schedule Line Number	nvarchar	4	0	Allow NULL?
134	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
135	GEBER	Fund	nvarchar	10	0	Allow NULL?
136	DABRZ	Reference Date for Settlement	nvarchar	8	0	Allow NULL?
137	KKBER	Credit control area	nvarchar	4	0	Allow NULL?
138	EMPFB	Payee/Payer	nvarchar	10	0	Allow NULL?
139	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
140	XREF1	Business partner reference key	nvarchar	12	0	Allow NULL?
141	XREF2	Business partner reference key	nvarchar	12	0	Allow NULL?
142	XREF3	Reference key for line item	nvarchar	20	0	Allow NULL?
143	ZINKZ	Exempted from interest calculation	nvarchar	2	0	Allow NULL?
144	DTWS1	Instruction key 1	nvarchar	2	0	Allow NULL?
145	DTWS2	Instruction key 2	nvarchar	2	0	Allow NULL?
146	DTWS3	Instruction key 3	nvarchar	2	0	Allow NULL?
147	DTWS4	Instruction key 4	nvarchar	2	0	Allow NULL?
148	MANSP	Dunning block	char	1	0	Allow NULL?
149	KIDNO	Payment Reference	nvarchar	30	0	Allow NULL?
150	XCPDD	Indicator: Address and bank data set individually	char	1	0	Allow NULL?
151	VERTT	Contract Type	char	1	0	Allow NULL?
152	VBEWA	Flow Type	nvarchar	4	0	Allow NULL?
153	AGZEI	Clearing Item	decimal	5	0
154	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	Allow NULL?
155	PSWBT	Amount for Updating in General Ledger	decimal	13	2
156	PSSKT	Cash Discount Deduction for the Item	decimal	13	2
157	XPYAM	Indicator: Payment Amount Predefined	char	1	0	Allow NULL?
158	GDIFF	Total Exchange Rate Difference	decimal	13	2
159	GDIF2	Total Exchange Rate Difference	decimal	13	2
160	GDIF3	Total Exchange Rate Difference	decimal	13	2
161	BUPLA	Business Place	nvarchar	4	0	Allow NULL?
162	SECCO	Section Code	nvarchar	4	0	Allow NULL?
163	XSAEN	Indicator: Unconfirmed master data change	char	1	0	Allow NULL?
164	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	Allow NULL?
165	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	Allow NULL?
166	CESSION_KZ	Accounts Receivable Pledging Indicator	nvarchar	2	0	Allow NULL?
167	KEYNO	Key Number for Payment Request	nvarchar	10	0	Allow NULL?
168	PAMTF	Payment Request Amount in Payment Currency	decimal	13	2
169	ORIGIN	Origin Indicator	nvarchar	8	0	Allow NULL?
170	PENLC1	Penalty charge amount in first local currency	decimal	13	2
171	PENLC2	Penalty charge amount in second local currency	decimal	13	2
172	PENLC3	Penalty Charge Amount in Third Local Currency	decimal	13	2
173	PENFC	Penalty charge amount in document currency	decimal	13	2
174	PENDAYS	Number of days for penalty charge calculation	int	10	0	Allow NULL?
175	PPRCT	Partner Profit Center	nvarchar	10	0	Allow NULL?
176	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
177	FKBER	Functional Area	nvarchar	16	0	Allow NULL?
178	SNAME1	Name 1	nvarchar	35	0	Allow NULL?
179	SORT01	City	nvarchar	35	0	Allow NULL?
180	SLAND1	Country Key	nvarchar	3	0	Allow NULL?
181	SAMNR	Invoice List Number	nvarchar	8	0	Allow NULL?
182	MABER	Dunning Area	nvarchar	2	0	Allow NULL?
183	BUDGET_PD	FM: Budget Period	nvarchar	10	0	Allow NULL?
184	SNAME2	Name 2	nvarchar	35	0	Allow NULL?
185	SNAME3	Name 3	nvarchar	35	0	Allow NULL?
186	SNAME4	Name 4	nvarchar	35	0	Allow NULL?
187	SSTRAS	House number and street	nvarchar	35	0	Allow NULL?
188	SSTRS2	House number and street	nvarchar	35	0	Allow NULL?
189	SPSTLZ	Postal code	nvarchar	10	0	Allow NULL?
190	SID	Original Payer of a Payment (ID)	nvarchar	35	0	Allow NULL?
191	EXTACCOUNT	External Account	nvarchar	10	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

191 COLUMNS | 1 INDEXES | ERP 6.0 | REGUP TABLE

TOP ERP 6.0 | REGUP COLUMNS

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

191 COLUMNS | 1 INDEXES | ERP 6.0 | REGUP TABLE

TOPERP 6.0 | REGUP COLUMNS

TOPERP 6.0 | REGUP INDEXES

TOP ERP 6.0 | REGUP COLUMNS

TOP ERP 6.0 | REGUP INDEXES