I_BpContactToAddress

Business Partner Contact To Address | view: IBPCNTCTADDRESS | Extraction: Not supported | Component: SAP Business Partner
Tables used: ADR3, ADR2, ADCP, BUT000, BUT052, BUT000
Column Name Description
RelationshipNumber FK BP Relationship Number
BusinessPartnerCompany Business Partner Number
BusinessPartnerPerson Business Partner Number
ValidityEndDate Validity Date (Valid To)
AddressID FK Address Number
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate Validity Date (Valid To)
Column Name Description
IsDefaultAddress Indicator: Address is standard address Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
PersonNumber Person Number AD_PERSNUM
ContactRelationshipFunction Function TEXT40
ContactRelationshipDepartment Department TEXT40
Floor Floor in building TEXT10
Building Building (number or code) TEXT10
RoomNumber Room or Apartment Number TEXT10
CorrespondenceShortName Short name for correspondence TEXT10
InhouseMail Internal Mail Postal Code TEXT10
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
PhoneNumber Telephone no.: dialling code+number CHAR30
InternationalMobilePhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
MobilePhoneNumberExtension Telephone no.: Extension CHAR10
InternationalFaxNumber Complete number: dialling code+number+extension CHAR30
Master Data Relations Join Conditions
Address Number
  • Client
  • Address Number
  • Version ID for International Addresses
  • ?
  • I_BPCONTACTTOADDRESS.MANDT == ADRC.CLIENT
  • I_BPCONTACTTOADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPCONTACTTOADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
  • I_BPCONTACTTOADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Version ID for International Addresses I_BPCONTACTTOADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Authorization Group
  • Client
  • ?
  • Authorization Group
  • I_BPCONTACTTOADDRESS.MANDT == TB037.CLIENT
  • I_BPCONTACTTOADDRESS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_BPCONTACTTOADDRESS.AUTHORIZATIONGROUP == TB037.AUGRP
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • I_BPCONTACTTOADDRESS.MANDT == T005.MANDT
  • I_BPCONTACTTOADDRESS.MOBILEPHONECOUNTRY == T005.LAND1
  • I_BPCONTACTTOADDRESS.FAXCOUNTRY == T005.LAND1
  • I_BPCONTACTTOADDRESS.PHONENUMBERCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • I_BPCONTACTTOADDRESS.MANDT == T005.MANDT
  • I_BPCONTACTTOADDRESS.MOBILEPHONECOUNTRY == T005.LAND1
  • I_BPCONTACTTOADDRESS.FAXCOUNTRY == T005.LAND1
  • I_BPCONTACTTOADDRESS.PHONENUMBERCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • I_BPCONTACTTOADDRESS.MANDT == T005.MANDT
  • I_BPCONTACTTOADDRESS.MOBILEPHONECOUNTRY == T005.LAND1
  • I_BPCONTACTTOADDRESS.FAXCOUNTRY == T005.LAND1
  • I_BPCONTACTTOADDRESS.PHONENUMBERCOUNTRY == T005.LAND1
Standard communication type I_BPCONTACTTOADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
BP Relationship Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • Validity Date (Valid To)
  • BP Relationship Number
  • I_BPCONTACTTOADDRESS.MANDT == BUT050.CLIENT
  • I_BPCONTACTTOADDRESS.BUSINESSPARTNERCOMPANY == BUT050.PARTNER1
  • I_BPCONTACTTOADDRESS.BUSINESSPARTNERPERSON == BUT050.PARTNER2
  • I_BPCONTACTTOADDRESS.VALIDITYENDDATE == BUT050.DATE_TO
  • I_BPCONTACTTOADDRESS.RELATIONSHIPNUMBER == BUT050.RELNR