	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

185 COLUMNS | 1 INDEXES | ERP 6.0 | VZFZE_VDBEPP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Services :: Loans Management
1	ERP EHP7	6.0	VZFZE_VDBEPP	185	1	Central Entry Table for Release Procedure	Loans Management

SQL: selectupdate insert create

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

SELECT MANDT, VZFZE_BUKRS, VZFZE_SVORGANG, VZFZE_LFDNR, 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 VZFZE_VDBEPP

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

TOP ERP 6.0 | VZFZE_VDBEPP INDEXES

Name	Primary	Unique	Type	Columns
VZFZE_VDBEPP~0	Yes	Yes	CLUSTERED	MANDT, VZFZE_BUKRS, VZFZE_SVORGANG, VZFZE_LFDNR

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

185 COLUMNS | 1 INDEXES | ERP 6.0 | VZFZE_VDBEPP TABLE

TOP ERP 6.0 | VZFZE_VDBEPP COLUMNS

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

185 COLUMNS | 1 INDEXES | ERP 6.0 | VZFZE_VDBEPP TABLE

TOPERP 6.0 | VZFZE_VDBEPP COLUMNS

TOPERP 6.0 | VZFZE_VDBEPP INDEXES

TOP ERP 6.0 | VZFZE_VDBEPP COLUMNS

TOP ERP 6.0 | VZFZE_VDBEPP INDEXES