SAP ABAP Table JSTPOFUPDA (IS-M/SD: Table for Upgrade of Table JSTPOFPRO)

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

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	PNRVON_ALT	☑	PFNRVON	NUMC10	NUMC	10	0	IS-M: From P.O. box number
5	PNRBIS_ALT	☑	PFNRBIS	NUMC10	NUMC	10	0	IS-M: To P.O. box number
6	PLZNEU_ALT	☑	PLZNEU_P	NPSTLZ	CHAR	10	0	IS-M: Postal code for P.O. box rack	JSTPLZPRO
7	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
8	ALORT	☑	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
9	PFNRVON	☑	PFNRVON	NUMC10	NUMC	10	0	IS-M: From P.O. box number
10	PFNRBIS	☑	PFNRBIS	NUMC10	NUMC	10	0	IS-M: To P.O. box number
11	PLZNEU_P	☑	PLZNEU_P	NPSTLZ	CHAR	10	0	IS-M: Postal code for P.O. box rack	JSTPLZPRO
12	.INCLUDE	☐				0	0	Include with attributes of table JSTPOFPRO
13	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
14	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
15	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
16	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
17	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
18	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
19	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
20	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
21	.INCLUDE	☐				0	0	Version (for upgrade procedures for postal data)
22	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
23	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
24	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
25	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number	*
26	.INCLUDE	☐				0	0	IS-M: Structure for Enhanced Address Data
27	.INCLUDE	☐				0	0	Secondary Address (Without ZIP Add-On)
28	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
29	ADDRSECNUMLOW	☐	ADDRSECNUMLOW	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number (Lower Limit)
30	ADDRSECNUMHIGH	☐	ADDRSECNUMHIGH	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
31	ADDRSECODDEVEN	☐	ADDRSECODDEVEN	ODDEVENCODE	CHAR	1	0	IS-M: Odd/Even Indicator for Secondary Address Number
32	ZIPADDONLOW	☐	JZIPADDONLOW	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (lower limit)
33	ZIPADDONHIGH	☐	JZIPADDONHIGH	CHAR4	CHAR	4	0	IS-M: Extension of 5-digit ZIP code (upper limit)
34	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
35	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
36	.INCLUDE	☐				0	0	IS-PSD: Update Indicator for Postal Upgrade
37	DBCODE_ALT	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
38	DBCODE_NEU	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
39	X_ADRESSEN	☐	X_ADRESSEN	XFELD	CHAR	1	0	IS-M: Update indicator: relevant addresses revised
40	X_STRUKTUR	☐	X_STRUKTUR	XFELD	CHAR	1	0	IS-M: Update indicator, related structures revised
41	X_POST_DB	☐	X_POST_DB	XFELD	CHAR	1	0	IS-M: Update indicator, postal DB edited
42	.INCLUDE	☐				0	0	Change data for structural changes etc.
43	.INCLUDE	☐				0	0	Change data: Standard references
44	AENDNRBIS	☐	AENDNRBIS	AENDNR	CHAR	9	0	Change Number for To-Date of Structural Change	JSTAENDER
45	AENDNRBISD	☐	AENDNRBISD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change To-Date
46	AENDNRAB	☐	AENDNRAB	AENDNR	CHAR	9	0	Change Number for From-Date of Structure Change	JSTAENDER
47	AENDNRABD	☐	AENDNRABD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change From-Date
48	AENDNRINIT	☐	AENDNRINIT	AENDNR	CHAR	9	0	Initiating Change Number	JSTAENDER
49	AENDLFDNRI	☐	AENDLFDNRI	AENDLFDNR	NUMC	4	0	Sequence Number of Initiating Change Number
50	AENDNRAKT	☐	AENDNRAKT	AENDNR	CHAR	9	0	Change Number in Process	JSTAENDER
51	AENDLFDNRA	☐	AENDLFDNRA	AENDLFDNR	NUMC	4	0	Sequence Number of Currently Operative Change Number
52	XAENDER	☐	XAENDER	XFELD	CHAR	1	0	Structure information being changed on other change number
53	XSTRUAKTIV	☐	XSTRUAKTIV	XSTRUAKTIV	CHAR	1	0	Structure information inactive
54	FCCODE	☐	FCCODE	FCCODE	CHAR	2	0	Function Control Code for Structure Changes
55	DBCODEFREI	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
56	.INCLUDE	☐				0	0	Change data: Reassignment statements
57	AENDNRVON	☐	AENDNRVON	AENDNR	CHAR	9	0	Change Number Used for Transfer FROM Another Assignment	JSTAENDER
58	AENDLFDNRV	☐	AENDLFDNRV	AENDLFDNR	NUMC	4	0	Sequence Number of Change Number Used for Transfer
59	AENDNRNACH	☐	AENDNRNACH	AENDNR	CHAR	9	0	Change Number Used to Transfer to Another Assignment	JSTAENDER
60	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	JSTPOFUPDA	ADDRSECABBREV	TJS43	ADDRSECABBREV
2	JSTPOFUPDA	AENDNRAB	JSTAENDER	AENDNR
3	JSTPOFUPDA	AENDNRAKT	JSTAENDER	AENDNR
4	JSTPOFUPDA	AENDNRBIS	JSTAENDER	AENDNR
5	JSTPOFUPDA	AENDNRINIT	JSTAENDER	AENDNR
6	JSTPOFUPDA	AENDNRNACH	JSTAENDER	AENDNR
7	JSTPOFUPDA	AENDNRVON	JSTAENDER	AENDNR
8	JSTPOFUPDA	ALORT	JSTORTPRO	ALORT	KEY	1	CN
9	JSTPOFUPDA	ALORT_ALT	JSTORTPRO	ALORT	KEY	1	CN
10	JSTPOFUPDA	LAND1	T005	LAND1	KEY	1	CN
11	JSTPOFUPDA	LAND1_ALT	T005	LAND1	KEY	1	CN
12	JSTPOFUPDA	MANDT	T000	MANDT	KEY	1	CN
13	JSTPOFUPDA	PLZNEU_ALT	JSTPLZPRO	PLZNEU	KEY	1	CN
14	JSTPOFUPDA	PLZNEU_P	JSTPLZPRO	PLZNEU	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in