1. Home
  2. Resources
  3. SAP Tables
  4. TJS09 - IS-M/SD: Types of Geographical Units

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
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
01 Country
02 City
03 Postal Code
04 Street
ARTPOSTE2 IS-M: Type of Postal Unit ARTPOSTE NUMC 2 0
01 Country
02 City
03 Postal Code
04 Street
ARTPOSTE3 IS-M: Type of Postal Unit ARTPOSTE NUMC 2 0
01 Country
02 City
03 Postal Code
04 Street
XSTRICT IS-M: Geo.type check not across hierarchy levels JXGEOSTRICT CHAR 1 0
X Yes
NULL No

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 MANDT TJS09 IS-M/SD: Types of Geographical Units MANDT
TJS09 TOP3ARTGEO TJS09 TOP3ARTGEO TJS09 IS-M/SD: Types of Geographical Units ARTGEO