SAP Table MHIS

Maintenance plan history

MHIS (Maintenance plan history) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MHIS to other SAP tables.

MHIS table fields

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

MHIS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MHIS WARPL MHIS MANDT MPLA Maintenance plan MANDT
MHIS WARPL MHIS WARPL MPLA Maintenance plan WARPL