SAP VDBEPP Flow Data - Planned Item Table

Overview

VDBEPP is a standard SAP S/4HANA table that stores Flow Data - Planned Item data. There are total 207 fields in the VDBEPP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VDBEPP belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).

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

Techincal Settings of VDBEPP

Below are technical details of the table VDBEPP

Buffering not allowed
No buffering
Storage type is Column Store

List of VDBEPP Fields

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

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	T000	CLNT	3
BUKRS	Company Code	BUKRS	T001	CHAR	4
RANL	Contract Number	RANL		CHAR	13
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
DVORGANG	Activity date	DVORGANG		DATS	8
SVORGANG	Business Operation (Activity)	SVORFALL		CHAR	4
NVORGANG	Activity number	NVORGANG		CHAR	3
SBEWART	Flow Type	SBEWART	*	CHAR	4
SREFBEW	Reference flow type	SREFBEW	*	CHAR	4
SBEWZITI	Flow category	SBEWZITI	*	CHAR	4
SPLANIST	Plan/actual record/record to be released indicator	SPLANIST		CHAR	1
SSOLHAB	Debit/credit indicator	VVSSOLHAB		CHAR	1
SSTORNO	Reversal indicator	SSTORNO		CHAR	1
SSTOGRD	Reason for Reversal	SSTOGRD	TZST	CHAR	2
ZUONR	Assignment number	DZUONR		CHAR	18
RSTBLG	Reverse Document Number	STBLG		CHAR	10
SGTXT	Item Text	SGTXT		CHAR	50
SANLF	Product Category	SANLF	*	NUMC	3
DGUEL_KK	Date Condition Effective from	DGUEL		DATS	8
NLFD_ANG	Offer consecutive number	NLFD_ANG		NUMC	3
SSTATI	Status of data record	SSTATI	*	NUMC	2
GSART	Product Type	VVSART	TZPAB	CHAR	3
RREFKONT	Account Assignment Reference in Financial Assets Management	RREFKONT	T037S	CHAR	8
GSBER	Business Area	GSBER	TGSB	CHAR	4
DORDER	Order day	DORDER		DATS	8
NORDER	Order Number	NORDER		NUMC	8
BNWHR	Nominal amount	BNWHR		CURR	13
SNWHR	Currency of nominal amount	SNWHR	TCURC	CUKY	5
BBWHR	Amount in position currency	BBWHR		CURR	13
SBWHR	Position Currency (Currency of Position Amount)	SBWHR	TCURC	CUKY	5
BCWHR	Settlement Amount	BCWHR		CURR	13
SCWHR	Settlement Currency	SCWHR	TCURC	CUKY	5
BHWHR	Amount in local currency	BHWHR		CURR	13
KURS1	Exchange rate	VVKURSF		DEC	9
KURS2	Exchange rate	VVKURSF		DEC	9
DVALUT	Calculation Date	DVALUT		DATS	8
DFAELL	Due date/calculation date	DFAELLIG		DATS	8
DDISPO	Payment Date	DDISPO		DATS	8
DBESTAND	Position value date	DBESTAND		DATS	8
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
UMSKZ	Special G/L Indicator	UMSKZ	*	CHAR	1
KOSTL	Cost Center	KOSTL	*	CHAR	10
SSPESEN	Expenses key	SSPESEN		CHAR	1
RSOLL	Account for debit posting	RSOLL	SKA1	CHAR	10
RHABEN	Account for credit posting	RHABEN	SKA1	CHAR	10
RZKSOLL	Debit interim account	RZKSOLL	SKA1	CHAR	10
RZKHABE	Credit interim account	RZKHABE	SKA1	CHAR	10
SBSLSOLL	Posting Key	BSCHL	TBSL	CHAR	2
SBSLZKSO	Posting Key	BSCHL	TBSL	CHAR	2
SBSLZKHA	Posting Key	BSCHL	TBSL	CHAR	2
SHSLHABEN	Posting Key	BSCHL	TBSL	CHAR	2
RBANKK	Bank account	RBANKK	SKB1	CHAR	10
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
BBASIS	Calculation Base Amount	BBASIS		CURR	13
SSORTZIT	Sort indicator for interest/repayment schedule calculations	SSORTZIT		CHAR	1
SWOHER	Source of flow record	SWOHER		CHAR	1
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
JVERF	Indicator whether drawings exist for the disbursement	JVERF		CHAR	1
KUNNR	Customer Number	KUNNR	KNA1	CHAR	10
BVTYP	Partner bank type	BVTYP		CHAR	4
ZLSCH	Payment Method	DZLSCH	T042Z	CHAR	1
MABER	Dunning Area	MABER	T047M	CHAR	2
ZAHLS	Block Key for Payment	DZAHLS	T008	CHAR	1
RPARTNR	Business Partner Number	BP_PARTNR_NEW	BUT000	CHAR	10
SROLEXT	Dummy function	DUMMY_3		CHAR	3
RKLAMMER	Classification Number for Finance Projects	RKLAMMER		CHAR	13
JEINBEHALT	Indicator for withholding of amount during disbursement	VVJEINBE		CHAR	1
SZEGEN	Generate Incoming Payment Immediately	SZEGEN	*	NUMC	2
MWSKZ	Tax on sales/purchases code	MWSKZ	T007A	CHAR	2
DTRANSREF	Flow data key: System date	VVDTRANS		DATS	8
TTRANSREF	Transaction data key: system time	VVTTRANS		TIMS	6
NTRANSREF	Transaction data key: Consecutive number	VVNTRANS		NUMC	4
RPNNR	Daybook no.	VVRPNNR		CHAR	10
HBKID	Short Key for a House Bank	HBKID	T012	CHAR	5
SBUST	Posting control key	VVSBUST	TZB09	NUMC	2
PWKURS	Security price for percentage quotation	PWKURS		DEC	10
DSTOCK	Premium reserve fund date	VVDSTOCK		DATS	8
JVORAUS	ID for planned record reference to an advance payment	VVJVORAUS		CHAR	1
AMMRHY	Frequency in months	AMMRHY		NUMC	3
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
SINCL	Inclusive indicator for beginning and end of a period	VVSINCL		NUMC	1
DVERRECH	Settlement date	VVDVERRECH		DATS	8
DPKOND	Fixing Date of Percentage Rate from Condition	VVDPKOND		DATS	8
RUMBLG	Reference transfer document number	UMBLG		CHAR	10
ZINKZ	Exempted from Interest Calculation	DZINKZ		CHAR	2
SVULT	Month-End Indicator for Value Date	VVSVULT		CHAR	1
JSOFVERR	Immediate settlement	JSOFVERR		CHAR	1
SINCLVERR	Inclusive Indicator for Clearing Date	VVSINCLVER		NUMC	1
SULTVERR	Month-End Indicator for Clearing Date	VVSULTVERR		CHAR	1
SREFZITI	Refer.flow category in accrual/deferral flow records	VVSREFZITI	*	CHAR	4
STGBASIS	Base Days Method	VVSTGBASIS		CHAR	1
STGMETH	Daily Method	VVSTGMETH		NUMC	1
SBASIS	Calculation base reference	VVSBASIS	TZFB	CHAR	4
SBERFIMA	Calculation category for cash flow calculator	SBEWFIMA	AT40	CHAR	4
SVORGKZ	Activity indicator for debit/credit control	VVSVORGKZ		NUMC	2
MANSP	Dunning Block	MANSP	T040S	CHAR	1
DGUEL_KP	Condition Item Valid From	DGUEL_KP		DATS	8
NSTUFE	Level number of condition item for recurring payments	NSTUFE		NUMC	2
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
RKONT	Quota number	RKONT		NUMC	6
DAUSZ	Lead date for withholding amounts for disbursement	VVDAUSZ		DATS	8
SSOLIST	Calculation using actual principle (or debit)	SSOLIST		CHAR	1
RDARNEHM	Borrower/Applicant Number	RDARNEHM_NEW		CHAR	10
BKOND	Condition Item Currency Amount	BKOND		CURR	13
RZEBEL	Document number of waiver/write-off document	VEBLGNR		CHAR	10
ZFBDT	Payment Date	DDISPO		DATS	8
DZFEST	Interest rate fixing date	TB_DZFEST		DATS	8
SBERECH	Grace Period Interest Method	SBERECH		CHAR	1
BKARZINS	Int.for days betw. redemption clear.and pmnt (FiMa-internal)	TFMBKAZINS		CURR	13
BTITALK	Imputed annuity repayment amount (FiMa internal)	TFMBTIKALK		CURR	13
HDN_KUNNR	Main Borrower Customer Number	HDN_KUNNR	KNA1	CHAR	10
SZART	Payment Transaction	TB_SZART		CHAR	1
RUZBEL	Accounting Document Number	BELNR_D		CHAR	10
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ		NUMC	4
REBZG	Document No. of the Invoice to Which the Transaction Belongs	REBZG		CHAR	10
REBZZ	Line Item in the Relevant Invoice	REBZZ		NUMC	3
S_SSDREF	Reference flow category in borrower's note loan flow records	VVS_SSDREF	*	CHAR	4
SAEND	Change Indicator for FiMa Flow Records	TFM_SAEND		NUMC	1
XPORE	Indicator: Individual Payment?	PRQ_XPORE		CHAR	1
SPAYRQ	Generate Payment Request	TB_SPAYRQK		CHAR	1
PRKEY	Key Number for Payment Request	PRQ_KEYNO	*	CHAR	10
HKTID	ID for Account Details	HKTID	T012K	CHAR	5
VORGTYP	Activity Category (Posting Area)	VORGTYP_LO		CHAR	4
ACENV	Source in TR-LO posting area	ACENV_LO		NUMC	4
SSIGN	Direction of Flow	TB_SSIGN		CHAR	1
SPRSNG	Individual Payment	TB_SPRSNGK		CHAR	1
UZAWE	Payment method supplement	UZAWE	T042F	CHAR	2
SPRGRD	Determine Grouping Definition	TB_SPRGRD		CHAR	1
SCSPAY	Same Direction Necessary for Joint Payment?	TB_SCSPAY		CHAR	1
ZWELS	List of Respected Payment Methods	DZWELS		CHAR	10
PAYGR	Grouping Field for Automatic Payments	PAYGR		CHAR	20
JEXPOZINS	Type of Compound Interest Calculation	TFM_SINTCOMP		CHAR	1
SREVALEXCL	Price gains w/o proportionate gains from deferral write-back	VVSREVALEXCL		CHAR	1
RBO	Business Operation Number (Loans)	RBO		CHAR	15
SROUND	Rounding Category	TFM_SROUND		CHAR	1
SKALIDWT	Interest Calendar	TFMSKALIDWT		CHAR	2
PPAYMENT	Payment Rate	TFM_PPAYMENT		DEC	11
AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.	TFM_AMMRHYZV		NUMC	2
LC_CAPITALS	Effect of the Flow on Capital Amounts Status	TB_LC_CAPITALS		CHAR	2
LC_DISBURSE	Effect of the Flow on the Disbursement Status	TB_LC_DISBURSE		CHAR	2
OP_APPLICATION	Open Item Tool: Application Key	TB_OPAPPL		NUMC	2
OP_RBO	OI Tool: Locking Business Operation	TB_OP_RBO		CHAR	15
DFAELL_OLD_EXT	Old Due Date	TB_EXTENS_DFAELL_OLD		DATS	8
DDISPO_OLD_EXT	Old Payment Date	TB_EXTENS_DDISPO_OLD		DATS	8
RBO_EXT	Business Operation Number (Loans)	RBO		CHAR	15
SBEWEGRP2	Flow Record Group in Cash Flow Calculator (Incoming Payment)	TB_FLOW_REC_GRP		NUMC	6
SUSP_REASON_TYPE	Key for Overpayment Reason	TB_SUSPREASON	TDSUSPREASON	NUMC	3
MNDID	Unique Reference to Mandate for each Payee	SEPA_MNDID		CHAR	35
SBEWEGRP	Flow record group in cash flow calculator	SBEWEGRP		NUMC	4
REMIT_INFO	Payment Notes Info	TB_REMIT_INFO		CHAR	140
DIP_KUKEY	DIP Short Key	FVD_DIP_KUKEY	FEBEP	NUMC	8
DIP_ESNUM	DIP Line Item Number	FVD_DIP_ESNUM	FEBEP	NUMC	5
DIP_ID	ID (Differentiated Incominmg Payment)	TB_DIP_ID	VDDIP_ID	CHAR	4
DIP_DATE	Date (Differentiated Incoming Payment)	TB_DIP_DATE		DATS	8
FLG_IP_CLI_NOTICE	Payment created by CLI notice	TB_FLG_IP_CLI_NOTICE		CHAR	1
AAVGDAYS	No. of Days for Interest Calc. with Average Interest Rate	TFM_AAVGDAYS		INT4	10
PAVGINTEREST	Average Interest Rate	TFM_PAVGINTEREST		DEC	15
JAVGCAP	Use Upper Limit of Average Interest Rate	TFM_JAVGCAP		CHAR	1
PAVGCAP	Upper Limit of Average Interest Rate	TFM_PAVGCAP		DEC	15
JAVGFLOOR	Use Lower Limit of Average Interest Rate	TFM_JAVGFLOOR		CHAR	1
PAVGFLOOR	Lower Limit of Average Interest Rate	TFM_PAVGFLOOR		DEC	15
PAVGSPREAD	Average Interest Rate Spread	TFM_PAVGSPREAD		DEC	15
SROUNDAVGINTEREST	Rounding Category of Average Interest Rate	TFM_SROUNDAVGINTEREST		CHAR	1
ROUNDDECAVGINTEREST	Number of Rounding Decimal Places for Average Interest Rate	TFM_ROUNDDECAVGINTEREST		INT1	3
AAVGWEIGHT	Weighting of Interest Rate	TFM_AWEIGHT		INT4	10
AAVGWEIGHTSUM	Cumulative Weighting of Interest Rate	TFM_AWEIGHTSUM		INT4	10
JEXPOINTFACTOR	Exponential Interest Calculation with Factor	TFM_JEXPOINTFACTOR		CHAR	1
FLOWFACTOR	Flow Factor	TFM_FLOWFACTOR		D34R	34
BASEFACTOR	Base Factor	TFM_BASEFACTOR		D34R	34
SFACTORRESET	Event for Resetting Factor Calculation	TFM_SFACTORRESET		CHAR	1
CA_DTRANS	Flow data key: System date	VVDTRANS		DATS	8
CA_TTRANS	Transaction data key: system time	VVTTRANS		TIMS	6
CA_NTRANS	Transaction data key: Consecutive number	VVNTRANS		NUMC	4
CA_FLG_ORG	Flow is orginal flow for customer specific dependent flow(s)	TB_FLG_CUST_ORG		CHAR	1
BROUNDUNIT	Rounding Unit for Amounts	TB_BROUNDUNIT_A		DEC	13
SEPA_PD	Posting Date in the Document	BUDAT		DATS	8

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 VDBEPP

