SAP ABAP Table CVDBEPI (Structure for change documents in VDBEPI)
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 CVDBEPI   Table Relationship Diagram
Short Description Structure for change documents in VDBEPI    
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   Posted line items for document header  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
4 RBELKPFD RBELKPFD RBELKPFD CHAR 10   0   Document Number of Document Header (Loan) VDBEKI
5 RPOSNR NVORGANG CHAR3 CHAR 3   0   Activity number  
6 SBEWART SBEWART SBEWART CHAR 4   0   Flow Type *
7 SREFBEW SREFBEW SBEWART CHAR 4   0   Reference flow type *
8 SBEWZITI SBEWZITI SBEWZITI CHAR 4   0   Flow category *
9 BNWHR BNWHR WERTV7 CURR 13   2   Nominal amount  
10 SNWHR SNWHR WAERS CUKY 5   0   Currency of nominal amount *
11 BBWHR BBWHR WERTV7 CURR 13   2   Amount in position currency  
12 SBWHR SBWHR WAERS CUKY 5   0   Position Currency (Currency of Position Amount) *
13 BCWHR BCWHR WERTV7 CURR 13   2   Settlement Amount  
14 SCWHR SCWHR WAERS CUKY 5   0   Settlement Currency *
15 BHWHR BHWHR WERTV7 CURR 13   2   Amount in local currency  
16 PKKURS PKKURS PWKURS DEC 10   7   Purchase Price of Borrower's Note  
17 PRUCK PRUCK DEC3_7 DEC 10   7   Repayment rate in percent  
18 KURS1 VVKURSF KURSF DEC 9   5   Exchange rate  
19 KURS2 VVKURSF KURSF DEC 9   5   Exchange rate  
20 DVALUT DVALUT DATUM DATS 8   0   Calculation Date  
21 DFAELL DFAELL DATUM DATS 8   0   Due date  
22 DDISPO DDISPO DATUM DATS 8   0   Payment Date  
23 DBESTAND DBESTAND DATUM DATS 8   0   Position value date  
24 DBERVON DBERVON DATUM DATS 8   0   Start of Calculation Period  
25 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator *
26 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
27 SSPESEN SSPESEN SSPESEN CHAR 1   0   Expenses key  
28 SSOLHAB VVSSOLHAB VVSSOLHAB CHAR 1   0   Debit/credit indicator  
29 RSOLL RSOLL SAKNR CHAR 10   0   Account for debit posting SKA1
30 RHABEN RHABEN SAKNR CHAR 10   0   Account for credit posting SKA1
31 RZKSOLL RZKSOLL SAKNR CHAR 10   0   Debit interim account SKA1
32 RZKHABE RZKHABE SAKNR CHAR 10   0   Credit interim account SKA1
33 SBSLSOLL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
34 SBSLZKSO BSCHL BSCHL CHAR 2   0   Posting Key TBSL
35 SBSLZKHA BSCHL BSCHL CHAR 2   0   Posting Key TBSL
36 SHSLHABEN BSCHL BSCHL CHAR 2   0   Posting Key TBSL
37 BUCHTXT SGTXT TEXT50 CHAR 50   0   Item Text  
38 RBANKK RBANKK SAKNR CHAR 10   0   Bank account SKB1
39 SFDLEV FDLEV FDLEV CHAR 2   0   Planning Level T036
40 JFDUPD JFDUPD JANEI CHAR 1   0   Record transferred to cash management and forecast  
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 SSORTZIT SSORTZIT CHAR1 CHAR 1   0   Sort indicator for interest/repayment schedule calculations  
47 SWOHER SWOHER CHAR1 CHAR 1   0   Source of flow record  
48 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
49 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
50 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method *
51 MABER MABER MABER CHAR 2   0   Dunning Area T047M
52 ZAHLS DZAHLS ZAHLS CHAR 1   0   Block Key for Payment T008
53 RPARTNR BP_PARTNR_NEW BU_PARTNER CHAR 10   0   Business Partner Number BUT000
54 SROLEXT DUMMY_3 CHAR3 CHAR 3   0   Dummy function  
55 JEINBEHALT JEINBEHALT KENZX CHAR 1   0   Indicator for Withholding of Amount During Disbursement  
56 JFIRUECK JFIRUECK JANEI CHAR 1   0   Confirmation From FI Not Necessary  
57 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
58 MWART MWART MWART CHAR 1   0   Tax Type  
59 DBERBIS DBERBIS DATUM DATS 8   0   End of Calculation Period  
60 ATAGE VVATAGE INT6 NUMC 6   0   Number of days  
61 ABASTAGE ABASTAGE INT6 NUMC 6   0   Number of base days in a calculation period  
62 SZBMETH SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
63 JSTOCK VVJSTOCK JANEI CHAR 1   0   Premium reserve fund-relevant indicator  
64 SBUST VVSBUST VVSBUST NUMC 2   0   Posting control key TZB09
65 DTRANS VVDTRANS DATUM DATS 8   0   Flow data key: System date  
66 TTRANS VVTTRANS UZEIT TIMS 6   0   Transaction data key: system time  
67 NTRANS VVNTRANS NUMC4 NUMC 4   0   Transaction data key: Consecutive number  
68 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
69 SKOART SKOART SKOART NUMC 4   0   Condition Type (Smallest Subdivision of Condition Records) TZK01
70 SEXCLVON VVSEXCLVON VVSEXCLVON NUMC 1   0   Exclusive Indicator for the Start of a Calculation Period  
71 SULTVON VVSULTVON VVSULT CHAR 1   0   Month-End Indicator for Start of a Calculation Period  
72 SINCLBIS VVSINCLBIS VVSINCLBIS NUMC 1   0   Inclusive Indicator for the End of a Calculation Period  
73 SULTBIS VVSULTBIS VVSULT CHAR 1   0   Month-End Indicator for the End of a Calculation Period  
74 SINCL VVSINCL VVSINCL NUMC 1   0   Inclusive indicator for beginning and end of a period  
75 DVERRECH VVDVERRECH DATUM DATS 8   0   Settlement date  
76 DPKOND VVDPKOND DATUM DATS 8   0   Determination date for percentage rate of condition items  
77 SBUCHA VVSBUCHA CHAR1 CHAR 1   0   Indicator for postings to accruals/deferrals accounts  
78 ZINKZ DZINKZ ZINKZ CHAR 2   0   Exempted from Interest Calculation  
79 SVULT VVSVULT VVSULT CHAR 1   0   Month-End Indicator for Value Date  
80 JSOFVERR JSOFVERR TFMSOFVERR CHAR 1   0   Immediate settlement  
81 SINCLVERR VVSINCLVER VVSINCLVER NUMC 1   0   Inclusive Indicator for Clearing Date  
82 SULTVERR VVSULTVERR VVSULT CHAR 1   0   Month-End Indicator for Clearing Date  
83 SREFZITI VVSREFZITI SBEWZITI CHAR 4   0   Refer.flow category in accrual/deferral flow records *
84 STGBASIS VVSTGBASIS VVSTGBASIS CHAR 1   0   Base Days Method  
85 STGMETH VVSTGMETH VVSTGMETH NUMC 1   0   Daily Method  
86 SBASIS VVSBASIS VVSBASIS CHAR 4   0   Calculation base reference *
87 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
88 SBERFIMA SBEWFIMA SBEWFIMA CHAR 4   0   Calculation category for cash flow calculator AT40
89 SVORGKZ VVSVORGKZ VVSVORGKZ NUMC 2   0   Activity indicator for debit/credit control  
90 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
91 DGUEL_KP DGUEL_KP DATUM DATS 8   0   Condition Item Valid From  
92 NSTUFE NSTUFE NUMC2 NUMC 2   0   Level number of condition item for recurring payments  
93 DBPERIOD VVDBPERIOD DATUM DATS 8   0   Period start  
94 SPAEXCL TFMSPAEXCL TFMSPAEXCL NUMC 1   0   Exclusive Indicator for Start Date of a Period  
95 SPAULT TFMSPAULT VVSULT CHAR 1   0   Month-End Indicator for Start Date of a Period  
96 DEPERIOD VVDEPERIOD DATUM DATS 8   0   Period End  
97 SPEINCL TFMSPEINCL TFMSPEINCL NUMC 1   0   Inclusive Indicator for End Date of a Period  
98 SPEULT TFMSPEULT VVSULT CHAR 1   0   Month-End Indicator for End of a Period  
99 SSTCKKZ SSTCKKZ SSTCKKZ CHAR 1   0   Accrued interest method  
100 NORDER NORDER NUM8 NUMC 8   0   Order Number  
101 RKONT RKONT RKONT NUMC 6   0   Quota number  
102 DAUSZ VVDAUSZ DATUM DATS 8   0   Lead date for withholding amounts for disbursement  
103 SSOLIST SSOLIST CHAR1 CHAR 1   0   Calculation using actual principle (or debit)  
104 RDARNEHM RDARNEHM_NEW BU_PARTNER CHAR 10   0   Borrower/Applicant Number *
105 BKOND BKOND WERTV7 CURR 13   2   Condition item currency amount  
106 SBERECH SBERECH XFELD CHAR 1   0   Grace Period Interest Method  
107 BKARZINS TFMBKAZINS TFM_WRTV7 CURR 13   2   Int.for days betw. redemption clear.and pmnt (FiMa-internal)  
108 BTITALK TFMBTIKALK TFM_WRTV7 CURR 13   2   Imputed annuity repayment amount (FiMa internal)  
109 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
110 DERF DERF DATUM DATS 8   0   First Entered on  
111 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
112 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
113 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
114 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
115 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
116 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
117 HDN_KUNNR HDN_KUNNR KUNNR CHAR 10   0   Main Borrower Customer Number *
118 SZART TB_SZART XFELD CHAR 1   0   Payment transaction  
119 RUZBEL BELNR_D BELNR CHAR 10   0   Accounting Document Number  
120 REBZJ REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
121 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
122 REBZZ REBZZ BUZEI NUMC 3   0   Line Item in the Relevant Invoice  
123 S_SSDREF VVS_SSDREF SBEWZITI CHAR 4   0   Reference flow category in borrower's note loan flow records *
124 PWKURS PWKURS PWKURS DEC 10   7   Security price for percentage quotation  
125 DZFEST TB_DZFEST DATUM DATS 8   0   Interest rate fixing date  
126 XPORE PRQ_XPORE XFELD CHAR 1   0   Indicator: Individual Payment?  
127 SPAYRQ TB_SPAYRQK XFELD CHAR 1   0   Generate payment request  
128 PRKEY PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request *
129 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank T012
130 HKTID HKTID HKTID CHAR 5   0   ID for account details T012K
131 VORGTYP VORGTYP_LO VORGTYP_LO CHAR 4   0   Activity Category (Posting Area)  
132 ACENV ACENV_LO ACENV_LO NUMC 4   0   Source in TR-LO posting area  
133 SSIGN TB_SSIGN T_SSIGN CHAR 1   0   Direction of flow  
134 SPRSNG TB_SPRSNGK XFELD CHAR 1   0   Individual payment  
135 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
136 SPRGRD TB_SPRGRD T_SPRGRD CHAR 1   0   Determine grouping definition  
137 SCSPAY TB_SCSPAY XFELD CHAR 1   0   Same direction necessary for joint payment?  
138 ZWELS DZWELS ZWELS CHAR 10   0   List of the Payment Methods to be Considered  
139 PAYGR PAYGR CHAR20 CHAR 20   0   Grouping Field for Automatic Payments  
140 JEXPOZINS TB_JZINSRE XFELD CHAR 1   0   Exponential Interest Calculation  
141 SREVALEXCL VVSREVALEXCL XFELD CHAR 1   0   Price gains w/o proportionate gains from deferral write-back  
142 SROUND TFM_SROUND TFM_SROUND CHAR 1   0   Rounding Category  
143 SKALIDWT TFMSKALIDWT WFCID CHAR 2   0   Interest Calendar *
144 JVERF JVERF JVERF CHAR 1   0   Indicator whether drawings exist for the disbursement  
145 PPAYMENT TFM_PPAYMENT TFM_PPAYMENT DEC 11   7   Payment Rate  
146 AMMRHYZV TFM_AMMRHYZV TFM_AMMRHYZV NUMC 2   0   Interest Settlement Frequency for Exponential Interest Calc.  
147 LC_CAPITALS TB_LC_CAPITALS T_LC_CASH_FLOW CHAR 2   0   Effect of the Flow on Capital Amounts Status  
148 LC_DISBURSE TB_LC_DISBURSE T_LC_CASH_FLOW CHAR 2   0   Effect of the Flow on the Disbursement Status  
149 DFAELL_OLD_EXT TB_EXTENS_DFAELL_OLD DATUM DATS 8   0   Old Due Date  
150 DDISPO_OLD_EXT TB_EXTENS_DDISPO_OLD DATUM DATS 8   0   Old Payment Date  
151 RBO_EXT RBO RBO CHAR 15   0   Business Operation Number (Loans)  
152 SBEWEGRP2 TB_FLOW_REC_GRP SBEWEGRP2 NUMC 6   0   Flow Record Group in Cash Flow Calculator (Incoming Payment)  
153 SUSP_REASON_TYPE TB_SUSPREASON T_SUSPREASON NUMC 3   0   Key for Overpayment Reason *
154 BILL_NUMBER TB_BILL_NUMBER T_BILL_NUMBER CHAR 15   0   Bill Number  
155 BILL_DUE_DATE TB_BILL_DUE_DATE DATUM DATS 8   0   Due Date for Bill  
156 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
157 .INCLUDE       0   0   SEPA Remittance Information  
158 REMIT_INFO TB_REMIT_INFO T_REMIT_INFO CHAR 140   0   SEPA Payment Notes Information  
159 .INCLU--AP       0   0   Extension for Localization  
160 BROUNDUNIT TB_BROUNDUNIT_A TFMSRUNIT DEC 13   7   Rounding Unit for Amounts  
161 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 CVDBEPI BUKRS T001 BUKRS KEY 1 CN
2 CVDBEPI GSBER TGSB GSBER KEY 1 CN
3 CVDBEPI HBKID T012 HBKID    
4 CVDBEPI HKTID T012K HKTID    
5 CVDBEPI KUNNR KNA1 KUNNR KEY 1 CN
6 CVDBEPI MABER T047M MABER KEY 1 CN
7 CVDBEPI MANDT T000 MANDT KEY 1 CN
8 CVDBEPI MANSP T040S MANSP    
9 CVDBEPI RBANKK SKB1 SAKNR KEY 1 CN
10 CVDBEPI RBELKPFD VDBEKI RBELKPFD KEY 1 CN
11 CVDBEPI RHABEN SKA1 SAKNR KEY 1 1
12 CVDBEPI RPARTNR BUT000 PARTNER    
13 CVDBEPI RSOLL SKA1 SAKNR KEY 1 1
14 CVDBEPI RZKHABE SKA1 SAKNR KEY 1 1
15 CVDBEPI RZKSOLL SKA1 SAKNR KEY 1 1
16 CVDBEPI SBERFIMA AT40 SBERFIMA    
17 CVDBEPI SBSLSOLL TBSL BSCHL KEY 1 CN
18 CVDBEPI SBSLZKHA TBSL BSCHL KEY 1 CN
19 CVDBEPI SBSLZKSO TBSL BSCHL KEY 1 CN
20 CVDBEPI SBUST TZB09 SBUST KEY 1 CN
21 CVDBEPI SFDLEV T036 EBENE KEY 1 CN
22 CVDBEPI SHSLHABEN TBSL BSCHL KEY 1 CN
23 CVDBEPI SKOART TZK01 SKOART KEY 1 CN
24 CVDBEPI UZAWE T042F UZAWE    
25 CVDBEPI ZAHLS T008 ZAHLS KEY 1 CN
History
Last changed by/on SAP  20141121 
SAP Release Created in