1. SAP Tutorial
  2. Financial Services

VDIOA_CALC_DET SAP table for – Progress (Interest) of Model Account IOA Calculation

Here we would like to draw your attention to VDIOA_CALC_DET 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). VDIOA_CALC_DET is a SAP standard transp table used for storing Progress (Interest) of Model Account IOA Calculation related data in SAP. It comes under the package FVVCL_IOA.

SAP VDIOA_CALC_DET table

Table VDIOA_CALC_DET technical data

TableVDIOA_CALC_DET
Data storingProgress (Interest) of Model Account IOA Calculation
ModuleFS
Sub ModuleFS-CML-AC
SAP PackageFVVCL_IOA
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDIOA_CALC_DET 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 VDIOA_CALC_DET 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
  • SARCHIV : Archiving Category Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RANL : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • RBO : Business Operation Number (Loans)
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • VZ_DBERVON : Start Date of the Interest on Arrears Calculation (Excl.)
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEWART_GRUPPE : Flow Type Grouping
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DBERVON : From Date for Flow Type Grouping for Interest on Arrears
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBERBIS : End Date of Calculation Period for Interest on Arrears
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUT_NK : Indicator for Automatic Recalcilation
    Its a key field. 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
  • .INCLUDE : Interest on Arrears Calc.: Include for Fields Table CALC_DET
  • SPLANIST : Plan/actual record/record to be released indicator
    Its data type is CHAR (Character String) with field length 1
  • 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
  • SREFZITI : Refer.flow category in accrual/deferral flow records
    Its data type is CHAR (Character String) with field length 4
  • S_SSDREF : Reference flow category in borrower’s note loan flow records
    Its data type is CHAR (Character String) with field length 4
  • SREVALEXCL : Price gains w/o proportionate gains from deferral write-back
    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
  • DGUEL_KK : Date Condition Effective from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKOART : Condition Type (Smallest Subdivision of Condition Records)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SVORGANG : Business Operation (Activity)
    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
  • NSTUFE : Level number of condition item for recurring payments
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SVORGKZ : Activity indicator for debit/credit control
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SSOLHAB : Debit/credit indicator
    Its data type is CHAR (Character String) with field length 1
  • SBERFIMA : Calculation category for cash flow calculator
    Its data type is CHAR (Character String) with field length 4
  • SSTCKKZ : Accrued interest method
    Its data type is CHAR (Character String) with field length 1
  • SZBMETH : Interest Calculation 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
  • STGBASIS : Base Days Method
    Its data type is CHAR (Character String) with field length 1
  • ABASTAGE : Number of base days in a calculation period
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PKOND : Percentage rate for condition items
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • DPKOND : Determination date for percentage rate of condition items
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SBASIS : Calculation base indicator
    Its data type is CHAR (Character String) with field length 4
  • JSOFVERR : Immediate settlement
    Its data type is CHAR (Character String) with field length 1
  • DVALUT : Calculation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SINCL : Inclusive indicator for beginning and end of a period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SVULT : Month-End Indicator for Value Date
    Its data type is CHAR (Character String) with field length 1
  • 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
  • SBEWART : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • 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
  • ATAGE : Number of days
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • 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
  • 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
  • DVERRECH : Settlement date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • 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
  • DBUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SNWHR : Currency of nominal amount
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BNWHR : Nominal amount
    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
  • BBWHR : Amount in position currency
    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
  • BCWHR : Settlement Amount
    Its data type is CURR (Currency Field) with field length 13
  • BHWHR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • BBASIS : Calculation base amount
    Its data type is CURR (Currency Field) with field length 13
  • 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
  • DBPERIOD : Period start
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

    • VDIOA_CALC_DET related tables

    • TDIOA_NOPOSTCALC : Flow Types Without Recalculation
    • TDIOA_TEMPL : Template for Interest On Arrears Calculation
    • VDIOA_CALC_DET : Progress (Interest) of Model Account IOA Calculation
    • TDIOA_SCHEME_DEF : Profile Definition for Interest on Arrears Calculation
    • TDIOA_FT_BALANCE : Assignment of Flows to Flow Type Grouping – IOA Calculation
    • TDIOA_TRIV_AMT : Trivial Amount per Currency and Profile IOA Calculation
    • TDIOA_BAL_COND : Assignment Condition Type to Flow Type Grouping – IOA Calc.
    • VDIOA_CALC_CF : Original Documents Without Model Account Int. on Arrears
    • TDIOA_SCHEME_BAL : Assignment of Product Type to Profile and Flow Type Grouping
    • TDIOA_TEMPLTXT : Template Texts for Interest on Arrears Calculation
    • TDIOA_SCHEMET : Text Table for Profile Definition IOA Calculation
    • TDIOA_GSTEER : General Control Data for Interest on Arrears Calculation
    • TDIOA_BO : Interest on Arrears Active in BO Interest on Arrears Calc.
    • VDIOA_CALC_HEAD : Calculation Details for Interest on Arrears Calculation

    Related References

    Related Tutorials

    VDIOA_CALC_HEAD SAP table for – Calculation Details for Interest on Arrears Calculation

    VDIOA_CALC_HEAD table in SAP FS (Loans Management in FS) module. This table is used for storing data of Calculation Details...

    TDIOA_TRIV_AMT SAP table for – Trivial Amount per Currency and Profile IOA Calculation

    TDIOA_TRIV_AMT table in SAP FS (Loans Management in FS) module. This table is used for storing data of Trivial Amount...

    TDIOA_TEMPL SAP table for – Template for Interest On Arrears Calculation

    TDIOA_TEMPL table in SAP FS (Loans Management in FS) module. This table is used for storing data of Template for...

    TDIOA_SCHEME_DEF SAP table for – Profile Definition for Interest on Arrears Calculation

    TDIOA_SCHEME_DEF table in SAP FS (Loans Management in FS) module. This table is used for storing data of Profile Definition...

    TDIOA_FT_BALANCE SAP table for – Assignment of Flows to Flow Type Grouping – IOA Calculation

    TDIOA_FT_BALANCE table in SAP FS (Loans Management in FS) module. This table is used for storing data of Assignment of...

    DFKKIAPT SAP table for – Interest Calculation: Log for Interest Run

    DFKKIAPT table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    VDIOA_CALC_CF SAP table for – Original Documents Without Model Account Int. on Arrears

    VDIOA_CALC_CF table in SAP FS (Loans Management in FS) module. This table is used for storing data of Original Documents...

    «
    »