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