SAP ABAP Table JSTGEOPST (IS-M/SD: Assignments of Geographical to Postal Units)
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 | JSTGEOPST | Table Relationship Diagram |
Short Description | IS-M/SD: Assignments of Geographical to Postal Units |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | GEOEIN | GEOEIN | GEOEIN | CHAR | 10 | 0 | Number of Geographical Unit | JSTGEOEINH | |
3 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
4 | ARTPOSTE | ARTPOSTE | ARTPOSTE | NUMC | 2 | 0 | IS-M: Type of Postal Unit | ||
5 | PSTEIN | PSTEIN | PSTEIN | CHAR | 10 | 0 | IS-M: Postal unit number | ||
6 | GUELTIGBIS | GUELTIGBIS | DATUM | DATS | 8 | 0 | Valid-To Date | ||
7 | GUELTIGAB | GUELTIGVON | DATUM | DATS | 8 | 0 | Valid-From Date | ||
8 | HAUSNRVON | HAUSNRVON | HAUSNUMMER | CHAR | 10 | 0 | IS-M: First House Number | ||
9 | HAUSNRBIS | HAUSNRBIS | HAUSNUMMER | CHAR | 10 | 0 | IS-M: Last House Number in Range | ||
10 | HNRZUSVON | HNRZUSVON | HNRZUSATZ | CHAR | 8 | 0 | IS-M/SD: First House Number Affix | ||
11 | HNRZUSBIS | HNRZUSBIS | HNRZUSATZ | CHAR | 8 | 0 | IS-M/SD: Last House Number Affix | ||
12 | ADRZUSATZ | ADRZUSATZ2 | ADRZUS | CHAR | 6 | 0 | IS-M: Further Address Affix | ||
13 | STOCKWERK | STOCKWERK | STOCK | CHAR | 6 | 0 | IS-M: Floor | ||
14 | HNRKENN | HNRKENN | HAUSNRKENN | CHAR | 1 | 0 | IS-M: Identifier for House Number Range | ||
15 | XMANUELL | XMANUELL | XFELD | CHAR | 1 | 0 | IS-M: Manual post-editing has taken place | ||
16 | XSCRIPT | XSCRIPT | XFELD | CHAR | 1 | 0 | SAPscript comment recorded | ||
17 | .INCLUDE | 0 | 0 | General function part for structural changes | |||||
18 | ZUORDART | JZUORDART | JZUORDART | CHAR | 1 | 0 | Assignment Type | ||
19 | ZUORDFUNK | JZUORDFUNK | JZUORDFUNK | CHAR | 1 | 0 | Assignment function (inclusive, exclusive) | ||
20 | .INCLUDE | 0 | 0 | Change data for structural changes etc. | |||||
21 | .INCLUDE | 0 | 0 | Change data: Standard references | |||||
22 | AENDNRBIS | AENDNRBIS | AENDNR | CHAR | 9 | 0 | Change Number for To-Date of Structural Change | JSTAENDER | |
23 | AENDNRBISD | AENDNRBISD | AENDNRARTD | CHAR | 1 | 0 | Date of Change Number Used to Change To-Date | ||
24 | AENDNRAB | AENDNRAB | AENDNR | CHAR | 9 | 0 | Change Number for From-Date of Structure Change | JSTAENDER | |
25 | AENDNRABD | AENDNRABD | AENDNRARTD | CHAR | 1 | 0 | Date of Change Number Used to Change From-Date | ||
26 | AENDNRINIT | AENDNRINIT | AENDNR | CHAR | 9 | 0 | Initiating Change Number | JSTAENDER | |
27 | AENDLFDNRI | AENDLFDNRI | AENDLFDNR | NUMC | 4 | 0 | Sequence Number of Initiating Change Number | ||
28 | AENDNRAKT | AENDNRAKT | AENDNR | CHAR | 9 | 0 | Change Number in Process | JSTAENDER | |
29 | AENDLFDNRA | AENDLFDNRA | AENDLFDNR | NUMC | 4 | 0 | Sequence Number of Currently Operative Change Number | ||
30 | XAENDER | XAENDER | XFELD | CHAR | 1 | 0 | Structure information being changed on other change number | ||
31 | XSTRUAKTIV | XSTRUAKTIV | XSTRUAKTIV | CHAR | 1 | 0 | Structure information inactive | ||
32 | FCCODE | FCCODE | FCCODE | CHAR | 2 | 0 | Function Control Code for Structure Changes | ||
33 | DBCODEFREI | DBCODE | DBCODE | CHAR | 1 | 0 | DB Code for Structural Changes | ||
34 | .INCLUDE | 0 | 0 | Change data: Reassignment statements | |||||
35 | AENDNRVON | AENDNRVON | AENDNR | CHAR | 9 | 0 | Change Number Used for Transfer FROM Another Assignment | JSTAENDER | |
36 | AENDLFDNRV | AENDLFDNRV | AENDLFDNR | NUMC | 4 | 0 | Sequence Number of Change Number Used for Transfer | ||
37 | AENDNRNACH | AENDNRNACH | AENDNR | CHAR | 9 | 0 | Change Number Used to Transfer to Another Assignment | JSTAENDER | |
38 | AENDLFDNRN | AENDLFDNRN | AENDLFDNR | NUMC | 4 | 0 | Sequence Number of Change Number Used for Transfer | ||
39 | .INCLUDE | 0 | 0 | Created-By Data (Medium Scope) | |||||
40 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
41 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
42 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
43 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
44 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
45 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
46 | .INCLUDE | 0 | 0 | Secondary Address (Without ZIP Add-On) | |||||
47 | ADDRSECABBREV | ADDRSECABBREV | ADDRSECABBREV | CHAR | 4 | 0 | IS-M: Secondary Address Text | TJS43 | |
48 | ADDRSECNUMLOW | ADDRSECNUMLOW | ADDRSECNUMBER | CHAR | 8 | 0 | IS-M: Secondary Address Number (Lower Limit) | ||
49 | ADDRSECNUMHIGH | ADDRSECNUMHIGH | ADDRSECNUMBER | CHAR | 8 | 0 | IS-M: Secondary Address Number | ||
50 | ADDRSECODDEVEN | ADDRSECODDEVEN | ODDEVENCODE | CHAR | 1 | 0 | IS-M: Odd/Even Indicator for Secondary Address Number | ||
51 | SCRIPTNUM | SCRIPTNUM | SCRIPTNUM | CHAR | 10 | 0 | IS-M: SAPscript number for geo.-postal unit assignment |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JSTGEOPST | ADDRSECABBREV | TJS43 | ADDRSECABBREV | |||
2 | JSTGEOPST | AENDNRAB | JSTAENDER | AENDNR | |||
3 | JSTGEOPST | AENDNRAKT | JSTAENDER | AENDNR | |||
4 | JSTGEOPST | AENDNRBIS | JSTAENDER | AENDNR | |||
5 | JSTGEOPST | AENDNRINIT | JSTAENDER | AENDNR | |||
6 | JSTGEOPST | AENDNRNACH | JSTAENDER | AENDNR | |||
7 | JSTGEOPST | AENDNRVON | JSTAENDER | AENDNR | |||
8 | JSTGEOPST | GEOEIN | JSTGEOEINH | GEOEIN | KEY | 1 | CN |
9 | JSTGEOPST | LAND1 | T005 | LAND1 | KEY | 1 | N |
10 | JSTGEOPST | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |