SAP Table ADDR1_DATA
Address transfer structure
ADDR1_DATA (Address transfer structure) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ADDR1_DATA to other SAP tables.
ADDR1_DATA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | 0 | |||||||||
| DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | 0 | |||||||||
| TITLE | Form-of-Address Key | AD_TITLE | TSAD3 | CHAR | 4 | 0 | ||||||||
| NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | 0 | |||||||||
| NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | 0 | |||||||||
| NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | 0 | |||||||||
| NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | 0 | |||||||||
| NAME_TXT | Converted name field (with form of address) | AD_NAMETXT | CHAR | 50 | 0 | |||||||||
| NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | 0 | |||||||||
| CITY1 | City | AD_CITY1 | CHAR | 40 | 0 | |||||||||
| CITY2 | District | AD_CITY2 | CHAR | 40 | 0 | |||||||||
| CITY_CODE | City code for city/street file | AD_CITYNUM | ADRCITY | CHAR | 12 | 0 | ||||||||
| CITYP_CODE | District code for City and Street file | AD_CITYPNM | ADRCITYPRT | CHAR | 8 | 0 | ||||||||
| HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | 0 | |||||||||
| CITYH_CODE | Different city for city/street file | AD_CITYHNM | ADRCITY | CHAR | 12 | 0 | ||||||||
| CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | 0 |
Possible values
|
||||||||
| REGIOGROUP | Regional structure grouping | REGIOGROUP | ADRREGGRP | CHAR | 8 | 0 | ||||||||
| POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||||||||
| POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | 0 | |||||||||
| POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | 0 | |||||||||
| PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | 0 | |||||||||
| PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | 0 | |||||||||
| PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | 0 | |||||||||
| PO_BOX | PO Box | AD_POBX | CHAR | 10 | 0 | |||||||||
| DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | TSAD12 | CHAR | 4 | 0 | ||||||||
| PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | 0 |
Possible values
|
||||||||
| PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | 0 | |||||||||
| CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | ADRCITY | CHAR | 12 | 0 | ||||||||
| PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | T005S | CHAR | 3 | 0 | ||||||||
| PO_BOX_CTY | PO box country | AD_POBXCTY | T005 | CHAR | 3 | 0 | ||||||||
| POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | 0 | |||||||||
| TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 | 0 | ||||||||
| STREET | Street | AD_STREET | CHAR | 60 | 0 | |||||||||
| DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | TSAD12 | CHAR | 4 | 0 | ||||||||
| STREETCODE | Street Number for City/Street File | AD_STRNUM | ADRSTREET | CHAR | 12 | 0 | ||||||||
| STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | ADRSTRTYPE | CHAR | 2 | 0 | ||||||||
| HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | 0 | |||||||||
| HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | 0 | |||||||||
| HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | 0 | |||||||||
| STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | 0 | |||||||||
| STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | 0 | |||||||||
| STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | 0 | |||||||||
| LOCATION | Street 5 | AD_LCTN | CHAR | 40 | 0 | |||||||||
| BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | 0 | |||||||||
| FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | 0 | |||||||||
| ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | 0 | |||||||||
| COUNTRY | Country Key | LAND1 | T005 | CHAR | 3 | 0 | ||||||||
| LANGU | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||
| REGION | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||||||||
| SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | 0 | |||||||||
| SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | 0 | |||||||||
| SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | 0 | |||||||||
| ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | TSAD6 | CHAR | 4 | 0 | ||||||||
| EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | 0 | |||||||||
| EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | 0 | |||||||||
| TIME_ZONE | Address time zone | AD_TZONE | TTZZ | CHAR | 6 | 0 | ||||||||
| TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | 0 | |||||||||
| ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | 0 | |||||||||
| REMARK | Address notes | AD_REMARK1 | CHAR | 50 | 0 | |||||||||
| LANGU_CREA | Address record creation original language | AD_LANGUCR | T002 | LANG | 1 | 0 | ||||||||
| PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | 0 | |||||||||
| DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | ADDRC_DELI_SERV | CHAR | 4 | 0 | ||||||||
| DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | 0 | |||||||||
| COUNTY_CODE | County code for county | AD_CNTYNUM | ADRCOUNTY | CHAR | 8 | 0 | ||||||||
| COUNTY | County | AD_COUNTY | CHAR | 40 | 0 | |||||||||
| TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | ADRTOWNSHIP | CHAR | 8 | 0 | ||||||||
| TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | 0 | |||||||||
| DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | TSAC | CHAR | 3 | 0 | ||||||||
ADDR1_DATA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADDR1_DATA | ADDRORIGIN | * | TSAD6 | Source Address or Personal Data (Business Address Services) | CLIENT | |
| ADDR1_DATA | ADDRORIGIN | ADDR1_DATA | ADDRORIGIN | TSAD6 | Source Address or Personal Data (Business Address Services) | ORIGIN |
| ADDR1_DATA | CITYH_CODE | * | ADRCITY | Postal cities | CLIENT | |
| ADDR1_DATA | CITYH_CODE | ADDR1_DATA | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADDR1_DATA | CITYH_CODE | ADDR1_DATA | CITYH_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADDR1_DATA | CITYP_CODE | * | ADRCITYPRT | Postal districts | CLIENT | |
| ADDR1_DATA | CITYP_CODE | ADDR1_DATA | COUNTRY | ADRCITYPRT | Postal districts | COUNTRY |
| ADDR1_DATA | CITYP_CODE | ADDR1_DATA | CITY_CODE | ADRCITYPRT | Postal districts | CITY_CODE |
| ADDR1_DATA | CITYP_CODE | ADDR1_DATA | CITYP_CODE | ADRCITYPRT | Postal districts | CITYP_CODE |
| ADDR1_DATA | CITY_CODE | ADDR1_DATA | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADDR1_DATA | CITY_CODE | ADDR1_DATA | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADDR1_DATA | CITY_CODE | * | ADRCITY | Postal cities | CLIENT | |
| ADDR1_DATA | CITY_CODE2 | * | ADRCITY | Postal cities | CLIENT | |
| ADDR1_DATA | CITY_CODE2 | ADDR1_DATA | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADDR1_DATA | CITY_CODE2 | ADDR1_DATA | CITY_CODE2 | ADRCITY | Postal cities | CITY_CODE |
| ADDR1_DATA | COUNTRY | * | T005 | Countries | MANDT | |
| ADDR1_DATA | COUNTRY | ADDR1_DATA | COUNTRY | T005 | Countries | LAND1 |
| ADDR1_DATA | COUNTY_CODE | ADDR1_DATA | PO_BOX_CTY | ADRCOUNTY | County codes | COUNTRY |
| ADDR1_DATA | COUNTY_CODE | ADDR1_DATA | PO_BOX_REG | ADRCOUNTY | County codes | REGION |
| ADDR1_DATA | COUNTY_CODE | ADDR1_DATA | COUNTY_CODE | ADRCOUNTY | County codes | COUNTY_CODE |
| ADDR1_DATA | COUNTY_CODE | SYST | MANDT | ADRCOUNTY | County codes | CLIENT |
| ADDR1_DATA | DEFLT_COMM | ADDR1_DATA | DEFLT_COMM | TSAC | Communication Methods (Business Address Services) | COMM_TYPE |
| ADDR1_DATA | DELI_SERV_TYPE | SYST | MANDT | ADDRC_DELI_SERV | Address Service Types | CLIENT |
| ADDR1_DATA | DELI_SERV_TYPE | ADDR1_DATA | DELI_SERV_TYPE | ADDRC_DELI_SERV | Address Service Types | DELI_SERV_TYPE |
| ADDR1_DATA | DONT_USE_P | SYST | MANDT | TSAD12 | Reasons for Non-Delivery (Business Address Services) | CLIENT |
| ADDR1_DATA | DONT_USE_P | ADDR1_DATA | DONT_USE_P | TSAD12 | Reasons for Non-Delivery (Business Address Services) | UNDELIVER |
| ADDR1_DATA | DONT_USE_S | ADDR1_DATA | DONT_USE_S | TSAD12 | Reasons for Non-Delivery (Business Address Services) | UNDELIVER |
| ADDR1_DATA | DONT_USE_S | SYST | MANDT | TSAD12 | Reasons for Non-Delivery (Business Address Services) | CLIENT |
| ADDR1_DATA | LANGU | ADDR1_DATA | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADDR1_DATA | LANGU_CREA | ADDR1_DATA | LANGU_CREA | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADDR1_DATA | PO_BOX_CTY | * | T005 | Countries | MANDT | |
| ADDR1_DATA | PO_BOX_CTY | ADDR1_DATA | PO_BOX_CTY | T005 | Countries | LAND1 |
| ADDR1_DATA | PO_BOX_REG | * | T005S | Taxes: Region (Province) Key | MANDT | |
| ADDR1_DATA | PO_BOX_REG | ADDR1_DATA | PO_BOX_CTY | T005S | Taxes: Region (Province) Key | LAND1 |
| ADDR1_DATA | PO_BOX_REG | ADDR1_DATA | PO_BOX_REG | T005S | Taxes: Region (Province) Key | BLAND |
| ADDR1_DATA | REGIOGROUP | * | ADRREGGRP | Regional structure grouping | CLIENT | |
| ADDR1_DATA | REGIOGROUP | ADDR1_DATA | REGIOGROUP | ADRREGGRP | Regional structure grouping | REGIOGROUP |
| ADDR1_DATA | REGION | ADDR1_DATA | REGION | T005S | Taxes: Region (Province) Key | BLAND |
| ADDR1_DATA | REGION | * | T005S | Taxes: Region (Province) Key | MANDT | |
| ADDR1_DATA | REGION | ADDR1_DATA | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| ADDR1_DATA | STREETABBR | * | ADRSTRTYPE | Street type | CLIENT | |
| ADDR1_DATA | STREETABBR | ADDR1_DATA | COUNTRY | ADRSTRTYPE | Street type | COUNTRY |
| ADDR1_DATA | STREETABBR | ADDR1_DATA | STREETABBR | ADRSTRTYPE | Street type | STRTYPEAB |
| ADDR1_DATA | STREETCODE | ADDR1_DATA | COUNTRY | ADRSTREET | Streets | COUNTRY |
| ADDR1_DATA | STREETCODE | ADDR1_DATA | STREETCODE | ADRSTREET | Streets | STRT_CODE |
| ADDR1_DATA | STREETCODE | * | ADRSTREET | Streets | CLIENT | |
| ADDR1_DATA | TIME_ZONE | ADDR1_DATA | TIME_ZONE | TTZZ | Time zones | TZONE |
| ADDR1_DATA | TIME_ZONE | * | TTZZ | Time zones | CLIENT | |
| ADDR1_DATA | TITLE | * | TSAD3 | Forms of Address (Key) (Business Address Services) | CLIENT | |
| ADDR1_DATA | TITLE | ADDR1_DATA | TITLE | TSAD3 | Forms of Address (Key) (Business Address Services) | TITLE |
| ADDR1_DATA | TOWNSHIP_CODE | SYST | MANDT | ADRTOWNSHIP | Township codes | CLIENT |
| ADDR1_DATA | TOWNSHIP_CODE | ADDR1_DATA | PO_BOX_CTY | ADRTOWNSHIP | Township codes | COUNTRY |
| ADDR1_DATA | TOWNSHIP_CODE | ADDR1_DATA | PO_BOX_REG | ADRTOWNSHIP | Township codes | REGION |
| ADDR1_DATA | TOWNSHIP_CODE | ADDR1_DATA | COUNTY_CODE | ADRTOWNSHIP | Township codes | COUNTY_CODE |
| ADDR1_DATA | TOWNSHIP_CODE | ADDR1_DATA | TOWNSHIP_CODE | ADRTOWNSHIP | Township codes | TOWNSHIP_CODE |
| ADDR1_DATA | TRANSPZONE | * | TZONE | Customers: Regional zones | MANDT | |
| ADDR1_DATA | TRANSPZONE | ADDR1_DATA | COUNTRY | TZONE | Customers: Regional zones | LAND1 |
| ADDR1_DATA | TRANSPZONE | ADDR1_DATA | TRANSPZONE | TZONE | Customers: Regional zones | ZONE1 |
