I_BusinessPartnerContactTP

Business Partner Contact BO View | view: IBUPACONTCTTP | Extraction: Not supported | Component: Business Partners
Tables used: BUT050BUT051BP001BUT000TB003BUT100
Column Name Description
BusinessPartner FK Business Partner Number
BusinessPartnerPerson FK Business Partner Number
RelationshipNumber BP Relationship Number
ValidityEndDate Validity Date (Valid To)
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
ValidityStartDate Validity Date (Valid From)
BirthDate Date of Birth of Business Partner
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
Column Name Description Domain name
RelationshipNumberForEdit BP Relationship Number BU_RELNR
PersonUUID Business Partner GUID SYSUUID
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
Building Building (number or code) TEXT10
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
PhoneNumberCountry Country/Region for Telephone/Fax Number LAND1
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
MobilePhoneCountry Country/Region for Telephone/Fax Number LAND1
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
MobilePhoneNumberExtension Telephone no.: Extension CHAR10
FaxCountry Country/Region for Telephone/Fax Number LAND1
FaxNumber Fax number: dialling code+number CHAR30
FaxNumberExtension Fax no.: Extension CHAR10
EmailAddress E-Mail Address AD_SMTPADR
ContactPersonRemarkText Notes for Partner TEXT40
FullName null
Master Data Relations Join Conditions
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_BUSINESSPARTNERCONTACTTP.MANDT == BUT000.CLIENT
  • I_BUSINESSPARTNERCONTACTTP.BUSINESSPARTNERFOREDIT == BUT000.PARTNER
  • I_BUSINESSPARTNERCONTACTTP.BUSINESSPARTNER == BUT000.PARTNER
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_BUSINESSPARTNERCONTACTTP.MANDT == BUT000.CLIENT
  • I_BUSINESSPARTNERCONTACTTP.BUSINESSPARTNERFOREDIT == BUT000.PARTNER
  • I_BUSINESSPARTNERCONTACTTP.BUSINESSPARTNER == BUT000.PARTNER
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_BUSINESSPARTNERCONTACTTP.MANDT == BUT000.CLIENT
  • I_BUSINESSPARTNERCONTACTTP.BUSINESSPARTNERPERSON == BUT000.PARTNER
  • I_BUSINESSPARTNERCONTACTTP.BUSINESSPARTNERPERSONFOREDIT == BUT000.PARTNER
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • I_BUSINESSPARTNERCONTACTTP.MANDT == BUT000.CLIENT
  • I_BUSINESSPARTNERCONTACTTP.BUSINESSPARTNERPERSON == BUT000.PARTNER
  • I_BUSINESSPARTNERCONTACTTP.BUSINESSPARTNERPERSONFOREDIT == BUT000.PARTNER
Partner's Authority
  • Partner's Authority
  • Client
  • I_BUSINESSPARTNERCONTACTTP.CONTACTPERSONAUTHORITYTYPE == TB914.PAAUTH
  • I_BUSINESSPARTNERCONTACTTP.MANDT == TB914.CLIENT
Department
  • Department
  • Client
  • I_BUSINESSPARTNERCONTACTTP.CONTACTPERSONDEPARTMENT == TB910.ABTNR
  • I_BUSINESSPARTNERCONTACTTP.MANDT == TB910.CLIENT
Function of partner
  • Function of partner
  • Client
  • I_BUSINESSPARTNERCONTACTTP.CONTACTPERSONFUNCTION == TB912.PAFKT
  • I_BUSINESSPARTNERCONTACTTP.MANDT == TB912.CLIENT
VIP Partner
  • VIP Partner
  • Client
  • I_BUSINESSPARTNERCONTACTTP.CONTACTPERSONVIPTYPE == TB916.PAVIP
  • I_BUSINESSPARTNERCONTACTTP.MANDT == TB916.CLIENT
Correspondence Language I_BUSINESSPARTNERCONTACTTP.CORRESPONDENCELANGUAGE == T002.SPRAS
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_BUSINESSPARTNERCONTACTTP.FORMOFADDRESS == TSAD3.TITLE
  • I_BUSINESSPARTNERCONTACTTP.MANDT == TSAD3.CLIENT