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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	VWBEPI	114	6	Treasury Securities: Actual Flows - Item	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	RBELNR	Number of flow header	nvarchar	10	0	Allow NULL?
4	RPOSNR	Activity number	nvarchar	3	0	Allow NULL?
5	RERF	Entered by	nvarchar	12	0	Allow NULL?
6	DERF	First Entered on	nvarchar	8	0	Allow NULL?
7	TERF	Time of Initial Entry	nvarchar	6	0	Allow NULL?
8	REHER	Source of initial entry	nvarchar	10	0	Allow NULL?
9	RBEAR	Employee ID	nvarchar	12	0	Allow NULL?
10	DBEAR	Last Edited on	nvarchar	8	0	Allow NULL?
11	TBEAR	Last Edited at	nvarchar	6	0	Allow NULL?
12	RBHER	Editing Source	nvarchar	10	0	Allow NULL?
13	SBEWART	Flow Type	nvarchar	4	0	Allow NULL?
14	SBEWZITI	Flow category	nvarchar	4	0	Allow NULL?
15	SSOLHAB	Debit/credit indicator	char	1	0	Allow NULL?
16	SNWHR	Currency of nominal amount	nvarchar	5	0	Allow NULL?
17	SBWHR	Position Currency (Currency of Position Amount)	nvarchar	5	0	Allow NULL?
18	SCWHR	Settlement Currency	nvarchar	5	0	Allow NULL?
19	ASTUECK	Number of units for unit-quoted securities	decimal	15	5
20	BWKURS	Security price for unit quotation	decimal	13	2
21	BNWHR	Nominal amount	decimal	13	2
22	PWKURS	Security price for percentage quotation	decimal	10	7
23	BBWHR	Amount in position currency	decimal	13	2
24	BCWHR	Settlement Amount	decimal	13	2
25	BHWHR	Amount in local currency	decimal	13	2
26	KURS1	Exchange rate	decimal	9	5
27	KURS2	Exchange rate	decimal	9	5
28	DVALUT	Interest Value Date/Calculation Date	nvarchar	8	0	Allow NULL?
29	DDISPO	Value date / planning day	nvarchar	8	0	Allow NULL?
30	DBESTAND	Position value date	nvarchar	8	0	Allow NULL?
31	DBEST6B	Date for §6b EstG relevant postings	nvarchar	8	0	Allow NULL?
32	RSOLL	Account for debit posting	nvarchar	10	0	Allow NULL?
33	SBSLSOLL	Posting Key	nvarchar	2	0	Allow NULL?
34	RZKSOLL	Debit interim account	nvarchar	10	0	Allow NULL?
35	SBSLZKSO	Posting Key	nvarchar	2	0	Allow NULL?
36	RZKHABE	Credit interim account	nvarchar	10	0	Allow NULL?
37	SBSLZKHA	Posting Key	nvarchar	2	0	Allow NULL?
38	RHABEN	Account for credit posting	nvarchar	10	0	Allow NULL?
39	SBSLHABEN	Posting Key	nvarchar	2	0	Allow NULL?
40	SWHRT	Currency swap indicator	char	1	0	Allow NULL?
41	JONLAEN	Indicator for fixing a flow record	char	1	0	Allow NULL?
42	JZINSBAS	Flow in interest base	char	1	0	Allow NULL?
43	JZINSZPT	Interest date	char	1	0	Allow NULL?
44	PKOND	Percentage rate for condition items	decimal	10	7
45	BBASIS	Calculation base amount	decimal	13	2
46	DBERVON	Start of Calculation Period	nvarchar	8	0	Allow NULL?
47	DBERBIS	End of Calculation Period	nvarchar	8	0	Allow NULL?
48	ATAGE	Number of days	nvarchar	6	0	Allow NULL?
49	ABASTAGE	Number of base days in a calculation period	nvarchar	6	0	Allow NULL?
50	SZBMETH	Interest Calculation Method	char	1	0	Allow NULL?
51	SKALIDWT	Interest Calendar	nvarchar	2	0	Allow NULL?
52	JEXPOZINS	Exponential Interest Calculation	char	1	0	Allow NULL?
53	SWOHER	Treasury: Source of flow	char	1	0	Allow NULL?
54	JSTOCK	Premium reserve fund-relevant indicator	char	1	0	Allow NULL?
55	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
56	DFAELL	Due date	nvarchar	8	0	Allow NULL?
57	SKOART	Condition Type (Smallest Subdivision of Condition Records)	nvarchar	4	0	Allow NULL?
58	SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	char	1	0	Allow NULL?
59	SULTVON	Month-End Indicator for Start of a Calculation Period	char	1	0	Allow NULL?
60	SINCLVON	Inclusive Indicator for the End of a Calculation Period	char	1	0	Allow NULL?
61	SULTBIS	Month-End Indicator for the End of a Calculation Period	char	1	0	Allow NULL?
62	DVERRECH	Settlement date	nvarchar	8	0	Allow NULL?
63	DPKOND	Determination date for percentage rate of condition items	nvarchar	8	0	Allow NULL?
64	SREFZITI	Refer.flow category in accrual/deferral flow records	nvarchar	4	0	Allow NULL?
65	SINCL	Inclusive indicator for beginning and end of a period	char	1	0	Allow NULL?
66	SVULT	Month-End Indicator for Value Date	char	1	0	Allow NULL?
67	APERTAGE	No. of days of a (calculation) period in cash flow	nvarchar	6	0	Allow NULL?
68	STGMETH	Daily Method	char	1	0	Allow NULL?
69	STGBASIS	Base Days Method	char	1	0	Allow NULL?
70	DBPERIOD	Period start	nvarchar	8	0	Allow NULL?
71	SPAEXCL	Exclusive Indicator for Start Date of a Period	char	1	0	Allow NULL?
72	SPAULT	Month-End Indicator for Start Date of a Period	char	1	0	Allow NULL?
73	DEPERIOD	Period End	nvarchar	8	0	Allow NULL?
74	SPEINCL	Inclusive Indicator for End Date of a Period	char	1	0	Allow NULL?
75	SPEULT	Month-End Indicator for End of a Period	char	1	0	Allow NULL?
76	SINCLVERR	Inclusive Indicator for Clearing Date	char	1	0	Allow NULL?
77	SULTVERR	Month-End Indicator for Clearing Date	char	1	0	Allow NULL?
78	DGUEL_KP	Condition Item Valid From	nvarchar	8	0	Allow NULL?
79	NSTUFE	Level number of condition item for recurring payments	nvarchar	2	0	Allow NULL?
80	DCOUPON	Coupon date of next delivered coupon	nvarchar	8	0	Allow NULL?
81	SCOUPON	Coupon ID for interest and accrued interest calculation	char	1	0	Allow NULL?
82	SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation	char	1	0	Allow NULL?
83	SBERFIMA	Calculation category for cash flow calculator	nvarchar	4	0	Allow NULL?
84	SVORGKZ	Activity indicator for debit/credit control	nvarchar	2	0	Allow NULL?
85	SREFBEW	Reference flow type	nvarchar	4	0	Allow NULL?
86	SINCLBIS	Inclusive Indicator for the End of a Calculation Period	char	1	0	Allow NULL?
87	SSWHR	Stock price currency	nvarchar	5	0	Allow NULL?
88	BSWHR	Market value	decimal	13	2
89	SRUNIT	Currency unit	nvarchar	5	0	Allow NULL?
90	KWKURS	Security price	decimal	15	6
91	DSCHLUSS	Date of business closing	nvarchar	8	0	Allow NULL?
92	TSCHLUSS	Time of business closing	nvarchar	6	0	Allow NULL?
93	SBUCHA	Indicator for postings to accruals/deferrals accounts	char	1	0	Allow NULL?
94	RAHABKI	Short key for own house bank	nvarchar	5	0	Allow NULL?
95	RAHKTID	Short key for house bank account	nvarchar	5	0	Allow NULL?
96	RPBANK	Partner bank details	nvarchar	4	0	Allow NULL?
97	ZLSCH	Payment Method	char	1	0	Allow NULL?
98	SZART	Payment transaction	char	1	0	Allow NULL?
99	KGV_FLAG	Manages status of the related price gains/losses flows	char	1	0	Allow NULL?
100	DZFEST	Interest rate fixing date	nvarchar	8	0	Allow NULL?
101	KMNR	Corporate Action Number	nvarchar	13	0	Allow NULL?
102	ERNR	ID number of exercised right	nvarchar	13	0	Allow NULL?
103	SPAYRQ	Generate payment request	char	1	0	Allow NULL?
104	SPRSNG	Individual payment	char	1	0	Allow NULL?
105	PRKEY	Key Number for Payment Request	nvarchar	10	0	Allow NULL?
106	RPZAHL	Payer/payee	nvarchar	10	0	Allow NULL?
107	INDEX_VALUE	Index Value (Independent of Basis)	decimal	18	12
108	PPAYMENT	Payment Rate	decimal	11	7
109	BBWHR_IDX_CLEAN	Amount in position currency	decimal	13	2
110	BUSTRANSID	Identifier of the Distributor Business Transaction	varbinary	16	0
111	BUSTRANSCAT	Business Transaction Category	nvarchar	4	0	Allow NULL?
112	LOT_ID	Identifier of the Lot	varbinary	16	0
113	MIGR_CFM10	Status of Flow Related to Migration to CFM 1.0	char	1	0	Allow NULL?
114	MIGR_ERP20	Status of Flow Related to Migration to ERP2.0	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VWBEPI~0	Yes	Yes	CLUSTERED	MANDT, BUKRS, RBELNR, RPOSNR
VWBEPI~100	No	No	NONCLUSTERED	MANDT, BUSTRANSID
VWBEPI~B	No	No	NONCLUSTERED	DVALUT
VWBEPI~C	No	No	NONCLUSTERED	SBEWART
VWBEPI~D	No	No	NONCLUSTERED	BUKRS, RBELNR, DVALUT, SBEWART
VWBEPI~MIG	No	No	NONCLUSTERED	BUKRS, MIGR_CFM10, SBEWZITI

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

114 COLUMNS | 6 INDEXES | ERP 6.0 | VWBEPI TABLE

TOP ERP 6.0 | VWBEPI COLUMNS

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

114 COLUMNS | 6 INDEXES | ERP 6.0 | VWBEPI TABLE

TOPERP 6.0 | VWBEPI COLUMNS

TOPERP 6.0 | VWBEPI INDEXES

TOP ERP 6.0 | VWBEPI COLUMNS

TOP ERP 6.0 | VWBEPI INDEXES