MHIS SAP table for – Maintenance plan history

Here we would like to draw your attention to MHIS table in SAP. As we know it is being mainly used with the SAP PM-PRM (Preventive Maintenance in PM) component which is coming under PM module (Plant Maintenance). MHIS is a SAP standard transparent table used for storing Maintenance plan history related data in SAP. It comes under the package IPRM.

SAP MHIS table

Table MHIS technical data

TableMHIS
Data storingMaintenance plan history
ModulePM
ComponentPM-PRM
SAP PackageIPRM
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MHIS Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MHIS table.

  • ABRUD
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SFAKT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • VERSCH
    Its data type is N (Character String with Digits Only) with field length 3
  • KNNRM
    Its data type is C (Character String) with field length 1
  • WARPL : Maintenance Plan
    Its a key field. Its data type is C (Character String) with field length 12
  • NPLDZ
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • OFFLE
    Its data type is F (Floating point number) with field length 8
  • KNAUT
    Its data type is C (Character String) with field length 1
  • TSABR
    Its data type is C (Character String) with field length 1
  • TSVBT
    Its data type is C (Character String) with field length 1
  • TSENM
    Its data type is C (Character String) with field length 1
  • TSTAT
    Its data type is C (Character String) with field length 1
  • VGNUM
    Its data type is X (Byte string) with field length 4
  • ZYKZT
    Its data type is F (Floating point number) with field length 8
  • PUFFP : Free float (from forecast)
    Its data type is N (Character String with Digits Only) with field length 3
  • SZAEH
    Its data type is F (Floating point number) with field length 8
  • ZAEHL : Internal counter
    Its a key field. Its data type is N (Character String with Digits Only) with field length 2
  • NZAEH
    Its data type is F (Floating point number) with field length 8
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is MHIS_AS1
  • ADANDOR
    Its data type is C (Character String) with field length 1
  • ADCYCLE
    Its data type is F (Floating point number) with field length 8
  • ADOFFSET
    Its data type is F (Floating point number) with field length 8
  • NPLDA
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ADSTTIME
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • CYCLESEQIND
    Its data type is N (Character String with Digits Only) with field length 2
  • ADEXTSTARTTIME
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ADSYSTARTTIME
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SETREPEATIND
    Its data type is N (Character String with Digits Only) with field length 2
  • DUE_DATE_TIME
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • STADT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • OFFZE
    Its data type is F (Floating point number) with field length 8