SAP Table SADR
Address Management: Company Data
SADR (Address Management: Company Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SADR to other SAP tables.
SADR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
ADRNR
Addresses: Address Number
|
CADNR |
CHAR
|
10 | 0 | ||||||||||
|
NATIO
International address version ID
|
INTER |
CHAR
|
1 | 0 | ||||||||||
|
ANRED
Title
|
ANRED |
CHAR
|
15 | 0 | ||||||||||
|
NAME1
Name 1
|
NAME1_BAS |
CHAR
|
35 | 0 | ||||||||||
|
NAME2
Name 2
|
NAME2_BAS |
CHAR
|
35 | 0 | ||||||||||
|
NAME3
Name 3
|
NAME3_BAS |
CHAR
|
35 | 0 | ||||||||||
|
NAME4
Name 4
|
NAME4_BAS |
CHAR
|
35 | 0 | ||||||||||
|
PSTLZ
Postal code
|
PSTLZ_BAS |
CHAR
|
10 | 0 | ||||||||||
|
ORT01
City
|
ORT01_GP |
CHAR
|
35 | 0 | ||||||||||
|
ORT02
District
|
ORT02_BAS |
CHAR
|
35 | 0 | ||||||||||
|
PSTL2
PO Box postal code
|
PSTL2_BAS |
CHAR
|
10 | 0 | ||||||||||
|
PFACH
PO box
|
PFACH_BAS |
CHAR
|
10 | 0 | ||||||||||
|
STRAS
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||||||||||
|
STRS2
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||||||||||
|
HAUSN
House number
|
HAUSN_BAS |
CHAR
|
6 | 0 | ||||||||||
|
STOCK
Floor
|
STOCK |
CHAR
|
6 | 0 | ||||||||||
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |||||||||
|
SORTL
Sort field
|
SORTL_BAS |
CHAR
|
10 | 0 | ||||||||||
|
SORT2
Sort field
|
SORT20 |
CHAR
|
20 | 0 | ||||||||||
|
SPRAS
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||
|
LZONE
Transportation zone to or from which the goods are delivered
|
LZONE | TZONE |
CHAR
|
10 | 0 | |||||||||
|
REGIO
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |||||||||
|
PSTBZ
Post delivery district
|
PSTBZ |
CHAR
|
15 | 0 | ||||||||||
|
TELF1
Addresses: telephone no.
|
TLFNR |
CHAR
|
30 | 0 | ||||||||||
|
FLAG
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TELFX
Fax number
|
TELFX_BAS |
CHAR
|
31 | 0 | ||||||||||
|
FLAG2
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TELTX
Teletex number
|
TELTX |
CHAR
|
30 | 0 | ||||||||||
|
FLAG3
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TELX1
Telex number
|
TELX1 |
CHAR
|
30 | 0 | ||||||||||
|
FLAG4
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
MAIAD
Checkbox
|
XFELD |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
MAILN
Addresses: Document name
|
OBJ_NAM |
CHAR
|
12 | 0 | ||||||||||
|
STDKO
Default communications service
|
STDKO_D |
CHAR
|
1 | 0 | ||||||||||
|
STDCOM
Addresses: Communication type
|
COM_ART |
CHAR
|
3 | 0 | ||||||||||
|
DBNAME
Addresses: System ID
|
SYM_DST |
CHAR
|
10 | 0 | ||||||||||
|
KLASSE
Addresses: class assigned to an address
|
SO_KLASSE |
CHAR
|
18 | 0 | ||||||||||
|
ANREK
Addresses: Form of address key
|
ANREK |
CHAR
|
2 | 0 | ||||||||||
|
CRNAM
Addresses: Created by
|
CR_NAM |
CHAR
|
12 | 0 | ||||||||||
|
CRDAT
Addresses: Creation date
|
CR_DAT |
DATS
|
8 | 0 | ||||||||||
|
CRTIM
Addresses: Creation time
|
CR_TIM |
TIMS
|
6 | 0 | ||||||||||
|
CHNAM
Addresses: Changed by
|
CH_NAM |
CHAR
|
12 | 0 | ||||||||||
|
CHDAT
Addresses: Change date
|
CH_DAT |
DATS
|
8 | 0 | ||||||||||
|
CHTIM
Addresses: Changed at
|
CH_TIM |
TIMS
|
6 | 0 | ||||||||||
|
DUEFL
Status of data transfer into subsequent release
|
DUEFL_BAS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TXJCD
Tax Jurisdiction
|
AD_TXJCD |
CHAR
|
15 | 0 | ||||||||||
|
PFORT
PO Box city
|
PFORT_ADRS |
CHAR
|
40 | 0 | ||||||||||
|
TZONE
Time Zone
|
TZNZONE | TTZZ |
CHAR
|
6 | 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 | ||||||||||
SADR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| SADR | LAND1 | SADR | MANDT |
T005
Countries
|
MANDT |
| SADR | LAND1 | SADR | LAND1 |
T005
Countries
|
LAND1 |
| SADR | LZONE | SADR | LZONE |
TZONE
Customers: Regional zones
|
ZONE1 |
| SADR | LZONE | SADR | MANDT |
TZONE
Customers: Regional zones
|
MANDT |
| SADR | LZONE | SADR | LAND1 |
TZONE
Customers: Regional zones
|
LAND1 |
| SADR | MANDT | SADR | MANDT |
T000
Clients
|
MANDT |
| SADR | REGIO | SADR | REGIO |
T005S
Taxes: Region (Province) Key
|
BLAND |
| SADR | REGIO | SADR | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| SADR | REGIO | SADR | LAND1 |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| SADR | SPRAS | SADR | SPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| SADR | TZONE | SADR | MANDT |
TTZZ
Time zones
|
CLIENT |
| SADR | TZONE | SADR | TZONE |
TTZZ
Time zones
|
TZONE |