VDARL

Loans | #masterdata | Component: Loans Management
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SARCHIV Archiving Category Indicator
RANL Contract Number
Column Name Description
💲 Currency (SANTWHR):
BANTRAG Capital applied for
BZUSAGE Commitment capital
BABTRET Minimum amount for assignments
BGESDAR Total amount of syndicated loan
BNBUERG Initial capital not guaranteed
RESERVED_AMOUNT Reserved amount
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DANTRAG Entry Date of Loan Application
DZUSAGE Loan - Date of Commitment by Lender
DZUSAGE_ORIGIN Date of the Original Approval from the Lender
DBLFZ Start of Term
DELFZ End of Loan Term
DBDIS Start of distribution of discount
DARCHIV Date of Rejection/Withdrawal
DKONS Syndicate loan date
DBEWI Approval date
MADAT Date of Last Dunning Notice
DABTR Date of assignment
DVERFU Date of restraint on disposal upto
DELSOZ Date of last special interest payment period
DRUECK Date when loan will probably be redeemed
MIGDATE Migration date
DCONVERT Date loan was converted to EURO
DCORRECT Date for adjustment flows resulting from EURO conversion
DPLAN_SET Date of Transfer of Contract into Status Planned Completed
DOPEN Opening Date of a Loan Contract
DCLOSE Closing Date of a Loan Contract
DUNN_BLOCK_TILL Expiration Date of Dunning Lock
NOIOA_TILL Expiry Date of Lock on Interest on Arrears
DCALLEND Provision Expiry Date
DAT_FULL_PAY Date of Full Disbursement
DAT_OF_CANCEL Rescission Date
DINSTR Date Customer Was Instructed About Rescission Rights
NOIOA_TILL_BLOCK End Date of Non-IOA Period
VDBEPP_DBEAR Planned Records Last Edited On
VDBEPP_TBEAR Planned Records Last Edited At
Column Name Description
SSOLIST Plan/Actual principle Show values
SDISMETH Discount distribution method Show values
JORIG Posting system indicator for borrower's note loans Show values
VVSLOEKZ Deletion indicator Show values
SABTRANS Indicator for Possible Foreign Assignment Show values
SFGKZ Release Indicator Show values
SBEA Loan Processing Indicator Show values
SPLIT Debit position splitting Show values
SREFZINS Loan With Reference Interest Rate Show values
SABGRENZ Loan Discount Accrual/Deferral Method Show values
SFEST Indicator for Control of Fixed Contract Show values
SKWG14_NEU Position Grouping Acc. Article 14 GBA (Sec. and Loans) Show values
SDUNNCMP Summarization Level for Dunning Letter Show values
XNODUNN Exclude Loan from Dunning Run Show values
SDUNCHARG Post Dunning Charges and Interest to this Contract Show values
SAKTPAS Indicator: Asset/Liability Transaction Show values
JNOREPAY Payoff Lock Show values
JNODOIP Blocked by Payoff: No Open Item Clearing for Loan Show values
SARC_EXCL Documents For The Loan May Not Be Archived Show values
SARC_DOCS Indicator: Archived Loan Documents Exist Show values
NO_PLAN_DONE Do Not Transfer Loan to Status "Completed" Show values
SVER_EXCL Documents for the loan may not be summarized Show values
LC_STATUS Status of Processing Characteristics for Loan Show values
PAYM_STATUS Payment Status Show values
STOP_INDICATOR Stop Indicator Show values
SCHUFA_MESSAGE Business Partner Has Signed a Schufa Declaration Show values
FLG_CNCL Rescission Indicator Show values
FLG_CNCL_CLI Indicator: Rescind Credit Life Insurance Show values
FLG_NO_CHANGE Only Limited Changes Possible for Contract Indicator Show values
WAIVE_METHOD Waiver Method Show values
FLG_NON_ACCRUAL Non-Accrual Status Permitted Show values
SFIMA_METHOD Control Settings for FiMa Connection Show values
FLG_SYNDICATE Syndicated Loan Show values
FLG_FACILITY Loan: Part of Facility Show values
SKWG14_OPEN Position Grouping Acc. to Para 14 GBA Open Loan Commitments Show values
AC_RECOURSE AnaCredit: Recourse Show values
AC_PFL AnaCredit: Project finance loan Show values
OPTIMAL_LIST For interest adjust optimization solution list Show values
RP_RELEVANT Flag „relevant for German Banking Act " Show values
IBAN_DET Type of Determination of IBAN for a contract Show values
FLG_DD_REVOLVING Revolving Drawdown Show values
FLG_FAC_INACTIVE Facility Inactive Show values
FLP Loan Belongs to Forward Loan Purchase Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
SOBJEKT Internal key for object VVKEY
XALKZ Short Name XKBEZ
XALLB Long Name XLBEZ
XAKT File Number CHAR32
RANLALT1 Alternative Identification CHAR13
RANLALT2 Alternative identification 2 CHAR13
RKLAMMER Classification Number for Finance Projects RANL
RANLKET Principle loan investment number CHAR13
RANTRAG Application number CHAR13
SDTI DTI indicator NUMC
AABTRET Number of Assignments Still Possible NUM02
AKONS Number of syndicate members NUM03
MAHNS Dunning Level MAHNS
RPNR Activity number/rollover number NUMC08
RSBEAR Dummy field 12 characters CHAR CHAR12
BEGRU Authorization Group BEGRU
NABTRV Contract of assignment number CHAR15
NAVAL Guarantee number CHAR15
SFGBEW Transaction data to be released available VVSFGBEW
SOBEZ Organizational District CHAR2
SBEZIRK Agent District CHAR4
SIHERK Component of the Version Number CHAR2
RGENUM Character Field with Length 10 CHAR10
SRATAGEN Rating agency BU_PARTNER
OBJNR Object Number for Financial Transactions J_OBJNR
RANLSTAMNR Master number part of loan number for finding contracts RANL
ZUOND Assignment TEXT18
REFER Internal Reference CHAR16
MERKM Characteristics CHAR25
XNOIOA Lock for Interest on Arrears CHAR1
LC_DISBURSEMENT Processing Characteristic: Disbursement Status T_LC_CHARACVALUE
LC_CAPITALS Processing Characteristic: Status of Capital Amounts T_LC_CHARACVALUE
LC_PLANNED_FLOW Processing Characteristic: Status of Planned Records T_LC_CHARACVALUE
LC_DEBIT Processing Characteristic: Status of Customer Receivables T_LC_CHARACVALUE
LC_CREDIT Processing Characteristic: Status of Customer Payables T_LC_CHARACVALUE
PRODUCT_ID Internal Product ID T_PR_PRODINT
PRODUCT_VERSION Product Version T_PR_VERSION
BACKOFFICE_ID Back Office HROBJID
GRACE_DAYS Grace Days NUM03
SHADOW_ACCNT Value of Shadow Account CHAR1
BPCA_ID ID number of Business Process Chain Assignment TB_BPCA_ID
BPCA_TYPE_CODE Business Process Type Code TB_BPCA_TYPE_CODE
AC_SCI AnaCredit: Syndicated contract Identifier TB_AC_SCI_DOM
COILAND Complementary Identification Country/Region
INSR_CONTRACT_ID Insurance Contract-ID CHAR17
INSR_OBJ_CAT Insurance Object Category
INSR_OBJ_ID Identification of an Insurance Object
CONTRACT_BIC SWIFT/BIC for International Payments SWIFT
CONTRACT_IBAN IBAN (International Bank Account Number) CHAR34
FAC_GROUP_NUMBER Facility Grouping Identifier RANL
OBJ_ID Data object Identifier CHAR50
OBJ_KEY Key for Archive File ARKEY
OBJ_OFFSET Archive file data object offset
FLP_NUMBER Forward Loan Purchase Deal Number T_FLP_DEAL_NUMBER
VDBEPP_RBHER Planned Records Editing Source CHAR10
Master Data Relations | to Other Relations ↓ Join Conditions
AnaCredit: Type of securitisation
  • AnaCredit: Type of securitisation
  • Client
  • VDARL.AC_TOS == TD32.AC_TOS
  • VDARL.MANDT == TD32.MANDT
