VDBEPP SAP table for - Flow Data

Table of Contents

Here we would like to draw your attention to VDBEPP table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). VDBEPP is a SAP standard transp table used for storing Flow Data – Planned Item related data in SAP. It comes under the package FVVD.

SAP VDBEPP table

Table VDBEPP technical data

Table	VDBEPP
Data storing	Flow Data – Planned Item
Module	FS
Sub Module	FS-CML
SAP Package	FVVD
Delivery Class	A – Application table (master and transaction data)
Component	EA-FINSERV
Table Category	TRANSP

SAP VDBEPP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VDBEPP table.

MANDT : Client
Its a key field. Its data type is CLNT (Character with length 3) with field length 3

BUKRS : Company Code
Its a key field. Its data type is CHAR (Character String) with field length 4

RANL : Contract Number
Its a key field. Its data type is CHAR (Character String) with field length 13

DTRANS : Flow data key: System date
Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

TTRANS : Transaction data key: system time
Its a key field. Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

NTRANS : Transaction data key: Consecutive number
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4

.INCLUDE : INCLUDE for VDBEPP (new fields always at the end)

RERF : Entered by
Its data type is CHAR (Character String) with field length 12

DERF : First Entered on
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

TERF : Time of Initial Entry
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

REHER : Source of initial entry
Its data type is CHAR (Character String) with field length 10

RBEAR : Employee ID
Its data type is CHAR (Character String) with field length 12

DBEAR : Last Edited on
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

TBEAR : Last Edited at
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

RBHER : Editing Source
Its data type is CHAR (Character String) with field length 10

DVORGANG : Activity date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SVORGANG : Business Operation (Activity)
Its data type is CHAR (Character String) with field length 4

NVORGANG : Activity number
Its data type is CHAR (Character String) with field length 3

SBEWART : Flow Type
Its data type is CHAR (Character String) with field length 4

SREFBEW : Reference flow type
Its data type is CHAR (Character String) with field length 4

SBEWZITI : Flow category
Its data type is CHAR (Character String) with field length 4

SPLANIST : Plan/actual record/record to be released indicator
Its data type is CHAR (Character String) with field length 1

SSOLHAB : Debit/credit indicator
Its data type is CHAR (Character String) with field length 1

SSTORNO : Reversal indicator
Its data type is CHAR (Character String) with field length 1

SSTOGRD : Reason for Reversal
Its data type is CHAR (Character String) with field length 2

ZUONR : Assignment number
Its data type is CHAR (Character String) with field length 18

RSTBLG : Reverse Document Number
Its data type is CHAR (Character String) with field length 10

SGTXT : Item Text
Its data type is CHAR (Character String) with field length 50

SANLF : Product Category
Its data type is NUMC (Character String with Digits Only) with field length 3

DGUEL_KK : Date Condition Effective from
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

NLFD_ANG : Offer consecutive number
Its data type is NUMC (Character String with Digits Only) with field length 3

SSTATI : Status of data record
Its data type is NUMC (Character String with Digits Only) with field length 2

GSART : Product Type
Its data type is CHAR (Character String) with field length 3

RREFKONT : Account Assignment Reference in Financial Assets Management
Its data type is CHAR (Character String) with field length 8

GSBER : Business Area
Its data type is CHAR (Character String) with field length 4

DORDER : Order day
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

NORDER : Order Number
Its data type is NUMC (Character String with Digits Only) with field length 8

BNWHR : Nominal amount
Its data type is CURR (Currency Field) with field length 13

SNWHR : Currency of nominal amount
Its data type is CUKY (Currency key for a currency field) with field length 5

BBWHR : Amount in position currency
Its data type is CURR (Currency Field) with field length 13

SBWHR : Position Currency (Currency of Position Amount)
Its data type is CUKY (Currency key for a currency field) with field length 5

BCWHR : Settlement Amount
Its data type is CURR (Currency Field) with field length 13