Table Name	Field	Cardinality	Check Table
VDBEPP	BUKRS	1: CN	T001
VDBEPP	DIP_ESNUM	:	FEBEP
VDBEPP	DIP_ID	:	VDDIP_ID
VDBEPP	DIP_KUKEY	:	FEBEP
VDBEPP	GSART	1: CN	TZPAB
VDBEPP	GSBER	:	TGSB
VDBEPP	HBKID	1: CN	T012
VDBEPP	HDN_KUNNR	C: CN	KNA1
VDBEPP	HKTID	:	T012K
VDBEPP	KUNNR	C: CN	KNA1
VDBEPP	MABER	1: CN	T047M
VDBEPP	MANDT	1: CN	T000
VDBEPP	MANSP	:	T040S
VDBEPP	MWSKZ	:	T007A
VDBEPP	RBANKK	1: CN	SKB1
VDBEPP	RHABEN	1: 1	SKA1
VDBEPP	RPARTNR	1: CN	BUT000
VDBEPP	RREFKONT	:	T037S
VDBEPP	RSOLL	1: 1	SKA1
VDBEPP	RZKHABE	1: 1	SKA1
VDBEPP	RZKSOLL	1: 1	SKA1
VDBEPP	SBASIS	:	TZFB
VDBEPP	SBERFIMA	:	AT40
VDBEPP	SBSLSOLL	1: CN	TBSL
VDBEPP	SBSLZKHA	1: CN	TBSL
VDBEPP	SBSLZKSO	1: CN	TBSL
VDBEPP	SBUST	1: CN	TZB09
VDBEPP	SBWHR	1: CN	TCURC
VDBEPP	SCWHR	1: CN	TCURC
VDBEPP	SFDLEV	1: CN	T036
VDBEPP	SHSLHABEN	1: CN	TBSL
VDBEPP	SKOART	1: CN	TZK01
VDBEPP	SNWHR	1: CN	TCURC
VDBEPP	SSTOGRD	1: CN	TZST
VDBEPP	SUSP_REASON_TYPE	:	TDSUSPREASON
VDBEPP	UZAWE	:	T042F
VDBEPP	ZAHLS	1: CN	T008
VDBEPP	ZLSCH	:	T042Z

SAP VDBEPP Flow Data - Planned Item Table

Overview

Techincal Settings of VDBEPP

List of VDBEPP Fields

Foreign Key Relationships

Other References