SAP table T016T (Industry Names)

SAP table T016T has 3 primary key fields being MANDT,SPRAS,BRSCH.

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
BRSCH Industry key CHAR 4 0 T016 BRSCH
BRTXT Description of the Industry Key CHAR 20 0 TEXT1_016T

T016T foreign key relationships

Table Field Check Table Check Field
0 T016T BRSCH T016 Industries BRSCH
1 T016T MANDT T000 Clients MANDT
0 T016T SPRAS T002 Language Keys (Component BC-I18) SPRAS