	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

173 COLUMNS | 4 INDEXES | ERP 6.0 | VWBEPP TABLE

	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

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, BUKRS, RANL, RLDEPO, DTRANS, TTRANS, NTRANS, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, SSTATI, INTEB, SBEWART, SBEWZITI, SSOLHAB, DVORGANG, SVORGANG, NVORGANG, SNWHR, SBWHR, SCWHR, ASTUECK, BWKURS, BNWHR, PWKURS, BBWHR, BCWHR, BHWHR, KURS1, KURS2, DORDER, DVALUT, DDISPO, DBESTAND, DBEST6B, SSPESEN, SLIMIT, BLIMIT, PLIMIT, NORDER, RSOLL, RZKSOLL, RZKHABE, RHABEN, SBSLSOLL, SBSLZKSO, SBSLZKHA, SBSLHABEN, SWHRT, RBANKK, RKONTRA, SROLEXTKO, SFDLEV, JFDUPD, JONLAEN, JZINSBAS, JZINSZPT, PKOND, SSTCKKZ, SSTCKTG, PEFFZINS, SEFFMETH, SCRWHR1, SCRWHR2, KCROSS, NORDEXT, SWOHER, XZUSATZ, JONLBUC, DANST, TANST, SANST, SABRECH, SVERFALL, RDEALER, KOSTL, GSBER, BBASIS, DBERVON, DBERBIS, ATAGE, ABASTAGE, SZBMETH, SKALIDWT, JEXPOZINS, SOBJEKT, RZBANK, SROLEXTZB, JVERK6B, SZEGEN, SBUST, SCOUPON, DCOUPON, SFLAT, DFAELL, RHANDPL, SKOART, SEXCLVON, SULTVON, SINCLBIS, SULTBIS, DVERRECH, DPKOND, SREFZITI, SFIXRATE2, SFIXRATE1, SINCL, SVULT, RREFKONT, APERTAGE, STGMETH, STGBASIS, DBPERIOD, SPAEXCL, SPAULT, DEPERIOD, SPEINCL, SPEULT, SINCLVERR, SULTVERR, DGUEL_KP, NSTUFE, RPNNR, SBERFIMA, SVORGKZ, SREFBEW, SSWHR, BSWHR, SRUNIT, KWKURS, DSCHLUSS, TSCHLUSS, SHERKUNFT, SFGKZ, SBUCHA, RAHABKI, RAHKTID, RPBANK, ZLSCH, SZART, PEFFZCALL, OBJNR, REFRLDEPO, KGV_FLAG, DZFEST, KUNNR, KMNR, ERNR, DEVALPOST, ZUOND, REFER, MERKM, SPAYRQ, SPRSNG, RPZAHL, RFHA, INDEX_VALUE, PPAYMENT, BBWHR_IDX_CLEAN, BUSTRANSID, BUSTRANSCAT, DBUDAT, DGJAHR, RBELNRFI, RBELNRFI2, LOT_ID, MIGR_CFM10, MIGR_ERP20 FROM VWBEPP

