I_BusPartScriptedPersonAddress

International version of a business partner address | view: IBPSCRPTPRSADDR | Extraction: Not supported | Component: Business Partner RAP
Tables used: BUT020, ADCP, ADRC, ADRP
Column Name Description
BusinessPartner FK Business Partner Number
AddressNumber FK Address Number
AddressRepresentationCode FK Version ID for International Addresses
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
ValidityStartDateTime Validity Start of a Business Partner Address TZNTSTMPS
ValidityEndDateTime Validity End of a Business Partner Address TZNTSTMPS
BusinessPartnerAddressUUID null
CareOfName c/o name TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
POBoxLobbyName PO Box Lobby TEXT40
POBoxDeviatingCityName PO Box city TEXT40
DeliveryServiceNumber Number of Delivery Service CHAR10
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
CityName City TEXT40
District District TEXT40
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
County County TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
Person Person Number AD_PERSNUM
SearchTerm1 Search Term 1 CHAR20
SearchTerm2 Search Term 2 CHAR20
FirstName First name TEXT40
LastName Last name TEXT40
BusinessPartnerBirthName Name of person at birth TEXT40
MiddleName Middle name or second forename of a person TEXT40
AdditionalLastName Other Last Name of a Person TEXT40
PersonFullName Full Name of Person TEXT80
BusinessPartnerNicknameLabel Nickname or name used TEXT40
Initials "Middle Initial" or personal initials CHAR10
BPFirstNameSearchHelp First Name in Uppercase for Search Help CHAR25
BPLastNameSearchHelp Last Name in Uppercase for Search Help CHAR25
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TSAD2.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.ACADEMICTITLE == TSAD2.TITLE_KEY
Second academic title (key)
  • Client
  • Second academic title (key)
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TSAD2.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.ACADEMICTITLE2 == TSAD2.TITLE_KEY
Non-Delivery Reason
  • Street Address Undeliverable Flag
  • Client
  • I_BUSPARTSCRIPTEDPERSONADDRESS.ADDRESSNONDELIVERABLEREASON == TSAD12.UNDELIVER
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TSAD12.CLIENT
Address Number
  • ?
  • Address Number
  • Client
  • Version ID for International Addresses
  • I_BUSPARTSCRIPTEDPERSONADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BUSPARTSCRIPTEDPERSONADDRESS.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == ADRC.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
Version ID for International Addresses I_BUSPARTSCRIPTEDPERSONADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Address time zone
  • Client
  • Address time zone
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TTZZ.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Business Partner Number
  • Business Partner Number
  • Client
  • I_BUSPARTSCRIPTEDPERSONADDRESS.BUSINESSPARTNER == BUT000.PARTNER
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == BUT000.CLIENT
Name supplement, e.g. noble title (key)
  • Name supplement, e.g. noble title (key)
  • Client
  • I_BUSPARTSCRIPTEDPERSONADDRESS.BUSINESSPARTNERSUPPLEMENTNAME == TSAD5.TITLE_KEY
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TSAD5.CLIENT
Language key I_BUSPARTSCRIPTEDPERSONADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Country/Region Key
  • Client
  • I_BUSPARTSCRIPTEDPERSONADDRESS.COUNTRY == T005.LAND1
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == T005.MANDT
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • I_BUSPARTSCRIPTEDPERSONADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TSAD3.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.FORMOFADDRESS == TSAD3.TITLE
Name Prefix (Key)
  • Client
  • Name Prefix (Key)
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TSAD4.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TSAD4.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
Country/Region for Name Format Rule
  • Client
  • Country/Region for Name Format Rule
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == T005.MANDT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.NAMECOUNTRY == T005.LAND1
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • I_BUSPARTSCRIPTEDPERSONADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • I_BUSPARTSCRIPTEDPERSONADDRESS.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_BUSPARTSCRIPTEDPERSONADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == T005S.MANDT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TSAD12.CLIENT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.POSTBOXNONDELIVERABLEREASON == TSAD12.UNDELIVER
Communication Method I_BUSPARTSCRIPTEDPERSONADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_BUSPARTSCRIPTEDPERSONADDRESS.COUNTRY == T005S.LAND1
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == T005S.MANDT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.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
  • I_BUSPARTSCRIPTEDPERSONADDRESS.COUNTRY == TZONE.LAND1
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == TZONE.MANDT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.TRANSPORTZONE == TZONE.ZONE1
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Name format
  • Client
  • Country/Region for Name Format Rule
  • I_BUSPARTSCRIPTEDPERSONADDRESS.NAMEFORMAT == T005N.NAMEFORMAT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.MANDT == T005N.MANDT
  • I_BUSPARTSCRIPTEDPERSONADDRESS.NAMECOUNTRY == T005N.LAND1