TTONFTVDARL - Test New FIMA: Basic Data and VDARL

Test New FIMA: Basic Data and VDARL information is stored in SAP table TTONFTVDARL.
It is part of development package FVVD_TEST_NEW_FIMA in software component FS-CML. This development package consists of objects that can be grouped under "Test of New FIMA".

Fields for table TTONFTVDARL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
GUID	GUID in 'RAW' format	X	GUID_16	RAW	16
.INCLUDE				VDARL_KEY	0
BUKRS	Company Code		BUKRS	CHAR	8
SARCHIV	Archiving Category Indicator		SARCHIV	CHAR	2
RANL	Contract Number		RANL	CHAR	26
FLG_STATE	'C' =Completed, 'E' = Excluded from Comparison			CHAR	2
IM_SSOLIST	Plan/Actual principle		VVSSOLIST	CHAR	2
IM_SAKTPAS	Indicator: Asset/Liability Transaction		VVSAKTPAS	CHAR	2
IM_END_DATE	End Date for Cash Flow Comparison			DATS	16
IM_LOANCHARAC	Determination of Effects of Flows on Processing			CHAR	2
BFRATE_OLD	Amount in position currency		BBWHR	CURR	7
BFRATE_NEW	Amount in position currency		BBWHR	CURR	7
DATUM_LFZ_OLD				DATS	16
DATUM_LFZ_NEW				DATS	16
DRSALDO_OLD				DATS	16
DRSALDO_NEW				DATS	16
RSALDO_OLD	Nominal amount		BNWHR	CURR	7
RSALDO_NEW	Nominal amount		BNWHR	CURR	7
.INCLUDE	VDARL			TTONFVDARL	0
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
SOBJEKT	Internal key for object		VVKEYOBJ	CHAR	20
SSTATI	Status of data record		SSTATI	NUMC	4	*
SANLF	Product Category		SANLF	NUMC	6	*
GSART	Product Type		VVSART	CHAR	6
RREFKONT	Account Assignment Reference in Financial Assets Management		RREFKONT	CHAR	16	*
HBKID	Short Key for a House Bank		HBKID	CHAR	10	*
HKTID	ID for Account Details		HKTID	CHAR	10	*
STITEL	Loan Type Indicator		STITEL	NUMC	6	*
SGLZB	SCB Asset Group Indicator		SGLZB	CHAR	8	*
SFIBG	Asset Grouping Indicator		SFIBG	NUMC	8	*
SBILK	Balance Sheet Indicator		SBILK	CHAR	4	*
XALKZ	Short Name		XALKZ	CHAR	30
XALLB	Long Name		XALLB	CHAR	120
XAKT	File Number		XAKT	CHAR	64
RANLALT1	Alternative Identification		RANLALT1	CHAR	26
RANLALT2	Alternative identification 2		RANLALT2	CHAR	26
SGR1	Group Key 1 (Freely Available)		SGRP1	CHAR	12	*
SGR2	Group Key 2 (Freely Available)		SGRP2	CHAR	12	*
RKLAMMER	Classification Number for Finance Projects		RKLAMMER	CHAR	26
RANLKET	Principle loan investment number		RANLHPT	CHAR	26
RANTRAG	Application number		RANTRAG	CHAR	26
SSOLIST	Plan/Actual principle		VVSSOLIST	CHAR	2
SFRIST	Loan Term		SFRIST	NUMC	4	*
BANTRAG	Capital applied for		BANTRAG	CURR	7
SANTWHR	Currency		SWHR	CUKY	10	*
DANTRAG	Entry Date of Loan Application		DANTRAG	DATS	16
BZUSAGE	Commitment capital		BZUSAGE	CURR	7
DZUSAGE	Loan - Date of Commitment by Lender		DZUSAGE	DATS	16
DZUSAGE_ORIGIN	Date of the Original Approval from the Lender		DZUSAGE_ORIGIN	DATS	16
DBLFZ	Start of Term		DBLFZ	DATS	16
DELFZ	End of Loan Term		DENDLFZ	DATS	16
DBDIS	Start of distribution of discount		DBDIS	DATS	16
SDISMETH	Discount distribution method		SDISMETH	NUMC	2
SSICHER	Primary collateral		SSICHER	CHAR	8	*
SVZWECK	Purpose of Loan		SVZWECK	CHAR	4	*
SSONDER	Special treatment of loan		SSONDER	NUMC	4	*
SFIWO	Indicator: Type of Residential Object Financing		SFIWO	CHAR	4	*
SDTI	DTI indicator		SDTI	NUMC	10
SHOME	Home statement		SHOME	NUMC	6	*
SLAENDER	Country/Region ID		SLAENDER	CHAR	6	*
AABTRET	Number of Assignments Still Possible		AABTRET	NUMC	4
BABTRET	Minimum amount for assignments		BABTRET	CURR	7
SNICHTAB	Reason for Non-Acceptance		SNICHTAB	NUMC	4	*
DARCHIV	Date of Rejection/Withdrawal		DARCHIV	DATS	16
BGESDAR	Total amount of syndicated loan		BGESDAR	CURR	7
DKONS	Syndicate loan date		DKONS	DATS	16
SKWGKRED	Credit category indicator Para. 75 report (Austria)		SKWGKRED	NUMC	2	*
SKWGDAR	Credit type indicator for Austrian reporting		SKWGDAR	NUMC	2	*
JORIG	Posting system indicator for borrower's note loans		BUCHSYS	NUMC	2
VVSLOEKZ	Deletion indicator		VVSLOEKZ	NUMC	2
SDTYP	Loans Class		VVSDTYP	NUMC	6	*
DBEWI	Approval date		VVDBEWI	DATS	16
SABTRANS	Indicator for Possible Foreign Assignment		VVSABTRANS	CHAR	2
AKONS	Number of syndicate members		VVAKONS	NUMC	6
SFGKZ	Release Indicator		VVSFGKZ	CHAR	2
SABT	Assignee		VVSABT	CHAR	8	*
MABER	Dunning Area		MABER	CHAR	4	*
MAHNS	Dunning Level		MAHNS_D	NUMC	2
MADAT	Date of Last Dunning Notice		MADAT	DATS	16
RPNR	Activity number/rollover number		VVRPNR	NUMC	16
RSBEAR	Dummy field 12 characters CHAR		DUMMY_12	CHAR	24
SONDST	Special posting treatment		VVSONDST	CHAR	4	*
SGRP3	Group Key 3 (Freely Available)		SGRP3	CHAR	12	*
SGRP4	Group Key 4 (Freely Available)		SGRP4	CHAR	12	*
SZKEY	Indicator for Control of Incoming Payment Distribution		VVSZKEY	NUMC	4	*
BEGRU	Authorization Group		BEGRU	CHAR	8
SVERFU	Type of Restraint on Drawing		VVSVERFU	NUMC	4	*
STITART	Borrower's Note Loan Security Type		VVSTITART	NUMC	4	*
NABTRV	Contract of assignment number		VVNABTRV	CHAR	30
NAVAL	Guarantee number		VVNAVAL	CHAR	30
DABTR	Date of assignment		VVDABTR	DATS	16
DVERFU	Date of restraint on disposal upto		VVDVERFU	DATS	16
SFGBEW	Transaction data to be released available		VVSFGBEW	NUMC	4
DELSOZ	Date of last special interest payment period		VVDLESOZ	DATS	16
RPORTB	Portfolio		RPORTB	CHAR	20
SREGION	Sales Region		VVSREGION	CHAR	8	*
SGESST	Branch Office		VVSGESST	CHAR	8	*
SBEA	Loan Processing Indicator		VVSBEA	NUMC	4
SOBEZ	Organizational District		VVSOBEZ	CHAR	4
SBEZIRK	Agent District		VVSBEZIRK	CHAR	8
SPLIT	Debit position splitting		VVSPLIT	CHAR	2
BNBUERG	Initial capital not guaranteed		VVBNBUERG	CURR	7
SREFZINS	Loan With Reference Interest Rate		VVSREFZINS	CHAR	2
SMAHNM	Loan Manual Dunning Level		VVSMAHNM	CHAR	2	*
SIHERK	Component of the Version Number		CHAR2	CHAR	4
RGENUM	Character Field with Length 10		CHAR10	CHAR	20
DRUECK	Date when loan will probably be redeemed		VVDRUECK	DATS	16
SABGRENZ	Loan Discount Accrual/Deferral Method		VVSABGRD	CHAR	2
SFEST	Indicator for Control of Fixed Contract		VVFESTKZ	CHAR	2
SRATING	Rating		BP_RATING	CHAR	6	*
SRATAGEN	Rating agency		SRATAGEN_NEW	CHAR	20
RDARNEHM	Business Partner Number		BP_PARTNR_NEW	CHAR	20
OBJNR	Object Number for Financial Transactions		TB_FINOBJNR	CHAR	44	*
HDN_KUNNR	Main Borrower Customer Number		HDN_KUNNR	CHAR	20	*
SKWG14_NEU	Position Grouping Acc. Article 14 GBA (Sec. and Loans)		VVSKWG14	CHAR	4
RANLSTAMNR	Master number part of loan number for finding contracts		RANLSTAMNR	CHAR	26
MIGDATE	Migration date		MIGDATE	DATS	16
SDUNNCMP	Summarization Level for Dunning Letter		SDUNNCMP	CHAR	4
XNODUNN	Exclude Loan from Dunning Run		XNODUNN	CHAR	2
REFER	Internal Reference		TB_REFER	CHAR	32
MERKM	Characteristics		TB_MERKM	CHAR	50
SDUNCHARG	Post Dunning Charges and Interest to this Contract		SDUNCHARG	CHAR	2
SWHRORG	Loan currency before conversion to EURO		SWHRORG	CUKY	10	*
DCONVERT	Date loan was converted to EURO		DCONVERT	DATS	16
DCORRECT	Date for adjustment flows resulting from EURO conversion		DCORRECT	DATS	16
SAKTPAS	Indicator: Asset/Liability Transaction		VVSAKTPAS	CHAR	2
RPZAHL	Payer/Payee		TB_RPZAHL_NEW	CHAR	20
GSBER	Business Area		GSBER	CHAR	8	*
JNOREPAY	Payoff Lock		TB_JNOREPAY	CHAR	2
JNODOIP	Blocked by Payoff: No Open Item Clearing for Loan		TB_JNODOIP	CHAR	2
COM_VAL_CLASS	General Valuation Class		TPM_COM_VAL_CLASS	NUMC	8	*
SARC_EXCL	Documents For The Loan May Not Be Archived		TB_SARC_EXCL	CHAR	2
SARC_DOCS	Indicator: Archived Loan Documents Exist		TB_SARC_DOCS	CHAR	2
NO_PLAN_DONE	Do Not Transfer Loan to Status "Completed"		TB_NO_PLAN_DONE	CHAR	2
DPLAN_SET	Date of Transfer of Contract into Status Planned Completed		TB_DPLAN_SET	DATS	16
DOPEN	Opening Date of a Loan Contract		TB_DOPEN	DATS	16
DCLOSE	Closing Date of a Loan Contract		TB_DCLOSE	DATS	16
DUNN_BLOCK_TILL	Expiration Date of Dunning Lock		TB_VIEW_DATE_DUNNING_BLOCK_TIL	DATS	16
XNOIOA	Lock for Interest on Arrears		TB_XNOIOA	CHAR	2
NOIOA_TILL	Expiry Date of Lock on Interest on Arrears		TB_NOIOA_TILL	DATS	16
ORIGIN	Loan Origin		TB_ORIGIN	CHAR	4	*
DCALLEND	Provision Expiry Date		TB_DCALLEND	DATS	16
SVER_EXCL	Documents for the loan may not be summarized		TB_SVER_EXCL	CHAR	2
.INCLUDE	RLC_CHARAC			RLC_CHARAC	0
LC_DISBURSEMENT	Processing Characteristic: Disbursement Status		TB_LC_CHARAC_DISBURSEMENT	CHAR	2
LC_CAPITALS	Processing Characteristic: Status of Capital Amounts		TB_LC_CHARAC_CAPITALS	CHAR	2
LC_PLANNED_FLOW	Processing Characteristic: Status of Planned Records		TB_LC_CHARAC_PLANNED_FLOW	CHAR	2
LC_DEBIT	Processing Characteristic: Status of Customer Receivables		TB_LC_CHARAC_DEBIT	CHAR	2
LC_CREDIT	Processing Characteristic: Status of Customer Payables		TB_LC_CHARAC_CREDIT	CHAR	2
LC_STATUS	Status of Processing Characteristics for Loan		TB_LC_STATUS	CHAR	2
PAYM_STATUS	Payment Status		TB_PAYM_STATUS	CHAR	2
STOP_INDICATOR	Stop Indicator		TB_STOP_INDICATOR	CHAR	2
PRODUCT_ID	Internal Product ID		TB_PR_PRODINT	CHAR	36	*
PRODUCT_VERSION	Product Version		TB_PR_VERSION	NUMC	8	*
SCHUFA_MESSAGE	Business Partner Has Signed a Schufa Declaration		TB_VIEW_SCHUFA	CHAR	2
DAT_FULL_PAY	Date of Full Disbursement		TB_VIEW_DATE_OF_FULL_PAYMENT	DATS	16
DAT_OF_CANCEL	Rescission Date		TB_VIEW_DATE_OF_CANCELATION	DATS	16
FLG_CNCL	Rescission Indicator		TB_CNCL	CHAR	2
DINSTR	Date Customer Was Instructed About Rescission Rights		TB_DINSTR	DATS	16
ORGUNIT	Organizational Unit		TB_MD_ORGUNIT_CNMGT	CHAR	24	*
DISTRIB_CHANNEL	Sales Channel		TB_MD_DISTRIBUTION_CHANNEL	CHAR	20	*
FLG_CNCL_CLI	Indicator: Rescind Credit Life Insurance		TB_CNCL_CLI	CHAR	2
FLG_NO_CHANGE	Only Limited Changes Possible for Contract Indicator		TB_MD_NO_CHANGE	CHAR	2
SCHEME_ID	Calculation Profile for Interest on Arrears Calculation		TB_SCHEME_ID	CHAR	6	*