This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table VWBEPP (Treasury Securities: Planned Flows) is a standard table in SAP ERP. It belongs to the package FVVW.
Table | VWBEPP |
Short Text | Treasury Securities: Planned Flows |
Package | FVVW |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
BUKRS | ✔ | Company Code | BUKRS | CHAR | 4 | T001 |
RANL | ✔ | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA |
RLDEPO | ✔ | Securities Account | VRLDEPO | CHAR | 10 | TWD01 |
DTRANS | ✔ | Flow data key: System date | VVDTRANS | DATS | 8 | |
TTRANS | ✔ | Transaction data key: system time | VVTTRANS | TIMS | 6 | |
NTRANS | ✔ | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | |
RERF | Entered by | RERF | CHAR | 12 | ||
DERF | First Entered on | DERF | DATS | 8 | ||
TERF | Time of Initial Entry | TERF | TIMS | 6 | ||
REHER | Source of initial entry | REHER | CHAR | 10 | ||
RBEAR | Employee ID | RBEAR | CHAR | 12 | ||
DBEAR | Last Edited on | DBEAR | DATS | 8 | ||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | ||
RBHER | Editing Source | RBHER | CHAR | 10 | ||
SSTATI | Status of data record | SSTATI | NUMC | 2 | * | |
INTEB | Financial Assets Management internal level | VVSINTEB | NUMC | 2 | * | |
SBEWART | Flow Type | SBEWART | CHAR | 4 | TZB0A | |
SBEWZITI | Flow category | SBEWZITI | CHAR | 4 | * | |
SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | ||
DVORGANG | Activity date | DVORGANG | DATS | 8 | ||
SVORGANG | Securities-Activity | RVORGANG | CHAR | 8 | ||
NVORGANG | Activity number | NVORGANG | CHAR | 3 | ||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | TCURC | |
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | TCURC | |
SCWHR | Settlement Currency | SCWHR | CUKY | 5 | TCURC | |
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15 | ||
BWKURS | Security price for unit quotation | BWKURS | CURR | 13 | ||
BNWHR | Nominal amount | BNWHR | CURR | 13 | ||
PWKURS | Security price for percentage quotation | PWKURS | DEC | 10 | ||
BBWHR | Amount in position currency | BBWHR | CURR | 13 | ||
BCWHR | Settlement Amount | BCWHR | CURR | 13 | ||
BHWHR | Amount in local currency | BHWHR | CURR | 13 | ||
KURS1 | Exchange rate into settlement currency | VVKURS1 | DEC | 9 | ||
KURS2 | Exchange rate from settlement currency into local currency | VVKURS2 | DEC | 9 | ||
DORDER | Order day | DORDER | DATS | 8 | ||
DVALUT | Interest Value Date/Calculation Date | VVDZINVAL | DATS | 8 | ||
DDISPO | Value date / planning day | VVDWERTST | DATS | 8 | ||
DBESTAND | Position value date | DBESTAND | DATS | 8 | ||
DBEST6B | Date for §6b EstG relevant postings | DBEST6B | DATS | 8 | ||
SSPESEN | Expenses key | SSPESEN | CHAR | 1 | ||
SLIMIT | Order notation | SLIMIT | CHAR | 1 | ||
BLIMIT | Limit price for unit quotation | BLIMIT | CURR | 13 | ||
PLIMIT | Limit price for percentage quotation | PLIMIT | DEC | 10 | ||
NORDER | Position number | SECPOSITIONNUMBER | NUMC | 8 | ||
RSOLL | Account for debit posting | RSOLL | CHAR | 10 | SKA1 | |
RZKSOLL | Debit interim account | RZKSOLL | CHAR | 10 | SKA1 | |
RZKHABE | Credit interim account | RZKHABE | CHAR | 10 | SKA1 | |
RHABEN | Account for credit posting | RHABEN | CHAR | 10 | SKA1 | |
SBSLSOLL | Posting Key | BSCHL | CHAR | 2 | TBSL | |
SBSLZKSO | Posting Key | BSCHL | CHAR | 2 | TBSL | |
SBSLZKHA | Posting Key | BSCHL | CHAR | 2 | TBSL | |
SBSLHABEN | Posting Key | BSCHL | CHAR | 2 | TBSL | |
SWHRT | Currency swap indicator | SWHRT | CHAR | 1 | ||
RBANKK | Bank account | RBANKK | CHAR | 10 | SKB1 | |
RKONTRA | Reference to Counterparty | RKONTRA_NEW | CHAR | 10 | * | |
SROLEXTKO | Dummy function | DUMMY_3 | CHAR | 3 | ||
SFDLEV | Planning level | FDLEV | CHAR | 2 | T036 | |
JFDUPD | Record transferred to cash management and forecast | JFDUPD | CHAR | 1 | ||
JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | ||
JZINSBAS | Flow in interest base | JZINSBAS | CHAR | 1 | ||
JZINSZPT | Interest date | JZINSZPT | CHAR | 1 | ||
PKOND | Percentage rate for condition items | PKOND | DEC | 10 | ||
SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 1 | ||
SSTCKTG | Accrued interest: Daily method | SSTCKTG | CHAR | 1 | ||
PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10 | ||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | ||
SCRWHR1 | Currency Key | WAERS | CUKY | 5 | TCURC | |
SCRWHR2 | Currency Key | WAERS | CUKY | 5 | TCURC | |
KCROSS | Exchange rate | KURSF | DEC | 9 | ||
NORDEXT | External order number | NORDEXT | CHAR | 20 | ||
SWOHER | Treasury: Source of flow | TB_SWOHER | CHAR | 1 | ||
XZUSATZ | Assignment | XZUSATZ | CHAR | 18 | ||
JONLBUC | Online posting flag indicator | JONLBUC | CHAR | 1 | ||
DANST | Reservation date | DANST | DATS | 8 | ||
TANST | Order time of day | TANST | TIMS | 6 | ||
SANST | Reservation reason | SANST | CHAR | 2 | TW14 | |
SABRECH | Single-Character Indicator | CHAR1 | CHAR | 1 | ||
SVERFALL | Single-Character Indicator | CHAR1 | CHAR | 1 | ||
RDEALER | Trader | RDEALER | CHAR | 12 | TZDEA | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | |
BBASIS | Calculation base amount | BBASIS | CURR | 13 | ||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | ||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | ||
ATAGE | Number of days | VVATAGE | NUMC | 6 | ||
ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | ||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | ||
SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | * | |
JEXPOZINS | Exponential Interest Calculation | TB_JZINSRE | CHAR | 1 | ||
SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | ||
RZBANK | Paying Bank | VVRZBANK_NEW | CHAR | 10 | BUT000 | |
SROLEXTZB | Dummy function | DUMMY_3 | CHAR | 3 | ||
JVERK6B | Sale in acc. with tax credit method | VVJVERK6B | CHAR | 1 | ||
SZEGEN | Generate incoming payment immediately | SZEGEN | NUMC | 2 | * | |
SBUST | Posting control key | VVSBUST | NUMC | 2 | TZB09 | |
SCOUPON | Coupon ID for interest and accrued interest calculation | VVSCOUPON | CHAR | 1 | ||
DCOUPON | Coupon date of next delivered coupon | VVDCOUPON | DATS | 8 | ||
SFLAT | Indicator 'Traded flat',i.e.no accrued interest calculation | VVSFLAT | CHAR | 1 | ||
DFAELL | Due date | DFAELL | DATS | 8 | ||
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | TWH01 | |
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | TZK01 | |
SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | ||
SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | ||
SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | ||
SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | ||
DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | ||
DPKOND | Determination date for percentage rate of condition items | VVDPKOND | DATS | 8 | ||
SREFZITI | Refer.flow category in accrual/deferral flow records | VVSREFZITI | CHAR | 4 | * | |
SFIXRATE2 | Fixed exchange rate | VVSFIXRATE | CHAR | 1 | ||
SFIXRATE1 | Fixed exchange rate | VVSFIXRATE | CHAR | 1 | ||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | ||
SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | ||
RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | T037S | |
APERTAGE | No. of days of a (calculation) period in cash flow | VVAPERTAGE | NUMC | 6 | ||
STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | ||
STGBASIS | Base Days Method | VVSTGBASIS | NUMC | 1 | ||
DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | ||
SPAEXCL | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | NUMC | 1 | ||
SPAULT | Month-End Indicator for Start Date of a Period | TFMSPAULT | CHAR | 1 | ||
DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | ||
SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | ||
SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | ||
SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | ||
SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | ||
DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | ||
NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | ||
RPNNR | Daybook no. | VVRPNNR | CHAR | 10 | ||
SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | CHAR | 4 | * | |
SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 2 | ||
SREFBEW | Reference flow type | SREFBEW | CHAR | 4 | * | |
SSWHR | Stock price currency | VVSSWHR | CUKY | 5 | * | |
BSWHR | Market value | VVBSWHR | CURR | 13 | ||
SRUNIT | Currency unit | VVSRUNIT | CHAR | 5 | TZUNI | |
KWKURS | Security price | VVKWKURS | DEC | 15 | ||
DSCHLUSS | Date of business closing | VVDSCHLUSS | DATS | 8 | ||
TSCHLUSS | Time of business closing | VVTSCHLUSS | TIMS | 6 | ||
SHERKUNFT | Origin indicator: 'From planned record/actual record' | VVSHERK | CHAR | 1 | ||
SFGKZ | Release Indicator | VVSFGKZ | CHAR | 1 | ||
SBUCHA | Indicator for postings to accruals/deferrals accounts | VVSBUCHA | CHAR | 1 | ||
RAHABKI | Short key for own house bank | TB_RHABKI | CHAR | 5 | T012 | |
RAHKTID | Short key for house bank account | TB_RHKTID | CHAR | 5 | T012K | |
RPBANK | Partner bank details | TB_RPBANK | CHAR | 4 | ||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | |
SZART | Payment transaction | TB_SZART | CHAR | 1 | ||
PEFFZCALL | Effective Interest Rate | PEFFZINS | DEC | 10 | ||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | |
REFRLDEPO | Reference sec.acct for sec.acct transfer (inflow/outflow) | VVREFRLDEP | CHAR | 10 | * | |
KGV_FLAG | Manages status of the related price gains/losses flows | TKGV | CHAR | 1 | ||
DZFEST | Interest rate fixing date | TB_DZFEST | DATS | 8 | ||
KMNR | Corporate Action Number | KMNR | CHAR | 13 | * | |
ERNR | ID number of exercised right | TER_HEADNUMBER | CHAR | 13 | ||
DEVALPOST | Date of period-end closing | DEVALPOST | DATS | 8 | ||
ZUOND | Assignment | TB_ZUOND | CHAR | 18 | ||
REFER | Internal Reference | TB_REFER | CHAR | 16 | ||
MERKM | Characteristics | TB_MERKM | CHAR | 25 | ||
SPAYRQ | Generate payment request | TB_SPAYRQK | CHAR | 1 | ||
SPRSNG | Individual payment | TB_SPRSNGK | CHAR | 1 | ||
RPZAHL | Payer/payee | TB_RPZAHL_NEW | CHAR | 10 | * | |
RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | * | |
INDEX_VALUE | Index Value (Independent of Basis) | TIDX_INDEX_VALUE_NO_RATIO | DEC | 18 | ||
PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11 | ||
BBWHR_IDX_CLEAN | Amount in position currency | BBWHR | CURR | 13 | ||
BUSTRANSID | Identifier of the Distributor Business Transaction | TPM_BUSTRANSID | RAW | 16 | ||
BUSTRANSCAT | Business Transaction Category | TPM_BUSTRANSCAT | NUMC | 4 | TRDTS_BT_CAT | |
DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | ||
DGJAHR | Fiscal Year | GJAHR | NUMC | 4 | ||
RBELNRFI | Accounting Document Number | BELNR_D | CHAR | 10 | ||
RBELNRFI2 | Accounting Document Number | BELNR_D | CHAR | 10 | ||
LOT_ID | Identifier of the Lot | TPM_LOT_ID | RAW | 16 | ||
MIGR_CFM10 | Status of Flow Related to Migration to CFM 1.0 | TPM_MIGR_CFM10 | CHAR | 1 | ||
MIGR_ERP20 | Status of Flow Related to Migration to ERP2.0 | TPM_MIGR_ERP20 | CHAR | 1 |