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