I_LoanContrBP

Loan Master data with Business Partner details | view: ILCBP | ATTR | Extraction: Full only | Component: Loans Management
Tables used: BUT000VDARL
Column Name Description
CompanyCode FK Company Code
LoanContractID Contract Number
Column Name Description
💲 Currency (LoanContractCurrency):
CmtdCptlAmtInContrCrcy Commitment capital
LoanCapitalAppliedAmount Capital applied for
Column Name Description
Column Name Description
LoanTermStartDate Start of Term
LoanTermEndDate End of Loan Term
Column Name Description
Column Name Description Domain name
LoanArchivingCategory Archiving Category Indicator SARCHIV
LoanAuthorizationGroup Authorization Group BEGRU
LoanObjectInternalKey Internal key for object VVKEY
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 Join Conditions
Second academic title (key)
  • Second academic title (key)
  • Client
  • I_LOANCONTRBP.ACADEMICSECONDTITLE == TSAD2.TITLE_KEY
  • I_LOANCONTRBP.MANDT == TSAD2.CLIENT
Business Partner Number
  • Business Partner Number
  • Client
  • I_LOANCONTRBP.BUSINESSPARTNER == BUT000.PARTNER
  • I_LOANCONTRBP.MANDT == BUT000.CLIENT
Occupation/group
  • Occupation/group
  • Client
  • I_LOANCONTRBP.BUSINESSPARTNEROCCUPATION == TB028.JOBGR
  • I_LOANCONTRBP.MANDT == TB028.CLIENT
Marital Status of Business Partner
  • Marital Status of Business Partner
  • Client
  • I_LOANCONTRBP.BUSPARTMARITALSTATUS == TB027.MARST
  • I_LOANCONTRBP.MANDT == TB027.CLIENT
Nationality
  • Nationality
  • Client
  • I_LOANCONTRBP.BUSPARTNATIONALITY == T005.LAND1
  • I_LOANCONTRBP.MANDT == T005.MANDT
Company code
  • Company Code
  • Client
  • I_LOANCONTRBP.COMPANYCODE == T001.BUKRS
  • I_LOANCONTRBP.MANDT == T001.MANDT
Currency
  • Currency
  • Client
  • I_LOANCONTRBP.LOANCONTRACTCURRENCY == TCURC.WAERS
  • I_LOANCONTRBP.MANDT == TCURC.MANDT
External status
  • Company Code
  • Product Type
  • Client
  • Status of data record
  • I_LOANCONTRBP.COMPANYCODE == TZC37.BUKRS
  • I_LOANCONTRBP.LOANPRODUCTTYPE == TZC37.GSART
  • I_LOANCONTRBP.MANDT == TZC37.MANDT
  • I_LOANCONTRBP.LOANLIFECYCLESTATUS == TZC37.STATU
Product Category I_LOANCONTRBP.LOANPRODUCTCATEGORY == TZAF.SANLF
Other Relations | to Master Data Relations ↑ Join Conditions
Product type / Transaction type
  • Company Code
  • Product Type
  • Client
  • I_LOANCONTRBP.COMPANYCODE == TZPAB.BUKRS
  • I_LOANCONTRBP.LOANPRODUCTTYPE == TZPAB.GSART
  • I_LOANCONTRBP.MANDT == TZPAB.MANDT