TOP ERP 6.0 | VWBEPP COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
3	RANL	Security ID Number	nvarchar	13	0	CHAR	(N' ')	No	VWPANLA	VVRANLW	Allow NULL?
4	RLDEPO	Securities Account	nvarchar	10	0	CHAR	(N' ')	No	TWD01	VRLDEPO	Allow NULL?
5	DTRANS	Flow data key: System date	nvarchar	8	0	DATS	(N'00000000')	No		VVDTRANS	Allow NULL?
6	TTRANS	Transaction data key: system time	nvarchar	6	0	TIMS	(N'000000')	No		VVTTRANS	Allow NULL?
7	NTRANS	Transaction data key: Consecutive number	nvarchar	4	0	NUMC	(N'0000')	No		VVNTRANS	Allow NULL?
8	RERF	Entered by	nvarchar	12	0	CHAR	(N' ')	Yes		RERF	Allow NULL?
9	DERF	First Entered on	nvarchar	8	0	DATS	(N'00000000')	Yes		DERF	Allow NULL?
10	TERF	Time of Initial Entry	nvarchar	6	0	TIMS	(N'000000')	Yes		TERF	Allow NULL?
11	REHER	Source of initial entry	nvarchar	10	0	CHAR	(N' ')	Yes		REHER	Allow NULL?
12	RBEAR	Employee ID	nvarchar	12	0	CHAR	(N' ')	Yes		RBEAR	Allow NULL?
13	DBEAR	Last Edited on	nvarchar	8	0	DATS	(N'00000000')	Yes		DBEAR	Allow NULL?
14	TBEAR	Last Edited at	nvarchar	6	0	TIMS	(N'000000')	Yes		TBEAR	Allow NULL?
15	RBHER	Editing Source	nvarchar	10	0	CHAR	(N' ')	Yes		RBHER	Allow NULL?
16	SSTATI	Status of data record	nvarchar	2	0	NUMC	(N'00')	Yes	*	SSTATI	Allow NULL?
17	INTEB	Financial Assets Management internal level	nvarchar	2	0	NUMC	(N'00')	Yes	*	VVSINTEB	Allow NULL?
18	SBEWART	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	TZB0A	SBEWART	Allow NULL?
19	SBEWZITI	Flow category	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBEWZITI	Allow NULL?
20	SSOLHAB	Debit/credit indicator	char	1	0	CHAR	(N' ')	Yes		VVSSOLHAB	Allow NULL?
21	DVORGANG	Activity date	nvarchar	8	0	DATS	(N'00000000')	Yes		DVORGANG	Allow NULL?
22	SVORGANG	Securities-Activity	nvarchar	8	0	CHAR	(N' ')	Yes		RVORGANG	Allow NULL?
23	NVORGANG	Activity number	nvarchar	3	0	CHAR	(N' ')	Yes		NVORGANG	Allow NULL?
24	SNWHR	Currency of nominal amount	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	SNWHR	Allow NULL?
25	SBWHR	Position Currency (Currency of Position Amount)	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	SBWHR	Allow NULL?
26	SCWHR	Settlement Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	SCWHR	Allow NULL?
27	ASTUECK	Number of units for unit-quoted securities	decimal	15	5	DEC	((0))	Yes		ASTUECK
28	BWKURS	Security price for unit quotation	decimal	13	2	CURR	((0))	Yes		BWKURS
29	BNWHR	Nominal amount	decimal	13	2	CURR	((0))	Yes		BNWHR
30	PWKURS	Security price for percentage quotation	decimal	10	7	DEC	((0))	Yes		PWKURS
31	BBWHR	Amount in position currency	decimal	13	2	CURR	((0))	Yes		BBWHR
32	BCWHR	Settlement Amount	decimal	13	2	CURR	((0))	Yes		BCWHR
33	BHWHR	Amount in local currency	decimal	13	2	CURR	((0))	Yes		BHWHR
34	KURS1	Exchange rate into settlement currency	decimal	9	5	DEC	((0))	Yes		VVKURS1
35	KURS2	Exchange rate from settlement currency into local currency	decimal	9	5	DEC	((0))	Yes		VVKURS2
36	DORDER	Order day	nvarchar	8	0	DATS	(N'00000000')	Yes		DORDER	Allow NULL?
37	DVALUT	Interest Value Date/Calculation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDZINVAL	Allow NULL?
38	DDISPO	Value date / planning day	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDWERTST	Allow NULL?
39	DBESTAND	Position value date	nvarchar	8	0	DATS	(N'00000000')	Yes		DBESTAND	Allow NULL?
40	DBEST6B	Date for §6b EstG relevant postings	nvarchar	8	0	DATS	(N'00000000')	Yes		DBEST6B	Allow NULL?
41	SSPESEN	Expenses key	char	1	0	CHAR	(N' ')	Yes		SSPESEN	Allow NULL?
42	SLIMIT	Order notation	char	1	0	CHAR	(N' ')	Yes		SLIMIT	Allow NULL?
43	BLIMIT	Limit price for unit quotation	decimal	13	2	CURR	((0))	Yes		BLIMIT
44	PLIMIT	Limit price for percentage quotation	decimal	10	7	DEC	((0))	Yes		PLIMIT
45	NORDER	Position number	nvarchar	8	0	NUMC	(N'00000000')	Yes		SECPOSITIONNUMBER	Allow NULL?
46	RSOLL	Account for debit posting	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	RSOLL	Allow NULL?
47	RZKSOLL	Debit interim account	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	RZKSOLL	Allow NULL?
48	RZKHABE	Credit interim account	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	RZKHABE	Allow NULL?
49	RHABEN	Account for credit posting	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	RHABEN	Allow NULL?
50	SBSLSOLL	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
51	SBSLZKSO	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
52	SBSLZKHA	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
53	SBSLHABEN	Posting Key	nvarchar	2	0	CHAR	(N' ')	Yes	TBSL	BSCHL	Allow NULL?
54	SWHRT	Currency swap indicator	char	1	0	CHAR	(N' ')	Yes		SWHRT	Allow NULL?
55	RBANKK	Bank account	nvarchar	10	0	CHAR	(N' ')	Yes	SKB1	RBANKK	Allow NULL?
56	RKONTRA	Reference to Counterparty	nvarchar	10	0	CHAR	(N' ')	Yes	*	RKONTRA_NEW	Allow NULL?
57	SROLEXTKO	Dummy function	nvarchar	3	0	CHAR	(N' ')	Yes		DUMMY_3	Allow NULL?
58	SFDLEV	Planning level	nvarchar	2	0	CHAR	(N' ')	Yes	T036	FDLEV	Allow NULL?
59	JFDUPD	Record transferred to cash management and forecast	char	1	0	CHAR	(N' ')	Yes		JFDUPD	Allow NULL?
60	JONLAEN	Indicator for fixing a flow record	char	1	0	CHAR	(N' ')	Yes		JONLAEN	Allow NULL?
61	JZINSBAS	Flow in interest base	char	1	0	CHAR	(N' ')	Yes		JZINSBAS	Allow NULL?
62	JZINSZPT	Interest date	char	1	0	CHAR	(N' ')	Yes		JZINSZPT	Allow NULL?
63	PKOND	Percentage rate for condition items	decimal	10	7	DEC	((0))	Yes		PKOND
64	SSTCKKZ	Accrued interest method	char	1	0	CHAR	(N' ')	Yes		SSTCKKZ	Allow NULL?
65	SSTCKTG	Accrued interest: Daily method	char	1	0	CHAR	(N' ')	Yes		SSTCKTG	Allow NULL?
66	PEFFZINS	Effective Interest Rate	decimal	10	7	DEC	((0))	Yes		PEFFZINS
67	SEFFMETH	Effective Interest Method (Financial Mathematics)	char	1	0	NUMC	(N'0')	Yes		SEFFMETH	Allow NULL?
68	SCRWHR1	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
69	SCRWHR2	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
70	KCROSS	Exchange rate	decimal	9	5	DEC	((0))	Yes		KURSF
71	NORDEXT	External order number	nvarchar	20	0	CHAR	(N' ')	Yes		NORDEXT	Allow NULL?
72	SWOHER	Treasury: Source of flow	char	1	0	CHAR	(N' ')	Yes		TB_SWOHER	Allow NULL?
73	XZUSATZ	Assignment	nvarchar	18	0	CHAR	(N' ')	Yes		XZUSATZ	Allow NULL?
74	JONLBUC	Online posting flag indicator	char	1	0	CHAR	(N' ')	Yes		JONLBUC	Allow NULL?
75	DANST	Reservation date	nvarchar	8	0	DATS	(N'00000000')	Yes		DANST	Allow NULL?
76	TANST	Order time of day	nvarchar	6	0	TIMS	(N'000000')	Yes		TANST	Allow NULL?
77	SANST	Reservation reason	nvarchar	2	0	CHAR	(N' ')	Yes	TW14	SANST	Allow NULL?
78	SABRECH	Single-Character Indicator	char	1	0	CHAR	(N' ')	Yes		CHAR1	Allow NULL?
79	SVERFALL	Single-Character Indicator	char	1	0	CHAR	(N' ')	Yes		CHAR1	Allow NULL?
80	RDEALER	Trader	nvarchar	12	0	CHAR	(N' ')	Yes	TZDEA	RDEALER	Allow NULL?
81	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	KOSTL	Allow NULL?
82	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
83	BBASIS	Calculation base amount	decimal	13	2	CURR	((0))	Yes		BBASIS
84	DBERVON	Start of Calculation Period	nvarchar	8	0	DATS	(N'00000000')	Yes		DBERVON	Allow NULL?
85	DBERBIS	End of Calculation Period	nvarchar	8	0	DATS	(N'00000000')	Yes		DBERBIS	Allow NULL?
86	ATAGE	Number of days	nvarchar	6	0	NUMC	(N'000000')	Yes		VVATAGE	Allow NULL?
87	ABASTAGE	Number of base days in a calculation period	nvarchar	6	0	NUMC	(N'000000')	Yes		ABASTAGE	Allow NULL?
88	SZBMETH	Interest Calculation Method	char	1	0	CHAR	(N' ')	Yes		SZBMETH	Allow NULL?
89	SKALIDWT	Interest Calendar	nvarchar	2	0	CHAR	(N' ')	Yes	*	TFMSKALIDWT	Allow NULL?
90	JEXPOZINS	Exponential Interest Calculation	char	1	0	CHAR	(N' ')	Yes		TB_JZINSRE	Allow NULL?
91	SOBJEKT	Internal key for object	nvarchar	10	0	CHAR	(N' ')	Yes		VVKEYOBJ	Allow NULL?
92	RZBANK	Paying Bank	nvarchar	10	0	CHAR	(N' ')	Yes	BUT000	VVRZBANK_NEW	Allow NULL?
93	SROLEXTZB	Dummy function	nvarchar	3	0	CHAR	(N' ')	Yes		DUMMY_3	Allow NULL?
94	JVERK6B	Sale in acc. with tax credit method	char	1	0	CHAR	(N' ')	Yes		VVJVERK6B	Allow NULL?
95	SZEGEN	Generate incoming payment immediately	nvarchar	2	0	NUMC	(N'00')	Yes	*	SZEGEN	Allow NULL?
96	SBUST	Posting control key	nvarchar	2	0	NUMC	(N'00')	Yes	TZB09	VVSBUST	Allow NULL?
97	SCOUPON	Coupon ID for interest and accrued interest calculation	char	1	0	CHAR	(N' ')	Yes		VVSCOUPON	Allow NULL?
98	DCOUPON	Coupon date of next delivered coupon	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDCOUPON	Allow NULL?
99	SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation	char	1	0	CHAR	(N' ')	Yes		VVSFLAT	Allow NULL?
100	DFAELL	Due date	nvarchar	8	0	DATS	(N'00000000')	Yes		DFAELL	Allow NULL?
101	RHANDPL	Exchange	nvarchar	10	0	CHAR	(N' ')	Yes	TWH01	VVRHANDPL	Allow NULL?
102	SKOART	Condition Type (Smallest Subdivision of Condition Records)	nvarchar	4	0	NUMC	(N'0000')	Yes	TZK01	SKOART	Allow NULL?
103	SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	char	1	0	NUMC	(N'0')	Yes		VVSEXCLVON	Allow NULL?
104	SULTVON	Month-End Indicator for Start of a Calculation Period	char	1	0	CHAR	(N' ')	Yes		VVSULTVON	Allow NULL?
105	SINCLBIS	Inclusive Indicator for the End of a Calculation Period	char	1	0	NUMC	(N'0')	Yes		VVSINCLBIS	Allow NULL?
106	SULTBIS	Month-End Indicator for the End of a Calculation Period	char	1	0	CHAR	(N' ')	Yes		VVSULTBIS	Allow NULL?
107	DVERRECH	Settlement date	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDVERRECH	Allow NULL?
108	DPKOND	Determination date for percentage rate of condition items	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDPKOND	Allow NULL?
109	SREFZITI	Refer.flow category in accrual/deferral flow records	nvarchar	4	0	CHAR	(N' ')	Yes	*	VVSREFZITI	Allow NULL?
110	SFIXRATE2	Fixed exchange rate	char	1	0	CHAR	(N' ')	Yes		VVSFIXRATE	Allow NULL?
111	SFIXRATE1	Fixed exchange rate	char	1	0	CHAR	(N' ')	Yes		VVSFIXRATE	Allow NULL?
112	SINCL	Inclusive indicator for beginning and end of a period	char	1	0	NUMC	(N'0')	Yes		VVSINCL	Allow NULL?
113	SVULT	Month-End Indicator for Value Date	char	1	0	CHAR	(N' ')	Yes		VVSVULT	Allow NULL?
114	RREFKONT	Account Assignment Reference in Financial Assets Management	nvarchar	8	0	CHAR	(N' ')	Yes	T037S	RREFKONT	Allow NULL?
115	APERTAGE	No. of days of a (calculation) period in cash flow	nvarchar	6	0	NUMC	(N'000000')	Yes		VVAPERTAGE	Allow NULL?
116	STGMETH	Daily Method	char	1	0	NUMC	(N'0')	Yes		VVSTGMETH	Allow NULL?
117	STGBASIS	Base Days Method	char	1	0	CHAR	(N' ')	Yes		VVSTGBASIS	Allow NULL?
118	DBPERIOD	Period start	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDBPERIOD	Allow NULL?
119	SPAEXCL	Exclusive Indicator for Start Date of a Period	char	1	0	NUMC	(N'0')	Yes		TFMSPAEXCL	Allow NULL?
120	SPAULT	Month-End Indicator for Start Date of a Period	char	1	0	CHAR	(N' ')	Yes		TFMSPAULT	Allow NULL?
121	DEPERIOD	Period End	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDEPERIOD	Allow NULL?
122	SPEINCL	Inclusive Indicator for End Date of a Period	char	1	0	NUMC	(N'0')	Yes		TFMSPEINCL	Allow NULL?
123	SPEULT	Month-End Indicator for End of a Period	char	1	0	CHAR	(N' ')	Yes		TFMSPEULT	Allow NULL?
124	SINCLVERR	Inclusive Indicator for Clearing Date	char	1	0	NUMC	(N'0')	Yes		VVSINCLVER	Allow NULL?
125	SULTVERR	Month-End Indicator for Clearing Date	char	1	0	CHAR	(N' ')	Yes		VVSULTVERR	Allow NULL?
126	DGUEL_KP	Condition Item Valid From	nvarchar	8	0	DATS	(N'00000000')	Yes		DGUEL_KP	Allow NULL?
127	NSTUFE	Level number of condition item for recurring payments	nvarchar	2	0	NUMC	(N'00')	Yes		NSTUFE	Allow NULL?
128	RPNNR	Daybook no.	nvarchar	10	0	CHAR	(N' ')	Yes		VVRPNNR	Allow NULL?
129	SBERFIMA	Calculation category for cash flow calculator	nvarchar	4	0	CHAR	(N' ')	Yes	*	SBEWFIMA	Allow NULL?
130	SVORGKZ	Activity indicator for debit/credit control	nvarchar	2	0	NUMC	(N'00')	Yes		VVSVORGKZ	Allow NULL?
131	SREFBEW	Reference flow type	nvarchar	4	0	CHAR	(N' ')	Yes	*	SREFBEW	Allow NULL?
132	SSWHR	Stock price currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	VVSSWHR	Allow NULL?
133	BSWHR	Market value	decimal	13	2	CURR	((0))	Yes		VVBSWHR
134	SRUNIT	Currency unit	nvarchar	5	0	CHAR	(N' ')	Yes	TZUNI	VVSRUNIT	Allow NULL?
135	KWKURS	Security price	decimal	15	6	DEC	((0))	Yes		VVKWKURS
136	DSCHLUSS	Date of business closing	nvarchar	8	0	DATS	(N'00000000')	Yes		VVDSCHLUSS	Allow NULL?
137	TSCHLUSS	Time of business closing	nvarchar	6	0	TIMS	(N'000000')	Yes		VVTSCHLUSS	Allow NULL?
138	SHERKUNFT	Origin indicator: 'From planned record/actual record'	char	1	0	CHAR	(N' ')	Yes		VVSHERK	Allow NULL?
139	SFGKZ	Release Indicator	char	1	0	CHAR	(N' ')	Yes		VVSFGKZ	Allow NULL?
140	SBUCHA	Indicator for postings to accruals/deferrals accounts	char	1	0	CHAR	(N' ')	Yes		VVSBUCHA	Allow NULL?
141	RAHABKI	Short key for own house bank	nvarchar	5	0	CHAR	(N' ')	Yes	T012	TB_RHABKI	Allow NULL?
142	RAHKTID	Short key for house bank account	nvarchar	5	0	CHAR	(N' ')	Yes	T012K	TB_RHKTID	Allow NULL?
143	RPBANK	Partner bank details	nvarchar	4	0	CHAR	(N' ')	Yes		TB_RPBANK	Allow NULL?
144	ZLSCH	Payment Method	char	1	0	CHAR	(N' ')	Yes	T042Z	DZLSCH	Allow NULL?
145	SZART	Payment transaction	char	1	0	CHAR	(N' ')	Yes		TB_SZART	Allow NULL?
146	PEFFZCALL	Effective Interest Rate	decimal	10	7	DEC	((0))	Yes		PEFFZINS
147	OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	J_OBJNR	Allow NULL?
148	REFRLDEPO	Reference sec.acct for sec.acct transfer (inflow/outflow)	nvarchar	10	0	CHAR	(N' ')	Yes	*	VVREFRLDEP	Allow NULL?
149	KGV_FLAG	Manages status of the related price gains/losses flows	char	1	0	CHAR	(N' ')	Yes		TKGV	Allow NULL?
150	DZFEST	Interest rate fixing date	nvarchar	8	0	DATS	(N'00000000')	Yes		TB_DZFEST	Allow NULL?
151	KUNNR	Customer Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	KUNNR	Allow NULL?
152	KMNR	Corporate Action Number	nvarchar	13	0	CHAR	(N' ')	Yes	*	KMNR	Allow NULL?
153	ERNR	ID number of exercised right	nvarchar	13	0	CHAR	(N' ')	Yes		TER_HEADNUMBER	Allow NULL?
154	DEVALPOST	Date of period-end closing	nvarchar	8	0	DATS	(N'00000000')	Yes		DEVALPOST	Allow NULL?
155	ZUOND	Assignment	nvarchar	18	0	CHAR	(N' ')	Yes		TB_ZUOND	Allow NULL?
156	REFER	Internal Reference	nvarchar	16	0	CHAR	(N' ')	Yes		TB_REFER	Allow NULL?
157	MERKM	Characteristics	nvarchar	25	0	CHAR	(N' ')	Yes		TB_MERKM	Allow NULL?
158	SPAYRQ	Generate payment request	char	1	0	CHAR	(N' ')	Yes		TB_SPAYRQK	Allow NULL?
159	SPRSNG	Individual payment	char	1	0	CHAR	(N' ')	Yes		TB_SPRSNGK	Allow NULL?
160	RPZAHL	Payer/payee	nvarchar	10	0	CHAR	(N' ')	Yes	*	TB_RPZAHL_NEW	Allow NULL?
161	RFHA	Financial Transaction	nvarchar	13	0	CHAR	(N' ')	Yes	*	TB_RFHA	Allow NULL?
162	INDEX_VALUE	Index Value (Independent of Basis)	decimal	18	12	DEC	((0))	Yes		TIDX_INDEX_VALUE_NO_RATIO
163	PPAYMENT	Payment Rate	decimal	11	7	DEC	((0))	Yes		TFM_PPAYMENT
164	BBWHR_IDX_CLEAN	Amount in position currency	decimal	13	2	CURR	((0))	Yes		BBWHR
165	BUSTRANSID	Identifier of the Distributor Business Transaction	varbinary	16	0	RAW		Yes		TPM_BUSTRANSID
166	BUSTRANSCAT	Business Transaction Category	nvarchar	4	0	NUMC	(N'0000')	Yes	TRDTS_BT_CAT	TPM_BUSTRANSCAT	Allow NULL?
167	DBUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
168	DGJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
169	RBELNRFI	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
170	RBELNRFI2	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
171	LOT_ID	Identifier of the Lot	varbinary	16	0	RAW		Yes		TPM_LOT_ID
172	MIGR_CFM10	Status of Flow Related to Migration to CFM 1.0	char	1	0	CHAR	(N' ')	Yes		TPM_MIGR_CFM10	Allow NULL?
173	MIGR_ERP20	Status of Flow Related to Migration to ERP2.0	char	1	0	CHAR	(N' ')	Yes		TPM_MIGR_ERP20	Allow NULL?

TOP ERP 6.0 | VWBEPP INDEXES

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