A_BusinessPartnerAddress

Address | view: ABUPARTADDRESS | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADRC, BUT000, BUT020, BUT021_FS, TB008S, TB008U
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
BPAddressIsProtected BP: Sensitivity Indicator Show values
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
Column Name Description Domain name
ValidityStartDate Validity Start of a Business Partner Address TZNTSTMPS
ValidityEndDate Validity End of a Business Partner Address TZNTSTMPS
AddressUUID GUID of a Business Partner Address SYSUUID
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
AddressIDByExternalSystem Address number in external system BU_ADEXT
CountyCode County code for county CNTY_CODE
TownshipCode Township code for Township TWSHP_CODE
TownshipName Township TEXT40
Master Data Relations Join Conditions
Address Number
  • Client
  • ?
  • Address Number
  • ?
  • A_BUSINESSPARTNERADDRESS.MANDT == ADRC.CLIENT
  • A_BUSINESSPARTNERADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • A_BUSINESSPARTNERADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • A_BUSINESSPARTNERADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Address time zone
  • Client
  • Address time zone
  • A_BUSINESSPARTNERADDRESS.MANDT == TTZZ.CLIENT
  • A_BUSINESSPARTNERADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Authorization Group
  • Client
  • ?
  • Authorization Group
  • A_BUSINESSPARTNERADDRESS.MANDT == TB037.CLIENT
  • A_BUSINESSPARTNERADDRESS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • A_BUSINESSPARTNERADDRESS.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Number
  • Client
  • Business Partner Number
  • A_BUSINESSPARTNERADDRESS.MANDT == BUT000.CLIENT
  • A_BUSINESSPARTNERADDRESS.BUSINESSPARTNER == BUT000.PARTNER
City code for city/street file
  • Country/Region Key
  • Client
  • City code for city/street file
  • A_BUSINESSPARTNERADDRESS.COUNTRY == ADRCITY.COUNTRY
  • A_BUSINESSPARTNERADDRESS.MANDT == ADRCITY.CLIENT
  • A_BUSINESSPARTNERADDRESS.CITYCODE == ADRCITY.CITY_CODE
Country key
  • Country/Region Key
  • Client
  • A_BUSINESSPARTNERADDRESS.COUNTRY == T005.LAND1
  • A_BUSINESSPARTNERADDRESS.MANDT == T005.MANDT
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • A_BUSINESSPARTNERADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • A_BUSINESSPARTNERADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • A_BUSINESSPARTNERADDRESS.FORMOFADDRESS == TSAD3.TITLE
  • A_BUSINESSPARTNERADDRESS.MANDT == TSAD3.CLIENT
Language key A_BUSINESSPARTNERADDRESS.LANGUAGE == T002.SPRAS
Key of person
  • Client
  • Person Number
  • ?
  • ?
  • A_BUSINESSPARTNERADDRESS.MANDT == ADRP.CLIENT
  • A_BUSINESSPARTNERADDRESS.PERSON == ADRP.PERSNUMBER
  • A_BUSINESSPARTNERADDRESS.[column in domain "AD_NATION"] == ADRP.NATION
  • A_BUSINESSPARTNERADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • A_BUSINESSPARTNERADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • A_BUSINESSPARTNERADDRESS.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_BUSINESSPARTNERADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • A_BUSINESSPARTNERADDRESS.MANDT == T005S.MANDT
  • A_BUSINESSPARTNERADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method A_BUSINESSPARTNERADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • A_BUSINESSPARTNERADDRESS.COUNTRY == T005S.LAND1
  • A_BUSINESSPARTNERADDRESS.MANDT == T005S.MANDT
  • A_BUSINESSPARTNERADDRESS.REGION == T005S.BLAND
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • A_BUSINESSPARTNERADDRESS.COUNTRY == TZONE.LAND1
  • A_BUSINESSPARTNERADDRESS.MANDT == TZONE.MANDT
  • A_BUSINESSPARTNERADDRESS.TRANSPORTZONE == TZONE.ZONE1