SAP ABAP Table VDBEPI_ADD (Extended VDBEPI for Display in Account Statement)
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 VDBEPI_ADD   Table Relationship Diagram
Short Description Extended VDBEPI for Display in Account Statement    
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 SANLF SANLF VVSANLF NUMC 3   0   Product Category *
162 RANL RANL RANL CHAR 13   0   Contract Number  
163 DGUEL_KK DGUEL DATUM DATS 8   0   Date Condition Effective from  
164 NLFD_ANG NLFD_ANG LFNR3 NUMC 3   0   Offer consecutive number  
165 RKLAMMER RKLAMMER RANL CHAR 13   0   Classification Number for Finance Projects  
166 DVORGANG DVORGANG DATUM DATS 8   0   Activity date  
167 SVORGANG SVORFALL SVORFALL CHAR 4   0   Business Operation (Activity)  
168 NVORGANG NVORGANG CHAR3 CHAR 3   0   Activity number  
169 SSTATI SSTATI STATI NUMC 2   0   Status of data record *
170 RREFKONT RREFKONT USTRU CHAR 8   0   Account Assignment Reference in Financial Assets Management *
171 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
172 SBLART BLART BLART CHAR 2   0   Document type *
173 DBLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
174 DBUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
175 DGJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
176 DMONAT MONAT MONAT NUMC 2   0   Fiscal period  
177 SSTORNO SSTORNO SSTORNO CHAR 1   0   Reversal indicator  
178 SSTOGRD SSTOGRD SSTOGRD CHAR 2   0   Reason for Reversal *
179 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
180 RSTBLG TB_REVERSAL_OF RBELKPFD CHAR 10   0   Document Number of Reversed Document  
181 RZEBEL RZEBEL RBELKPFD CHAR 10   0   Doc.no. of debit pos. doc.header (only for inc.pmnt records)  
182 DORDER DORDER DATUM DATS 8   0   Order day  
183 DANJRNL DANJRNL DATUM DATS 8   0   Date of transferal to journal  
184 DANFIBU DANFIBU DATUM DATS 8   0   Date of transferal to FiAc  
185 UANFIBU UANFIBU TIMES TIMS 6   0   Time of transfer to financial accounting  
186 SSTCKTG SSTCKTG SZBMETH CHAR 1   0   Accrued interest: Daily method  
187 PEFFZINS PEFFZINS DEC3_7 DEC 10   7   Effective Interest Rate  
188 SEFFMETH SEFFMETH SEFFMETH NUMC 1   0   Effective Interest Method (Financial Mathematics)  
189 DSTOCK VVDSTOCK DATUM DATS 8   0   Premium reserve fund date  
190 RPNNR VVRPNNR VVRPNNR CHAR 10   0   Daybook no.  
191 RVZBLG BELNR_D BELNR CHAR 10   0   Accounting Document Number  
192 RPNSUP VVRPNSUP VVRPNNR CHAR 10   0   Super prima nota for grouping in autom.deb.pos.  
193 RUMBLG UMBLG BELNR CHAR 10   0   Reference transfer document number  
194 RUZBELKPF BELNR_D BELNR CHAR 10   0   Accounting Document Number  
195 SEVALPOST SEVALPOST XFELD CHAR 1   0   PEC for flow executed indicator yes/no  
196 SBEWAGRP SBAGRP SBEWAGRP CHAR 2   0   Flow type group *
197 SFIBU VVSFIBU VVSFIBU CHAR 2   0   Control entry of overpayment and advance payment data  
198 XBEWART XBEWART TEXT30 CHAR 30   0   Name of flow type  
199 SBTRS SBCWHR WERT7 CURR 13   2   Debit amount in display currency  
200 SBTRH HBCWHR WERT7 CURR 13   2   Credit amount in display currency  
201 SBTRSUM SUMBCWHR WERT7 CURR 13   2   Amount in Display Currency  
202 SBTRWHR SSCWHR WAERS CUKY 5   0   Display currency *
203 SHWHR SHWHR WAERS CUKY 5   0   Local currency *
204 GPRESTOP T_BP_RESTOP BU_PARTNER CHAR 10   0   Business Partner Assigned to Open Items in General Ledger *
205 ICON_SREORG ICON_SREORG ICON CHAR 4   0   Indicator For Reorganization Record (Doc. Data Archiving) *
206 COLOR COLOUR_CODE COLOUR_CODE CHAR 3   0   Field For Color  
207 XMARK XMARK XFELD CHAR 1   0   Indicator: Line selected  
208 CHANGED TB_ROW_CHANGED T_ROW_CHANGED CHAR 1   0   Line Was Changed  
209 SIOA_LOCK_CHKBX TB_FLG_IOA_LOCK XFELD CHAR 1   0   Locked for Interest on Arrears  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VDBEPI_ADD BUKRS T001 BUKRS KEY 1 CN
2 VDBEPI_ADD GSBER TGSB GSBER KEY 1 CN
3 VDBEPI_ADD HBKID T012 HBKID    
4 VDBEPI_ADD HKTID T012K HKTID    
5 VDBEPI_ADD KUNNR KNA1 KUNNR KEY 1 CN
6 VDBEPI_ADD MABER T047M MABER KEY 1 CN
7 VDBEPI_ADD MANDT T000 MANDT KEY 1 CN
8 VDBEPI_ADD MANSP T040S MANSP    
9 VDBEPI_ADD RBANKK SKB1 SAKNR KEY 1 CN
10 VDBEPI_ADD RBELKPFD VDBEKI RBELKPFD KEY 1 CN
11 VDBEPI_ADD RHABEN SKA1 SAKNR KEY 1 1
12 VDBEPI_ADD RPARTNR BUT000 PARTNER    
13 VDBEPI_ADD RSOLL SKA1 SAKNR KEY 1 1
14 VDBEPI_ADD RZKHABE SKA1 SAKNR KEY 1 1
15 VDBEPI_ADD RZKSOLL SKA1 SAKNR KEY 1 1
16 VDBEPI_ADD SBERFIMA AT40 SBERFIMA    
17 VDBEPI_ADD SBSLSOLL TBSL BSCHL KEY 1 CN
18 VDBEPI_ADD SBSLZKHA TBSL BSCHL KEY 1 CN
19 VDBEPI_ADD SBSLZKSO TBSL BSCHL KEY 1 CN
20 VDBEPI_ADD SBUST TZB09 SBUST KEY 1 CN
21 VDBEPI_ADD SFDLEV T036 EBENE KEY 1 CN
22 VDBEPI_ADD SHSLHABEN TBSL BSCHL KEY 1 CN
23 VDBEPI_ADD SKOART TZK01 SKOART KEY 1 CN
24 VDBEPI_ADD UZAWE T042F UZAWE    
25 VDBEPI_ADD ZAHLS T008 ZAHLS KEY 1 CN
History
Last changed by/on SAP  20141121 
SAP Release Created in