SAP ABAP Table JSTSTRUPDA (IS-M/SD: Table for Upgrading Table JSTSTRPRO)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JSTSTRUPDA	Table Relationship Diagram
Short Description	IS-M/SD: Table for Upgrading Table JSTSTRPRO

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LAND1_ALT	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
3	ALORT_ALT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
4	STRNR_ALT	☑	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
5	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
6	ALORT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
7	STRASSENNR	☑	STRASSENNR	STRASSENNR	CHAR	10	0	IS-M: Street Number	JSTSTRPRO
8	.INCLUDE	☐				0	0	IS-PSD: Include with Attributes of Table JSTSTRPRO
9	SUCHFELDS	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
10	STR_NAME_K	☐	STR_NAME_K	TEXT25	CHAR	25	0	IS-M: Street Name (Short)
11	STR_NAME_L	☐	STR_NAME_L	TEXT50	CHAR	50	0	IS-M: Street Name (long)
12	STR_NAME_G	☐	STR_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: Street name - upper case for matchcode
13	STR_NAME_S	☐	STR_NAME_S	CHAR50	CHAR	50	0	IS-M: Street Name (Long Without Special Characters)
14	OTL_KEY	☐	OTL_KEY	OTL_KEY	CHAR	3	0	IS-M: City District Number	JSTOTLPRO
15	KREISG_SCH	☐	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key	JSTKGSPRO
16	HNRKENN	☐	HNRKENN	HAUSNRKENN	CHAR	1	0	IS-M: Identifier for House Number Range
17	HNR1VON	☐	HNR1VON	HAUSNUMMER	CHAR	10	0	IS-M: House Number From (Numerical)
18	HNR2VON	☐	HNR2VON	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix to First House Number (Alphanumeric)
19	HNR1BIS	☐	HNR1BIS	HAUSNUMMER	CHAR	10	0	IS-M: House Numbers To (Numerical)
20	HNR2BIS	☐	HNR2BIS	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix for Last House Number (Alphanumeric)
21	PLZ_ZSTR	☐	PLZ_ZSTR	NPSTLZ	CHAR	10	0	IS-M: Postal Code of Street Section for Home Delivery	JSTPLZPRO
22	STR_NRPOST	☐	STR_NRPOST	STR_NRPOST	CHAR	15	0	IS-M: Street number from German postal service
23	STRHNR1000	☐	STRHNR1000	STRHNR1000	CHAR	1	0	IS-M: 1000 column in house number interval
24	STR_CODE	☐	STR_CODE	STR_CODE	CHAR	3	0	IS-M: Street code for coding street sections
25	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
26	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
27	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
28	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
29	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
30	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
31	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
32	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
33	.INCLUDE	☐				0	0	Version (for upgrade procedures for postal data)
34	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
35	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
36	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
37	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number	*
38	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
39	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
40	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
41	.INCLUDE	☐				0	0	IS-M: Additional Fields in JSTSTRPRO for US Country Version
42	PREDIRECTIONAL	☐	PREDIRECTIONAL	DIRECTIONAL	CHAR	10	0	Predirectional	TJS41
43	SUFFIXABBREV	☐	SUFFIXABBREV	CHAR04	CHAR	4	0	Suffix to Street Name According to USPS
44	POSTDIRECTIONAL	☐	POSTDIRECTIONAL	DIRECTIONAL	CHAR	10	0	Postdirectional	TJS41
45	RECORDTYPECODE	☐	RECORDTYPECODE	RECORDTYPECODE	CHAR	1	0	Record Type in ZIP+4 File
46	CARRIERROUTEID	☐	CARRIERROUTEID	CHAR04	CHAR	4	0	Indicates Whether Truck Routes are for Drop-Off or Delivery
47	BUILDINGFIRMNAME	☐	BUILDINGFIRMNAME	TEXT40	CHAR	40	0	Building or Company Name
48	.INCLUDE	☐				0	0	IS-M: Structure for Enhanced Address Data
49	.INCLUDE	☐				0	0	Secondary Address (Without ZIP Add-On)
50	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
51	ADDRSECNUMLOW	☐	ADDRSECNUMLOW	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number (Lower Limit)
52	ADDRSECNUMHIGH	☐	ADDRSECNUMHIGH	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
53	ADDRSECODDEVEN	☐	ADDRSECODDEVEN	ODDEVENCODE	CHAR	1	0	IS-M: Odd/Even Indicator for Secondary Address Number
54	ZIPADDONLOW	☐	JZIPADDONLOW	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (lower limit)
55	ZIPADDONHIGH	☐	JZIPADDONHIGH	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (upper limit)
56	LACSSTATUSIND	☐	LACSSTATUSIND	CHAR01	CHAR	1	0	Locatable Address Conversion Service (LACS) indicator
57	GOVTBLDGIND	☐	GOVTBLDGIND	GOVTBLDGINDICATOR	CHAR	1	0	Building Type
58	FINANCENO	☐	FINANCENO	CHAR06	CHAR	6	0	Finance Number; Required by USPS
59	STATEABBREV	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
60	COUNTYNO	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
61	CONGRDISTRICTNO	☐	CONGRDISTRICTNO	CHAR02	CHAR	2	0	Code for District in a Geographical Area
62	PREFCITYSTATEKEY	☐	CITYSTATEKEY	CHAR06	CHAR	6	0	City Number from City State Product File
63	.INCLU--AP	☐				0	0	Structure for Additional Street Fields (NL)
64	STREETNAME_NEN	☐	STREETNAME_NEN	TEXT24	CHAR	24	0	Street Name (NEN Standard)
65	STREETNAME_PTT	☐	STREETNAME_PTT	CHAR17	CHAR	17	0	Street Name (PTT Standard)
66	SERIESINDICATOR	☐	SERIESINDICATOR	SERIESINDICATOR	CHAR	1	0	Indicator in PTT Postal Data: Street, Houseboat or Trailer
67	ST_NAMEALT	☐	STR_NAME_L	TEXT50	CHAR	50	0	IS-M: Street Name (long)
68	STR_NRPALT	☐	STR_NRPOST	STR_NRPOST	CHAR	15	0	IS-M: Street number from German postal service
69	HNRKENNALT	☐	HNRKENN	HAUSNRKENN	CHAR	1	0	IS-M: Identifier for House Number Range
70	HNR1000ALT	☐	STRHNR1000	STRHNR1000	CHAR	1	0	IS-M: 1000 column in house number interval
71	HNR1VONALT	☐	HNR1VON	HAUSNUMMER	CHAR	10	0	IS-M: House Number From (Numerical)
72	HNR2VONALT	☐	HNR2VON	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix to First House Number (Alphanumeric)
73	HNR1BISALT	☐	HNR1BIS	HAUSNUMMER	CHAR	10	0	IS-M: House Numbers To (Numerical)
74	HNR2BISALT	☐	HNR2BIS	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix for Last House Number (Alphanumeric)
75	.INCLUDE	☐				0	0	IS-PSD: Update Indicator for Postal Upgrade
76	DBCODE_ALT	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
77	DBCODE_NEU	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
78	X_ADRESSEN	☐	X_ADRESSEN	XFELD	CHAR	1	0	IS-M: Update indicator: relevant addresses revised
79	X_STRUKTUR	☐	X_STRUKTUR	XFELD	CHAR	1	0	IS-M: Update indicator, related structures revised
80	X_POST_DB	☐	X_POST_DB	XFELD	CHAR	1	0	IS-M: Update indicator, postal DB edited
81	.INCLUDE	☐				0	0	Change data for structural changes etc.
82	.INCLUDE	☐				0	0	Change data: Standard references
83	AENDNRBIS	☐	AENDNRBIS	AENDNR	CHAR	9	0	Change Number for To-Date of Structural Change	JSTAENDER
84	AENDNRBISD	☐	AENDNRBISD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change To-Date
85	AENDNRAB	☐	AENDNRAB	AENDNR	CHAR	9	0	Change Number for From-Date of Structure Change	JSTAENDER
86	AENDNRABD	☐	AENDNRABD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change From-Date
87	AENDNRINIT	☐	AENDNRINIT	AENDNR	CHAR	9	0	Initiating Change Number	JSTAENDER
88	AENDLFDNRI	☐	AENDLFDNRI	AENDLFDNR	NUMC	4	0	Sequence Number of Initiating Change Number
89	AENDNRAKT	☐	AENDNRAKT	AENDNR	CHAR	9	0	Change Number in Process	JSTAENDER
90	AENDLFDNRA	☐	AENDLFDNRA	AENDLFDNR	NUMC	4	0	Sequence Number of Currently Operative Change Number
91	XAENDER	☐	XAENDER	XFELD	CHAR	1	0	Structure information being changed on other change number
92	XSTRUAKTIV	☐	XSTRUAKTIV	XSTRUAKTIV	CHAR	1	0	Structure information inactive
93	FCCODE	☐	FCCODE	FCCODE	CHAR	2	0	Function Control Code for Structure Changes
94	DBCODEFREI	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
95	.INCLUDE	☐				0	0	Change data: Reassignment statements
96	AENDNRVON	☐	AENDNRVON	AENDNR	CHAR	9	0	Change Number Used for Transfer FROM Another Assignment	JSTAENDER
97	AENDLFDNRV	☐	AENDLFDNRV	AENDLFDNR	NUMC	4	0	Sequence Number of Change Number Used for Transfer
98	AENDNRNACH	☐	AENDNRNACH	AENDNR	CHAR	9	0	Change Number Used to Transfer to Another Assignment	JSTAENDER
99	AENDLFDNRN	☐	AENDLFDNRN	AENDLFDNR	NUMC	4	0	Sequence Number of Change Number Used for Transfer
100	HNR1VON_ZUS	☐	HNR1VON	HAUSNUMMER	CHAR	10	0	IS-M: House Number From (Numerical)
101	HNR2VON_ZUS	☐	HNR2VON	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix to First House Number (Alphanumeric)
102	HNR1BIS_ZUS	☐	HNR1BIS	HAUSNUMMER	CHAR	10	0	IS-M: House Numbers To (Numerical)
103	HNR2BIS_ZUS	☐	HNR2BIS	HNRZUSATZ	CHAR	8	0	IS-M/SD: Affix for Last House Number (Alphanumeric)
104	.INCLU--AP	☐				0	0	Structure for Additional Fields for Street CH
105	STRNRPTT	☐	J_1SSTRPTT	NUM06	NUMC	6	0	IS-M: PTT street number (CH)
106	STRART	☐	J_1SSTRART	J_1SSTRART	CHAR	2	0	IS-M: CH/S: Street Type	*
107	PRAEPCODE	☐	J_1SPRPCOD	J_1SPRPCOD	CHAR	2	0	IS-M: CH/S: Preposition Code	*
108	SPRCODE	☐	J_1SSPRCOD	J_1SC1	CHAR	1	0	IS-M: CH: Language Code
109	GRUNDPLZ	☐	J_1SGPLZ	J_1SGPLZ	NUMC	4	0	IS-M: CH: 4-Digit Basic Postal Code CH	*
110	ERWPLZ	☐	ERWPLZ	ERW_PLZ	CHAR	2	0	2-Digit Postal Code Extension CH
111	STRSTAMM	☐	J_1SSTRSTA	J_1SC10	CHAR	10	0	IS-M: CH/S: Street Master

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSTSTRUPDA	ADDRSECABBREV	TJS43	ADDRSECABBREV
2	JSTSTRUPDA	AENDNRAB	JSTAENDER	AENDNR
3	JSTSTRUPDA	AENDNRAKT	JSTAENDER	AENDNR
4	JSTSTRUPDA	AENDNRBIS	JSTAENDER	AENDNR
5	JSTSTRUPDA	AENDNRINIT	JSTAENDER	AENDNR
6	JSTSTRUPDA	AENDNRNACH	JSTAENDER	AENDNR
7	JSTSTRUPDA	AENDNRVON	JSTAENDER	AENDNR
8	JSTSTRUPDA	ALORT	JSTORTPRO	ALORT	KEY	1	CN
9	JSTSTRUPDA	ALORT_ALT	JSTORTPRO	ALORT	KEY	1	CN
10	JSTSTRUPDA	COUNTYNO	T005E	COUNC
11	JSTSTRUPDA	KREISG_SCH	JSTKGSPRO	KREISG_SCH	KEY	1	CN
12	JSTSTRUPDA	LAND1	T005	LAND1	KEY	1	CN
13	JSTSTRUPDA	LAND1_ALT	T005	LAND1	KEY	1	CN
14	JSTSTRUPDA	MANDT	T000	MANDT	KEY	1	CN
15	JSTSTRUPDA	OTL_KEY	JSTOTLPRO	OTL_KEY	KEY	1	CN
16	JSTSTRUPDA	PLZ_ZSTR	JSTPLZPRO	PLZNEU	KEY	1	CN
17	JSTSTRUPDA	POSTDIRECTIONAL	TJS41	DIRECTIONAL
18	JSTSTRUPDA	PREDIRECTIONAL	TJS41	DIRECTIONAL
19	JSTSTRUPDA	STATEABBREV	T005S	BLAND
20	JSTSTRUPDA	STRASSENNR	JSTSTRPRO	STRASSENNR	KEY	1	CN
21	JSTSTRUPDA	STRNR_ALT	JSTSTRPRO	STRASSENNR	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in