- Home
- Resources
- SAP Tables
- SADR - Address Management: Company Data
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.
Source: SADR (Address Management: Company Data)
SADR table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| 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 |
Possible values
|
| TELFX |
Fax number |
TELFX_BAS |
|
CHAR |
|
31 |
0 |
|
| FLAG2 |
Checkbox |
XFELD |
|
CHAR |
|
1 |
0 |
Possible values
|
| TELTX |
Teletex number |
TELTX |
|
CHAR |
|
30 |
0 |
|
| FLAG3 |
Checkbox |
XFELD |
|
CHAR |
|
1 |
0 |
Possible values
|
| TELX1 |
Telex number |
TELX1 |
|
CHAR |
|
30 |
0 |
|
| FLAG4 |
Checkbox |
XFELD |
|
CHAR |
|
1 |
0 |
Possible values
|
| MAIAD |
Checkbox |
XFELD |
|
CHAR |
|
1 |
0 |
Possible values
|
| 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 |
Possible values
| NULL |
Not transferred yet |
| A |
Transferred, data subsequently changed |
| X |
Transferred, data unchanged |
|
| 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 |
MANDT |
TZONE |
Customers: Regional zones |
MANDT |
| SADR |
LZONE |
SADR |
LAND1 |
TZONE |
Customers: Regional zones |
LAND1 |
| SADR |
LZONE |
SADR |
LZONE |
TZONE |
Customers: Regional zones |
ZONE1 |
| SADR |
MANDT |
SADR |
MANDT |
T000 |
Clients |
MANDT |
| SADR |
REGIO |
SADR |
MANDT |
T005S |
Taxes: Region (Province) Key |
MANDT |
| SADR |
REGIO |
SADR |
LAND1 |
T005S |
Taxes: Region (Province) Key |
LAND1 |
| SADR |
REGIO |
SADR |
REGIO |
T005S |
Taxes: Region (Province) Key |
BLAND |
| 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 |
