	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

182 COLUMNS | 2 INDEXES | ERP 6.0 | VDBOBEPP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Services :: Loans Management
1	ERP EHP7	6.0	VDBOBEPP	182	2	Business Operation: Entered and Activated Flow Data	Loans Management

SQL: selectupdate insert create

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

SELECT MANDT, BUKRS, RANL, DTRANS, TTRANS, NTRANS, RERF, DERF, TERF, REHER, RBEAR, DBEAR, TBEAR, RBHER, DVORGANG, SVORGANG, NVORGANG, SBEWART, SREFBEW, SBEWZITI, SPLANIST, SSOLHAB, SSTORNO, SSTOGRD, ZUONR, RSTBLG, SGTXT, SANLF, DGUEL_KK, NLFD_ANG, SSTATI, GSART, RREFKONT, GSBER, DORDER, NORDER, BNWHR, SNWHR, BBWHR, SBWHR, BCWHR, SCWHR, BHWHR, KURS1, KURS2, DVALUT, DFAELL, DDISPO, DBESTAND, DBERVON, DBERBIS, ATAGE, ABASTAGE, SZBMETH, UMSKZ, KOSTL, SSPESEN, RSOLL, RHABEN, RZKSOLL, RZKHABE, SBSLSOLL, SBSLZKSO, SBSLZKHA, SHSLHABEN, RBANKK, SFDLEV, JFDUPD, JONLAEN, JZINSBAS, JZINSZPT, PKOND, BBASIS, SSORTZIT, SWOHER, SSTCKKZ, SSTCKTG, PEFFZINS, SEFFMETH, JVERF, KUNNR, BVTYP, ZLSCH, MABER, ZAHLS, RPARTNR, SROLEXT, RKLAMMER, JEINBEHALT, SZEGEN, MWSKZ, DTRANSREF, TTRANSREF, NTRANSREF, RPNNR, HBKID, SBUST, PWKURS, DSTOCK, JVORAUS, AMMRHY, SKOART, SEXCLVON, SULTVON, SINCLBIS, SULTBIS, SINCL, DVERRECH, DPKOND, RUMBLG, ZINKZ, SVULT, JSOFVERR, SINCLVERR, SULTVERR, SREFZITI, STGBASIS, STGMETH, SBASIS, SBERFIMA, SVORGKZ, MANSP, DGUEL_KP, NSTUFE, DBPERIOD, SPAEXCL, SPAULT, DEPERIOD, SPEINCL, SPEULT, RKONT, DAUSZ, SSOLIST, RDARNEHM, BKOND, RZEBEL, ZFBDT, DZFEST, SBERECH, BKARZINS, BTITALK, HDN_KUNNR, SZART, RUZBEL, REBZJ, REBZG, REBZZ, S_SSDREF, SAEND, XPORE, SPAYRQ, PRKEY, HKTID, VORGTYP, ACENV, SSIGN, SPRSNG, UZAWE, SPRGRD, SCSPAY, ZWELS, PAYGR, JEXPOZINS, SREVALEXCL, RBO, SROUND, SKALIDWT, PPAYMENT, AMMRHYZV, LC_CAPITALS, LC_DISBURSE, OP_APPLICATION, OP_RBO, DFAELL_OLD_EXT, DDISPO_OLD_EXT, RBO_EXT, SBEWEGRP2, SUSP_REASON_TYPE, MNDID, REMIT_INFO, BROUNDUNIT, SEPA_PD FROM VDBOBEPP

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

TOP ERP 6.0 | VDBOBEPP INDEXES

Name	Primary	Unique	Type	Columns
VDBOBEPP~0	Yes	Yes	CLUSTERED	MANDT, BUKRS, RANL, DTRANS, TTRANS, NTRANS
VDBOBEPP~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 | VDBOBEPP TABLE

TOP ERP 6.0 | VDBOBEPP COLUMNS

TOP ERP 6.0 | VDBOBEPP 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 | VDBOBEPP TABLE

TOPERP 6.0 | VDBOBEPP COLUMNS

TOPERP 6.0 | VDBOBEPP INDEXES

TOP ERP 6.0 | VDBOBEPP COLUMNS

TOP ERP 6.0 | VDBOBEPP INDEXES