SAP ABAP Table JSPLZZUOUPDA (Change Records PCd 4-/6-Digit (Postal Data CH))

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	TRANSP	Transparent table
Transparent table	JSPLZZUOUPDA	Table Relationship Diagram
Short Description	Change Records PCd 4-/6-Digit (Postal Data CH)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	LAND1_ALT	☑	LAND1	LAND1	CHAR	3	0	Country Key	*
3	PLZNEU_ALT	☑	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	JSTPLZPRO
4	PLZPTT6_ALT	☑	PLZPTT6	PLZPTT6D	CHAR	6	0	6-Digit Postal Code CH
5	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	*
6	PLZNEU	☑	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	JSTPLZPRO
7	PLZPTT6	☑	PLZPTT6	PLZPTT6D	CHAR	6	0	6-Digit Postal Code CH
8	ORDNRP	☐	J_1SONRP	J_1SC5	CHAR	5	0	IS-M: Official number P (PTT) (CH)
9	ZDPLZ	☐	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	JSTPLZPRO
10	GRUNDPLZ	☐	J_1SGPLZ	J_1SGPLZ	NUMC	4	0	IS-M: CH: 4-Digit Basic Postal Code CH	*
11	.INCLUDE	☐				0	0	Type of postal code for usage
12	X_ZUSTELL	☐	X_ZUSTELL	XFELD	CHAR	1	0	IS-M: Postal code for home delivery
13	X_POSTFACH	☐	X_POSTFACH	XFELD	CHAR	1	0	IS-M: Postal code for P.O.box
14	X_GRKUNDE	☐	X_GRKUNDE	XFELD	CHAR	1	0	IS-M: Postal code for major customer
15	X_GKGRUPPE	☐	X_GKGRUPPE	XFELD	CHAR	1	0	IS-M: Postal code for major customer group
16	X_AKTION	☐	X_AKTION	XFELD	CHAR	1	0	Indicator: Sales Promotion Postal Code
17	X_SCHALTER	☐	X_SCHALTER	XFELD	CHAR	1	0	Indicator: Postal code for counter collection
18	X_MILITARY	☐	X_MILITARY	XFELD	CHAR	1	0	Military ZIP code
19	ZDORT	☐	J_1SZDORT	J_1SC18	CHAR	18	0	IS-M: CH: Home Delivery for City
20	KANTON	☐	J_1SKANTON	J_1SC2	CHAR	2	0	IS-M: CH: Canton
21	SPRCODE1	☐	J_1SSPRCO1	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 1
22	SPRCODE2	☐	J_1SSPRCO2	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 2
23	KZBOTENF	☐	J_1SZUBOTF	J_1SC1	CHAR	1	0	IS-M: CH: Existing Membership in Carrier File
24	GEMEINDENR	☐	J_1SGNRBFS	CHAR5KONV	CHAR	5	0	IS-M: CH: Municipality Number from Federal Statistics Office
25	GEMEINDENA	☐	J_1SGEMNAM	J_1SC18	CHAR	18	0	IS-M: CH: Municipality Name
26	AGGLOMNR	☐	J_1SAGGLNR	CHAR5KONV	CHAR	5	0	IS-M: CH: Agglomeration Number
27	KANTONPLRE	☐	J_1SKPLREG	J_1SC4	CHAR	4	0	IS-M: Canton planning region (CH)
28	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
29	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
30	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
31	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
32	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
33	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
34	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
35	.INCLUDE	☐				0	0	IS-PSD: Update Indicator for Postal Upgrade
36	DBCODE_ALT	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
37	DBCODE_NEU	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
38	X_ADRESSEN	☐	X_ADRESSEN	XFELD	CHAR	1	0	IS-M: Update indicator: relevant addresses revised
39	X_STRUKTUR	☐	X_STRUKTUR	XFELD	CHAR	1	0	IS-M: Update indicator, related structures revised
40	X_POST_DB	☐	X_POST_DB	XFELD	CHAR	1	0	IS-M: Update indicator, postal DB edited
41	.INCLUDE	☐				0	0	Change data for structural changes etc.
42	.INCLUDE	☐				0	0	Change data: Standard references
43	AENDNRBIS	☐	AENDNRBIS	AENDNR	CHAR	9	0	Change Number for To-Date of Structural Change	JSTAENDER
44	AENDNRBISD	☐	AENDNRBISD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change To-Date
45	AENDNRAB	☐	AENDNRAB	AENDNR	CHAR	9	0	Change Number for From-Date of Structure Change	JSTAENDER
46	AENDNRABD	☐	AENDNRABD	AENDNRARTD	CHAR	1	0	Date of Change Number Used to Change From-Date
47	AENDNRINIT	☐	AENDNRINIT	AENDNR	CHAR	9	0	Initiating Change Number	JSTAENDER
48	AENDLFDNRI	☐	AENDLFDNRI	AENDLFDNR	NUMC	4	0	Sequence Number of Initiating Change Number
49	AENDNRAKT	☐	AENDNRAKT	AENDNR	CHAR	9	0	Change Number in Process	JSTAENDER
50	AENDLFDNRA	☐	AENDLFDNRA	AENDLFDNR	NUMC	4	0	Sequence Number of Currently Operative Change Number
51	XAENDER	☐	XAENDER	XFELD	CHAR	1	0	Structure information being changed on other change number
52	XSTRUAKTIV	☐	XSTRUAKTIV	XSTRUAKTIV	CHAR	1	0	Structure information inactive
53	FCCODE	☐	FCCODE	FCCODE	CHAR	2	0	Function Control Code for Structure Changes
54	DBCODEFREI	☐	DBCODE	DBCODE	CHAR	1	0	DB Code for Structural Changes
55	.INCLUDE	☐				0	0	Change data: Reassignment statements
56	AENDNRVON	☐	AENDNRVON	AENDNR	CHAR	9	0	Change Number Used for Transfer FROM Another Assignment	JSTAENDER
57	AENDLFDNRV	☐	AENDLFDNRV	AENDLFDNR	NUMC	4	0	Sequence Number of Change Number Used for Transfer
58	AENDNRNACH	☐	AENDNRNACH	AENDNR	CHAR	9	0	Change Number Used to Transfer to Another Assignment	JSTAENDER
59	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	JSPLZZUOUPDA	AENDNRAB	JSTAENDER	AENDNR
2	JSPLZZUOUPDA	AENDNRAKT	JSTAENDER	AENDNR
3	JSPLZZUOUPDA	AENDNRBIS	JSTAENDER	AENDNR
4	JSPLZZUOUPDA	AENDNRINIT	JSTAENDER	AENDNR
5	JSPLZZUOUPDA	AENDNRNACH	JSTAENDER	AENDNR
6	JSPLZZUOUPDA	AENDNRVON	JSTAENDER	AENDNR
7	JSPLZZUOUPDA	PLZNEU	JSTPLZPRO	PLZNEU
8	JSPLZZUOUPDA	PLZNEU_ALT	JSTPLZPRO	PLZNEU
9	JSPLZZUOUPDA	ZDPLZ	JSTPLZPRO	PLZNEU

History

Last changed by/on	SAP	20130529
SAP Release Created in	471