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
⤷ 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
History
Last changed by/on | SAP | 20141121 |
SAP Release Created in |