P_Businesspartnerpcontacts

Business Partner Contacts | view: P_MD_BPCONTACTS | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADR3, ADR6, BUT000, BUT052, BUT000, BUT051, ADR2, ADR2, BUT050
Column Name Description
RelationshipNumber BP Relationship Number
BusinessPartner1 FK Business Partner Number
BusinessPartner2 FK Business Partner Number
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
IsStandardRelationship Standard Relationship Show values
Column Name Description Domain name
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
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
InternationalMobilePhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
MobilePhoneExtension Telephone no.: Extension CHAR10
InternationalFaxNumber Complete number: dialling code+number+extension CHAR30
FaxNumber Fax number: dialling code+number CHAR30
FaxNumberExtension Fax no.: Extension CHAR10
EmailAddress E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Authorization Group
  • Client
  • ?
  • Authorization Group
  • P_BUSINESSPARTNERPCONTACTS.MANDT == TB037.CLIENT
  • P_BUSINESSPARTNERPCONTACTS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • P_BUSINESSPARTNERPCONTACTS.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Number
  • Client
  • Business Partner Number
  • P_BUSINESSPARTNERPCONTACTS.MANDT == BUT000.CLIENT
  • P_BUSINESSPARTNERPCONTACTS.BUSINESSPARTNER1 == BUT000.PARTNER
Business Partner Number
  • Client
  • Business Partner Number
  • P_BUSINESSPARTNERPCONTACTS.MANDT == BUT000.CLIENT
  • P_BUSINESSPARTNERPCONTACTS.BUSINESSPARTNER2 == BUT000.PARTNER
Department
  • Department
  • Client
  • P_BUSINESSPARTNERPCONTACTS.CONTACTPERSONDEPARTMENT == TB910.ABTNR
  • P_BUSINESSPARTNERPCONTACTS.MANDT == TB910.CLIENT
Function of partner
  • Client
  • Function of partner
  • P_BUSINESSPARTNERPCONTACTS.MANDT == TB912.CLIENT
  • P_BUSINESSPARTNERPCONTACTS.CONTACTPERSONFUNCTION == TB912.PAFKT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • P_BUSINESSPARTNERPCONTACTS.PHONECOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.MOBILEPHONECOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.FAXCOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.MANDT == T005.MANDT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • P_BUSINESSPARTNERPCONTACTS.MANDT == TSAD3.CLIENT
  • P_BUSINESSPARTNERPCONTACTS.FORMOFADDRESS == TSAD3.TITLE
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • P_BUSINESSPARTNERPCONTACTS.PHONECOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.MOBILEPHONECOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.FAXCOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.MANDT == T005.MANDT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • P_BUSINESSPARTNERPCONTACTS.PHONECOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.MOBILEPHONECOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.FAXCOUNTRY == T005.LAND1
  • P_BUSINESSPARTNERPCONTACTS.MANDT == T005.MANDT