I_LoanContrCndnHdrData

Conditon Header for Loan Contract | view: ILCCDNHDRD | TRAN | Extraction: Full or Incremental | Component: Loans Management
Tables used: VZZKOKO
Column Name Description
CompanyCode FK Company Code
LoanProductCategory Product Category
LoanContractID Key part 1
LoanCndnHdrValdtyStrtDte Date Condition Effective from
LoanConditionHeaderOfferNumber Offer consecutive number
Column Name Description
💲 Currency of commitment amount (LoanCommittedCapitalCrcy):
LoanCommittedCapitalAmount Commitment capital
Column Name Description
Column Name Description
LoanCndnHdrValdtyStrtDte Date Condition Effective from
LoanNoticeDate Date of notice
LoanLndrErlstNtcDate Earliest Possible Date for Notice Given by the Lender
LoanTermStartDate Start of Term
LoanTermEndDate End of Term
LoanCndnHdrValdtyEndDte Date of fixed period end
LoanCndnEffctvIntrstStrtDte Date when calculation of effective rate starts
Column Name Description
LoanConditionHeaderType Type of Condition Header Show values
LoanRepaymentType Repayment Type Indicator Show values
LoanEffectiveInterestMethod Effective Interest Method (Financial Mathematics) Show values
InterestCalculationMethod Interest Calculation Method Show values
LoanIntEffctvIntrstMeth Effective Interest Method (Financial Mathematics) Show values
Column Name Description Domain name
LoanLifeCycleStatus Status of data record STATI
LoanDisbursementRate Pay-in/disbursement rate DEC3_7
LoanEffectiveInterestRate Effective Interest Rate DECV3_7
LoanIntEffctvIntrstRate Internal Effective Interest Rate DECV3_7
InterestDaysCalendar Interest Calendar WFCID
Master Data Relations Join Conditions
Company code
  • Company Code
  • Client
  • I_LOANCONTRCNDNHDRDATA.COMPANYCODE == T001.BUKRS
  • I_LOANCONTRCNDNHDRDATA.MANDT == T001.MANDT
Currency
  • Client
  • Currency of commitment amount
  • I_LOANCONTRCNDNHDRDATA.MANDT == TCURC.MANDT
  • I_LOANCONTRCNDNHDRDATA.LOANCOMMITTEDCAPITALCRCY == TCURC.WAERS
Notice Arrangement Borrower
  • Notice Arrangement Borrower
  • Client
  • I_LOANCONTRCNDNHDRDATA.LOANCONTRBRWRNTCARRGMT == TD29.SKUEDN
  • I_LOANCONTRCNDNHDRDATA.MANDT == TD29.MANDT
Notice Type for the Loan
  • Client
  • Notice Type for the Loan
  • I_LOANCONTRCNDNHDRDATA.MANDT == TD27.MANDT
  • I_LOANCONTRCNDNHDRDATA.LOANCONTRNTCTYPE == TD27.SKUEART
Notice Arrangement Lender
  • Notice Arrangement Lender
  • Client
  • I_LOANCONTRCNDNHDRDATA.LOANLENDERNOTICEARRGMT == TD28.SKUEGL
  • I_LOANCONTRCNDNHDRDATA.MANDT == TD28.MANDT
Reason for Notice
  • Reason for Notice
  • Client
  • I_LOANCONTRCNDNHDRDATA.LOANNOTICEREASON == TD04.SKUEND
  • I_LOANCONTRCNDNHDRDATA.MANDT == TD04.MANDT