VDIOA_CALC_DET

Progress (Interest) of Model Account IOA Calculation | #masterdata | Component: Accounting
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SARCHIV Archiving Category Indicator
RANL Contract Number
RBO Business Operation Number (Loans)
VZ_DBERVON Start Date of Interest on Arrears Calculation (Exclusive)
BEWART_GRUPPE Flow Type Grouping
DBERVON From Date for Flow Type Grouping for Interest on Arrears
DBERBIS End Date of Calculation Period for Interest on Arrears
AUT_NK Indicator for Automatic Recalcilation Show values
Column Name Description
💲 Currency of nominal amount (TRDC_REC.SNWHR):
BNWHR Nominal amount
BBASIS Calculation Base Amount
💲 Position Currency (Currency of Position Amount) (TRDC_REC.SBWHR):
BBWHR Amount in position currency
💲 Settlement Currency (TRDC_REC.SCWHR):
BCWHR Settlement Amount
💲 Currency Key (T001.WAERS):
BHWHR Amount in local currency
Column Name Description
Column Name Description
VZ_DBERVON Start Date of Interest on Arrears Calculation (Exclusive)
DBERVON From Date for Flow Type Grouping for Interest on Arrears
DBERBIS End Date of Calculation Period for Interest on Arrears
DGUEL_KK Date Condition Effective from
DPKOND Fixing Date of Percentage Rate from Condition
DVALUT Calculation Date
DFAELL Due date
DDISPO Payment Date
DEPERIOD Period End
DVERRECH Settlement date
DBUDAT Posting Date in the Document
DBPERIOD Period start
Column Name Description
AUT_NK Indicator for Automatic Recalcilation Show values
SSTORNO Reversal indicator Show values
SPLANIST Plan/actual record/record to be released indicator Show values
SREVALEXCL Price gains w/o proportionate gains from deferral write-back Show values
ACENV Source in TR-LO posting area Show values
SVORGKZ Activity indicator for debit/credit control Show values
SSOLHAB Debit/credit indicator Show values
SSTCKKZ Accrued interest method Show values
SZBMETH Interest Calculation Method Show values
STGMETH Daily Method Show values
STGBASIS Base Days Method Show values
JSOFVERR Immediate settlement Show values
SINCL Inclusive indicator for beginning and end of a period Show values
SVULT Month-End Indicator for Value Date 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
SPEINCL Inclusive Indicator for End Date of a Period Show values
SPEULT Month-End Indicator for End of a Period Show values
SINCLVERR Inclusive Indicator for Clearing Date Show values
SULTVERR Month-End Indicator for Clearing Date Show values
SEFFMETH Effective Interest Method (Financial Mathematics) 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
SREFBEW Reference flow type SBEWART
SBEWZITI Flow category SBEWZITI
SREFZITI Refer.flow category in accrual/deferral flow records SBEWZITI
S_SSDREF Reference flow category in borrower's note loan flow records SBEWZITI
SWOHER Source of flow record CHAR1
SKOART Condition Type (Smallest Subdivision of Condition Records) SKOART
SVORGANG Business Operation (Activity) SVORFALL
NSTUFE Level number of condition item for recurring payments NUMC2
SBERFIMA Calculation category for cash flow calculator SBEWFIMA
ABASTAGE Number of base days in a calculation period INT6
PKOND Percentage rate for condition items DECV3_7
SBASIS Calculation Base Indicator VVSBASIS
SBEWART Flow Type SBEWART
ATAGE Number of Days INT6
PEFFZINS Effective Interest Rate DEC3_7
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
Master Data Relations Join Conditions
Company Code
  • VDIOA_CALC_DET.MANDT == T001.MANDT
  • VDIOA_CALC_DET.BUKRS == T001.BUKRS
Client VDIOA_CALC_DET.MANDT == T000.MANDT