SAP ABAP Table VDARL (Loans)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷
FS-CML (Application Component) Loans Management
⤷
FVVD (Package) Treasury Loans

⤷

⤷

Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VDARL |
![]() |
Short Description | Loans |
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 | CLNT | 3 | 0 | Client | T000 | |
2 | ![]() |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | ![]() |
SARCHIV | SARCHIV | CHAR | 1 | 0 | Archiving Category Indicator | ||
4 | ![]() |
RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
5 | ![]() |
RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
6 | ![]() |
DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
7 | ![]() |
TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
8 | ![]() |
REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
9 | ![]() |
RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
10 | ![]() |
DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
11 | ![]() |
TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
12 | ![]() |
RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
13 | ![]() |
VVKEYOBJ | VVKEY | CHAR | 10 | 0 | Internal key for object | ||
14 | ![]() |
SSTATI | STATI | NUMC | 2 | 0 | Status of data record | TZC37 | |
15 | ![]() |
SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
16 | ![]() |
VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPAB | |
17 | ![]() |
RREFKONT | USTRU | CHAR | 8 | 0 | Account Assignment Reference in Financial Assets Management | T037S | |
18 | ![]() |
HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | T012 | |
19 | ![]() |
HKTID | HKTID | CHAR | 5 | 0 | ID for account details | T012K | |
20 | ![]() |
STITEL | STITEL | NUMC | 3 | 0 | Loan Type Indicator | TD03 | |
21 | ![]() |
SGLZB | SGLZB | CHAR | 4 | 0 | SCB asset group indicator | TW07 | |
22 | ![]() |
SFIBG | SFIBG | NUMC | 4 | 0 | Asset Grouping Indicator | TW08 | |
23 | ![]() |
SBILK | SBILK | CHAR | 2 | 0 | Balance Sheet Indicator | TW11 | |
24 | ![]() |
XALKZ | XKBEZ | CHAR | 15 | 0 | Short name | ||
25 | ![]() |
XALLB | XLBEZ | CHAR | 60 | 0 | Long name | ||
26 | ![]() |
XAKT | CHAR32 | CHAR | 32 | 0 | File Number | ||
27 | ![]() |
RANLALT1 | CHAR13 | CHAR | 13 | 0 | Alternative Identification | ||
28 | ![]() |
RANLALT2 | CHAR13 | CHAR | 13 | 0 | Alternative identification 2 | ||
29 | ![]() |
SGRP1 | SGRP1 | CHAR | 6 | 0 | Group Key 1 (Freely Available) | TDDG1 | |
30 | ![]() |
SGRP2 | SGRP2 | CHAR | 6 | 0 | Group Key 2 (Freely Available) | TDDG2 | |
31 | ![]() |
RKLAMMER | RANL | CHAR | 13 | 0 | Classification Number for Finance Projects | ||
32 | ![]() |
RANLHPT | CHAR13 | CHAR | 13 | 0 | Principle loan investment number | ||
33 | ![]() |
RANTRAG | CHAR13 | CHAR | 13 | 0 | Application number | ||
34 | ![]() |
VVSSOLIST | VVSSOLIST | CHAR | 1 | 0 | Plan/Actual principle | ||
35 | ![]() |
SFRIST | SFRIST | NUMC | 2 | 0 | Loan Term | TD09 | |
36 | ![]() |
BANTRAG | BWHR | CURR | 13 | 2 | Capital applied for | ||
37 | ![]() |
SWHR | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
38 | ![]() |
DANTRAG | DATUM | DATS | 8 | 0 | Entry Date of Loan Application | ||
39 | ![]() |
BZUSAGE | WERTV7 | CURR | 13 | 2 | Commitment capital | ||
40 | ![]() |
DZUSAGE | DATUM | DATS | 8 | 0 | Loan - Date of Commitment by Lender | ||
41 | ![]() |
DZUSAGE_ORIGIN | DATUM | DATS | 8 | 0 | Date of the Original Approval from the Lender | ||
42 | ![]() |
DBLFZ | DATUM | DATS | 8 | 0 | Start of Term | ||
43 | ![]() |
DENDLFZ | DATUM | DATS | 8 | 0 | End of Loan Term | ||
44 | ![]() |
DBDIS | DDAT | DATS | 8 | 0 | Start of distribution of discount | ||
45 | ![]() |
SDISMETH | DISMETH | NUMC | 1 | 0 | Discount distribution method | ||
46 | ![]() |
SSICHER | SSICH | CHAR | 4 | 0 | Primary collateral | TD01 | |
47 | ![]() |
SVZWECK | SVZWK | CHAR | 2 | 0 | Purpose of Loan | TD07 | |
48 | ![]() |
SSONDER | SSONDER | NUMC | 2 | 0 | Special treatment of loan | TD10 | |
49 | ![]() |
SFIWO | SFIWO | CHAR | 2 | 0 | Indicator: Type of Residential Object Financing | TD15 | |
50 | ![]() |
SDTI | NUMC | NUMC | 5 | 0 | DTI indicator | ||
51 | ![]() |
SHOME | SHOME | NUMC | 3 | 0 | Home statement | TD11 | |
52 | ![]() |
SLAENDER | LAND1 | CHAR | 3 | 0 | Country ID | T005 | |
53 | ![]() |
AABTRET | NUM02 | NUMC | 2 | 0 | Number of Assignments Still Possible | ||
54 | ![]() |
BABTRET | BWHR | CURR | 13 | 2 | Minimum amount for assignments | ||
55 | ![]() |
SNICHTAB | SNICHTAB | NUMC | 2 | 0 | Reason for Non-Acceptance | TDA5 | |
56 | ![]() |
DARCHIV | DATUM | DATS | 8 | 0 | Date of Rejection/Withdrawal | ||
57 | ![]() |
BGESDAR | BWHR | CURR | 13 | 2 | Total amount of syndicated loan | ||
58 | ![]() |
DKONS | DATUM | DATS | 8 | 0 | Syndicate loan date | ||
59 | ![]() |
SKWGKRED | SKWGKRED | NUMC | 1 | 0 | Credit category indicator Para. 75 report (Austria) | TZ35 | |
60 | ![]() |
SKWGDAR | SKWGDAR | NUMC | 1 | 0 | Credit type indicator for Austrian reporting | TZ34 | |
61 | ![]() |
BUCHSYS | BUCHSYS | NUMC | 1 | 0 | Posting system indicator for borrower's note loans | ||
62 | ![]() |
VVSLOEKZ | VVSLOEKZ | NUMC | 1 | 0 | Deletion indicator | ||
63 | ![]() |
VVSDTYP | VVSDTYP | NUMC | 3 | 0 | Loans Class | TD02 | |
64 | ![]() |
VVDBEWI | DATUM | DATS | 8 | 0 | Approval date | ||
65 | ![]() |
VVSABTRANS | XFELD | CHAR | 1 | 0 | Indicator for Possible Foreign Assignment | ||
66 | ![]() |
VVAKONS | NUM03 | NUMC | 3 | 0 | Number of syndicate members | ||
67 | ![]() |
VVSFGKZ | VVSFGKZ | CHAR | 1 | 0 | Release Indicator | ||
68 | ![]() |
VVSABT | VVSABT | CHAR | 4 | 0 | Assignee | TDS1 | |
69 | ![]() |
MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
70 | ![]() |
MAHNS_D | MAHNS | NUMC | 1 | 0 | Dunning Level | ||
71 | ![]() |
MADAT | DATUM | DATS | 8 | 0 | Date of Last Dunning Notice | ||
72 | ![]() |
VVRPNR | NUMC08 | NUMC | 8 | 0 | Activity number/rollover number | ||
73 | ![]() |
DUMMY_12 | CHAR12 | CHAR | 12 | 0 | Dummy field 12 characters CHAR | ||
74 | ![]() |
VVSONDST | VVSONDST | CHAR | 2 | 0 | Special posting treatment | TD14 | |
75 | ![]() |
SGRP3 | SGRP3 | CHAR | 6 | 0 | Group Key 3 (Freely Available) | TDDG3 | |
76 | ![]() |
SGRP4 | SGRP4 | CHAR | 6 | 0 | Group Key 4 (Freely Available) | TDDG4 | |
77 | ![]() |
VVSZKEY | VVSZKEY | NUMC | 2 | 0 | Indicator for Control of Incoming Payment Distribution | TVZ01 | |
78 | ![]() |
BEGRU | BEGRU | CHAR | 4 | 0 | Authorization Group | ||
79 | ![]() |
VVSVERFU | VVSVERFU | NUMC | 2 | 0 | Type of Restraint on Drawing | TZV05 | |
80 | ![]() |
VVSTITART | VVSTITART | NUMC | 2 | 0 | Borrower's Note Loan Security Type | TD16 | |
81 | ![]() |
VVNABTRV | CHAR15 | CHAR | 15 | 0 | Contract of assignment number | ||
82 | ![]() |
VVNAVAL | CHAR15 | CHAR | 15 | 0 | Guarantee number | ||
83 | ![]() |
VVDABTR | DATUM | DATS | 8 | 0 | Date of assignment | ||
84 | ![]() |
VVDVERFU | DATUM | DATS | 8 | 0 | Date of restraint on disposal upto | ||
85 | ![]() |
VVSFGBEW | VVSFGBEW | NUMC | 2 | 0 | Transaction data to be released available | ||
86 | ![]() |
VVDLESOZ | DATUM | DATS | 8 | 0 | Date of last special interest payment period | ||
87 | ![]() |
RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | TWPOB | |
88 | ![]() |
VVSREGION | VVSREGION | CHAR | 4 | 0 | Sales Region | TD18 | |
89 | ![]() |
VVSGESST | VVSGESST | CHAR | 4 | 0 | Branch Office | TD17 | |
90 | ![]() |
VVSBEA | VVSBEA | NUMC | 2 | 0 | Loan Processing Indicator | ||
91 | ![]() |
VVSOBEZ | CHAR2 | CHAR | 2 | 0 | Organizational District | ||
92 | ![]() |
VVSBEZIRK | CHAR4 | CHAR | 4 | 0 | Agent District | ||
93 | ![]() |
VVSPLIT | XFELD | CHAR | 1 | 0 | Debit position splitting | ||
94 | ![]() |
VVBNBUERG | WERTV7 | CURR | 13 | 2 | Initial capital not guaranteed | ||
95 | ![]() |
VVSREFZINS | XFELD | CHAR | 1 | 0 | Loan With Reference Interest Rate | ||
96 | ![]() |
VVSMAHNM | VVSMAHNM | CHAR | 1 | 0 | Loan Manual Dunning Level | TDMAHNS_MAN | |
97 | ![]() |
CHAR2 | CHAR2 | CHAR | 2 | 0 | Version Number Component | ||
98 | ![]() |
CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
99 | ![]() |
VVDRUECK | DATUM | DATS | 8 | 0 | Date when loan will probably be redeemed | ||
100 | ![]() |
VVSABGRD | VVSABGRD | CHAR | 1 | 0 | Loan Discount Accrual/Deferral Method | ||
101 | ![]() |
VVFESTKZ | VVFESTKZ | CHAR | 1 | 0 | Indicator for Control of Fixed Contract | ||
102 | ![]() |
BP_RATING | BP_RATING | CHAR | 3 | 0 | Rating | TP06 | |
103 | ![]() |
SRATAGEN_NEW | BU_PARTNER | CHAR | 10 | 0 | Rating agency | * | |
104 | ![]() |
BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | BUT000 | |
105 | ![]() |
TB_FINOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number for Financial Transactions | * | |
106 | ![]() |
HDN_KUNNR | KUNNR | CHAR | 10 | 0 | Main Borrower Customer Number | KNA1 | |
107 | ![]() |
VVSKWG14 | VVSKWG14 | CHAR | 2 | 0 | Position grouping acc. Para 14 GBA (Sec. and loans) | ||
108 | ![]() |
RANLSTAMNR | RANL | CHAR | 13 | 0 | Master number part of loan number for finding contracts | ||
109 | ![]() |
MIGDATE | DATUM | DATS | 8 | 0 | Migration date | ||
110 | ![]() |
SDUNNCMP | SDUNNCMP | CHAR | 2 | 0 | Summarization Level for Dunning Letter | ||
111 | ![]() |
XNODUNN | XFELD | CHAR | 1 | 0 | Exclude Loan from Dunning Run | ||
112 | ![]() |
TB_ZUOND | TEXT18 | CHAR | 18 | 0 | Assignment | ||
113 | ![]() |
TB_REFER | CHAR16 | CHAR | 16 | 0 | Internal Reference | ||
114 | ![]() |
TB_MERKM | CHAR25 | CHAR | 25 | 0 | Characteristics | ||
115 | ![]() |
SDUNCHARG | XFELD | CHAR | 1 | 0 | Post Dunning Charges and Interest to this Contract | ||
116 | ![]() |
SWHRORG | WAERS | CUKY | 5 | 0 | Loan currency before conversion to EURO | TCURC | |
117 | ![]() |
DCONVERT | DATE | DATS | 8 | 0 | Date loan was converted to EURO | ||
118 | ![]() |
DCORRECT | DATE | DATS | 8 | 0 | Date for adjustment flows resulting from EURO conversion | ||
119 | ![]() |
VVSAKTPAS | VVSAKTPAS | CHAR | 1 | 0 | Indicator: Asset/Liability Transaction | ||
120 | ![]() |
TB_RPZAHL_NEW | BU_PARTNER | CHAR | 10 | 0 | Payer/payee | BUT000 | |
121 | ![]() |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
122 | ![]() |
TB_JNOREPAY | XFELD | CHAR | 1 | 0 | Payoff Lock | ||
123 | ![]() |
TB_JNODOIP | XFELD | CHAR | 1 | 0 | Blocked by Payoff: No Open Item Clearing for Loan | ||
124 | ![]() |
TPM_COM_VAL_CLASS | TPM_COM_VAL_CLASS | NUMC | 4 | 0 | General Valuation Class | TRGC_COM_VALCL | |
125 | ![]() |
TB_SARC_EXCL | T_SARC_EXCL | CHAR | 1 | 0 | Documents For The Loan May Not Be Archived | ||
126 | ![]() |
TB_SARC_DOCS | T_SARC_DOCS | CHAR | 1 | 0 | Indicator: Archived Loan Documents Exist | ||
127 | ![]() |
TB_NO_PLAN_DONE | CHECKBOX | CHAR | 1 | 0 | Do Not Transfer Loan to Status "Completed" | ||
128 | ![]() |
TB_DPLAN_SET | DATUM | DATS | 8 | 0 | Date of Transfer of Contract into Status Planned Completed | ||
129 | ![]() |
TB_DOPEN | DATUM | DATS | 8 | 0 | Opening Date of a Loan Contract | ||
130 | ![]() |
TB_DCLOSE | DATUM | DATS | 8 | 0 | Closing Date of a Loan Contract | ||
131 | ![]() |
TB_VIEW_DATE_DUNNING_BLOCK_TIL | DATUM | DATS | 8 | 0 | Expiration Date of Dunning Lock | ||
132 | ![]() |
TB_XNOIOA | CHAR1 | CHAR | 1 | 0 | Lock for Interest on Arrears | ||
133 | ![]() |
TB_NOIOA_TILL | DATUM | DATS | 8 | 0 | Expiry Date of Lock on Interest on Arrears | ||
134 | ![]() |
TB_ORIGIN | T_ORIGIN | CHAR | 2 | 0 | Loan Origin | TDORIGIN | |
135 | ![]() |
TB_DCALLEND | DATUM | DATS | 8 | 0 | Provision Expiry Date | ||
136 | ![]() |
TB_SVER_EXCL | T_SVER_EXCL | CHAR | 1 | 0 | Documents for the loan may not be summarized | ||
137 | ![]() |
0 | 0 | Processing Characteristics of a Loan | |||||
138 | ![]() |
TB_LC_CHARAC_DISBURSEMENT | T_LC_CHARACVALUE | CHAR | 1 | 0 | Processing Characteristic: Disbursement Status | * | |
139 | ![]() |
TB_LC_CHARAC_CAPITALS | T_LC_CHARACVALUE | CHAR | 1 | 0 | Processing Characteristic: Status of Capital Amounts | * | |
140 | ![]() |
TB_LC_CHARAC_PLANNED_FLOW | T_LC_CHARACVALUE | CHAR | 1 | 0 | Processing Characteristic: Status of Planned Records | * | |
141 | ![]() |
TB_LC_CHARAC_DEBIT | T_LC_CHARACVALUE | CHAR | 1 | 0 | Processing Characteristic: Status of Customer Receivables | * | |
142 | ![]() |
TB_LC_CHARAC_CREDIT | T_LC_CHARACVALUE | CHAR | 1 | 0 | Processing Characteristic: Status of Customer Payables | * | |
143 | ![]() |
TB_LC_STATUS | T_LC_STATUS | CHAR | 1 | 0 | Status of Processing Characteristics for Loan | ||
144 | ![]() |
TB_PAYM_STATUS | T_PAYM_STATUS | CHAR | 1 | 0 | Payment Status | ||
145 | ![]() |
TB_STOP_INDICATOR | T_STOP_INDICATOR | CHAR | 1 | 0 | Stop Indicator | ||
146 | ![]() |
TB_PR_PRODINT | T_PR_PRODINT | CHAR | 18 | 0 | Internal Product ID | * | |
147 | ![]() |
TB_PR_VERSION | T_PR_VERSION | NUMC | 4 | 0 | Product Version | * | |
148 | ![]() |
TB_VIEW_SCHUFA | XFELD | CHAR | 1 | 0 | Business Partner Has Signed a Schufa Declaration | ||
149 | ![]() |
TB_VIEW_DATE_OF_FULL_PAYMENT | DATUM | DATS | 8 | 0 | Date of Full Disbursement | ||
150 | ![]() |
TB_VIEW_DATE_OF_CANCELATION | DATUM | DATS | 8 | 0 | Rescission Date | ||
151 | ![]() |
TB_CNCL | BOOLE | CHAR | 1 | 0 | Rescission Indicator | ||
152 | ![]() |
TB_DINSTR | DATUM | DATS | 8 | 0 | Date Customer Was Instructed About Rescission Rights | ||
153 | ![]() |
TB_MD_ORGUNIT_CNMGT | T_MD_ORGUNIT_CNMGT | CHAR | 12 | 0 | Organizational Unit | TD19 | |
154 | ![]() |
TB_MD_DISTRIBUTION_CHANNEL | T_MD_DISTRIBUTION_CHANNEL | CHAR | 10 | 0 | Sales Channel | TD30 | |
155 | ![]() |
TB_CNCL_CLI | T_CNCL_CLI | CHAR | 1 | 0 | Indicator: Rescind Credit Life Insurance | ||
156 | ![]() |
TB_MD_NO_CHANGE | TB_MD_NO_CHANGE | CHAR | 1 | 0 | Only Limited Changes Possible for Contract Indicator | ||
157 | ![]() |
TB_SCHEME_ID | T_SCHEME_ID | CHAR | 3 | 0 | Calculation Profile for Interest on Arrears Calculation | TDIOA_SCHEME_DEF | |
158 | ![]() |
TB_SREGION | REGIO | CHAR | 3 | 0 | Region Where Contract Concluded | T005S | |
159 | ![]() |
TB_WAIVE_REASON | T_WAIVE_REASON | CHAR | 3 | 0 | Reason for Automatic Waiver of Charges | TDWAIVE_REASON | |
160 | ![]() |
TB_WAIVE_METHOD | T_WAIVE_METHOD | NUMC | 1 | 0 | Waiver Method | ||
161 | ![]() |
TB_BACKOFFICE_ID | HROBJID | NUMC | 8 | 0 | Back Office | * | |
162 | ![]() |
TB_FLG_NON_ACCRUAL | XFELD | CHAR | 1 | 0 | Non-Accrual Status Permitted | ||
163 | ![]() |
TB_FIMA_METHOD | T_FIMA_METHOD | CHAR | 1 | 0 | Control Settings for FiMa Connection | ||
164 | ![]() |
TB_GRACEDAYS | NUM03 | NUMC | 3 | 0 | Grace Days | ||
165 | ![]() |
TB_NOIOA_TILL_BLOCK | DATS | DATS | 8 | 0 | End Date of Non-IOA Period | ||
166 | ![]() |
0 | 0 | Fields for Consumer Line of Credit | |||||
167 | ![]() |
VVRP_RELEVANT | XFELD | CHAR | 1 | 0 | Indicator: 'CLC-Relevant' | ||
168 | ![]() |
0 | 0 | SEPA: BIC / IBAN for a Contract | |||||
169 | ![]() |
SWIFT | SWIFT | CHAR | 11 | 0 | SWIFT/BIC for International Payments | ||
170 | ![]() |
BU_IBAN | CHAR34 | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
171 | ![]() |
TB_SEPA_IBAN_DET | TB_SEPA_IBAN_DET_DOM | CHAR | 1 | 0 | IBAN Determination Type for Contract | ||
172 | ![]() |
0 | 0 | Planned records | |||||
173 | ![]() |
VDBEPP_DBEAR | DATUM | DATS | 8 | 0 | Planned Records Last Edited On | ||
174 | ![]() |
VDBEPP_TBEAR | TIMES | TIMS | 6 | 0 | Planned Records Last Edited At | ||
175 | ![]() |
VDBEPP_RBHER | CHAR10 | CHAR | 10 | 0 | Planned Records Editing Source |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |