SAP ABAP Table VDBEVI (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VDBEVI	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RBELKPFD	☑	RBELKPFD	RBELKPFD	CHAR	10	0	Document Number of Document Header (Loan)
4	RPOSNR	☑	NVORGANG	CHAR3	CHAR	3	0	Activity number
5	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category
6	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
7	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
8	SSTCKTG	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
9	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
10	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
11	UANFIBU	☐	UANFIBU	TIMES	TIMS	6	0	Time of transfer to financial accounting
12	DANFIBU	☐	DANFIBU	DATUM	DATS	8	0	Date of transferal to FiAc
13	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
14	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
15	NLFD_ANG	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
16	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
17	DVORGANG	☐	DVORGANG	DATUM	DATS	8	0	Activity date
18	SVORGANG	☐	SVORFALL	SVORFALL	CHAR	4	0	Business Operation (Activity)
19	NVORGANG	☐	NVORGANG	CHAR3	CHAR	3	0	Activity number
20	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record
21	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management
22	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKB1
23	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
24	SBLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
25	DBLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
26	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
27	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
28	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
29	SSTORNO	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
30	SSTOGRD	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
31	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
32	RSTBLG	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
33	RZEBEL	☐	RZEBEL	RBELKPFD	CHAR	10	0	Doc.no. of debit pos. doc.header (only for inc.pmnt records)
34	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
35	DANJRNL	☐	DANJRNL	DATUM	DATS	8	0	Date of transferal to journal
36	MWART	☐	MWART	MWART	CHAR	1	0	Tax Type
37	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type
38	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category
39	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
40	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount
41	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
42	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)
43	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
44	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency
45	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
46	PKKURS	☐	PKKURS	PWKURS	DEC	10	7	Purchase Price of Borrower's Note
47	PRUCK	☐	PRUCK	DEC3_7	DEC	10	7	Repayment rate in percent
48	KURS1	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
49	KURS2	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
50	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
51	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
52	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
53	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
54	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
55	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator
56	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
57	SSPESEN	☐	SSPESEN	SSPESEN	CHAR	1	0	Expenses key
58	VVSSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
59	RSOLL	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	SKA1
60	RHABEN	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	SKA1
61	RZKSOLL	☐	RZKSOLL	SAKNR	CHAR	10	0	Debit interim account	SKA1
62	RZKHABE	☐	RZKHABE	SAKNR	CHAR	10	0	Credit interim account	SKA1
63	SBSLSOLL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
64	SBSLZKSO	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
65	SBSLZKHA	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
66	SHSLHABEN	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
67	BUCHTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
68	RBANKK	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	SKB1
69	SFDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
70	JFDUPD	☐	JFDUPD	JANEI	CHAR	1	0	Record transferred to cash management and forecast
71	JONLAEN	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
72	JZINSBAS	☐	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
73	JZINSZPT	☐	JZINSZPT	JANEI	CHAR	1	0	Interest date
74	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
75	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
76	SSORTZIT	☐	SSORTZIT	CHAR1	CHAR	1	0	Sort indicator for interest/repayment schedule calculations
77	SWOHER	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
78	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
79	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
80	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method
81	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
82	RPARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
83	SROLEXT	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
84	JEINBEHALT	☐	JEINBEHALT	KENZX	CHAR	1	0	Indicator for Withholding of Amount During Disbursement
85	JFIRUECK	☐	JFIRUECK	JANEI	CHAR	1	0	Confirmation From FI Not Necessary
86	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
87	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
88	SBUST	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key	TZB09

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDBEVI	BUKRS	T001	BUKRS	KEY	1	CN
2	VDBEVI	GSBER	TGSB	GSBER	KEY	1	CN
3	VDBEVI	HKONT	SKB1	SAKNR	KEY	1	CN
4	VDBEVI	KUNNR	KNA1	KUNNR	KEY	1	CN
5	VDBEVI	MABER	T047M	MABER	KEY	1	CN
6	VDBEVI	MANDT	T000	MANDT	KEY	1	CN
7	VDBEVI	RBANKK	SKB1	SAKNR	KEY	1	CN
8	VDBEVI	RHABEN	SKA1	SAKNR	KEY	1	1
9	VDBEVI	RPARTNR	BUT000	PARTNER
10	VDBEVI	RSOLL	SKA1	SAKNR	KEY	1	1
11	VDBEVI	RZKHABE	SKA1	SAKNR	KEY	1	1
12	VDBEVI	RZKSOLL	SKA1	SAKNR	KEY	1	1
13	VDBEVI	SBLART	T003	BLART	KEY	1	CN
14	VDBEVI	SBSLSOLL	TBSL	BSCHL	KEY	1	CN
15	VDBEVI	SBSLZKHA	TBSL	BSCHL	KEY	1	CN
16	VDBEVI	SBSLZKSO	TBSL	BSCHL	KEY	1	CN
17	VDBEVI	SBUST	TZB09	SBUST	KEY	1	CN
18	VDBEVI	SFDLEV	T036	EBENE	KEY	1	CN
19	VDBEVI	SHSLHABEN	TBSL	BSCHL	KEY	1	CN
20	VDBEVI	SSTOGRD	TZST	SSTOGRD	KEY	1	1
21	VDBEVI	ZAHLS	T008	ZAHLS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in