SAP ABAP Table VWBEPI (Treasury Securities: Actual Flows - Item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVW (Package) Treasury Management: Securities

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VWBEPI	Table Relationship Diagram
Short Description	Treasury Securities: Actual Flows - Item

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	VWBEKI
4	RPOSNR	☑	NVORGANG	CHAR3	CHAR	3	0	Activity number
5	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
6	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
7	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
8	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
9	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
13	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
14	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
15	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
16	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
17	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
18	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
19	ASTUECK	☐	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
20	BWKURS	☐	BWKURS	BWKURS	CURR	13	2	Security price for unit quotation
21	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
22	PWKURS	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
23	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
24	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
25	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
26	KURS1	☐	KURSF	KURSF	DEC	9	5	Exchange rate
27	KURS2	☐	KURSF	KURSF	DEC	9	5	Exchange rate
28	DVALUT	☐	VVDZINVAL	DATUM	DATS	8	0	Interest Value Date/Calculation Date
29	DDISPO	☐	VVDWERTST	DATUM	DATS	8	0	Value date / planning day
30	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
31	DBEST6B	☐	DBEST6B	DATUM	DATS	8	0	Date for §6b EstG relevant postings
32	RSOLL	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	SKA1
33	SBSLSOLL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
34	RZKSOLL	☐	RZKSOLL	SAKNR	CHAR	10	0	Debit interim account	SKA1
35	SBSLZKSO	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
36	RZKHABE	☐	RZKHABE	SAKNR	CHAR	10	0	Credit interim account	SKA1
37	SBSLZKHA	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
38	RHABEN	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	SKA1
39	SBSLHABEN	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
40	SWHRT	☐	SWHRT	SWHRT	CHAR	1	0	Currency swap indicator
41	JONLAEN	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
42	JZINSBAS	☐	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
43	JZINSZPT	☐	JZINSZPT	JANEI	CHAR	1	0	Interest date
44	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
45	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
46	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
47	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
48	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
49	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
50	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
51	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
52	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
53	SWOHER	☐	TB_SWOHER	TB_SWOHER	CHAR	1	0	Treasury: Source of flow
54	JSTOCK	☐	VVJSTOCK	JANEI	CHAR	1	0	Premium reserve fund-relevant indicator
55	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
56	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
57	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
58	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
59	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
60	SINCLVON	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
61	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
62	DVERRECH	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
63	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
64	SREFZITI	☐	VVSREFZITI	SBEWZITI	CHAR	4	0	Refer.flow category in accrual/deferral flow records	*
65	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
66	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
67	APERTAGE	☐	VVAPERTAGE	INT6	NUMC	6	0	No. of days of a (calculation) period in cash flow
68	STGMETH	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
69	STGBASIS	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
70	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
71	SPAEXCL	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
72	SPAULT	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
73	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
74	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
75	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
76	SINCLVERR	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
77	SULTVERR	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
78	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
79	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
80	DCOUPON	☐	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
81	SCOUPON	☐	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
82	SFLAT	☐	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
83	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
84	SVORGKZ	☐	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
85	SREFBEW	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
86	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
87	SSWHR	☐	VVSSWHR	WAERS	CUKY	5	0	Stock price currency	TCURC
88	BSWHR	☐	VVBSWHR	WERTV7	CURR	13	2	Market value
89	SRUNIT	☐	VVSRUNIT	VVSRUNIT	CHAR	5	0	Currency unit	TZUNI
90	KWKURS	☐	VVKWKURS	VVKWKURS	DEC	15	6	Security price
91	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
92	TSCHLUSS	☐	VVTSCHLUSS	UZEIT	TIMS	6	0	Time of business closing
93	SBUCHA	☐	VVSBUCHA	CHAR1	CHAR	1	0	Indicator for postings to accruals/deferrals accounts
94	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
95	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
96	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
97	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
98	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
99	KGV_FLAG	☐	TKGV	TKGV	CHAR	1	0	Manages status of the related price gains/losses flows
100	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
101	KMNR	☐	KMNR	VKMNR	CHAR	13	0	Corporate Action Number	*
102	ERNR	☐	TER_HEADNUMBER	TER_RIGHTNUMBER	CHAR	13	0	ID number of exercised right
103	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
104	SPRSNG	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
105	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
106	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
107	INDEX_VALUE	☐	TIDX_INDEX_VALUE_NO_RATIO	TIDX_INDEX_VALUE_NO_RATIO	DEC	18	12	Index Value (Independent of Basis)
108	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
109	BBWHR_IDX_CLEAN	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
110	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
111	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
112	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
113	MIGR_CFM10	☐	TPM_MIGR_CFM10	TPM_MIGR_CFM10	CHAR	1	0	Status of Flow Related to Migration to CFM 1.0
114	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	VWBEPI	BUKRS	T001	BUKRS	KEY	1	CN
2	VWBEPI	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	KEY	C	CN
3	VWBEPI	KUNNR	KNA1	KUNNR	KEY	1	CN
4	VWBEPI	MANDT	T000	MANDT	KEY	1	CN
5	VWBEPI	RBELNR	VWBEKI	RBELNR	KEY	1	CN
6	VWBEPI	RHABEN	SKA1	SAKNR	KEY	1	1
7	VWBEPI	RSOLL	SKA1	SAKNR	KEY	1	1
8	VWBEPI	RZKHABE	SKA1	SAKNR	KEY	1	1
9	VWBEPI	RZKSOLL	SKA1	SAKNR	KEY	1	1
10	VWBEPI	SBERFIMA	AT40	SBERFIMA
11	VWBEPI	SBEWART	TZB0A	SBEWART
12	VWBEPI	SBEWZITI	TZB03	SBEWZITI
13	VWBEPI	SBWHR	TCURC	WAERS	KEY	1	1
14	VWBEPI	SCWHR	TCURC	WAERS	KEY	1	1
15	VWBEPI	SKOART	TZK01	SKOART	REF	C	CN
16	VWBEPI	SNWHR	TCURC	WAERS	KEY	1	1
17	VWBEPI	SRUNIT	TZUNI	SRUNIT	KEY	1	CN
18	VWBEPI	SSWHR	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20141121
SAP Release Created in