SAP ABAP Table GEOZ5GOLD (Table for ZIP5GOLD Geo-Coder (Zipcodes USA))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-GEO (Application Component) Geographical Functions
     ⤷ SZGEOCODING (Package) Geocoding, Independent of Business Address Services

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	GEOZ5GOLD	Table Relationship Diagram
Short Description	Table for ZIP5GOLD Geo-Coder (Zipcodes 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	ZIPCODE	☑	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
2	CITYNAME	☑	AD_CITY1	TEXT40	CHAR	40	0	City
3	CITYUPCASE	☐	AD_CITY1	TEXT40	CHAR	40	0	City
4	STATECODE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
5	PREFERRED	☐	GEOZ5_PREF	GEOZ5_PREF	CHAR	1	0	Preferred City Name (P,A,N), Preferred/Approved/Not Approved
6	TIME_ZONE	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
7	LONGITUDE	☐	GEOLON	GEOLONLAT	DEC	15	12	Geo location longitude
8	LATITUDE	☐	GEOLAT	GEOLONLAT	DEC	15	12	Geo location latitude

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GEOZ5GOLD	TIME_ZONE	TTZZ	TZONE	REF	1	N

History

Last changed by/on	SAP	20110908
SAP Release Created in	610