| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | GUID_22 | Allow NULL? |
| 3 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 4 | NAME_CO | c/o name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_NAME_CO | Allow NULL? |
| 5 | CITY1 | City | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY1 | Allow NULL? |
| 6 | CITY2 | District | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY2 | Allow NULL? |
| 7 | CITY_CODE | City code for city/street file | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRCITY | AD_CITYNUM | Allow NULL? |
| 8 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRCITYPRT | AD_CITYPNM | Allow NULL? |
| 9 | HOME_CITY | City (different from postal city) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_CITY3 | Allow NULL? |
| 10 | CITYH_CODE | Different city for city/street file | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRCITY | AD_CITYHNM | Allow NULL? |
| 11 | CHCKSTATUS | City file test status | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_CHECKST | Allow NULL? |
| 12 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRREGGRP | REGIOGROUP | Allow NULL? |
| 13 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 14 | POST_CODE2 | PO Box Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD2 | Allow NULL? |
| 15 | POST_CODE3 | Company Postal Code (for Large Customers) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD3 | Allow NULL? |
| 16 | PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST1XT | Allow NULL? |
| 17 | PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST2XT | Allow NULL? |
| 18 | PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PST3XT | Allow NULL? |
| 19 | PO_BOX | PO Box | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_POBX | Allow NULL? |
| 20 | DONT_USE_P | PO Box Address Undeliverable Flag | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAD12 | AD_NO_USEP | Allow NULL? |
| 21 | PO_BOX_NUM | Flag: PO Box Without Number | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_POBXNUM | Allow NULL? |
| 22 | PO_BOX_LOC | PO Box city | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_POBXLOC | Allow NULL? |
| 23 | CITY_CODE2 | City PO box code (City file) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRCITY | AD_CIT2NUM | Allow NULL? |
| 24 | PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | AD_POBXREG | Allow NULL? |
| 25 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | AD_POBXCTY | Allow NULL? |
| 26 | POSTALAREA | (Not Supported) Post Delivery District | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | AD_PSTLAR | Allow NULL? |
| 27 | TRANSPZONE | Transportation zone to or from which the goods are delivered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TZONE | LZONE | Allow NULL? |
| 28 | STREET | Street | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AD_STREET | Allow NULL? |
| 29 | DONT_USE_S | Street Address Undeliverable Flag | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAD12 | AD_NO_USES | Allow NULL? |
| 30 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | ADRSTREET | AD_STRNUM | Allow NULL? |
| 31 | STREETABBR | (Not Supported) Abbreviation of Street Name | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | ADRSTRTYPE | AD_STRABBR | Allow NULL? |
| 32 | HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM1 | Allow NULL? |
| 33 | HOUSE_NUM2 | House number supplement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM2 | Allow NULL? |
| 34 | HOUSE_NUM3 | (Not supported) House Number Range | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_HSNM3 | Allow NULL? |
| 35 | STR_SUPPL1 | Street 2 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP1 | Allow NULL? |
| 36 | STR_SUPPL2 | Street 3 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP2 | Allow NULL? |
| 37 | STR_SUPPL3 | Street 4 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_STRSPP3 | Allow NULL? |
| 38 | LOCATION | Street 5 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_LCTN | Allow NULL? |
| 39 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_BLDNG | Allow NULL? |
| 40 | FLOOR | Floor in building | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_FLOOR | Allow NULL? |
| 41 | ROOMNUMBER | Room or Appartment Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_ROOMNUM | Allow NULL? |
| 42 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 43 | LANGU | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SPRAS | Allow NULL? |
| 44 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 45 | SORT1 | Search Term 1 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_SORT1UL | Allow NULL? |
| 46 | SORT2 | Search Term 2 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_SORT2UL | Allow NULL? |
| 47 | SORT_PHN | (Not Supported) Phonetic Search Sort Field | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AD_SRTPHN | Allow NULL? |
| 48 | ADDRORIGIN | (Not Supported) Address Data Source (Key) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAD6 | AD_ORIGINA | Allow NULL? |
| 49 | EXTENSION1 | Extension (only for data conversion) (e.g. data line) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_EXTENS1 | Allow NULL? |
| 50 | EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_EXTENS2 | Allow NULL? |
| 51 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TTZZ | AD_TZONE | Allow NULL? |
| 52 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | AD_TXJCD | Allow NULL? |
| 53 | ADDRESS_ID | (Not supported) Physical address ID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_ADDR_ID | Allow NULL? |
| 54 | REMARK | Address notes | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | AD_REMARK1 | Allow NULL? |
| 55 | LANGU_CREA | Address record creation original language | char | 1 | 0 | LANG | (N' ') | Yes | T002 | AD_LANGUCR | Allow NULL? |
| 56 | PO_BOX_LOBBY | PO Box Lobby | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_PO_BOX_LBY | Allow NULL? |
| 57 | DELI_SERV_TYPE | Type of Delivery Service | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | ADDRC_DELI_SERV | AD_DELIVERY_SERVICE_TYPE | Allow NULL? |
| 58 | DELI_SERV_NUMBER | Number of Delivery Service | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_DELIVERY_SERVICE_NUMBER | Allow NULL? |
| 59 | COUNTY_CODE | County code for county | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRCOUNTY | AD_CNTYNUM | Allow NULL? |
| 60 | COUNTY | County | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_COUNTY | Allow NULL? |
| 61 | TOWNSHIP_CODE | Township code for Township | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ADRTOWNSHIP | AD_TWSHPNUM | Allow NULL? |
| 62 | TOWNSHIP | Township | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_TOWNSHIP | Allow NULL? |
