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

	Product	Version	Table	Columns	Indexes	Description	Module
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	VWBEPP	173	4	Treasury Securities: Planned Flows	Transaction Manager

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	Security ID Number	nvarchar	13	0	Allow NULL?
4	RLDEPO	Securities Account	nvarchar	10	0	Allow NULL?
5	DTRANS	Flow data key: System date	nvarchar	8	0	Allow NULL?
6	TTRANS	Transaction data key: system time	nvarchar	6	0	Allow NULL?
7	NTRANS	Transaction data key: Consecutive number	nvarchar	4	0	Allow NULL?
8	RERF	Entered by	nvarchar	12	0	Allow NULL?
9	DERF	First Entered on	nvarchar	8	0	Allow NULL?
10	TERF	Time of Initial Entry	nvarchar	6	0	Allow NULL?
11	REHER	Source of initial entry	nvarchar	10	0	Allow NULL?
12	RBEAR	Employee ID	nvarchar	12	0	Allow NULL?
13	DBEAR	Last Edited on	nvarchar	8	0	Allow NULL?
14	TBEAR	Last Edited at	nvarchar	6	0	Allow NULL?
15	RBHER	Editing Source	nvarchar	10	0	Allow NULL?
16	SSTATI	Status of data record	nvarchar	2	0	Allow NULL?
17	INTEB	Financial Assets Management internal level	nvarchar	2	0	Allow NULL?
18	SBEWART	Flow Type	nvarchar	4	0	Allow NULL?
19	SBEWZITI	Flow category	nvarchar	4	0	Allow NULL?
20	SSOLHAB	Debit/credit indicator	char	1	0	Allow NULL?
21	DVORGANG	Activity date	nvarchar	8	0	Allow NULL?
22	SVORGANG	Securities-Activity	nvarchar	8	0	Allow NULL?
23	NVORGANG	Activity number	nvarchar	3	0	Allow NULL?
24	SNWHR	Currency of nominal amount	nvarchar	5	0	Allow NULL?
25	SBWHR	Position Currency (Currency of Position Amount)	nvarchar	5	0	Allow NULL?
26	SCWHR	Settlement Currency	nvarchar	5	0	Allow NULL?
27	ASTUECK	Number of units for unit-quoted securities	decimal	15	5
28	BWKURS	Security price for unit quotation	decimal	13	2
29	BNWHR	Nominal amount	decimal	13	2
30	PWKURS	Security price for percentage quotation	decimal	10	7
31	BBWHR	Amount in position currency	decimal	13	2
32	BCWHR	Settlement Amount	decimal	13	2
33	BHWHR	Amount in local currency	decimal	13	2
34	KURS1	Exchange rate into settlement currency	decimal	9	5
35	KURS2	Exchange rate from settlement currency into local currency	decimal	9	5
36	DORDER	Order day	nvarchar	8	0	Allow NULL?
37	DVALUT	Interest Value Date/Calculation Date	nvarchar	8	0	Allow NULL?
38	DDISPO	Value date / planning day	nvarchar	8	0	Allow NULL?
39	DBESTAND	Position value date	nvarchar	8	0	Allow NULL?
40	DBEST6B	Date for §6b EstG relevant postings	nvarchar	8	0	Allow NULL?
41	SSPESEN	Expenses key	char	1	0	Allow NULL?
42	SLIMIT	Order notation	char	1	0	Allow NULL?
43	BLIMIT	Limit price for unit quotation	decimal	13	2
44	PLIMIT	Limit price for percentage quotation	decimal	10	7
45	NORDER	Position number	nvarchar	8	0	Allow NULL?
46	RSOLL	Account for debit posting	nvarchar	10	0	Allow NULL?
47	RZKSOLL	Debit interim account	nvarchar	10	0	Allow NULL?
48	RZKHABE	Credit interim account	nvarchar	10	0	Allow NULL?
49	RHABEN	Account for credit posting	nvarchar	10	0	Allow NULL?
50	SBSLSOLL	Posting Key	nvarchar	2	0	Allow NULL?
51	SBSLZKSO	Posting Key	nvarchar	2	0	Allow NULL?
52	SBSLZKHA	Posting Key	nvarchar	2	0	Allow NULL?
53	SBSLHABEN	Posting Key	nvarchar	2	0	Allow NULL?
54	SWHRT	Currency swap indicator	char	1	0	Allow NULL?
55	RBANKK	Bank account	nvarchar	10	0	Allow NULL?
56	RKONTRA	Reference to Counterparty	nvarchar	10	0	Allow NULL?
57	SROLEXTKO	Dummy function	nvarchar	3	0	Allow NULL?
58	SFDLEV	Planning level	nvarchar	2	0	Allow NULL?
59	JFDUPD	Record transferred to cash management and forecast	char	1	0	Allow NULL?
60	JONLAEN	Indicator for fixing a flow record	char	1	0	Allow NULL?
61	JZINSBAS	Flow in interest base	char	1	0	Allow NULL?
62	JZINSZPT	Interest date	char	1	0	Allow NULL?
63	PKOND	Percentage rate for condition items	decimal	10	7
64	SSTCKKZ	Accrued interest method	char	1	0	Allow NULL?
65	SSTCKTG	Accrued interest: Daily method	char	1	0	Allow NULL?
66	PEFFZINS	Effective Interest Rate	decimal	10	7
67	SEFFMETH	Effective Interest Method (Financial Mathematics)	char	1	0	Allow NULL?
68	SCRWHR1	Currency Key	nvarchar	5	0	Allow NULL?
69	SCRWHR2	Currency Key	nvarchar	5	0	Allow NULL?
70	KCROSS	Exchange rate	decimal	9	5
71	NORDEXT	External order number	nvarchar	20	0	Allow NULL?
72	SWOHER	Treasury: Source of flow	char	1	0	Allow NULL?
73	XZUSATZ	Assignment	nvarchar	18	0	Allow NULL?
74	JONLBUC	Online posting flag indicator	char	1	0	Allow NULL?
75	DANST	Reservation date	nvarchar	8	0	Allow NULL?
76	TANST	Order time of day	nvarchar	6	0	Allow NULL?
77	SANST	Reservation reason	nvarchar	2	0	Allow NULL?
78	SABRECH	Single-Character Indicator	char	1	0	Allow NULL?
79	SVERFALL	Single-Character Indicator	char	1	0	Allow NULL?
80	RDEALER	Trader	nvarchar	12	0	Allow NULL?
81	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
82	GSBER	Business Area	nvarchar	4	0	Allow NULL?
83	BBASIS	Calculation base amount	decimal	13	2
84	DBERVON	Start of Calculation Period	nvarchar	8	0	Allow NULL?
85	DBERBIS	End of Calculation Period	nvarchar	8	0	Allow NULL?
86	ATAGE	Number of days	nvarchar	6	0	Allow NULL?
87	ABASTAGE	Number of base days in a calculation period	nvarchar	6	0	Allow NULL?
88	SZBMETH	Interest Calculation Method	char	1	0	Allow NULL?
89	SKALIDWT	Interest Calendar	nvarchar	2	0	Allow NULL?
90	JEXPOZINS	Exponential Interest Calculation	char	1	0	Allow NULL?
91	SOBJEKT	Internal key for object	nvarchar	10	0	Allow NULL?
92	RZBANK	Paying Bank	nvarchar	10	0	Allow NULL?
93	SROLEXTZB	Dummy function	nvarchar	3	0	Allow NULL?
94	JVERK6B	Sale in acc. with tax credit method	char	1	0	Allow NULL?
95	SZEGEN	Generate incoming payment immediately	nvarchar	2	0	Allow NULL?
96	SBUST	Posting control key	nvarchar	2	0	Allow NULL?
97	SCOUPON	Coupon ID for interest and accrued interest calculation	char	1	0	Allow NULL?
98	DCOUPON	Coupon date of next delivered coupon	nvarchar	8	0	Allow NULL?
99	SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation	char	1	0	Allow NULL?
100	DFAELL	Due date	nvarchar	8	0	Allow NULL?
101	RHANDPL	Exchange	nvarchar	10	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	DVERRECH	Settlement date	nvarchar	8	0	Allow NULL?
108	DPKOND	Determination date for percentage rate of condition items	nvarchar	8	0	Allow NULL?
109	SREFZITI	Refer.flow category in accrual/deferral flow records	nvarchar	4	0	Allow NULL?
110	SFIXRATE2	Fixed exchange rate	char	1	0	Allow NULL?
111	SFIXRATE1	Fixed exchange rate	char	1	0	Allow NULL?
112	SINCL	Inclusive indicator for beginning and end of a period	char	1	0	Allow NULL?
113	SVULT	Month-End Indicator for Value Date	char	1	0	Allow NULL?
114	RREFKONT	Account Assignment Reference in Financial Assets Management	nvarchar	8	0	Allow NULL?
115	APERTAGE	No. of days of a (calculation) period in cash flow	nvarchar	6	0	Allow NULL?
116	STGMETH	Daily Method	char	1	0	Allow NULL?
117	STGBASIS	Base Days Method	char	1	0	Allow NULL?
118	DBPERIOD	Period start	nvarchar	8	0	Allow NULL?
119	SPAEXCL	Exclusive Indicator for Start Date of a Period	char	1	0	Allow NULL?
120	SPAULT	Month-End Indicator for Start Date of a Period	char	1	0	Allow NULL?
121	DEPERIOD	Period End	nvarchar	8	0	Allow NULL?
122	SPEINCL	Inclusive Indicator for End Date of a Period	char	1	0	Allow NULL?
123	SPEULT	Month-End Indicator for End of a Period	char	1	0	Allow NULL?
124	SINCLVERR	Inclusive Indicator for Clearing Date	char	1	0	Allow NULL?
125	SULTVERR	Month-End Indicator for Clearing Date	char	1	0	Allow NULL?
126	DGUEL_KP	Condition Item Valid From	nvarchar	8	0	Allow NULL?
127	NSTUFE	Level number of condition item for recurring payments	nvarchar	2	0	Allow NULL?
128	RPNNR	Daybook no.	nvarchar	10	0	Allow NULL?
129	SBERFIMA	Calculation category for cash flow calculator	nvarchar	4	0	Allow NULL?
130	SVORGKZ	Activity indicator for debit/credit control	nvarchar	2	0	Allow NULL?
131	SREFBEW	Reference flow type	nvarchar	4	0	Allow NULL?
132	SSWHR	Stock price currency	nvarchar	5	0	Allow NULL?
133	BSWHR	Market value	decimal	13	2
134	SRUNIT	Currency unit	nvarchar	5	0	Allow NULL?
135	KWKURS	Security price	decimal	15	6
136	DSCHLUSS	Date of business closing	nvarchar	8	0	Allow NULL?
137	TSCHLUSS	Time of business closing	nvarchar	6	0	Allow NULL?
138	SHERKUNFT	Origin indicator: 'From planned record/actual record'	char	1	0	Allow NULL?
139	SFGKZ	Release Indicator	char	1	0	Allow NULL?
140	SBUCHA	Indicator for postings to accruals/deferrals accounts	char	1	0	Allow NULL?
141	RAHABKI	Short key for own house bank	nvarchar	5	0	Allow NULL?
142	RAHKTID	Short key for house bank account	nvarchar	5	0	Allow NULL?
143	RPBANK	Partner bank details	nvarchar	4	0	Allow NULL?
144	ZLSCH	Payment Method	char	1	0	Allow NULL?
145	SZART	Payment transaction	char	1	0	Allow NULL?
146	PEFFZCALL	Effective Interest Rate	decimal	10	7
147	OBJNR	Object number	nvarchar	22	0	Allow NULL?
148	REFRLDEPO	Reference sec.acct for sec.acct transfer (inflow/outflow)	nvarchar	10	0	Allow NULL?
149	KGV_FLAG	Manages status of the related price gains/losses flows	char	1	0	Allow NULL?
150	DZFEST	Interest rate fixing date	nvarchar	8	0	Allow NULL?
151	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
152	KMNR	Corporate Action Number	nvarchar	13	0	Allow NULL?
153	ERNR	ID number of exercised right	nvarchar	13	0	Allow NULL?
154	DEVALPOST	Date of period-end closing	nvarchar	8	0	Allow NULL?
155	ZUOND	Assignment	nvarchar	18	0	Allow NULL?
156	REFER	Internal Reference	nvarchar	16	0	Allow NULL?
157	MERKM	Characteristics	nvarchar	25	0	Allow NULL?
158	SPAYRQ	Generate payment request	char	1	0	Allow NULL?
159	SPRSNG	Individual payment	char	1	0	Allow NULL?
160	RPZAHL	Payer/payee	nvarchar	10	0	Allow NULL?
161	RFHA	Financial Transaction	nvarchar	13	0	Allow NULL?
162	INDEX_VALUE	Index Value (Independent of Basis)	decimal	18	12
163	PPAYMENT	Payment Rate	decimal	11	7
164	BBWHR_IDX_CLEAN	Amount in position currency	decimal	13	2
165	BUSTRANSID	Identifier of the Distributor Business Transaction	varbinary	16	0
166	BUSTRANSCAT	Business Transaction Category	nvarchar	4	0	Allow NULL?
167	DBUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
168	DGJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
169	RBELNRFI	Accounting Document Number	nvarchar	10	0	Allow NULL?
170	RBELNRFI2	Accounting Document Number	nvarchar	10	0	Allow NULL?
171	LOT_ID	Identifier of the Lot	varbinary	16	0
172	MIGR_CFM10	Status of Flow Related to Migration to CFM 1.0	char	1	0	Allow NULL?
173	MIGR_ERP20	Status of Flow Related to Migration to ERP2.0	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VWBEPP~0	Yes	Yes	CLUSTERED	MANDT, BUKRS, RANL, RLDEPO, DTRANS, TTRANS, NTRANS
VWBEPP~B	No	No	NONCLUSTERED	DVALUT
VWBEPP~C	No	No	NONCLUSTERED	SBEWART
VWBEPP~O	No	No	NONCLUSTERED	MANDT, BUKRS, NORDER

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

173 COLUMNS | 4 INDEXES | ERP 6.0 | VWBEPP TABLE

TOP ERP 6.0 | VWBEPP COLUMNS

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

173 COLUMNS | 4 INDEXES | ERP 6.0 | VWBEPP TABLE

TOPERP 6.0 | VWBEPP COLUMNS

TOPERP 6.0 | VWBEPP INDEXES

TOP ERP 6.0 | VWBEPP COLUMNS

TOP ERP 6.0 | VWBEPP INDEXES