SCWHR : Settlement Currency
Its data type is CUKY (Currency key for a currency field) with field length 5

BHWHR : Amount in local currency
Its data type is CURR (Currency Field) with field length 13

KURS1 : Exchange rate
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9

KURS2 : Exchange rate
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9

DVALUT : Calculation Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DFAELL : Due date/calculation date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DDISPO : Payment Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DBESTAND : Position value date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DBERVON : Start of Calculation Period
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DBERBIS : End of Calculation Period
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

ATAGE : Number of days
Its data type is NUMC (Character String with Digits Only) with field length 6

ABASTAGE : Number of base days in a calculation period
Its data type is NUMC (Character String with Digits Only) with field length 6

SZBMETH : Interest Calculation Method
Its data type is CHAR (Character String) with field length 1

UMSKZ : Special G/L Indicator
Its data type is CHAR (Character String) with field length 1

KOSTL : Cost Center
Its data type is CHAR (Character String) with field length 10

SSPESEN : Expenses key
Its data type is CHAR (Character String) with field length 1

RSOLL : Account for debit posting
Its data type is CHAR (Character String) with field length 10

RHABEN : Account for credit posting
Its data type is CHAR (Character String) with field length 10

RZKSOLL : Debit interim account
Its data type is CHAR (Character String) with field length 10

RZKHABE : Credit interim account
Its data type is CHAR (Character String) with field length 10

SBSLSOLL : Posting Key
Its data type is CHAR (Character String) with field length 2

SBSLZKSO : Posting Key
Its data type is CHAR (Character String) with field length 2

SBSLZKHA : Posting Key
Its data type is CHAR (Character String) with field length 2

SHSLHABEN : Posting Key
Its data type is CHAR (Character String) with field length 2

RBANKK : Bank account
Its data type is CHAR (Character String) with field length 10

SFDLEV : Planning Level
Its data type is CHAR (Character String) with field length 2

JFDUPD : Record transferred to cash management and forecast
Its data type is CHAR (Character String) with field length 1

JONLAEN : Indicator for fixing a flow record
Its data type is CHAR (Character String) with field length 1

JZINSBAS : Flow in interest base
Its data type is CHAR (Character String) with field length 1

JZINSZPT : Interest date
Its data type is CHAR (Character String) with field length 1

PKOND : Percentage rate for condition items
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

BBASIS : Calculation base amount
Its data type is CURR (Currency Field) with field length 13

SSORTZIT : Sort indicator for interest/repayment schedule calculations
Its data type is CHAR (Character String) with field length 1

SWOHER : Source of flow record
Its data type is CHAR (Character String) with field length 1

SSTCKKZ : Accrued interest method
Its data type is CHAR (Character String) with field length 1

SSTCKTG : Accrued interest: Daily method
Its data type is CHAR (Character String) with field length 1

PEFFZINS : Effective Interest Rate
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

SEFFMETH : Effective Interest Method (Financial Mathematics)
Its data type is NUMC (Character String with Digits Only) with field length 1

JVERF : Indicator whether drawings exist for the disbursement
Its data type is CHAR (Character String) with field length 1

KUNNR : Customer Number
Its data type is CHAR (Character String) with field length 10

BVTYP : Partner bank type
Its data type is CHAR (Character String) with field length 4

ZLSCH : Payment method
Its data type is CHAR (Character String) with field length 1

MABER : Dunning Area
Its data type is CHAR (Character String) with field length 2

ZAHLS : Block Key for Payment
Its data type is CHAR (Character String) with field length 1

RPARTNR : Business Partner Number
Its data type is CHAR (Character String) with field length 10

SROLEXT : Dummy function
Its data type is CHAR (Character String) with field length 3

RKLAMMER : Classification Number for Finance Projects
Its data type is CHAR (Character String) with field length 13

JEINBEHALT : Indicator for withholding of amount during disbursement
Its data type is CHAR (Character String) with field length 1

