SAP ABAP Table J_1SPDA (IS-M/SD CH/S: Postal Code Data from Post for SAP Transfer)

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	INTTAB	Structure
Structure	J_1SPDA	Table Relationship Diagram
Short Description	IS-M/SD CH/S: Postal Code Data from Post for SAP Transfer

Delivery and Maintenance

Pool/cluster
Delivery Class
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	CHPLZ	☐	J_1SPLZCH	NUM06	NUMC	6	0	IS-M: CH: 6-Digit Postal Code CH
2	ORTSABK	☐	J_1SORTABK	J_1SC27	CHAR	27	0	IS-M: CH: City Abbreviation 27-Character
3	ORDNRP	☐	J_1SONRP	J_1SC5	CHAR	5	0	IS-M: Official number P (PTT) (CH)
4	KATEGORIE	☐	J_1SKATEG	J_1SKATEG	NUMC	4	0	IS-M: Category (CH)	*
5	X_ZUSTELL	☐	X_ZUSTELL	XFELD	CHAR	1	0	IS-M: Postal code for home delivery
6	X_POSTFACH	☐	X_POSTFACH	XFELD	CHAR	1	0	IS-M: Postal code for P.O.box
7	X_GRKUNDE	☐	X_GRKUNDE	XFELD	CHAR	1	0	IS-M: Postal code for major customer
8	X_GKGRUPPE	☐	X_GKGRUPPE	XFELD	CHAR	1	0	IS-M: Postal code for major customer group
9	X_MILITARY	☐	X_MILITARY	XFELD	CHAR	1	0	Military ZIP code
10	RUBRIKCOD	☐	J_1SRUBCOD	J_1SC2	CHAR	2	0	IS-M: Column code (CH)
11	ZDPLZ	☐	J_1SZDPLZ	J_1SC6	CHAR	6	0	IS-M: CH: Home Delivery for Postal Code
12	ZDORT	☐	J_1SZDORT	J_1SC18	CHAR	18	0	IS-M: CH: Home Delivery for City
13	HMEER	☐	J_1SHMEER	J_1SC4	CHAR	4	0	IS-M: CH: Height Above Sea Level
14	.INCLUDE	☐				0	0	IS-M/SD CH/S: Include Record Type 102 PCd PTT
15	GDATUM	☐	J_1SGKDAT	J_1SC6	CHAR	6	0	IS-M: CH: Validity Date YYMMDD
16	KANTON	☐	J_1SKANTON	J_1SC2	CHAR	2	0	IS-M: CH: Canton
17	KANTONABW	☐	J_1SKANTAB	J_1SC2	CHAR	2	0	IS-M: Alternative Canton (CH)
18	SPRCODE1	☐	J_1SSPRCO1	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 1
19	SPRCODE2	☐	J_1SSPRCO2	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 2
20	SPRCODE3	☐	J_1SSPRCO3	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 3
21	TELDIR	☐	J_1SDIRPTT	J_1SC2	CHAR	2	0	IS-M: CH: Telecom Direction PTT
22	TELDIRABW	☐	J_1SDIRPAW	J_1SC2	CHAR	2	0	IS-M: CH: Telecom Direction PTT (Deviation)
23	TELBCHNR	☐	J_1STELBNR	J_1SC2	CHAR	2	0	IS-M: CH: Telephone Book Number
24	TELBCHNRAB	☐	J_1STELBAW	J_1SC2	CHAR	2	0	IS-M: CH: Telephone Book Number (Deviation)
25	NETZGRP	☐	J_1SNETZGR	J_1SC3	CHAR	3	0	IS-M: CH: Network Group
26	NETZGRPABW	☐	J_1SNETZAW	J_1SC3	CHAR	3	0	IS-M: CH: Network Group (Deviation)
27	KRPOSTDIR	☐	J_1SKPDIR	J_1SC2	CHAR	2	0	IS-M: CH: Regional Postal Structure
28	KZBOTENF	☐	J_1SZUBOTF	J_1SC1	CHAR	1	0	IS-M: CH: Existing Membership in Carrier File
29	SORTPOSTST	☐	J_1SSORPST	J_1SC5	CHAR	5	0	IS-M: CH: Alpha Sort Value for Post Office
30	ORTSCODE	☐	J_1SORTCOD	J_1SC4	CHAR	4	0	IS-M: CH: City Code
31	MUTDATUM	☐	J_1SMUTDAT	J_1SC6	CHAR	6	0	IS-M: CH: Date of Last Change
32	KZHAUSHALT	☐	J_1SKZHAUS	J_1SC1	CHAR	1	0	IS-M: CH: Check Byte for Household
33	.INCLUDE	☐				0	0	IS-M/SD CH/S: Include Record Type 200 PCd PTT
34	GEMEINDENR	☐	J_1SGNRBFS	CHAR5KONV	CHAR	5	0	IS-M: CH: Municipality Number from Federal Statistics Office
35	GEMEINDENA	☐	J_1SGEMNAM	J_1SC18	CHAR	18	0	IS-M: CH: Municipality Name
36	AGGLOMNR	☐	J_1SAGGLNR	CHAR5KONV	CHAR	5	0	IS-M: CH: Agglomeration Number
37	AGGLOMNAME	☐	J_1SAGGLNA	J_1SC18	CHAR	18	0	IS-M: Name of agglomeration (CH)
38	KANTONPLRE	☐	J_1SKPLREG	J_1SC4	CHAR	4	0	IS-M: Canton planning region (CH)
39	ALPHASORTG	☐	J_1SALSOGE	J_1SC5	CHAR	5	0	IS-M: CH: Alpha Sort Value for Municipality
40	.INCLUDE	☐				0	0	IS-M/SD CH/S: Include Record Type 500 PTT PCodes
41	STADTTOTHH	☐	J_1SSTADTH	J_1SC4	CHAR	4	0	IS-M: CH: City Household Total
42	SPRACODEH1	☐	J_1SSPRCH1	J_1SC1	CHAR	1	0	IS-M: CH: Language Code Household 1
43	KANTONHH1	☐	J_1SKANTH1	J_1SC2	CHAR	2	0	IS-M: CH: Canton Household 1
44	ANZAHLHP1	☐	J_1SANZHP1	J_1SC7	CHAR	7	0	IS-M: CH: Number of Households PTT 1
45	LEER71	☐	J_1SLEER7	J_1SC7	CHAR	7	0	IS-M: CH: Blank Field 7 Characters Long (Default '0000000')
46	ANZAHLFA1	☐	J_1SANZFA1	J_1SC5	CHAR	5	0	IS-M: CH: Number of PO Boxes 1
47	LEER51	☐	J_1SLEER5	J_1SC5	CHAR	5	0	IS-M: CH: Blank Field 5 Characters Long (Default '00000')
48	SPRACODEH2	☐	J_1SSPRCH2	J_1SC1	CHAR	1	0	IS-M: CH: Language Code Household 2
49	KANTONHH2	☐	J_1SKANTH2	J_1SC2	CHAR	2	0	IS-M: CH: Canton Household 2
50	ANZAHLHP2	☐	J_1SANZHP2	J_1SC7	CHAR	7	0	IS-M: CH: Number of Households PTT 2
51	LEER72	☐	J_1SLEER7	J_1SC7	CHAR	7	0	IS-M: CH: Blank Field 7 Characters Long (Default '0000000')
52	ANZAHLFA2	☐	J_1SANZFA2	J_1SC5	CHAR	5	0	IS-M: CH: Number of PO Boxes 2
53	LEER52	☐	J_1SLEER5	J_1SC5	CHAR	5	0	IS-M: CH: Blank Field 5 Characters Long (Default '00000')
54	SPRACODEH3	☐	J_1SSPRCH3	J_1SC1	CHAR	1	0	IS-M: CH: Language Code Household 3
55	KANTONHH3	☐	J_1SKANTH3	J_1SC2	CHAR	2	0	IS-M: CH: Canton Household 3
56	ANZAHLHP3	☐	J_1SANZHP3	J_1SC7	CHAR	7	0	IS-M: CH: Number of Households PTT 3
57	LEER73	☐	J_1SLEER7	J_1SC7	CHAR	7	0	IS-M: CH: Blank Field 7 Characters Long (Default '0000000')
58	ANZAHLFA3	☐	J_1SANZFA3	J_1SC5	CHAR	5	0	IS-M: CH: Number of PO Boxes 3
59	LEER53	☐	J_1SLEER5	J_1SC5	CHAR	5	0	IS-M: CH: Blank Field 5 Characters Long (Default '00000')
60	UPDSEQ	☐	J_1SLFNRMU	J_1SC5	CHAR	5	0	IS-M: CH: Run Number for Changes
61	MUTCODE	☐	J_1SMUTCOD	J_1SC1	CHAR	1	0	JS-MSD CH: Change Code
62	ERSPLZPF	☐	J_1SPLZCH	NUM06	NUMC	6	0	IS-M: CH: 6-Digit Postal Code CH
63	ERSONRPPF	☐	J_1SONRP	J_1SC5	CHAR	5	0	IS-M: Official number P (PTT) (CH)
64	ERSPLZDOM	☐	J_1SPLZCH	NUM06	NUMC	6	0	IS-M: CH: 6-Digit Postal Code CH
65	ERSONRPDOM	☐	J_1SONRP	J_1SC5	CHAR	5	0	IS-M: Official number P (PTT) (CH)

History

Last changed by/on	SAP	20110810
SAP Release Created in