QMEL

Quality Notification | #transactional | Component: Maintenance Notifications
Column Name Description
MANDT FK Client
QMNUM Notification Number
Column Name Description
💲 Currency Key (WAERS):
ESTIMATED_COSTS Estimated Costs for a Claim
CLAIMED_COSTS Costs Claimed
RESULT_COSTS Costs Accepted
Column Name Description
📏 Unit of Measure (MGEIN):
MGEIG Defective Quantity (Internal)
MGFRD Defective Quantity (External)
BZMNG General Reference Quantity
RKMNG Complaint Quantity
RGMNG Return Delivery Quantity
Column Name Description
ERDAT Date on which the record was created
AEDAT Last Changed On
MZEIT Time of Notification
QMDAT Date of Notification
STRMN Required start date
STRUR Required Start Time
LTRMN Required End Date
LTRUR Required End Time
QMDAB Date for Notification Completion
QMZAB Completion Time of Notification
BEZDT Notification Reference Date
BEZUR Notification Reference Time
BSTDK Customer Reference Date
AEZEIT Time of Change
ERZEIT Time at Which Record Was Added
RKDAT Date of Return Delivery
PRODDAT Production Date
/SAPSMOSS/ERDAT Date on which notification was completed at SAP
/SAPSMOSS/ERZEIT Time when notification was completed at SAP
/ISDFPS/MHIO_ADDATE Completion Date for Call Object
/ISDFPS/MHIO_ADTIME Completion Time for Call Object
Column Name Description
KZKRI Indicator: Critical part Show values
KZDKZ Documentation required indicator Show values
HERKZ Origin of Notification Show values
CROBJTY Object types of the CIM resource Show values
CVP_XBLCK Business Purpose Completed Flag Show values
AUTKZ Data Record Created with Function 'Create with Copy Model' Show values
TSEGFL Time segment exists Show values
TZONID Origin of Time Zone in Notification Show values
CHANCE Chance of Completing a Claim Show values
OPPONENT Partner Type Show values
PHASE Notification Processing Phase Show values
SHN_OBJTY Object types of the CIM resource Show values
SHN_ORIGIN Origin or Use of Shift Note or Report Show values
Column Name Description Domain name
QMTXT Short Text TEXT40
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
QMNAM Name of Person Reporting Notification USNAM
REVLV Revision Level REVLV
FEKNZ Defect Records Exist CHAR1
MAKNZ Task Records Exist CHAR1
RBNRI Origin of Notifications Catalog Profile RBNRI
INDTX Object Long Text Available CHAR1
KZMLA Primary language indicator for text segment CHAR1
BUNAME Author of a QM/PM Notification XUBNAME
BSTNK Customer Reference BSTKD
ADRNR Addresses: Address Number CADRNR
QMCOD Coding QCODE
LICHN Supplier Batch Number LICHN
FERTAUFPL Plan Number for Operations in Order (Production Order) AUFPL
MJAHR Material Document Year GJAHR
MBLNR Number of Material Document BELNR
MBLPO Item in Material Document MBLPO
PNLKN Current Node Number from Order Counter KNTNR
REFNUM External Reference Number CHAR020
KDMAT Material Number Used by Customer IDNEX
IDNLF Material Number Used by Supplier IDNEX
SERIALNR Serial Number GERNR
KZLOESCH Delete Data Record CHAR1
DEVICEID Additional Device Data DEVICEID
BEDID ID of the Capacity Requirements Record BEDID
BEDZL Internal counter CIM_COUNT
PROFIL_TYP Object Type OTYPE
PROFIL_ID Object ID NUM08
HANDLE Globally unique identifier (linked to time segment, etc) SYSUUID_22
FUNKTION Keys for Function in Action Box CHAR4
/SAPSMOSS/MNUMM SAPNet notification number /SAPSMOSS/MNUMM
/SAPSMOSS/COMP Area /SAPSMOSS/R3COMP
/SAPSMOSS/TSTMP SAPNet time stamp TZNTIMESTP
/SAPSMOSS/SYSID Name of SAP System SYCHAR08
/SAPSMOSS/MANDT Client ID MANDT
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR
KALVAR Costing Variant for Postprocessing with Unit Costing KLVAR
DUMMY_QMEL_INCL_EEW_PS Dummy function in length 1 DUMMY
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
/ISDFPS/USERMODE Scheduling determined by user CHAR1
/ISDFPS/OBJNR Object number J_OBJNR
LOGSYSTEM Logical System LOGSYS
/ISDFPS/MEQUI Master Equipment EQUNR
SHN_OBJID Object ID of the resource CR_OBJID
SHN_FUNCT_LOC Functional Location TPLNR
SHN_EQUIPMENT Equipment Number EQUNR
UII Unique Item Identifier UII_CHAR72
Master Data Relations Join Conditions
Add-on ID
  • Add-on ID
  • Client
