SAP ABAP Table JSTCSPDETAIL (IS-M: Rec.Structure for US City State Product File (Details))

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

Table Category	INTTAB	Structure
Structure	JSTCSPDETAIL	Table Relationship Diagram
Short Description	IS-M: Rec.Structure for US City State Product File (Details)

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	DETAILCODE	☐	DETAILCODE	CHAR01	CHAR	1	0	Record Type in US Postal Data
2	ZIPCODE	☐	JZIPCODE	JCHAR5	CHAR	5	0	5-digit ZIP code
3	CITYSTATEKEY	☐	CITYSTATEKEY	CHAR06	CHAR	6	0	City Number from City State Product File
4	ZIPCLASSIFCODE	☐	JZIPCLASSIFCODE	CHAR01	CHAR	1	0	Classification of ZIP code
5	CITYSTATENAME	☐	CITYSTATENAME	TEXT28	CHAR	28	0	City
6	CITYSTATENAME_S	☐	CITYSTATENAME_S	TEXT13	CHAR	13	0	City Name (Short)
7	CITYSTATEFACCODE	☐	CITYSTATEFACCODE	CITYSTATEFACCODE	CHAR	1	0	Type of Location Defined by the City Name
8	CITYSTATEMAILIND	☐	CITYSTATEMAILIND	CHAR01	CHAR	1	0	Indicates Whether City Text Possible for Postal Addressing
9	PREFCITYSTATEKEY	☐	CITYSTATEKEY	CHAR06	CHAR	6	0	City Number from City State Product File
10	PREFCITYSTATENAME	☐	CITYSTATENAME	TEXT28	CHAR	28	0	City
11	CITYDELIND	☐	CITYDELIND	CHAR01	CHAR	1	0	Indicates Whether Carrier Routes Defined
12	CARRRTESORTIND	☐	CARRRTESORTIND	CHAR01	CHAR	1	0	Indicates Whether Price Reduction Possible for Letter Post
13	UNIQUEZIPIND	☐	UNIQUEZIPIND	CHAR01	CHAR	1	0	Indicates Whether or not ZIP Code is Unique
14	FINANCENO	☐	FINANCENO	CHAR06	CHAR	6	0	Finance Number; Required by USPS
15	STATEABBREV	☐	STATEABBREV	CHAR02	CHAR	2	0	Abbreviation for a Federal State or Province
16	COUNTYNO	☐	COUNTYNO	NUMC3	NUMC	3	0	Code for County/Administrative District in State
17	COUNTYNAME	☐	COUNTYNAME	TEXT25	CHAR	25	0	Name of County/Administrative District

History

Last changed by/on	SAP	20130529
SAP Release Created in