| BUKRS |
Company Code |
CHAR |
4 |
0 |
*
|
BUKRS
|
|
| SWENR |
Business Entity Number |
CHAR |
8 |
0 |
*
|
SWENR
|
|
| SGENR |
Building Number |
CHAR |
8 |
0 |
*
|
SGENR
|
|
| SGRNR |
Land Number for BE |
CHAR |
8 |
0 |
*
|
SGRNR
|
|
| REOBJ |
BW RE: InfoObject Real Estate Object (WE, GE, GR) |
CHAR |
22 |
0 |
*
|
REOBJ
|
|
| SMENR |
Number of Rental Unit |
CHAR |
8 |
0 |
*
|
SMENR
|
|
| SMIVE |
Lease-Out Number |
CHAR |
13 |
0 |
|
SMIVE
|
|
| CLIENT |
Client |
CLNT |
3 |
0 |
*
|
MANDT
|
|
| ADDRNUMBER |
Address Number |
CHAR |
10 |
0 |
*
|
AD_ADDRNUM
|
|
| DATE_FROM |
Valid-from date - in current Release only 00010101 possible |
DATS |
8 |
0 |
|
AD_DATE_FR
|
|
| NATION |
Version ID for International Addresses |
CHAR |
1 |
0 |
*
|
AD_NATION
|
|
| DATE_TO |
Valid-to date in current Release only 99991231 possible |
DATS |
8 |
0 |
|
AD_DATE_TO
|
|
| TITLE |
Form-of-Address Key |
CHAR |
4 |
0 |
*
|
AD_TITLE
|
|
| NAME1 |
Name 1 |
CHAR |
40 |
0 |
|
AD_NAME1
|
|
| NAME2 |
Name 2 |
CHAR |
40 |
0 |
|
AD_NAME2
|
|
| NAME3 |
Name 3 |
CHAR |
40 |
0 |
|
AD_NAME3
|
|
| NAME4 |
Name 4 |
CHAR |
40 |
0 |
|
AD_NAME4
|
|
| NAME_TEXT |
Converted name field (with form of address) |
CHAR |
50 |
0 |
|
AD_NAMETXT
|
|
| NAME_CO |
c/o name |
CHAR |
40 |
0 |
|
AD_NAME_CO
|
|
| CITY1 |
City |
CHAR |
40 |
0 |
|
AD_CITY1
|
|
| CITY2 |
District |
CHAR |
40 |
0 |
|
AD_CITY2
|
|
| CITY_CODE |
City code for city/street file |
CHAR |
12 |
0 |
*
|
AD_CITYNUM
|
|
| CITYP_CODE |
District code for City and Street file |
CHAR |
8 |
0 |
*
|
AD_CITYPNM
|
|
| CHCKSTATUS |
City file test status |
CHAR |
1 |
0 |
|
AD_CHECKST
|
|
Not Checked |
| C |
checked against city index |
| D |
differs from city index |
|
| POST_CODE1 |
City postal code |
CHAR |
10 |
0 |
|
AD_PSTCD1
|
|
| POST_CODE2 |
PO Box Postal Code |
CHAR |
10 |
0 |
|
AD_PSTCD2
|
|
| POST_CODE3 |
Company Postal Code (for Large Customers) |
CHAR |
10 |
0 |
|
AD_PSTCD3
|
|
| PO_BOX |
PO Box |
CHAR |
10 |
0 |
|
AD_POBX
|
|
| PO_BOX_NUM |
Flag: PO Box Without Number |
CHAR |
1 |
0 |
|
AD_POBXNUM
|
|
| PO_BOX_LOC |
PO Box city |
CHAR |
40 |
0 |
|
AD_POBXLOC
|
|
| CITY_CODE2 |
City PO box code (City file) |
CHAR |
12 |
0 |
*
|
AD_CIT2NUM
|
|
| PO_BOX_REG |
Region for PO Box (Country/Region, State, Province, ...) |
CHAR |
3 |
0 |
*
|
AD_POBXREG
|
|
| PO_BOX_CTY |
PO Box of Country/Region |
CHAR |
3 |
0 |
*
|
AD_POBXCTY
|
|
| POSTALAREA |
(Not Supported) Post Delivery District |
CHAR |
15 |
0 |
|
AD_PSTLAR
|
|
| TRANSPZONE |
Transportation zone to or from which the goods are delivered |
CHAR |
10 |
0 |
*
|
LZONE
|
|
| STREET |
Street |
CHAR |
60 |
0 |
|
AD_STREET
|
|
| STREETCODE |
Street Number for City/Street File |
CHAR |
12 |
0 |
*
|
AD_STRNUM
|
|
| STREETABBR |
(Not Supported) Abbreviation of Street Name |
CHAR |
2 |
0 |
*
|
AD_STRABBR
|
|
| HOUSE_NUM1 |
House Number |
CHAR |
10 |
0 |
|
AD_HSNM1
|
|
| HOUSE_NUM2 |
House number supplement |
CHAR |
10 |
0 |
|
AD_HSNM2
|
|
| HOUSE_NUM3 |
(Not supported) House Number Range |
CHAR |
10 |
0 |
|
AD_HSNM3
|
|
| STR_SUPPL1 |
Street 2 |
CHAR |
40 |
0 |
|
AD_STRSPP1
|
|
| STR_SUPPL2 |
Street 3 |
CHAR |
40 |
0 |
|
AD_STRSPP2
|
|
| STR_SUPPL3 |
Street 4 |
CHAR |
40 |
0 |
|
AD_STRSPP3
|
|
| LOCATION |
Street 5 |
CHAR |
40 |
0 |
|
AD_LCTN
|
|
| BUILDING |
Building (Number or Code) |
CHAR |
20 |
0 |
|
AD_BLDNG
|
|
| FLOOR |
Floor in building |
CHAR |
10 |
0 |
|
AD_FLOOR
|
|
| ROOMNUMBER |
Room or Apartment Number |
CHAR |
10 |
0 |
|
AD_ROOMNUM
|
|
| COUNTRY |
Country/Region Key |
CHAR |
3 |
0 |
*
|
LAND1
|
|
| LANGU |
Language Key |
LANG |
1 |
0 |
*
|
SPRAS
|
|
| REGION |
Region (State, Province, County) |
CHAR |
3 |
0 |
*
|
REGIO
|
|
| ADDR_GROUP |
Address Group (Key) (Business Address Services) |
CHAR |
4 |
0 |
*
|
AD_GROUP
|
|
| PERS_ADDR |
Flag: This is a personal address |
CHAR |
1 |
0 |
|
AD_PRSADDR
|
|
| SORT1 |
Search Term 1 |
CHAR |
20 |
0 |
|
AD_SORT1
|
|
| SORT2 |
Search Term 2 |
CHAR |
20 |
0 |
|
AD_SORT2
|
|
| SORT_PHN |
(Not Supported) Phonetic Search Sort Field |
CHAR |
20 |
0 |
|
AD_SRTPHN
|
|
| DEFLT_COMM |
Communication Method (Key) (Business Address Services) |
CHAR |
3 |
0 |
*
|
AD_COMM
|
|
| TEL_NUMBER |
First telephone no.: dialling code+number |
CHAR |
30 |
0 |
|
AD_TLNMBR1
|
|
| TEL_EXTENS |
First Telephone No.: Extension |
CHAR |
10 |
0 |
|
AD_TLXTNS1
|
|
| FAX_NUMBER |
First Fax No.: Area Code + Number |
CHAR |
30 |
0 |
|
AD_FXNMBR1
|
|
| FAX_EXTENS |
First fax no.: extension |
CHAR |
10 |
0 |
|
AD_FXXTNS1
|
|
| FLAGCOMM2 |
Flag: Telephone number(s) defined |
CHAR |
1 |
0 |
|
AD_FLGCM02
|
|
| FLAGCOMM3 |
Flag: Fax number(s) defined |
CHAR |
1 |
0 |
|
AD_FLGCM03
|
|
| FLAGCOMM4 |
Flag: Teletex number(s) defined |
CHAR |
1 |
0 |
|
AD_FLGCM04
|
|
| FLAGCOMM5 |
Flag: Telex number(s) defined |
CHAR |
1 |
0 |
|
AD_FLGCM05
|
|
| FLAGCOMM6 |
Flag: E-mail address(es) defined |
CHAR |
1 |
0 |
|
AD_FLGCM06
|
|
| FLAGCOMM7 |
Flag: RML (remote mail) addresse(s) defined |
CHAR |
1 |
0 |
|
AD_FLGCM07
|
|
| FLAGCOMM8 |
Flag: X.400 addresse(s) defined |
CHAR |
1 |
0 |
|
AD_FLGCM08
|
|
| FLAGCOMM9 |
Flag: RFC destination(s) defined |
CHAR |
1 |
0 |
|
AD_FLGCM09
|
|
| ADDRORIGIN |
(Not Supported) Address Data Source (Key) |
CHAR |
4 |
0 |
*
|
AD_ORIGINA
|
|
| MC_NAME1 |
Name (Field NAME1) in Uppercase for Search Help |
CHAR |
25 |
0 |
|
AD_MC_NAME
|
|
| MC_CITY1 |
City name in Uppercase for Search Help |
CHAR |
25 |
0 |
|
AD_MC_CITY
|
|
| MC_STREET |
Street Name in Uppercase for Search Help |
CHAR |
25 |
0 |
|
AD_MC_STRT
|
|
| EXTENSION1 |
Extension (only for data conversion) (data line/telebox) |
CHAR |
40 |
0 |
|
AD_EXTENS
|
|
| EXTENSION2 |
Extension (only for data conversion) (data line/telebox) |
CHAR |
40 |
0 |
|
AD_EXTENS
|
|
| TIME_ZONE |
Address time zone |
CHAR |
6 |
0 |
*
|
AD_TZONE
|
|
| TAXJURCODE |
Tax Jurisdiction |
CHAR |
15 |
0 |
|
AD_TXJCD
|
|
| ADDRESS_ID |
(Not supported) Physical address ID |
CHAR |
10 |
0 |
|
AD_ADDR_ID
|
|
| LANGU_CREA |
Address record creation original language |
LANG |
1 |
0 |
*
|
AD_LANGUCR
|
|