| 1 | CLIENT | Client | MANDT | T000 | CLNT | 000003 | 000000 | |
| 2 | ADDRNUMBER | Address Number | AD_ADDRNUM | | CHAR | 000010 | 000000 | |
| 3 | DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | | DATS | 000008 | 000000 | |
| 4 | NATION | Version ID for International Addresses | AD_NATION | TSADV | CHAR | 000001 | 000000 | |
| 5 | DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | | DATS | 000008 | 000000 | |
| 6 | TITLE | Form-of-Address Key | AD_TITLE | TSAD3 | CHAR | 000004 | 000000 | |
| 7 | NAME1 | Name 1 | AD_NAME1 | | CHAR | 000040 | 000000 | |
| 8 | NAME2 | Name 2 | AD_NAME2 | | CHAR | 000040 | 000000 | |
| 9 | NAME3 | Name 3 | AD_NAME3 | | CHAR | 000040 | 000000 | |
| 10 | NAME4 | Name 4 | AD_NAME4 | | CHAR | 000040 | 000000 | |
| 11 | NAME_TEXT | Converted name field (with form of address) | AD_NAMETXT | | CHAR | 000050 | 000000 | |
| 12 | NAME_CO | c/o name | AD_NAME_CO | | CHAR | 000040 | 000000 | |
| 13 | CITY1 | City | AD_CITY1 | | CHAR | 000040 | 000000 | |
| 14 | CITY2 | District | AD_CITY2 | | CHAR | 000040 | 000000 | |
| 15 | CITY_CODE | City code for city/street file | AD_CITYNUM | ADRCITY | CHAR | 000012 | 000000 | |
| 16 | CITYP_CODE | District code for City and Street file | AD_CITYPNM | ADRCITYPRT | CHAR | 000008 | 000000 | |
| 17 | HOME_CITY | City (different from postal city) | AD_CITY3 | | CHAR | 000040 | 000000 | |
| 18 | CITYH_CODE | Different city for city/street file | AD_CITYHNM | ADRCITY | CHAR | 000012 | 000000 | |
| 19 | CHCKSTATUS | City file test status | AD_CHECKST | | CHAR | 000001 | 000000 | |
| Possible Values | C | checked against city index | | Not Checked | | D | differs from city index |
| |
|
| 20 | REGIOGROUP | Regional structure grouping | REGIOGROUP | ADRREGGRP | CHAR | 000008 | 000000 | |
| 21 | POST_CODE1 | City postal code | AD_PSTCD1 | | CHAR | 000010 | 000000 | |
| 22 | POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | | CHAR | 000010 | 000000 | |
| 23 | POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | | CHAR | 000010 | 000000 | |
| 24 | PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | | CHAR | 000010 | 000000 | |
| 25 | PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | | CHAR | 000010 | 000000 | |
| 26 | PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | | CHAR | 000010 | 000000 | |
| 27 | PO_BOX | PO Box | AD_POBX | | CHAR | 000010 | 000000 | |
| 28 | DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | TSAD12 | CHAR | 000004 | 000000 | |
| 29 | PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | | CHAR | 000001 | 000000 | |
| | |
|
| 30 | PO_BOX_LOC | PO Box city | AD_POBXLOC | | CHAR | 000040 | 000000 | |
| 31 | CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | ADRCITY | CHAR | 000012 | 000000 | |
| 32 | PO_BOX_REG | Region for PO Box (Country/Region, State, Province, ...) | AD_POBXREG | T005S | CHAR | 000003 | 000000 | |
| 33 | PO_BOX_CTY | PO Box of Country/Region | AD_POBXCTY | T005 | CHAR | 000003 | 000000 | |
| 34 | POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | | CHAR | 000015 | 000000 | |
| 35 | TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 000010 | 000000 | |
| 36 | STREET | Street | AD_STREET | | CHAR | 000060 | 000000 | |
| 37 | DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | TSAD12 | CHAR | 000004 | 000000 | |
| 38 | STREETCODE | Street Number for City/Street File | AD_STRNUM | ADRSTREET | CHAR | 000012 | 000000 | |
| 39 | STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | ADRSTRTYPE | CHAR | 000002 | 000000 | |
| 40 | HOUSE_NUM1 | House Number | AD_HSNM1 | | CHAR | 000010 | 000000 | |
| 41 | HOUSE_NUM2 | House number supplement | AD_HSNM2 | | CHAR | 000010 | 000000 | |
| 42 | HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | | CHAR | 000010 | 000000 | |
| 43 | STR_SUPPL1 | Street 2 | AD_STRSPP1 | | CHAR | 000040 | 000000 | |
| 44 | STR_SUPPL2 | Street 3 | AD_STRSPP2 | | CHAR | 000040 | 000000 | |
| 45 | STR_SUPPL3 | Street 4 | AD_STRSPP3 | | CHAR | 000040 | 000000 | |
| 46 | LOCATION | Street 5 | AD_LCTN | | CHAR | 000040 | 000000 | |
| 47 | BUILDING | Building (Number or Code) | AD_BLDNG | | CHAR | 000020 | 000000 | |
| 48 | FLOOR | Floor in building | AD_FLOOR | | CHAR | 000010 | 000000 | |
| 49 | ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | | CHAR | 000010 | 000000 | |
| 50 | COUNTRY | Country/Region Key | LAND1 | T005 | CHAR | 000003 | 000000 | |
| 51 | LANGU | Language Key | SPRAS | T002 | LANG | 000001 | 000000 | |
| 52 | REGION | Region (State, Province, County) | REGIO | T005S | CHAR | 000003 | 000000 | |
| 53 | ADDR_GROUP | Address Group (Key) (Business Address Services) | AD_GROUP | TSAD7 | CHAR | 000004 | 000000 | |
| 54 | FLAGGROUPS | Flag: There are more address group assignments | AD_FLGGP | | CHAR | 000001 | 000000 | |
| | |
|
| 55 | PERS_ADDR | Flag: This is a personal address | AD_PRSADDR | | CHAR | 000001 | 000000 | |
| | |
|
| 56 | SORT1 | Search Term 1 | AD_SORT1 | | CHAR | 000020 | 000000 | |
| 57 | SORT2 | Search Term 2 | AD_SORT2 | | CHAR | 000020 | 000000 | |
| 58 | SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | | CHAR | 000020 | 000000 | |
| 59 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | TSAC | CHAR | 000003 | 000000 | |
| 60 | TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | | CHAR | 000030 | 000000 | |
| 61 | TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | | CHAR | 000010 | 000000 | |
| 62 | FAX_NUMBER | First Fax No.: Area Code + Number | AD_FXNMBR1 | | CHAR | 000030 | 000000 | |
| 63 | FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | | CHAR | 000010 | 000000 | |
| 64 | FLAGCOMM2 | Flag: Telephone number(s) defined | AD_FLGCM02 | | CHAR | 000001 | 000000 | |
| | |
|
| 65 | FLAGCOMM3 | Flag: Fax number(s) defined | AD_FLGCM03 | | CHAR | 000001 | 000000 | |
| | |
|
| 66 | FLAGCOMM4 | Flag: Teletex number(s) defined | AD_FLGCM04 | | CHAR | 000001 | 000000 | |
| | |
|
| 67 | FLAGCOMM5 | Flag: Telex number(s) defined | AD_FLGCM05 | | CHAR | 000001 | 000000 | |
| | |
|
| 68 | FLAGCOMM6 | Flag: E-mail address(es) defined | AD_FLGCM06 | | CHAR | 000001 | 000000 | |
| | |
|
| 69 | FLAGCOMM7 | Flag: RML (remote mail) addresse(s) defined | AD_FLGCM07 | | CHAR | 000001 | 000000 | |
| | |
|
| 70 | FLAGCOMM8 | Flag: X.400 addresse(s) defined | AD_FLGCM08 | | CHAR | 000001 | 000000 | |
| | |
|
| 71 | FLAGCOMM9 | Flag: RFC destination(s) defined | AD_FLGCM09 | | CHAR | 000001 | 000000 | |
| | |
|
| 72 | FLAGCOMM10 | Flag: Printer defined | AD_FLGCM10 | | CHAR | 000001 | 000000 | |
| | |
|
| 73 | FLAGCOMM11 | Flag: SSF defined | AD_FLGCM11 | | CHAR | 000001 | 000000 | |
| | |
|
| 74 | FLAGCOMM12 | Flag: URI/FTP address defined | AD_FLGCM12 | | CHAR | 000001 | 000000 | |
| | |
|
| 75 | FLAGCOMM13 | Flag: Pager address defined | AD_FLGCM13 | | CHAR | 000001 | 000000 | |
| | |
|
| 76 | ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | TSAD6 | CHAR | 000004 | 000000 | |
| 77 | MC_NAME1 | Name (Field NAME1) in Uppercase for Search Help | AD_MC_NAME | | CHAR | 000025 | 000000 | |
| 78 | MC_CITY1 | City name in Uppercase for Search Help | AD_MC_CITY | | CHAR | 000025 | 000000 | |
| 79 | MC_STREET | Street Name in Uppercase for Search Help | AD_MC_STRT | | CHAR | 000025 | 000000 | |
| 80 | EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | | CHAR | 000040 | 000000 | |
| 81 | EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | | CHAR | 000040 | 000000 | |
| 82 | TIME_ZONE | Address time zone | AD_TZONE | TTZZ | CHAR | 000006 | 000000 | |
| 83 | TAXJURCODE | Tax Jurisdiction | AD_TXJCD | | CHAR | 000015 | 000000 | |
| 84 | ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | | CHAR | 000010 | 000000 | |
| 85 | LANGU_CREA | Address record creation original language | AD_LANGUCR | | LANG | 000001 | 000000 | |
| 86 | ADRC_UUID | UUID Used in the Address | AD_UUID | | RAW | 000016 | 000000 | |
| 87 | UUID_BELATED | Indicator: UUID created later | AD_UUID_BELATED | | CHAR | 000001 | 000000 | |
| Possible Values | X | UUID was created later | | UUID was created when the address was created |
| |
|
| 88 | ID_CATEGORY | Category of an Address ID | AD_ID_CATEGORY | | CHAR | 000001 | 000000 | |
| Possible Values | Normal AddressID | | I | Internal AddressID of Instance Sharing Address |
| |
|
| 89 | ADRC_ERR_STATUS | Error Status of Address | AD_ERR_STATUS | | CHAR | 000001 | 000000 | |
| Possible Values | Address is consistent | | W | Address contains data that produces warnings | | E | Address contains data with errors |
| |
|
| 90 | PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | | CHAR | 000040 | 000000 | |
| 91 | DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | ADDRC_DELI_SERV | CHAR | 000004 | 000000 | |
| 92 | DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | | CHAR | 000010 | 000000 | |
| 93 | COUNTY_CODE | County code for county | AD_CNTYNUM | | CHAR | 000008 | 000000 | |
| 94 | COUNTY | County | AD_COUNTY | | CHAR | 000040 | 000000 | |
| 95 | TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | | CHAR | 000008 | 000000 | |
| 96 | TOWNSHIP | Township | AD_TOWNSHIP | | CHAR | 000040 | 000000 | |
| 97 | MC_COUNTY | County name in upper case for search help | AD_MC_COUNTY | | CHAR | 000025 | 000000 | |
| 98 | MC_TOWNSHIP | Township name in upper case for search help | AD_MC_TWSHP | | CHAR | 000025 | 000000 | |
| 99 | XPCPT | Business Purpose Completed Flag | AD_XPCPT | | CHAR | 000001 | 000000 | |
| | |
|
| 100 | _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | | DATS | 000008 | 000000 | |
| 101 | DUNS | Dun & Bradstreet number (DUNS) | /SAPHT/RN_DUNS | | CHAR | 000009 | 000000 | |
| 102 | DUNSP4 | DUNS+4 number (the last four digit) | /SAPHT/RN_DUNSP4 | | CHAR | 000004 | 000000 | |