SAP table MHIS (Maintenance plan history)

SAP table MHIS has 4 primary key fields being MANDT,WARPL,ABNUM,ZAEHL.

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 MANDT
WARPL Maintenance Plan CHAR 12 0 MPLA WARPL
ABNUM Maintenance Plan Call Number INT4 10 0 ABNUM
ZAEHL Maintenance Package Number NUMC 2 0 PAKETZAEHL
NPLDA Next planned date DATS 8 0 NPLDA
TERMA Scheduling type CHAR 1 0 TERMA
STADT Start date DATS 8 0 STADT
LRMDT Date of last completion in maintenance plan DATS 8 0 LRMDT
OFFZE Offset in current cycle FLTP 16 16 OFFZE
OFFZO Previous offset FLTP 16 16 OFFZO
ABRUD Date of the call DATS 8 0 ABRUD
ABRNA Name of the person who made the call CHAR 12 0 ABRNA
SFAKT Cycle modification factor DEC 3 2 SFAKT
TERMK Scheduling indicator CHAR 1 0 TERMKNZ
Time
1 Time - key date
2 Time - factory calendar
3 Performance-based
4 Multiple counter
VERSCH Shift Factor for Late Completion NUMC 3 0 VERSCHPLUS
TOLER Tolerance for Late Completion (%) NUMC 3 0 TOLERPLUS
KNNRM Indicator for negative completion confirmation CHAR 1 0 KNNRM
KNPRM Indicator: planned counter reading set manually CHAR 1 0 KNPRM
NPLDO Last planned date DATS 8 0 NPLDO
NPLDZ Completion for Predecessor DATS 8 0 NPLDZ
MANDA Manual call date DATS 8 0 MANDA
OFFLE Estimated annual performance FLTP 16 16 OFFLE
OFFLO Shift factor FLTP 16 16 OFFLO
KNAUT Reserved CHAR 1 0 KNZABR
KNASR Indicator for leading cycle (multi-counter plan) -> internal CHAR 1 0 KNZSTILL
TSABR Scheduling status: planned date called CHAR 1 0 TSABR
TSVBT Scheduling status: call outstanding CHAR 1 0 TSVBT
TSENQ Scheduling status: call horizon not reached CHAR 1 0 TSENQ
TSENM Scheduling status: stopped manually CHAR 1 0 TSENM
HORDA Call date DATS 8 0 HORDA
TSTAT Scheduling status CHAR 1 0 TSTAT
FIXDU Fixed or skipped by CHAR 12 0 FIXDU
FIXDA Fixed/skipped on DATS 8 0 FIXDA
VGNUM Previous maintenance plan call INT4 10 0 VGNUM
ZYKZT Maintenance package cycle/offset FLTP 16 16 DZYK_ZEIT
ZYKLS Total counter reading on call date FLTP 16 16 DZYK_LEIST
PUFFP Lead Float in Days NUMC 3 0 PUFF_VORL
PUFFN Follow-up float in days NUMC 3 0 PUFF_NACHL
SZAEH Start counter reading FLTP 16 16 SZAEH
RZAEH Counter reading confirmation FLTP 16 16 RZAEH
NZAEH Next planned counter reading FLTP 16 16 NZAEH
USERMOD Scheduling determined by user CHAR 1 0 USERMOD
DEMAND_ID Demand Id CHAR 22 0 ADMSP_D_DMND_ID
DEMAND_NO APO Demand Number CHAR 12 0 ADMSP_D_DMND_NO
REVISION_NO Revision for Plant Maintenance and Customer Service CHAR 8 0 * REVNI
REV_PLANT Maintenance Planning Plant CHAR 4 0 * IWERK
ADPOINT Measuring Point CHAR 12 0 IMRC_POINT
ADANDOR Indicator for OR or AND link CHAR 1 0 ANDOR
ADTGOON Scheduling to reoccur when lead float reached NUMC 3 0 TGON
ADCYCLE Maintenance package cycle/offset FLTP 16 16 DZYK_ZEIT
ADUNIT Unit for the performance of maintenance tasks UNIT 3 0 * DZEIEH
ADOFFSET Start offset of a time-based maintenance package FLTP 16 16 DZYK_OFFZT
ADNZAEH Next planned counter reading FLTP 16 16 NZAEH
ADSTTIME Start Time for Scheduling TIMS 6 0 TIME_START
ADCONFTIME Time of Last Completion in Maintenance Plan TIMS 6 0 TIME_CONF
CYCLESEQIND Cycle Set Sequence NUMC 2 0 CYCLESETSEQ
ADEXTSTARTDATE Maintenance Plan Start Date Set Externally DATS 8 0 DATE_START_EX
ADEXTSTARTTIME Maintenance Plan Start Time Set Externally TIMS 6 0 TIME_START_EX
ADSYSTARTDATE System Date for Maintenance Plan Start DATS 8 0 DATE_START_SYST
ADSYSTARTTIME System Time for Maintenance Plan Start TIMS 6 0 TIME_START_SYST
ADOBJECT Object number CHAR 22 0 * J_OBJNR
SETREPEATIND Repeat Factor for Cycle Set Sequence NUMC 2 0 IND_SET_REPEAT
IND_MPLA_API Maintenance Plan Was Created/Changed by API CHAR 2 0 IND_MPLA_API
DUE_DATE_TIME Start Time for Scheduling TIMS 6 0 TIME_START

MHIS foreign key relationships

Table Field Check Table Check Field
0 MHIS WARPL MPLA Maintenance plan WARPL