SAP VDIOA_CALC_DET Progress (Interest) of Model Account IOA Calculation Table
Overview
VDIOA_CALC_DET is a standard SAP S/4HANA table that stores Progress (Interest) of Model Account IOA Calculation data. There are total 64 fields in the VDIOA_CALC_DET table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDIOA_CALC_DET belongs to Accounting (FS-CML-AC) module and is located in the package Calculation of Interest on Arrears for Consumer Loans (FVVCL_IOA).
In addition, following links provide an overview of foreign key relationships, if any, that link VDIOA_CALC_DET to other SAP tables and standard CDS views available based on VDIOA_CALC_DET table in S/4HANA 2020.
Techincal Settings of VDIOA_CALC_DET
Below are technical details of the table VDIOA_CALC_DET
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDIOA_CALC_DET Fields
The following table gives you an overview of the fields available in VDIOA_CALC_DET
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | |
| RANL | Contract Number | RANL | CHAR | 13 | |
| RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| VZ_DBERVON | Start Date of Interest on Arrears Calculation (Exclusive) | TB_IOA_CALC_FROM | DATS | 8 | |
| BEWART_GRUPPE | Flow Type Grouping | TB_IOA_FLOW_TYPE_GROUPING | * | CHAR | 4 |
| DBERVON | From Date for Flow Type Grouping for Interest on Arrears | TB_CALC_DATE_FROM_BAL_GRADIENT | DATS | 8 | |
| DBERBIS | End Date of Calculation Period for Interest on Arrears | TB_CALCULATION_DATE_TO | DATS | 8 | |
| AUT_NK | Indicator for Automatic Recalcilation | TB_FLG_AUT_RECALC | CHAR | 1 | |
| SSTORNO | Reversal indicator | SSTORNO | CHAR | 1 | |
| SPLANIST | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 1 | |
| SREFBEW | Reference flow type | SREFBEW | * | CHAR | 4 |
| SBEWZITI | Flow category | SBEWZITI | * | CHAR | 4 |
| SREFZITI | Refer.flow category in accrual/deferral flow records | VVSREFZITI | * | CHAR | 4 |
| S_SSDREF | Reference flow category in borrower's note loan flow records | VVS_SSDREF | * | CHAR | 4 |
| SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | VVSREVALEXCL | CHAR | 1 | |
| SWOHER | Source of flow record | SWOHER | CHAR | 1 | |
| DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | * | NUMC | 4 |
| SVORGANG | Business Operation (Activity) | SVORFALL | CHAR | 4 | |
| ACENV | Source in TR-LO posting area | ACENV_LO | NUMC | 4 | |
| NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | |
| SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 2 | |
| SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | |
| SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | * | CHAR | 4 |
| SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 1 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | |
| STGBASIS | Base Days Method | VVSTGBASIS | CHAR | 1 | |
| ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| DPKOND | Fixing Date of Percentage Rate from Condition | VVDPKOND | DATS | 8 | |
| SBASIS | Calculation Base Indicator | SBASIS | * | CHAR | 4 |
| JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | |
| SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | |
| SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | |
| SBEWART | Flow Type | SBEWART | * | CHAR | 4 |
| SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | |
| SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | |
| ATAGE | Number of Days | VVATAGE | NUMC | 6 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| DDISPO | Payment Date | DDISPO | DATS | 8 | |
| DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | |
| SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | |
| SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | |
| DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | |
| SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | |
| SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | |
| DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| SNWHR | Currency of nominal amount | SNWHR | * | CUKY | 5 |
| BNWHR | Nominal amount | BNWHR | CURR | 13 | |
| SBWHR | Position Currency (Currency of Position Amount) | SBWHR | * | CUKY | 5 |
| BBWHR | Amount in position currency | BBWHR | CURR | 13 | |
| SCWHR | Settlement Currency | SCWHR | * | CUKY | 5 |
| BCWHR | Settlement Amount | BCWHR | CURR | 13 | |
| BHWHR | Amount in local currency | BHWHR | CURR | 13 | |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10 | |
| SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | |
| DBPERIOD | Period start | VVDBPERIOD | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDIOA_CALC_DET
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDIOA_CALC_DET | BUKRS | 1: CN | T001 |
| VDIOA_CALC_DET | MANDT | 1: CN | T000 |