SAP table MMPT (Cycle definitions and MeasPoints for MaintPlan)

SAP table MMPT has 3 primary key fields being MANDT,WARPL,NUMMER.

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
WARPL	Maintenance Plan	CHAR	12	0	MPLA	WARPL
NUMMER	Counter in Control Tables	NUMC	2	0		DZAEHLER
OPERATOR	Comparison operator for maint. package cycle duration	CHAR	2	0		PM_VERGL
ZYKL1	Maintenance package cycle/offset	FLTP	16	16		DZYK_ZEIT
ZEIEH	Unit for the performance of maintenance tasks	UNIT	3	0	T006	DZEIEH
PAK_TEXT	Text for maintenance package/cycle (time/performance)	CHAR	30	0		TXZYKLUS
LANGU	Primary language for object texts	LANG	1	0	T002	MLANG
POINT	Measuring Point	CHAR	12	0	IMPTT	IMRC_POINT
OFFSET	Start offset of a time-based maintenance package	FLTP	16	16		DZYK_OFFZT
INAKTIV	Indicator: event scheduling inactive	CHAR	1	0		INAKT_TERM
NZAEH	Next planned counter reading	FLTP	16	16		NZAEH
ZAEHL	Maintenance Package Number	NUMC	2	0	*	PAKETZAEHL
KTEXTYZK	Short text for the maintenance cycle (time/performance)	CHAR	2	0		KTEXTZYK
CYCLESEQIND	Cycle Set Sequence	NUMC	2	0		CYCLESETSEQ
SETREPEATIND	Repeat Factor for Cycle Set Sequence	NUMC	2	0		IND_SET_REPEAT

MMPT foreign key relationships

Table	Field	Check Table		Check Field
0 MMPT	MANDT	T000	Clients	MANDT
1 MMPT	POINT	IMPTT	Measuring Point (Table)	POINT
0 MMPT	WARPL	MPLA	Maintenance plan	WARPL
1 MMPT	ZEIEH	T006	Units of Measurement	MANDT
1 MMPT	ZEIEH	T006	Units of Measurement	MSEHI