SAP VDCAPITAL Data for Capitalization of Overdue Items Table
Overview
VDCAPITAL is a standard SAP S/4HANA table that stores Data for Capitalization of Overdue Items data. There are total 57 fields in the VDCAPITAL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDCAPITAL belongs to Portfolio (FS-CML-PO) module and is located in the package Payment Agreements (Deferral / Capitalization) (FVVCL_DEFCAP).
In addition, following links provide an overview of foreign key relationships, if any, that link VDCAPITAL to other SAP tables and standard CDS views available based on VDCAPITAL table in S/4HANA 2020.
Techincal Settings of VDCAPITAL
Below are technical details of the table VDCAPITAL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDCAPITAL Fields
The following table gives you an overview of the fields available in VDCAPITAL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | |
| RANL | Contract Number | RANL | CHAR | 13 | |
| RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | |
| SBO_CAT | Business Operation Category | SBO_CAT | CHAR | 1 | |
| SBO_STATUS | Bus. operation status | TB_SBOSTATUS | CHAR | 1 | |
| SBO_STATUS_OLD | Loans: Business operation status | SBO_STATUS | CHAR | 1 | |
| XBO_TEXT | Text for Business Operation | XBOTEXT | CHAR | 30 | |
| SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | |
| SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | |
| UCURR | Position Currency (Currency of Position Amount) | SBWHR | * | CUKY | 5 |
| AARRBAL | Total Amount of Overdue Items | TB_ARRBALANCE | CURR | 13 | |
| AFUDUPAY | Total Amount for Payments Due in the Future | TB_FUDUPAY | CURR | 13 | |
| ACAPRECS | Total Amount of Receivables to Be Included in Loan | TB_CAPRECS | CURR | 13 | |
| ACREBAL | Total Amount of Credit | TB_CREBAL | CURR | 13 | |
| ABALNUIT | Total Amount of Non-Selected Items | TB_BALNUIT | CURR | 13 | |
| ABALNCPRECS | Total Amount of Receivables Not Included in Loan | TB_BALNCPRECS | CURR | 13 | |
| IINCL_KYDTE | Term Including Key Date | TB_INCLKYDTE | CHAR | 1 | |
| IULTI_KYDTE | Key Date Must Be Last Day of the Month | TB_ULTIKYDTE | CHAR | 1 | |
| DPAYM_TO | Payments to | TB_PAYM_TO | DATS | 8 | |
| INOTE_ASSIGNED | Memo Exists | TB_IND_NOTE_ASSIGNED | CHAR | 1 | |
| APRCCHRGE | Processing Charge for Deferral or Capitalization | TB_PRCCHRGE | CURR | 13 | |
| ICAPITAL | Include Processing Charge in Loan | TB_ICAPITAL | CHAR | 1 | |
| IDEVIATE_PAYM | Alternative Payment Information in Additional Flows | TB_DEVIATE_PAYM | CHAR | 1 | |
| MNORISKMS | Number of Risk-Increasing Measures | TB_NORISKMS | NUMC | 2 | |
| IOA_AMOUNT | Interest on Arrears Calculated | TB_IOA_CALCULATION_RESULT | CURR | 13 | |
| MPOSTTYPE | Posting Control | TB_DEFCAPPOSTTYPE | TZB09 | NUMC | 2 |
| IDUNNBLCK | Dunning Block for Items for Deferral or Capitalization | TB_DUNNBLCK | T040S | CHAR | 1 |
| IIOABLCK | Interest on Arrears Block for Items for Deferral/Capitaliz. | TB_IOABLCK | CHAR | 2 | |
| IDUBLDEFI | Dunning Block for Deferral Installments | TB_DUBLDEFR | T040S | CHAR | 1 |
| IIOABLDEFI | Interest on Arrears Block for Deferral Installments | TB_IOADEFI | CHAR | 2 | |
| IPAYBLCK | Payment Block for Deferral Installments | TB_PAYBLCK | T008 | CHAR | 1 |
| DOFFER_FR | Creation Date for the Offer | TB_OFFER_FR | DATS | 8 | |
| DOFFER_TO | End of the Validity Period of the Offer | TB_OFFER_TO | DATS | 8 | |
| DACCEPT | Acceptance Date of the Offer | TB_ACCEPT | DATS | 8 | |
| MCAPREASON | Key for Reason for Capitalization | TB_CAPREASON | TDCAP_REASON | NUMC | 3 |
| ACAPITALI | Capitalization Amount | TB_CAPAMO | CURR | 13 | |
| DCAPKYDTE | Key Date for Capitalization of Overdue Items | TB_CAPKYDTE | DATS | 8 | |
| DENDPROPO | New End of Term | TB_ENDPROPO | DATS | 8 | |
| AINSTPROPO | New Figure for Payment Installments | TB_INSTPROPO | CURR | 13 | |
| PKAPEFFINTRT | Effective Interest Based on Capitalization of Overdue Items | TB_KAPEFFINTRT | DEC | 10 | |
| MKAPEFFINTMT | Capitalization of Overdue Items: Effective Interest Method | TB_KAPEFFINTMT | NUMC | 1 | |
| DENDWOCAP | End of Term Without Capitalization of Overdue Items | TB_ENDWOCAP | DATS | 8 | |
| AINSTWOCAP | Payment Installment Amount w/o Capitalizn of Overdue Items | TB_INSTWOCAP | CURR | 13 | |
| DFIRST_DISB | Field of type DATS | DATS | DATS | 8 | |
| DOEFFINTPYMNP | Key Date for Last Change to Installment Plan | TB_MODEL_DATE_LAST_PAYMENTPLAN | DATS | 8 | |
| OEFFINTPYMNP | Effective Interest Rate for Last Change to Installment Plan | TB_MODEL_EFFECTIV_INTERSTS_PPC | DEC | 10 | |
| NMAXTERM | Number of Times Units for Maximum Term of Contract | TB_PROD_TERM_MAX_VALUE | NUMC | 4 | |
| AREIMBURSEMENT | Credit Life Insurance Reimbursement | TB_CLI_RECALC_CONTR | CURR | 13 | |
| AINSURANCE_CONTR | Single Premium for Credit Life Insurance | TB_CLI_INSURANCE | CURR | 13 | |
| ADIFFERENCE | Calculated Difference for Credit Life Insurance | TB_LOLIINBAL | CURR | 13 | |
| ICONSIDER | Transfer CLI Difference | TB_ICONSIDER | CHAR | 1 | |
| CALCULATION_DATE | CLI: Key Date for Calculation of Credit Life Insurance | TB_CLI_CALCULATION_DATE | DATS | 8 | |
| UCLICURR | Position Currency (Currency of Position Amount) | SBWHR | * | CUKY | 5 |
| CLI_FLOW_SBEWART | Flow Type | SBEWART | * | CHAR | 4 |
| CLI_CHANGED | Checkbox | XFELD | CHAR | 1 |
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 VDCAPITAL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDCAPITAL | ICAPMANUPROC | : | TDCAP_POSTPR |
| VDCAPITAL | IDUBLDEFI | : | T040S |
| VDCAPITAL | IDUNNBLCK | : | T040S |
| VDCAPITAL | IPAYBLCK | : | T008 |
| VDCAPITAL | MANDT | : | T000 |
| VDCAPITAL | MCAPREASON | : | TDCAP_REASON |
| VDCAPITAL | MPOSTTYPE | : | TZB09 |