SAP ABAP Table JYTSTRINCL (IS-PSD: Include with Attributes of Table JSTSTRPRO)

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	JYTSTRINCL	Table Relationship Diagram
Short Description	IS-PSD: Include with Attributes of Table JSTSTRPRO

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	SUCHFELDS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
2	STR_NAME_K	☐	STR_NAME_K	TEXT25	CHAR	25	0	IS-M: Street Name (Short)
3	STR_NAME_L	☐	STR_NAME_L	TEXT50	CHAR	50	0	IS-M: Street Name (long)
4	STR_NAME_G	☐	STR_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: Street name - upper case for matchcode
5	STR_NAME_S	☐	STR_NAME_S	CHAR50	CHAR	50	0	IS-M: Street Name (Long Without Special Characters)
6	OTL_KEY	☐	OTL_KEY	OTL_KEY	CHAR	3	0	IS-M: City District Number	*
7	KREISG_SCH	☐	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key	*
8	HNRKENN	☐	HNRKENN	HAUSNRKENN	CHAR	1	0	IS-M: Identifier for House Number Range
9	HNR1VON	☐	HNR1VON	HAUSNUMMER	CHAR	10	0	IS-M: House Number From (Numerical)
10	HNR2VON	☐	HNR2VON	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix to First House Number (Alphanumeric)
11	HNR1BIS	☐	HNR1BIS	HAUSNUMMER	CHAR	10	0	IS-M: House Numbers To (Numerical)
12	HNR2BIS	☐	HNR2BIS	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix for Last House Number (Alphanumeric)
13	PLZ_ZSTR	☐	PLZ_ZSTR	NPSTLZ	CHAR	10	0	IS-M: Postal Code of Street Section for Home Delivery	*
14	STR_NRPOST	☐	STR_NRPOST	STR_NRPOST	CHAR	15	0	IS-M: Street number from German postal service
15	STRHNR1000	☐	STRHNR1000	STRHNR1000	CHAR	1	0	IS-M: 1000 column in house number interval
16	STR_CODE	☐	STR_CODE	STR_CODE	CHAR	3	0	IS-M: Street code for coding street sections
17	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
18	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
19	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
20	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
21	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
22	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
23	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
24	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
25	.INCLUDE	☐				0	0	Version (for upgrade procedures for postal data)
26	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
27	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
28	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
29	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number	*
30	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
31	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
32	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
33	.INCLUDE	☐				0	0	IS-M: Additional Fields in JSTSTRPRO for US Country Version
34	PREDIRECTIONAL	☐	PREDIRECTIONAL	DIRECTIONAL	CHAR	10	0	Predirectional	TJS41
35	SUFFIXABBREV	☐	SUFFIXABBREV	CHAR04	CHAR	4	0	Suffix to Street Name According to USPS
36	POSTDIRECTIONAL	☐	POSTDIRECTIONAL	DIRECTIONAL	CHAR	10	0	Postdirectional	TJS41
37	RECORDTYPECODE	☐	RECORDTYPECODE	RECORDTYPECODE	CHAR	1	0	Record Type in ZIP+4 File
38	CARRIERROUTEID	☐	CARRIERROUTEID	CHAR04	CHAR	4	0	Indicates Whether Truck Routes are for Drop-Off or Delivery
39	BUILDINGFIRMNAME	☐	BUILDINGFIRMNAME	TEXT40	CHAR	40	0	Building or Company Name
40	.INCLUDE	☐				0	0	IS-M: Structure for Enhanced Address Data
41	.INCLUDE	☐				0	0	Secondary Address (Without ZIP Add-On)
42	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
43	ADDRSECNUMLOW	☐	ADDRSECNUMLOW	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number (Lower Limit)
44	ADDRSECNUMHIGH	☐	ADDRSECNUMHIGH	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
45	ADDRSECODDEVEN	☐	ADDRSECODDEVEN	ODDEVENCODE	CHAR	1	0	IS-M: Odd/Even Indicator for Secondary Address Number
46	ZIPADDONLOW	☐	JZIPADDONLOW	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (lower limit)
47	ZIPADDONHIGH	☐	JZIPADDONHIGH	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (upper limit)
48	LACSSTATUSIND	☐	LACSSTATUSIND	CHAR01	CHAR	1	0	Locatable Address Conversion Service (LACS) indicator
49	GOVTBLDGIND	☐	GOVTBLDGIND	GOVTBLDGINDICATOR	CHAR	1	0	Building Type
50	FINANCENO	☐	FINANCENO	CHAR06	CHAR	6	0	Finance Number; Required by USPS
51	STATEABBREV	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
52	COUNTYNO	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
53	CONGRDISTRICTNO	☐	CONGRDISTRICTNO	CHAR02	CHAR	2	0	Code for District in a Geographical Area
54	PREFCITYSTATEKEY	☐	CITYSTATEKEY	CHAR06	CHAR	6	0	City Number from City State Product File
55	.INCLU--AP	☐				0	0	Structure for Additional Street Fields (NL)
56	STREETNAME_NEN	☐	STREETNAME_NEN	TEXT24	CHAR	24	0	Street Name (NEN Standard)
57	STREETNAME_PTT	☐	STREETNAME_PTT	CHAR17	CHAR	17	0	Street Name (PTT Standard)
58	SERIESINDICATOR	☐	SERIESINDICATOR	SERIESINDICATOR	CHAR	1	0	Indicator in PTT Postal Data: Street, Houseboat or Trailer

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in