SAP ABAP Table VWBEVI (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VWBEVI	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	RBELNR	☑	RBELKPF	RBELKPF	CHAR	10	0	Number of flow header	*
4	RPOSNR	☑	NVORGANG	CHAR3	CHAR	3	0	Activity number
5	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
6	RLDEPO	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
7	DVORGANG	☐	DVORGANG	DATUM	DATS	8	0	Activity date
8	SVORGANG	☐	RVORGANG	RVORGANG	CHAR	8	0	Securities-Activity
9	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
10	INTEB	☐	VVSINTEB	INTEB	NUMC	2	0	Financial Assets Management internal level	*
11	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
12	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
13	RBELNRFI	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
14	RBELNRFI2	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
15	SBLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
16	DBLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
17	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
18	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
19	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
20	RSTBLG	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
21	SSTORNO	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
22	SSTOGRD	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
23	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
24	DANJRNL	☐	DANJRNL	DATUM	DATS	8	0	Date of transferal to journal
25	DANFIBU	☐	DANFIBU	DATUM	DATS	8	0	Date of transferal to FiAc
26	UANFIBU	☐	UANFIBU	TIMES	TIMS	6	0	Time of transfer to financial accounting
27	SSPESEN	☐	SSPESEN	SSPESEN	CHAR	1	0	Expenses key
28	NORDER	☐	SECPOSITIONNUMBER	NUM8	NUMC	8	0	Position number
29	NORDEXT	☐	NORDEXT	CHAR20	CHAR	20	0	External order number
30	RBANKK	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	SKA1
31	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	*
32	SROLEXTKO	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
33	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
34	XZUSATZ	☐	XZUSATZ	CHAR18	CHAR	18	0	Assignment
35	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
36	SSTCKTG	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
37	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
38	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
39	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
40	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
41	SOBJEKT	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
42	RZBANK	☐	VVRZBANK_NEW	BU_PARTNER	CHAR	10	0	Paying Bank	BUT000
43	SROLEXTZB	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
44	DSTOCK	☐	VVDSTOCK	DATUM	DATS	8	0	Premium reserve fund date
45	RPNNR	☐	VVRPNNR	VVRPNNR	CHAR	10	0	Daybook no.
46	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	TWH01
47	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
48	SEVALPOST	☐	SEVALPOST	XFELD	CHAR	1	0	PEC for flow executed indicator yes/no
49	REFRLDEPO	☐	VVREFRLDEP	RLDEPO	CHAR	10	0	Reference sec.acct for sec.acct transfer (inflow/outflow)	*
50	TRSEDOCNR1	☐	TRSEDOCNR	TRSEDOCNR	CHAR	10	0	Document number of security posting document	VWPOSTDOC
51	TRSEGJAHR1	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
52	TRSEDOCNR2	☐	TRSEDOCNR	TRSEDOCNR	CHAR	10	0	Document number of security posting document	VWPOSTDOC
53	TRSEGJAHR2	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
54	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
55	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
56	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
57	DEVALPOST	☐	DEVALPOST	DATUM	DATS	8	0	Date of period-end closing
58	SHERKUNFT	☐	VVSHERK	VVSHERK	CHAR	1	0	Origin indicator: 'From planned record/actual record'
59	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
60	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
61	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
62	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
63	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
64	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
65	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
66	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
67	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
68	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
69	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
70	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
71	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
72	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
73	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
74	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
75	BWKURS	☐	BWKURS	BWKURS	CURR	13	2	Security price for unit quotation
76	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
77	PWKURS	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
78	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
79	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
80	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
81	KURS1	☐	KURSF	KURSF	DEC	9	5	Exchange rate
82	KURS2	☐	KURSF	KURSF	DEC	9	5	Exchange rate
83	DVALUT	☐	VVDZINVAL	DATUM	DATS	8	0	Interest Value Date/Calculation Date
84	DDISPO	☐	VVDWERTST	DATUM	DATS	8	0	Value date / planning day
85	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
86	DBEST6B	☐	DBEST6B	DATUM	DATS	8	0	Date for §6b EstG relevant postings
87	RSOLL	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	SKA1
88	SBSLSOLL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
89	RZKSOLL	☐	RZKSOLL	SAKNR	CHAR	10	0	Debit interim account	SKA1
90	SBSLZKSO	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
91	RZKHABE	☐	RZKHABE	SAKNR	CHAR	10	0	Credit interim account	SKA1
92	SBSLZKHA	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
93	RHABEN	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	SKA1
94	SBSLHABEN	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
95	SWHRT	☐	SWHRT	SWHRT	CHAR	1	0	Currency swap indicator
96	JONLAEN	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
97	JZINSBAS	☐	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
98	JZINSZPT	☐	JZINSZPT	JANEI	CHAR	1	0	Interest date
99	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
100	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
101	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
102	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
103	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
104	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
105	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
106	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
107	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
108	SWOHER	☐	TB_SWOHER	TB_SWOHER	CHAR	1	0	Treasury: Source of flow
109	JSTOCK	☐	VVJSTOCK	JANEI	CHAR	1	0	Premium reserve fund-relevant indicator
110	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
111	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
112	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
113	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
114	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
115	SINCLVON	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
116	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
117	DVERRECH	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
118	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
119	SREFZITI	☐	VVSREFZITI	SBEWZITI	CHAR	4	0	Refer.flow category in accrual/deferral flow records	*
120	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
121	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
122	APERTAGE	☐	VVAPERTAGE	INT6	NUMC	6	0	No. of days of a (calculation) period in cash flow
123	STGMETH	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
124	STGBASIS	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
125	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
126	SPAEXCL	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
127	SPAULT	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
128	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
129	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
130	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
131	SINCLVERR	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
132	SULTVERR	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
133	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
134	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
135	DCOUPON	☐	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
136	SCOUPON	☐	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
137	SFLAT	☐	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
138	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
139	SVORGKZ	☐	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
140	SREFBEW	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
141	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
142	SSWHR	☐	VVSSWHR	WAERS	CUKY	5	0	Stock price currency	TCURC
143	BSWHR	☐	VVBSWHR	WERTV7	CURR	13	2	Market value
144	SRUNIT	☐	VVSRUNIT	VVSRUNIT	CHAR	5	0	Currency unit	TZUNI
145	KWKURS	☐	VVKWKURS	VVKWKURS	DEC	15	6	Security price
146	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
147	TSCHLUSS	☐	VVTSCHLUSS	UZEIT	TIMS	6	0	Time of business closing
148	SBUCHA	☐	VVSBUCHA	CHAR1	CHAR	1	0	Indicator for postings to accruals/deferrals accounts
149	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
150	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
151	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
152	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
153	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
154	KGV_FLAG	☐	TKGV	TKGV	CHAR	1	0	Manages status of the related price gains/losses flows
155	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
156	KMNR	☐	KMNR	VKMNR	CHAR	13	0	Corporate Action Number	*
157	ERNR	☐	TER_HEADNUMBER	TER_RIGHTNUMBER	CHAR	13	0	ID number of exercised right
158	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
159	SPRSNG	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
160	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
161	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
162	INDEX_VALUE	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
163	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
164	BBWHR_IDX_CLEAN	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
165	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
166	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
167	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
168	MIGR_CFM10	☐	TPM_MIGR_CFM10	TPM_MIGR_CFM10	CHAR	1	0	Status of Flow Related to Migration to CFM 1.0
169	MIGR_ERP20	☐	TPM_MIGR_ERP20	TPM_MIGR_ERP20	CHAR	1	0	Status of Flow Related to Migration to ERP2.0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VWBEVI	BUKRS	T001	BUKRS	KEY	1	CN
2	VWBEVI	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	KEY	C	CN
3	VWBEVI	GSBER	TGSB	GSBER	KEY	1	CN
4	VWBEVI	KUNNR	KNA1	KUNNR	KEY	1	CN
5	VWBEVI	MANDT	T000	MANDT	KEY	1	CN
6	VWBEVI	OBJNR	ONR00	OBJNR	REF	1	1
7	VWBEVI	RANL	VWPANLA	RANL	KEY	1	CN
8	VWBEVI	RBANKK	SKA1	SAKNR	KEY	1	1
9	VWBEVI	RHABEN	SKA1	SAKNR	KEY	1	1
10	VWBEVI	RHANDPL	TWH01	RHANDPL	REF	C	CN
11	VWBEVI	RLDEPO	TWD01	RLDEPO	KEY	1	CN
12	VWBEVI	RSOLL	SKA1	SAKNR	KEY	1	1
13	VWBEVI	RZBANK	BUT000	PARTNER		C	CN
14	VWBEVI	RZKHABE	SKA1	SAKNR	KEY	1	1
15	VWBEVI	RZKSOLL	SKA1	SAKNR	KEY	1	1
16	VWBEVI	SBERFIMA	AT40	SBERFIMA
17	VWBEVI	SBEWART	TZB0A	SBEWART
18	VWBEVI	SBEWZITI	TZB03	SBEWZITI
19	VWBEVI	SBLART	T003	BLART	KEY	1	1
20	VWBEVI	SBWHR	TCURC	WAERS	KEY	1	1
21	VWBEVI	SCWHR	TCURC	WAERS	KEY	1	1
22	VWBEVI	SKOART	TZK01	SKOART	REF	C	CN
23	VWBEVI	SNWHR	TCURC	WAERS	KEY	1	1
24	VWBEVI	SRUNIT	TZUNI	SRUNIT	KEY	1	CN
25	VWBEVI	SSTOGRD	TZST	SSTOGRD	KEY	1	1
26	VWBEVI	SSWHR	TCURC	WAERS	KEY	1	CN
27	VWBEVI	TRSEDOCNR1	VWPOSTDOC	DOCNR	KEY	C	N
28	VWBEVI	TRSEDOCNR2	VWPOSTDOC	DOCNR	KEY	C	N

History

Last changed by/on	SAP	20141121
SAP Release Created in