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
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |