T005G

City

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table T005G.

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

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

T005G fields.

4 fields

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

T005G relationships.

4 relationships

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

Back to SAP tables