MHIS

Transparent Table Application Table
64 Fields 1 CDS Views

Maintenance plan history

MHIS is an SAP database table in S/4HANA. Maintenance plan history. It contains 64 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MaintPlanCallHistory view from BASIC Maintenance Plan Call History

Fields (64)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY warpl WARPL MaintenancePlan
KEY abnum ABNUM Call Number
KEY zaehl PAKETZAEHL Package
nplda NPLDA Planned Date
terma TERMA SchedulngType
stadt STADT Cycle start
lrmdt LRMDT Last Completion
offze OFFZE Time offset
offzo OFFZO Time offset
abrud ABRUD Call date
abrna ABRNA Name
sfakt SFAKT CycModifFactor
termk TERMKNZ SchedIndic.
versch VERSCHPLUS Late Completion
toler TOLERPLUS Tolerance (+)
knnrm KNNRM AND/OR op.
knprm KNPRM Indicator: planned counter reading set manually
npldo NPLDO Last date
npldz NPLDZ Compl.Predecess
manda MANDA Manual call
offle OFFLE AnnEstimate
offlo OFFLO ShftFctr
knaut KNZABR Reserved
knasr KNZSTILL Leading Cycle
tsabr TSABR SchedStatus
tsvbt TSVBT SchedStatus
tsenq TSENQ SchedStatus
tsenm TSENM SchedStatus
horda HORDA Call date
tstat TSTAT Sched. status
fixdu FIXDU Changed by
fixda FIXDA Change date
vgnum VGNUM Previous call
zykzt DZYK_ZEIT Package cycle
zykls DZYK_LEIST CallCountRead.
puffp PUFF_VORL Lead float
puffn PUFF_NACHL Follow-up float
szaeh SZAEH StrtCtrReadg
rzaeh RZAEH CompConfReadg
nzaeh NZAEH TL counter
usermod USERMOD UserSched.
demand_id ADMSP_D_DMND_ID Demand GUID
demand_no ADMSP_D_DMND_NO APO Demand Number
revision_no REVNI Revision
rev_plant IWERK Planning Plant
adpoint IMRC_POINT Measuring point
adandor ANDOR Operation type
adtgoon TGON FurthrSchedulng
adcycle DZYK_ZEIT Package cycle
adunit DZEIEH Unit
adoffset DZYK_OFFZT TimeOffset
adnzaeh NZAEH TL counter
adsttime TIME_START Start Time
adconftime TIME_CONF Time
cycleseqind CYCLESETSEQ Cycle Set Seq.
adextstartdate DATE_START_EX Start Date
adextstarttime TIME_START_EX Start Time
adsystartdate DATE_START_SYST Date
adsystarttime TIME_START_SYST Time
adobject J_OBJNR Object number
setrepeatind IND_SET_REPEAT RepFactor Set
ind_mpla_api IND_MPLA_API MPlan by API
due_date_time TIME_START Start Time

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Maintenance plan history
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MHIS (
    MANDT,           -- Client [MANDT]
    WARPL,           -- MaintenancePlan [WARPL]
    ABNUM,           -- Call Number [ABNUM]
    ZAEHL,           -- Package [PAKETZAEHL]
    NPLDA,           -- Planned Date [NPLDA]
    TERMA,           -- SchedulngType [TERMA]
    STADT,           -- Cycle start [STADT]
    LRMDT,           -- Last Completion [LRMDT]
    OFFZE,           -- Time offset [OFFZE]
    OFFZO,           -- Time offset [OFFZO]
    ABRUD,           -- Call date [ABRUD]
    ABRNA,           -- Name [ABRNA]
    SFAKT,           -- CycModifFactor [SFAKT]
    TERMK,           -- SchedIndic. [TERMKNZ]
    VERSCH,          -- Late Completion [VERSCHPLUS]
    TOLER,           -- Tolerance (+) [TOLERPLUS]
    KNNRM,           -- AND/OR op. [KNNRM]
    KNPRM,           -- Indicator: planned counter reading set manually [KNPRM]
    NPLDO,           -- Last date [NPLDO]
    NPLDZ,           -- Compl.Predecess [NPLDZ]
    MANDA,           -- Manual call [MANDA]
    OFFLE,           -- AnnEstimate [OFFLE]
    OFFLO,           -- ShftFctr [OFFLO]
    KNAUT,           -- Reserved [KNZABR]
    KNASR,           -- Leading Cycle [KNZSTILL]
    TSABR,           -- SchedStatus [TSABR]
    TSVBT,           -- SchedStatus [TSVBT]
    TSENQ,           -- SchedStatus [TSENQ]
    TSENM,           -- SchedStatus [TSENM]
    HORDA,           -- Call date [HORDA]
    TSTAT,           -- Sched. status [TSTAT]
    FIXDU,           -- Changed by [FIXDU]
    FIXDA,           -- Change date [FIXDA]
    VGNUM,           -- Previous call [VGNUM]
    ZYKZT,           -- Package cycle [DZYK_ZEIT]
    ZYKLS,           -- CallCountRead. [DZYK_LEIST]
    PUFFP,           -- Lead float [PUFF_VORL]
    PUFFN,           -- Follow-up float [PUFF_NACHL]
    SZAEH,           -- StrtCtrReadg [SZAEH]
    RZAEH,           -- CompConfReadg [RZAEH]
    NZAEH,           -- TL counter [NZAEH]
    USERMOD,         -- UserSched. [USERMOD]
    DEMAND_ID,       -- Demand GUID [ADMSP_D_DMND_ID]
    DEMAND_NO,       -- APO Demand Number [ADMSP_D_DMND_NO]
    REVISION_NO,     -- Revision [REVNI]
    REV_PLANT,       -- Planning Plant [IWERK]
    ADPOINT,         -- Measuring point [IMRC_POINT]
    ADANDOR,         -- Operation type [ANDOR]
    ADTGOON,         -- FurthrSchedulng [TGON]
    ADCYCLE,         -- Package cycle [DZYK_ZEIT]
    ADUNIT,          -- Unit [DZEIEH]
    ADOFFSET,        -- TimeOffset [DZYK_OFFZT]
    ADNZAEH,         -- TL counter [NZAEH]
    ADSTTIME,        -- Start Time [TIME_START]
    ADCONFTIME,      -- Time [TIME_CONF]
    CYCLESEQIND,     -- Cycle Set Seq. [CYCLESETSEQ]
    ADEXTSTARTDATE,  -- Start Date [DATE_START_EX]
    ADEXTSTARTTIME,  -- Start Time [TIME_START_EX]
    ADSYSTARTDATE,   -- Date [DATE_START_SYST]
    ADSYSTARTTIME,   -- Time [TIME_START_SYST]
    ADOBJECT,        -- Object number [J_OBJNR]
    SETREPEATIND,    -- RepFactor Set [IND_SET_REPEAT]
    IND_MPLA_API,    -- MPlan by API [IND_MPLA_API]
    DUE_DATE_TIME,   -- Start Time [TIME_START]
    PRIMARY KEY (MANDT, WARPL, ABNUM, ZAEHL)
);

Learn More