SAP ABAP Table J_1SPLZPRO (IS-M/SD CH/S: CH Postal Codes)
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_1SPLZPRO   Table Relationship Diagram
Short Description IS-M/SD CH/S: CH Postal Codes    
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 T005
2 PLZNEU PLZNEU NPSTLZ CHAR 10   0   IS-M: Postal code JSTPLZPRO
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) J_1STJ1S0
5 RUBRIKCOD J_1SRUBCOD J_1SC2 CHAR 2   0   IS-M: Column code (CH)  
6 ZDPLZ PLZNEU NPSTLZ CHAR 10   0   IS-M: Postal code JSTPLZPRO
7 ZDORT J_1SZDORT J_1SC18 CHAR 18   0   IS-M: CH: Home Delivery for City  
8 HMEER J_1SHMEER J_1SC4 CHAR 4   0   IS-M: CH: Height Above Sea Level  
9 X_FEHLERH X_FEHLER ANKREUZ CHAR 1   0   IS-M: Incorrect data record  
10 .INCLUDE       0   0   IS-M/SD CH/S: Include Record Type 102 PCd PTT  
11 GDATUM J_1SGKDAT J_1SC6 CHAR 6   0   IS-M: CH: Validity Date YYMMDD  
12 KANTON J_1SKANTON J_1SC2 CHAR 2   0   IS-M: CH: Canton  
13 KANTONABW J_1SKANTAB J_1SC2 CHAR 2   0   IS-M: Alternative Canton (CH)  
14 SPRCODE1 J_1SSPRCO1 J_1SC1 CHAR 1   0   IS-M: CH: Language Code 1  
15 SPRCODE2 J_1SSPRCO2 J_1SC1 CHAR 1   0   IS-M: CH: Language Code 2  
16 SPRCODE3 J_1SSPRCO3 J_1SC1 CHAR 1   0   IS-M: CH: Language Code 3  
17 TELDIR J_1SDIRPTT J_1SC2 CHAR 2   0   IS-M: CH: Telecom Direction PTT  
18 TELDIRABW J_1SDIRPAW J_1SC2 CHAR 2   0   IS-M: CH: Telecom Direction PTT (Deviation)  
19 TELBCHNR J_1STELBNR J_1SC2 CHAR 2   0   IS-M: CH: Telephone Book Number  
20 TELBCHNRAB J_1STELBAW J_1SC2 CHAR 2   0   IS-M: CH: Telephone Book Number (Deviation)  
21 NETZGRP J_1SNETZGR J_1SC3 CHAR 3   0   IS-M: CH: Network Group  
22 NETZGRPABW J_1SNETZAW J_1SC3 CHAR 3   0   IS-M: CH: Network Group (Deviation)  
23 KRPOSTDIR J_1SKPDIR J_1SC2 CHAR 2   0   IS-M: CH: Regional Postal Structure  
24 KZBOTENF J_1SZUBOTF J_1SC1 CHAR 1   0   IS-M: CH: Existing Membership in Carrier File  
25 SORTPOSTST J_1SSORPST J_1SC5 CHAR 5   0   IS-M: CH: Alpha Sort Value for Post Office  
26 ORTSCODE J_1SORTCOD J_1SC4 CHAR 4   0   IS-M: CH: City Code  
27 MUTDATUM J_1SMUTDAT J_1SC6 CHAR 6   0   IS-M: CH: Date of Last Change  
28 KZHAUSHALT J_1SKZHAUS J_1SC1 CHAR 1   0   IS-M: CH: Check Byte for Household  
29 .INCLUDE       0   0   IS-M/SD CH/S: Include Record Type 200 PCd PTT  
30 GEMEINDENR J_1SGNRBFS CHAR5KONV CHAR 5   0   IS-M: CH: Municipality Number from Federal Statistics Office  
31 GEMEINDENA J_1SGEMNAM J_1SC18 CHAR 18   0   IS-M: CH: Municipality Name  
32 AGGLOMNR J_1SAGGLNR CHAR5KONV CHAR 5   0   IS-M: CH: Agglomeration Number  
33 AGGLOMNAME J_1SAGGLNA J_1SC18 CHAR 18   0   IS-M: Name of agglomeration (CH)  
34 KANTONPLRE J_1SKPLREG J_1SC4 CHAR 4   0   IS-M: Canton planning region (CH)  
35 ALPHASORTG J_1SALSOGE J_1SC5 CHAR 5   0   IS-M: CH: Alpha Sort Value for Municipality  
36 .INCLUDE       0   0   IS-M/SD CH/S: Include Record Type 500 PTT PCodes  
37 STADTTOTHH J_1SSTADTH J_1SC4 CHAR 4   0   IS-M: CH: City Household Total  
38 SPRACODEH1 J_1SSPRCH1 J_1SC1 CHAR 1   0   IS-M: CH: Language Code Household 1  
39 KANTONHH1 J_1SKANTH1 J_1SC2 CHAR 2   0   IS-M: CH: Canton Household 1  
40 ANZAHLHP1 J_1SANZHP1 J_1SC7 CHAR 7   0   IS-M: CH: Number of Households PTT 1  
41 LEER71 J_1SLEER7 J_1SC7 CHAR 7   0   IS-M: CH: Blank Field 7 Characters Long (Default '0000000')  
42 ANZAHLFA1 J_1SANZFA1 J_1SC5 CHAR 5   0   IS-M: CH: Number of PO Boxes 1  
43 LEER51 J_1SLEER5 J_1SC5 CHAR 5   0   IS-M: CH: Blank Field 5 Characters Long (Default '00000')  
44 SPRACODEH2 J_1SSPRCH2 J_1SC1 CHAR 1   0   IS-M: CH: Language Code Household 2  
45 KANTONHH2 J_1SKANTH2 J_1SC2 CHAR 2   0   IS-M: CH: Canton Household 2  
46 ANZAHLHP2 J_1SANZHP2 J_1SC7 CHAR 7   0   IS-M: CH: Number of Households PTT 2  
47 LEER72 J_1SLEER7 J_1SC7 CHAR 7   0   IS-M: CH: Blank Field 7 Characters Long (Default '0000000')  
48 ANZAHLFA2 J_1SANZFA2 J_1SC5 CHAR 5   0   IS-M: CH: Number of PO Boxes 2  
49 LEER52 J_1SLEER5 J_1SC5 CHAR 5   0   IS-M: CH: Blank Field 5 Characters Long (Default '00000')  
50 SPRACODEH3 J_1SSPRCH3 J_1SC1 CHAR 1   0   IS-M: CH: Language Code Household 3  
51 KANTONHH3 J_1SKANTH3 J_1SC2 CHAR 2   0   IS-M: CH: Canton Household 3  
52 ANZAHLHP3 J_1SANZHP3 J_1SC7 CHAR 7   0   IS-M: CH: Number of Households PTT 3  
53 LEER73 J_1SLEER7 J_1SC7 CHAR 7   0   IS-M: CH: Blank Field 7 Characters Long (Default '0000000')  
54 ANZAHLFA3 J_1SANZFA3 J_1SC5 CHAR 5   0   IS-M: CH: Number of PO Boxes 3  
55 LEER53 J_1SLEER5 J_1SC5 CHAR 5   0   IS-M: CH: Blank Field 5 Characters Long (Default '00000')  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1SPLZPRO KATEGORIE J_1STJ1S0 KATEGORIE    
2 J_1SPLZPRO LAND1 T005 LAND1    
3 J_1SPLZPRO PLZNEU JSTPLZPRO PLZNEU KEY 1 CN
4 J_1SPLZPRO ZDPLZ JSTPLZPRO PLZNEU KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in