VWBEPP - Treasury Securities: Planned Flows

Treasury Securities: Planned Flows information is stored in SAP table VWBEPP.
It is part of development package FVVW in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Treasury Management: Securities".

Fields for table VWBEPP

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
RANL	Security Class ID Number	X	VVRANLW	CHAR	26	VWPANLA
RLDEPO	Securities Account	X	VRLDEPO	CHAR	20	TWD01
DTRANS	Flow data key: System date	X	VVDTRANS	DATS	16
TTRANS	Transaction data key: system time	X	VVTTRANS	TIMS	12
NTRANS	Transaction data key: Consecutive number	X	VVNTRANS	NUMC	8
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
SSTATI	Status of data record		SSTATI	NUMC	4
INTEB	Financial Assets Management internal level		VVSINTEB	NUMC	4
SBEWART	Flow Type		SBEWART	CHAR	8	TZB0A
SBEWZITI	Flow category		SBEWZITI	CHAR	8
SSOLHAB	Debit/credit indicator		VVSSOLHAB	CHAR	2
DVORGANG	Activity date		DVORGANG	DATS	16
SVORGANG	Securities-Activity		RVORGANG	CHAR	16
NVORGANG	Activity number		NVORGANG	CHAR	6
SNWHR	Currency of nominal amount		SNWHR	CUKY	10	TCURC
SBWHR	Position Currency (Currency of Position Amount)		SBWHR	CUKY	10	TCURC
SCWHR	Settlement Currency		SCWHR	CUKY	10	TCURC
ASTUECK	Number of units for unit-quoted securities		ASTUECK	DEC	8
BWKURS	Security price for unit quotation		BWKURS	CURR	7
BNWHR	Nominal amount		BNWHR	CURR	7
PWKURS	Security price for percentage quotation		PWKURS	DEC	6
BBWHR	Amount in position currency		BBWHR	CURR	7
BCWHR	Settlement Amount		BCWHR	CURR	7
BHWHR	Amount in local currency		BHWHR	CURR	7
KURS1	Exchange Rate into Settlement Currency		VVKURS1	DEC	5
KURS2	Exchange rate from settlement currency into local currency		VVKURS2	DEC	5
DORDER	Order day		DORDER	DATS	16
DVALUT	Interest Value Date/Calculation Date		VVDZINVAL	DATS	16
DDISPO	Value Date / Planning Day		VVDWERTST	DATS	16
DBESTAND	Position value date		DBESTAND	DATS	16
DBEST6B	Date for �6b EstG relevant postings		DBEST6B	DATS	16
SSPESEN	Expenses key		SSPESEN	CHAR	2
SLIMIT	Order notation		SLIMIT	CHAR	2
BLIMIT	Limit price for unit quotation		BLIMIT	CURR	7
PLIMIT	Limit price for percentage quotation		PLIMIT	DEC	6
NORDER	Position number		SECPOSITIONNUMBER	NUMC	16
RSOLL	Account for debit posting		RSOLL	CHAR	20	SKA1
RZKSOLL	Debit interim account		RZKSOLL	CHAR	20	SKA1
RZKHABE	Credit interim account		RZKHABE	CHAR	20	SKA1
RHABEN	Account for credit posting		RHABEN	CHAR	20	SKA1
SBSLSOLL	Posting Key		BSCHL	CHAR	4	TBSL
SBSLZKSO	Posting Key		BSCHL	CHAR	4	TBSL
SBSLZKHA	Posting Key		BSCHL	CHAR	4	TBSL
SBSLHABEN	Posting Key		BSCHL	CHAR	4	TBSL
SWHRT	Currency swap indicator		SWHRT	CHAR	2
RBANKK	Bank account		RBANKK	CHAR	20	SKB1
RKONTRA	Reference to Counterparty		RKONTRA_NEW	CHAR	20
SROLEXTKO	Dummy function		DUMMY_3	CHAR	6
SFDLEV	Planning Level		FDLEV	CHAR	4	T036
JFDUPD	Record transferred to cash management and forecast		JFDUPD	CHAR	2
JONLAEN	Indicator for fixing a flow record		JONLAEN	CHAR	2
JZINSBAS	Flow in interest base		JZINSBAS	CHAR	2
JZINSZPT	Interest date		JZINSZPT	CHAR	2
PKOND	Percentage rate for condition items		PKOND	DEC	6
SSTCKKZ	Accrued interest method		SSTCKKZ	CHAR	2
SSTCKTG	Accrued interest: Daily method		SSTCKTG	CHAR	2
PEFFZINS	Effective Interest Rate		PEFFZINS	DEC	6
SEFFMETH	Effective Interest Method (Financial Mathematics)		SEFFMETH	NUMC	2
SCRWHR1	Currency Key		WAERS	CUKY	10	TCURC
SCRWHR2	Currency Key		WAERS	CUKY	10	TCURC
KCROSS	Exchange rate		KURSF	DEC	5
NORDEXT	External order number		NORDEXT	CHAR	40
SWOHER	Treasury: Source of Flow		TB_SWOHER	CHAR	2
XZUSATZ	Assignment		XZUSATZ	CHAR	36
JONLBUC	Online posting flag indicator		JONLBUC	CHAR	2
DANST	Reservation date		DANST	DATS	16
TANST	Order time of day		TANST	TIMS	12
SANST	Reservation reason		SANST	CHAR	4	TW14
SABRECH	Single-Character Flag		CHAR1	CHAR	2
SVERFALL	Single-Character Flag		CHAR1	CHAR	2
RDEALER	Trader		RDEALER	CHAR	24	TZDEA
KOSTL	Cost Center		KOSTL	CHAR	20	CSKS
GSBER	Business Area		GSBER	CHAR	8	TGSB
BBASIS	Calculation Base Amount		BBASIS	CURR	7
DBERVON	Start of Calculation Period		DBERVON	DATS	16
DBERBIS	End of Calculation Period		DBERBIS	DATS	16
ATAGE	Number of Days		VVATAGE	NUMC	12
ABASTAGE	Number of base days in a calculation period		ABASTAGE	NUMC	12
SZBMETH	Interest Calculation Method		SZBMETH	CHAR	2
SKALIDWT	Interest Calendar		TFMSKALIDWT	CHAR	4
JEXPOZINS	Type of Compound Interest Calculation		TFM_SINTCOMP	CHAR	2
SOBJEKT	Internal key for object		VVKEYOBJ	CHAR	20
RZBANK	Paying Bank		VVRZBANK_NEW	CHAR	20	BUT000
SROLEXTZB	Dummy function		DUMMY_3	CHAR	6
JVERK6B	Sale in Acc. with Tax Credit Method		VVJVERK6B	CHAR	2
SZEGEN	Generate Incoming Payment Immediately		SZEGEN	NUMC	4
SBUST	Posting Control Key		VVSBUST	NUMC	4	TZB09
SCOUPON	Coupon ID for interest and accrued interest calculation		VVSCOUPON	CHAR	2
DCOUPON	Coupon date of next delivered coupon		VVDCOUPON	DATS	16
SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation		VVSFLAT	CHAR	2
DFAELL	Due date		DFAELL	DATS	16
RHANDPL	Exchange		VVRHANDPL	CHAR	20	TWH01
SKOART	Condition Type (Smallest Subdivision of Condition Records)		SKOART	NUMC	8	TZK01
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period		VVSEXCLVON	NUMC	2
SULTVON	Month-End Indicator for Start of a Calculation Period		VVSULTVON	CHAR	2
SINCLBIS	Inclusive Indicator for the End of a Calculation Period		VVSINCLBIS	NUMC	2
SULTBIS	Month-End Indicator for the End of a Calculation Period		VVSULTBIS	CHAR	2
DVERRECH	Settlement date		VVDVERRECH	DATS	16
DPKOND	Fixing Date of Percentage Rate from Condition		VVDPKOND	DATS	16
SREFZITI	Refer.flow category in accrual/deferral flow records		VVSREFZITI	CHAR	8
SFIXRATE2	Fixed exchange rate		VVSFIXRATE	CHAR	2
SFIXRATE1	Fixed exchange rate		VVSFIXRATE	CHAR	2
SINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
SVULT	Month-End Indicator for Value Date		VVSVULT	CHAR	2
RREFKONT	Account Assignment Reference in Financial Assets Management		RREFKONT	CHAR	16	T037S
APERTAGE	No. of Days of a (Calculation) Period in Cash Flow		VVAPERTAGE	NUMC	12
STGMETH	Daily Method		VVSTGMETH	NUMC	2
STGBASIS	Base Days Method		VVSTGBASIS	CHAR	2
DBPERIOD	Period start		VVDBPERIOD	DATS	16
SPAEXCL	Exclusive Indicator for Start Date of a Period		TFMSPAEXCL	NUMC	2
SPAULT	Month-End Indicator for Start Date of a Period		TFMSPAULT	CHAR	2
DEPERIOD	Period End		VVDEPERIOD	DATS	16
SPEINCL	Inclusive Indicator for End Date of a Period		TFMSPEINCL	NUMC	2
SPEULT	Month-End Indicator for End of a Period		TFMSPEULT	CHAR	2
SINCLVERR	Inclusive Indicator for Clearing Date		VVSINCLVER	NUMC	2
SULTVERR	Month-End Indicator for Clearing Date		VVSULTVERR	CHAR	2
DGUEL_KP	Condition Item Effective From		DGUEL_KP	DATS	16
NSTUFE	Level number of condition item for recurring payments		NSTUFE	NUMC	4
RPNNR	Daybook no.		VVRPNNR	CHAR	20
SBERFIMA	Calculation category for cash flow calculator		SBEWFIMA	CHAR	8
SVORGKZ	Activity indicator for debit/credit control		VVSVORGKZ	NUMC	4
SREFBEW	Reference flow type		SREFBEW	CHAR	8
SSWHR	Stock price currency		VVSSWHR	CUKY	10
BSWHR	Market value		VVBSWHR	CURR	7
SRUNIT	Currency unit		VVSRUNIT	CHAR	10	TZUNI
KWKURS	Security price		VVKWKURS	DEC	8
DSCHLUSS	Date of business closing		VVDSCHLUSS	DATS	16
TSCHLUSS	Time of business closing		VVTSCHLUSS	TIMS	12
SHERKUNFT	Origin indicator: 'From planned record/actual record'		VVSHERK	CHAR	2
SFGKZ	Release Indicator		VVSFGKZ	CHAR	2
SBUCHA	Indicator for postings to accruals/deferrals accounts		VVSBUCHA	CHAR	2
RAHABKI	Short Key for Own House Bank		TB_RHABKI	CHAR	10	T012
RAHKTID	Short Key for House Bank Account		TB_RHKTID	CHAR	10	T012K
RPBANK	Partner Bank Details		TB_RPBANK	CHAR	8
SZART	Payment Transaction		TB_SZART	CHAR	2
PEFFZCALL	Effective Interest Rate		PEFFZINS	DEC	6
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
REFRLDEPO	Reference sec.acct for sec.acct transfer (inflow/outflow)		VVREFRLDEP	CHAR	20
KGV_FLAG	Manages status of the related price gains/losses flows		TKGV	CHAR	2
DZFEST	Interest rate fixing date		TB_DZFEST	DATS	16
KUNNR	Customer Number		KUNNR	CHAR	20
KMNR	Corporate Action Number		KMNR	CHAR	26
ERNR	ID number of exercised right		TER_HEADNUMBER	CHAR	26
DEVALPOST	Date of period-end closing		DEVALPOST	DATS	16
REFER	Internal Reference		TB_REFER	CHAR	32
MERKM	Characteristics		TB_MERKM	CHAR	50
SPAYRQ	Generate Payment Request		TB_SPAYRQK	CHAR	2
SPRSNG	Individual Payment		TB_SPRSNGK	CHAR	2
RPZAHL	Payer/Payee		TB_RPZAHL_NEW	CHAR	20
RFHA	Financial Transaction		TB_RFHA	CHAR	26
INDEX_VALUE	Index Value (Independent of Basis)		TIDX_INDEX_VALUE_NO_RATIO	DEC	10
PPAYMENT	Payment Rate		TFM_PPAYMENT	DEC	6
BBWHR_IDX_CLEAN	Amount in position currency		BBWHR	CURR	7
BUSTRANSID	Identifier of the Distributor Business Transaction		TPM_BUSTRANSID	RAW	16
BUSTRANSCAT	Business Transaction Category		TPM_BUSTRANSCAT	NUMC	8	TRDTS_BT_CAT
DBUDAT	Posting Date in the Document		BUDAT	DATS	16
DGJAHR	Fiscal Year		GJAHR	NUMC	8
RBELNRFI	Document Number of an Accounting Document		BELNR_D	CHAR	20
RBELNRFI2	Document Number of an Accounting Document		BELNR_D	CHAR	20
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	2
MIGR_ERP20	Status of Flow Related to Migration to ERP2.0		TPM_MIGR_ERP20	CHAR	2