SAP ABAP Table RVZZMASTERDATA (Master Data Structure)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CML (Application Component) Loans Management
     FVVD (Package) Treasury Loans
Basic Data
Table Category INTTAB    Structure 
Structure RVZZMASTERDATA   Table Relationship Diagram
Short Description Master Data Structure    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 VDARL VDARL   STRU 0   0    
2 MANDT MANDT MANDT CLNT 3   0   Client  
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 RERF RERF SYCHAR12 CHAR 12   0   Entered by  
7 DERF DERF DATUM DATS 8   0   First Entered on  
8 TERF TERF TIMES TIMS 6   0   Time of Initial Entry  
9 REHER REHER CHAR10 CHAR 10   0   Source of initial entry  
10 RBEAR RBEAR SYCHAR12 CHAR 12   0   Employee ID  
11 DBEAR DBEAR DATUM DATS 8   0   Last Edited on  
12 TBEAR TBEAR TIMES TIMS 6   0   Last Edited at  
13 RBHER RBHER CHAR10 CHAR 10   0   Editing Source  
14 SOBJEKT VVKEYOBJ VVKEY CHAR 10   0   Internal key for object  
15 SSTATI SSTATI STATI NUMC 2   0   Status of data record  
16 SANLF SANLF VVSANLF NUMC 3   0   Product Category  
17 GSART VVSART VVSART CHAR 3   0   Product Type  
18 RREFKONT RREFKONT USTRU CHAR 8   0   Account Assignment Reference in Financial Assets Management  
19 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank  
20 HKTID HKTID HKTID CHAR 5   0   ID for account details  
21 STITEL STITEL STITEL NUMC 3   0   Loan Type Indicator  
22 SGLZB SGLZB SGLZB CHAR 4   0   SCB asset group indicator  
23 SFIBG SFIBG SFIBG NUMC 4   0   Asset Grouping Indicator  
24 SBILK SBILK SBILK CHAR 2   0   Balance Sheet Indicator  
25 XALKZ XALKZ XKBEZ CHAR 15   0   Short name  
26 XALLB XALLB XLBEZ CHAR 60   0   Long name  
27 XAKT XAKT CHAR32 CHAR 32   0   File Number  
28 RANLALT1 RANLALT1 CHAR13 CHAR 13   0   Alternative Identification  
29 RANLALT2 RANLALT2 CHAR13 CHAR 13   0   Alternative identification 2  
30 SGR1 SGRP1 SGRP1 CHAR 6   0   Group Key 1 (Freely Available)  
31 SGR2 SGRP2 SGRP2 CHAR 6   0   Group Key 2 (Freely Available)  
32 RKLAMMER RKLAMMER RANL CHAR 13   0   Classification Number for Finance Projects  
33 RANLKET RANLHPT CHAR13 CHAR 13   0   Principle loan investment number  
34 RANTRAG RANTRAG CHAR13 CHAR 13   0   Application number  
35 SSOLIST VVSSOLIST VVSSOLIST CHAR 1   0   Plan/Actual principle  
36 SFRIST SFRIST SFRIST NUMC 2   0   Loan Term  
37 BANTRAG BANTRAG BWHR CURR 13   2   Capital applied for  
38 SANTWHR SWHR WAERS CUKY 5   0   Currency  
39 DANTRAG DANTRAG DATUM DATS 8   0   Entry Date of Loan Application  
40 BZUSAGE BZUSAGE WERTV7 CURR 13   2   Commitment capital  
41 DZUSAGE DZUSAGE DATUM DATS 8   0   Loan - Date of Commitment by Lender  
42 DZUSAGE_ORIGIN DZUSAGE_ORIGIN DATUM DATS 8   0   Date of the Original Approval from the Lender  
43 DBLFZ DBLFZ DATUM DATS 8   0   Start of Term  
44 DELFZ DENDLFZ DATUM DATS 8   0   End of Loan Term  
45 DBDIS DBDIS DDAT DATS 8   0   Start of distribution of discount  
46 SDISMETH SDISMETH DISMETH NUMC 1   0   Discount distribution method  
47 SSICHER SSICHER SSICH CHAR 4   0   Primary collateral  
48 SVZWECK SVZWECK SVZWK CHAR 2   0   Purpose of Loan  
49 SSONDER SSONDER SSONDER NUMC 2   0   Special treatment of loan  
50 SFIWO SFIWO SFIWO CHAR 2   0   Indicator: Type of Residential Object Financing  
51 SDTI SDTI NUMC NUMC 5   0   DTI indicator  
52 SHOME SHOME SHOME NUMC 3   0   Home statement  
53 SLAENDER SLAENDER LAND1 CHAR 3   0   Country ID  
54 AABTRET AABTRET NUM02 NUMC 2   0   Number of Assignments Still Possible  
55 BABTRET BABTRET BWHR CURR 13   2   Minimum amount for assignments  
56 SNICHTAB SNICHTAB SNICHTAB NUMC 2   0   Reason for Non-Acceptance  
57 DARCHIV DARCHIV DATUM DATS 8   0   Date of Rejection/Withdrawal  
58 BGESDAR BGESDAR BWHR CURR 13   2   Total amount of syndicated loan  
59 DKONS DKONS DATUM DATS 8   0   Syndicate loan date  
60 SKWGKRED SKWGKRED SKWGKRED NUMC 1   0   Credit category indicator Para. 75 report (Austria)  
61 SKWGDAR SKWGDAR SKWGDAR NUMC 1   0   Credit type indicator for Austrian reporting  
62 JORIG BUCHSYS BUCHSYS NUMC 1   0   Posting system indicator for borrower's note loans  
63 VVSLOEKZ VVSLOEKZ VVSLOEKZ NUMC 1   0   Deletion indicator  
64 SDTYP VVSDTYP VVSDTYP NUMC 3   0   Loans Class  
65 DBEWI VVDBEWI DATUM DATS 8   0   Approval date  
66 SABTRANS VVSABTRANS XFELD CHAR 1   0   Indicator for Possible Foreign Assignment  
67 AKONS VVAKONS NUM03 NUMC 3   0   Number of syndicate members  
68 SFGKZ VVSFGKZ VVSFGKZ CHAR 1   0   Release Indicator  
69 SABT VVSABT VVSABT CHAR 4   0   Assignee  
70 MABER MABER MABER CHAR 2   0   Dunning Area  
71 MAHNS MAHNS_D MAHNS NUMC 1   0   Dunning Level  
72 MADAT MADAT DATUM DATS 8   0   Date of Last Dunning Notice  
73 RPNR VVRPNR NUMC08 NUMC 8   0   Activity number/rollover number  
74 RSBEAR DUMMY_12 CHAR12 CHAR 12   0   Dummy field 12 characters CHAR  
75 SONDST VVSONDST VVSONDST CHAR 2   0   Special posting treatment  
76 SGRP3 SGRP3 SGRP3 CHAR 6   0   Group Key 3 (Freely Available)  
77 SGRP4 SGRP4 SGRP4 CHAR 6   0   Group Key 4 (Freely Available)  
78 SZKEY VVSZKEY VVSZKEY NUMC 2   0   Indicator for Control of Incoming Payment Distribution  
79 BEGRU BEGRU BEGRU CHAR 4   0   Authorization Group  
80 SVERFU VVSVERFU VVSVERFU NUMC 2   0   Type of Restraint on Drawing  
81 STITART VVSTITART VVSTITART NUMC 2   0   Borrower's Note Loan Security Type  
82 NABTRV VVNABTRV CHAR15 CHAR 15   0   Contract of assignment number  
83 NAVAL VVNAVAL CHAR15 CHAR 15   0   Guarantee number  
84 DABTR VVDABTR DATUM DATS 8   0   Date of assignment  
85 DVERFU VVDVERFU DATUM DATS 8   0   Date of restraint on disposal upto  
86 SFGBEW VVSFGBEW VVSFGBEW NUMC 2   0   Transaction data to be released available  
87 DELSOZ VVDLESOZ DATUM DATS 8   0   Date of last special interest payment period  
88 RPORTB RPORTB RPORTB CHAR 10   0   Portfolio  
89 SREGION VVSREGION VVSREGION CHAR 4   0   Sales Region  
90 SGESST VVSGESST VVSGESST CHAR 4   0   Branch Office  
91 SBEA VVSBEA VVSBEA NUMC 2   0   Loan Processing Indicator  
92 SOBEZ VVSOBEZ CHAR2 CHAR 2   0   Organizational District  
93 SBEZIRK VVSBEZIRK CHAR4 CHAR 4   0   Agent District  
94 SPLIT VVSPLIT XFELD CHAR 1   0   Debit position splitting  
95 BNBUERG VVBNBUERG WERTV7 CURR 13   2   Initial capital not guaranteed  
96 SREFZINS VVSREFZINS XFELD CHAR 1   0   Loan With Reference Interest Rate  
97 SMAHNM VVSMAHNM VVSMAHNM CHAR 1   0   Loan Manual Dunning Level  
98 SIHERK CHAR2 CHAR2 CHAR 2   0   Version Number Component  
99 RGENUM CHAR10 CHAR10 CHAR 10   0   Character Field Length = 10  
100 DRUECK VVDRUECK DATUM DATS 8   0   Date when loan will probably be redeemed  
101 SABGRENZ VVSABGRD VVSABGRD CHAR 1   0   Loan Discount Accrual/Deferral Method  
102 SFEST VVFESTKZ VVFESTKZ CHAR 1   0   Indicator for Control of Fixed Contract  
103 SRATING BP_RATING BP_RATING CHAR 3   0   Rating  
104 SRATAGEN SRATAGEN_NEW BU_PARTNER CHAR 10   0   Rating agency  
105 RDARNEHM BP_PARTNR_NEW BU_PARTNER CHAR 10   0   Business Partner Number  
106 OBJNR TB_FINOBJNR J_OBJNR CHAR 22   0   Object Number for Financial Transactions  
107 HDN_KUNNR HDN_KUNNR KUNNR CHAR 10   0   Main Borrower Customer Number  
108 SKWG14_NEU VVSKWG14 VVSKWG14 CHAR 2   0   Position grouping acc. Para 14 GBA (Sec. and loans)  
109 RANLSTAMNR RANLSTAMNR RANL CHAR 13   0   Master number part of loan number for finding contracts  
110 MIGDATE MIGDATE DATUM DATS 8   0   Migration date  
111 SDUNNCMP SDUNNCMP SDUNNCMP CHAR 2   0   Summarization Level for Dunning Letter  
112 XNODUNN XNODUNN XFELD CHAR 1   0   Exclude Loan from Dunning Run  
113 ZUOND TB_ZUOND TEXT18 CHAR 18   0   Assignment  
114 REFER TB_REFER CHAR16 CHAR 16   0   Internal Reference  
115 MERKM TB_MERKM CHAR25 CHAR 25   0   Characteristics  
116 SDUNCHARG SDUNCHARG XFELD CHAR 1   0   Post Dunning Charges and Interest to this Contract  
117 SWHRORG SWHRORG WAERS CUKY 5   0   Loan currency before conversion to EURO  
118 DCONVERT DCONVERT DATE DATS 8   0   Date loan was converted to EURO  
119 DCORRECT DCORRECT DATE DATS 8   0   Date for adjustment flows resulting from EURO conversion  
120 SAKTPAS VVSAKTPAS VVSAKTPAS CHAR 1   0   Indicator: Asset/Liability Transaction  
121 RPZAHL TB_RPZAHL_NEW BU_PARTNER CHAR 10   0   Payer/payee  
122 GSBER GSBER GSBER CHAR 4   0   Business Area  
123 JNOREPAY TB_JNOREPAY XFELD CHAR 1   0   Payoff Lock  
124 JNODOIP TB_JNODOIP XFELD CHAR 1   0   Blocked by Payoff: No Open Item Clearing for Loan  
125 COM_VAL_CLASS TPM_COM_VAL_CLASS TPM_COM_VAL_CLASS NUMC 4   0   General Valuation Class  
126 SARC_EXCL TB_SARC_EXCL T_SARC_EXCL CHAR 1   0   Documents For The Loan May Not Be Archived  
127 SARC_DOCS TB_SARC_DOCS T_SARC_DOCS CHAR 1   0   Indicator: Archived Loan Documents Exist  
128 NO_PLAN_DONE TB_NO_PLAN_DONE CHECKBOX CHAR 1   0   Do Not Transfer Loan to Status "Completed"  
129 DPLAN_SET TB_DPLAN_SET DATUM DATS 8   0   Date of Transfer of Contract into Status Planned Completed  
130 DOPEN TB_DOPEN DATUM DATS 8   0   Opening Date of a Loan Contract  
131 DCLOSE TB_DCLOSE DATUM DATS 8   0   Closing Date of a Loan Contract  
132 DUNN_BLOCK_TILL TB_VIEW_DATE_DUNNING_BLOCK_TIL DATUM DATS 8   0   Expiration Date of Dunning Lock  
133 XNOIOA TB_XNOIOA CHAR1 CHAR 1   0   Lock for Interest on Arrears  
134 NOIOA_TILL TB_NOIOA_TILL DATUM DATS 8   0   Expiry Date of Lock on Interest on Arrears  
135 ORIGIN TB_ORIGIN T_ORIGIN CHAR 2   0   Loan Origin  
136 DCALLEND TB_DCALLEND DATUM DATS 8   0   Provision Expiry Date  
137 SVER_EXCL TB_SVER_EXCL T_SVER_EXCL CHAR 1   0   Documents for the loan may not be summarized  
138 .INCLUDE       0   0   Processing Characteristics of a Loan  
139 LC_DISBURSEMENT TB_LC_CHARAC_DISBURSEMENT T_LC_CHARACVALUE CHAR 1   0   Processing Characteristic: Disbursement Status  
140 LC_CAPITALS TB_LC_CHARAC_CAPITALS T_LC_CHARACVALUE CHAR 1   0   Processing Characteristic: Status of Capital Amounts  
141 LC_PLANNED_FLOW TB_LC_CHARAC_PLANNED_FLOW T_LC_CHARACVALUE CHAR 1   0   Processing Characteristic: Status of Planned Records  
142 LC_DEBIT TB_LC_CHARAC_DEBIT T_LC_CHARACVALUE CHAR 1   0   Processing Characteristic: Status of Customer Receivables  
143 LC_CREDIT TB_LC_CHARAC_CREDIT T_LC_CHARACVALUE CHAR 1   0   Processing Characteristic: Status of Customer Payables  
144 LC_STATUS TB_LC_STATUS T_LC_STATUS CHAR 1   0   Status of Processing Characteristics for Loan  
145 PAYM_STATUS TB_PAYM_STATUS T_PAYM_STATUS CHAR 1   0   Payment Status  
146 STOP_INDICATOR TB_STOP_INDICATOR T_STOP_INDICATOR CHAR 1   0   Stop Indicator  
147 PRODUCT_ID TB_PR_PRODINT T_PR_PRODINT CHAR 18   0   Internal Product ID  
148 PRODUCT_VERSION TB_PR_VERSION T_PR_VERSION NUMC 4   0   Product Version  
149 SCHUFA_MESSAGE TB_VIEW_SCHUFA XFELD CHAR 1   0   Business Partner Has Signed a Schufa Declaration  
150 DAT_FULL_PAY TB_VIEW_DATE_OF_FULL_PAYMENT DATUM DATS 8   0   Date of Full Disbursement  
151 DAT_OF_CANCEL TB_VIEW_DATE_OF_CANCELATION DATUM DATS 8   0   Rescission Date  
152 FLG_CNCL TB_CNCL BOOLE CHAR 1   0   Rescission Indicator  
153 DINSTR TB_DINSTR DATUM DATS 8   0   Date Customer Was Instructed About Rescission Rights  
154 ORGUNIT TB_MD_ORGUNIT_CNMGT T_MD_ORGUNIT_CNMGT CHAR 12   0   Organizational Unit  
155 DISTRIB_CHANNEL TB_MD_DISTRIBUTION_CHANNEL T_MD_DISTRIBUTION_CHANNEL CHAR 10   0   Sales Channel  
156 FLG_CNCL_CLI TB_CNCL_CLI T_CNCL_CLI CHAR 1   0   Indicator: Rescind Credit Life Insurance  
157 FLG_NO_CHANGE TB_MD_NO_CHANGE TB_MD_NO_CHANGE CHAR 1   0   Only Limited Changes Possible for Contract Indicator  
158 SCHEME_ID TB_SCHEME_ID T_SCHEME_ID CHAR 3   0   Calculation Profile for Interest on Arrears Calculation  
159 SSTATE_OF_EXEC TB_SREGION REGIO CHAR 3   0   Region Where Contract Concluded  
160 WAIVE_REASON TB_WAIVE_REASON T_WAIVE_REASON CHAR 3   0   Reason for Automatic Waiver of Charges  
161 WAIVE_METHOD TB_WAIVE_METHOD T_WAIVE_METHOD NUMC 1   0   Waiver Method  
162 BACKOFFICE_ID TB_BACKOFFICE_ID HROBJID NUMC 8   0   Back Office  
163 FLG_NON_ACCRUAL TB_FLG_NON_ACCRUAL XFELD CHAR 1   0   Non-Accrual Status Permitted  
164 SFIMA_METHOD TB_FIMA_METHOD T_FIMA_METHOD CHAR 1   0   Control Settings for FiMa Connection  
165 GRACE_DAYS TB_GRACEDAYS NUM03 NUMC 3   0   Grace Days  
166 NOIOA_TILL_BLOCK TB_NOIOA_TILL_BLOCK DATS DATS 8   0   End Date of Non-IOA Period  
167 .INCLU--AP       0   0   Fields for Consumer Line of Credit  
168 RP_RELEVANT VVRP_RELEVANT XFELD CHAR 1   0   Indicator: 'CLC-Relevant'  
169 .INCLU--AP       0   0   SEPA: BIC / IBAN for a Contract  
170 CONTRACT_BIC SWIFT SWIFT CHAR 11   0   SWIFT/BIC for International Payments  
171 CONTRACT_IBAN BU_IBAN CHAR34 CHAR 34   0   IBAN (International Bank Account Number)  
172 IBAN_DET TB_SEPA_IBAN_DET TB_SEPA_IBAN_DET_DOM CHAR 1   0   IBAN Determination Type for Contract  
173 .INCLU--AP       0   0   Planned records  
174 VDBEPP_DBEAR VDBEPP_DBEAR DATUM DATS 8   0   Planned Records Last Edited On  
175 VDBEPP_TBEAR VDBEPP_TBEAR TIMES TIMS 6   0   Planned Records Last Edited At  
176 VDBEPP_RBHER VDBEPP_RBHER CHAR10 CHAR 10   0   Planned Records Editing Source  
177 VDARLDVS VDARLDVS   STRU 0   0    
178 MANDT MANDT MANDT CLNT 3   0   Client  
179 BUKRS BUKRS BUKRS CHAR 4   0   Company Code  
180 SARCHIV SARCHIV SARCHIV CHAR 1   0   Archiving Category Indicator  
181 RANL RANL RANL CHAR 13   0   Contract Number  
182 DBEGINEKA DBEGINEKA CK_DATUM DATS 8   0   Start date of last external account statement  
183 DLASTEKA DLASTEKA DATUM DATS 8   0   Key date of last external account statement  
184 DCREATEEKA DCREATEEKA CK_DATUM DATS 8   0   Creation date of last external account statement  
185 SRHYEKA CREARHYEKA ERSTRHY NUMC 1   0   Generation frequency of external account statement  
186 STMTNREKA STMTNREKA NUMC07 NUMC 7   0   Number of last account statement  
187 RESTCAPEKA RESTCAPEKA WERTV7 CURR 13   2   Remaining capital at evaluation start of ext. acct statement  
188 DLASTZB DLASTZB CK_DATUM DATS 8   0   Key date of the last interest certificate  
189 SPROCZB SPROCZB BZVERARB NUMC 1   0   Processing type of interest certificate  
190 CORR_ROLE TB_CORR_ROLE CORR_ROLE_KK CHAR 4   0   Correspondence Role  
191 TCREATEEKA TB_CREATION_TSTAMP TZNTSTMPS DEC 15   0   Creation Date and Time (Time Stamp)  
192 EKA_NOT_PRINTED TB_EKA_NOT_PRINTED_FLAG BOOLE CHAR 1   0   Account Statment Ordered But Not Yet Printed  
193 VZSORT VZSORT   STRU 0   0    
194 MANDT MANDT MANDT CLNT 3   0   Client  
195 SNUMOBJ VVNUMOBJ VVNUMOBJ CHAR 2   0   Key for number range object  
196 SOBJEKT VVSOBJGPO CHAR13 CHAR 13   0   Internal key for object for business partner table  
197 SLWID SLWID SLWID CHAR 7   0   Key word ID for user-defined fields  
198 USR00 USRCHAR20 USRCHAR20 CHAR 20   0   User field with 20 characters  
199 USR01 USRCHAR20 USRCHAR20 CHAR 20   0   User field with 20 characters  
200 USR02 USRCHAR10 USRCHAR10 CHAR 10   0   User field with 10 characters  
201 USR03 USRCHAR10 USRCHAR10 CHAR 10   0   User field with 10 characters  
202 USR04 USRQUAN13 USRQUAN13 QUAN 13   3   User field for quantity (length 10.3)  
203 USE04 USRUNIT MEINS UNIT 3   0   User field: Unit for quantity fields  
204 USR05 USRQUAN13 USRQUAN13 QUAN 13   3   User field for quantity (length 10.3)  
205 USE05 USRUNIT MEINS UNIT 3   0   User field: Unit for quantity fields  
206 USR06 USRCURR13 USRCURR13 CURR 13   3   User-defined field for values (length 10,3)  
207 USE06 USRCUKY WAERS CUKY 5   0   User field: Unit for value fields  
208 USR07 USRCURR13 USRCURR13 CURR 13   3   User-defined field for values (length 10,3)  
209 USE07 USRCUKY WAERS CUKY 5   0   User field: Unit for value fields  
210 USR08 USRDATE USRDATE DATS 8   0   User field for date  
211 USR09 USRDATE USRDATE DATS 8   0   User field for date  
212 USR10 USRFLAG FLAG CHAR 1   0   User-defined field: Indicator for reports  
213 USR11 USRFLAG FLAG CHAR 1   0   User-defined field: Indicator for reports  
History
Last changed by/on SAP  20130529 
SAP Release Created in 600