MHIS

Transparent Table Application Table
42 Fields 1 CDS Views

Maintenance plan history

MHIS is an SAP database table in S/4HANA. Maintenance plan history. It contains 42 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 (42)

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.

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]
    PRIMARY KEY (MANDT, WARPL, ABNUM, ZAEHL)
);

Learn More