P_Bpcontacts_Address

Address Data of BP Contacts | view: P_MD_BPC_ADR | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADR3, ADR6, BUT000, BUT052, ADR2, ADR2
Column Name Description
Relationship FK BP Relationship Number
BusinessPartner Business Partner Number
AddressID FK Address Number
Person Person Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsDefaultAddress Indicator: Address is standard address Show values
Column Name Description Domain 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
Address Number
  • ?
  • Address Number
  • ?
  • Client
  • P_BPCONTACTS_ADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • P_BPCONTACTS_ADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • P_BPCONTACTS_ADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • P_BPCONTACTS_ADDRESS.MANDT == ADRC.CLIENT
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • P_BPCONTACTS_ADDRESS.MANDT == T005.MANDT
  • P_BPCONTACTS_ADDRESS.FAXCOUNTRY == T005.LAND1
  • P_BPCONTACTS_ADDRESS.PHONECOUNTRY == T005.LAND1
  • P_BPCONTACTS_ADDRESS.MOBILEPHONECOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • P_BPCONTACTS_ADDRESS.MANDT == T005.MANDT
  • P_BPCONTACTS_ADDRESS.FAXCOUNTRY == T005.LAND1
  • P_BPCONTACTS_ADDRESS.PHONECOUNTRY == T005.LAND1
  • P_BPCONTACTS_ADDRESS.MOBILEPHONECOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • P_BPCONTACTS_ADDRESS.MANDT == T005.MANDT
  • P_BPCONTACTS_ADDRESS.FAXCOUNTRY == T005.LAND1
  • P_BPCONTACTS_ADDRESS.PHONECOUNTRY == T005.LAND1
  • P_BPCONTACTS_ADDRESS.MOBILEPHONECOUNTRY == T005.LAND1
BP Relationship Number
  • Business Partner Number
  • BP Relationship Number
  • Client
  • ?
  • ?
  • P_BPCONTACTS_ADDRESS.BUSINESSPARTNER == BUT050.PARTNER2
  • P_BPCONTACTS_ADDRESS.RELATIONSHIP == BUT050.RELNR
  • P_BPCONTACTS_ADDRESS.MANDT == BUT050.CLIENT
  • P_BPCONTACTS_ADDRESS.[column in domain "BU_DATTO"] == BUT050.DATE_TO
  • P_BPCONTACTS_ADDRESS.[column in domain "BU_PARTNER"] == BUT050.PARTNER1