1. SAP Tutorial
  2. Financial Services

VDREPAYMENT SAP table for – Payoff Master Data

Here we would like to draw your attention to VDREPAYMENT 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). VDREPAYMENT is a SAP standard transp table used for storing Payoff Master Data related data in SAP. It comes under the package FVVD_REP.

SAP VDREPAYMENT table

Table VDREPAYMENT technical data

TableVDREPAYMENT
Data storingPayoff Master Data
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD_REP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDREPAYMENT 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 VDREPAYMENT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : VDARL Key Structure
    Its a key field.
  • 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
  • .INCLUDE : Header Data for Payoff
  • SBO_STATUS : Loans: Business operation status
    Its data type is CHAR (Character String) with field length 1
  • SFGKZ : Release Workflow Indicator for the Business Operation
    Its data type is CHAR (Character String) with field length 1
  • SRELSTAT : Internal Release Status in the Business Operations
    Its data type is CHAR (Character String) with field length 1
  • SNOTIZ : Indicator for stored memo
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Basic Data for Payoff
  • DFAELL : Due Date of Business Operation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BRVWR : Available Capital on Due Date
    Its data type is CURR (Currency Field) with field length 15
  • DEFSZ : Date of End of Fixed-Rate Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BRPWR : Remaining Capital at the End of the Fixed Period
    Its data type is CURR (Currency Field) with field length 15
  • SBOTERM : Repayment Change During Partial Payoff
    Its data type is CHAR (Character String) with field length 1
  • XTEXT : Text (15 characters)
    Its data type is CHAR (Character String) with field length 15
  • SBWHR : Position Currency (Currency of Position Amount)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • SBRUTTO : Gross procedure
    Its data type is CHAR (Character String) with field length 1
  • SNETTO : Net procedure
    Its data type is CHAR (Character String) with field length 1
  • BBBWHR : Gross Payoff Amount
    Its data type is CURR (Currency Field) with field length 13
  • BCWHR : Net Payoff Amount
    Its data type is CURR (Currency Field) with field length 13
  • BADDFLOWS : Other Flows
    Its data type is CURR (Currency Field) with field length 13
  • BOVERDUE_ITEMS : Overdue Items
    Its data type is CURR (Currency Field) with field length 13
  • BCREDITS : Credit Balance
    Its data type is CURR (Currency Field) with field length 13
  • BPROPPAYMENTS : Proportional Payments
    Its data type is CURR (Currency Field) with field length 13
  • BDEFPAYMENTS : Deferred Payments
    Its data type is CURR (Currency Field) with field length 13
  • BREGPAYMENTS : Regular Payments
    Its data type is CURR (Currency Field) with field length 13
  • BFELD1 : Amount Field 1
    Its data type is CURR (Currency Field) with field length 13
  • BFELD2 : Amount Field 2
    Its data type is CURR (Currency Field) with field length 13
  • BFELD3 : Amount Field 3
    Its data type is CURR (Currency Field) with field length 13
  • BFELD4 : Amount Field 4
    Its data type is CURR (Currency Field) with field length 13
  • BOUTSTANDING : Payments Outstanding Until Payoff Due Date
    Its data type is CURR (Currency Field) with field length 13
  • IOA_AMOUNT : Interest on Arrears Calculated
    Its data type is CURR (Currency Field) with field length 13
  • .INCLUDE : Detail Data for Payoff
  • BHWHR : Payoff Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • KURS1 : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SINCL : Inclusive Indicator for Due Date
    Its data type is CHAR (Character String) with field length 1
  • SINCLINT : 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 Due Date
    Its data type is CHAR (Character String) with field length 1
  • DDISPO : Payment Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKALID : Factory calendar
    Its data type is CHAR (Character String) with field length 2
  • SKALID2 : Calendar ID 2 (valid in connection with calendar ID 1)
    Its data type is CHAR (Character String) with field length 2
  • SBEWART : Payoff Flow Type
    Its data type is CHAR (Character String) with field length 4
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • BRPWR_FAELL : Remaining Capital on Due Date
    Its data type is CURR (Currency Field) with field length 15
  • DELFZ : Previous Term End Without Payoff (Calculated)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DELFZ_REPAY : New Term End With Payoff
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BAVWR : Available Disbursement Obligation on Due Date
    Its data type is CURR (Currency Field) with field length 15
  • BPARTREDUCTION : Reduction
    Its data type is CURR (Currency Field) with field length 13
  • BNONSETTLEDREPAY : Repayment not Settled
    Its data type is CURR (Currency Field) with field length 13
  • JREPAY_SETTLEM : Repayment Settlement
    Its data type is CHAR (Character String) with field length 1
  • JREGPAYMENTS : Treatment of Regular Payments
    Its data type is CHAR (Character String) with field length 1
  • SKOART : Partial Payoff: Condition Type for Repayment ChangeC
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DGUEL_KP : Repayment Change Effective From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BBASIS : Base Amount for Repayment Change
    Its data type is CURR (Currency Field) with field length 13
  • PKOND : Repayment Rate for Repayment Change
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • BKOND : Payment Installment for Repayment Change
    Its data type is CURR (Currency Field) with field length 13
  • SCONDCOLL : Repayment Clash
    Its data type is CHAR (Character String) with field length 1
  • DDEFERRAL_FROM : Start of Deferral Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DGUEL_KK : Date Condition Effective from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SPAYSIM : Indicator: Full Clearing for Actual Principle 1
    Its data type is CHAR (Character String) with field length 1
  • PSSDKURS : Exchange Rate For Net Posted Borrower’s Notes
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • BNWHR : Nominal Payoff Amount
    Its data type is CURR (Currency Field) with field length 13
  • JNOREGSETTLE : Available Capital Contains Regular Repayments
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Administration Data for Payoff
  • PARTNR : Payer of Payoff
    Its data type is CHAR (Character String) with field length 10
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • BVTYP : Bank Details ID
    Its data type is CHAR (Character String) with field length 4
  • SZART : Payment transaction
    Its data type is CHAR (Character String) with field length 1
  • JNODOIP : Blocked by Payoff: No Open Item Clearing for Loan
    Its data type is CHAR (Character String) with field length 1
  • XNODUNN : Exclude Loan from Dunning Run
    Its data type is CHAR (Character String) with field length 1
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • SBUST : Posting control key
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SZEGEN : Generate incoming payment immediately
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DANGAM : Creation Date for the Offer
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DANGBIS : End of the Validity Period of the Offer
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DANNAHME : Acceptance Date of the Offer
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DKUENDDG : Date of Receipt of Notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKUEND : Reason for Notice
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RREJECT_REASON : Reason for Rejection
    Its data type is CHAR (Character String) with field length 3
  • RREPAY_REASON : Payoff Reason
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • ZAHLS : Block Key for Payment
    Its data type is CHAR (Character String) with field length 1
  • XCONDPAYDATA : Keep Payment Data for Condition-Based Flows Acc to Cond.
    Its data type is CHAR (Character String) with field length 1
  • MABER : Dunning Area
    Its data type is CHAR (Character String) with field length 2
  • MANSP : Dunning block
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : SEPA Remittance Information
  • REMIT_INFO : SEPA Payment Notes Information
    Its data type is CHAR (Character String) with field length 140
  • MNDID : Unique Referene to Mandate per Payment Recipient
    Its data type is CHAR (Character String) with field length 35
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Internal Data for Payoff
  • XNODUNN_OLD : Exclude Loan from Dunning Run
    Its data type is CHAR (Character String) with field length 1
  • JNODOIP_OLD : Blocked by Payoff: No Open Item Clearing for Loan
    Its data type is CHAR (Character String) with field length 1
  • DEFSZ_OLD : Date of fixed period end
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Customer Data for Payoff
  • CHANGED : EBP: ‘Changed on’ Time Stamp for Cache
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Installment Loan-Specific Data for the Payoff
  • DFPOSPO : Date of Earliest Possible Payoff
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MREQUESTOR : Business Partner Requesting Payoff (BP Number)
    Its data type is CHAR (Character String) with field length 10
  • MSTOPCODE : Technical Key for Stop
    Its data type is CHAR (Character String) with field length 3
  • MQUOTE : Business Operation Is Payoff Quote Or Payoff
    Its data type is CHAR (Character String) with field length 1
  • MCOM_STATUS : Communication Status
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DCOM_STATUS : Last Change to Communication Status
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MREMITCODE : Remittance Code
    Its data type is CHAR (Character String) with field length 4
  • AACCRUED : Payments Accrued
    Its data type is CURR (Currency Field) with field length 13
  • APROJECTED : Projected Payments
    Its data type is CURR (Currency Field) with field length 13
  • AINS_DEBIT : Insurance Receivables (Debit)
    Its data type is CURR (Currency Field) with field length 13
  • AINS_CREDIT : Insurance Credit Memos (Credit)
    Its data type is CURR (Currency Field) with field length 13
  • AINTDIEM : Interest per Day
    Its data type is CURR (Currency Field) with field length 13
  • MNOINS : No Insurance Calculation
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Fields for the Consumer Loan and for the Business Op. Notice
  • .INCLUDE : Payoff Data in the Consumer Loan
  • LIFE_REPAY : Current Total Term of the Loan in Months
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • OVERDUE_ITEMS : Arrears of Contract Capital as a Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • FIRST_POS_NOTICE : Earliest Possible Notice Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INTERIM_ACCOUNT : Receivables Interim Account
    Its data type is CHAR (Character String) with field length 10
  • ENFORCM_PAYM : Collector
    Its data type is CHAR (Character String) with field length 10
  • STATI_OLD : Contract Status Before Activation of Notice
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DUNNING_DATE : Date of Last Dunning Notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DUNNING_LEVEL : Last Dunning Level
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • NO_INST_OLD : Previous Total of Loan Installments
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLU–AP : Credit Life Insurance Data
  • .INCLUDE : Results for Recalculation of Credit Life Insurance
  • AREIMBURSEMENT : Credit Life Insurance Reimbursement
    Its data type is CURR (Currency Field) with field length 13
  • AINSURANCE_CONTR : Single Premium for Credit Life Insurance
    Its data type is CURR (Currency Field) with field length 13
  • ADIFFERENCE : Calculated Difference for Credit Life Insurance
    Its data type is CURR (Currency Field) with field length 13
  • ICONSIDER : Transfer CLI Difference
    Its data type is CHAR (Character String) with field length 1
  • CALCULATION_DATE : CLI: Key Date for Calculation of Credit Life Insurance
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UCLICURR : Position Currency (Currency of Position Amount)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CLI_FLOW_SBEWART : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • CLI_CHANGED : Checkbox
    Its data type is CHAR (Character String) with field length 1

    • VDREPAYMENT related tables

    • TDREPAY_MMETHODT : Text Table for TDREPAY_MMETHOD
    • TDREPAY_COMSTATT : Texts for Communication Status
    • VDCFWAREHOUSE : Cash Flow Management
    • TDREPAY_PRCOND : Condition Type Determination for the Payoff
    • TDREPAY_TEMPL : Table for Payoff and Notice Templates
    • TDREPAY_MMETHOD : Distribution Methods for Fields in Receivables List
    • TDREPAY_RLFLOWS : Flow Type Groups for Receivables List for Payoff
    • TDREPAY_RECLISTT : Name of Items in Receivables List
    • TDREPAY_RECLIST : Customizing for Receivables List
    • TDNOTICE_INTACCT : Texts for Receivables Interim Account
    • TDREPAY_REJECT : Rejection Reasons
    • TDREPAY_TEMPLTXT : Texts for Payoff Templates
    • TDREPAY_REJECTT : Texts for Rejection Reasons
    • TDREPAY_COMSTATU : Communication Status Payoff
    • TDREPAY_REASON : Payoff Reasons
    • TDREPAY_GSTEER : General Control Data for Payoff and Notice
    • TDREPAY_RLFLOWST : Text Table for TDREPAY_RLFLOWST
    • TDNOTICE_INTACC : Receivables Interim Account for Business Operation Notice
    • TDREPAY_REASONT : Texts for Payoff Reasons
    • TDREPAY_CFHANDLE : Cash Flow Behavior in the Payoff

    VDREPAYMENT related transaction codes under SAP package FVVD_REP

    • FNVD_REPAY : Loan Payoff
    • S_KFM_86000061 : IMG Activity: RUECKZ_GRUENDE_DEF
    • S_KFM_86000060 : IMG-Activity: RUECKZ_KONDIS_FEST
    • S_KFM_86000057 : IMG Activity: MUSTER_VOREINST
    • S_KFM_86000059 : IMG Activity: RUECKZ_BEWEG_FELD
    • S_KFM_86000076 : IMG Activity: VORSCHL_BELPOSTEXT
    • S_KFM_86000062 : IMG Activity: RUECKZ_ABLEHN_DEF
    • S_KFM_86000058 : IMG Activity: RUECKZ_ALLG_STEUER

    Related References

    Related Tutorials

    VDCAPTR SAP table for – CAPTR: Master Data of Capital Transfer

    VDCAPTR table in SAP FS (Loans Management in FS) module. This table is used for storing data of CAPTR: Master...

    TDREPAY_GSTEER SAP table for – General Control Data for Payoff and Notice

    TDREPAY_GSTEER table in SAP FS (Loans Management in FS) module. This table is used for storing data of General Control...

    TDREPAY_TEMPL SAP table for – Table for Payoff and Notice Templates

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

    VDEXTSKIP SAP table for – Master Data Extension and Skip

    VDEXTSKIP table in SAP FS (Loans Management in FS) module. This table is used for storing data of Master Data...

    BPTC01 SAP table for – Master Data for Total Commitment

    BPTC01 table in SAP FS (Business Partner in FS) module. This table is used for storing data of Master Data...

    TDREPAY_TEMPLTXT SAP table for – Texts for Payoff Templates

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

    TDREPAY_COMSTATU SAP table for – Communication Status Payoff

    TDREPAY_COMSTATU table in SAP FS (Loans Management in FS) module. This table is used for storing data of Communication Status...

    «
    »