SAP T005G Table – City

T005G table in SAP ERP or S/4HANA stores City data. There are total 4 fields in T005G table. The City table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of T005G table. It is in SD Cross-application Objects (BV) ABAP package and is part of the Technical Application Support (CA-GTF-TS) module.

SAP T005G Table Fields

Following is the list of fields that are available in SAP T005G table. The primary key fields of City table in SAP are MANDT (Client), LAND1 (Country/Region Key), REGIO (Region (State, Province, County)), CITYC (City Code).

Field Description Data Element Check Table Data Type
MANDT Client MANDT T000 CLNT(3)
LAND1 Country/Region Key LAND1 T005 CHAR(3)
REGIO Region (State, Province, County) REGIO T005S CHAR(3)
CITYC City Code CITYC CHAR(4)