I_ScriptedAddress

Interational Address Version | view: ISCRPTEDADDR | Extraction: Not supported | Component: Business Partner RAP
Tables used: ADCPADRCADRP
Column Name Description
AddressNumber 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
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
CountyCode County code for county CNTY_CODE
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
PhoneNumber First telephone no.: dialling code+number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
StreetSearch Street Name in Uppercase for Search Help CHAR25
CitySearch City name in Uppercase for Search Help CHAR25
TaxJurisdiction Tax Jurisdiction AD_TXJCD
FormOfAddress Form-of-Address Key AD_TITLE
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_SCRIPTEDADDRESS.MANDT == TSAD2.CLIENT
  • I_SCRIPTEDADDRESS.ACADEMICTITLE == TSAD2.TITLE_KEY
Second academic title (key)
  • Client
  • Second academic title (key)
  • I_SCRIPTEDADDRESS.MANDT == TSAD2.CLIENT
  • I_SCRIPTEDADDRESS.ACADEMICTITLE2 == TSAD2.TITLE_KEY
City PO box code (City file)
  • City PO box code (City file)
  • ?
  • Client
  • I_SCRIPTEDADDRESS.ADDRESSCITYPOSTBOXCODE == ADRCITY.CITY_CODE
  • I_SCRIPTEDADDRESS.[column in domain "LAND1"] == ADRCITY.COUNTRY
  • I_SCRIPTEDADDRESS.MANDT == ADRCITY.CLIENT
Non-Delivery Reason
  • Street Address Undeliverable Flag
  • Client
  • I_SCRIPTEDADDRESS.ADDRESSNONDELIVERABLEREASON == TSAD12.UNDELIVER
  • I_SCRIPTEDADDRESS.MANDT == TSAD12.CLIENT
Version ID for International Addresses I_SCRIPTEDADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Address time zone
  • Address time zone
  • Client
  • I_SCRIPTEDADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
  • I_SCRIPTEDADDRESS.MANDT == TTZZ.CLIENT
City code for city/street file
  • City code for city/street file
  • Client
  • Country/Region Key
  • I_SCRIPTEDADDRESS.CITYCODE == ADRCITY.CITY_CODE
  • I_SCRIPTEDADDRESS.MANDT == ADRCITY.CLIENT
  • I_SCRIPTEDADDRESS.COUNTRY == ADRCITY.COUNTRY
Language key I_SCRIPTEDADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • I_SCRIPTEDADDRESS.MANDT == T005.MANDT
  • I_SCRIPTEDADDRESS.COUNTRY == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • I_SCRIPTEDADDRESS.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
  • I_SCRIPTEDADDRESS.MANDT == TSAD4.CLIENT
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • I_SCRIPTEDADDRESS.MANDT == TSAD4.CLIENT
  • I_SCRIPTEDADDRESS.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
Country/Region for Name Format Rule
  • Client
  • Country/Region for Name Format Rule
  • I_SCRIPTEDADDRESS.MANDT == T005.MANDT
  • I_SCRIPTEDADDRESS.NAMECOUNTRY == T005.LAND1
Key of person
  • Version ID for International Addresses
  • Person Number
  • ?
  • Client
  • I_SCRIPTEDADDRESS.ADDRESSREPRESENTATIONCODE == ADRP.NATION
  • I_SCRIPTEDADDRESS.PERSON == ADRP.PERSNUMBER
  • I_SCRIPTEDADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_SCRIPTEDADDRESS.MANDT == ADRP.CLIENT
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • I_SCRIPTEDADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • I_SCRIPTEDADDRESS.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Region for PO Box (Country/Region, State, Province, ...)
  • Client
  • I_SCRIPTEDADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • I_SCRIPTEDADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
  • I_SCRIPTEDADDRESS.MANDT == T005S.MANDT
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • I_SCRIPTEDADDRESS.MANDT == TSAD12.CLIENT
  • I_SCRIPTEDADDRESS.POSTBOXNONDELIVERABLEREASON == TSAD12.UNDELIVER
Communication Method I_SCRIPTEDADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • I_SCRIPTEDADDRESS.REGION == T005S.BLAND
  • I_SCRIPTEDADDRESS.MANDT == T005S.MANDT
  • I_SCRIPTEDADDRESS.COUNTRY == T005S.LAND1
Transportation zone to or from which the goods are delivered
  • Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • I_SCRIPTEDADDRESS.TRANSPORTZONE == TZONE.ZONE1
  • I_SCRIPTEDADDRESS.MANDT == TZONE.MANDT
  • I_SCRIPTEDADDRESS.COUNTRY == TZONE.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Client
  • Name format
  • Country/Region for Name Format Rule
  • I_SCRIPTEDADDRESS.MANDT == T005N.MANDT
  • I_SCRIPTEDADDRESS.NAMEFORMAT == T005N.NAMEFORMAT
  • I_SCRIPTEDADDRESS.NAMECOUNTRY == T005N.LAND1