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 | |||
|---|---|---|---|---|---|---|---|---|
| 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 | LAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
| SANS1 | REGIO | SANS1 | REGIO | T005S | Taxes: Region (Province) Key | BLAND |
| SANS1 | REGIO | SANS1 | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
