C_BusinessPartnerAddress

Business Partner Address | view: CBUPAADDRESS1 | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADRC, ADR6, ADR3, ADR12, ADR2, BUT000, BUT020, BUT021_FS, BUT021_FS, TB008S, TB008U
Column Name Description
BusinessPartner FK Business Partner Number
AddressNumber FK Address Number
Column Name Description
Column Name Description
Column Name Description
AddressValidityStartDate null
AddressValidityEndDate null
AddressMoveDate null
Column Name Description
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
StandardUsage Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
CareOfName c/o name TEXT40
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
HouseNumber House Number TEXT10
StreetName Street TEXT60
CustomerSupplierStreetName Street TEXT60
HouseNumberSupplementText House number supplement TEXT10
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
HomeCityName City (different from postal city) TEXT40
District District TEXT40
PostalCode City postal code CHAR10
CityName City TEXT40
CustomerSupplierCityName City TEXT40
County County TEXT40
TownshipName Township TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
TaxJurisdictionByProvider Tax Jurisdiction AD_TXJCD
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
DeliveryServiceNumber Number of Delivery Service CHAR10
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
POBoxLobbyName PO Box Lobby TEXT40
POBoxDeviatingCityName PO Box city TEXT40
PhoneNumberCountry null
PhoneNumber null
PhoneNumberExtension null
MobilePhoneCountry null
MobilePhoneNumber null
FaxCountry null
FaxNumber null
FaxNumberExtension null
EmailAddress null
BPTargetAddressID Number of Move Target Address for Address Moves AD_ADDRNUM
FormattedPostalAddressText null
BPTargetAddressText null
InternationalPhoneNumber null
URLFieldLength null
WebsiteURL Universal Resource Identifier (URI) AD_URI
Master Data Relations Join Conditions
Address Number
  • Client
  • ?
  • Address Number
  • Address Number
  • ?
  • C_BUSINESSPARTNERADDRESS.MANDT == ADRC.CLIENT
  • C_BUSINESSPARTNERADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_BUSINESSPARTNERADDRESS.ADDRESSNUMBERFOREDIT == ADRC.ADDRNUMBER
  • C_BUSINESSPARTNERADDRESS.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • C_BUSINESSPARTNERADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
Address Number
  • Client
  • ?
  • Address Number
  • Address Number
  • ?
  • C_BUSINESSPARTNERADDRESS.MANDT == ADRC.CLIENT
  • C_BUSINESSPARTNERADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_BUSINESSPARTNERADDRESS.ADDRESSNUMBERFOREDIT == ADRC.ADDRNUMBER
  • C_BUSINESSPARTNERADDRESS.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • C_BUSINESSPARTNERADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
Address time zone
  • Client
  • Address time zone
  • C_BUSINESSPARTNERADDRESS.MANDT == TTZZ.CLIENT
  • C_BUSINESSPARTNERADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • C_BUSINESSPARTNERADDRESS.MANDT == BUT000.CLIENT
  • C_BUSINESSPARTNERADDRESS.BUSINESSPARTNERFOREDIT == BUT000.PARTNER
  • C_BUSINESSPARTNERADDRESS.BUSINESSPARTNER == BUT000.PARTNER
Business Partner Number
  • Client
  • Business Partner Number
  • Business Partner Number
  • C_BUSINESSPARTNERADDRESS.MANDT == BUT000.CLIENT
  • C_BUSINESSPARTNERADDRESS.BUSINESSPARTNERFOREDIT == BUT000.PARTNER
  • C_BUSINESSPARTNERADDRESS.BUSINESSPARTNER == BUT000.PARTNER
Language key C_BUSINESSPARTNERADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • C_BUSINESSPARTNERADDRESS.MANDT == T005.MANDT
  • C_BUSINESSPARTNERADDRESS.COUNTRY == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • C_BUSINESSPARTNERADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • C_BUSINESSPARTNERADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • C_BUSINESSPARTNERADDRESS.MANDT == T005.MANDT
  • C_BUSINESSPARTNERADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • C_BUSINESSPARTNERADDRESS.MANDT == T005S.MANDT
  • C_BUSINESSPARTNERADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
  • C_BUSINESSPARTNERADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
Communication Method C_BUSINESSPARTNERADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_BUSINESSPARTNERADDRESS.MANDT == T005S.MANDT
  • C_BUSINESSPARTNERADDRESS.COUNTRY == T005S.LAND1
  • C_BUSINESSPARTNERADDRESS.REGION == T005S.BLAND
Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • C_BUSINESSPARTNERADDRESS.MANDT == TZONE.MANDT
  • C_BUSINESSPARTNERADDRESS.COUNTRY == TZONE.LAND1
  • C_BUSINESSPARTNERADDRESS.TRANSPORTZONE == TZONE.ZONE1