VDBEPI_SHADOW SAP table for – Shadow Table for VDBEPI (Restrictions)

Here we would like to draw your attention to VDBEPI_SHADOW 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). VDBEPI_SHADOW is a SAP standard transp table used for storing Shadow Table for VDBEPI (Restrictions) related data in SAP. It comes under the package FVVD.

SAP VDBEPI_SHADOW table

Table VDBEPI_SHADOW technical data

TableVDBEPI_SHADOW
Data storingShadow Table for VDBEPI (Restrictions)
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDBEPI_SHADOW 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 VDBEPI_SHADOW table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Flow Data (Key Fields VDBEPI)
    Its a key field.
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RBELKPFD : Document Number of Document Header (Loan)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • RPOSNR : Activity number
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : Include for VDBEPI
  • 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
  • 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
  • PKKURS : Purchase Price of Borrower’s Note
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PRUCK : Repayment rate in percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • 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
    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
  • 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
  • SSOLHAB : Debit/credit indicator
    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
  • BUCHTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • 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
  • 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
  • JEINBEHALT : Indicator for Withholding of Amount During Disbursement
    Its data type is CHAR (Character String) with field length 1
  • JFIRUECK : Confirmation From FI Not Necessary
    Its data type is CHAR (Character String) with field length 1
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • MWART : Tax Type
    Its data type is CHAR (Character String) with field length 1
  • 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
  • JSTOCK : Premium reserve fund-relevant indicator
    Its data type is CHAR (Character String) with field length 1
  • SBUST : Posting control key
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTRANS : Flow data key: System date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TTRANS : Transaction data key: system time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • NTRANS : Transaction data key: Consecutive number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • 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
  • SBUCHA : Indicator for postings to accruals/deferrals accounts
    Its data type is CHAR (Character String) with field length 1
  • 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
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • 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
  • SSTCKKZ : Accrued interest method
    Its data type is CHAR (Character String) with field length 1
  • NORDER : Order Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • 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
  • 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
  • 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
  • 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
  • PWKURS : Security price for percentage quotation
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • DZFEST : Interest rate fixing date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • 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
  • HBKID : Short key for a house bank
    Its data type is CHAR (Character String) with field length 5
  • 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
  • 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
  • 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
  • JVERF : Indicator whether drawings exist for the disbursement
    Its data type is CHAR (Character String) with field length 1
  • 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
  • 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
  • BILL_NUMBER : Bill Number
    Its data type is CHAR (Character String) with field length 15
  • BILL_DUE_DATE : Due Date for Bill
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • 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