VDREPAYMENT SAP (Payoff Master Data) Table details
Dictionary Type: Table
Description: Payoff Master Data
Description: Payoff Master Data
Table field list including key, data, relationships and ABAP select examples
VDREPAYMENT is a standard SAP Table which is used to store Payoff Master Data data and is available within R/3 SAP systems depending on the version and release level.
The VDREPAYMENT table consists of various fields, each holding specific information or linking keys about Payoff Master Data data available in SAP. These include BUKRS (Company Code), SARCHIV (Archiving Category Indicator), RANL (Contract Number), RBO (Business Operation Number (Loans)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VDREPAYMENT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
SARCHIV | Archiving Category Indicator | SARCHIV | CHAR | 1 | SARCHIV | ARC | |||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RBO | Business Operation Number (Loans) | RBO | CHAR | 15 | RBO | ||||
SBO_STATUS | Bus. operation status | TB_SBOSTATUS | CHAR | 1 | SBO_STATUS | ||||
SFGKZ | Release Workflow Indicator for the Business Operation | TB_SFGKZA | CHAR | 1 | T_SFGKZ | ||||
SRELSTAT | Internal Release Status in the Business Operations | TB_SRELSTAT | CHAR | 1 | T_SRELSTAT | ||||
SNOTIZ | Indicator for stored memo | SNOTIZ | CHAR | 1 | JANEI | ||||
DFAELL | Due Date of Business Operation | TB_DFAELLR | DATS | 8 | DATUM | ||||
BRVWR | Available Capital on Due Date | TB_BRVWR | CURR | 15(2) | WERTV8_TR | ||||
DEFSZ | Date of End of Fixed-Rate Period | TB_REPAY_DEFSZ | DATS | 8 | DATUM | ||||
BRPWR | Remaining Capital at the End of the Fixed Period | TB_BRPWR | CURR | 15(2) | WERTV8_TR | ||||
SBOTERM | Repayment Change During Partial Payoff | TB_SBOTERM | CHAR | 1 | T_SBO_TERM | ||||
XTEXT | Text (15 characters) | TEXT15 | CHAR | 15 | TEXT15 | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
SBRUTTO | Gross procedure | TB_SBRUTTO | CHAR | 1 | JFLAGG | ||||
SNETTO | Net procedure | TB_SNETTO | CHAR | 1 | JFLAGG | ||||
BBBWHR | Gross Payoff Amount | TB_BBBWHR | CURR | 13(2) | WERTV7 | ||||
BCWHR | Net Payoff Amount | TB_BBNWHR | CURR | 13(2) | WERTV7 | ||||
BADDFLOWS | Other Flows | TB_ADDFLOWS | CURR | 13(2) | WERTV7 | ||||
BOVERDUE_ITEMS | Overdue Items | TB_OVERDUE_ITEMS | CURR | 13(2) | WERTV7 | ||||
BCREDITS | Credit Balance | TB_CREDITS | CURR | 13(2) | WERTV7 | ||||
BPROPPAYMENTS | Proportional Payments | TB_PROPPAYMENTS | CURR | 13(2) | WERTV7 | ||||
BDEFPAYMENTS | Deferred Payments | TB_DEFPAYMENTS | CURR | 13(2) | WERTV7 | ||||
BREGPAYMENTS | Regular Payments | TB_REGPAYMENTS | CURR | 13(2) | WERTV7 | ||||
BFELD1 | Amount Field 1 | TB_FELD1 | CURR | 13(2) | WERTV7 | ||||
BFELD2 | Amount Field 2 | TB_FELD2 | CURR | 13(2) | WERTV7 | ||||
BFELD3 | Amount Field 3 | TB_FELD3 | CURR | 13(2) | WERTV7 | ||||
BFELD4 | Amount Field 4 | TB_FELD4 | CURR | 13(2) | WERTV7 | ||||
BOUTSTANDING | Payments Outstanding Until Payoff Due Date | TB_OUTSTANDING | CURR | 13(2) | WERTV7 | ||||
IOA_AMOUNT | Interest on Arrears Calculated | TB_IOA_CALCULATION_RESULT | CURR | 13(2) | WERTV7 | ||||
BOFFSETNG_FLOWS | Offsetting Flows/Waivers/Write-Offs | TB_OFFSETNG_FLOWS | CURR | 13(2) | WERTV7 | ||||
.INCLU--AP | 0 | ||||||||
BREFUND | Refund for PPI | TB_REFUND_CMLCHN | CURR | 13(2) | WERTV7 | ||||
BHWHR | Payoff Amount in Local Currency | TB_BHNWHR | CURR | 13(2) | WERTV7 | ||||
KURS1 | Exchange rate | VVKURSF | DEC | 9(5) | EXCRT | KURSF | |||
SINCL | Inclusive Indicator for Due Date | TB_SINCL | CHAR | 1 | XFELD | ||||
SINCLINT | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
SVULT | Month-End Indicator for Due Date | TB_SVULT | CHAR | 1 | VVSULT | ||||
DDISPO | Payment Date | TB_PAYDATE | DATS | 8 | DATUM | ||||
SKALID | Factory calendar | SKALID | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
SKALID2 | Calendar ID 2 (valid in connection with calendar ID 1) | VVSKALID2 | CHAR | 2 | Assigned to domain | WFCID | |||
SBEWART | Payoff Flow Type | TB_SBEWART | CHAR | 4 | TZB0A | SBEWART | |||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
BRPWR_FAELL | Remaining Capital on Due Date | TB_BRPWR_FAELL | CURR | 15(2) | WERTV8_TR | ||||
DELFZ | Previous Term End Without Payoff (Calculated) | TB_DELFZ_WITHOUT_REPAY | DATS | 8 | DATUM | ||||
DELFZ_REPAY | New Term End With Payoff | TB_DELFZ_WITH_REPAY | DATS | 8 | DATUM | ||||
BAVWR | Available Disbursement Obligation on Due Date | TB_BAVVWR | CURR | 15(2) | WERTV8_TR | ||||
BPARTREDUCTION | Reduction | TB_PARTREDUCTION | CURR | 13(2) | WERTV7 | ||||
BNONSETTLEDREPAY | Repayment not Settled | TB_NONSETTLEDREPAY | CURR | 13(2) | WERTV7 | ||||
JREPAY_SETTLEM | Repayment Settlement | TB_JREPAY_SETTLEMENT | CHAR | 1 | JFLAGG | ||||
JREGPAYMENTS | Treatment of Regular Payments | TB_JREGPAYMENTS | CHAR | 1 | JFLAGG | ||||
SKOART | Partial Payoff: Condition Type for Repayment ChangeC | TB_SKOART | NUMC | 4 | TZK01 | SKOART | |||
DGUEL_KP | Repayment Change Effective From | TB_DGUEL_KP_REPAY | DATS | 8 | DATUM | ||||
BBASIS | Base Amount for Repayment Change | TB_BBASIS_REPAY | CURR | 13(2) | WERTV7 | ||||
PKOND | Repayment Rate for Repayment Change | TB_PKOND_REPAY | DEC | 10(7) | DECV3_7 | ||||
BKOND | Payment Installment for Repayment Change | TB_BKOND_REPAY | CURR | 13(2) | WERTV7 | ||||
SCONDCOLL | Repayment Clash | TB_SCONDCOLL | CHAR | 1 | TB_SCONDCOLL | ||||
DDEFERRAL_FROM | Start of Deferral Period | TB_DEFERRAL_FROM | DATS | 8 | DATUM | ||||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
SPAYSIM | Indicator: Full Clearing for Actual Principle 1 | TB_SPAYSIM | CHAR | 1 | JFLAGG | ||||
PSSDKURS | Exchange Rate For Net Posted Borrower's Notes | TB_PSSDKURS | DEC | 10(7) | PWKURS | ||||
BNWHR | Nominal Payoff Amount | TB_REPAY_BNWHR | CURR | 13(2) | WERTV7 | ||||
JNOREGSETTLE | Available Capital Contains Regular Repayments | TB_NO_REG_SETTLEMENT | CHAR | 1 | JFLAGG | ||||
.INCLU--AP | 0 | ||||||||
DFAELL_ADJ | Due date adjustment indicator | TB_DFAELLR_ADJ_CMLCHN | CHAR | 1 | TD_DFAELLR_ADJ_CMLCHN | ||||
PARTNR | Payer of Payoff | TB_PARTNR_REPAY | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
BVTYP | Bank Details ID | TB_BVTYP | CHAR | 4 | BVTYP | ||||
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
JNODOIP | Blocked by Payoff: No Open Item Clearing for Loan | TB_JNODOIP | CHAR | 1 | XFELD | ||||
XNODUNN | Exclude Loan from Dunning Run | XNODUNN | CHAR | 1 | XFELD | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
SBUST | Posting control key | VVSBUST | NUMC | 2 | TZB09 | VVSBUST | |||
SZEGEN | Generate incoming payment immediately | SZEGEN | NUMC | 2 | TD21 | SZEGEN | |||
DANGAM | Creation Date for the Offer | TB_DANGAM_REPAY | DATS | 8 | DATUM | ||||
DANGBIS | End of the Validity Period of the Offer | TB_DANGBIS_REPAY | DATS | 8 | DATUM | ||||
DANNAHME | Acceptance Date of the Offer | TB_DANNAHME_REPAY | DATS | 8 | DATUM | ||||
DKUENDDG | Date of Receipt of Notice | TB_DKUEND_REPAY | DATS | 8 | DATUM | ||||
SKUEND | Reason for Notice | TB_SKUEND_REPAY | NUMC | 3 | TD04 | SKUEART | |||
RREJECT_REASON | Reason for Rejection | TB_REJECT_REASON | CHAR | 3 | TDREPAY_REJECT | T_REASON | |||
RREPAY_REASON | Payoff Reason | TB_REPAY_REASON | NUMC | 3 | TD04 | SKUEART | |||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | Assigned to domain | ZAHLS | |||
XCONDPAYDATA | Keep Payment Data for Condition-Based Flows Acc to Cond. | XCONDPAYDATA | CHAR | 1 | XFELD | ||||
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
REMIT_INFO | Payment Notes Info | TB_REMIT_INFO | CHAR | 140 | T_REMIT_INFO | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
XNODUNN_OLD | Exclude Loan from Dunning Run | XNODUNN | CHAR | 1 | XFELD | ||||
JNODOIP_OLD | Blocked by Payoff: No Open Item Clearing for Loan | TB_JNODOIP | CHAR | 1 | XFELD | ||||
DEFSZ_OLD | Date of fixed period end | VVDEFSZ | DATS | 8 | DATUM | ||||
CHANGED | 0 | ||||||||
DFPOSPO | Date of Earliest Possible Payoff | TB_DFPOSPO | DATS | 8 | T_DFPOSPO | ||||
MREQUESTOR | Business Partner Requesting Payoff (BP Number) | TB_MREQUESTOR | CHAR | 10 | ALPHA | T_MREQUESTOR | |||
MSTOPCODE | Technical Key for Stop | TB_STOP | CHAR | 3 | T_STOP | ||||
MQUOTE | Business Operation Is Payoff Quote Or Payoff | TB_MQUOTE | CHAR | 1 | T_MQUOTE | ||||
MCOM_STATUS | Communication Status | TB_MCOM_STATUS | NUMC | 3 | TDREPAY_COMSTATU | T_MCOM_STATUS | |||
DCOM_STATUS | Last Change to Communication Status | TB_DCOM_STATUS | DATS | 8 | T_DCOM_STATUS | ||||
MREMITCODE | Remittance Code | TB_REMIT_CODE | CHAR | 4 | CHAR4 | ||||
AACCRUED | Payments Accrued | TB_AACCRUED | CURR | 13(2) | T_AAMOUNT | ||||
APROJECTED | Projected Payments | TB_APROJECTED | CURR | 13(2) | T_AAMOUNT | ||||
AINS_DEBIT | Insurance Receivables (Debit) | TB_AINS_DEBIT | CURR | 13(2) | T_AAMOUNT | ||||
AINS_CREDIT | Insurance Credit Memos (Credit) | TB_AINS_CREDIT | CURR | 13(2) | T_AAMOUNT | ||||
AINTDIEM | Interest per Day | TB_AINTDIEM | CURR | 13(2) | T_AAMOUNT | ||||
MNOINS | No Insurance Calculation | TB_NOINS | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
LIFE_REPAY | Current Total Term of the Loan in Months | TB_LIFE_REPAY | DEC | 6 | DEC6 | ||||
OVERDUE_ITEMS | Arrears of Contract Capital as a Percentage | TB_OVERDUE_ITEMS_REPAY | DEC | 6 | DEC6 | ||||
FIRST_POS_NOTICE | Earliest Possible Notice Date | TB_FIRST_POS_NOTICE | DATS | 8 | DATE | ||||
INTERIM_ACCOUNT | Receivables Interim Account | TB_INTERIM_ACCOUNT | CHAR | 10 | ALPHA | T_INTERIM_ACCOUNT | |||
ENFORCM_PAYM | Collector | TB_ENFORCM_PAYM | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
STATI_OLD | Contract Status Before Activation of Notice | TB_NOTICE_STATI_OLD | NUMC | 2 | Assigned to domain | STATI | |||
DUNNING_DATE | Date of Last Dunning Notice | TB_DUNNING_DATE_REPAY | DATS | 8 | DATE | ||||
DUNNING_LEVEL | Last Dunning Level | TB_DUNNING_LEVEL_REPAY | NUMC | 1 | MAHNS | ||||
CLR_CATEGORY | Clearing Category | TB_REPAY_CLR_CATEGORY | NUMC | 2 | T_REPAY_CLR_CATEGORY | ||||
NO_INST_OLD | Previous Total of Loan Installments | TB_NO_INST_OLD | NUMC | 3 | |||||
INST_NEW | New Figure for Payment Installments | TB_INST_NEW | CURR | 13(2) | WERTV7 | ||||
NO_INST_NEW | New Total Number of Loan Installments | TB_NO_INST_NEW | NUMC | 3 | |||||
EXIT_INST_NEW | Amount of the Final Installment Payment for the Contract | TB_EXIT_INST | CURR | 13(2) | WERTV7 | ||||
EXIT_INST_OLD | Previous Amount of Clearing Installment | TB_EXIT_INST_OLD | CURR | 13(2) | WERTV7 | ||||
MONTHS_OLD | Overall Term in Months Without Payoff | TB_MONTHS_OLD | NUMC | 3 | |||||
MONTHS_NEW | Overall Term in Months with Payoff | TB_MONTHS_NEW | NUMC | 3 | |||||
.INCLU--AP | 0 | ||||||||
AREIMBURSEMENT | Credit Life Insurance Reimbursement | TB_CLI_RECALC_CONTR | CURR | 13(2) | WERTV7 | ||||
AINSURANCE_CONTR | Single Premium for Credit Life Insurance | TB_CLI_INSURANCE | CURR | 13(2) | WERTV7 | ||||
ADIFFERENCE | Calculated Difference for Credit Life Insurance | TB_LOLIINBAL | CURR | 13(2) | WERTV7 | ||||
ICONSIDER | Transfer CLI Difference | TB_ICONSIDER | CHAR | 1 | XFELD | ||||
CALCULATION_DATE | CLI: Key Date for Calculation of Credit Life Insurance | TB_CLI_CALCULATION_DATE | DATS | 8 | DATUM | ||||
UCLICURR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
CLI_FLOW_SBEWART | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
CLI_CHANGED | Checkbox | XFELD | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table VDREPAYMENT using ABAP code
The following ABAP code Example will allow you to do a basic selection on VDREPAYMENT to SELECT all data from the tableDATA: WA_VDREPAYMENT TYPE VDREPAYMENT.
SELECT SINGLE *
FROM VDREPAYMENT
INTO CORRESPONDING FIELDS OF WA_VDREPAYMENT
WHERE...
How to access SAP table VDREPAYMENT
Within an ECC or HANA version of SAP you can also view further information about VDREPAYMENT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects