SAP table TESPT (Alloc. of Div. Cat. to Div.)

SAP table TESPT has 2 primary key fields being MANDT,SPARTE.

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
SPARTE Division CHAR 2 0 TSPA SPARTE
SPARTYP Division category NUMC 2 0 SPARTYP
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste Management
11 Mutual help
99 For all sectors

TESPT foreign key relationships

Table Field Check Table Check Field
0 TESPT SPARTE TSPA Organizational Unit: Sales Divisions MANDT
0 TESPT SPARTE TSPA Organizational Unit: Sales Divisions SPART