SZEGEN : Generate incoming payment immediately
Its data type is NUMC (Character String with Digits Only) with field length 2

MWSKZ : Tax on sales/purchases code
Its data type is CHAR (Character String) with field length 2

DTRANSREF : Flow data key: System date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

TTRANSREF : Transaction data key: system time
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

NTRANSREF : Transaction data key: Consecutive number
Its data type is NUMC (Character String with Digits Only) with field length 4

RPNNR : Daybook no.
Its data type is CHAR (Character String) with field length 10

HBKID : Short key for a house bank
Its data type is CHAR (Character String) with field length 5

SBUST : Posting control key
Its data type is NUMC (Character String with Digits Only) with field length 2

PWKURS : Security price for percentage quotation
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10

DSTOCK : Premium reserve fund date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

JVORAUS : ID for planned record reference to an advance payment
Its data type is CHAR (Character String) with field length 1

AMMRHY : Frequency in months
Its data type is NUMC (Character String with Digits Only) with field length 3

SKOART : Condition Type (Smallest Subdivision of Condition Records)
Its data type is NUMC (Character String with Digits Only) with field length 4

SEXCLVON : Exclusive Indicator for the Start of a Calculation Period
Its data type is NUMC (Character String with Digits Only) with field length 1

SULTVON : Month-End Indicator for Start of a Calculation Period
Its data type is CHAR (Character String) with field length 1

SINCLBIS : Inclusive Indicator for the End of a Calculation Period
Its data type is NUMC (Character String with Digits Only) with field length 1

SULTBIS : Month-End Indicator for the End of a Calculation Period
Its data type is CHAR (Character String) with field length 1

SINCL : Inclusive indicator for beginning and end of a period
Its data type is NUMC (Character String with Digits Only) with field length 1

DVERRECH : Settlement date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DPKOND : Determination date for percentage rate of condition items
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

RUMBLG : Reference transfer document number
Its data type is CHAR (Character String) with field length 10

ZINKZ : Exempted from Interest Calculation
Its data type is CHAR (Character String) with field length 2

SVULT : Month-End Indicator for Value Date
Its data type is CHAR (Character String) with field length 1

JSOFVERR : Immediate settlement
Its data type is CHAR (Character String) with field length 1

SINCLVERR : Inclusive Indicator for Clearing Date
Its data type is NUMC (Character String with Digits Only) with field length 1

SULTVERR : Month-End Indicator for Clearing Date
Its data type is CHAR (Character String) with field length 1

SREFZITI : Refer.flow category in accrual/deferral flow records
Its data type is CHAR (Character String) with field length 4

STGBASIS : Base Days Method
Its data type is CHAR (Character String) with field length 1

STGMETH : Daily Method
Its data type is NUMC (Character String with Digits Only) with field length 1

SBASIS : Calculation base reference
Its data type is CHAR (Character String) with field length 4

SBERFIMA : Calculation category for cash flow calculator
Its data type is CHAR (Character String) with field length 4

SVORGKZ : Activity indicator for debit/credit control
Its data type is NUMC (Character String with Digits Only) with field length 2

MANSP : Dunning block
Its data type is CHAR (Character String) with field length 1

DGUEL_KP : Condition Item Valid From
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

NSTUFE : Level number of condition item for recurring payments
Its data type is NUMC (Character String with Digits Only) with field length 2

DBPERIOD : Period start
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SPAEXCL : Exclusive Indicator for Start Date of a Period
Its data type is NUMC (Character String with Digits Only) with field length 1

SPAULT : Month-End Indicator for Start Date of a Period
Its data type is CHAR (Character String) with field length 1

DEPERIOD : Period End
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SPEINCL : Inclusive Indicator for End Date of a Period
Its data type is NUMC (Character String with Digits Only) with field length 1

SPEULT : Month-End Indicator for End of a Period
Its data type is CHAR (Character String) with field length 1

RKONT : Quota number
Its data type is NUMC (Character String with Digits Only) with field length 6

