SAP ABAP Table CVWBEPP (Structure for change documents in VWBEPP)

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	INTTAB	Structure
Structure	CVWBEPP	Table Relationship Diagram
Short Description	Structure for change documents in VWBEPP

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CVWBEPP	BUKRS	T001	BUKRS	KEY	1	CN
2	CVWBEPP	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	KEY	1	CN
3	CVWBEPP	GSBER	TGSB	GSBER	KEY	1	CN
4	CVWBEPP	KOSTL	CSKS	KOSTL	KEY	1	CN
5	CVWBEPP	MANDT	T000	MANDT	KEY	1	CN
6	CVWBEPP	OBJNR	ONR00	OBJNR	REF	1	1
7	CVWBEPP	RAHABKI	T012	HBKID	REF	C	CN
8	CVWBEPP	RAHKTID	T012K	HKTID	REF	C	CN
9	CVWBEPP	RANL	VWPANLA	RANL	KEY	1	CN
10	CVWBEPP	RBANKK	SKB1	SAKNR	REF	C	CN
11	CVWBEPP	RDEALER	TZDEA	RDEALER	KEY	1	CN
12	CVWBEPP	RHABEN	SKA1	SAKNR	KEY	1	1
13	CVWBEPP	RHANDPL	TWH01	RHANDPL	REF	C	CN
14	CVWBEPP	RLDEPO	TWD01	RLDEPO	KEY	1	CN
15	CVWBEPP	RREFKONT	T037S	RREFKONT	KEY	1	CN
16	CVWBEPP	RSOLL	SKA1	SAKNR	KEY	1	1
17	CVWBEPP	RZBANK	BUT000	PARTNER		1	CN
18	CVWBEPP	RZKHABE	SKA1	SAKNR	KEY	1	1
19	CVWBEPP	RZKSOLL	SKA1	SAKNR	KEY	1	1
20	CVWBEPP	SANST	TW14	SANST	KEY	1	CN
21	CVWBEPP	SBEWART	TZB0A	SBEWART	KEY	1	CN
22	CVWBEPP	SBSLHABEN	TBSL	BSCHL	KEY	1	CN
23	CVWBEPP	SBSLSOLL	TBSL	BSCHL	KEY	1	CN
24	CVWBEPP	SBSLZKHA	TBSL	BSCHL	KEY	1	CN
25	CVWBEPP	SBSLZKSO	TBSL	BSCHL	KEY	1	CN
26	CVWBEPP	SBUST	TZB09	SBUST	KEY	1	CN
27	CVWBEPP	SBWHR	TCURC	WAERS	KEY	1	CN
28	CVWBEPP	SCRWHR1	TCURC	WAERS	KEY	1	CN
29	CVWBEPP	SCRWHR2	TCURC	WAERS	KEY	1	CN
30	CVWBEPP	SCWHR	TCURC	WAERS	KEY	1	CN
31	CVWBEPP	SFDLEV	T036	EBENE	KEY	1	CN
32	CVWBEPP	SKOART	TZK01	SKOART	REF	C	CN
33	CVWBEPP	SNWHR	TCURC	WAERS	KEY	1	CN
34	CVWBEPP	SRUNIT	TZUNI	SRUNIT	KEY	1	CN
35	CVWBEPP	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20141121
SAP Release Created in