SAP ABAP Table JSTZIP4DETAIL (IS-M: Record Structure for US ZIP+4 File (Streets))

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	JSTZIP4DETAIL	Table Relationship Diagram
Short Description	IS-M: Record Structure for US ZIP+4 File (Streets)

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	UPDATEKEYNUMBER	☐	UPDATEKEYNUMBER	CHAR10	CHAR	10	0	Unique number of ZIP record
4	ACTIONCODE	☐	JACTIONCODE	CHAR01	CHAR	1	0	Activity Code for Record (Add, Delete)
5	RECORDTYPECODE	☐	RECORDTYPECODE	RECORDTYPECODE	CHAR	1	0	Record Type in ZIP+4 File
6	CARRIERROUTEID	☐	CARRIERROUTEID	CHAR04	CHAR	4	0	Indicates Whether Truck Routes are for Drop-Off or Delivery
7	PREDIRECTIONAL	☐	DIRECTNABBREV	CHAR02	CHAR	2	0	Direction for Street Name (Abbreviation)
8	STREETNAME	☐	STREETNAME	TEXT28	CHAR	28	0	Street name
9	SUFFIXABBREV	☐	SUFFIXABBREV	CHAR04	CHAR	4	0	Suffix to Street Name According to USPS
10	POSTDIRECTIONAL	☐	DIRECTNABBREV	CHAR02	CHAR	2	0	Direction for Street Name (Abbreviation)
11	ADDRPRIMLOW	☐	ADDRPRIMLOW	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Lower Limit)
12	ADDRPRIMHIGH	☐	ADDRPRIMHIGH	HAUSNUMMER	CHAR	10	0	IS-M: Primary House Number (Upper Limit)
13	ADDRPRIMODDEVEN	☐	ADDRPRIMODDEVEN	ODDEVENCODE	CHAR	1	0	Even/Odd ID for Primary Address Number
14	BUILDINGFIRMNAME	☐	BUILDINGFIRMNAME	TEXT40	CHAR	40	0	Building or Company Name
15	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	*
16	ADDRSECNUMLOW	☐	ADDRSECNUMLOW	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number (Lower Limit)
17	ADDRSECNUMHIGH	☐	ADDRSECNUMHIGH	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
18	ADDRSECODDEVEN	☐	ADDRSECODDEVEN	ODDEVENCODE	CHAR	1	0	IS-M: Odd/Even Indicator for Secondary Address Number
19	ZIPADDONLOW	☐	JZIPADDONLOW	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (lower limit)
20	ZIPADDONHIGH	☐	JZIPADDONHIGH	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (upper limit)
21	BASEALTCODE	☐	BASEALTCODE	CHAR01	CHAR	1	0	Change Code for a Record (Basic or Change Record)
22	LACSSTATUSIND	☐	LACSSTATUSIND	CHAR01	CHAR	1	0	Locatable Address Conversion Service (LACS) indicator
23	GOVTBLDGIND	☐	GOVTBLDGIND	GOVTBLDGINDICATOR	CHAR	1	0	Building Type
24	FINANCENO	☐	FINANCENO	CHAR06	CHAR	6	0	Finance Number; Required by USPS
25	STATEABBREV	☐	STATEABBREV	CHAR02	CHAR	2	0	Abbreviation for a Federal State or Province
26	COUNTYNO	☐	COUNTYNO	NUMC3	NUMC	3	0	Code for County/Administrative District in State
27	CONGRDISTRICTNO	☐	CONGRDISTRICTNO	CHAR02	CHAR	2	0	Code for District in a Geographical Area
28	MUNICITYSTATEKEY	☐	CITYSTATEKEY	CHAR06	CHAR	6	0	City Number from City State Product File
29	URBACITYSTATEKEY	☐	CITYSTATEKEY	CHAR06	CHAR	6	0	City Number from City State Product File
30	PREFCITYSTATEKEY	☐	CITYSTATEKEY	CHAR06	CHAR	6	0	City Number from City State Product File

History

Last changed by/on	SAP	20130529
SAP Release Created in