DAUSZ : Lead date for withholding amounts for disbursement
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SSOLIST : Calculation using actual principle (or debit)
Its data type is CHAR (Character String) with field length 1

RDARNEHM : Borrower/Applicant Number
Its data type is CHAR (Character String) with field length 10

BKOND : Condition item currency amount
Its data type is CURR (Currency Field) with field length 13

RZEBEL : Document number of waiver/write-off document
Its data type is CHAR (Character String) with field length 10

ZFBDT : Payment Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DZFEST : Interest rate fixing date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

SBERECH : Grace Period Interest Method
Its data type is CHAR (Character String) with field length 1

BKARZINS : Int.for days betw. redemption clear.and pmnt (FiMa-internal)
Its data type is CURR (Currency Field) with field length 13

BTITALK : Imputed annuity repayment amount (FiMa internal)
Its data type is CURR (Currency Field) with field length 13

HDN_KUNNR : Main Borrower Customer Number
Its data type is CHAR (Character String) with field length 10

SZART : Payment transaction
Its data type is CHAR (Character String) with field length 1

RUZBEL : Accounting Document Number
Its data type is CHAR (Character String) with field length 10

REBZJ : Fiscal Year of the Relevant Invoice (for Credit Memo)
Its data type is NUMC (Character String with Digits Only) with field length 4

REBZG : Number of the Invoice the Transaction Belongs to
Its data type is CHAR (Character String) with field length 10

REBZZ : Line Item in the Relevant Invoice
Its data type is NUMC (Character String with Digits Only) with field length 3

S_SSDREF : Reference flow category in borrower’s note loan flow records
Its data type is CHAR (Character String) with field length 4

SAEND : Change Indicator for FiMa Flow Records
Its data type is NUMC (Character String with Digits Only) with field length 1

XPORE : Indicator: Individual Payment?
Its data type is CHAR (Character String) with field length 1

SPAYRQ : Generate payment request
Its data type is CHAR (Character String) with field length 1

PRKEY : Key Number for Payment Request
Its data type is CHAR (Character String) with field length 10

HKTID : ID for account details
Its data type is CHAR (Character String) with field length 5

VORGTYP : Activity Category (Posting Area)
Its data type is CHAR (Character String) with field length 4

ACENV : Source in TR-LO posting area
Its data type is NUMC (Character String with Digits Only) with field length 4

SSIGN : Direction of flow
Its data type is CHAR (Character String) with field length 1

SPRSNG : Individual payment
Its data type is CHAR (Character String) with field length 1

UZAWE : Payment method supplement
Its data type is CHAR (Character String) with field length 2

SPRGRD : Determine grouping definition
Its data type is CHAR (Character String) with field length 1

SCSPAY : Same direction necessary for joint payment?
Its data type is CHAR (Character String) with field length 1

ZWELS : List of the Payment Methods to be Considered
Its data type is CHAR (Character String) with field length 10

PAYGR : Grouping Field for Automatic Payments
Its data type is CHAR (Character String) with field length 20

JEXPOZINS : Exponential Interest Calculation
Its data type is CHAR (Character String) with field length 1

SREVALEXCL : Price gains w/o proportionate gains from deferral write-back
Its data type is CHAR (Character String) with field length 1

RBO : Business Operation Number (Loans)
Its data type is CHAR (Character String) with field length 15

SROUND : Rounding Category
Its data type is CHAR (Character String) with field length 1

SKALIDWT : Interest Calendar
Its data type is CHAR (Character String) with field length 2

PPAYMENT : Payment Rate
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

AMMRHYZV : Interest Settlement Frequency for Exponential Interest Calc.
Its data type is NUMC (Character String with Digits Only) with field length 2

LC_CAPITALS : Effect of the Flow on Capital Amounts Status
Its data type is CHAR (Character String) with field length 2

LC_DISBURSE : Effect of the Flow on the Disbursement Status
Its data type is CHAR (Character String) with field length 2

