C_AddressTP

Address Reusable Component | view: CADDRRTP | Extraction: Not supported | Component: Basic Functions

Tables used: ADCP, ADRC, ADR6

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (3)
Other (30)
🔗 Relations (10)

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
AddressIsChangedManually	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
TaxJurisdiction	Tax Jurisdiction	AD_TXJCD
PhoneNumber	Phone Number: Area Code+Number	CHAR30
FaxNumber	First Fax No.: Area Code + Number	CHAR30
EmailAddress	SMTP Address	AD_SMTPADR
ReferenceAddressID	Address Number	AD_ADDRNUM
ReferenceObjectID	Address owner object ID	SWO_TYPEID

Master Data Relations	Join Conditions
City code for city/street file City code for city/street file Client Country/Region	`C_ADDRESSTP.CITYCODE == ADRCITY.CITY_CODE` `C_ADDRESSTP.MANDT == ADRCITY.CLIENT` `C_ADDRESSTP.COUNTRY == ADRCITY.COUNTRY`
Language key	`C_ADDRESSTP.CORRESPONDENCELANGUAGE == T002.SPRAS`
Country key Client Country/Region	`C_ADDRESSTP.MANDT == T005.MANDT` `C_ADDRESSTP.COUNTRY == T005.LAND1`
Address Delivery service type text table Type of Delivery Service ?	`C_ADDRESSTP.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE` `C_ADDRESSTP.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT`
Form-of-Address Key Client Form-of-Address Key	`C_ADDRESSTP.MANDT == TSAD3.CLIENT` `C_ADDRESSTP.FORMOFADDRESS == TSAD3.TITLE`
PO Box of Country/Region Client PO Box of Country/Region	`C_ADDRESSTP.MANDT == T005.MANDT` `C_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, ...)	`C_ADDRESSTP.MANDT == T005S.MANDT` `C_ADDRESSTP.POBOXDEVIATINGCOUNTRY == T005S.LAND1` `C_ADDRESSTP.POBOXDEVIATINGREGION == T005S.BLAND`
Communication Method	`C_ADDRESSTP.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE`
Region code Client Region (State, Province, County) Country/Region	`C_ADDRESSTP.MANDT == T005S.MANDT` `C_ADDRESSTP.REGION == T005S.BLAND` `C_ADDRESSTP.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	`C_ADDRESSTP.TRANSPORTZONE == TZONE.ZONE1` `C_ADDRESSTP.MANDT == TZONE.MANDT` `C_ADDRESSTP.COUNTRY == TZONE.LAND1`