Company code
  • VDARL.MANDT == T001.MANDT
  • VDARL.BUKRS == T001.BUKRS
Complementary Identification Code
General Valuation Class
  • General Valuation Class
  • Client
Loan Classification (Directive on Credit Agmts for Cons.)
  • VDARL.MANDT == TD31.MANDT
  • VDARL.DCAC_CLASS == TD31.DCAC_CLASS
Loan Partner Currency (Directive on Credit Agmts for Cons.)
  • VDARL.MANDT == TCURC.MANDT
  • VDARL.DCAC_CURR == TCURC.WAERS
Sales Channel
  • Sales Channel
  • Client
  • VDARL.DISTRIB_CHANNEL == TD30.DISTRIB_CHANNEL
  • VDARL.MANDT == TD30.MANDT
Business Area
  • VDARL.MANDT == TGSB.MANDT
  • VDARL.GSBER == TGSB.GSBER
House bank ID
  • Short Key for a House Bank
  • Company Code
  • VDARL.MANDT == T012.MANDT
  • VDARL.HBKID == T012.HBKID
  • VDARL.BUKRS == T012.BUKRS
Customer number
  • VDARL.MANDT == KNA1.MANDT
  • VDARL.HDN_KUNNR == KNA1.KUNNR
Account details ID
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • VDARL.BUKRS == T012K.BUKRS
  • VDARL.HKTID == T012K.HKTID
  • VDARL.MANDT == T012K.MANDT
  • VDARL.HBKID == T012K.HBKID
