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 | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
KNPRM
Indicator: planned counter reading set manually
|
KNPRM |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
KNASR
Indicator for leading cycle (multi-counter plan) -> internal
|
KNZSTILL |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TSABR
Scheduling status: planned date called
|
TSABR |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TSVBT
Scheduling status: call outstanding
|
TSVBT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TSENQ
Scheduling status: call horizon not reached
|
TSENQ |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TSENM
Scheduling status: stopped manually
|
TSENM |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
HORDA
Call date
|
HORDA |
DATS
|
8 | 0 | ||||||||||||||
|
TSTAT
Scheduling status
|
TSTAT |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
DUE_DATE_TIME
Start Time for Scheduling
|
TIME_START |
TIMS
|
6 | 0 | ||||||||||||||