SANO1

Address-object relationship

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table SANO1.

SAP table SANO1 has 4 primary key fields: MANDT,ADRNR,OBJNR,OBTYP.

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.

SANO1 fields.

9 fields

Field	Description	Data type	Length	Check table	Data element
Key MANDT	Client	CLNT	3	T000	MANDT
Key ADRNR	Address number	CHAR	10	SANS1	SADRNR
Key OBJNR	Object number (virtual object)	NUMC	10		SOBJNR
Key OBTYP	Object type for objects to which addresses are assigned	NUMC	2	TZV03	SOBTYP
NAME3	Name 3	CHAR	35		NAME3_GP
NAME4	Name 4	CHAR	35		NAME4_GP
ADRZUS	Address addit. info. (e.g. storey)	CHAR	35		ADRZUS
PSTL2	P.O. Box Postal Code	CHAR	10		PSTL2
PFACH	PO Box	CHAR	10		PFACH

SANO1 relationships.

2 relationships

Table	Field	Check table	Description	Check field
SANO1	ADRNR	SANS1	Address table	MANDT
SANO1	OBTYP	TZV03	Object categ.for objects which addresses can be assigned to	OBTYP

Back to SAP tables