SANS1
Address tableExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table SANS1.
SAP table SANS1 has 2 primary key fields: MANDT,ADRNR.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
SANS1 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key ADRNR | Address number | CHAR | 10 | 0 | SADRNR | ||
| LAND1 | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| PSTLZ | Postal Code | CHAR | 10 | 0 | PSTLZ | ||
| ORT01 | City | CHAR | 35 | 0 | ORT01_GP | ||
| ORT02 | District | CHAR | 35 | 0 | ORT02_GP | ||
| PSTBZ | Post delivery district | CHAR | 15 | 0 | PSTBZ | ||
| STRAS | Street and House Number | CHAR | 35 | 0 | STRAS_GP | ||
| STRA1 | Street and House Number | CHAR | 35 | 0 | STRAS_GP | ||
| REGIO | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| ORT01_MC | IS-IS: City 1 in upper case characters for matchcode search | CHAR | 16 | 0 | VVXORT01MC | ||
| STRAS_MC | IS-IS: Street in upper case characters for matchcode search | CHAR | 16 | 0 | VVXSTRASMC | ||
| ADDRESS_ID | (Not supported) Physical address ID | CHAR | 10 | 0 | AD_ADDR_ID |