SAP ABAP Table CVDBEPP (Structure for change documents in VDBEPP)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	INTTAB	Structure
Structure	CVDBEPP	Table Relationship Diagram
Short Description	Structure for change documents in VDBEPP

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	Flow Data - Planned Item
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RANL	☐	RANL	RANL	CHAR	13	0	Contract 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	.INCLUDE	☐				0	0	INCLUDE for VDBEPP (new fields always at the end)
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	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	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
21	SREFBEW	☐	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
22	SBEWZITI	☐	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	*
23	SPLANIST	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
24	SSOLHAB	☐	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
25	SSTORNO	☐	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
26	SSTOGRD	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
27	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
28	RSTBLG	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
29	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
30	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
31	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
32	NLFD_ANG	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
33	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
34	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPAB
35	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
36	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
37	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
38	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
39	BNWHR	☐	BNWHR	WERTV7	CURR	13	2	Nominal amount
40	SNWHR	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	TCURC
41	BBWHR	☐	BBWHR	WERTV7	CURR	13	2	Amount in position currency
42	SBWHR	☐	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	TCURC
43	BCWHR	☐	BCWHR	WERTV7	CURR	13	2	Settlement Amount
44	SCWHR	☐	SCWHR	WAERS	CUKY	5	0	Settlement Currency	TCURC
45	BHWHR	☐	BHWHR	WERTV7	CURR	13	2	Amount in local currency
46	KURS1	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
47	KURS2	☐	VVKURSF	KURSF	DEC	9	5	Exchange rate
48	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
49	DFAELL	☐	DFAELLIG	DATUM	DATS	8	0	Due date/calculation date
50	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
51	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
52	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
53	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
54	ATAGE	☐	VVATAGE	INT6	NUMC	6	0	Number of days
55	ABASTAGE	☐	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
56	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
57	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
58	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
59	SSPESEN	☐	SSPESEN	SSPESEN	CHAR	1	0	Expenses key
60	RSOLL	☐	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	SKA1
61	RHABEN	☐	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	SKA1
62	RZKSOLL	☐	RZKSOLL	SAKNR	CHAR	10	0	Debit interim account	SKA1
63	RZKHABE	☐	RZKHABE	SAKNR	CHAR	10	0	Credit interim account	SKA1
64	SBSLSOLL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
65	SBSLZKSO	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
66	SBSLZKHA	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
67	SHSLHABEN	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
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	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
79	SSTCKTG	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
80	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
81	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
82	JVERF	☐	JVERF	JVERF	CHAR	1	0	Indicator whether drawings exist for the disbursement
83	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
84	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
85	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
86	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
87	ZAHLS	☐	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	T008
88	RPARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
89	SROLEXT	☐	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
90	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
91	JEINBEHALT	☐	VVJEINBE	KENZX	CHAR	1	0	Indicator for withholding of amount during disbursement
92	SZEGEN	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	*
93	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
94	DTRANSREF	☐	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
95	TTRANSREF	☐	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
96	NTRANSREF	☐	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
97	RPNNR	☐	VVRPNNR	VVRPNNR	CHAR	10	0	Daybook no.
98	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
99	SBUST	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key	TZB09
100	PWKURS	☐	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
101	DSTOCK	☐	VVDSTOCK	DATUM	DATS	8	0	Premium reserve fund date
102	JVORAUS	☐	VVJVORAUS	KENZX	CHAR	1	0	ID for planned record reference to an advance payment
103	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
104	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
105	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
106	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
107	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
108	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
109	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
110	DVERRECH	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
111	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
112	RUMBLG	☐	UMBLG	BELNR	CHAR	10	0	Reference transfer document number
113	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
114	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
115	JSOFVERR	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
116	SINCLVERR	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
117	SULTVERR	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
118	SREFZITI	☐	VVSREFZITI	SBEWZITI	CHAR	4	0	Refer.flow category in accrual/deferral flow records	*
119	STGBASIS	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
120	STGMETH	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
121	SBASIS	☐	VVSBASIS	VVSBASIS	CHAR	4	0	Calculation base reference	TZFB
122	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	AT40
123	SVORGKZ	☐	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
124	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
125	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
126	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
127	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
128	SPAEXCL	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
129	SPAULT	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
130	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
131	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
132	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
133	RKONT	☐	RKONT	RKONT	NUMC	6	0	Quota number
134	DAUSZ	☐	VVDAUSZ	DATUM	DATS	8	0	Lead date for withholding amounts for disbursement
135	SSOLIST	☐	SSOLIST	CHAR1	CHAR	1	0	Calculation using actual principle (or debit)
136	RDARNEHM	☐	RDARNEHM_NEW	BU_PARTNER	CHAR	10	0	Borrower/Applicant Number	*
137	BKOND	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
138	RZEBEL	☐	VEBLGNR	BELNR	CHAR	10	0	Document number of waiver/write-off document
139	ZFBDT	☐	DDISPO	DATUM	DATS	8	0	Payment Date
140	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
141	SBERECH	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
142	BKARZINS	☐	TFMBKAZINS	TFM_WRTV7	CURR	13	2	Int.for days betw. redemption clear.and pmnt (FiMa-internal)
143	BTITALK	☐	TFMBTIKALK	TFM_WRTV7	CURR	13	2	Imputed annuity repayment amount (FiMa internal)
144	HDN_KUNNR	☐	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	KNA1
145	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
146	RUZBEL	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
147	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
148	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
149	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
150	S_SSDREF	☐	VVS_SSDREF	SBEWZITI	CHAR	4	0	Reference flow category in borrower's note loan flow records	*
151	SAEND	☐	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
152	XPORE	☐	PRQ_XPORE	XFELD	CHAR	1	0	Indicator: Individual Payment?
153	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
154	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
155	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
156	VORGTYP	☐	VORGTYP_LO	VORGTYP_LO	CHAR	4	0	Activity Category (Posting Area)
157	ACENV	☐	ACENV_LO	ACENV_LO	NUMC	4	0	Source in TR-LO posting area
158	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
159	SPRSNG	☐	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
160	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
161	SPRGRD	☐	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
162	SCSPAY	☐	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
163	ZWELS	☐	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
164	PAYGR	☐	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
165	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
166	SREVALEXCL	☐	VVSREVALEXCL	XFELD	CHAR	1	0	Price gains w/o proportionate gains from deferral write-back
167	RBO	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
168	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
169	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
170	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
171	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
172	LC_CAPITALS	☐	TB_LC_CAPITALS	T_LC_CASH_FLOW	CHAR	2	0	Effect of the Flow on Capital Amounts Status
173	LC_DISBURSE	☐	TB_LC_DISBURSE	T_LC_CASH_FLOW	CHAR	2	0	Effect of the Flow on the Disbursement Status
174	OP_APPLICATION	☐	TB_OPAPPL	T_OPAPPL	NUMC	2	0	Open Item Tool: Application Key	*
175	OP_RBO	☐	TB_OP_RBO	RBO	CHAR	15	0	OI Tool: Locking Business Operation
176	DFAELL_OLD_EXT	☐	TB_EXTENS_DFAELL_OLD	DATUM	DATS	8	0	Old Due Date
177	DDISPO_OLD_EXT	☐	TB_EXTENS_DDISPO_OLD	DATUM	DATS	8	0	Old Payment Date
178	RBO_EXT	☐	RBO	RBO	CHAR	15	0	Business Operation Number (Loans)
179	SBEWEGRP2	☐	TB_FLOW_REC_GRP	SBEWEGRP2	NUMC	6	0	Flow Record Group in Cash Flow Calculator (Incoming Payment)
180	SUSP_REASON_TYPE	☐	TB_SUSPREASON	T_SUSPREASON	NUMC	3	0	Key for Overpayment Reason	TDSUSPREASON
181	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
182	.INCLUDE	☐				0	0	SEPA Remittance Information
183	REMIT_INFO	☐	TB_REMIT_INFO	T_REMIT_INFO	CHAR	140	0	SEPA Payment Notes Information
184	.INCLU--AP	☐				0	0	Extensions for Localization
185	BROUNDUNIT	☐	TB_BROUNDUNIT_A	TFMSRUNIT	DEC	13	7	Rounding Unit for Amounts
186	.INCLU--AP	☐				0	0	Additional Fields for SEPA Direct Debit
187	SEPA_PD	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
188	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	CVDBEPP	BUKRS	T001	BUKRS	KEY	1	CN
2	CVDBEPP	GSART	TZPAB	GSART	KEY	1	CN
3	CVDBEPP	GSBER	TGSB	GSBER
4	CVDBEPP	HBKID	T012	HBKID	KEY	1	CN
5	CVDBEPP	HDN_KUNNR	KNA1	KUNNR	REF	C	CN
6	CVDBEPP	HKTID	T012K	HKTID
7	CVDBEPP	KUNNR	KNA1	KUNNR	REF	C	CN
8	CVDBEPP	MABER	T047M	MABER	KEY	1	CN
9	CVDBEPP	MANDT	T000	MANDT	KEY	1	CN
10	CVDBEPP	MANSP	T040S	MANSP
11	CVDBEPP	MWSKZ	T007A	MWSKZ
12	CVDBEPP	RBANKK	SKB1	SAKNR	KEY	1	CN
13	CVDBEPP	RHABEN	SKA1	SAKNR	KEY	1	1
14	CVDBEPP	RPARTNR	BUT000	PARTNER	KEY	1	CN
15	CVDBEPP	RREFKONT	T037S	RREFKONT
16	CVDBEPP	RSOLL	SKA1	SAKNR	KEY	1	1
17	CVDBEPP	RZKHABE	SKA1	SAKNR	KEY	1	1
18	CVDBEPP	RZKSOLL	SKA1	SAKNR	KEY	1	1
19	CVDBEPP	SBASIS	TZFB	SBASIS
20	CVDBEPP	SBERFIMA	AT40	SBERFIMA	KEY	1	CN
21	CVDBEPP	SBSLSOLL	TBSL	BSCHL	KEY	1	CN
22	CVDBEPP	SBSLZKHA	TBSL	BSCHL	KEY	1	CN
23	CVDBEPP	SBSLZKSO	TBSL	BSCHL	KEY	1	CN
24	CVDBEPP	SBUST	TZB09	SBUST	KEY	1	CN
25	CVDBEPP	SBWHR	TCURC	WAERS	KEY	1	CN
26	CVDBEPP	SCWHR	TCURC	WAERS	KEY	1	CN
27	CVDBEPP	SFDLEV	T036	EBENE	KEY	1	CN
28	CVDBEPP	SHSLHABEN	TBSL	BSCHL	KEY	1	CN
29	CVDBEPP	SKOART	TZK01	SKOART	KEY	1	CN
30	CVDBEPP	SNWHR	TCURC	WAERS	KEY	1	CN
31	CVDBEPP	SSTOGRD	TZST	SSTOGRD	KEY	1	CN
32	CVDBEPP	SUSP_REASON_TYPE	TDSUSPREASON	SSUSPREASON	KEY
33	CVDBEPP	UZAWE	T042F	UZAWE
34	CVDBEPP	ZAHLS	T008	ZAHLS	KEY	1	CN
35	CVDBEPP	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20141121
SAP Release Created in