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