A_BPContactToAddress

Contact Person Address | view: ABPCONTACTADDR | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADRC, ADR3, ADR2, ADCP, BUT000, BUT052, BUT000, BUT020, BUT021_FS, TB008S, TB008U
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
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
Column Name Description Domain name
AdditionalStreetPrefixName Street 3 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
CareOfName c/o name TEXT40
CityName City TEXT40
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
County County TEXT40
DeliveryServiceNumber Number of Delivery Service CHAR10
District District TEXT40
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
HomeCityName City (different from postal city) TEXT40
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
POBox PO Box CHAR10
POBoxDeviatingCityName PO Box city TEXT40
POBoxLobbyName PO Box Lobby TEXT40
POBoxPostalCode PO Box Postal Code CHAR10
PostalCode City postal code CHAR10
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
StreetSuffixName Street 4 TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
ContactRelationshipFunction Function TEXT40
ContactRelationshipDepartment Department TEXT40
Floor Floor in building TEXT10
ContactPersonBuilding Building (number or code) TEXT10
RoomNumber Room or Apartment Number TEXT10
CorrespondenceShortName Short name for correspondence TEXT10
InhouseMail Internal Mail Postal Code TEXT10
Master Data Relations Join Conditions
Address Number
  • Address Number
  • Address Number
  • Client
  • ?
  • Version ID for International Addresses
  • A_BPCONTACTTOADDRESS.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • A_BPCONTACTTOADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • A_BPCONTACTTOADDRESS.MANDT == ADRC.CLIENT
  • A_BPCONTACTTOADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • A_BPCONTACTTOADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
Address Number
  • Address Number
  • Address Number
  • Client
  • ?
  • Version ID for International Addresses
  • A_BPCONTACTTOADDRESS.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • A_BPCONTACTTOADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • A_BPCONTACTTOADDRESS.MANDT == ADRC.CLIENT
  • A_BPCONTACTTOADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • A_BPCONTACTTOADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
Version ID for International Addresses A_BPCONTACTTOADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Address time zone
  • Address time zone
  • Client
  • A_BPCONTACTTOADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
  • A_BPCONTACTTOADDRESS.MANDT == TTZZ.CLIENT
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • A_BPCONTACTTOADDRESS.CITYCODE == ADRCITY.CITY_CODE
  • A_BPCONTACTTOADDRESS.MANDT == ADRCITY.CLIENT
  • A_BPCONTACTTOADDRESS.COUNTRY == ADRCITY.COUNTRY
Standard communication type
  • Communication Method (Key) (Business Address Services)
  • Communication Method (Key) (Business Address Services)
  • A_BPCONTACTTOADDRESS.CONTACTPERSONPRFRDCOMMMEDIUM == TSAC.COMM_TYPE
  • A_BPCONTACTTOADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Country key
  • Client
  • Country/Region Key
  • A_BPCONTACTTOADDRESS.MANDT == T005.MANDT
  • A_BPCONTACTTOADDRESS.COUNTRY == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • A_BPCONTACTTOADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • A_BPCONTACTTOADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • A_BPCONTACTTOADDRESS.MANDT == TSAD3.CLIENT
  • A_BPCONTACTTOADDRESS.FORMOFADDRESS == TSAD3.TITLE
Language key A_BPCONTACTTOADDRESS.LANGUAGE == T002.SPRAS
Key of person
  • ?
  • Client
  • Version ID for International Addresses
  • Person Number
  • A_BPCONTACTTOADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • A_BPCONTACTTOADDRESS.MANDT == ADRP.CLIENT
  • A_BPCONTACTTOADDRESS.ADDRESSREPRESENTATIONCODE == ADRP.NATION
  • A_BPCONTACTTOADDRESS.PERSON == ADRP.PERSNUMBER
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • A_BPCONTACTTOADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • A_BPCONTACTTOADDRESS.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Client
  • Region for PO Box (Country/Region, State, Province, ...)
  • A_BPCONTACTTOADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • A_BPCONTACTTOADDRESS.MANDT == T005S.MANDT
  • A_BPCONTACTTOADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method
  • Communication Method (Key) (Business Address Services)
  • Communication Method (Key) (Business Address Services)
  • A_BPCONTACTTOADDRESS.CONTACTPERSONPRFRDCOMMMEDIUM == TSAC.COMM_TYPE
  • A_BPCONTACTTOADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • A_BPCONTACTTOADDRESS.MANDT == T005S.MANDT
  • A_BPCONTACTTOADDRESS.REGION == T005S.BLAND
  • A_BPCONTACTTOADDRESS.COUNTRY == T005S.LAND1
BP Relationship Number
  • Client
  • Business Partner Number
  • Validity Date (Valid To)
  • Business Partner Number
  • BP Relationship Number
  • A_BPCONTACTTOADDRESS.MANDT == BUT050.CLIENT
  • A_BPCONTACTTOADDRESS.BUSINESSPARTNERPERSON == BUT050.PARTNER2
  • A_BPCONTACTTOADDRESS.VALIDITYENDDATE == BUT050.DATE_TO
  • A_BPCONTACTTOADDRESS.BUSINESSPARTNERCOMPANY == BUT050.PARTNER1
  • A_BPCONTACTTOADDRESS.RELATIONSHIPNUMBER == BUT050.RELNR
Transportation zone to or from which the goods are delivered
  • Client
  • Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • A_BPCONTACTTOADDRESS.MANDT == TZONE.MANDT
  • A_BPCONTACTTOADDRESS.TRANSPORTZONE == TZONE.ZONE1
  • A_BPCONTACTTOADDRESS.COUNTRY == TZONE.LAND1