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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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 Services :: Loans Management
1	ERP EHP7	6.0	VDBEPP	182	2	Flow Data - Planned Item	Loans Management

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	RANL	Contract Number	nvarchar	13	0	Allow NULL?
4	DTRANS	Flow data key: System date	nvarchar	8	0	Allow NULL?
5	TTRANS	Transaction data key: system time	nvarchar	6	0	Allow NULL?
6	NTRANS	Transaction data key: Consecutive number	nvarchar	4	0	Allow NULL?
7	RERF	Entered by	nvarchar	12	0	Allow NULL?
8	DERF	First Entered on	nvarchar	8	0	Allow NULL?
9	TERF	Time of Initial Entry	nvarchar	6	0	Allow NULL?
10	REHER	Source of initial entry	nvarchar	10	0	Allow NULL?
11	RBEAR	Employee ID	nvarchar	12	0	Allow NULL?
12	DBEAR	Last Edited on	nvarchar	8	0	Allow NULL?
13	TBEAR	Last Edited at	nvarchar	6	0	Allow NULL?
14	RBHER	Editing Source	nvarchar	10	0	Allow NULL?
15	DVORGANG	Activity date	nvarchar	8	0	Allow NULL?
16	SVORGANG	Business Operation (Activity)	nvarchar	4	0	Allow NULL?
17	NVORGANG	Activity number	nvarchar	3	0	Allow NULL?
18	SBEWART	Flow Type	nvarchar	4	0	Allow NULL?
19	SREFBEW	Reference flow type	nvarchar	4	0	Allow NULL?
20	SBEWZITI	Flow category	nvarchar	4	0	Allow NULL?
21	SPLANIST	Plan/actual record/record to be released indicator	char	1	0	Allow NULL?
22	SSOLHAB	Debit/credit indicator	char	1	0	Allow NULL?
23	SSTORNO	Reversal indicator	char	1	0	Allow NULL?
24	SSTOGRD	Reason for Reversal	nvarchar	2	0	Allow NULL?
25	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
26	RSTBLG	Reverse Document Number	nvarchar	10	0	Allow NULL?
27	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
28	SANLF	Product Category	nvarchar	3	0	Allow NULL?
29	DGUEL_KK	Date Condition Effective from	nvarchar	8	0	Allow NULL?
30	NLFD_ANG	Offer consecutive number	nvarchar	3	0	Allow NULL?
31	SSTATI	Status of data record	nvarchar	2	0	Allow NULL?
32	GSART	Product Type	nvarchar	3	0	Allow NULL?
33	RREFKONT	Account Assignment Reference in Financial Assets Management	nvarchar	8	0	Allow NULL?
34	GSBER	Business Area	nvarchar	4	0	Allow NULL?
35	DORDER	Order day	nvarchar	8	0	Allow NULL?
36	NORDER	Order Number	nvarchar	8	0	Allow NULL?
37	BNWHR	Nominal amount	decimal	13	2
38	SNWHR	Currency of nominal amount	nvarchar	5	0	Allow NULL?
39	BBWHR	Amount in position currency	decimal	13	2
40	SBWHR	Position Currency (Currency of Position Amount)	nvarchar	5	0	Allow NULL?
41	BCWHR	Settlement Amount	decimal	13	2
42	SCWHR	Settlement Currency	nvarchar	5	0	Allow NULL?
43	BHWHR	Amount in local currency	decimal	13	2
44	KURS1	Exchange rate	decimal	9	5
45	KURS2	Exchange rate	decimal	9	5
46	DVALUT	Calculation Date	nvarchar	8	0	Allow NULL?
47	DFAELL	Due date/calculation date	nvarchar	8	0	Allow NULL?
48	DDISPO	Payment Date	nvarchar	8	0	Allow NULL?
49	DBESTAND	Position value date	nvarchar	8	0	Allow NULL?
50	DBERVON	Start of Calculation Period	nvarchar	8	0	Allow NULL?
51	DBERBIS	End of Calculation Period	nvarchar	8	0	Allow NULL?
52	ATAGE	Number of days	nvarchar	6	0	Allow NULL?
53	ABASTAGE	Number of base days in a calculation period	nvarchar	6	0	Allow NULL?
54	SZBMETH	Interest Calculation Method	char	1	0	Allow NULL?
55	UMSKZ	Special G/L Indicator	char	1	0	Allow NULL?
56	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
57	SSPESEN	Expenses key	char	1	0	Allow NULL?
58	RSOLL	Account for debit posting	nvarchar	10	0	Allow NULL?
59	RHABEN	Account for credit posting	nvarchar	10	0	Allow NULL?
60	RZKSOLL	Debit interim account	nvarchar	10	0	Allow NULL?
61	RZKHABE	Credit interim account	nvarchar	10	0	Allow NULL?
62	SBSLSOLL	Posting Key	nvarchar	2	0	Allow NULL?
63	SBSLZKSO	Posting Key	nvarchar	2	0	Allow NULL?
64	SBSLZKHA	Posting Key	nvarchar	2	0	Allow NULL?
65	SHSLHABEN	Posting Key	nvarchar	2	0	Allow NULL?
66	RBANKK	Bank account	nvarchar	10	0	Allow NULL?
67	SFDLEV	Planning level	nvarchar	2	0	Allow NULL?
68	JFDUPD	Record transferred to cash management and forecast	char	1	0	Allow NULL?
69	JONLAEN	Indicator for fixing a flow record	char	1	0	Allow NULL?
70	JZINSBAS	Flow in interest base	char	1	0	Allow NULL?
71	JZINSZPT	Interest date	char	1	0	Allow NULL?
72	PKOND	Percentage rate for condition items	decimal	10	7
73	BBASIS	Calculation base amount	decimal	13	2
74	SSORTZIT	Sort indicator for interest/repayment schedule calculations	char	1	0	Allow NULL?
75	SWOHER	Source of flow record	char	1	0	Allow NULL?
76	SSTCKKZ	Accrued interest method	char	1	0	Allow NULL?
77	SSTCKTG	Accrued interest: Daily method	char	1	0	Allow NULL?
78	PEFFZINS	Effective Interest Rate	decimal	10	7
79	SEFFMETH	Effective Interest Method (Financial Mathematics)	char	1	0	Allow NULL?
80	JVERF	Indicator whether drawings exist for the disbursement	char	1	0	Allow NULL?
81	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
82	BVTYP	Partner Bank Type	nvarchar	4	0	Allow NULL?
83	ZLSCH	Payment Method	char	1	0	Allow NULL?
84	MABER	Dunning Area	nvarchar	2	0	Allow NULL?
85	ZAHLS	Block Key for Payment	char	1	0	Allow NULL?
86	RPARTNR	Business Partner Number	nvarchar	10	0	Allow NULL?
87	SROLEXT	Dummy function	nvarchar	3	0	Allow NULL?
88	RKLAMMER	Classification Number for Finance Projects	nvarchar	13	0	Allow NULL?
89	JEINBEHALT	Indicator for withholding of amount during disbursement	char	1	0	Allow NULL?
90	SZEGEN	Generate incoming payment immediately	nvarchar	2	0	Allow NULL?
91	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
92	DTRANSREF	Flow data key: System date	nvarchar	8	0	Allow NULL?
93	TTRANSREF	Transaction data key: system time	nvarchar	6	0	Allow NULL?
94	NTRANSREF	Transaction data key: Consecutive number	nvarchar	4	0	Allow NULL?
95	RPNNR	Daybook no.	nvarchar	10	0	Allow NULL?
96	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
97	SBUST	Posting control key	nvarchar	2	0	Allow NULL?
98	PWKURS	Security price for percentage quotation	decimal	10	7
99	DSTOCK	Premium reserve fund date	nvarchar	8	0	Allow NULL?
100	JVORAUS	ID for planned record reference to an advance payment	char	1	0	Allow NULL?
101	AMMRHY	Frequency in months	nvarchar	3	0	Allow NULL?
102	SKOART	Condition Type (Smallest Subdivision of Condition Records)	nvarchar	4	0	Allow NULL?
103	SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	char	1	0	Allow NULL?
104	SULTVON	Month-End Indicator for Start of a Calculation Period	char	1	0	Allow NULL?
105	SINCLBIS	Inclusive Indicator for the End of a Calculation Period	char	1	0	Allow NULL?
106	SULTBIS	Month-End Indicator for the End of a Calculation Period	char	1	0	Allow NULL?
107	SINCL	Inclusive indicator for beginning and end of a period	char	1	0	Allow NULL?
108	DVERRECH	Settlement date	nvarchar	8	0	Allow NULL?
109	DPKOND	Determination date for percentage rate of condition items	nvarchar	8	0	Allow NULL?
110	RUMBLG	Reference transfer document number	nvarchar	10	0	Allow NULL?
111	ZINKZ	Exempted from interest calculation	nvarchar	2	0	Allow NULL?
112	SVULT	Month-End Indicator for Value Date	char	1	0	Allow NULL?
113	JSOFVERR	Immediate settlement	char	1	0	Allow NULL?
114	SINCLVERR	Inclusive Indicator for Clearing Date	char	1	0	Allow NULL?
115	SULTVERR	Month-End Indicator for Clearing Date	char	1	0	Allow NULL?
116	SREFZITI	Refer.flow category in accrual/deferral flow records	nvarchar	4	0	Allow NULL?
117	STGBASIS	Base Days Method	char	1	0	Allow NULL?
118	STGMETH	Daily Method	char	1	0	Allow NULL?
119	SBASIS	Calculation base reference	nvarchar	4	0	Allow NULL?
120	SBERFIMA	Calculation category for cash flow calculator	nvarchar	4	0	Allow NULL?
121	SVORGKZ	Activity indicator for debit/credit control	nvarchar	2	0	Allow NULL?
122	MANSP	Dunning block	char	1	0	Allow NULL?
123	DGUEL_KP	Condition Item Valid From	nvarchar	8	0	Allow NULL?
124	NSTUFE	Level number of condition item for recurring payments	nvarchar	2	0	Allow NULL?
125	DBPERIOD	Period start	nvarchar	8	0	Allow NULL?
126	SPAEXCL	Exclusive Indicator for Start Date of a Period	char	1	0	Allow NULL?
127	SPAULT	Month-End Indicator for Start Date of a Period	char	1	0	Allow NULL?
128	DEPERIOD	Period End	nvarchar	8	0	Allow NULL?
129	SPEINCL	Inclusive Indicator for End Date of a Period	char	1	0	Allow NULL?
130	SPEULT	Month-End Indicator for End of a Period	char	1	0	Allow NULL?
131	RKONT	Quota number	nvarchar	6	0	Allow NULL?
132	DAUSZ	Lead date for withholding amounts for disbursement	nvarchar	8	0	Allow NULL?
133	SSOLIST	Calculation using actual principle (or debit)	char	1	0	Allow NULL?
134	RDARNEHM	Borrower/Applicant Number	nvarchar	10	0	Allow NULL?
135	BKOND	Condition item currency amount	decimal	13	2
136	RZEBEL	Document number of waiver/write-off document	nvarchar	10	0	Allow NULL?
137	ZFBDT	Payment Date	nvarchar	8	0	Allow NULL?
138	DZFEST	Interest rate fixing date	nvarchar	8	0	Allow NULL?
139	SBERECH	Grace Period Interest Method	char	1	0	Allow NULL?
140	BKARZINS	Int.for days betw. redemption clear.and pmnt (FiMa-internal)	decimal	13	2
141	BTITALK	Imputed annuity repayment amount (FiMa internal)	decimal	13	2
142	HDN_KUNNR	Main Borrower Customer Number	nvarchar	10	0	Allow NULL?
143	SZART	Payment transaction	char	1	0	Allow NULL?
144	RUZBEL	Accounting Document Number	nvarchar	10	0	Allow NULL?
145	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	Allow NULL?
146	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
147	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	Allow NULL?
148	S_SSDREF	Reference flow category in borrower's note loan flow records	nvarchar	4	0	Allow NULL?
149	SAEND	Change Indicator for FiMa Flow Records	char	1	0	Allow NULL?
150	XPORE	Indicator: Individual Payment?	char	1	0	Allow NULL?
151	SPAYRQ	Generate payment request	char	1	0	Allow NULL?
152	PRKEY	Key Number for Payment Request	nvarchar	10	0	Allow NULL?
153	HKTID	ID for account details	nvarchar	5	0	Allow NULL?
154	VORGTYP	Activity Category (Posting Area)	nvarchar	4	0	Allow NULL?
155	ACENV	Source in TR-LO posting area	nvarchar	4	0	Allow NULL?
156	SSIGN	Direction of flow	char	1	0	Allow NULL?
157	SPRSNG	Individual payment	char	1	0	Allow NULL?
158	UZAWE	Payment Method Supplement	nvarchar	2	0	Allow NULL?
159	SPRGRD	Determine grouping definition	char	1	0	Allow NULL?
160	SCSPAY	Same direction necessary for joint payment?	char	1	0	Allow NULL?
161	ZWELS	List of the Payment Methods to be Considered	nvarchar	10	0	Allow NULL?
162	PAYGR	Grouping Field for Automatic Payments	nvarchar	20	0	Allow NULL?
163	JEXPOZINS	Exponential Interest Calculation	char	1	0	Allow NULL?
164	SREVALEXCL	Price gains w/o proportionate gains from deferral write-back	char	1	0	Allow NULL?
165	RBO	Business Operation Number (Loans)	nvarchar	15	0	Allow NULL?
166	SROUND	Rounding Category	char	1	0	Allow NULL?
167	SKALIDWT	Interest Calendar	nvarchar	2	0	Allow NULL?
168	PPAYMENT	Payment Rate	decimal	11	7
169	AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.	nvarchar	2	0	Allow NULL?
170	LC_CAPITALS	Effect of the Flow on Capital Amounts Status	nvarchar	2	0	Allow NULL?
171	LC_DISBURSE	Effect of the Flow on the Disbursement Status	nvarchar	2	0	Allow NULL?
172	OP_APPLICATION	Open Item Tool: Application Key	nvarchar	2	0	Allow NULL?
173	OP_RBO	OI Tool: Locking Business Operation	nvarchar	15	0	Allow NULL?
174	DFAELL_OLD_EXT	Old Due Date	nvarchar	8	0	Allow NULL?
175	DDISPO_OLD_EXT	Old Payment Date	nvarchar	8	0	Allow NULL?
176	RBO_EXT	Business Operation Number (Loans)	nvarchar	15	0	Allow NULL?
177	SBEWEGRP2	Flow Record Group in Cash Flow Calculator (Incoming Payment)	nvarchar	6	0	Allow NULL?
178	SUSP_REASON_TYPE	Key for Overpayment Reason	nvarchar	3	0	Allow NULL?
179	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	Allow NULL?
180	REMIT_INFO	Payment Notes Info	nvarchar	140	0	Allow NULL?
181	BROUNDUNIT	Rounding Unit for Amounts	decimal	13	7
182	SEPA_PD	Posting Date in the Document	nvarchar	8	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VDBEPP~0	Yes	Yes	CLUSTERED	MANDT, BUKRS, RANL, DTRANS, TTRANS, NTRANS
VDBEPP~1	No	No	NONCLUSTERED	MANDT, BUKRS, DDISPO

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

182 COLUMNS | 2 INDEXES | ERP 6.0 | VDBEPP TABLE

TOP ERP 6.0 | VDBEPP COLUMNS

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

182 COLUMNS | 2 INDEXES | ERP 6.0 | VDBEPP TABLE

TOPERP 6.0 | VDBEPP COLUMNS

TOPERP 6.0 | VDBEPP INDEXES

TOP ERP 6.0 | VDBEPP COLUMNS

TOP ERP 6.0 | VDBEPP INDEXES