SAP ABAP Table J_1SPUPBESTAND (IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet)
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_1SPUPBESTAND | Table Relationship Diagram |
Short Description | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ORDNRP | J_1SONRP | J_1SC5 | CHAR | 5 | 0 | IS-M: Official number P (PTT) (CH) | ||
3 | TABELLE | J_1SUPDATAB | J_1SUPDATAB | CHAR | 10 | 0 | CH Postal Upgrade Table | ||
4 | FUNCTION | J_1SUPDAFUNC | J_1SUPDAFUNC | CHAR | 2 | 0 | CH Postal Upgrade Functions | ||
5 | LAUFNR | LFDNR | LFDNR | CHAR | 3 | 0 | Sequence Number | ||
6 | USERFUNC | J_1SUPDAFUNC | J_1SUPDAFUNC | CHAR | 2 | 0 | CH Postal Upgrade Functions | ||
7 | ORT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | * | |
8 | DOMPLZ | PLZNEU | NPSTLZ | CHAR | 10 | 0 | IS-M: Postal code | * | |
9 | LAND1_ALT | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
10 | ALORT_ALT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | JSTORTPRO | |
11 | PLZNEU_ALT | PLZNEU | NPSTLZ | CHAR | 10 | 0 | IS-M: Postal code | JSTPLZPRO | |
12 | PLZLFD_ALT | PLZLFDNR | NUMC3 | NUMC | 3 | 0 | IS-M/SD: Sequence number for postal code (for history) | ||
13 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
14 | ALORT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | * | |
15 | PLZNEU | PLZNEU | NPSTLZ | CHAR | 10 | 0 | IS-M: Postal code | * | |
16 | PLZLFD | PLZLFDNR | NUMC3 | NUMC | 3 | 0 | IS-M/SD: Sequence number for postal code (for history) | ||
17 | SUCHFELDO | SUCHFELD | CHAR40 | CHAR | 40 | 0 | Search field for accessing postal structures w/o matchcode | ||
18 | ORT_NAME_K | ORT_NAME_K | TEXT25 | CHAR | 25 | 0 | IS-M: City Name (Short Text) | ||
19 | ORT_NAME_L | ORT_NAME_L | TEXT50 | CHAR | 50 | 0 | IS-M: City name (long text) | ||
20 | ORT_NAME_G | ORT_NAME_G | JCHAR50_G | CHAR | 50 | 0 | IS-M: City name in block capitals | ||
21 | ORT_NAME_S | ORT_NAME_S | CHAR50 | CHAR | 50 | 0 | IS-M: City Name (Long Text, No Special Characters) | ||
22 | HERKKZORT | HERKZORT | HERKUNFTKZ | CHAR | 1 | 0 | IS-M: Origin Indicator for City | * | |
23 | HERKKZSTR | HERKZSTR | HERKUNFTKZ | CHAR | 1 | 0 | IS-M: Origin Indicator for Street File | * | |
24 | .INCLUDE | 0 | 0 | Type of postal code for usage | |||||
25 | X_ZUSTELL | X_ZUSTELL | XFELD | CHAR | 1 | 0 | IS-M: Postal code for home delivery | ||
26 | X_POSTFACH | X_POSTFACH | XFELD | CHAR | 1 | 0 | IS-M: Postal code for P.O.box | ||
27 | X_GRKUNDE | X_GRKUNDE | XFELD | CHAR | 1 | 0 | IS-M: Postal code for major customer | ||
28 | X_GKGRUPPE | X_GKGRUPPE | XFELD | CHAR | 1 | 0 | IS-M: Postal code for major customer group | ||
29 | X_AKTION | X_AKTION | XFELD | CHAR | 1 | 0 | Indicator: Sales Promotion Postal Code | ||
30 | X_SCHALTER | X_SCHALTER | XFELD | CHAR | 1 | 0 | Indicator: Postal code for counter collection | ||
31 | X_MILITARY | X_MILITARY | XFELD | CHAR | 1 | 0 | Military ZIP code | ||
32 | ZDPLZ | PLZNEU | NPSTLZ | CHAR | 10 | 0 | IS-M: Postal code | * | |
33 | GRUNDPLZ | J_1SGPLZ | J_1SGPLZ | NUMC | 4 | 0 | IS-M: CH: 4-Digit Basic Postal Code CH | * | |
34 | ZDORT | J_1SZDORT | J_1SC18 | CHAR | 18 | 0 | IS-M: CH: Home Delivery for City | ||
35 | KANTON | J_1SKANTON | J_1SC2 | CHAR | 2 | 0 | IS-M: CH: Canton | ||
36 | SPRCODE1 | J_1SSPRCO1 | J_1SC1 | CHAR | 1 | 0 | IS-M: CH: Language Code 1 | ||
37 | SPRCODE2 | J_1SSPRCO2 | J_1SC1 | CHAR | 1 | 0 | IS-M: CH: Language Code 2 | ||
38 | KZBOTENF | J_1SZUBOTF | J_1SC1 | CHAR | 1 | 0 | IS-M: CH: Existing Membership in Carrier File | ||
39 | GEMEINDENR | J_1SGNRBFS | CHAR5KONV | CHAR | 5 | 0 | IS-M: CH: Municipality Number from Federal Statistics Office | ||
40 | GEMEINDENA | J_1SGEMNAM | J_1SC18 | CHAR | 18 | 0 | IS-M: CH: Municipality Name | ||
41 | AGGLOMNR | J_1SAGGLNR | CHAR5KONV | CHAR | 5 | 0 | IS-M: CH: Agglomeration Number | ||
42 | KANTONPLRE | J_1SKPLREG | J_1SC4 | CHAR | 4 | 0 | IS-M: Canton planning region (CH) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | J_1SPUPBESTAND | ALORT_ALT | JSTORTPRO | ALORT | |||
2 | J_1SPUPBESTAND | LAND1_ALT | T005 | LAND1 | |||
3 | J_1SPUPBESTAND | MANDT | T000 | MANDT | |||
4 | J_1SPUPBESTAND | PLZNEU_ALT | JSTPLZPRO | PLZNEU |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |