P_LoanContrBPAddlDet

Business Partner additional details | view: PLCBPADDLDET | Extraction: Not supported | Component: Loans Management
Tables used: BP1010, BP011, BP001, BUT000, VDARL
Column Name Description
BusinessPartner FK Business Partner Number
Column Name Description
💲 Currency of Net Income (BusinessPartnerIncomeCurrency):
BPAnnualIncAmtInIncCrcy Net Annual Income
BPMonthlyIncAmtInIncCrcy Monthly Net Income of Business Partner
Column Name Description
Column Name Description
BirthDate Date of Birth of Business Partner
Column Name Description
IsMale Selection: Business partner is male Show values
IsFemale Selection: Business partner is female Show values
CustomerIsUnwanted Undesirable Customer Show values
BusPartCreditStanding Credit Standing Show values
BusinessPartnerIsBankrupt Launch Bankruptcy Proceedings Show values
BPForeclosureIsInitiated Foreclosure Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Second academic title (key)
  • Client
  • Second academic title (key)
  • P_LOANCONTRBPADDLDET.MANDT == TSAD2.CLIENT
  • P_LOANCONTRBPADDLDET.ACADEMICSECONDTITLE == TSAD2.TITLE_KEY
Academic Title: Key
  • Client
  • Academic Title: Key
  • P_LOANCONTRBPADDLDET.MANDT == TSAD2.CLIENT
  • P_LOANCONTRBPADDLDET.ACADEMICTITLE == TSAD2.TITLE_KEY
Business Partner Number
  • Client
  • Business Partner Number
  • P_LOANCONTRBPADDLDET.MANDT == BUT000.CLIENT
  • P_LOANCONTRBPADDLDET.BUSINESSPARTNER == BUT000.PARTNER
Currency of Net Income
  • Client
  • Currency of Net Income
  • P_LOANCONTRBPADDLDET.MANDT == TCURC.MANDT
  • P_LOANCONTRBPADDLDET.BUSINESSPARTNERINCOMECURRENCY == TCURC.WAERS
Occupation/group
  • Client
  • Occupation/group
  • P_LOANCONTRBPADDLDET.MANDT == TB028.CLIENT
  • P_LOANCONTRBPADDLDET.BUSINESSPARTNEROCCUPATION == TB028.JOBGR
Occupation/group
  • Client
  • Occupation/group
  • P_LOANCONTRBPADDLDET.MANDT == TB028.CLIENT
  • P_LOANCONTRBPADDLDET.BUSPARTCURRENTOCCUPATION == TB028.JOBGR
Target Group
  • Client
  • Target Group
  • P_LOANCONTRBPADDLDET.MANDT == TP13.MANDT
  • P_LOANCONTRBPADDLDET.BUSPARTEMPLOYMENTTARGETGROUP == TP13.GROUP_D
Industry
  • ?
  • Client
  • Industry
  • P_LOANCONTRBPADDLDET.[column in domain "BU_ISTYPE"] == TB038A.ISTYPE
  • P_LOANCONTRBPADDLDET.MANDT == TB038A.CLIENT
  • P_LOANCONTRBPADDLDET.BUSPARTEMPLRINDSTRYCODE == TB038A.IND_SECTOR
Employment Status
  • Employment Status
  • Client
  • P_LOANCONTRBPADDLDET.BUSPARTEMPLYMTRELSHPSTS == TP11.EMPLOYMENT
  • P_LOANCONTRBPADDLDET.MANDT == TP11.MANDT
Status of Legal Proceedings
  • Client
  • Status of Legal Proceedings
Marital Status of Business Partner
  • Client
  • Marital Status of Business Partner
  • P_LOANCONTRBPADDLDET.MANDT == TB027.CLIENT
  • P_LOANCONTRBPADDLDET.BUSPARTMARITALSTATUS == TB027.MARST
Nationality
  • Client
  • Nationality
  • P_LOANCONTRBPADDLDET.MANDT == T005.MANDT
  • P_LOANCONTRBPADDLDET.BUSPARTNATIONALITY == T005.LAND1
Foreign key: Rating
  • Client
  • Rating
  • P_LOANCONTRBPADDLDET.MANDT == TP06.MANDT
  • P_LOANCONTRBPADDLDET.CREDITRATING == TP06.RATING
Sex of business partner (person) P_LOANCONTRBPADDLDET.GENDERCODENAME == TB995.GENDER
Reason for Undesirability
  • Client
  • Reason for Undesirability
  • P_LOANCONTRBPADDLDET.MANDT == TP18.MANDT
  • P_LOANCONTRBPADDLDET.UNDESIRABILITYREASON == TP18.UNW_REASON