SAP VWBEPP Treasury Securities: Planned Flows Table

Overview

VWBEPP is a standard SAP S/4HANA table that stores Treasury Securities: Planned Flows data. There are total 173 fields in the VWBEPP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VWBEPP belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package Treasury Management: Securities (FVVW).

In addition, following links provide an overview of foreign key relationships, if any, that link VWBEPP to other SAP tables and standard CDS views available based on VWBEPP table in S/4HANA 2020.

Techincal Settings of VWBEPP

Below are technical details of the table VWBEPP

Buffering not allowed
No buffering
Storage type is Column Store

List of VWBEPP Fields

The following table gives you an overview of the fields available in VWBEPP

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	T000	CLNT	3
BUKRS	Company Code	BUKRS	T001	CHAR	4
RANL	Security Class ID Number	VVRANLW	VWPANLA	CHAR	13
RLDEPO	Securities Account	VRLDEPO	TWD01	CHAR	10
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 Creation	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	TZB0A	CHAR	4
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	TCURC	CUKY	5
SBWHR	Position Currency (Currency of Position Amount)	SBWHR	TCURC	CUKY	5
SCWHR	Settlement Currency	SCWHR	TCURC	CUKY	5
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	SKA1	CHAR	10
RZKSOLL	Debit interim account	RZKSOLL	SKA1	CHAR	10
RZKHABE	Credit interim account	RZKHABE	SKA1	CHAR	10
RHABEN	Account for credit posting	RHABEN	SKA1	CHAR	10
SBSLSOLL	Posting Key	BSCHL	TBSL	CHAR	2
SBSLZKSO	Posting Key	BSCHL	TBSL	CHAR	2
SBSLZKHA	Posting Key	BSCHL	TBSL	CHAR	2
SBSLHABEN	Posting Key	BSCHL	TBSL	CHAR	2
SWHRT	Currency swap indicator	SWHRT		CHAR	1
RBANKK	Bank account	RBANKK	SKB1	CHAR	10
RKONTRA	Reference to Counterparty	RKONTRA_NEW		CHAR	10
SROLEXTKO	Dummy function	DUMMY_3		CHAR	3
SFDLEV	Planning Level	FDLEV	T036	CHAR	2
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	TCURC	CUKY	5
SCRWHR2	Currency Key	WAERS	TCURC	CUKY	5
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	TW14	CHAR	2
SABRECH	Single-Character Flag	CHAR1		CHAR	1
SVERFALL	Single-Character Flag	CHAR1		CHAR	1
RDEALER	Trader	RDEALER	TZDEA	CHAR	12
KOSTL	Cost Center	KOSTL	CSKS	CHAR	10
GSBER	Business Area	GSBER	TGSB	CHAR	4
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	Type of Compound Interest Calculation	TFM_SINTCOMP		CHAR	1
SOBJEKT	Internal key for object	VVKEYOBJ		CHAR	10
RZBANK	Paying Bank	VVRZBANK_NEW	BUT000	CHAR	10
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	TZB09	NUMC	2
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	TWH01	CHAR	10
SKOART	Condition Type (Smallest Subdivision of Condition Records)	SKOART	TZK01	NUMC	4
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	Fixing Date of Percentage Rate from Condition	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	T037S	CHAR	8
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		CHAR	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	TZUNI	CHAR	5
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	T012	CHAR	5
RAHKTID	Short Key for House Bank Account	TB_RHKTID	T012K	CHAR	5
RPBANK	Partner Bank Details	TB_RPBANK		CHAR	4
ZLSCH	Payment Method	DZLSCH	T042Z	CHAR	1
SZART	Payment Transaction	TB_SZART		CHAR	1
PEFFZCALL	Effective Interest Rate	PEFFZINS		DEC	10
OBJNR	Object number	J_OBJNR	ONR00	CHAR	22
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
KUNNR	Customer Number	KUNNR		CHAR	10
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	TRDTS_BT_CAT	NUMC	4
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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VWBEPP

Table Name	Field	Cardinality	Check Table
VWBEPP	BUKRS	1: CN	T001
VWBEPP	BUSTRANSCAT	1: CN	TRDTS_BT_CAT
VWBEPP	GSBER	1: CN	TGSB
VWBEPP	KOSTL	1: CN	CSKS
VWBEPP	MANDT	1: CN	T000
VWBEPP	OBJNR	1: 1	ONR00
VWBEPP	RAHABKI	C: CN	T012
VWBEPP	RAHKTID	C: CN	T012K
VWBEPP	RANL	1: CN	VWPANLA
VWBEPP	RBANKK	C: CN	SKB1
VWBEPP	RDEALER	1: CN	TZDEA
VWBEPP	RHABEN	1: 1	SKA1
VWBEPP	RHANDPL	C: CN	TWH01
VWBEPP	RLDEPO	1: CN	TWD01
VWBEPP	RREFKONT	1: CN	T037S
VWBEPP	RSOLL	1: 1	SKA1
VWBEPP	RZBANK	1: CN	BUT000
VWBEPP	RZKHABE	1: 1	SKA1
VWBEPP	RZKSOLL	1: 1	SKA1
VWBEPP	SANST	1: CN	TW14
VWBEPP	SBEWART	1: CN	TZB0A
VWBEPP	SBSLHABEN	1: CN	TBSL
VWBEPP	SBSLSOLL	1: CN	TBSL
VWBEPP	SBSLZKHA	1: CN	TBSL
VWBEPP	SBSLZKSO	1: CN	TBSL
VWBEPP	SBUST	1: CN	TZB09
VWBEPP	SBWHR	1: CN	TCURC
VWBEPP	SCRWHR1	1: CN	TCURC
VWBEPP	SCRWHR2	1: CN	TCURC
VWBEPP	SCWHR	1: CN	TCURC
VWBEPP	SFDLEV	1: CN	T036
VWBEPP	SKOART	C: CN	TZK01
VWBEPP	SNWHR	1: CN	TCURC
VWBEPP	SRUNIT	1: CN	TZUNI
VWBEPP	ZLSCH	C: CN	T042Z

SAP VWBEPP Treasury Securities: Planned Flows Table

Overview

Techincal Settings of VWBEPP

List of VWBEPP Fields

Foreign Key Relationships

Other References