I_ScriptedPersonAddress

Interational Address Version for Persons | view: ISCRPTPRSNADDR | Extraction: Not supported | Component: Business Partner RAP

Tables used: ADCP, ADRC, ADRP

🔑 Keys (3)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (2)
Other (41)
🔗 Relations (23)

Column Name	Description
AddressNumber FK	Address Number
AddressRepresentationCode FK	Version ID for International Addresses
Person	Person 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
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
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
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_SCRIPTEDPERSONADDRESS.MANDT == TSAD2.CLIENT` `I_SCRIPTEDPERSONADDRESS.ACADEMICTITLE == TSAD2.TITLE_KEY`
Second academic title (key) Client Second academic title (key)	`I_SCRIPTEDPERSONADDRESS.MANDT == TSAD2.CLIENT` `I_SCRIPTEDPERSONADDRESS.ACADEMICTITLE2 == TSAD2.TITLE_KEY`
City PO box code (City file) Client ? City PO box code (City file)	`I_SCRIPTEDPERSONADDRESS.MANDT == ADRCITY.CLIENT` `I_SCRIPTEDPERSONADDRESS.[column in domain "LAND1"] == ADRCITY.COUNTRY` `I_SCRIPTEDPERSONADDRESS.ADDRESSCITYPOSTBOXCODE == ADRCITY.CITY_CODE`
Non-Delivery Reason Client Street Address Undeliverable Flag	`I_SCRIPTEDPERSONADDRESS.MANDT == TSAD12.CLIENT` `I_SCRIPTEDPERSONADDRESS.ADDRESSNONDELIVERABLEREASON == TSAD12.UNDELIVER`
Address key Address Number Client Version ID for International Addresses ?	`I_SCRIPTEDPERSONADDRESS.ADDRESSNUMBER == ADRC.ADDRNUMBER` `I_SCRIPTEDPERSONADDRESS.MANDT == ADRC.CLIENT` `I_SCRIPTEDPERSONADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION` `I_SCRIPTEDPERSONADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM`
Version ID for International Addresses	`I_SCRIPTEDPERSONADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION`
Address time zone Client Address time zone	`I_SCRIPTEDPERSONADDRESS.MANDT == TTZZ.CLIENT` `I_SCRIPTEDPERSONADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE`
Name supplement, e.g. noble title (key) Name supplement, e.g. noble title (key) Client	`I_SCRIPTEDPERSONADDRESS.BUSINESSPARTNERSUPPLEMENTNAME == TSAD5.TITLE_KEY` `I_SCRIPTEDPERSONADDRESS.MANDT == TSAD5.CLIENT`
City code for city/street file Client City code for city/street file Country/Region Key	`I_SCRIPTEDPERSONADDRESS.MANDT == ADRCITY.CLIENT` `I_SCRIPTEDPERSONADDRESS.CITYCODE == ADRCITY.CITY_CODE` `I_SCRIPTEDPERSONADDRESS.COUNTRY == ADRCITY.COUNTRY`
Language key	`I_SCRIPTEDPERSONADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS`
Country key Client Country/Region Key	`I_SCRIPTEDPERSONADDRESS.MANDT == T005.MANDT` `I_SCRIPTEDPERSONADDRESS.COUNTRY == T005.LAND1`
Address Delivery service type text table ? Type of Delivery Service	`I_SCRIPTEDPERSONADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT` `I_SCRIPTEDPERSONADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE`
Form-of-Address Key Client Form-of-Address Key	`I_SCRIPTEDPERSONADDRESS.MANDT == TSAD3.CLIENT` `I_SCRIPTEDPERSONADDRESS.FORMOFADDRESS == TSAD3.TITLE`
Name Prefix (Key) Name Prefix (Key) Client	`I_SCRIPTEDPERSONADDRESS.LASTNAMEPREFIX == TSAD4.PREFIX_KEY` `I_SCRIPTEDPERSONADDRESS.MANDT == TSAD4.CLIENT`
2nd name prefix (key) Client 2nd name prefix (key)	`I_SCRIPTEDPERSONADDRESS.MANDT == TSAD4.CLIENT` `I_SCRIPTEDPERSONADDRESS.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY`
Country/Region for Name Format Rule Client Country/Region for Name Format Rule	`I_SCRIPTEDPERSONADDRESS.MANDT == T005.MANDT` `I_SCRIPTEDPERSONADDRESS.NAMECOUNTRY == T005.LAND1`
PO Box of Country/Region Client PO Box of Country/Region	`I_SCRIPTEDPERSONADDRESS.MANDT == T005.MANDT` `I_SCRIPTEDPERSONADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1`
Region for PO Box (Country/Region, State, Province, ...) Client PO Box of Country/Region Region for PO Box (Country/Region, State, Province, ...)	`I_SCRIPTEDPERSONADDRESS.MANDT == T005S.MANDT` `I_SCRIPTEDPERSONADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1` `I_SCRIPTEDPERSONADDRESS.POBOXDEVIATINGREGION == T005S.BLAND`
Non-Delivery Reason PO Box Address Undeliverable Flag Client	`I_SCRIPTEDPERSONADDRESS.POSTBOXNONDELIVERABLEREASON == TSAD12.UNDELIVER` `I_SCRIPTEDPERSONADDRESS.MANDT == TSAD12.CLIENT`
Communication Method	`I_SCRIPTEDPERSONADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE`
Region code Client Country/Region Key Region (State, Province, County)	`I_SCRIPTEDPERSONADDRESS.MANDT == T005S.MANDT` `I_SCRIPTEDPERSONADDRESS.COUNTRY == T005S.LAND1` `I_SCRIPTEDPERSONADDRESS.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	`I_SCRIPTEDPERSONADDRESS.MANDT == TZONE.MANDT` `I_SCRIPTEDPERSONADDRESS.COUNTRY == TZONE.LAND1` `I_SCRIPTEDPERSONADDRESS.TRANSPORTZONE == TZONE.ZONE1`

Other Relations \| to Master Data Relations ↑	Join Conditions
Name format Client Country/Region for Name Format Rule Name format	`I_SCRIPTEDPERSONADDRESS.MANDT == T005N.MANDT` `I_SCRIPTEDPERSONADDRESS.NAMECOUNTRY == T005N.LAND1` `I_SCRIPTEDPERSONADDRESS.NAMEFORMAT == T005N.NAMEFORMAT`