SAP ABAP Table J_1SPLZZUO (Assignment: 4-Digit PCode - 6-Digit PCode (CH Postal Data))

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ J1SC (Package) IS-M/SD CH: Development of Swiss Version

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1SPLZZUO	Table Relationship Diagram
Short Description	Assignment: 4-Digit PCode - 6-Digit PCode (CH Postal Data)

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	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	*
2	PLZNEU	☑	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	*
3	PLZPTT6	☑	PLZPTT6	PLZPTT6D	CHAR	6	0	6-Digit Postal Code CH
4	ORDNRP	☐	J_1SONRP	J_1SC5	CHAR	5	0	IS-M: Official number P (PTT) (CH)
5	ZDPLZ	☐	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	*
6	GRUNDPLZ	☐	J_1SGPLZ	J_1SGPLZ	NUMC	4	0	IS-M: CH: 4-Digit Basic Postal Code CH	*
7	.INCLUDE	☐				0	0	Type of postal code for usage
8	X_ZUSTELL	☐	X_ZUSTELL	XFELD	CHAR	1	0	IS-M: Postal code for home delivery
9	X_POSTFACH	☐	X_POSTFACH	XFELD	CHAR	1	0	IS-M: Postal code for P.O.box
10	X_GRKUNDE	☐	X_GRKUNDE	XFELD	CHAR	1	0	IS-M: Postal code for major customer
11	X_GKGRUPPE	☐	X_GKGRUPPE	XFELD	CHAR	1	0	IS-M: Postal code for major customer group
12	X_AKTION	☐	X_AKTION	XFELD	CHAR	1	0	Indicator: Sales Promotion Postal Code
13	X_SCHALTER	☐	X_SCHALTER	XFELD	CHAR	1	0	Indicator: Postal code for counter collection
14	X_MILITARY	☐	X_MILITARY	XFELD	CHAR	1	0	Military ZIP code
15	ZDORT	☐	J_1SZDORT	J_1SC18	CHAR	18	0	IS-M: CH: Home Delivery for City
16	KANTON	☐	J_1SKANTON	J_1SC2	CHAR	2	0	IS-M: CH: Canton
17	SPRCODE1	☐	J_1SSPRCO1	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 1
18	SPRCODE2	☐	J_1SSPRCO2	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 2
19	KZBOTENF	☐	J_1SZUBOTF	J_1SC1	CHAR	1	0	IS-M: CH: Existing Membership in Carrier File
20	GEMEINDENR	☐	J_1SGNRBFS	CHAR5KONV	CHAR	5	0	IS-M: CH: Municipality Number from Federal Statistics Office
21	GEMEINDENA	☐	J_1SGEMNAM	J_1SC18	CHAR	18	0	IS-M: CH: Municipality Name
22	AGGLOMNR	☐	J_1SAGGLNR	CHAR5KONV	CHAR	5	0	IS-M: CH: Agglomeration Number
23	KANTONPLRE	☐	J_1SKPLREG	J_1SC4	CHAR	4	0	IS-M: Canton planning region (CH)
24	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
25	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
26	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
27	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
28	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
29	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
30	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
31	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution

History

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