SAP ABAP Table VDREPAYMENT (Payoff Master Data)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD_REP (Package) Payoff
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD_REP (Package) Payoff
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VDREPAYMENT | Table Relationship Diagram |
Short Description | Payoff Master Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | .INCLUDE | 0 | 0 | VDARL Key Structure | |||||
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | SARCHIV | SARCHIV | SARCHIV | CHAR | 1 | 0 | Archiving Category Indicator | ||
5 | RANL | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
6 | RBO | RBO | RBO | CHAR | 15 | 0 | Business Operation Number (Loans) | ||
7 | .INCLUDE | 0 | 0 | Header Data for Payoff | |||||
8 | SBO_STATUS | SBO_STATUS | SBO_STATUS | CHAR | 1 | 0 | Loans: Business operation status | ||
9 | SFGKZ | TB_SFGKZA | T_SFGKZ | CHAR | 1 | 0 | Release Workflow Indicator for the Business Operation | ||
10 | SRELSTAT | TB_SRELSTAT | T_SRELSTAT | CHAR | 1 | 0 | Internal Release Status in the Business Operations | ||
11 | SNOTIZ | SNOTIZ | JANEI | CHAR | 1 | 0 | Indicator for stored memo | ||
12 | .INCLUDE | 0 | 0 | Basic Data for Payoff | |||||
13 | DFAELL | TB_DFAELLR | DATUM | DATS | 8 | 0 | Due Date of Business Operation | ||
14 | BRVWR | TB_BRVWR | WERTV8_TR | CURR | 15 | 2 | Available Capital on Due Date | ||
15 | DEFSZ | TB_REPAY_DEFSZ | DATUM | DATS | 8 | 0 | Date of End of Fixed-Rate Period | ||
16 | BRPWR | TB_BRPWR | WERTV8_TR | CURR | 15 | 2 | Remaining Capital at the End of the Fixed Period | ||
17 | SBOTERM | TB_SBOTERM | T_SBO_TERM | CHAR | 1 | 0 | Repayment Change During Partial Payoff | ||
18 | XTEXT | TEXT15 | TEXT15 | CHAR | 15 | 0 | Text (15 characters) | ||
19 | SBWHR | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
20 | SBRUTTO | TB_SBRUTTO | JFLAGG | CHAR | 1 | 0 | Gross procedure | ||
21 | SNETTO | TB_SNETTO | JFLAGG | CHAR | 1 | 0 | Net procedure | ||
22 | BBBWHR | TB_BBBWHR | WERTV7 | CURR | 13 | 2 | Gross Payoff Amount | ||
23 | BCWHR | TB_BBNWHR | WERTV7 | CURR | 13 | 2 | Net Payoff Amount | ||
24 | BADDFLOWS | TB_ADDFLOWS | WERTV7 | CURR | 13 | 2 | Other Flows | ||
25 | BOVERDUE_ITEMS | TB_OVERDUE_ITEMS | WERTV7 | CURR | 13 | 2 | Overdue Items | ||
26 | BCREDITS | TB_CREDITS | WERTV7 | CURR | 13 | 2 | Credit Balance | ||
27 | BPROPPAYMENTS | TB_PROPPAYMENTS | WERTV7 | CURR | 13 | 2 | Proportional Payments | ||
28 | BDEFPAYMENTS | TB_DEFPAYMENTS | WERTV7 | CURR | 13 | 2 | Deferred Payments | ||
29 | BREGPAYMENTS | TB_REGPAYMENTS | WERTV7 | CURR | 13 | 2 | Regular Payments | ||
30 | BFELD1 | TB_FELD1 | WERTV7 | CURR | 13 | 2 | Amount Field 1 | ||
31 | BFELD2 | TB_FELD2 | WERTV7 | CURR | 13 | 2 | Amount Field 2 | ||
32 | BFELD3 | TB_FELD3 | WERTV7 | CURR | 13 | 2 | Amount Field 3 | ||
33 | BFELD4 | TB_FELD4 | WERTV7 | CURR | 13 | 2 | Amount Field 4 | ||
34 | BOUTSTANDING | TB_OUTSTANDING | WERTV7 | CURR | 13 | 2 | Payments Outstanding Until Payoff Due Date | ||
35 | IOA_AMOUNT | TB_IOA_CALCULATION_RESULT | WERTV7 | CURR | 13 | 2 | Interest on Arrears Calculated | ||
36 | .INCLUDE | 0 | 0 | Detail Data for Payoff | |||||
37 | BHWHR | TB_BHNWHR | WERTV7 | CURR | 13 | 2 | Payoff Amount in Local Currency | ||
38 | KURS1 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
39 | SINCL | TB_SINCL | XFELD | CHAR | 1 | 0 | Inclusive Indicator for Due Date | ||
40 | SINCLINT | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period | ||
41 | SVULT | TB_SVULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Due Date | ||
42 | DDISPO | TB_PAYDATE | DATUM | DATS | 8 | 0 | Payment Date | ||
43 | SKALID | SKALID | WFCID | CHAR | 2 | 0 | Factory calendar | * | |
44 | SKALID2 | VVSKALID2 | WFCID | CHAR | 2 | 0 | Calendar ID 2 (valid in connection with calendar ID 1) | * | |
45 | SBEWART | TB_SBEWART | SBEWART | CHAR | 4 | 0 | Payoff Flow Type | TZB0A | |
46 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
47 | BRPWR_FAELL | TB_BRPWR_FAELL | WERTV8_TR | CURR | 15 | 2 | Remaining Capital on Due Date | ||
48 | DELFZ | TB_DELFZ_WITHOUT_REPAY | DATUM | DATS | 8 | 0 | Previous Term End Without Payoff (Calculated) | ||
49 | DELFZ_REPAY | TB_DELFZ_WITH_REPAY | DATUM | DATS | 8 | 0 | New Term End With Payoff | ||
50 | BAVWR | TB_BAVVWR | WERTV8_TR | CURR | 15 | 2 | Available Disbursement Obligation on Due Date | ||
51 | BPARTREDUCTION | TB_PARTREDUCTION | WERTV7 | CURR | 13 | 2 | Reduction | ||
52 | BNONSETTLEDREPAY | TB_NONSETTLEDREPAY | WERTV7 | CURR | 13 | 2 | Repayment not Settled | ||
53 | JREPAY_SETTLEM | TB_JREPAY_SETTLEMENT | JFLAGG | CHAR | 1 | 0 | Repayment Settlement | ||
54 | JREGPAYMENTS | TB_JREGPAYMENTS | JFLAGG | CHAR | 1 | 0 | Treatment of Regular Payments | ||
55 | SKOART | TB_SKOART | SKOART | NUMC | 4 | 0 | Partial Payoff: Condition Type for Repayment ChangeC | TZK01 | |
56 | DGUEL_KP | TB_DGUEL_KP_REPAY | DATUM | DATS | 8 | 0 | Repayment Change Effective From | ||
57 | BBASIS | TB_BBASIS_REPAY | WERTV7 | CURR | 13 | 2 | Base Amount for Repayment Change | ||
58 | PKOND | TB_PKOND_REPAY | DECV3_7 | DEC | 10 | 7 | Repayment Rate for Repayment Change | ||
59 | BKOND | TB_BKOND_REPAY | WERTV7 | CURR | 13 | 2 | Payment Installment for Repayment Change | ||
60 | SCONDCOLL | TB_SCONDCOLL | TB_SCONDCOLL | CHAR | 1 | 0 | Repayment Clash | ||
61 | DDEFERRAL_FROM | TB_DEFERRAL_FROM | DATUM | DATS | 8 | 0 | Start of Deferral Period | ||
62 | DGUEL_KK | DGUEL | DATUM | DATS | 8 | 0 | Date Condition Effective from | ||
63 | SPAYSIM | TB_SPAYSIM | JFLAGG | CHAR | 1 | 0 | Indicator: Full Clearing for Actual Principle 1 | ||
64 | PSSDKURS | TB_PSSDKURS | PWKURS | DEC | 10 | 7 | Exchange Rate For Net Posted Borrower's Notes | ||
65 | BNWHR | TB_REPAY_BNWHR | WERTV7 | CURR | 13 | 2 | Nominal Payoff Amount | ||
66 | JNOREGSETTLE | TB_NO_REG_SETTLEMENT | JFLAGG | CHAR | 1 | 0 | Available Capital Contains Regular Repayments | ||
67 | .INCLUDE | 0 | 0 | Administration Data for Payoff | |||||
68 | PARTNR | TB_PARTNR_REPAY | BU_PARTNER | CHAR | 10 | 0 | Payer of Payoff | * | |
69 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
70 | BVTYP | TB_BVTYP | BVTYP | CHAR | 4 | 0 | Bank Details ID | ||
71 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
72 | JNODOIP | TB_JNODOIP | XFELD | CHAR | 1 | 0 | Blocked by Payoff: No Open Item Clearing for Loan | ||
73 | XNODUNN | XNODUNN | XFELD | CHAR | 1 | 0 | Exclude Loan from Dunning Run | ||
74 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
75 | SBUST | VVSBUST | VVSBUST | NUMC | 2 | 0 | Posting control key | TZB09 | |
76 | SZEGEN | SZEGEN | SZEGEN | NUMC | 2 | 0 | Generate incoming payment immediately | TD21 | |
77 | DANGAM | TB_DANGAM_REPAY | DATUM | DATS | 8 | 0 | Creation Date for the Offer | ||
78 | DANGBIS | TB_DANGBIS_REPAY | DATUM | DATS | 8 | 0 | End of the Validity Period of the Offer | ||
79 | DANNAHME | TB_DANNAHME_REPAY | DATUM | DATS | 8 | 0 | Acceptance Date of the Offer | ||
80 | DKUENDDG | TB_DKUEND_REPAY | DATUM | DATS | 8 | 0 | Date of Receipt of Notice | ||
81 | SKUEND | TB_SKUEND_REPAY | SKUEART | NUMC | 3 | 0 | Reason for Notice | TD04 | |
82 | RREJECT_REASON | TB_REJECT_REASON | T_REASON | CHAR | 3 | 0 | Reason for Rejection | TDREPAY_REJECT | |
83 | RREPAY_REASON | TB_REPAY_REASON | SKUEART | NUMC | 3 | 0 | Payoff Reason | TD04 | |
84 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
85 | ZAHLS | DZAHLS | ZAHLS | CHAR | 1 | 0 | Block Key for Payment | * | |
86 | XCONDPAYDATA | XCONDPAYDATA | XFELD | CHAR | 1 | 0 | Keep Payment Data for Condition-Based Flows Acc to Cond. | ||
87 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
88 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
89 | .INCLUDE | 0 | 0 | SEPA Remittance Information | |||||
90 | REMIT_INFO | TB_REMIT_INFO | T_REMIT_INFO | CHAR | 140 | 0 | SEPA Payment Notes Information | ||
91 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
92 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
93 | .INCLUDE | 0 | 0 | Internal Data for Payoff | |||||
94 | XNODUNN_OLD | XNODUNN | XFELD | CHAR | 1 | 0 | Exclude Loan from Dunning Run | ||
95 | JNODOIP_OLD | TB_JNODOIP | XFELD | CHAR | 1 | 0 | Blocked by Payoff: No Open Item Clearing for Loan | ||
96 | DEFSZ_OLD | VVDEFSZ | DATUM | DATS | 8 | 0 | Date of fixed period end | ||
97 | .INCLUDE | 0 | 0 | Customer Data for Payoff | |||||
98 | CHANGED | CHAR | 1 | 0 | |||||
99 | .INCLUDE | 0 | 0 | Installment Loan-Specific Data for the Payoff | |||||
100 | DFPOSPO | TB_DFPOSPO | T_DFPOSPO | DATS | 8 | 0 | Date of Earliest Possible Payoff | ||
101 | MREQUESTOR | TB_MREQUESTOR | T_MREQUESTOR | CHAR | 10 | 0 | Business Partner Requesting Payoff (BP Number) | ||
102 | MSTOPCODE | TB_STOP | T_STOP | CHAR | 3 | 0 | Technical Key for Stop | ||
103 | MQUOTE | TB_MQUOTE | T_MQUOTE | CHAR | 1 | 0 | Business Operation Is Payoff Quote Or Payoff | ||
104 | MCOM_STATUS | TB_MCOM_STATUS | T_MCOM_STATUS | NUMC | 3 | 0 | Communication Status | TDREPAY_COMSTATU | |
105 | DCOM_STATUS | TB_DCOM_STATUS | T_DCOM_STATUS | DATS | 8 | 0 | Last Change to Communication Status | ||
106 | MREMITCODE | TB_REMIT_CODE | CHAR4 | CHAR | 4 | 0 | Remittance Code | ||
107 | AACCRUED | TB_AACCRUED | T_AAMOUNT | CURR | 13 | 2 | Payments Accrued | ||
108 | APROJECTED | TB_APROJECTED | T_AAMOUNT | CURR | 13 | 2 | Projected Payments | ||
109 | AINS_DEBIT | TB_AINS_DEBIT | T_AAMOUNT | CURR | 13 | 2 | Insurance Receivables (Debit) | ||
110 | AINS_CREDIT | TB_AINS_CREDIT | T_AAMOUNT | CURR | 13 | 2 | Insurance Credit Memos (Credit) | ||
111 | AINTDIEM | TB_AINTDIEM | T_AAMOUNT | CURR | 13 | 2 | Interest per Day | ||
112 | MNOINS | TB_NOINS | XFELD | CHAR | 1 | 0 | No Insurance Calculation | ||
113 | .INCLU--AP | 0 | 0 | Fields for the Consumer Loan and for the Business Op. Notice | |||||
114 | .INCLUDE | 0 | 0 | Payoff Data in the Consumer Loan | |||||
115 | LIFE_REPAY | TB_LIFE_REPAY | DEC6 | DEC | 6 | 0 | Current Total Term of the Loan in Months | ||
116 | OVERDUE_ITEMS | TB_OVERDUE_ITEMS_REPAY | DEC6 | DEC | 6 | 0 | Arrears of Contract Capital as a Percentage | ||
117 | FIRST_POS_NOTICE | TB_FIRST_POS_NOTICE | DATE | DATS | 8 | 0 | Earliest Possible Notice Date | ||
118 | INTERIM_ACCOUNT | TB_INTERIM_ACCOUNT | T_INTERIM_ACCOUNT | CHAR | 10 | 0 | Receivables Interim Account | ||
119 | ENFORCM_PAYM | TB_ENFORCM_PAYM | BU_PARTNER | CHAR | 10 | 0 | Collector | * | |
120 | STATI_OLD | TB_NOTICE_STATI_OLD | STATI | NUMC | 2 | 0 | Contract Status Before Activation of Notice | * | |
121 | DUNNING_DATE | TB_DUNNING_DATE_REPAY | DATE | DATS | 8 | 0 | Date of Last Dunning Notice | ||
122 | DUNNING_LEVEL | TB_DUNNING_LEVEL_REPAY | MAHNS | NUMC | 1 | 0 | Last Dunning Level | ||
123 | NO_INST_OLD | TB_NO_INST_OLD | NUMC | 3 | 0 | Previous Total of Loan Installments | |||
124 | .INCLU--AP | 0 | 0 | Credit Life Insurance Data | |||||
125 | .INCLUDE | 0 | 0 | Results for Recalculation of Credit Life Insurance | |||||
126 | AREIMBURSEMENT | TB_CLI_RECALC_CONTR | WERTV7 | CURR | 13 | 2 | Credit Life Insurance Reimbursement | ||
127 | AINSURANCE_CONTR | TB_CLI_INSURANCE | WERTV7 | CURR | 13 | 2 | Single Premium for Credit Life Insurance | ||
128 | ADIFFERENCE | TB_LOLIINBAL | WERTV7 | CURR | 13 | 2 | Calculated Difference for Credit Life Insurance | ||
129 | ICONSIDER | TB_ICONSIDER | XFELD | CHAR | 1 | 0 | Transfer CLI Difference | ||
130 | CALCULATION_DATE | TB_CLI_CALCULATION_DATE | DATUM | DATS | 8 | 0 | CLI: Key Date for Calculation of Credit Life Insurance | ||
131 | UCLICURR | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
132 | CLI_FLOW_SBEWART | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
133 | CLI_CHANGED | XFELD | XFELD | CHAR | 1 | 0 | Checkbox |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VDREPAYMENT | MABER | T047M | MABER | |||
2 | VDREPAYMENT | MANDT | T000 | MANDT | KEY | 1 | CN |
3 | VDREPAYMENT | MANSP | T040S | MANSP | |||
4 | VDREPAYMENT | MCOM_STATUS | TDREPAY_COMSTATU | MCOM_STATUS | KEY | 1 | CN |
5 | VDREPAYMENT | RREJECT_REASON | TDREPAY_REJECT | RREJECT_REASON | KEY | 1 | CN |
6 | VDREPAYMENT | RREPAY_REASON | TD04 | SKUEND | KEY | 1 | CN |
7 | VDREPAYMENT | SBEWART | TZB0A | SBEWART | KEY | 1 | C |
8 | VDREPAYMENT | SBUST | TZB09 | SBUST | KEY | ||
9 | VDREPAYMENT | SKOART | TZK01 | SKOART | |||
10 | VDREPAYMENT | SKUEND | TD04 | SKUEND | KEY | 1 | C |
11 | VDREPAYMENT | SZEGEN | TD21 | SZEGEN | KEY |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |