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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

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

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

162 COLUMNS | 1 INDEXES | ERP 6.0 | VDBEPI TABLE

TOP ERP 6.0 | VDBEPI COLUMNS

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

162 COLUMNS | 1 INDEXES | ERP 6.0 | VDBEPI TABLE

TOPERP 6.0 | VDBEPI COLUMNS

TOPERP 6.0 | VDBEPI INDEXES

TOP ERP 6.0 | VDBEPI COLUMNS

TOP ERP 6.0 | VDBEPI INDEXES