SAP ABAP Table JSTORTUPDA (IS-M/SD: Table for Upgrade of Table JSTORTPRO)

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	JSTORTUPDA	Table Relationship Diagram
Short Description	IS-M/SD: Table for Upgrade of Table JSTORTPRO

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	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
5	ALORT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
6	.INCLUDE	☐				0	0	IS-PSD: Include with Attributes of Table JSTORTPRO
7	SUCHFELDO	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
8	ORT_NAME_K	☐	ORT_NAME_K	TEXT25	CHAR	25	0	IS-M: City Name (Short Text)
9	ORT_NAME_L	☐	ORT_NAME_L	TEXT50	CHAR	50	0	IS-M: City name (long text)
10	ORT_NAME_G	☐	ORT_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: City name in block capitals
11	ORT_NAME_S	☐	ORT_NAME_S	CHAR50	CHAR	50	0	IS-M: City Name (Long Text, No Special Characters)
12	ORTZUSA	☐	ORTZUSA	TEXT30	CHAR	30	0	IS-M: Affix for City Name
13	KREISG_SCH	☐	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key	*
14	HERKKZORT	☐	HERKZORT	HERKUNFTKZ	CHAR	1	0	IS-M: Origin Indicator for City	TJS31
15	HERKKZSTR	☐	HERKZSTR	HERKUNFTKZ	CHAR	1	0	IS-M: Origin Indicator for Street File	TJS31
16	XSTRMANUEL	☐	XSTRMANUEL	XFELD	CHAR	1	0	IS-M: Additional Streets were Entered Manually
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	TJS00
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 JSTORTPRO for US Country Version
34	CITYSTATEFACCODE	☐	CITYSTATEFACCODE	CITYSTATEFACCODE	CHAR	1	0	Type of Location Defined by the City Name
35	PREFCITYSTATEKEY	☐	PREFCITYSTATEKEY	CHAR06	CHAR	6	0	Preferred city number from city state product file
36	PREFCITYSTNAME	☐	PREFCITYSTNAME	TEXT28	CHAR	28	0	Preferred city name
37	CITYDELIND	☐	CITYDELIND	CHAR01	CHAR	1	0	Indicates Whether Carrier Routes Defined
38	CARRRTESORTIND	☐	CARRRTESORTIND	CHAR01	CHAR	1	0	Indicates Whether Price Reduction Possible for Letter Post
39	UNIQUEZIPIND	☐	UNIQUEZIPIND	CHAR01	CHAR	1	0	Indicates Whether or not ZIP Code is Unique
40	FINANCENO	☐	FINANCENO	CHAR06	CHAR	6	0	Finance Number; Required by USPS
41	STATEABBREV	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
42	COUNTYNO	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
43	ORT_NAME_AL	☐	ORT_NAME_AL	TEXT50	CHAR	50	0	IS-M: Alternative City Name
44	.INCLU--AP	☐				0	0	Structure for Additional City Fields (NL)
45	CEBUCOCODE	☐	CEBUCOCODE	CEBUCOCODE	CHAR	3	0	Cebuco Code	*
46	CITYNAME_NEN	☐	CITYNAME_NEN	CHAR24	CHAR	24	0	City Name (NEN Standard)
47	ORTNAMEALT	☐	ORT_NAME_L	TEXT50	CHAR	50	0	IS-M: City name (long text)
48	.INCLUDE	☐				0	0	IS-PSD: Update Indicator for Postal Upgrade
49	DBCODE_ALT	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
50	DBCODE_NEU	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
51	X_ADRESSEN	☐	X_ADRESSEN	XFELD	CHAR	1	0	IS-M: Update indicator: relevant addresses revised
52	X_STRUKTUR	☐	X_STRUKTUR	XFELD	CHAR	1	0	IS-M: Update indicator, related structures revised
53	X_POST_DB	☐	X_POST_DB	XFELD	CHAR	1	0	IS-M: Update indicator, postal DB edited
54	.INCLUDE	☐				0	0	Change data for structural changes etc.
55	.INCLUDE	☐				0	0	Change data: Standard references
56	AENDNRBIS	☐	AENDNRBIS	AENDNR	CHAR	9	0	Change Number for To-Date of Structural Change	JSTAENDER
57	AENDNRBISD	☐	AENDNRBISD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change To-Date
58	AENDNRAB	☐	AENDNRAB	AENDNR	CHAR	9	0	Change Number for From-Date of Structure Change	JSTAENDER
59	AENDNRABD	☐	AENDNRABD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change From-Date
60	AENDNRINIT	☐	AENDNRINIT	AENDNR	CHAR	9	0	Initiating Change Number	JSTAENDER
61	AENDLFDNRI	☐	AENDLFDNRI	AENDLFDNR	NUMC	4	0	Sequence Number of Initiating Change Number
62	AENDNRAKT	☐	AENDNRAKT	AENDNR	CHAR	9	0	Change Number in Process	JSTAENDER
63	AENDLFDNRA	☐	AENDLFDNRA	AENDLFDNR	NUMC	4	0	Sequence Number of Currently Operative Change Number
64	XAENDER	☐	XAENDER	XFELD	CHAR	1	0	Structure information being changed on other change number
65	XSTRUAKTIV	☐	XSTRUAKTIV	XSTRUAKTIV	CHAR	1	0	Structure information inactive
66	FCCODE	☐	FCCODE	FCCODE	CHAR	2	0	Function Control Code for Structure Changes
67	DBCODEFREI	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
68	.INCLUDE	☐				0	0	Change data: Reassignment statements
69	AENDNRVON	☐	AENDNRVON	AENDNR	CHAR	9	0	Change Number Used for Transfer FROM Another Assignment	JSTAENDER
70	AENDLFDNRV	☐	AENDLFDNRV	AENDLFDNR	NUMC	4	0	Sequence Number of Change Number Used for Transfer
71	AENDNRNACH	☐	AENDNRNACH	AENDNR	CHAR	9	0	Change Number Used to Transfer to Another Assignment	JSTAENDER
72	AENDLFDNRN	☐	AENDLFDNRN	AENDLFDNR	NUMC	4	0	Sequence Number of Change Number Used for Transfer

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSTORTUPDA	AENDNRAB	JSTAENDER	AENDNR
2	JSTORTUPDA	AENDNRAKT	JSTAENDER	AENDNR
3	JSTORTUPDA	AENDNRBIS	JSTAENDER	AENDNR
4	JSTORTUPDA	AENDNRINIT	JSTAENDER	AENDNR
5	JSTORTUPDA	AENDNRNACH	JSTAENDER	AENDNR
6	JSTORTUPDA	AENDNRVON	JSTAENDER	AENDNR
7	JSTORTUPDA	ALORT_ALT	JSTORTPRO	ALORT	KEY	1	CN
8	JSTORTUPDA	COUNTYNO	T005E	COUNC
9	JSTORTUPDA	HERKKZORT	TJS31	HERKUNFTKZ	KEY	1	CN
10	JSTORTUPDA	HERKKZSTR	TJS31	HERKUNFTKZ	KEY	1	CN
11	JSTORTUPDA	LAND1	T005	LAND1	KEY	1	CN
12	JSTORTUPDA	LAND1_ALT	T005	LAND1	KEY	1	CN
13	JSTORTUPDA	MANDT	T000	MANDT	KEY	1	CN
14	JSTORTUPDA	STATEABBREV	T005S	BLAND
15	JSTORTUPDA	VERSION_NR	TJS00	VERSION_T

History

Last changed by/on	SAP	20130529
SAP Release Created in