Add-On Release
  • Add-On Release
  • Client
Database system
  • Database system
  • Client
Frontend
  • Frontend
  • Client
Installation number
Operating system and version
R/3 Release
Status of R/3 notification in SAPNet QMEL./SAPSMOSS/STATUS == /SAPSMOSS/STAT.STATUS
R/3 System type
Foreign key work center
  • Object ID of the Work Center
  • Object types of the CIM resource
  • Client
  • QMEL.ARBPL == CRID.OBJID
  • QMEL.CROBJTY == CRID.OBJTY
  • QMEL.MANDT == CRID.MANDT
Plant for Work Center
  • QMEL.MANDT == T001W.MANDT
  • QMEL.ARBPLWERK == T001W.WERKS
Priority Type
  • QMEL.MANDT == T356A.MANDT
  • QMEL.ARTPR == T356A.ARTPR
Order Number
  • Order Number
  • Client
  • QMEL.AUFNR == AUFK.AUFNR
  • QMEL.MANDT == AUFK.MANDT
Key for a Scenario
  • Key for a Scenario
  • Client
  • QMEL.AUSWIRK == TQ81.AUSWIRK
  • QMEL.MANDT == TQ81.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • QMEL.BKGRP == T024.EKGRP
  • QMEL.MANDT == T024.MANDT
Batch Number
  • Material Number
  • Client
  • Batch Number
  • QMEL.MATNR == MCH1.MATNR
  • QMEL.MANDT == MCH1.MANDT
  • QMEL.CHARG == MCH1.CHARG
Order Number (QM Order)
  • Order Number (QM Order)
  • Client
  • QMEL.COAUFNR == AUFK.AUFNR
  • QMEL.MANDT == AUFK.MANDT
Purchasing organization
  • QMEL.MANDT == T024E.MANDT
  • QMEL.EKORG == T024E.EKORG
Material number corresponding to manufacturer part number
  • Material number corresponding to manufacturer part number
  • Client
  • QMEL.EMATNR == MARA.MATNR
  • QMEL.MANDT == MARA.MANDT
Report Type for Defects Recording
  • QMEL.MANDT == TQ86.MANDT
  • QMEL.FEART == TQ86.FEART
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • QMEL.FERTAUFNR == AUFK.AUFNR
  • QMEL.MANDT == AUFK.MANDT
Number of Manufacturer
  • QMEL.MANDT == LFA1.MANDT
  • QMEL.HERSTELLER == LFA1.LIFNR
Account Number of Customer
  • QMEL.MANDT == KNA1.MANDT
  • QMEL.KUNUM == KNA1.KUNNR
Storage Location of Batch
  • Storage Location of Batch
  • Client
  • Plant for Material
  • QMEL.LGORTCHARG == T001L.LGORT
  • QMEL.MANDT == T001L.MANDT
  • QMEL.MAWERK == T001L.WERKS
Storage Location for Inspection Lot Stock
  • Storage Location for Inspection Lot Stock
  • Client
  • Plant for Material
  • QMEL.LGORTVORG == T001L.LGORT
  • QMEL.MANDT == T001L.MANDT
  • QMEL.MAWERK == T001L.WERKS
Supplier Account Number
  • QMEL.MANDT == LFA1.MANDT
  • QMEL.LIFNUM == LFA1.LIFNR
