SAP ABAP Table JSTPLOUPDA (IS-M/SD: Table for Upgrade of Table JSTPLZORT)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
⤷ IS-M-MD (Application Component) Master Data
⤷ JMDGEN (Package) Generic Master Data Media
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | JSTPLOUPDA | Table Relationship Diagram |
Short Description | IS-M/SD: Table for Upgrade of Table JSTPLZORT |
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 | LAND1_ALT | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
3 | PLZNEU_ALT | PLZNEU | NPSTLZ | CHAR | 10 | 0 | IS-M: Postal code | JSTPLZPRO | |
4 | PLZLFD_ALT | PLZLFDNR | NUMC3 | NUMC | 3 | 0 | IS-M/SD: Sequence number for postal code (for history) | ||
5 | ALORT_ALT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | JSTORTPRO | |
6 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
7 | PLZNEU | PLZNEU | NPSTLZ | CHAR | 10 | 0 | IS-M: Postal code | JSTPLZPRO | |
8 | PLZLFDNR | PLZLFDNR | NUMC3 | NUMC | 3 | 0 | IS-M/SD: Sequence number for postal code (for history) | ||
9 | ALORT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | JSTORTPRO | |
10 | .INCLUDE | 0 | 0 | IS-M/SD: Table for Upgrade of Table JSTPLZORT | |||||
11 | X_FEHLER | X_FEHLER | ANKREUZ | CHAR | 1 | 0 | IS-M: Incorrect data record | ||
12 | .INCLUDE | 0 | 0 | Created-By Data (Medium Scope) | |||||
13 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
14 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
15 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
16 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
17 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
18 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
19 | .INCLUDE | 0 | 0 | Version (for upgrade procedures for postal data) | |||||
20 | VERSION_J | VERSION_J | JAHR | NUMC | 4 | 0 | IS-M: Version year | ||
21 | VERSION_M | VERSION_M | AM_MONAT | NUMC | 2 | 0 | IS-M: Version month | ||
22 | VERSION_T | VERSION_T | AM_TAG | NUMC | 2 | 0 | IS-M: Version day | ||
23 | VERSION_NR | VERSION_NR | VERSION_NR | CHAR | 5 | 0 | IS-M: Version number | * | |
24 | GUELTIGAB | GUELTIGVON | DATUM | DATS | 8 | 0 | Valid-From Date | ||
25 | GUELTIGBIS | GUELTIGBIS | DATUM | DATS | 8 | 0 | Valid-To Date | ||
26 | LOESCH_VM | LOEVM_ISP | XFELD | CHAR | 1 | 0 | Deletion Flag for Master Data in Media Sales & Distribution | ||
27 | .INCLUDE | 0 | 0 | IS-PSD: Update Indicator for Postal Upgrade | |||||
28 | DBCODE_ALT | DBCODE | DBCODE | CHAR | 1 | 0 | DB Code for Structural Changes | ||
29 | DBCODE_NEU | DBCODE | DBCODE | CHAR | 1 | 0 | DB Code for Structural Changes | ||
30 | X_ADRESSEN | X_ADRESSEN | XFELD | CHAR | 1 | 0 | IS-M: Update indicator: relevant addresses revised | ||
31 | X_STRUKTUR | X_STRUKTUR | XFELD | CHAR | 1 | 0 | IS-M: Update indicator, related structures revised | ||
32 | X_POST_DB | X_POST_DB | XFELD | CHAR | 1 | 0 | IS-M: Update indicator, postal DB edited | ||
33 | .INCLUDE | 0 | 0 | Change data for structural changes etc. | |||||
34 | .INCLUDE | 0 | 0 | Change data: Standard references | |||||
35 | AENDNRBIS | AENDNRBIS | AENDNR | CHAR | 9 | 0 | Change Number for To-Date of Structural Change | JSTAENDER | |
36 | AENDNRBISD | AENDNRBISD | AENDNRARTD | CHAR | 1 | 0 | Date of Change Number Used to Change To-Date | ||
37 | AENDNRAB | AENDNRAB | AENDNR | CHAR | 9 | 0 | Change Number for From-Date of Structure Change | JSTAENDER | |
38 | AENDNRABD | AENDNRABD | AENDNRARTD | CHAR | 1 | 0 | Date of Change Number Used to Change From-Date | ||
39 | AENDNRINIT | AENDNRINIT | AENDNR | CHAR | 9 | 0 | Initiating Change Number | JSTAENDER | |
40 | AENDLFDNRI | AENDLFDNRI | AENDLFDNR | NUMC | 4 | 0 | Sequence Number of Initiating Change Number | ||
41 | AENDNRAKT | AENDNRAKT | AENDNR | CHAR | 9 | 0 | Change Number in Process | JSTAENDER | |
42 | AENDLFDNRA | AENDLFDNRA | AENDLFDNR | NUMC | 4 | 0 | Sequence Number of Currently Operative Change Number | ||
43 | XAENDER | XAENDER | XFELD | CHAR | 1 | 0 | Structure information being changed on other change number | ||
44 | XSTRUAKTIV | XSTRUAKTIV | XSTRUAKTIV | CHAR | 1 | 0 | Structure information inactive | ||
45 | FCCODE | FCCODE | FCCODE | CHAR | 2 | 0 | Function Control Code for Structure Changes | ||
46 | DBCODEFREI | DBCODE | DBCODE | CHAR | 1 | 0 | DB Code for Structural Changes | ||
47 | .INCLUDE | 0 | 0 | Change data: Reassignment statements | |||||
48 | AENDNRVON | AENDNRVON | AENDNR | CHAR | 9 | 0 | Change Number Used for Transfer FROM Another Assignment | JSTAENDER | |
49 | AENDLFDNRV | AENDLFDNRV | AENDLFDNR | NUMC | 4 | 0 | Sequence Number of Change Number Used for Transfer | ||
50 | AENDNRNACH | AENDNRNACH | AENDNR | CHAR | 9 | 0 | Change Number Used to Transfer to Another Assignment | JSTAENDER | |
51 | AENDLFDNRN | AENDLFDNRN | AENDLFDNR | NUMC | 4 | 0 | Sequence Number of Change Number Used for Transfer | ||
52 | ERWPLZ | ERWPLZ | ERW_PLZ | CHAR | 2 | 0 | 2-Digit Postal Code Extension CH |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JSTPLOUPDA | AENDNRAB | JSTAENDER | AENDNR | |||
2 | JSTPLOUPDA | AENDNRAKT | JSTAENDER | AENDNR | |||
3 | JSTPLOUPDA | AENDNRBIS | JSTAENDER | AENDNR | |||
4 | JSTPLOUPDA | AENDNRINIT | JSTAENDER | AENDNR | |||
5 | JSTPLOUPDA | AENDNRNACH | JSTAENDER | AENDNR | |||
6 | JSTPLOUPDA | AENDNRVON | JSTAENDER | AENDNR | |||
7 | JSTPLOUPDA | ALORT | JSTORTPRO | ALORT | KEY | 1 | CN |
8 | JSTPLOUPDA | ALORT_ALT | JSTORTPRO | ALORT | KEY | 1 | CN |
9 | JSTPLOUPDA | LAND1 | T005 | LAND1 | KEY | 1 | CN |
10 | JSTPLOUPDA | LAND1_ALT | T005 | LAND1 | KEY | 1 | CN |
11 | JSTPLOUPDA | MANDT | T000 | MANDT | KEY | 1 | CN |
12 | JSTPLOUPDA | PLZNEU | JSTPLZPRO | PLZNEU | KEY | 1 | CN |
13 | JSTPLOUPDA | PLZNEU_ALT | JSTPLZPRO | PLZNEU | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |