SAP ABAP Table SANO1 (Address-object relationship)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVV (Package) R/3 application development for Financial Assets Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SANO1	Table Relationship Diagram
Short Description	Address-object relationship

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ADRNR	☑	SADRNR	SADRNR	CHAR	10	0	Address number	SANS1
3	OBJNR	☑	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)
4	OBTYP	☑	SOBTYP	SOBTYP	NUMC	2	0	Object type for objects to which addresses are assigned	TZV03
5	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
6	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
7	ADRZUS	☐	ADRZUS	TEXT35	CHAR	35	0	Address addit. info. (e.g. storey)
8	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
9	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SANO1	ADRNR	SANS1	ADRNR	KEY	1	1
2	SANO1	MANDT	T000	MANDT	KEY	1	1
3	SANO1	OBTYP	TZV03	OBTYP	KEY	1	1

History

Last changed by/on	SAP	20110901
SAP Release Created in