| CLIENT |
✔ |
Client |
MANDT |
CLNT |
3 |
T000 |
| ADDRNUMBER |
✔ |
Address number |
AD_ADDRNUM |
CHAR |
10 |
|
| DATE_FROM |
✔ |
Valid-from date - in current Release only 00010101 possible |
AD_DATE_FR |
DATS |
8 |
|
| NATION |
✔ |
Version ID for International Addresses |
AD_NATION |
CHAR |
1 |
TSADV |
| DATE_TO |
|
Valid-to date in current Release only 99991231 possible |
AD_DATE_TO |
DATS |
8 |
|
| TITLE |
|
Form-of-Address Key |
AD_TITLE |
CHAR |
4 |
TSAD3 |
| NAME1 |
|
Name 1 |
AD_NAME1 |
CHAR |
40 |
|
| NAME2 |
|
Name 2 |
AD_NAME2 |
CHAR |
40 |
|
| NAME3 |
|
Name 3 |
AD_NAME3 |
CHAR |
40 |
|
| NAME4 |
|
Name 4 |
AD_NAME4 |
CHAR |
40 |
|
| NAME_TEXT |
|
Converted name field (with form of address) |
AD_NAMETXT |
CHAR |
50 |
|
| NAME_CO |
|
c/o name |
AD_NAME_CO |
CHAR |
40 |
|
| CITY1 |
|
City |
AD_CITY1 |
CHAR |
40 |
|
| CITY2 |
|
District |
AD_CITY2 |
CHAR |
40 |
|
| CITY_CODE |
|
City code for city/street file |
AD_CITYNUM |
CHAR |
12 |
ADRCITY |
| CITYP_CODE |
|
District code for City and Street file |
AD_CITYPNM |
CHAR |
8 |
ADRCITYPRT |
| HOME_CITY |
|
City (different from postal city) |
AD_CITY3 |
CHAR |
40 |
|
| CITYH_CODE |
|
Different city for city/street file |
AD_CITYHNM |
CHAR |
12 |
ADRCITY |
| CHCKSTATUS |
|
City file test status |
AD_CHECKST |
CHAR |
1 |
|
| REGIOGROUP |
|
Regional structure grouping |
REGIOGROUP |
CHAR |
8 |
ADRREGGRP |
| POST_CODE1 |
|
City postal code |
AD_PSTCD1 |
CHAR |
10 |
|
| POST_CODE2 |
|
PO Box Postal Code |
AD_PSTCD2 |
CHAR |
10 |
|
| POST_CODE3 |
|
Company Postal Code (for Large Customers) |
AD_PSTCD3 |
CHAR |
10 |
|
| PCODE1_EXT |
|
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code |
AD_PST1XT |
CHAR |
10 |
|
| PCODE2_EXT |
|
(Not Supported) PO Box Postal Code Extension |
AD_PST2XT |
CHAR |
10 |
|
| PCODE3_EXT |
|
(Not Supported) Major Customer Postal Code Extension |
AD_PST3XT |
CHAR |
10 |
|
| PO_BOX |
|
PO Box |
AD_POBX |
CHAR |
10 |
|
| DONT_USE_P |
|
PO Box Address Undeliverable Flag |
AD_NO_USEP |
CHAR |
4 |
TSAD12 |
| PO_BOX_NUM |
|
Flag: PO Box Without Number |
AD_POBXNUM |
CHAR |
1 |
|
| PO_BOX_LOC |
|
PO Box city |
AD_POBXLOC |
CHAR |
40 |
|
| CITY_CODE2 |
|
City PO box code (City file) |
AD_CIT2NUM |
CHAR |
12 |
ADRCITY |
| PO_BOX_REG |
|
Region for PO Box (Country, State, Province, ...) |
AD_POBXREG |
CHAR |
3 |
T005S |
| PO_BOX_CTY |
|
PO box country |
AD_POBXCTY |
CHAR |
3 |
T005 |
| POSTALAREA |
|
(Not Supported) Post Delivery District |
AD_PSTLAR |
CHAR |
15 |
|
| TRANSPZONE |
|
Transportation zone to or from which the goods are delivered |
LZONE |
CHAR |
10 |
TZONE |
| STREET |
|
Street |
AD_STREET |
CHAR |
60 |
|
| DONT_USE_S |
|
Street Address Undeliverable Flag |
AD_NO_USES |
CHAR |
4 |
TSAD12 |
| STREETCODE |
|
Street Number for City/Street File |
AD_STRNUM |
CHAR |
12 |
ADRSTREET |
| STREETABBR |
|
(Not Supported) Abbreviation of Street Name |
AD_STRABBR |
CHAR |
2 |
ADRSTRTYPE |
| HOUSE_NUM1 |
|
House Number |
AD_HSNM1 |
CHAR |
10 |
|
| HOUSE_NUM2 |
|
House number supplement |
AD_HSNM2 |
CHAR |
10 |
|
| HOUSE_NUM3 |
|
(Not supported) House Number Range |
AD_HSNM3 |
CHAR |
10 |
|
| STR_SUPPL1 |
|
Street 2 |
AD_STRSPP1 |
CHAR |
40 |
|
| STR_SUPPL2 |
|
Street 3 |
AD_STRSPP2 |
CHAR |
40 |
|
| STR_SUPPL3 |
|
Street 4 |
AD_STRSPP3 |
CHAR |
40 |
|
| LOCATION |
|
Street 5 |
AD_LCTN |
CHAR |
40 |
|
| BUILDING |
|
Building (Number or Code) |
AD_BLDNG |
CHAR |
20 |
|
| FLOOR |
|
Floor in building |
AD_FLOOR |
CHAR |
10 |
|
| ROOMNUMBER |
|
Room or Appartment Number |
AD_ROOMNUM |
CHAR |
10 |
|
| COUNTRY |
|
Country Key |
LAND1 |
CHAR |
3 |
T005 |
| LANGU |
|
Language Key |
SPRAS |
LANG |
1 |
T002 |
| ADDR_GROUP |
|
Address Group (Key) (Business Address Services) |
AD_GROUP |
CHAR |
4 |
TSAD7 |
| FLAGGROUPS |
|
Flag: There are more address group assignments |
AD_FLGGP |
CHAR |
1 |
|
| PERS_ADDR |
|
Flag: This is a personal address |
AD_PRSADDR |
CHAR |
1 |
|
| SORT1 |
|
Search Term 1 |
AD_SORT1 |
CHAR |
20 |
|
| SORT2 |
|
Search Term 2 |
AD_SORT2 |
CHAR |
20 |
|
| SORT_PHN |
|
(Not Supported) Phonetic Search Sort Field |
AD_SRTPHN |
CHAR |
20 |
|
| DEFLT_COMM |
|
Communication Method (Key) (Business Address Services) |
AD_COMM |
CHAR |
3 |
TSAC |
| TEL_EXTENS |
|
First Telephone No.: Extension |
AD_TLXTNS1 |
CHAR |
10 |
|
| FAX_NUMBER |
|
First fax no.: dialling code+number |
AD_FXNMBR1 |
CHAR |
30 |
|
| FAX_EXTENS |
|
First fax no.: extension |
AD_FXXTNS1 |
CHAR |
10 |
|
| FLAGCOMM2 |
|
Flag: Telephone number(s) maintained |
AD_FLGCM02 |
CHAR |
1 |
|
| FLAGCOMM3 |
|
Flag: Fax number(s) maintained |
AD_FLGCM03 |
CHAR |
1 |
|
| FLAGCOMM4 |
|
Flag: Teletex number(s) maintained |
AD_FLGCM04 |
CHAR |
1 |
|
| FLAGCOMM5 |
|
Flag: Telex number(s) maintained |
AD_FLGCM05 |
CHAR |
1 |
|
| FLAGCOMM6 |
|
Indicator: E-Mail Address(es) Maintained |
AD_FLGCM06 |
CHAR |
1 |
|
| FLAGCOMM7 |
|
Flag: RML (remote mail) addresse(s) maintained |
AD_FLGCM07 |
CHAR |
1 |
|
| FLAGCOMM8 |
|
Flag: X.400 addresse(s) maintained |
AD_FLGCM08 |
CHAR |
1 |
|
| FLAGCOMM9 |
|
Flag: RFC destination(s) maintained |
AD_FLGCM09 |
CHAR |
1 |
|
| FLAGCOMM10 |
|
Flag: Printer maintained |
AD_FLGCM10 |
CHAR |
1 |
|
| FLAGCOMM11 |
|
Flag: SSF maintained |
AD_FLGCM11 |
CHAR |
1 |
|
| FLAGCOMM12 |
|
Flag: URI/FTP address maintained |
AD_FLGCM12 |
CHAR |
1 |
|
| FLAGCOMM13 |
|
Flag: Pager address maintained |
AD_FLGCM13 |
CHAR |
1 |
|
| ADDRORIGIN |
|
(Not Supported) Address Data Source (Key) |
AD_ORIGINA |
CHAR |
4 |
TSAD6 |
| MC_NAME1 |
|
Name (field NAME1) in upper case for matchcode |
AD_MC_NAME |
CHAR |
25 |
|
| MC_CITY1 |
|
City name in upper case for search help |
AD_MC_CITY |
CHAR |
25 |
|
| MC_STREET |
|
Street name in upper case for search help |
AD_MC_STRT |
CHAR |
25 |
|
| EXTENSION1 |
|
Extension (only for data conversion) (e.g. data line) |
AD_EXTENS1 |
CHAR |
40 |
|
| EXTENSION2 |
|
Extension (only for data conversion) (e.g. telebox) |
AD_EXTENS2 |
CHAR |
40 |
|
| TIME_ZONE |
|
Address time zone |
AD_TZONE |
CHAR |
6 |
TTZZ |
| TAXJURCODE |
|
Tax Jurisdiction |
AD_TXJCD |
CHAR |
15 |
|
| ADDRESS_ID |
|
(Not supported) Physical address ID |
AD_ADDR_ID |
CHAR |
10 |
|
| LANGU_CREA |
|
Address record creation original language |
AD_LANGUCR |
LANG |
1 |
* |
| ADRC_UUID |
|
UUID Used in the Address |
AD_UUID |
RAW |
16 |
|
| UUID_BELATED |
|
Indicator: UUID was generated later |
AD_UUID_BELATED |
CHAR |
1 |
|
| ID_CATEGORY |
|
Category of an Address ID |
AD_ID_CATEGORY |
CHAR |
1 |
|
| ADRC_ERR_STATUS |
|
Error Status of Address |
AD_ERR_STATUS |
CHAR |
1 |
|
| PO_BOX_LOBBY |
|
PO Box Lobby |
AD_PO_BOX_LBY |
CHAR |
40 |
|
| DELI_SERV_TYPE |
|
Type of Delivery Service |
AD_DELIVERY_SERVICE_TYPE |
CHAR |
4 |
ADDRC_DELI_SERV |
| DELI_SERV_NUMBER |
|
Number of Delivery Service |
AD_DELIVERY_SERVICE_NUMBER |
CHAR |
10 |
|
| COUNTY_CODE |
|
County code for county |
AD_CNTYNUM |
CHAR |
8 |
* |
| COUNTY |
|
County |
AD_COUNTY |
CHAR |
40 |
|
| TOWNSHIP_CODE |
|
Township code for Township |
AD_TWSHPNUM |
CHAR |
8 |
* |
| TOWNSHIP |
|
Township |
AD_TOWNSHIP |
CHAR |
40 |
|
| MC_COUNTY |
|
County name in upper case for search help |
AD_MC_COUNTY |
CHAR |
25 |
|
| MC_TOWNSHIP |
|
Township name in upper case for search help |
AD_MC_TWSHP |
CHAR |
25 |
|
| Append Structure: /SAPHT/RN_SADRC_DUNS |
| DUNS |
|
Dun & Bradstreet number (DUNS) |
/SAPHT/RN_DUNS |
CHAR |
9 |
|
| DUNSP4 |
|
DUNS+4 number (the last four digit) |
/SAPHT/RN_DUNSP4 |
CHAR |
4 |
|