I_LoanContrData

Loan Contract Master Data | view: ILCD | ATTR | Extraction: Full or Incremental | Component: Loans Management
Tables used: VDARL
Column Name Description
CompanyCode FK Company Code
LoanArchivingCategory Archiving Category Indicator
LoanContractID Contract Number
Column Name Description
💲 Currency (LoanContractCurrency):
LoanCapitalAppliedAmount Capital applied for
LoanCommittedCapitalAmount Commitment capital
Column Name Description
Column Name Description
LoanContractEnteredDate First Entered On
LoanContractEnteredTime Time of Creation
LoanContractEditedDate Last Edited On
LoanContractEditedTime Last Edited At
LoanApplicationEntryDate Entry Date of Loan Application
LoanCommitmentDate Loan - Date of Commitment by Lender
LoanTermStartDate Start of Term
LoanTermEndDate End of Loan Term
LoanWithdrawalDate Date of Rejection/Withdrawal
LoanApprovalDate Approval date
LastDunningDate Date of Last Dunning Notice
LoanRedeemDate Date when loan will probably be redeemed
Column Name Description
LoanIntrstCalcCptlMeth Plan/Actual principle Show values
LoanProcessingControl Loan Processing Indicator Show values
LoanDiscountMethod Loan Discount Accrual/Deferral Method Show values
LoanFixedContractControl Indicator for Control of Fixed Contract Show values
LoanDunSmmrzn Summarization Level for Dunning Letter Show values
LoanDunRunIsExclude Exclude Loan from Dunning Run Show values
LoanIsPostDunCharge Post Dunning Charges and Interest to this Contract Show values
LoanIsLiabilityTransaction Indicator: Asset/Liability Transaction Show values
LoanIsPayoffLock Payoff Lock Show values
LoanIsPOffBlkOpnItmClrg Blocked by Payoff: No Open Item Clearing for Loan Show values
LoanPaymentStatus Payment Status Show values
Column Name Description Domain name
LoanContractEnteredBy Entered By SYCHAR12
LoanContractEnteredSource Source of Initial Entry CHAR10
LoanContractEditedBy Employee ID SYCHAR12
LoanContractEditedSource Editing Source CHAR10
LoanObjectInternalKey Internal key for object VVKEY
LoanFileNumber File Number CHAR32
LoanAlternativeID1 Alternative Identification CHAR13
LoanAlternativeID2 Alternative identification 2 CHAR13
LoanClassfctnNmbr Classification Number for Finance Projects RANL
PrncpLoanInvmtNmbr Principle loan investment number CHAR13
LoanApplicationNumber Application number CHAR13
DunningLevel Dunning Level MAHNS
LoanAuthorizationGroup Authorization Group BEGRU
LoanOrganizationalDistrict Organizational District CHAR2
LoanAgentDistrict Agent District CHAR4
FinTransObjNmbr Object Number for Financial Transactions J_OBJNR
LoanMasterNumber Master number part of loan number for finding contracts RANL
LoanInternalReference Internal Reference CHAR16
LoanCharacteristic Characteristics CHAR25
LoanBackOffice Back Office HROBJID
LoanContractIBAN IBAN (International Bank Account Number) CHAR34
LoanBusProcChnAssgmtType Business Process Type Code TB_BPCA_TYPE_CODE
LoanBusProcChnAssgmtID ID number of Business Process Chain Assignment TB_BPCA_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Balance Sheet Indicator
  • Client
  • Balance Sheet Indicator
  • I_LOANCONTRDATA.MANDT == TW11.MANDT
  • I_LOANCONTRDATA.BALANCESHEETCODE == TW11.SBILK
Business Partner Number
  • Client
  • Business Partner Number
  • I_LOANCONTRDATA.MANDT == BUT000.CLIENT
  • I_LOANCONTRDATA.BUSINESSPARTNER == BUT000.PARTNER
Company code
  • Client
  • Company Code
  • I_LOANCONTRDATA.MANDT == T001.MANDT
  • I_LOANCONTRDATA.COMPANYCODE == T001.BUKRS
Dunning Area
  • Client
  • Company Code
  • Dunning Area
  • I_LOANCONTRDATA.MANDT == T047M.MANDT
  • I_LOANCONTRDATA.COMPANYCODE == T047M.BUKRS
  • I_LOANCONTRDATA.DUNNINGAREA == T047M.MABER
