QMFE

Transparent Table Application Table
82 Fields 4 CDS Views

Quality notification - items / Defect

QMFE is an SAP database table in S/4HANA. Quality notification - items / Defect. It contains 82 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_NotificationItem view_entity from EXTENSION Notification Item Extension
I_MaintenanceNotificationItem view from BASIC Maintenance Notification Item
I_MaintNotificationItemBasic view_entity from BASIC Maintenance Notification Basic
I_NotificationItem view_entity from BASIC Notification Item

Fields (82)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY qmnum qmnum Notification
KEY fenum felfd Item
category qdefcategory Defect Category
ernam ernam Created By
erdat erdat Created On
aenam aenam Changed By
aedat aedat Changed On
fetxt fetxt Text
fekat fekat Defect types
fegrp fegrp Code Group
fecod fecod Damage Code
fever qversnr Version
otkat otkat Object Parts
otgrp otgrp Code Group
oteil oteil ObjectPartCode
otver qversnr Version
initialcausecat urkat Catalog type
initialcausegroup urgrp Code Group
initialcausecode urcod Cause Code
initialcausecodever qversnr Version
bautl bautl Assembly
ebort ebort Install. Point
indtx indltx Long text
kzmla kzmla Primary lang.
erzeit erzeit Created At
aezeit aezeit Changed At
kzorg kzorg Orig. defect
wdfeh wdfeh RepetitiveDefct
feqklas qfehlklas Defect Class
fcoaufnr qcoaufnr Order
fmgfrd qmgfrd Def. Qty (Ext.)
fmgeig qmgeig Def. Qty (Int.)
fmgein qmgein Unit of Measure
anzfehler qanzfehl4 No. of Defects
fehlbew qfehlbew DefectValuation
unitflbew qunitflbew Unit
feart qfeart Report Type
fertaufnr fertaufnr Prod. Order
fertaufpl fertaufpl Plan no. oper.
pnlkn qlfnkn Node Number
merknr qmerknrp Characteristic
probenr qprobenr Sample Number
phynr qphysprnr Sample
prueflinr qprueflinr Insp. Unit No.
crobjty cr_objty Object Type
arbpl lgwid Work Center
arbplwerk qarbpwerks Work Ctr Plant
fenumorg qfenumorg Original item
kzsysfe qkzsysfe SystematDefect
kzloesch kzloesch Delete
posnr qlfdpos Sort Number
herpos qmfeherk Oritin of item
autkz qautkz Object autom.
matnr matnr Material
werks werks_d Plant
lgort lgort_d Location
ekorg ekorg Purchasing Org.
infnr infnr Info Record
kostl kostl Cost Center
lstar lstar Activity Type
prznr co_prznr Business Process
menge qmgpos Quantity
prueflos qplos Inspection Lot
charg charg_d Batch
oa_id mpe_oa_id Operation Activity
oa_version_no mpe_oa_version_no OA Version
defrefnum qdefrefnum Defect Key
rbnr rbnr Catalog Profile
changeddatetime tzntstmps Time Stamp
statlcycle qdeflcyclestat Defect Status
statacycle qdefacyclestat Defect Archiving Status
statpanalysis qdefpanastat Problem Analysis
extrefnum qextrefnum Reference Number
isautocreated qisdefectcreatedautomatically Created Automat.
internalid qdefectinternalid Internal Defect ID
repuser qfrepuser Reported By
repondate qfrepondate Reported On
repattime qfrepattime Reported At
defectuuid qdefectuuid Defect UUID
defectcausedby qdefectcausedby Defect Caused By
bom_item_instance dmu_guid16 DMU GUID

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 notification - items / Defect
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QMFE (
    MANDT,                -- Client [mandt]
    QMNUM,                -- Notification [qmnum]
    FENUM,                -- Item [felfd]
    CATEGORY,             -- Defect Category [qdefcategory]
    ERNAM,                -- Created By [ernam]
    ERDAT,                -- Created On [erdat]
    AENAM,                -- Changed By [aenam]
    AEDAT,                -- Changed On [aedat]
    FETXT,                -- Text [fetxt]
    FEKAT,                -- Defect types [fekat]
    FEGRP,                -- Code Group [fegrp]
    FECOD,                -- Damage Code [fecod]
    FEVER,                -- Version [qversnr]
    OTKAT,                -- Object Parts [otkat]
    OTGRP,                -- Code Group [otgrp]
    OTEIL,                -- ObjectPartCode [oteil]
    OTVER,                -- Version [qversnr]
    INITIALCAUSECAT,      -- Catalog type [urkat]
    INITIALCAUSEGROUP,    -- Code Group [urgrp]
    INITIALCAUSECODE,     -- Cause Code [urcod]
    INITIALCAUSECODEVER,  -- Version [qversnr]
    BAUTL,                -- Assembly [bautl]
    EBORT,                -- Install. Point [ebort]
    INDTX,                -- Long text [indltx]
    KZMLA,                -- Primary lang. [kzmla]
    ERZEIT,               -- Created At [erzeit]
    AEZEIT,               -- Changed At [aezeit]
    KZORG,                -- Orig. defect [kzorg]
    WDFEH,                -- RepetitiveDefct [wdfeh]
    FEQKLAS,              -- Defect Class [qfehlklas]
    FCOAUFNR,             -- Order [qcoaufnr]
    FMGFRD,               -- Def. Qty (Ext.) [qmgfrd]
    FMGEIG,               -- Def. Qty (Int.) [qmgeig]
    FMGEIN,               -- Unit of Measure [qmgein]
    ANZFEHLER,            -- No. of Defects [qanzfehl4]
    FEHLBEW,              -- DefectValuation [qfehlbew]
    UNITFLBEW,            -- Unit [qunitflbew]
    FEART,                -- Report Type [qfeart]
    FERTAUFNR,            -- Prod. Order [fertaufnr]
    FERTAUFPL,            -- Plan no. oper. [fertaufpl]
    PNLKN,                -- Node Number [qlfnkn]
    MERKNR,               -- Characteristic [qmerknrp]
    PROBENR,              -- Sample Number [qprobenr]
    PHYNR,                -- Sample [qphysprnr]
    PRUEFLINR,            -- Insp. Unit No. [qprueflinr]
    CROBJTY,              -- Object Type [cr_objty]
    ARBPL,                -- Work Center [lgwid]
    ARBPLWERK,            -- Work Ctr Plant [qarbpwerks]
    FENUMORG,             -- Original item [qfenumorg]
    KZSYSFE,              -- SystematDefect [qkzsysfe]
    KZLOESCH,             -- Delete [kzloesch]
    POSNR,                -- Sort Number [qlfdpos]
    HERPOS,               -- Oritin of item [qmfeherk]
    AUTKZ,                -- Object autom. [qautkz]
    MATNR,                -- Material [matnr]
    WERKS,                -- Plant [werks_d]
    LGORT,                -- Location [lgort_d]
    EKORG,                -- Purchasing Org. [ekorg]
    INFNR,                -- Info Record [infnr]
    KOSTL,                -- Cost Center [kostl]
    LSTAR,                -- Activity Type [lstar]
    PRZNR,                -- Business Process [co_prznr]
    MENGE,                -- Quantity [qmgpos]
    PRUEFLOS,             -- Inspection Lot [qplos]
    CHARG,                -- Batch [charg_d]
    OA_ID,                -- Operation Activity [mpe_oa_id]
    OA_VERSION_NO,        -- OA Version [mpe_oa_version_no]
    DEFREFNUM,            -- Defect Key [qdefrefnum]
    RBNR,                 -- Catalog Profile [rbnr]
    CHANGEDDATETIME,      -- Time Stamp [tzntstmps]
    STATLCYCLE,           -- Defect Status [qdeflcyclestat]
    STATACYCLE,           -- Defect Archiving Status [qdefacyclestat]
    STATPANALYSIS,        -- Problem Analysis [qdefpanastat]
    EXTREFNUM,            -- Reference Number [qextrefnum]
    ISAUTOCREATED,        -- Created Automat. [qisdefectcreatedautomatically]
    INTERNALID,           -- Internal Defect ID [qdefectinternalid]
    REPUSER,              -- Reported By [qfrepuser]
    REPONDATE,            -- Reported On [qfrepondate]
    REPATTIME,            -- Reported At [qfrepattime]
    DEFECTUUID,           -- Defect UUID [qdefectuuid]
    DEFECTCAUSEDBY,       -- Defect Caused By [qdefectcausedby]
    BOM_ITEM_INSTANCE,    -- DMU GUID [dmu_guid16]
    PRIMARY KEY (MANDT, QMNUM, FENUM)
);

Learn More