OP_APPLICATION : Open Item Tool: Application Key
Its data type is NUMC (Character String with Digits Only) with field length 2

OP_RBO : OI Tool: Locking Business Operation
Its data type is CHAR (Character String) with field length 15

DFAELL_OLD_EXT : Old Due Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DDISPO_OLD_EXT : Old Payment Date
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

RBO_EXT : Business Operation Number (Loans)
Its data type is CHAR (Character String) with field length 15

SBEWEGRP2 : Flow Record Group in Cash Flow Calculator (Incoming Payment)
Its data type is NUMC (Character String with Digits Only) with field length 6

SUSP_REASON_TYPE : Key for Overpayment Reason
Its data type is NUMC (Character String with Digits Only) with field length 3

MNDID : Unique Referene to Mandate per Payment Recipient
Its data type is CHAR (Character String) with field length 35

.INCLUDE : SEPA Remittance Information

REMIT_INFO : SEPA Payment Notes Information
Its data type is CHAR (Character String) with field length 140

.INCLU–AP : Extensions for Localization

BROUNDUNIT : Rounding Unit for Amounts
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 13

.INCLU–AP : Additional Fields for SEPA Direct Debit

SEPA_PD : Posting Date in the Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

VDBEPP related tables

TDA5T : Reason for non-acceptance (texts for TDA5)
TDBUDAT_T : Texts: Default Posting Date
VDRISKCLASS : Risk Classification for Individual Value Adjustment
VDMAP_LABELS : Loans: Mapping Table Data Fields for Descriptions
TZB04 : Flow Type Groups Definition for Cash Flow Display
TD14 : Value table for tax preferential treatment ID
TD47E : Form selection for dunning notices
TD22T : Texts for special arrangement indicators
TDSUBROLE : BP: Business Partner – Role Type
TZFO1 : Definition of release objects
TDO1T : Texts for TD01 Object Construction Methods
VDARLDVS : Print and dispatch control data for VDARL
TDA12 : Loans master data field control
TDDGB : User-specific loans key 2 text table
TVZ03 : Flow control of advance payments and overpayments
VDZNB_SEPA : Recall of SEPA Credit Transfers
VDBOHEAD : Business Operation: Header
VDBEPP : Flow Data – Planned Item
VDHOBJ : Collateral Objects
TDDG1 : Value table 1 User-specific loans key

VDBEPP related transaction codes under SAP package FVVD

FNV0 : Payoff policy contract
FNO2 : Change Object
S_ALR_87004495 : IMG Activity: SIMG_CFMENUFNMCFNDA
S_ALR_87004577 : IMG Activity: DARLART_DEFINIEREN
ACCT_DETER : Report for Account Determination
FNRS : Reversal Accrual/Deferral
FNM1_NODD : Automatic Posting
FNO3 : Display Object
FNM1S_NODD : Automatic Posting – Single
S_ALR_87004848 : IMG Activity: FVV_OBJNR
FNAD : Reactivation of Deleted Policy Offer
S_PLN_16000235 : Query: Balanace List in Display Crcy
FNM3 : Loans reversal module
FN40 : Create other loan interested party
FNI4 : Mortgage Application Withdrawal
FNMD : Submenu General Loans
FNQ5 : Transact.type – Acct determinat.adj.
FNK1 : Loans to Managers (GBA15)
S_ALR_87004629 : IMG Activity: SIMG_CFMENUFNMCFNCB
FW56 : Customizing user-specific loan key

VDBEPP SAP table for – Flow Data – Planned Item

Table VDBEPP technical data

SAP VDBEPP Table Fields

VDBEPP related tables

VDBEPP related transaction codes under SAP package FVVD

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

VDBEPP SAP table for – Flow Data – Planned Item

Table VDBEPP technical data

SAP VDBEPP Table Fields

VDBEPP related tables

VDBEPP related transaction codes under SAP package FVVD

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References