Client QMEL.MANDT == T000.MANDT
Material Group
  • QMEL.MANDT == T023.MANDT
  • QMEL.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • QMEL.MATNR == MARA.MATNR
  • QMEL.MANDT == MARA.MANDT
Plant for Material
  • QMEL.MANDT == T001W.MANDT
  • QMEL.MAWERK == T001W.WERKS
Unit of Measure
  • QMEL.MANDT == T006.MANDT
  • QMEL.MGEIN == T006.MSEHI
Product hierarchy
  • Product hierarchy
  • Client
  • QMEL.PRDHA == T179.PRODH
  • QMEL.MANDT == T179.MANDT
Priority
  • Priority Type
  • Client
  • Priority
  • QMEL.ARTPR == T356.ARTPR
  • QMEL.MANDT == T356.MANDT
  • QMEL.PRIOK == T356.PRIOK
Notification Type
  • QMEL.MANDT == TQ80.MANDT
  • QMEL.QMART == TQ80.QMART
Code Group - Coding
  • Catalog Type - Coding
  • Client
  • Code Group - Coding
  • QMEL.QMKAT == QPGR.KATALOGART
  • QMEL.MANDT == QPGR.MANDT
  • QMEL.QMGRP == QPGR.CODEGRUPPE
Catalog Type - Coding
  • QMEL.MANDT == TQ15.MANDT
  • QMEL.QMKAT == TQ15.KATALOGART
Catalog Profile
  • QMEL.MANDT == T352B.MANDT
  • QMEL.RBNR == T352B.RBNR
Material Number of Production Version
  • Plant of Production Version
  • Material Number of Production Version
  • Production Version
  • Client
  • QMEL.RM_WERKS == MKAL.WERKS
  • QMEL.RM_MATNR == MKAL.MATNR
  • QMEL.VERID == MKAL.VERID
  • QMEL.MANDT == MKAL.MANDT
Plant of Production Version
  • Plant of Production Version
  • Material Number of Production Version
  • Production Version
  • Client
  • QMEL.RM_WERKS == MKAL.WERKS
  • QMEL.RM_MATNR == MKAL.MATNR
  • QMEL.VERID == MKAL.VERID
  • QMEL.MANDT == MKAL.MANDT
Run schedule header number
  • Run schedule header number
  • Client
  • QMEL.SA_AUFNR == SAFK.AUFNR
  • QMEL.MANDT == SAFK.MANDT
Division
  • QMEL.MANDT == TSPA.MANDT
  • QMEL.SPART == TSPA.SPART
Usage of Parts
  • Usage of Parts
  • Client
  • QMEL.TEILEV == TQ81V.TEILEV
  • QMEL.MANDT == TQ81V.MANDT
Time Zone for Notification
  • QMEL.MANDT == TTZZ.CLIENT
  • QMEL.TZONSO == TTZZ.TZONE
Production Version
  • Plant of Production Version
  • Material Number of Production Version
  • Production Version
  • Client
  • QMEL.RM_WERKS == MKAL.WERKS
  • QMEL.RM_MATNR == MKAL.MATNR
  • QMEL.VERID == MKAL.VERID
  • QMEL.MANDT == MKAL.MANDT
Sales group
  • Sales group
  • Sales office
  • QMEL.MANDT == TVBVK.MANDT
  • QMEL.VKGRP == TVBVK.VKGRP
  • QMEL.VKBUR == TVBVK.VKBUR
Sales Organization
  • QMEL.MANDT == TVKO.MANDT
  • QMEL.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • QMEL.VTWEG == TVTW.VTWEG
  • QMEL.MANDT == TVTW.MANDT
Currency Key
  • QMEL.MANDT == TCURC.MANDT
  • QMEL.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • QMEL.VKORG == TVKBZ.VKORG
  • QMEL.MANDT == TVKBZ.MANDT
  • QMEL.VTWEG == TVKBZ.VTWEG
  • QMEL.SPART == TVKBZ.SPART
  • QMEL.VKBUR == TVKBZ.VKBUR