SAP ABAP Table SANS1 (Address table)

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	SANS1	Table Relationship Diagram
Short Description	Address table

Delivery and Maintenance

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

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
3	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
4	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
5	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
6	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
7	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
8	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
9	STRA1	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
10	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
11	ORT01_MC	☐	VVXORT01MC	CHAR16	CHAR	16	0	IS-IS: City 1 in upper case characters for matchcode search
12	STRAS_MC	☐	VVXSTRASMC	CHAR16	CHAR	16	0	IS-IS: Street in upper case characters for matchcode search
13	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SANS1	LAND1	T005	LAND1	KEY	1	1
2	SANS1	MANDT	T000	MANDT	KEY	1	1
3	SANS1	REGIO	T005S	BLAND	KEY	1	1

History

Last changed by/on	SAP	20130529
SAP Release Created in