Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table T005G

City

T005G (City) 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 T005G to other SAP tables.

T005G table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
 MANDT T000
CLNT
 3 0
LAND1
Country Key
 LAND1 T005
CHAR
 3 0
REGIO
Region (State, Province, County)
 REGIO T005S
CHAR
 3 0
CITYC
City Code
 CITYC
CHAR
 4 0

T005G foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T005G LAND1 T005G MANDT T005
Countries
 MANDT
T005G LAND1 T005G LAND1 T005
Countries
 LAND1
T005G MANDT T005G MANDT T000
Clients
 MANDT
T005G REGIO T005G MANDT T005S
Taxes: Region (Province) Key
 MANDT
T005G REGIO T005G LAND1 T005S
Taxes: Region (Province) Key
 LAND1
T005G REGIO T005G REGIO T005S
Taxes: Region (Province) Key
 BLAND