I_BusinessPartnerAddress

Core view for Business Partner Address | view: IBPADDRESS | Extraction: Not supported | Component: SAP Business Partner
Tables used: ADCP, ADRC, ADR6, ADR3, ADR12, ADR2, BUT020
Column Name Description
BusinessPartner FK Business Partner Number
AddressNumber FK Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
CityFileTestStatus City file test status 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
BusinessPartnerAddressUUID GUID of a Business Partner Address SYSUUID
BPTargetAddressID Number of Move Target Address for Address Moves AD_ADDRNUM
BPAddressMoveDateTime Date of Move for Address Moves TZNTSTMPS
CareOfName c/o name TEXT40
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
HouseNumber House Number TEXT10
StreetName Street TEXT60
HouseNumberSupplementText House number supplement TEXT10
District District TEXT40
PostalCode City postal code CHAR10
CityName City TEXT40
TaxJurisdiction 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
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
HomeCityName City (different from postal city) TEXT40
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
County County TEXT40
CountyCode County code for county CNTY_CODE
TownshipCode Township code for Township TWSHP_CODE
TownshipName Township TEXT40
PhoneNumber null
PhoneNumberCountry null
PhoneNumberExtension null
FaxNumber null
FaxCountry null
FaxNumberExtension null
MobilePhoneNumber null
MobilePhoneCountry null
EmailAddress null
URLFieldLength null
WebsiteURL Universal Resource Identifier (URI) AD_URI
Master Data Relations Join Conditions
Address Number
  • ?
  • Address Number
  • Client
  • ?
  • I_BUSINESSPARTNERADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BUSINESSPARTNERADDRESS.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • I_BUSINESSPARTNERADDRESS.MANDT == ADRC.CLIENT
  • I_BUSINESSPARTNERADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
Non-Delivery Reason
  • PO Box Address Undeliverable Flag
  • Client
  • I_BUSINESSPARTNERADDRESS.ADDRESSPOSTBOXUNUSABLE == TSAD12.UNDELIVER
  • I_BUSINESSPARTNERADDRESS.MANDT == TSAD12.CLIENT
Non-Delivery Reason
  • Street Address Undeliverable Flag
  • Client
  • I_BUSINESSPARTNERADDRESS.ADDRESSSTREETUNUSABLE == TSAD12.UNDELIVER
  • I_BUSINESSPARTNERADDRESS.MANDT == TSAD12.CLIENT
Address time zone
  • Address time zone
  • Client
  • I_BUSINESSPARTNERADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
  • I_BUSINESSPARTNERADDRESS.MANDT == TTZZ.CLIENT
Business Partner Number
  • Client
  • Business Partner Number
  • I_BUSINESSPARTNERADDRESS.MANDT == BUT000.CLIENT
  • I_BUSINESSPARTNERADDRESS.BUSINESSPARTNER == BUT000.PARTNER
Language key I_BUSINESSPARTNERADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • I_BUSINESSPARTNERADDRESS.MANDT == T005.MANDT
  • I_BUSINESSPARTNERADDRESS.COUNTRY == T005.LAND1
Address Delivery service type text table
  • Type of Delivery Service
  • ?
  • I_BUSINESSPARTNERADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
  • I_BUSINESSPARTNERADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_BUSINESSPARTNERADDRESS.MANDT == TSAD3.CLIENT
  • I_BUSINESSPARTNERADDRESS.FORMOFADDRESS == TSAD3.TITLE
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • I_BUSINESSPARTNERADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • I_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, ...)
  • I_BUSINESSPARTNERADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • I_BUSINESSPARTNERADDRESS.MANDT == T005S.MANDT
  • I_BUSINESSPARTNERADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method I_BUSINESSPARTNERADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • I_BUSINESSPARTNERADDRESS.REGION == T005S.BLAND
  • I_BUSINESSPARTNERADDRESS.MANDT == T005S.MANDT
  • I_BUSINESSPARTNERADDRESS.COUNTRY == T005S.LAND1
Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • I_BUSINESSPARTNERADDRESS.MANDT == TZONE.MANDT
  • I_BUSINESSPARTNERADDRESS.COUNTRY == TZONE.LAND1
  • I_BUSINESSPARTNERADDRESS.TRANSPORTZONE == TZONE.ZONE1