SAP Table ADDR2_DATA
Transfer structure for person with private address
ADDR2_DATA (Transfer structure for person with private address) 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 ADDR2_DATA to other SAP tables.
Source: ADDR2_DATA (Transfer structure for person with private address)
ADDR2_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 | |||||||||
| 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 | |||||||||
| TITLE_P | Form-of-Address Key | AD_TITLE | TSAD3 | CHAR | 4 | 0 | ||||||||
| NAME_FIRST | First name | AD_NAMEFIR | CHAR | 40 | 0 | |||||||||
| NAME_LAST | Last name | AD_NAMELAS | CHAR | 40 | 0 | |||||||||
| NAME2_P | Name of person at birth | AD_NAME2_P | CHAR | 40 | 0 | |||||||||
| NAMEMIDDLE | Middle name or second forename of a person | AD_NAMEMID | CHAR | 40 | 0 | |||||||||
| NAME_LAST2 | Second surname of a person | AD_NAMLAS2 | CHAR | 40 | 0 | |||||||||
| NAME_TEXT | Full Name of Person | AD_NAMTEXT | CHAR | 80 | 0 | |||||||||
| CONVERTED | Status of Field 'Full Name' NAME_TEXT | AD_NAMCONV | CHAR | 1 | 0 |
Possible values
|
||||||||
| TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | 0 | |||||||||
| TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | 0 | |||||||||
| PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | 0 | |||||||||
| PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | 0 | |||||||||
| TITLE_SPPL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | 0 | |||||||||
| NICKNAME | Nickname or name used | AD_NICKNAM | CHAR | 40 | 0 | |||||||||
| INITIALS | "Middle Initial" or personal initials | AD_INITS | CHAR | 10 | 0 | |||||||||
| NAMEFORMAT | Name format | AD_FORMAT | T005N | CHAR | 2 | 0 | ||||||||
| NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | T005 | CHAR | 3 | 0 | ||||||||
| PROFESSION | Profession | AD_PROFESS | CHAR | 40 | 0 | |||||||||
| SEX | Gender key | AD_SEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| LANGU_P | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||
| SORT1_P | Search Term 1 | AD_SORT1UL | CHAR | 20 | 0 | |||||||||
| SORT2_P | Search Term 2 | AD_SORT2UL | CHAR | 20 | 0 | |||||||||
| SORT_PHN_P | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | 0 | |||||||||
| PERSORIGIN | Personal data source (key) | AD_ORIGINP | TSAD6 | CHAR | 4 | 0 | ||||||||
| LANGU_CR_P | Address record creation original language | AD_LANGUCR | T002 | LANG | 1 | 0 | ||||||||
| SO_KEY | SAP-Office key | AD_SO_KEY | CHAR | 10 | 0 | |||||||||
| DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | TSAC | CHAR | 3 | 0 | ||||||||
| ADDR_PERS | (not used) | AD_ADDRPER | ADRC | CHAR | 10 | 0 | ||||||||
| AD_PERS_HD | First pers. address: internal key, if number not yet issued | AD_PERS_HD | CHAR | 140 | 0 | |||||||||
ADDR2_DATA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADDR2_DATA | ADDRORIGIN | ADDR2_DATA | ADDRORIGIN | TSAD6 | Source Address or Personal Data (Business Address Services) | ORIGIN |
| ADDR2_DATA | ADDRORIGIN | * | TSAD6 | Source Address or Personal Data (Business Address Services) | CLIENT | |
| ADDR2_DATA | ADDR_PERS | SY | MANDT | ADRC | Addresses (Business Address Services) | CLIENT |
| ADDR2_DATA | ADDR_PERS | ADDR2_DATA | ADDR_PERS | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| ADDR2_DATA | ADDR_PERS | ADDR2_DATA | DATE_FROM | ADRC | Addresses (Business Address Services) | DATE_FROM |
| ADDR2_DATA | ADDR_PERS | * | ADRC | Addresses (Business Address Services) | NATION | |
| ADDR2_DATA | CITYH_CODE | ADDR2_DATA | CITYH_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADDR2_DATA | CITYH_CODE | ADDR2_DATA | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADDR2_DATA | CITYH_CODE | * | ADRCITY | Postal cities | CLIENT | |
| ADDR2_DATA | CITYP_CODE | * | ADRCITYPRT | Postal districts | CLIENT | |
| ADDR2_DATA | CITYP_CODE | ADDR2_DATA | COUNTRY | ADRCITYPRT | Postal districts | COUNTRY |
| ADDR2_DATA | CITYP_CODE | ADDR2_DATA | CITY_CODE | ADRCITYPRT | Postal districts | CITY_CODE |
| ADDR2_DATA | CITYP_CODE | ADDR2_DATA | CITYP_CODE | ADRCITYPRT | Postal districts | CITYP_CODE |
| ADDR2_DATA | CITY_CODE | ADDR2_DATA | CITY_CODE | ADRCITY | Postal cities | CITY_CODE |
| ADDR2_DATA | CITY_CODE | ADDR2_DATA | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADDR2_DATA | CITY_CODE | * | ADRCITY | Postal cities | CLIENT | |
| ADDR2_DATA | CITY_CODE2 | ADDR2_DATA | CITY_CODE2 | ADRCITY | Postal cities | CITY_CODE |
| ADDR2_DATA | CITY_CODE2 | * | ADRCITY | Postal cities | CLIENT | |
| ADDR2_DATA | CITY_CODE2 | ADDR2_DATA | COUNTRY | ADRCITY | Postal cities | COUNTRY |
| ADDR2_DATA | COUNTRY | * | T005 | Countries | MANDT | |
| ADDR2_DATA | COUNTRY | ADDR2_DATA | COUNTRY | T005 | Countries | LAND1 |
| ADDR2_DATA | COUNTY_CODE | SYST | MANDT | ADRCOUNTY | County codes | CLIENT |
| ADDR2_DATA | COUNTY_CODE | ADDR2_DATA | PO_BOX_CTY | ADRCOUNTY | County codes | COUNTRY |
| ADDR2_DATA | COUNTY_CODE | ADDR2_DATA | PO_BOX_REG | ADRCOUNTY | County codes | REGION |
| ADDR2_DATA | COUNTY_CODE | ADDR2_DATA | COUNTY_CODE | ADRCOUNTY | County codes | COUNTY_CODE |
| ADDR2_DATA | DEFLT_COMM | ADDR2_DATA | DEFLT_COMM | TSAC | Communication Methods (Business Address Services) | COMM_TYPE |
| ADDR2_DATA | DELI_SERV_TYPE | SYST | MANDT | ADDRC_DELI_SERV | Address Service Types | CLIENT |
| ADDR2_DATA | DELI_SERV_TYPE | ADDR2_DATA | DELI_SERV_TYPE | ADDRC_DELI_SERV | Address Service Types | DELI_SERV_TYPE |
| ADDR2_DATA | DONT_USE_P | ADDR2_DATA | DONT_USE_P | TSAD12 | Reasons for Non-Delivery (Business Address Services) | UNDELIVER |
| ADDR2_DATA | DONT_USE_P | SYST | MANDT | TSAD12 | Reasons for Non-Delivery (Business Address Services) | CLIENT |
| ADDR2_DATA | DONT_USE_S | SYST | MANDT | TSAD12 | Reasons for Non-Delivery (Business Address Services) | CLIENT |
| ADDR2_DATA | DONT_USE_S | ADDR2_DATA | DONT_USE_S | TSAD12 | Reasons for Non-Delivery (Business Address Services) | UNDELIVER |
| ADDR2_DATA | LANGU | ADDR2_DATA | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADDR2_DATA | LANGU_CREA | ADDR2_DATA | LANGU_CREA | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADDR2_DATA | LANGU_CR_P | ADDR2_DATA | LANGU_CR_P | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADDR2_DATA | LANGU_P | ADDR2_DATA | LANGU_P | T002 | Language Keys (Component BC-I18) | SPRAS |
| ADDR2_DATA | NAMCOUNTRY | ADDR2_DATA | NAMCOUNTRY | T005 | Countries | LAND1 |
| ADDR2_DATA | NAMCOUNTRY | ADRP | CLIENT | T005 | Countries | MANDT |
| ADDR2_DATA | NAMEFORMAT | ADDR2_DATA | NAMEFORMAT | T005N | Name formats | NAMEFORMAT |
| ADDR2_DATA | NAMEFORMAT | ADRP | CLIENT | T005N | Name formats | MANDT |
| ADDR2_DATA | NAMEFORMAT | ADDR2_DATA | NAMCOUNTRY | T005N | Name formats | LAND1 |
| ADDR2_DATA | PERSORIGIN | * | TSAD6 | Source Address or Personal Data (Business Address Services) | CLIENT | |
| ADDR2_DATA | PERSORIGIN | ADDR2_DATA | PERSORIGIN | TSAD6 | Source Address or Personal Data (Business Address Services) | ORIGIN |
| ADDR2_DATA | PO_BOX_CTY | ADDR2_DATA | PO_BOX_CTY | T005 | Countries | LAND1 |
| ADDR2_DATA | PO_BOX_CTY | * | T005 | Countries | MANDT | |
| ADDR2_DATA | PO_BOX_REG | ADDR2_DATA | PO_BOX_REG | T005S | Taxes: Region (Province) Key | BLAND |
| ADDR2_DATA | PO_BOX_REG | ADDR2_DATA | PO_BOX_CTY | T005S | Taxes: Region (Province) Key | LAND1 |
| ADDR2_DATA | PO_BOX_REG | * | T005S | Taxes: Region (Province) Key | MANDT | |
| ADDR2_DATA | REGIOGROUP | * | ADRREGGRP | Regional structure grouping | CLIENT | |
| ADDR2_DATA | REGIOGROUP | ADDR2_DATA | REGIOGROUP | ADRREGGRP | Regional structure grouping | REGIOGROUP |
| ADDR2_DATA | REGION | ADDR2_DATA | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| ADDR2_DATA | REGION | ADDR2_DATA | REGION | T005S | Taxes: Region (Province) Key | BLAND |
| ADDR2_DATA | REGION | * | T005S | Taxes: Region (Province) Key | MANDT | |
| ADDR2_DATA | STREETABBR | * | ADRSTRTYPE | Street type | CLIENT | |
| ADDR2_DATA | STREETABBR | ADDR2_DATA | COUNTRY | ADRSTRTYPE | Street type | COUNTRY |
| ADDR2_DATA | STREETABBR | ADDR2_DATA | STREETABBR | ADRSTRTYPE | Street type | STRTYPEAB |
| ADDR2_DATA | STREETCODE | ADDR2_DATA | COUNTRY | ADRSTREET | Streets | COUNTRY |
| ADDR2_DATA | STREETCODE | * | ADRSTREET | Streets | CLIENT | |
| ADDR2_DATA | STREETCODE | ADDR2_DATA | STREETCODE | ADRSTREET | Streets | STRT_CODE |
| ADDR2_DATA | TIME_ZONE | ADDR2_DATA | TIME_ZONE | TTZZ | Time zones | TZONE |
| ADDR2_DATA | TIME_ZONE | * | TTZZ | Time zones | CLIENT | |
| ADDR2_DATA | TITLE_P | * | TSAD3 | Forms of Address (Key) (Business Address Services) | CLIENT | |
| ADDR2_DATA | TITLE_P | ADDR2_DATA | TITLE_P | TSAD3 | Forms of Address (Key) (Business Address Services) | TITLE |
| ADDR2_DATA | TOWNSHIP_CODE | ADDR2_DATA | PO_BOX_REG | ADRTOWNSHIP | Township codes | REGION |
| ADDR2_DATA | TOWNSHIP_CODE | SYST | MANDT | ADRTOWNSHIP | Township codes | CLIENT |
| ADDR2_DATA | TOWNSHIP_CODE | ADDR2_DATA | TOWNSHIP_CODE | ADRTOWNSHIP | Township codes | TOWNSHIP_CODE |
| ADDR2_DATA | TOWNSHIP_CODE | ADDR2_DATA | COUNTY_CODE | ADRTOWNSHIP | Township codes | COUNTY_CODE |
| ADDR2_DATA | TOWNSHIP_CODE | ADDR2_DATA | PO_BOX_CTY | ADRTOWNSHIP | Township codes | COUNTRY |
| ADDR2_DATA | TRANSPZONE | * | TZONE | Customers: Regional zones | MANDT | |
| ADDR2_DATA | TRANSPZONE | ADDR2_DATA | COUNTRY | TZONE | Customers: Regional zones | LAND1 |
| ADDR2_DATA | TRANSPZONE | ADDR2_DATA | TRANSPZONE | TZONE | Customers: Regional zones | ZONE1 |