Asset Grouping Indicator
  • Client
  • Asset Grouping Indicator
  • I_LOANCONTRDATA.MANDT == TW08.MANDT
  • I_LOANCONTRDATA.FINACCTGASTGRP == TW08.SFIBG
House bank ID
  • Client
  • Short Key for a House Bank
  • Company Code
  • I_LOANCONTRDATA.MANDT == T012.MANDT
  • I_LOANCONTRDATA.HOUSEBANK == T012.HBKID
  • I_LOANCONTRDATA.COMPANYCODE == T012.BUKRS
Account details ID
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • Company Code
  • I_LOANCONTRDATA.HOUSEBANKACCOUNT == T012K.HKTID
  • I_LOANCONTRDATA.MANDT == T012K.MANDT
  • I_LOANCONTRDATA.HOUSEBANK == T012K.HBKID
  • I_LOANCONTRDATA.COMPANYCODE == T012K.BUKRS
Account assignment reference
  • Client
  • ?
  • Account Assignment Reference in Financial Assets Management
  • Company Code
  • I_LOANCONTRDATA.MANDT == T037S.MANDT
  • I_LOANCONTRDATA.[column in domain "RANTYP"] == T037S.RANTYP
  • I_LOANCONTRDATA.LOANACCTASSGMTREF == T037S.RREFKONT
  • I_LOANCONTRDATA.COMPANYCODE == T037S.BUKRS
Assignment creditor
  • Client
  • Assignee
  • I_LOANCONTRDATA.MANDT == TDS1.MANDT
  • I_LOANCONTRDATA.LOANASSIGNMENTCREDITOR == TDS1.SABT
Branch office
  • Client
  • Branch Office
  • I_LOANCONTRDATA.MANDT == TD17.MANDT
  • I_LOANCONTRDATA.LOANBRANCHOFFICE == TD17.SGESST
Business Area
  • Client
  • Business Area
  • I_LOANCONTRDATA.MANDT == TGSB.MANDT
  • I_LOANCONTRDATA.LOANBUSINESSAREA == TGSB.GSBER
Loan category
  • Client
  • Loans Class
  • I_LOANCONTRDATA.MANDT == TD02.MANDT
  • I_LOANCONTRDATA.LOANCLASS == TD02.SDTYP
Region Where Contract Concluded
  • Client
  • Country/Region ID
  • Region Where Contract Concluded
  • I_LOANCONTRDATA.MANDT == T005S.MANDT
  • I_LOANCONTRDATA.LOANCOUNTRYID == T005S.LAND1
  • I_LOANCONTRDATA.LOANCONCLUDEDREGION == T005S.BLAND
Currency
  • Client
  • Currency
  • I_LOANCONTRDATA.MANDT == TCURC.MANDT
  • I_LOANCONTRDATA.LOANCONTRACTCURRENCY == TCURC.WAERS
Country key
  • Client
  • Country/Region ID
  • I_LOANCONTRDATA.MANDT == T005.MANDT
  • I_LOANCONTRDATA.LOANCOUNTRYID == T005.LAND1
Type of Restraint on Drawing
  • Client
  • Type of Restraint on Drawing
  • I_LOANCONTRDATA.MANDT == TZV05.MANDT
  • I_LOANCONTRDATA.LOANDRWGRESTRAINTTYPE == TZV05.SVERFU
General Valuation Class
  • General Valuation Class
  • Client
Group Key 1 (Freely Available)
  • Client
  • Group Key 1 (Freely Available)
  • I_LOANCONTRDATA.MANDT == TDDG1.MANDT
  • I_LOANCONTRDATA.LOANGROUPKEY1 == TDDG1.SGRP1
Group Key 2 (Freely Available)
  • Client
  • Group Key 2 (Freely Available)
  • I_LOANCONTRDATA.MANDT == TDDG2.MANDT
  • I_LOANCONTRDATA.LOANGROUPKEY2 == TDDG2.SGRP2
Group Key 3 (Freely Available)
  • Client
  • Group Key 3 (Freely Available)
  • I_LOANCONTRDATA.MANDT == TDDG3.MANDT
  • I_LOANCONTRDATA.LOANGROUPKEY3 == TDDG3.SGRP3
Group Key 4 (Freely Available)
  • Client
  • Group Key 4 (Freely Available)
  • I_LOANCONTRDATA.MANDT == TDDG4.MANDT
  • I_LOANCONTRDATA.LOANGROUPKEY4 == TDDG4.SGRP4
