SAP Table

T005G City

SAP table T005G has 4 primary key fields being MANDT,LAND1,REGIO,CITYC.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

T005G columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyLAND1 Country/Region Key CHAR 3 0 T005 LAND1
KeyREGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
KeyCITYC City Code CHAR 4 0 CITYC
/ Relationships

T005G foreign keys.

Table Field Check Table Description Check Field
T005G LAND1 T005 Countries MANDT
T005G LAND1 T005 Countries LAND1
T005G MANDT T000 Clients MANDT
T005G REGIO T005S Taxes: Region (Province) Key LAND1