VDBEPP SAP table for – Flow Data – Planned Item

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

TableVDBEPP
Data storingFlow Data – Planned Item
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

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