SAP ABAP Table USATOWNS (All Cities in the USA)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-GEO (Application Component) Geographical Functions
     ⤷ SZGL_TEST (Package) Tests for the SZGL Development Class

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	USATOWNS	Table Relationship Diagram
Short Description	All Cities in the USA

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	GUIDTOWN	☑	GEOGUID	SYSUUID	RAW	16	0	GUID 16
3	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
4	ZIPCODE	☐	CHAR5	CHAR5	CHAR	5	0	R/2 table
5	CITYNAME	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
6	REGION	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
7	AREACODE	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
8	COUNTYNAME	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
9	PREFERRED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
10	GUIDOBJR	☐	GEOGUID	SYSUUID	RAW	16	0	GUID 16	GEOOBJR

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USATOWNS	GUIDOBJR	GEOOBJR	GUIDOBJR

History

Last changed by/on	SAP	20130604
SAP Release Created in