CLIENT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
ADDRNUMBER |
Address number |
AD_ADDRNUM |
|
CHAR |
|
10 |
0 |
|
DATE_FROM |
Valid-from date - in current Release only 00010101 possible |
AD_DATE_FR |
|
DATS |
|
8 |
0 |
|
NATION |
Version ID for International Addresses |
AD_NATION |
TSADV
|
CHAR |
|
1 |
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_TEXT |
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
NULL |
Not checked |
C |
checked against city index |
D |
differs from city index |
|
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 |
|
ADDR_GROUP |
Address Group (Key) (Business Address Services) |
AD_GROUP |
TSAD7
|
CHAR |
|
4 |
0 |
|
FLAGGROUPS |
Flag: There are more address group assignments |
AD_FLGGP |
|
CHAR |
|
1 |
0 |
Possible values
|
PERS_ADDR |
Flag: This is a personal address |
AD_PRSADDR |
|
CHAR |
|
1 |
0 |
Possible values
|
SORT1 |
Search Term 1 |
AD_SORT1 |
|
CHAR |
|
20 |
0 |
|
SORT2 |
Search Term 2 |
AD_SORT2 |
|
CHAR |
|
20 |
0 |
|
SORT_PHN |
(Not Supported) Phonetic Search Sort Field |
AD_SRTPHN |
|
CHAR |
|
20 |
0 |
|
DEFLT_COMM |
Communication Method (Key) (Business Address Services) |
AD_COMM |
TSAC
|
CHAR |
|
3 |
0 |
|
TEL_NUMBER |
First telephone no.: dialling code+number |
AD_TLNMBR1 |
|
CHAR |
|
30 |
0 |
|
TEL_EXTENS |
First Telephone No.: Extension |
AD_TLXTNS1 |
|
CHAR |
|
10 |
0 |
|
FAX_NUMBER |
First fax no.: dialling code+number |
AD_FXNMBR1 |
|
CHAR |
|
30 |
0 |
|
FAX_EXTENS |
First fax no.: extension |
AD_FXXTNS1 |
|
CHAR |
|
10 |
0 |
|
FLAGCOMM2 |
Flag: Telephone number(s) maintained |
AD_FLGCM02 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM3 |
Flag: Fax number(s) maintained |
AD_FLGCM03 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM4 |
Flag: Teletex number(s) maintained |
AD_FLGCM04 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM5 |
Flag: Telex number(s) maintained |
AD_FLGCM05 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM6 |
Indicator: E-Mail Address(es) Maintained |
AD_FLGCM06 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM7 |
Flag: RML (remote mail) addresse(s) maintained |
AD_FLGCM07 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM8 |
Flag: X.400 addresse(s) maintained |
AD_FLGCM08 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM9 |
Flag: RFC destination(s) maintained |
AD_FLGCM09 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM10 |
Flag: Printer maintained |
AD_FLGCM10 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM11 |
Flag: SSF maintained |
AD_FLGCM11 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM12 |
Flag: URI/FTP address maintained |
AD_FLGCM12 |
|
CHAR |
|
1 |
0 |
Possible values
|
FLAGCOMM13 |
Flag: Pager address maintained |
AD_FLGCM13 |
|
CHAR |
|
1 |
0 |
Possible values
|
ADDRORIGIN |
(Not Supported) Address Data Source (Key) |
AD_ORIGINA |
TSAD6
|
CHAR |
|
4 |
0 |
|
MC_NAME1 |
Name (field NAME1) in upper case for matchcode |
AD_MC_NAME |
|
CHAR |
|
25 |
0 |
|
MC_CITY1 |
City name in upper case for search help |
AD_MC_CITY |
|
CHAR |
|
25 |
0 |
|
MC_STREET |
Street name in upper case for search help |
AD_MC_STRT |
|
CHAR |
|
25 |
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 |
|
LANGU_CREA |
Address record creation original language |
AD_LANGUCR |
|
LANG |
|
1 |
0 |
|
ADRC_UUID |
UUID Used in the Address |
AD_UUID |
|
RAW |
|
16 |
0 |
|
UUID_BELATED |
Indicator: UUID was generated later |
AD_UUID_BELATED |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
UUID was generated during creation of address |
X |
UUID was generated later |
|
ID_CATEGORY |
Category of an Address ID |
AD_ID_CATEGORY |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Normal AddressID |
I |
Internal AddressID of Instance Sharing Address |
|
ADRC_ERR_STATUS |
Error Status of Address |
AD_ERR_STATUS |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Address is consistent |
E |
Address contains incorrect data |
W |
Address contains data that leads to warnings |
|
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 |
|
CHAR |
|
8 |
0 |
|
COUNTY |
County |
AD_COUNTY |
|
CHAR |
|
40 |
0 |
|
TOWNSHIP_CODE |
Township code for Township |
AD_TWSHPNUM |
|
CHAR |
|
8 |
0 |
|
TOWNSHIP |
Township |
AD_TOWNSHIP |
|
CHAR |
|
40 |
0 |
|
MC_COUNTY |
County name in upper case for search help |
AD_MC_COUNTY |
|
CHAR |
|
25 |
0 |
|
MC_TOWNSHIP |
Township name in upper case for search help |
AD_MC_TWSHP |
|
CHAR |
|
25 |
0 |
|