QMIH

Transparent Table Application Table
61 Fields 3 CDS Views

Quality message - maintenance data excerpt

QMIH is an SAP database table in S/4HANA. Quality message - maintenance data excerpt. It contains 61 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_PMNotifMaintenanceData view_entity from EXTENSION Extension View of Maintenance Notification
I_MaintenanceNotificationBasic view_entity from BASIC Maintenance Notification Basic
I_PMNotifMaintenanceData view from BASIC Notification Maintenance Data

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY qmnum QMNUM Notification
iwerk IWERK Planning Plant
iloan ILOAN Loc/AccAssmt
iloai ILOAI ILOA individ.
equnr EQUNR Equipment
bautl BAUTL Assembly
ebort EBORT Install. Point
msaus MSAUS Breakdown
ausvn AUSVN Malfunct. Start
ausbs AUSBS Malfunct. End
auztv AUZTV Mal. Start (T.)
auztb AUZTB Malfunction End
auszt AUSZT Breakdown Dur.
maueh MAUEH Unit
btpln BTPLN FLoc. affected
bequi BEQUI EquipmtAffctd
auswk AUSWK Effect
verfv VERFV AvailBefMalfn
verfn VERFN AvailAftMalfn
verfm VERFM AvailAftTask
anlzv ANLZV Cond.bef.malfn.
anlzn ANLZN Cond.aft.malfn.
anlze ANLZE Cond.after task
inspk INSPK TechInspectn by
datan DATAN TechInspec on
ingrp INGRP Planner Group
warpl WARPL MaintenancePlan
abnum ABNUM Call Number
wapos WAPOS MaintItem
kdauf VBELN_VA Sales Document
kdpos POSNR_VA Item
screenty SCRTP Scenario
plnty PLNTY Task List Type
plnnr PLNNR Group
plnal PLNAL Group Counter
revnr REVNI Revision
loc_desc PM_LOC_DESC Current Location
ilart ILA MaintActivType
notificationpersonresponsible EAMS_PERSON_RESPONSIBLE Person Resp. ID
datamodelversion EAM_SDM_VERSION_QMIH Migration State
maintnotifovrlprocphase EAM_OSTAT_PHASE Process Phase
maintnotifovrlprocsubphase EAM_OSTAT_SPHASE Process Subphase
detectioncatalog DETECTIONCATALOG Detection Meth Prfl
detectioncodegroup DETECTIONCODEGROUP Detection Meth Grp
detectioncode DETECTIONCODE Detection Meth
notifrejectionreasoncode EAM_REJREASONCODE Reason Code
maintnotifprocessingcontext MAINTNOTIFPROCESSINGCONTEXT Notif Procg Context
dummy_qmih_incl_eew_ps CFD_DUMMY Dummy
zaehl CIM_COUNT Counter
lacd_date LACD_DATE Final Due Date
old_lacd_date LACD_OLD Prev. Final Due Date
pams_ptstf PAMS_PTSTF Plnd TmStmp fr.
pams_ptstt PAMS_PTSTT Plnd TmStmp to
pams_atstf PAMS_ATSTF Actl Start Time
pams_atstt PAMS_ATSTT Actl End Time
pams_pool PAMS_POOL PAM Pool
pams_kostl KOSTL Cost Center
pams_aufnr AUFNR Order
pams_proid PS_PSP_PNR WBS Element
pams_kokrs KOKRS CO Area

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.

