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
⤷ 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 |