SAP ABAP Table TTONFTVDARL (Test neue Fima: Grunddaten und VDARL)

Hierarchy

☛

EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷

FS-CML (Application Component) Loans Management
⤷

FVVD_TEST_NEW_FIMA (Package) Test der neuen Fima

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TTONFTVDARL	Table Relationship Diagram
Short Description	Test neue Fima: Grunddaten und VDARL

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components


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