VDBEPI_SHADOW

Shadow Table for VDBEPI (Restrictions) | #transactional | Component: Loans Management
Column Name Description
MANDT Client
BUKRS Company Code
RBELKPFD Document Number of Document Header (Loan)
RPOSNR Activity number
Column Name Description
💲 Currency of nominal amount (SNWHR):
BNWHR Nominal amount
BBASIS Calculation Base Amount
BKOND Condition Item Currency Amount
BKARZINS Int.for days betw. redemption clear.and pmnt (FiMa-internal)
BTITALK Imputed annuity repayment amount (FiMa internal)
💲 Position Currency (Currency of Position Amount) (SBWHR):
BBWHR Amount in position currency
💲 Settlement Currency (SCWHR):
BCWHR Settlement Amount
💲 Currency Key (T001.WAERS):
BHWHR Amount in local currency
Column Name Description
Column Name Description
DVALUT Calculation Date
DFAELL Due date
DDISPO Payment Date
DBESTAND Position value date
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
DTRANS Flow data key: System date
TTRANS Transaction data key: system time
DVERRECH Settlement date
DPKOND Fixing Date of Percentage Rate from Condition
DGUEL_KP Condition Item Effective From
DBPERIOD Period start
DEPERIOD Period End
DAUSZ Lead date for withholding amounts for disbursement
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DZFEST Interest rate fixing date
DFAELL_OLD_EXT Old Due Date
DDISPO_OLD_EXT Old Payment Date
BILL_DUE_DATE Due Date for Bill
Column Name Description
SSPESEN Expenses key Show values
SSOLHAB Debit/credit indicator Show values
JFDUPD Record transferred to cash management and forecast Show values
JONLAEN Indicator for fixing a flow record Show values
JZINSBAS Flow in interest base Show values
JZINSZPT Interest date Show values
JEINBEHALT Indicator for Withholding of Amount During Disbursement Show values
JFIRUECK Confirmation From FI Not Necessary Show values
MWART Tax Type Show values
SZBMETH Interest Calculation Method Show values
JSTOCK Premium reserve fund-relevant indicator Show values
SEXCLVON Exclusive Indicator for the Start of a Calculation Period Show values
SULTVON Month-End Indicator for Start of a Calculation Period Show values
SINCLBIS Inclusive Indicator for the End of a Calculation Period Show values
SULTBIS Month-End Indicator for the End of a Calculation Period Show values
SINCL Inclusive indicator for beginning and end of a period Show values
ZINKZ Exempted from Interest Calculation Show values
SVULT Month-End Indicator for Value Date Show values
JSOFVERR Immediate settlement Show values
SINCLVERR Inclusive Indicator for Clearing Date Show values
SULTVERR Month-End Indicator for Clearing Date Show values
STGBASIS Base Days Method Show values
STGMETH Daily Method Show values
SVORGKZ Activity indicator for debit/credit control Show values
SPAEXCL Exclusive Indicator for Start Date of a Period Show values
SPAULT Month-End Indicator for Start Date of a Period Show values
SPEINCL Inclusive Indicator for End Date of a Period Show values
SPEULT Month-End Indicator for End of a Period Show values
SSTCKKZ Accrued interest method Show values
SBERECH Grace Period Interest Method Show values
SZART Payment Transaction Show values
XPORE Indicator: Individual Payment? Show values
SPAYRQ Generate Payment Request Show values
VORGTYP Activity Category (Posting Area) Show values
ACENV Source in TR-LO posting area Show values
SSIGN Direction of Flow Show values
SPRSNG Individual Payment Show values
SPRGRD Determine Grouping Definition Show values
SCSPAY Same Direction Necessary for Joint Payment? Show values
JEXPOZINS Type of Compound Interest Calculation Show values
SREVALEXCL Price gains w/o proportionate gains from deferral write-back Show values
SROUND Rounding Category Show values
JVERF Indicator whether drawings exist for the disbursement Show values
AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. Show values
JAVGCAP Use Upper Limit of Average Interest Rate Show values
JAVGFLOOR Use Lower Limit of Average Interest Rate Show values
SROUNDAVGINTEREST Rounding Category of Average Interest Rate Show values
JEXPOINTFACTOR Exponential Interest Calculation with Factor Show values
SFACTORRESET Event for Resetting Factor Calculation Show values
Column Name Description Domain name
SBEWART Flow Type SBEWART
SREFBEW Reference flow type SBEWART
SBEWZITI Flow category SBEWZITI
PKKURS Purchase Price of Borrower's Note PWKURS
PRUCK Repayment rate in percent DEC3_7
KURS1 Exchange rate KURSF
KURS2 Exchange rate KURSF
UMSKZ Special G/L Indicator UMSKZ
KOSTL Cost Center KOSTL
RSOLL Account for debit posting SAKNR
RHABEN Account for credit posting SAKNR
RZKSOLL Debit interim account SAKNR
RZKHABE Credit interim account SAKNR
SBSLSOLL Posting Key BSCHL
SBSLZKSO Posting Key BSCHL
SBSLZKHA Posting Key BSCHL
SHSLHABEN Posting Key BSCHL
BUCHTXT Item Text TEXT50
RBANKK Bank account SAKNR
SFDLEV Planning Level FDLEV
PKOND Percentage rate for condition items DECV3_7
SSORTZIT Sort indicator for interest/repayment schedule calculations CHAR1
SWOHER Source of flow record CHAR1
KUNNR Customer Number KUNNR
BVTYP Partner bank type BVTYP
ZLSCH Payment Method ZLSCH
MABER Dunning Area MABER
ZAHLS Block Key for Payment ZAHLS
RPARTNR Business Partner Number BU_PARTNER
SROLEXT Dummy function CHAR3
MWSKZ Tax on sales/purchases code MWSKZ
ATAGE Number of Days INT6
ABASTAGE Number of base days in a calculation period INT6
SBUST Posting Control Key VVSBUST
NTRANS Transaction data key: Consecutive number NUMC4
GSBER Business Area GSBER
SKOART Condition Type (Smallest Subdivision of Condition Records) SKOART
SBUCHA Indicator for postings to accruals/deferrals accounts CHAR1
SREFZITI Refer.flow category in accrual/deferral flow records SBEWZITI
SBASIS Calculation base reference VVSBASIS
SGTXT Item Text TEXT50
SBERFIMA Calculation category for cash flow calculator SBEWFIMA
MANSP Dunning Block MANSP
NSTUFE Level number of condition item for recurring payments NUMC2
NORDER Order Number NUM8
RKONT Quota number RKONT
SSOLIST Calculation using actual principle (or debit) CHAR1
RDARNEHM Borrower/Applicant Number BU_PARTNER
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
HDN_KUNNR Main Borrower Customer Number KUNNR
RUZBEL Document Number of an Accounting Document BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZZ Line Item in the Relevant Invoice BUZEI
S_SSDREF Reference flow category in borrower's note loan flow records SBEWZITI
PWKURS Security price for percentage quotation PWKURS
PRKEY Key Number for Payment Request PRQ_KEYNO
HBKID Short Key for a House Bank HBKID
HKTID ID for Account Details HKTID
UZAWE Payment method supplement UZAWE
PAYGR Grouping Field for Automatic Payments CHAR20
SKALIDWT Interest Calendar WFCID
PPAYMENT Payment Rate TFM_PPAYMENT
LC_CAPITALS Effect of the Flow on Capital Amounts Status T_LC_CASH_FLOW
LC_DISBURSE Effect of the Flow on the Disbursement Status T_LC_CASH_FLOW
RBO_EXT Business Operation Number (Loans) RBO
SBEWEGRP2 Flow Record Group in Cash Flow Calculator (Incoming Payment) SBEWEGRP2
SUSP_REASON_TYPE Key for Overpayment Reason T_SUSPREASON
BILL_NUMBER Bill Number T_BILL_NUMBER
MNDID Unique Reference to Mandate for each Payee ID035
REMIT_INFO Payment Notes Info T_REMIT_INFO_LC
AAVGDAYS No. of Days for Interest Calc. with Average Interest Rate INT4
PAVGINTEREST Average Interest Rate DECV5_10
PAVGCAP Upper Limit of Average Interest Rate DECV5_10
PAVGFLOOR Lower Limit of Average Interest Rate DECV5_10
PAVGSPREAD Average Interest Rate Spread DECV5_10
ROUNDDECAVGINTEREST Number of Rounding Decimal Places for Average Interest Rate TFM_ROUNDDECIMALS
AAVGWEIGHT Weighting of Interest Rate INT4
AAVGWEIGHTSUM Cumulative Weighting of Interest Rate INT4
FLOWFACTOR Flow Factor TFM_FACTOR
BASEFACTOR Base Factor TFM_FACTOR
PNON_CUMULATIVE_RATE Non Cumulative Rate DECV5_10