SAP Table VWBEPP - Treasury Securities: Planned Flows

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
RANL X VVRANLW CHAR 7 13 0 Security ID Number
RLDEPO X VRLDEPO CHAR 20 10 0 Securities Account
DTRANS X VVDTRANS DATS 30 8 0 Flow data key: System date
TTRANS X VVTTRANS TIMS 38 6 0 Transaction data key: system time
NTRANS X VVNTRANS NUMC 44 4 0 Transaction data key: Consecutive number
RERF RERF CHAR 48 12 0 Entered by
DERF DERF DATS 60 8 0 First Entered on
TERF TERF TIMS 68 6 0 Time of Initial Entry
REHER REHER CHAR 74 10 0 Source of initial entry
RBEAR RBEAR CHAR 84 12 0 Employee ID
DBEAR DBEAR DATS 96 8 0 Last Edited on
TBEAR TBEAR TIMS 104 6 0 Last Edited at
RBHER RBHER CHAR 110 10 0 Editing Source
SSTATI SSTATI NUMC 120 2 0 TZC37 Status of data record
INTEB VVSINTEB NUMC 122 2 0 TDINTEB Financial Assets Management internal level
SBEWART SBEWART CHAR 124 4 0 TZB0A Flow Type
SBEWZITI SBEWZITI CHAR 128 4 0 TZB03 Flow category
SSOLHAB VVSSOLHAB CHAR 132 1 0 Debit/credit indicator
DVORGANG DVORGANG DATS 133 8 0 Activity date
SVORGANG RVORGANG CHAR 141 8 0 Securities-Activity
NVORGANG NVORGANG CHAR 149 3 0 Activity number
SNWHR SNWHR CUKY 152 5 0 TCURC Currency of nominal amount
SBWHR SBWHR CUKY 157 5 0 TCURC Position Currency (Currency of Position Amount)
SCWHR SCWHR CUKY 162 5 0 TCURC Settlement Currency
ASTUECK ASTUECK DEC 167 15 5 Number of units for unit-quoted securities
BWKURS BWKURS CURR 175 13 2 Security price for unit quotation
BNWHR BNWHR CURR 182 13 2 Nominal amount
PWKURS PWKURS DEC 189 10 7 Security price for percentage quotation
BBWHR BBWHR CURR 195 13 2 Amount in position currency
BCWHR BCWHR CURR 202 13 2 Settlement Amount
BHWHR BHWHR CURR 209 13 2 Amount in local currency
KURS1 VVKURS1 DEC 216 9 5 Exchange rate into settlement currency
KURS2 VVKURS2 DEC 221 9 5 Exchange rate from settlement currency into local currency
DORDER DORDER DATS 226 8 0 Order day
DVALUT VVDZINVAL DATS 234 8 0 Interest Value Date/Calculation Date
DDISPO VVDWERTST DATS 242 8 0 Value date / planning day
DBESTAND DBESTAND DATS 250 8 0 Position value date
DBEST6B DBEST6B DATS 258 8 0 Date for §6b EstG relevant postings
SSPESEN SSPESEN CHAR 266 1 0 Expenses key
SLIMIT SLIMIT CHAR 267 1 0 Order notation
BLIMIT BLIMIT CURR 268 13 2 Limit price for unit quotation
PLIMIT PLIMIT DEC 275 10 7 Limit price for percentage quotation
NORDER SECPOSITIONNUMBER NUMC 281 8 0 Position number
RSOLL RSOLL CHAR 289 10 0 Account for debit posting
RZKSOLL RZKSOLL CHAR 299 10 0 Debit interim account
RZKHABE RZKHABE CHAR 309 10 0 Credit interim account
RHABEN RHABEN CHAR 319 10 0 Account for credit posting
SBSLSOLL BSCHL CHAR 329 2 0 TBSL Posting Key
SBSLZKSO BSCHL CHAR 331 2 0 TBSL Posting Key
SBSLZKHA BSCHL CHAR 333 2 0 TBSL Posting Key
SBSLHABEN BSCHL CHAR 335 2 0 TBSL Posting Key
SWHRT SWHRT CHAR 337 1 0 Currency swap indicator
RBANKK RBANKK CHAR 338 10 0 Bank account
RKONTRA RKONTRA_NEW CHAR 348 10 0 Reference to Counterparty
SROLEXTKO DUMMY_3 CHAR 358 3 0 Dummy function
SFDLEV FDLEV CHAR 361 2 0 T036 Planning Level
JFDUPD JFDUPD CHAR 363 1 0 Record transferred to cash management and forecast
JONLAEN JONLAEN CHAR 364 1 0 Indicator for fixing a flow record
JZINSBAS JZINSBAS CHAR 365 1 0 Flow in interest base
JZINSZPT JZINSZPT CHAR 366 1 0 Interest date
PKOND PKOND DEC 367 10 7 Percentage rate for condition items
SSTCKKZ SSTCKKZ CHAR 373 1 0 Accrued interest method
SSTCKTG SSTCKTG CHAR 374 1 0 Accrued interest: Daily method
PEFFZINS PEFFZINS DEC 375 10 7 Effective Interest Rate
SEFFMETH SEFFMETH NUMC 381 1 0 Effective Interest Method (Financial Mathematics)
SCRWHR1 WAERS CUKY 382 5 0 TCURC Currency Key
SCRWHR2 WAERS CUKY 387 5 0 TCURC Currency Key
KCROSS KURSF DEC 392 9 5 Exchange rate
NORDEXT NORDEXT CHAR 397 20 0 External order number
SWOHER TB_SWOHER CHAR 417 1 0 Treasury: Source of flow
XZUSATZ XZUSATZ CHAR 418 18 0 Assignment
JONLBUC JONLBUC CHAR 436 1 0 Online posting flag indicator
DANST DANST DATS 437 8 0 Reservation date
TANST TANST TIMS 445 6 0 Order time of day
SANST SANST CHAR 451 2 0 Reservation reason
SABRECH CHAR1 CHAR 453 1 0 Single-Character Indicator
SVERFALL CHAR1 CHAR 454 1 0 Single-Character Indicator
RDEALER RDEALER CHAR 455 12 0 TZDEA Trader
KOSTL KOSTL CHAR 467 10 0 Cost Center
GSBER GSBER CHAR 477 4 0 TGSB Business Area
BBASIS BBASIS CURR 481 13 2 Calculation base amount
DBERVON DBERVON DATS 488 8 0 Start of Calculation Period
DBERBIS DBERBIS DATS 496 8 0 End of Calculation Period
ATAGE VVATAGE NUMC 504 6 0 Number of days
ABASTAGE ABASTAGE NUMC 510 6 0 Number of base days in a calculation period
SZBMETH SZBMETH CHAR 516 1 0 Interest Calculation Method
SKALIDWT TFMSKALIDWT CHAR 517 2 0 TFACD Interest Calendar
JEXPOZINS TB_JZINSRE CHAR 519 1 0 Exponential Interest Calculation
SOBJEKT VVKEYOBJ CHAR 520 10 0 Internal key for object
RZBANK VVRZBANK_NEW CHAR 530 10 0 Paying Bank
SROLEXTZB DUMMY_3 CHAR 540 3 0 Dummy function
JVERK6B VVJVERK6B CHAR 543 1 0 Sale in acc. with tax credit method
SZEGEN SZEGEN NUMC 544 2 0 TD21 Generate incoming payment immediately
SBUST VVSBUST NUMC 546 2 0 TZB09 Posting control key
SCOUPON VVSCOUPON CHAR 548 1 0 Coupon ID for interest and accrued interest calculation
DCOUPON VVDCOUPON DATS 549 8 0 Coupon date of next delivered coupon
SFLAT VVSFLAT CHAR 557 1 0 Indicator 'Traded flat',i.e.no accrued interest calculation
DFAELL DFAELL DATS 558 8 0 Due date
RHANDPL VVRHANDPL CHAR 566 10 0 Exchange
SKOART SKOART NUMC 576 4 0 TZK01 Condition Type (Smallest Subdivision of Condition Records)
SEXCLVON VVSEXCLVON NUMC 580 1 0 Exclusive Indicator for the Start of a Calculation Period
SULTVON VVSULTVON CHAR 581 1 0 Month-End Indicator for Start of a Calculation Period
SINCLBIS VVSINCLBIS NUMC 582 1 0 Inclusive Indicator for the End of a Calculation Period
SULTBIS VVSULTBIS CHAR 583 1 0 Month-End Indicator for the End of a Calculation Period
DVERRECH VVDVERRECH DATS 584 8 0 Settlement date
DPKOND VVDPKOND DATS 592 8 0 Determination date for percentage rate of condition items
SREFZITI VVSREFZITI CHAR 600 4 0 TZB03 Refer.flow category in accrual/deferral flow records
SFIXRATE2 VVSFIXRATE CHAR 604 1 0 Fixed exchange rate
SFIXRATE1 VVSFIXRATE CHAR 605 1 0 Fixed exchange rate
SINCL VVSINCL NUMC 606 1 0 Inclusive indicator for beginning and end of a period
SVULT VVSVULT CHAR 607 1 0 Month-End Indicator for Value Date
RREFKONT RREFKONT CHAR 608 8 0 T037S Account Assignment Reference in Financial Assets Management
APERTAGE VVAPERTAGE NUMC 616 6 0 No. of days of a (calculation) period in cash flow
STGMETH VVSTGMETH NUMC 622 1 0 Daily Method
STGBASIS VVSTGBASIS NUMC 623 1 0 Base Days Method
DBPERIOD VVDBPERIOD DATS 624 8 0 Period start
SPAEXCL TFMSPAEXCL NUMC 632 1 0 Exclusive Indicator for Start Date of a Period
SPAULT TFMSPAULT CHAR 633 1 0 Month-End Indicator for Start Date of a Period
DEPERIOD VVDEPERIOD DATS 634 8 0 Period End
SPEINCL TFMSPEINCL NUMC 642 1 0 Inclusive Indicator for End Date of a Period
SPEULT TFMSPEULT CHAR 643 1 0 Month-End Indicator for End of a Period
SINCLVERR VVSINCLVER NUMC 644 1 0 Inclusive Indicator for Clearing Date
SULTVERR VVSULTVERR CHAR 645 1 0 Month-End Indicator for Clearing Date
DGUEL_KP DGUEL_KP DATS 646 8 0 Condition Item Effecitve from
NSTUFE NSTUFE NUMC 654 2 0 Level number of condition item for recurring payments
RPNNR VVRPNNR CHAR 656 10 0 Daybook no.
SBERFIMA SBEWFIMA CHAR 666 4 0 Calculation Category for Cash Flow Calculator
SVORGKZ VVSVORGKZ NUMC 670 2 0 Activity indicator for debit/credit control
SREFBEW SREFBEW CHAR 672 4 0 TZB0A Reference flow type
SSWHR VVSSWHR CUKY 676 5 0 TCURC Stock price currency
BSWHR VVBSWHR CURR 681 13 2 Market value
SRUNIT VVSRUNIT CHAR 688 5 0 Currency unit
KWKURS VVKWKURS DEC 693 15 6 Security price
DSCHLUSS VVDSCHLUSS DATS 701 8 0 Date of business closing
TSCHLUSS VVTSCHLUSS TIMS 709 6 0 Time of business closing
SHERKUNFT VVSHERK CHAR 715 1 0 Origin indicator: 'From planned record/actual record'
SFGKZ VVSFGKZ CHAR 716 1 0 Release Indicator
SBUCHA VVSBUCHA CHAR 717 1 0 Indicator for postings to accruals/deferrals accounts
RAHABKI TB_RHABKI CHAR 718 5 0 T012 Short key for own house bank
RAHKTID TB_RHKTID CHAR 723 5 0 T012K Short key for house bank account
RPBANK TB_RPBANK CHAR 728 4 0 Partner bank details
ZLSCH DZLSCH CHAR 732 1 0 T042E Payment Method
SZART TB_SZART CHAR 733 1 0 Payment transaction
PEFFZCALL PEFFZINS DEC 734 10 7 Effective Interest Rate
OBJNR J_OBJNR CHAR 740 22 0 ONR00 Object number
REFRLDEPO VVREFRLDEP CHAR 762 10 0 Reference sec.acct for sec.acct transfer (inflow/outflow)
KGV_FLAG TKGV CHAR 772 1 0 Manages status of the related price gains/losses flows
DZFEST TB_DZFEST DATS 773 8 0 Interest rate fixing date
KUNNR KUNNR CHAR 781 10 0 KNA1 Customer Number
KMNR KMNR CHAR 791 13 0 Corporate Action Number
ERNR TER_HEADNUMBER CHAR 804 13 0 ID number of exercised right
DEVALPOST DEVALPOST DATS 817 8 0 Date of period-end closing
ZUOND TB_ZUOND CHAR 825 18 0 Assignment
REFER TB_REFER CHAR 843 16 0 Internal Reference
MERKM TB_MERKM CHAR 859 25 0 Characteristics
SPAYRQ TB_SPAYRQK CHAR 884 1 0 Generate payment request
SPRSNG TB_SPRSNGK CHAR 885 1 0 Individual payment
RPZAHL TB_RPZAHL_NEW CHAR 886 10 0 Payer/payee
RFHA TB_RFHA CHAR 896 13 0 Financial Transaction
INDEX_VALUE TIDX_INDEX_VALUE_NO_RATIO DEC 909 18 12 Index Value (Independent of Basis)
PPAYMENT TFM_PPAYMENT DEC 919 11 7 Payment Rate
BBWHR_IDX_CLEAN BBWHR CURR 925 13 2 Amount in position currency
BUSTRANSID TPM_BUSTRANSID RAW 932 16 0 Identifier of the Distributor Business Transaction
BUSTRANSCAT TPM_BUSTRANSCAT NUMC 948 4 0 Business Transaction Category
DBUDAT BUDAT DATS 952 8 0 Posting Date in the Document
DGJAHR GJAHR NUMC 960 4 0 Fiscal Year
RBELNRFI BELNR_D CHAR 964 10 0 Accounting Document Number
RBELNRFI2 BELNR_D CHAR 974 10 0 Accounting Document Number
LOT_ID TPM_LOT_ID RAW 984 16 0 Identifier of the Lot
MIGR_CFM10 TPM_MIGR_CFM10 CHAR 1000 1 0 Status of Flow Related to Migration to CFM 1.0
MIGR_ERP20 TPM_MIGR_ERP20 CHAR 1001 1 0 Status of Flow Related to Migration to ERP2.0

706952 Data migration for CFM-TM or TR-TM
746051Obsolete database tables for Rel. R/3 Enterprise 2.00
102007Customizing : Update Settings