VWBEPI SAP (Treasury Securities: Actual Flows - Item) Table details
Dictionary Type: Table
Description: Treasury Securities: Actual Flows - Item
Description: Treasury Securities: Actual Flows - Item
Table field list including key, data, relationships and ABAP select examples
VWBEPI is a standard SAP Table which is used to store Treasury Securities: Actual Flows - Item data and is available within R/3 SAP systems depending on the version and release level.
The VWBEPI table consists of various fields, each holding specific information or linking keys about Treasury Securities: Actual Flows - Item data available in SAP. These include BUKRS (Company Code), RBELNR (Number of flow header), RPOSNR (Activity number), RERF (Entered by).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VWBEPI table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RBELNR | Number of flow header | RBELKPF | CHAR | 10 | VWBEKI | ALPHA | RBELKPF | ||
RPOSNR | Activity number | NVORGANG | CHAR | 3 | CHAR3 | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SBEWART | Flow Type | SBEWART | CHAR | 4 | TZB0A | SBEWART | |||
SBEWZITI | Flow category | SBEWZITI | CHAR | 4 | TZB03 | SBEWZITI | |||
SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | VVSSOLHAB | ||||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | TCURC | WAERS | |||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | TCURC | WAERS | |||
SCWHR | Settlement Currency | SCWHR | CUKY | 5 | TCURC | WAERS | |||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
BWKURS | Security price for unit quotation | BWKURS | CURR | 13(2) | BWKURS | ||||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
PWKURS | Security price for percentage quotation | PWKURS | DEC | 10(7) | PWKURS | ||||
BBWHR | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
BCWHR | Settlement Amount | BCWHR | CURR | 13(2) | WERTV7 | ||||
BHWHR | Amount in local currency | BHWHR | CURR | 13(2) | WERTV7 | ||||
KURS1 | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
KURS2 | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
DVALUT | Interest Value Date/Calculation Date | VVDZINVAL | DATS | 8 | DATUM | ||||
DDISPO | Value date / planning day | VVDWERTST | DATS | 8 | DATUM | ||||
DBESTAND | Position value date | DBESTAND | DATS | 8 | DATUM | ||||
DBEST6B | Date for ยง6b EstG relevant postings | DBEST6B | DATS | 8 | DATUM | ||||
RSOLL | Account for debit posting | RSOLL | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
SBSLSOLL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
RZKSOLL | Debit interim account | RZKSOLL | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
SBSLZKSO | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
RZKHABE | Credit interim account | RZKHABE | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
SBSLZKHA | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
RHABEN | Account for credit posting | RHABEN | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
SBSLHABEN | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
SWHRT | Currency swap indicator | SWHRT | CHAR | 1 | SWHRT | ||||
JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | VVSONLAEN | ||||
JZINSBAS | Flow in interest base | JZINSBAS | CHAR | 1 | JANEI | ||||
JZINSZPT | Interest date | JZINSZPT | CHAR | 1 | JANEI | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
BBASIS | Calculation base amount | BBASIS | CURR | 13(2) | WERTV7 | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
ATAGE | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | INT6 | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
JEXPOZINS | Exponential Interest Calculation | TB_JZINSRE | CHAR | 1 | XFELD | ||||
SWOHER | Treasury: Source of flow | TB_SWOHER | CHAR | 1 | TB_SWOHER | ||||
JSTOCK | Premium reserve fund-relevant indicator | VVJSTOCK | CHAR | 1 | JANEI | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | TZK01 | SKOART | |||
SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | VVSEXCLVON | ||||
SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | VVSULT | ||||
SINCLVON | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | VVSINCLBIS | ||||
SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | VVSULT | ||||
DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | DATUM | ||||
DPKOND | Determination date for percentage rate of condition items | VVDPKOND | DATS | 8 | DATUM | ||||
SREFZITI | Refer.flow category in accrual/deferral flow records | VVSREFZITI | CHAR | 4 | Assigned to domain | SBEWZITI | |||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | VVSULT | ||||
APERTAGE | No. of days of a (calculation) period in cash flow | VVAPERTAGE | NUMC | 6 | INT6 | ||||
STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | VVSTGMETH | ||||
STGBASIS | Base Days Method | VVSTGBASIS | NUMC | 1 | VVSTGBASIS | ||||
DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | DATUM | ||||
SPAEXCL | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | NUMC | 1 | TFMSPAEXCL | ||||
SPAULT | Month-End Indicator for Start Date of a Period | TFMSPAULT | CHAR | 1 | VVSULT | ||||
DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | DATUM | ||||
SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | TFMSPEINCL | ||||
SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | VVSULT | ||||
SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | VVSINCLVER | ||||
SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | VVSULT | ||||
DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM | ||||
NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | NUMC2 | ||||
DCOUPON | Coupon date of next delivered coupon | VVDCOUPON | DATS | 8 | DATUM | ||||
SCOUPON | Coupon ID for interest and accrued interest calculation | VVSCOUPON | CHAR | 1 | VVSCOUPON | ||||
SFLAT | Indicator 'Traded flat',i.e.no accrued interest calculation | VVSFLAT | CHAR | 1 | XFELD | ||||
SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | CHAR | 4 | AT40 | SBEWFIMA | |||
SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 2 | VVSVORGKZ | ||||
SREFBEW | Reference flow type | SREFBEW | CHAR | 4 | Assigned to domain | SBEWART | |||
SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | VVSINCLBIS | ||||
SSWHR | Stock price currency | VVSSWHR | CUKY | 5 | TCURC | WAERS | |||
BSWHR | Market value | VVBSWHR | CURR | 13(2) | WERTV7 | ||||
SRUNIT | Currency unit | VVSRUNIT | CHAR | 5 | TZUNI | VVSRUNIT | |||
KWKURS | Security price | VVKWKURS | DEC | 15(6) | VVKWKURS | ||||
DSCHLUSS | Date of business closing | VVDSCHLUSS | DATS | 8 | DATUM | ||||
TSCHLUSS | Time of business closing | VVTSCHLUSS | TIMS | 6 | UZEIT | ||||
SBUCHA | Indicator for postings to accruals/deferrals accounts | VVSBUCHA | CHAR | 1 | CHAR1 | ||||
RAHABKI | Short key for own house bank | TB_RHABKI | CHAR | 5 | Assigned to domain | HBKID | |||
RAHKTID | Short key for house bank account | TB_RHKTID | CHAR | 5 | Assigned to domain | HKTID | |||
RPBANK | Partner bank details | TB_RPBANK | CHAR | 4 | BVTYP | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
KGV_FLAG | Manages status of the related price gains/losses flows | TKGV | CHAR | 1 | TKGV | ||||
DZFEST | Interest rate fixing date | TB_DZFEST | DATS | 8 | DATUM | ||||
KMNR | Corporate Action Number | KMNR | CHAR | 13 | Assigned to domain | ALPHA | VKMNR | KMA | |
ERNR | ID number of exercised right | TER_HEADNUMBER | CHAR | 13 | ALPHA | TER_RIGHTNUMBER | |||
SPAYRQ | Generate payment request | TB_SPAYRQK | CHAR | 1 | XFELD | ||||
SPRSNG | Individual payment | TB_SPRSNGK | CHAR | 1 | XFELD | ||||
PRKEY | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | Assigned to domain | ALPHA | PRQ_KEYNO | ||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
INDEX_VALUE | Index Value (Independent of Basis) | TIDX_INDEX_VALUE_NO_RATIO | DEC | 18(12) | TIDX_INDEX_VALUE_NO_RATIO | ||||
PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11(7) | TFM_PPAYMENT | ||||
BBWHR_IDX_CLEAN | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
BUSTRANSID | Identifier of the Distributor Business Transaction | TPM_BUSTRANSID | RAW | 16 | SYSUUID | ||||
BUSTRANSCAT | Business Transaction Category | TPM_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | TPM_BUSTRANSCAT | |||
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | SYSUUID | ||||
MIGR_CFM10 | Status of Flow Related to Migration to CFM 1.0 | TPM_MIGR_CFM10 | CHAR | 1 | TPM_MIGR_CFM10 | ||||
MIGR_ERP20 | Status of Flow Related to Migration to ERP2.0 | TPM_MIGR_ERP20 | CHAR | 1 | TPM_MIGR_ERP20 |
Key field | Non-key field |
How do I retrieve data from SAP table VWBEPI using ABAP code
The following ABAP code Example will allow you to do a basic selection on VWBEPI to SELECT all data from the tableDATA: WA_VWBEPI TYPE VWBEPI.
SELECT SINGLE *
FROM VWBEPI
INTO CORRESPONDING FIELDS OF WA_VWBEPI
WHERE...
How to access SAP table VWBEPI
Within an ECC or HANA version of SAP you can also view further information about VWBEPI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects