VDARL - Loans

Loans information is stored in SAP table VDARL.
It is part of development package FVVD in software component FS-CML. This development package consists of objects that can be grouped under "Treasury Loans".

Fields for table VDARL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
SARCHIV	Archiving Category Indicator	X	SARCHIV	CHAR	2
RANL	Contract Number	X	RANL	CHAR	26
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	TZC37
SANLF	Product Category		SANLF	NUMC	6	TZAF
GSART	Product Type		VVSART	CHAR	6	TZPAB
RREFKONT	Account Assignment Reference in Financial Assets Management		RREFKONT	CHAR	16	T037S
HBKID	Short Key for a House Bank		HBKID	CHAR	10	T012
HKTID	ID for Account Details		HKTID	CHAR	10	T012K
STITEL	Loan Type Indicator		STITEL	NUMC	6	TD03
SGLZB	SCB Asset Group Indicator		SGLZB	CHAR	8	TW07
SFIBG	Asset Grouping Indicator		SFIBG	NUMC	8	TW08
SBILK	Balance Sheet Indicator		SBILK	CHAR	4	TW11
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	TDDG1
SGR2	Group Key 2 (Freely Available)		SGRP2	CHAR	12	TDDG2
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	TD09
BANTRAG	Capital applied for		BANTRAG	CURR	7
SANTWHR	Currency		SWHR	CUKY	10	TCURC
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	TD01
SVZWECK	Purpose of Loan		SVZWECK	CHAR	4	TD07
SSONDER	Special treatment of loan		SSONDER	NUMC	4	TD10
SFIWO	Indicator: Type of Residential Object Financing		SFIWO	CHAR	4	TD15
SDTI	DTI indicator		SDTI	NUMC	10
SHOME	Home statement		SHOME	NUMC	6	TD11
SLAENDER	Country/Region ID		SLAENDER	CHAR	6	T005
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	TDA5
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	TZ35
SKWGDAR	Credit type indicator for Austrian reporting		SKWGDAR	NUMC	2	TZ34
JORIG	Posting system indicator for borrower's note loans		BUCHSYS	NUMC	2
VVSLOEKZ	Deletion indicator		VVSLOEKZ	NUMC	2
SDTYP	Loans Class		VVSDTYP	NUMC	6	TD02
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	TDS1
MABER	Dunning Area		MABER	CHAR	4	T047M
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	TD14
SGRP3	Group Key 3 (Freely Available)		SGRP3	CHAR	12	TDDG3
SGRP4	Group Key 4 (Freely Available)		SGRP4	CHAR	12	TDDG4
SZKEY	Indicator for Control of Incoming Payment Distribution		VVSZKEY	NUMC	4	TVZ01
BEGRU	Authorization Group		BEGRU	CHAR	8
SVERFU	Type of Restraint on Drawing		VVSVERFU	NUMC	4	TZV05
STITART	Borrower's Note Loan Security Type		VVSTITART	NUMC	4	TD16
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	TWPOB
SREGION	Sales Region		VVSREGION	CHAR	8	TD18
SGESST	Branch Office		VVSGESST	CHAR	8	TD17
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	TDMAHNS_MAN
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	TP06
SRATAGEN	Rating agency		SRATAGEN_NEW	CHAR	20
RDARNEHM	Business Partner Number		BP_PARTNR_NEW	CHAR	20	BUT000
OBJNR	Object Number for Financial Transactions		TB_FINOBJNR	CHAR	44
HDN_KUNNR	Main Borrower Customer Number		HDN_KUNNR	CHAR	20	KNA1
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	TCURC
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	BUT000
GSBER	Business Area		GSBER	CHAR	8	TGSB
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	TRGC_COM_VALCL
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	TDORIGIN
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	TD19
DISTRIB_CHANNEL	Sales Channel		TB_MD_DISTRIBUTION_CHANNEL	CHAR	20	TD30
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	TDIOA_SCHEME_DEF
SSTATE_OF_EXEC	Region Where Contract Concluded		TB_SREGION	CHAR	6	T005S
WAIVE_REASON	Reason for Automatic Waiver of Charges		TB_WAIVE_REASON	CHAR	6	TDWAIVE_REASON
WAIVE_METHOD	Waiver Method		TB_WAIVE_METHOD	NUMC	2
BACKOFFICE_ID	Back Office		TB_BACKOFFICE_ID	NUMC	16
FLG_NON_ACCRUAL	Non-Accrual Status Permitted		TB_FLG_NON_ACCRUAL	CHAR	2
SFIMA_METHOD	Control Settings for FiMa Connection		TB_FIMA_METHOD	CHAR	2
GRACE_DAYS	Grace Days		TB_GRACEDAYS	NUMC	6
NOIOA_TILL_BLOCK	End Date of Non-IOA Period		TB_NOIOA_TILL_BLOCK	DATS	16
FLG_SYNDICATE	Syndicated Loan		TB_FLG_SYNDICATE	CHAR	2
FLG_FACILITY	Loan: Part of Facility		TB_FLG_FACILITY	CHAR	2
SHADOW_ACCNT	Value of Shadow Account		TB_SHD_ACCNT	CHAR	2
SKWG14_OPEN	Position Grouping Acc. to Para 14 GBA Open Loan Commitments		VVSKWG14_OPEN	CHAR	4
.INCLUDE				FVD_STR_BPCA	0
BPCA_ID	ID number of Business Process Chain Assignment		TB_BPCA_ID	CHAR	64
BPCA_TYPE_CODE	Business Process Type Code		TB_BPCA_TYPE_CODE	CHAR	12
.INCLU--AP				FVD_ANACREDIT	0
AC_SCI	AnaCredit: Syndicated contract Identifier		TB_AC_SCI	CHAR	120
AC_RECOURSE	AnaCredit: Recourse		TB_AC_RECOURSE	NUMC	2
AC_PFL	AnaCredit: Project finance loan		TB_AC_PFL	NUMC	2
AC_TOS	AnaCredit: Type of securitisation		TB_AC_TOS	NUMC	4	TD32
.INCLU--AP				FVD_CIC_CODE	0
COICODE	Complementary Identification Code		COICODE	CHAR	4	TTCOICODE
COILAND	Complementary Identification Country/Region		COILAND	CHAR	4
.INCLU--AP				FVD_DCAC	0
DCAC_CLASS	Loan Classification (Directive on Credit Agmts for Cons.)		TB_DCAC_CLASS	NUMC	6	TD31
DCAC_CURR	Loan Partner Currency (Directive on Credit Agmts for Cons.)		TB_DCAC_CURR	CUKY	10	TCURC
.INCLU--AP				FVD_OPT_INT_ADJ_CMLCHN	0
OPTIMAL_LIST	For interest adjust optimization solution list		TB_OP_LIST_CMLCHN	CHAR	2
.INCLU--AP				FVD_PAYMENT	0
PYCUR	Currency for Automatic Payment		FVD_PYCUR	CUKY	10	TCURC
.INCLU--AP				FVD_PL	0
INSR_CONTRACT_ID	Insurance Contract-ID		FVD_PL_INSR_CONTRACT_ID	CHAR	34
INSR_OBJ_CAT	Insurance Object Category		FVD_INSOBJECTTYPC_MD	CHAR	4
INSR_OBJ_ID	Identification of an Insurance Object		FVD_INSOBJECT_MD	CHAR	40
INSR_COND_STRUC	Condition structure type (policy loan integration)		FVD_PL_COND_STRUC_TYPE	CHAR	6	VDPL_TYPES
.INCLU--AP				FVD_RP_VDARL	0
RP_RELEVANT	Flag �relevant for German Banking Act "		VVRP_RELEVANT	CHAR	2
.INCLU--AP				FVD_SEPA_CONTRACT	0
CONTRACT_BIC	SWIFT/BIC for International Payments		SWIFT	CHAR	22
CONTRACT_IBAN	IBAN (International Bank Account Number)		BU_IBAN	CHAR	68
IBAN_DET	Type of Determination of IBAN for a contract		TB_SEPA_IBAN_DET	CHAR	2
.INCLU--AP				RAFACILITIES	0
FAC_GROUP_NUMBER	Facility Grouping Identifier		TB_FACILITY_GROUP_NUMBER	CHAR	26
FLG_DD_REVOLVING	Revolving Drawdown		TB_FLG_DRAWDOWN_REVOLVING	CHAR	2
FLG_FAC_INACTIVE	Facility Inactive		TB_FLG_FACILITY_INACTIVE	CHAR	2
.INCLU--AP				RFVD_CML_ARCHIVE	0
OBJ_ID	Data object Identifier		DATOBJ_ID	CHAR	100
OBJ_KEY	Key for Archive File		ARKEY	CHAR	40
OBJ_OFFSET	Archive file data object offset		ADMI_OFFST	INT4	4
.INCLU--AP				RFVD_FLP	0
FLP	Loan Belongs to Forward Loan Purchase		TB_FLP_FLAG	CHAR	2
FLP_NUMBER	Forward Loan Purchase Deal Number		TB_FLP_DEAL_NUMBER	CHAR	26
.INCLU--AP				RFVD_VDBEPP	0
VDBEPP_DBEAR	Planned Records Last Edited On		VDBEPP_DBEAR	DATS	16
VDBEPP_TBEAR	Planned Records Last Edited At		VDBEPP_TBEAR	TIMS	12
VDBEPP_RBHER	Planned Records Editing Source		VDBEPP_RBHER	CHAR	20
.INCLU--AP				VDARL_RES_AMT_CMLCHN	0
RESERVED_AMOUNT	Reserved amount		TB_FACILITY_RES_AMT_CMLCHN	CURR	7