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