SAP ABAP Table TJI32 (Exploded Geographical Hierarchy for Statistics)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TJI32	Table Relationship Diagram
Short Description	Exploded Geographical Hierarchy for Statistics

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	GEOHIEVST	☑	JGEOHIEVST	JGEOHIEVST	CHAR	10	0	Geographical hierarchy variant for statistics	TJI31
3	LAND	☑	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	HAUSNRVON	☑	HAUSNRVON	HAUSNUMMER	CHAR	10	0	IS-M: First House Number
7	HAUSNRBIS	☑	HAUSNRBIS	HAUSNUMMER	CHAR	10	0	IS-M: Last House Number in Range
8	HNRZUSVON	☑	HNRZUSVON	HNRZUSATZ	CHAR	8	0	IS-M/SD: First House Number Affix
9	HNRZUSBIS	☑	HNRZUSBIS	HNRZUSATZ	CHAR	8	0	IS-M/SD: Last House Number Affix
10	ADRZUSATZ	☑	ADRZUSATZ2	ADRZUS	CHAR	6	0	IS-M: Further Address Affix
11	STOCKWERK	☑	STOCKWERK	STOCK	CHAR	6	0	IS-M: Floor
12	LFDNR	☑	JLFDNR	JLFDNR	NUMC	3	0	IS-M: Sequence Number
13	HNRKENN	☐	HNRKENN	HAUSNRKENN	CHAR	1	0	IS-M: Identifier for House Number Range
14	GEOEIN	☐	GEOEIN	GEOEIN	CHAR	10	0	Number of Geographical Unit	JSTGEOEINH

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TJI32	GEOEIN	JSTGEOEINH	GEOEIN		1	CN
2	TJI32	GEOHIEVST	TJI31	GEOHIEVST		1	CN
3	TJI32	LAND	T005	LAND1		1	CN
4	TJI32	MANDT	T000	MANDT		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in