Condition structure type (policy loan integration)
Dunning Area
  • Dunning Area
  • Company Code
  • VDARL.MANDT == T047M.MANDT
  • VDARL.MABER == T047M.MABER
  • VDARL.BUKRS == T047M.BUKRS
Client VDARL.MANDT == T000.MANDT
Organizational Unit
  • VDARL.MANDT == TD19.MANDT
  • VDARL.ORGUNIT == TD19.ORGUNIT
Loan Origin VDARL.ORIGIN == TDORIGIN.ORIGIN
Currency for Automatic Payment
  • VDARL.MANDT == TCURC.MANDT
  • VDARL.PYCUR == TCURC.WAERS
Business Partner Number
  • Business Partner Number
  • Client
  • VDARL.RDARNEHM == BUT000.PARTNER
  • VDARL.MANDT == BUT000.CLIENT
Portfolio identification
  • Company Code
  • Portfolio
  • Client
  • VDARL.BUKRS == TWPOB.BUKRS
  • VDARL.RPORTB == TWPOB.RPORTB
  • VDARL.MANDT == TWPOB.MANDT
Payer/Payee
  • Payer/Payee
  • Client
  • VDARL.RPZAHL == BUT000.PARTNER
  • VDARL.MANDT == BUT000.CLIENT
Account assignment reference
  • Company Code
  • ?
  • Account Assignment Reference in Financial Assets Management
  • VDARL.MANDT == T037S.MANDT
  • VDARL.BUKRS == T037S.BUKRS
  • VDARL.[column in domain "RANTYP"] == T037S.RANTYP
  • VDARL.RREFKONT == T037S.RREFKONT
Assignment creditor
  • VDARL.MANDT == TDS1.MANDT
  • VDARL.SABT == TDS1.SABT
Product Category VDARL.SANLF == TZAF.SANLF
Currency
  • VDARL.MANDT == TCURC.MANDT
  • VDARL.SANTWHR == TCURC.WAERS
Balance Sheet Indicator
  • Balance Sheet Indicator
  • Client
  • VDARL.SBILK == TW11.SBILK
  • VDARL.MANDT == TW11.MANDT
Calculation Profile for Interest on Arrears Calculation
Loan category
  • Loans Class
  • Client
  • VDARL.SDTYP == TD02.SDTYP
  • VDARL.MANDT == TD02.MANDT
Asset Grouping Indicator
  • VDARL.MANDT == TW08.MANDT
  • VDARL.SFIBG == TW08.SFIBG
Indicator: Type of Residential Object Financing
  • Indicator: Type of Residential Object Financing
  • Client
  • VDARL.SFIWO == TD15.SFIWO
  • VDARL.MANDT == TD15.MANDT
Loan Term
  • Loan Term
  • Client
  • VDARL.SFRIST == TD09.SFRIST
  • VDARL.MANDT == TD09.MANDT
Branch office
  • VDARL.MANDT == TD17.MANDT
  • VDARL.SGESST == TD17.SGESST
SCB Asset Group Indicator
  • VDARL.MANDT == TW07.MANDT
  • VDARL.SGLZB == TW07.SGLZB
Group Key 1 (Freely Available)
  • Group Key 1 (Freely Available)
  • Client
  • VDARL.SGR1 == TDDG1.SGRP1
  • VDARL.MANDT == TDDG1.MANDT
