SAP ABAP Table RESRVDARL_SOBJECT (CML Corr.: Structure VDARL + Field SOBJEKT From VDGPO)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CML (Application Component) Loans Management
     FVVD_CH (Package) CML - Country-Specifc Requirements for Switzerland
Basic Data
Table Category INTTAB    Structure 
Structure RESRVDARL_SOBJECT   Table Relationship Diagram
Short Description CML Corr.: Structure VDARL + Field SOBJEKT From VDGPO    
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 .INCLUDE       0   0   Loans  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
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 TZC37
16 SANLF SANLF VVSANLF NUMC 3   0   Product Category TZAF
17 GSART VVSART VVSART CHAR 3   0   Product Type TZPAB
18 RREFKONT RREFKONT USTRU CHAR 8   0   Account Assignment Reference in Financial Assets Management T037S
19 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank T012
20 HKTID HKTID HKTID CHAR 5   0   ID for account details T012K
21 STITEL STITEL STITEL NUMC 3   0   Loan Type Indicator TD03
22 SGLZB SGLZB SGLZB CHAR 4   0   SCB asset group indicator TW07
23 SFIBG SFIBG SFIBG NUMC 4   0   Asset Grouping Indicator TW08
24 SBILK SBILK SBILK CHAR 2   0   Balance Sheet Indicator TW11
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) TDDG1
31 SGR2 SGRP2 SGRP2 CHAR 6   0   Group Key 2 (Freely Available) TDDG2
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 TD09
37 BANTRAG BANTRAG BWHR CURR 13   2   Capital applied for  
38 SANTWHR SWHR WAERS CUKY 5   0   Currency TCURC
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 TD01
48 SVZWECK SVZWECK SVZWK CHAR 2   0   Purpose of Loan TD07
49 SSONDER SSONDER SSONDER NUMC 2   0   Special treatment of loan TD10
50 SFIWO SFIWO SFIWO CHAR 2   0   Indicator: Type of Residential Object Financing TD15
51 SDTI SDTI NUMC NUMC 5   0   DTI indicator  
52 SHOME SHOME SHOME NUMC 3   0   Home statement TD11
53 SLAENDER SLAENDER LAND1 CHAR 3   0   Country ID T005
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 TDA5
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) TZ35
61 SKWGDAR SKWGDAR SKWGDAR NUMC 1   0   Credit type indicator for Austrian reporting TZ34
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 TD02
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 TDS1
70 MABER MABER MABER CHAR 2   0   Dunning Area T047M
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 TD14
76 SGRP3 SGRP3 SGRP3 CHAR 6   0   Group Key 3 (Freely Available) TDDG3
77 SGRP4 SGRP4 SGRP4 CHAR 6   0   Group Key 4 (Freely Available) TDDG4
78 SZKEY VVSZKEY VVSZKEY NUMC 2   0   Indicator for Control of Incoming Payment Distribution TVZ01
79 BEGRU BEGRU BEGRU CHAR 4   0   Authorization Group  
80 SVERFU VVSVERFU VVSVERFU NUMC 2   0   Type of Restraint on Drawing TZV05
81 STITART VVSTITART VVSTITART NUMC 2   0   Borrower's Note Loan Security Type TD16
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 TWPOB
89 SREGION VVSREGION VVSREGION CHAR 4   0   Sales Region TD18
90 SGESST VVSGESST VVSGESST CHAR 4   0   Branch Office TD17
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 TDMAHNS_MAN
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 TP06
104 SRATAGEN SRATAGEN_NEW BU_PARTNER CHAR 10   0   Rating agency *
105 RDARNEHM BP_PARTNR_NEW BU_PARTNER CHAR 10   0   Business Partner Number BUT000
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 KNA1
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 TCURC
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 BUT000
122 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
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 TRGC_COM_VALCL
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 TDORIGIN
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 TD19
155 DISTRIB_CHANNEL TB_MD_DISTRIBUTION_CHANNEL T_MD_DISTRIBUTION_CHANNEL CHAR 10   0   Sales Channel TD30
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 TDIOA_SCHEME_DEF
159 SSTATE_OF_EXEC TB_SREGION REGIO CHAR 3   0   Region Where Contract Concluded T005S
160 WAIVE_REASON TB_WAIVE_REASON T_WAIVE_REASON CHAR 3   0   Reason for Automatic Waiver of Charges TDWAIVE_REASON
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 SOBJEKT_VDGPO VVSOBJGPO CHAR13 CHAR 13   0   Internal key for object for business partner table  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RESRVDARL_SOBJECT BUKRS T001 BUKRS KEY 1 1
2 RESRVDARL_SOBJECT COM_VAL_CLASS TRGC_COM_VALCL COM_VAL_CLASS    
3 RESRVDARL_SOBJECT DISTRIB_CHANNEL TD30 DISTRIB_CHANNEL    
4 RESRVDARL_SOBJECT GSART TZPAB GSART KEY 1 CN
5 RESRVDARL_SOBJECT GSBER TGSB GSBER    
6 RESRVDARL_SOBJECT HBKID T012 HBKID KEY 1 CN
7 RESRVDARL_SOBJECT HDN_KUNNR KNA1 KUNNR REF C CN
8 RESRVDARL_SOBJECT HKTID T012K HKTID KEY 1 CN
9 RESRVDARL_SOBJECT MABER T047M MABER KEY 1 CN
10 RESRVDARL_SOBJECT MANDT T000 MANDT KEY 1 1
11 RESRVDARL_SOBJECT ORGUNIT TD19 ORGUNIT    
12 RESRVDARL_SOBJECT ORIGIN TDORIGIN ORIGIN KEY    
13 RESRVDARL_SOBJECT RDARNEHM BUT000 PARTNER    
14 RESRVDARL_SOBJECT RPORTB TWPOB RPORTB KEY 1 CN
15 RESRVDARL_SOBJECT RPZAHL BUT000 PARTNER    
16 RESRVDARL_SOBJECT RREFKONT T037S RREFKONT KEY 1 CN
17 RESRVDARL_SOBJECT SABT TDS1 SABT KEY 1 CN
18 RESRVDARL_SOBJECT SANLF TZAF SANLF    
19 RESRVDARL_SOBJECT SANTWHR TCURC WAERS KEY 1 1
20 RESRVDARL_SOBJECT SBILK TW11 SBILK KEY 1 1
21 RESRVDARL_SOBJECT SCHEME_ID TDIOA_SCHEME_DEF SCHEME_ID    
22 RESRVDARL_SOBJECT SDTYP TD02 SDTYP KEY 1 CN
23 RESRVDARL_SOBJECT SFIBG TW08 SFIBG KEY 1 1
24 RESRVDARL_SOBJECT SFIWO TD15 SFIWO KEY 1 CN
25 RESRVDARL_SOBJECT SFRIST TD09 SFRIST    
26 RESRVDARL_SOBJECT SGESST TD17 SGESST KEY 1 CN
27 RESRVDARL_SOBJECT SGLZB TW07 SGLZB KEY 1 1
28 RESRVDARL_SOBJECT SGR1 TDDG1 SGRP1 KEY 1 CN
29 RESRVDARL_SOBJECT SGR2 TDDG2 SGRP2 KEY 1 CN
30 RESRVDARL_SOBJECT SGRP3 TDDG3 SGRP3 KEY 1 CN
31 RESRVDARL_SOBJECT SGRP4 TDDG4 SGRP4 KEY 1 CN
32 RESRVDARL_SOBJECT SHOME TD11 SHOME KEY 1 CN
33 RESRVDARL_SOBJECT SKWGDAR TZ34 SKWGDAR    
34 RESRVDARL_SOBJECT SKWGKRED TZ35 SKWGKRED    
35 RESRVDARL_SOBJECT SLAENDER T005 LAND1 KEY 1 1
36 RESRVDARL_SOBJECT SMAHNM TDMAHNS_MAN SMAHNM    
37 RESRVDARL_SOBJECT SNICHTAB TDA5 SNICHTAB    
38 RESRVDARL_SOBJECT SONDST TD14 SONDST KEY 1 CN
39 RESRVDARL_SOBJECT SRATING TP06 RATING    
40 RESRVDARL_SOBJECT SREGION TD18 SREGION KEY 1 CN
41 RESRVDARL_SOBJECT SSICHER TD01 SSICH KEY 1 CN
42 RESRVDARL_SOBJECT SSONDER TD10 SSONDER KEY 1 CN
43 RESRVDARL_SOBJECT SSTATE_OF_EXEC T005S BLAND KEY 1 CN
44 RESRVDARL_SOBJECT SSTATI TZC37 STATU KEY 1 CN
45 RESRVDARL_SOBJECT STITART TD16 STITART KEY 1 CN
46 RESRVDARL_SOBJECT STITEL TD03 STITEL KEY 1 CN
47 RESRVDARL_SOBJECT SVERFU TZV05 SVERFU KEY 1 CN
48 RESRVDARL_SOBJECT SVZWECK TD07 SVZWECK KEY 1 CN
49 RESRVDARL_SOBJECT SWHRORG TCURC WAERS    
50 RESRVDARL_SOBJECT SZKEY TVZ01 SZKEY KEY 1 CN
51 RESRVDARL_SOBJECT WAIVE_REASON TDWAIVE_REASON WAIVE_REASON KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 600