-- Quality message - maintenance data excerpt
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QMIH (
    MANDT,                          -- Client [MANDT]
    QMNUM,                          -- Notification [QMNUM]
    IWERK,                          -- Planning Plant [IWERK]
    ILOAN,                          -- Loc/AccAssmt [ILOAN]
    ILOAI,                          -- ILOA individ. [ILOAI]
    EQUNR,                          -- Equipment [EQUNR]
    BAUTL,                          -- Assembly [BAUTL]
    EBORT,                          -- Install. Point [EBORT]
    MSAUS,                          -- Breakdown [MSAUS]
    AUSVN,                          -- Malfunct. Start [AUSVN]
    AUSBS,                          -- Malfunct. End [AUSBS]
    AUZTV,                          -- Mal. Start (T.) [AUZTV]
    AUZTB,                          -- Malfunction End [AUZTB]
    AUSZT,                          -- Breakdown Dur. [AUSZT]
    MAUEH,                          -- Unit [MAUEH]
    BTPLN,                          -- FLoc. affected [BTPLN]
    BEQUI,                          -- EquipmtAffctd [BEQUI]
    AUSWK,                          -- Effect [AUSWK]
    VERFV,                          -- AvailBefMalfn [VERFV]
    VERFN,                          -- AvailAftMalfn [VERFN]
    VERFM,                          -- AvailAftTask [VERFM]
    ANLZV,                          -- Cond.bef.malfn. [ANLZV]
    ANLZN,                          -- Cond.aft.malfn. [ANLZN]
    ANLZE,                          -- Cond.after task [ANLZE]
    INSPK,                          -- TechInspectn by [INSPK]
    DATAN,                          -- TechInspec on [DATAN]
    INGRP,                          -- Planner Group [INGRP]
    WARPL,                          -- MaintenancePlan [WARPL]
    ABNUM,                          -- Call Number [ABNUM]
    WAPOS,                          -- MaintItem [WAPOS]
    KDAUF,                          -- Sales Document [VBELN_VA]
    KDPOS,                          -- Item [POSNR_VA]
    SCREENTY,                       -- Scenario [SCRTP]
    PLNTY,                          -- Task List Type [PLNTY]
    PLNNR,                          -- Group [PLNNR]
    PLNAL,                          -- Group Counter [PLNAL]
    REVNR,                          -- Revision [REVNI]
    LOC_DESC,                       -- Current Location [PM_LOC_DESC]
    ILART,                          -- MaintActivType [ILA]
    NOTIFICATIONPERSONRESPONSIBLE,  -- Person Resp. ID [EAMS_PERSON_RESPONSIBLE]
    DATAMODELVERSION,               -- Migration State [EAM_SDM_VERSION_QMIH]
    MAINTNOTIFOVRLPROCPHASE,        -- Process Phase [EAM_OSTAT_PHASE]
    MAINTNOTIFOVRLPROCSUBPHASE,     -- Process Subphase [EAM_OSTAT_SPHASE]
    DETECTIONCATALOG,               -- Detection Meth Prfl [DETECTIONCATALOG]
    DETECTIONCODEGROUP,             -- Detection Meth Grp [DETECTIONCODEGROUP]
    DETECTIONCODE,                  -- Detection Meth [DETECTIONCODE]
    NOTIFREJECTIONREASONCODE,       -- Reason Code [EAM_REJREASONCODE]
    MAINTNOTIFPROCESSINGCONTEXT,    -- Notif Procg Context [MAINTNOTIFPROCESSINGCONTEXT]
    DUMMY_QMIH_INCL_EEW_PS,         -- Dummy [CFD_DUMMY]
    ZAEHL,                          -- Counter [CIM_COUNT]
    LACD_DATE,                      -- Final Due Date [LACD_DATE]
    OLD_LACD_DATE,                  -- Prev. Final Due Date [LACD_OLD]
    PAMS_PTSTF,                     -- Plnd TmStmp fr. [PAMS_PTSTF]
    PAMS_PTSTT,                     -- Plnd TmStmp to [PAMS_PTSTT]
    PAMS_ATSTF,                     -- Actl Start Time [PAMS_ATSTF]
    PAMS_ATSTT,                     -- Actl End Time [PAMS_ATSTT]
    PAMS_POOL,                      -- PAM Pool [PAMS_POOL]
    PAMS_KOSTL,                     -- Cost Center [KOSTL]
    PAMS_AUFNR,                     -- Order [AUFNR]
    PAMS_PROID,                     -- WBS Element [PS_PSP_PNR]
    PAMS_KOKRS,                     -- CO Area [KOKRS]
    PRIMARY KEY (MANDT, QMNUM)
);

Learn More