I_AddressTP

Address Reuse Component Transactional | view: IADDRTP | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: ADCPADRCADR6
Column Name Description
AddressID Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
AddressType Address type (1=Organization, 2=Person, 3=Contact person) Show values
AddressIsChangedManually Boolean Variable (X = True, - = False, Space = Unknown) Show values
ActiveAddressIsManual Boolean Variable (X = True, - = False, Space = Unknown) Show values
ReferenceAddressType Address Type 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 Address Full Name 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
PhoneNumber Phone Number: Area Code+Number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
SearchTerm1 Search Term 1 CHAR20
StreetSearch Street Name in Uppercase for Search Help CHAR25
CitySearch City name in Uppercase for Search Help CHAR25
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
AddressOwnerObjectID Address owner object ID SWO_TYPEID
ActiveAddressID Address Number AD_ADDRNUM
AddressOwnerTableName Application table logical name (address management) CHAR10
AddressOwnerReferenceFieldName Application table address where-used list logical field name CHAR10
AddressOwnerManualFieldName Application table address where-used list logical field name CHAR10
ReferenceAddressID Address Number AD_ADDRNUM
ReferenceObjectID Address owner object ID SWO_TYPEID
EmailAddress SMTP Address AD_SMTPADR
LastChangeDateTime Last Changed On TZNTSTMPL
Master Data Relations Join Conditions
Address time zone
  • Address time zone
  • Client
  • I_ADDRESSTP.ADDRESSTIMEZONE == TTZZ.TZONE
  • I_ADDRESSTP.MANDT == TTZZ.CLIENT
City code for city/street file
  • Country/Region
  • Client
  • City code for city/street file
  • I_ADDRESSTP.COUNTRY == ADRCITY.COUNTRY
  • I_ADDRESSTP.MANDT == ADRCITY.CLIENT
  • I_ADDRESSTP.CITYCODE == ADRCITY.CITY_CODE
Language key I_ADDRESSTP.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Country/Region
  • Client
  • I_ADDRESSTP.COUNTRY == T005.LAND1
  • I_ADDRESSTP.MANDT == T005.MANDT
Address Delivery service type text table
  • ?
  • Type of Delivery Service
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_ADDRESSTP.FORMOFADDRESS == TSAD3.TITLE
  • I_ADDRESSTP.MANDT == TSAD3.CLIENT
Version ID for International Addresses I_ADDRESSTP.NATION == TSADV.NATION
Key of person
  • Person Number
  • ?
  • Client
  • Version ID for International Addresses
  • I_ADDRESSTP.PERSON == ADRP.PERSNUMBER
  • I_ADDRESSTP.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_ADDRESSTP.MANDT == ADRP.CLIENT
  • I_ADDRESSTP.NATION == ADRP.NATION
PO Box of Country/Region
  • Client
  • PO Box of Country/Region
  • I_ADDRESSTP.MANDT == T005.MANDT
  • I_ADDRESSTP.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_ADDRESSTP.MANDT == T005S.MANDT
  • I_ADDRESSTP.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • I_ADDRESSTP.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method I_ADDRESSTP.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Country/Region
  • Client
  • Region (State, Province, County)
  • I_ADDRESSTP.COUNTRY == T005S.LAND1
  • I_ADDRESSTP.MANDT == T005S.MANDT
  • I_ADDRESSTP.REGION == T005S.BLAND
Transportation zone to or from which the goods are delivered
  • Transportation zone to or from which the goods are delivered
  • Country/Region
  • Client
  • I_ADDRESSTP.TRANSPORTZONE == TZONE.ZONE1
  • I_ADDRESSTP.COUNTRY == TZONE.LAND1
  • I_ADDRESSTP.MANDT == TZONE.MANDT