SAP Table

T005E County

SAP table T005E has 4 primary key fields being MANDT,LAND1,REGIO,COUNC.

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

T005E 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
KeyCOUNC County Code CHAR 3 0 COUNC
/ Relationships

T005E foreign keys.

Table Field Check Table Description Check Field
T005E LAND1 T005 Countries MANDT
T005E LAND1 T005 Countries LAND1
T005E MANDT T000 Clients MANDT
T005E REGIO T005S Taxes: Region (Province) Key LAND1
Back to SAP tables