SAP ABAP Table CVWORDE (Structure for change documents in VWORDE)

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	CVWORDE	Table Relationship Diagram
Short Description	Structure for change documents in VWORDE

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	Order Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
5	DTRANS	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
6	TTRANS	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
7	NTRANS	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
8	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
9	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
10	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
11	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
12	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
13	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
14	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
15	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
16	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
17	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
18	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
19	INTEB	☐	VVSINTEB	INTEB	NUMC	2	0	Financial Assets Management internal level	*
20	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
21	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	TZB03
22	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
23	DVORGANG	☐	DVORGANG	DATUM	DATS	8	0	Activity date
24	SVORGANG	☐	RVORGANG	RVORGANG	CHAR	8	0	Securities-Activity
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	☐	KURSF	KURSF	DEC	9	5	Exchange rate
36	KURS2	☐	KURSF	KURSF	DEC	9	5	Exchange rate
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	RBANKK	☐	RBANKK	SAKNR	CHAR	10	0	Bank account	SKB1
47	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	BUT000
48	SROLEXTKO	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
49	SFDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
50	JFDUPD	☐	JFDUPD	JANEI	CHAR	1	0	Record transferred to cash management and forecast
51	JONLAEN	☐	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
52	JZINSBAS	☐	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
53	JZINSZPT	☐	JZINSZPT	JANEI	CHAR	1	0	Interest date
54	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
55	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
56	SSTCKTG	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
57	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
58	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
59	SCRWHR1	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
60	SCRWHR2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
61	KCROSS	☐	KURSF	KURSF	DEC	9	5	Exchange rate
62	NORDEXT	☐	NORDEXT	CHAR20	CHAR	20	0	External order number
63	SWOHER	☐	SWOHER	CHAR1	CHAR	1	0	Source of flow record
64	XZUSATZ	☐	XZUSATZ	CHAR18	CHAR	18	0	Assignment
65	DANST	☐	DANST	DATUM	DATS	8	0	Reservation date
66	TANST	☐	TANST	TIMES	TIMS	6	0	Order time of day
67	SANST	☐	SANST	SANST	CHAR	2	0	Reservation reason	*
68	SABRECH	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
69	SVERFALL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
70	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
71	SOBJECT	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
72	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
73	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
74	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
75	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
76	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
77	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
78	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
79	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
80	RZBANK	☐	VVRZBANK_NEW	BU_PARTNER	CHAR	10	0	Paying Bank	BUT000
81	SROLEXTZB	☐	SROLEXT	SROLEXT	CHAR	3	0	External role of partner	*
82	JVERK6B	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
83	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	TWH01
84	SFLAT	☐	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
85	DCOUPON	☐	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
86	SCOUPON	☐	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
87	SSWHR	☐	VVSSWHR	WAERS	CUKY	5	0	Stock price currency	*
88	BSWHR	☐	VVBSWHR	WERTV7	CURR	13	2	Market value
89	SRUNIT	☐	VVSRUNIT	VVSRUNIT	CHAR	5	0	Currency unit	*
90	KWKURS	☐	VVKWKURS	VVKWKURS	DEC	15	6	Security price
91	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
92	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
93	TSCHLUSS	☐	VVTSCHLUSS	UZEIT	TIMS	6	0	Time of business closing
94	SFGKZ	☐	VVSFGKZ	VVSFGKZ	CHAR	1	0	Release Indicator
95	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
96	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
97	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
98	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
99	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
100	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
101	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
102	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
103	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
104	PEFFZCALL	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
105	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
106	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
107	SDELETE	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
108	TBEGRU	☐	TBEGRU	TRBEGRU	CHAR	4	0	Authorization Group	*
109	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
110	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
111	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
112	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
113	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
114	SPRSNG	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
115	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
116	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	CVWORDE	BUKRS	T001	BUKRS	KEY	1	CN
2	CVWORDE	OBJNR	ONR00	OBJNR	REF	1	1
3	CVWORDE	RANL	VWPANLA	RANL	KEY	1	CN
4	CVWORDE	RBANKK	SKB1	SAKNR	KEY	1	CN
5	CVWORDE	RDEALER	TZDEA	RDEALER	KEY	1	CN
6	CVWORDE	RHANDPL	TWH01	RHANDPL	REF	C	CN
7	CVWORDE	RKONTRA	BUT000	PARTNER		1	CN
8	CVWORDE	RLDEPO	TWD01	RLDEPO	KEY	1	CN
9	CVWORDE	RZBANK	BUT000	PARTNER		1	CN
10	CVWORDE	SBEWART	TZB0A	SBEWART	KEY	1	CN
11	CVWORDE	SBEWZITI	TZB03	SBEWZITI	KEY	1	CN
12	CVWORDE	SBWHR	TCURC	WAERS	KEY	1	CN
13	CVWORDE	SCRWHR1	TCURC	WAERS	KEY	1	CN
14	CVWORDE	SCRWHR2	TCURC	WAERS	KEY	1	CN
15	CVWORDE	SCWHR	TCURC	WAERS	KEY	1	CN
16	CVWORDE	SNWHR	TCURC	WAERS	KEY	1	CN
17	CVWORDE	SSTATI	TZC37	STATU	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in