SAP table TIV22 (Representative list of rents location classes)

SAP table TIV22 has 3 primary key fields being MANDT,SMIETSP,SLAGK.

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
SMIETSP	Representative list of rents assignment	CHAR	6	0	TIV20	SMIETSP
SLAGK	Location class	NUMC	2	0		SLAGK
XMBEZ	Description of location class for rep.list of rents	CHAR	30	0		XLAGK
BGRBTR	Basic amount per location class	CURR	11	2		BGRUND
BFLBTR	Area basic amount per location category	CURR	11	2		BFLBTR
PPROZ	Maximum number of points to be considered per class	DEC	6	3		FVVIPROZ

TIV22 foreign key relationships

Table	Field	Check Table		Check Field
0 TIV22	SMIETSP	TIV20	Rep.list of rents master data	MANDT
0 TIV22	SMIETSP	TIV20	Rep.list of rents master data	SMIETSP