Group Key 2 (Freely Available)
  • VDARL.MANDT == TDDG2.MANDT
  • VDARL.SGR2 == TDDG2.SGRP2
Group Key 3 (Freely Available)
  • VDARL.MANDT == TDDG3.MANDT
  • VDARL.SGRP3 == TDDG3.SGRP3
Group Key 4 (Freely Available)
  • VDARL.MANDT == TDDG4.MANDT
  • VDARL.SGRP4 == TDDG4.SGRP4
Home statement
  • VDARL.MANDT == TD11.MANDT
  • VDARL.SHOME == TD11.SHOME
Credit type indicator for Austrian reporting
  • ?
  • Credit type indicator for Austrian reporting
  • VDARL.[column in domain "VVXLAND"] == TZ34.XLAND
  • VDARL.SKWGDAR == TZ34.SKWGDAR
Credit category indicator Para. 75 report (Austria)
  • Credit category indicator Para. 75 report (Austria)
  • ?
  • VDARL.SKWGKRED == TZ35.SKWGKRED
  • VDARL.[column in domain "VVXLAND"] == TZ35.XLAND
Country key
  • Country/Region ID
  • Client
  • VDARL.SLAENDER == T005.LAND1
  • VDARL.MANDT == T005.MANDT
Loan Manual Dunning Level
Reason for Non-Acceptance
  • Product Type
  • Company Code
  • Reason for Non-Acceptance
  • VDARL.MANDT == TDA5.MANDT
  • VDARL.GSART == TDA5.GSART
  • VDARL.BUKRS == TDA5.BUKRS
  • VDARL.SNICHTAB == TDA5.SNICHTAB
Special posting treatment
  • Company Code
  • Special posting treatment
  • VDARL.MANDT == TD14.MANDT
  • VDARL.BUKRS == TD14.BUKRS
  • VDARL.SONDST == TD14.SONDST
Rating
  • VDARL.MANDT == TP06.MANDT
  • VDARL.SRATING == TP06.RATING
Region
  • VDARL.MANDT == TD18.MANDT
  • VDARL.SREGION == TD18.SREGION
Primary collateral
  • VDARL.MANDT == TD01.MANDT
  • VDARL.SSICHER == TD01.SSICH
Special Handling
  • VDARL.MANDT == TD10.MANDT
  • VDARL.SSONDER == TD10.SSONDER
Region Where Contract Concluded
  • Country/Region ID
  • Region Where Contract Concluded
  • VDARL.MANDT == T005S.MANDT
  • VDARL.SLAENDER == T005S.LAND1
  • VDARL.SSTATE_OF_EXEC == T005S.BLAND
External status
  • Product Type
  • Company Code
  • Status of data record
  • VDARL.MANDT == TZC37.MANDT
  • VDARL.GSART == TZC37.GSART
  • VDARL.BUKRS == TZC37.BUKRS
  • VDARL.SSTATI == TZC37.STATU
Security type
  • Borrower's Note Loan Security Type
  • Client
  • VDARL.STITART == TD16.STITART
  • VDARL.MANDT == TD16.MANDT
Type of Restraint on Drawing
  • VDARL.MANDT == TZV05.MANDT
  • VDARL.SVERFU == TZV05.SVERFU
Note to payee
  • Product Type
  • Client
  • Purpose of Loan
  • VDARL.GSART == TD07.GSART
  • VDARL.MANDT == TD07.MANDT
  • VDARL.SVZWECK == TD07.SVZWECK
Loan currency before conversion to EURO
  • VDARL.MANDT == TCURC.MANDT
  • VDARL.SWHRORG == TCURC.WAERS
Incoming payment distribution grouping
  • Indicator for Control of Incoming Payment Distribution
  • Client
  • VDARL.SZKEY == TVZ01.SZKEY
  • VDARL.MANDT == TVZ01.MANDT
Reason for Automatic Waiver of Charges
  • Reason for Automatic Waiver of Charges
  • Client
  • Company Code
Other Relations | to Master Data Relations ↑ Join Conditions
Product type / Transaction type
  • Company Code
  • Product Type
  • VDARL.MANDT == TZPAB.MANDT
  • VDARL.BUKRS == TZPAB.BUKRS
  • VDARL.GSART == TZPAB.GSART
Loan type
  • Loan Type Indicator
  • Product Type
  • VDARL.MANDT == TD03.MANDT
  • VDARL.STITEL == TD03.STITEL
  • VDARL.GSART == TD03.GSART