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

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