SAP Table T7PLE4 (TERYT municipality GUS codes texts)

SAP table T7PLE4 has 7 primary key fields being MANDT,SPRAS,LAND1,REGIO,COUNC,TERY2,TERSR.

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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SPRAS Language Key LANG 1 0 T002 SPRAS
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
COUNC County Code CHAR 3 0 T005E COUNC
TERY2 Municipality key according to GUS - TERYT CHAR 3 0 T7PLE2 PPL_TERY2
TERSR Municipality name usage NUMC 2 0 T7PLE3 PPL_TER_SRC
00 Any usage
01 Usage for tax office
02 Usage for ZUS
TTEXT Description CHAR 40 0 BEZEI40

T7PLE4 foreign key relationships

Table Field Check Table Check Field
0 T7PLE4 COUNC T005E County MANDT
0 T7PLE4 COUNC T005E County LAND1
0 T7PLE4 COUNC T005E County REGIO
0 T7PLE4 COUNC T005E County COUNC
1 T7PLE4 LAND1 T005 Countries MANDT
1 T7PLE4 LAND1 T005 Countries LAND1
0 T7PLE4 REGIO T005S Taxes: Region (Province) Key LAND1
1 T7PLE4 SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 T7PLE4 TERSR T7PLE3 Keys for GUS TERYT codes conversion to municipality names LAND1
0 T7PLE4 TERSR T7PLE3 Keys for GUS TERYT codes conversion to municipality names REGIO
0 T7PLE4 TERSR T7PLE3 Keys for GUS TERYT codes conversion to municipality names COUNC
0 T7PLE4 TERSR T7PLE3 Keys for GUS TERYT codes conversion to municipality names TERY2
0 T7PLE4 TERSR T7PLE3 Keys for GUS TERYT codes conversion to municipality names TERSR
1 T7PLE4 TERY2 T7PLE2 Municipality code according to GUS - TERYT LAND1
1 T7PLE4 TERY2 T7PLE2 Municipality code according to GUS - TERYT REGIO
1 T7PLE4 TERY2 T7PLE2 Municipality code according to GUS - TERYT COUNC