SAP Table SANS1
Address table
SANS1 (Address table) 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 SANS1 to other SAP tables.
SANS1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
ADRNR
Address number
|
SADRNR |
CHAR
|
10 | 0 | ||
|
LAND1
Country Key
|
LAND1 | T005 |
CHAR
|
3 | 0 | |
|
PSTLZ
Postal Code
|
PSTLZ |
CHAR
|
10 | 0 | ||
|
ORT01
City
|
ORT01_GP |
CHAR
|
35 | 0 | ||
|
ORT02
District
|
ORT02_GP |
CHAR
|
35 | 0 | ||
|
PSTBZ
Post delivery district
|
PSTBZ |
CHAR
|
15 | 0 | ||
|
STRAS
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||
|
STRA1
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||
|
REGIO
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |
|
ORT01_MC
IS-IS: City 1 in upper case characters for matchcode search
|
VVXORT01MC |
CHAR
|
16 | 0 | ||
|
STRAS_MC
IS-IS: Street in upper case characters for matchcode search
|
VVXSTRASMC |
CHAR
|
16 | 0 | ||
|
ADDRESS_ID
(Not supported) Physical address ID
|
AD_ADDR_ID |
CHAR
|
10 | 0 |
SANS1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| SANS1 | LAND1 | SANS1 | MANDT |
T005
Countries
|
MANDT |
| SANS1 | LAND1 | SANS1 | LAND1 |
T005
Countries
|
LAND1 |
| SANS1 | MANDT | SANS1 | MANDT |
T000
Clients
|
MANDT |
| SANS1 | REGIO | SANS1 | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| SANS1 | REGIO | SANS1 | LAND1 |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| SANS1 | REGIO | SANS1 | REGIO |
T005S
Taxes: Region (Province) Key
|
BLAND |