SAP VDDEFERRAL Deferral Data Table
Overview
VDDEFERRAL is a standard SAP S/4HANA table that stores Deferral Data data. There are total 54 fields in the VDDEFERRAL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDDEFERRAL 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 VDDEFERRAL to other SAP tables and standard CDS views available based on VDDEFERRAL table in S/4HANA 2020.
Techincal Settings of VDDEFERRAL
Below are technical details of the table VDDEFERRAL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDDEFERRAL Fields
The following table gives you an overview of the fields available in VDDEFERRAL
| 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 | |
| MDEFREASON | Reason for Deferral: Key | TB_DEFREASON | TDDEF_REASON | NUMC | 3 |
| ADEFERR | Deferral Amount | TB_DEFAMO | CURR | 13 | |
| DDEFKYDTE | Key Date for Deferral | TB_DEFKYDTE | DATS | 8 | |
| PDEFINTRT | Interest Rate for the Deferral | TB_DEFINTRT | DEC | 10 | |
| MINTDYMT | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| DFRSTDUDTE | Due Date of First Installment Payment for Deferral Plan | TB_FRSDUDTE | DATS | 8 | |
| IULTIDUDTE | Due Date Is Always on the Last Day of the Month | TB_ULTIDUDTE | CHAR | 1 | |
| IINCLDUDTE | Including Due Date | TB_INCLDUDTE | CHAR | 1 | |
| MWRKDYRL | Working Day Shift for Calculation Day | TB_SVWERK | NUMC | 1 | |
| MPUHOLCAL | Factory calendar | SKALID | * | CHAR | 2 |
| IFREEPAYM | Custom Deferral Plan | TB_FREEPAYM | CHAR | 1 | |
| MPARTKUNNR | Customer Number | KUNNR | * | CHAR | 10 |
| MPARTNER | Business Partner Number for Payer of Deferral Installments | TB_DEFPARTNER | * | CHAR | 10 |
| MBANKTYPE | Bank Details ID for Deferral Installments | TB_DEFBVTYP | CHAR | 4 | |
| MPAYMTHD | Payment Method for Deferral Installments | TB_DEFPYMTD | * | CHAR | 1 |
| PEFFINTRT | Effective Interest Rate for Deferral Agreement | TB_EFFINTRT | DEC | 10 | |
| MEFFINTMT | Effective Interest Method for Deferral Agreement | TB_EFFINTMT | NUMC | 1 | |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 |
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 VDDEFERRAL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDDEFERRAL | IDEFMANUPROC | : | TDDEF_POSTPR |
| VDDEFERRAL | IDUBLDEFI | : | T040S |
| VDDEFERRAL | IDUNNBLCK | : | T040S |
| VDDEFERRAL | IPAYBLCK | : | T008 |
| VDDEFERRAL | MANDT | : | T000 |
| VDDEFERRAL | MDEFREASON | : | TDDEF_REASON |
| VDDEFERRAL | MPOSTTYPE | : | TZB09 |