SAP Table TJS09
IS-M/SD: Types of Geographical Units
TJS09 (IS-M/SD: Types of Geographical Units) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TJS09 to other SAP tables.
TJS09 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
ARTGEO
IS-M: Type of Geographical Unit
|
ARTGEO |
NUMC
|
2 | 0 | ||||||||||||
|
TOP1ARTGEO
IS-M: Higher-level geographical units
|
TOPARTGEO | TJS09 |
NUMC
|
2 | 0 | |||||||||||
|
TOP2ARTGEO
IS-M: Higher-level geographical units
|
TOPARTGEO | TJS09 |
NUMC
|
2 | 0 | |||||||||||
|
TOP3ARTGEO
IS-M: Higher-level geographical units
|
TOPARTGEO | TJS09 |
NUMC
|
2 | 0 | |||||||||||
|
ARTPOSTE1D
IS-M: Type of Postal Unit
|
ARTPOSTE |
NUMC
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
ARTPOSTE2
IS-M: Type of Postal Unit
|
ARTPOSTE |
NUMC
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
ARTPOSTE3
IS-M: Type of Postal Unit
|
ARTPOSTE |
NUMC
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
XSTRICT
IS-M: Geo.type check not across hierarchy levels
|
JXGEOSTRICT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
TJS09 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TJS09 | MANDT | TJS09 | MANDT |
T000
Clients
|
MANDT |
| TJS09 | TOP1ARTGEO | TJS09 | MANDT |
TJS09
IS-M/SD: Types of Geographical Units
|
MANDT |
| TJS09 | TOP1ARTGEO | TJS09 | TOP1ARTGEO |
TJS09
IS-M/SD: Types of Geographical Units
|
ARTGEO |
| TJS09 | TOP2ARTGEO | TJS09 | MANDT |
TJS09
IS-M/SD: Types of Geographical Units
|
MANDT |
| TJS09 | TOP2ARTGEO | TJS09 | TOP2ARTGEO |
TJS09
IS-M/SD: Types of Geographical Units
|
ARTGEO |
| TJS09 | TOP3ARTGEO | TJS09 | TOP3ARTGEO |
TJS09
IS-M/SD: Types of Geographical Units
|
ARTGEO |
| TJS09 | TOP3ARTGEO | TJS09 | MANDT |
TJS09
IS-M/SD: Types of Geographical Units
|
MANDT |