SAP ABAP Table TXI_SANO1 (Address-object relationship)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_SANO1	Table Relationship Diagram
Short Description	Address-object relationship

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Address-object relationship
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ADRNR	☐	SADRNR	SADRNR	CHAR	10	0	Address number	SANS1
4	OBJNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	*
5	OBTYP	☐	SOBTYP	SOBTYP	NUMC	2	0	Object type for objects to which addresses are assigned	TZV03
6	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
7	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
8	ADRZUS	☐	ADRZUS	TEXT35	CHAR	35	0	Address addit. info. (e.g. storey)
9	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
10	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	TXI_SANO1	ADRNR	SANS1	ADRNR	KEY	1	1
2	TXI_SANO1	MANDT	T000	MANDT	KEY	1	1
3	TXI_SANO1	OBTYP	TZV03	OBTYP	KEY	1	1

History

Last changed by/on	SAP	20110901
SAP Release Created in