Incoming payment distribution grouping
  • Client
  • Indicator for Control of Incoming Payment Distribution
  • I_LOANCONTRDATA.MANDT == TVZ01.MANDT
  • I_LOANCONTRDATA.LOANINCGPAYTDISTRCTRL == TVZ01.SZKEY
External status
  • Client
  • Company Code
  • Product Type
  • Status of data record
  • I_LOANCONTRDATA.MANDT == TZC37.MANDT
  • I_LOANCONTRDATA.COMPANYCODE == TZC37.BUKRS
  • I_LOANCONTRDATA.LOANPRODUCTTYPE == TZC37.GSART
  • I_LOANCONTRDATA.LOANLIFECYCLESTATUS == TZC37.STATU
Customer number
  • Client
  • Main Borrower Customer Number
  • I_LOANCONTRDATA.MANDT == KNA1.MANDT
  • I_LOANCONTRDATA.LOANMAINBRWRCUSTNMBR == KNA1.KUNNR
Loan Manual Dunning Level
  • Client
  • Loan Manual Dunning Level
Reason for Non-Acceptance
  • Client
  • Reason for Non-Acceptance
  • Company Code
  • Product Type
  • I_LOANCONTRDATA.MANDT == TDA5.MANDT
  • I_LOANCONTRDATA.LOANNONACCPTCRSN == TDA5.SNICHTAB
  • I_LOANCONTRDATA.COMPANYCODE == TDA5.BUKRS
  • I_LOANCONTRDATA.LOANPRODUCTTYPE == TDA5.GSART
Portfolio identification
  • Client
  • Portfolio
  • Company Code
  • I_LOANCONTRDATA.MANDT == TWPOB.MANDT
  • I_LOANCONTRDATA.LOANPORTFOLIOTYPE == TWPOB.RPORTB
  • I_LOANCONTRDATA.COMPANYCODE == TWPOB.BUKRS
Product Category I_LOANCONTRDATA.LOANPRODUCTCATEGORY == TZAF.SANLF
Note to payee
  • Client
  • Purpose of Loan
  • Product Type
  • I_LOANCONTRDATA.MANDT == TD07.MANDT
  • I_LOANCONTRDATA.LOANPURPOSE == TD07.SVZWECK
  • I_LOANCONTRDATA.LOANPRODUCTTYPE == TD07.GSART
Region
  • Client
  • Sales Region
  • I_LOANCONTRDATA.MANDT == TD18.MANDT
  • I_LOANCONTRDATA.LOANSALESREGION == TD18.SREGION
Security type
  • Client
  • Borrower's Note Loan Security Type
  • I_LOANCONTRDATA.MANDT == TD16.MANDT
  • I_LOANCONTRDATA.LOANSECURITYTYPE == TD16.STITART
Special posting treatment
  • Client
  • Special posting treatment
  • Company Code
  • I_LOANCONTRDATA.MANDT == TD14.MANDT
  • I_LOANCONTRDATA.LOANSPECIALPOSTINGTYPE == TD14.SONDST
  • I_LOANCONTRDATA.COMPANYCODE == TD14.BUKRS
Special Handling
  • Client
  • Special treatment of loan
  • I_LOANCONTRDATA.MANDT == TD10.MANDT
  • I_LOANCONTRDATA.LOANSPECIALTREATMENT == TD10.SSONDER
Loan Term
  • Client
  • Loan Term
  • I_LOANCONTRDATA.MANDT == TD09.MANDT
  • I_LOANCONTRDATA.LOANTERM == TD09.SFRIST
SCB Asset Group Indicator
  • Client
  • SCB Asset Group Indicator
  • I_LOANCONTRDATA.MANDT == TW07.MANDT
  • I_LOANCONTRDATA.STATECNTRLBKASTGRP == TW07.SGLZB
Other Relations | to Master Data Relations ↑ Join Conditions
Product type / Transaction type
  • Client
  • Company Code
  • Product Type
  • I_LOANCONTRDATA.MANDT == TZPAB.MANDT
  • I_LOANCONTRDATA.COMPANYCODE == TZPAB.BUKRS
  • I_LOANCONTRDATA.LOANPRODUCTTYPE == TZPAB.GSART
Loan type
  • Client
  • Loan Type Indicator
  • Product Type
  • I_LOANCONTRDATA.MANDT == TD03.MANDT
  • I_LOANCONTRDATA.LOANTYPE == TD03.STITEL
  • I_LOANCONTRDATA.LOANPRODUCTTYPE == TD03.GSART