SAP ABAP Table JYTSTRFIELDS_USA (IS-M: Additional Fields in JSTSTRPRO for US Country Version)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	JYTSTRFIELDS_USA	Table Relationship Diagram
Short Description	IS-M: Additional Fields in JSTSTRPRO for US Country Version

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	PREDIRECTIONAL	☐	PREDIRECTIONAL	DIRECTIONAL	CHAR	10	0	Predirectional	TJS41
2	SUFFIXABBREV	☐	SUFFIXABBREV	CHAR04	CHAR	4	0	Suffix to Street Name According to USPS
3	POSTDIRECTIONAL	☐	POSTDIRECTIONAL	DIRECTIONAL	CHAR	10	0	Postdirectional	TJS41
4	RECORDTYPECODE	☐	RECORDTYPECODE	RECORDTYPECODE	CHAR	1	0	Record Type in ZIP+4 File
5	CARRIERROUTEID	☐	CARRIERROUTEID	CHAR04	CHAR	4	0	Indicates Whether Truck Routes are for Drop-Off or Delivery
6	BUILDINGFIRMNAME	☐	BUILDINGFIRMNAME	TEXT40	CHAR	40	0	Building or Company Name
7	.INCLUDE	☐				0	0	IS-M: Structure for Enhanced Address Data
8	.INCLUDE	☐				0	0	Secondary Address (Without ZIP Add-On)
9	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
10	ADDRSECNUMLOW	☐	ADDRSECNUMLOW	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number (Lower Limit)
11	ADDRSECNUMHIGH	☐	ADDRSECNUMHIGH	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
12	ADDRSECODDEVEN	☐	ADDRSECODDEVEN	ODDEVENCODE	CHAR	1	0	IS-M: Odd/Even Indicator for Secondary Address Number
13	ZIPADDONLOW	☐	JZIPADDONLOW	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (lower limit)
14	ZIPADDONHIGH	☐	JZIPADDONHIGH	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (upper limit)
15	LACSSTATUSIND	☐	LACSSTATUSIND	CHAR01	CHAR	1	0	Locatable Address Conversion Service (LACS) indicator
16	GOVTBLDGIND	☐	GOVTBLDGIND	GOVTBLDGINDICATOR	CHAR	1	0	Building Type
17	FINANCENO	☐	FINANCENO	CHAR06	CHAR	6	0	Finance Number; Required by USPS
18	STATEABBREV	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
19	COUNTYNO	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
20	CONGRDISTRICTNO	☐	CONGRDISTRICTNO	CHAR02	CHAR	2	0	Code for District in a Geographical Area
21	PREFCITYSTATEKEY	☐	CITYSTATEKEY	CHAR06	CHAR	6	0	City Number from City State Product File

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JYTSTRFIELDS_USA	ADDRSECABBREV	TJS43	ADDRSECABBREV
2	JYTSTRFIELDS_USA	COUNTYNO	T005E	COUNC
3	JYTSTRFIELDS_USA	POSTDIRECTIONAL	TJS41	DIRECTIONAL
4	JYTSTRFIELDS_USA	PREDIRECTIONAL	TJS41	DIRECTIONAL
5	JYTSTRFIELDS_USA	STATEABBREV	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in