SAP Table QMEL - Quality Notification

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
QMNUM X QMNUM CHAR 3 12 0 QMEL Notification No
QMART QMART CHAR 15 2 0 TQ80 Notification Type
QMTXT QMTXT CHAR 17 40 0 Short Text
ARTPR ARTPR CHAR 57 2 0 T356A Priority Type
PRIOK PRIOK CHAR 59 1 0 T356 Priority
ERNAM ERNAM CHAR 60 12 0 Name of Person who Created the Object
ERDAT ERDAT DATS 72 8 0 Date on Which Record Was Created
AENAM AENAM CHAR 80 12 0 Name of Person Who Changed Object
AEDAT AEDAT DATS 92 8 0 Changed On
MZEIT MZEIT TIMS 100 6 0 Time of Notification
QMDAT QMDAT DATS 106 8 0 Date of Notification
QMNAM QMNAM CHAR 114 12 0 Name of Person Reporting Notification
STRMN STRMN DATS 126 8 0 Required start date
STRUR STRUR TIMS 134 6 0 Required Start Time
LTRMN LTRMN DATS 140 8 0 Required End Date
LTRUR LTRUR TIMS 148 6 0 Requested End Time
WAERS WAERS CUKY 154 5 0 TCURC Currency Key
AUFNR AUFNR CHAR 159 12 0 AUFK Order Number
VERID VERID CHAR 171 4 0 Production Version
RM_MATNR RM_MATNR CHAR 175 18 0 MARA Material number of the production version
RM_WERKS RM_WERKS CHAR 193 4 0 T001W Plant of production version
SA_AUFNR SA_AUFNR CHAR 197 12 0 Run schedule header number
MATNR MATNR CHAR 209 18 0 MARA Material Number
REVLV REVLV CHAR 227 2 0 Revision Level
MATKL MATKL CHAR 229 9 0 T023 Material Group
PRDHA PRODH_D CHAR 238 18 0 T179 Product hierarchy
KZKRI KZKRI CHAR 256 1 0 Indicator: Critical part
KZDKZ KZDKZ CHAR 257 1 0 Documentation required indicator
KUNUM QKUNUM CHAR 258 10 0 KNA1 Account Number of Customer
FEKNZ FEKNZ CHAR 268 1 0 Error Records Exist
MAKNZ MAKNZ CHAR 269 1 0 Task Records Exist
OBJNR QMOBJNR CHAR 270 22 0 ONR00 Object Number for Status Management
QMDAB QMDAB DATS 292 8 0 Date for Notification Completion
QMZAB QMZAB TIMS 300 6 0 Completion Time of Notification
RBNR RBNR CHAR 306 9 0 T352B Catalog Profile
RBNRI RBNRI CHAR 315 1 0 Origin of Notifications Catalog Profile
INDTX INDLTX CHAR 316 1 0 Object Long Text Available
KZMLA KZMLA CHAR 317 1 0 Primary language indicator for text segment
HERKZ HERKZ CHAR 318 2 0 Origin of Notification
BEZDT BEZDT DATS 320 8 0 Notification Reference Date
BEZUR BEZUR_D TIMS 328 6 0 Notification Reference Time
LIFNUM LIFNUM CHAR 334 10 0 LFA1 Vendor Account Number
BUNAME BUNAME CHAR 344 12 0 USR02 Author of a Q/PM Notification
VBELN KDAUF CHAR 356 10 0 Sales Order Number
BSTNK BSTKD CHAR 366 35 0 Customer purchase order number
BSTDK BSTDK DATS 401 8 0 Customer purchase order date
SPART SPART CHAR 409 2 0 TSPA Division
VKORG VKORG CHAR 411 4 0 TVKO Sales Organization
VTWEG VTWEG CHAR 415 2 0 TVTW Distribution Channel
ADRNR CADNR CHAR 417 10 0 Addresses: Address Number
AEZEIT AEZEIT TIMS 427 6 0 Time of Change
ERZEIT ERZEIT TIMS 433 6 0 Time, at Which Record Was Added
MAWERK QMAWERKS CHAR 439 4 0 T001W Plant for Material
QMKAT QMKAT CHAR 443 1 0 Catalog Type - Coding
QMGRP QMGRP CHAR 444 8 0 QPGR Code Group - Coding
QMCOD QMCOD CHAR 452 4 0 QPCD Coding
AUSWIRK QSCENARIO CHAR 456 4 0 Key for a Scenario
TEILEV QTEILEV CHAR 460 4 0 Usage of Parts
PRUEFLOS QPLOS NUMC 464 12 0 QALS Inspection Lot Number
CHARG CHARG_D CHAR 476 10 0 MCH1 Batch Number
LGORTCHARG QLGORTCHAR CHAR 486 4 0 T001L Storage Location of Batch
LICHN LICHN CHAR 490 15 0 Vendor Batch Number
HERSTELLER QLIFNR CHAR 505 10 0 LFA1 Number of Manufacturer
EMATNR EMATN CHAR 515 18 0 MARA Material Number Corresponding to Manufacturer Part Number
EKORG EKORG CHAR 533 4 0 T024E Purchasing Organization
BKGRP BKGRP CHAR 537 3 0 T024 Purchasing Group
LGORTVORG QLGORTVORG CHAR 540 4 0 T001L Storage Location for Inspection Lot Stock
FERTAUFNR FERTAUFNR CHAR 544 12 0 AUFK Order Number (Production Order)
FERTAUFPL FERTAUFPL NUMC 556 10 0 Plan Number for Operations in Order (Production Order)
EBELN EBELN CHAR 566 10 0 EKKO Purchasing Document Number
EBELP QEBELP NUMC 576 5 0 EKPO Item Number of Purchasing Document
MJAHR MJAHR NUMC 581 4 0 Material Document Year
MBLNR MBLNR CHAR 585 10 0 Number of Material Document
MBLPO QMBLPO NUMC 595 4 0 Item in Material Document
LS_KDAUF KDAUF CHAR 599 10 0 Sales Order Number
LS_KDPOS POSNR NUMC 609 6 0 Item number of the SD document
LS_VBELN VBELN_VL CHAR 615 10 0 Delivery
LS_POSNR QPOSNR_VL NUMC 625 6 0 Delivery Item
CROBJTY CR_OBJTY CHAR 631 2 0 Object types of the CIM resource
ARBPL LGWID NUMC 633 8 0 CRID Object ID of the Work Center
ARBPLWERK QARBPWERKS CHAR 641 4 0 T001W Plant for Work Center
FEART QFEART CHAR 645 8 0 Report Type for Defects Recording
PNLKN QLFNKN NUMC 653 8 0 Current Node Number from Order Counter APLZL
MGEIG MGEIG QUAN 661 13 3 Defective Quantity (Internal)
MGFRD MGFRD QUAN 668 13 3 Defective Quantity (External)
MGEIN MGEIN UNIT 675 3 0 T006 Unit of Measure
BZMNG QBZMNG QUAN 678 13 3 General Reference Quantity
RKMNG RKMNG QUAN 685 13 3 Complaint Quantity
RGMNG RGMNG QUAN 692 13 3 Return Delivery Quantity
RKDAT RKDAT DATS 699 8 0 Date of Return Delivery
COAUFNR COAUFNR CHAR 707 12 0 AUFK Order Number (QM Order)
QWRNUM QWRNUM CHAR 719 12 0 QMEL Reference Notification Number
REFNUM QMEXTNR CHAR 731 20 0 External Reference Number
KDMAT MATNR_KU CHAR 751 35 0 Material Number Used by Customer
IDNLF IDNLF CHAR 786 35 0 Material Number Used by Vendor
SERIALNR GERNR CHAR 821 18 0 Serial Number
KZLOESCH KZLOESCH CHAR 839 1 0 Delete Data Record
PRODDAT QPRODDAT DATS 840 8 0 Production Date
DEVICEID DEVICEID CHAR 848 40 0 Additional Device Data
VKBUR VKBUR CHAR 888 4 0 TVBUR Sales Office
VKGRP VKGRP CHAR 892 3 0 TVKGR Sales Group
AUTKZ QAUTKZ CHAR 895 1 0 Data Record Created with Function 'Create with Copy Model'
BEDID BEDID NUMC 896 12 0 ID of the capacity requirements record
BEDZL CIM_COUNT NUMC 908 8 0 Internal counter
PROFIL_TYP OTYPE CHAR 916 2 0 T778O Object Type
PROFIL_ID OBJEKTID NUMC 918 8 0 Object ID
HANDLE TSEGGUID CHAR 926 22 0 Globally unique identifier (linked to time segment, etc)
TSEGFL TSEGEXISTS CHAR 948 1 0 Time segment exists
TSEGTP TSEGTEMPLA CHAR 949 10 0 Template
TZONSO TZONSO CHAR 959 6 0 TTZZ Time Zone for Notification
TZONID TZONSMID CHAR 965 1 0 Origin of Time Zone in Notification
FUNKTION QNFUNKTION CHAR 966 4 0 Keys for Function in Action Box
/SAPSMOSS/INSTN /SAPSMOSS/R3INSTN CHAR 970 10 0 /SAPSMOSS/INSTN Installation number
/SAPSMOSS/MNUMM /SAPSMOSS/MNUMM NUMC 980 24 0 SAPNet notification number
/SAPSMOSS/OSSYS /SAPSMOSS/OSSYS CHAR 1004 10 0 /SAPSMOSS/OSYS Operating system and version
/SAPSMOSS/DBSYS /SAPSMOSS/DBSYS CHAR 1014 10 0 /SAPSMOSS/DBSY Database system
/SAPSMOSS/REL /SAPSMOSS/R3REL CHAR 1024 10 0 /SAPSMOSS/REL R/3 Release
/SAPSMOSS/COMP /SAPSMOSS/R3COMP CHAR 1034 20 0 Area
/SAPSMOSS/FRONT /SAPSMOSS/FRONTEND CHAR 1054 10 0 /SAPSMOSS/FRNT Frontend
/SAPSMOSS/SYSTYP /SAPSMOSS/R3SYSTYPE CHAR 1064 1 0 /SAPSMOSS/SYST R/3 System type
/SAPSMOSS/ADDID /SAPSMOSS/R3ADDID CHAR 1065 10 0 /SAPSMOSS/ADDID Add-on ID
/SAPSMOSS/ADDREL /SAPSMOSS/R3ADDREL CHAR 1075 10 0 /SAPSMOSS/ADDRL Add-On Release
/SAPSMOSS/TSTMP /SAPSMOSS/NSTSTMP NUMC 1085 14 0 SAPNet time stamp
/SAPSMOSS/STATUS /SAPSMOSS/STATUS CHAR 1099 1 0 /SAPSMOSS/STAT Status of R/3 notification in SAPNet
/SAPSMOSS/ERDAT /SAPSMOSS/ERDAT DATS 1100 8 0 Date on which notification was completed at SAP
/SAPSMOSS/ERZEIT /SAPSMOSS/ERZEIT TIMS 1108 6 0 Time when notification was completed at SAP
/SAPSMOSS/SYSID SYSYSID CHAR 1114 8 0 Name of the SAP System
/SAPSMOSS/MANDT SYMANDT CLNT 1122 3 0 T000 Client ID of Current User
PSP_NR PS_POSNR NUMC 1125 8 0 PRPS WBS Element
ESTIMATED_COSTS PS_COSTS CURR 1133 13 2 Estimated Costs for a Claim
CLAIMED_COSTS COSTS_CLAIM CURR 1140 13 2 Costs Claimed
RESULT_COSTS COSTS_RESULT CURR 1147 13 2 Costs Accepted
CHANCE PS_CHANCE NUMC 1154 2 0 Chance of Completing a Claim
OPPONENT PS_OPPONENT CHAR 1156 2 0 Partner Type
KALNR CK_KALNR NUMC 1158 12 0 Cost Estimate Number for Cost Est. w/o Qty Structure
KALVAR CK_KALVAR CHAR 1170 4 0 TCK03 Costing Variant for Postprocessing with Unit Costing
OBJNR_REAL J_OBJNR_REAL CHAR 1174 22 0 ONR00 Object number of real CO account assignment
OBJNR_STAT OBJNR_N1 CHAR 1196 22 0 ONR00 Auxiliary account assignment 1
PHASE QM_PHASE CHAR 1218 1 0 Notification Processing Phase
/ISDFPS/OBJNR J_OBJNR CHAR 1219 22 0 ONR00 Object number
LOGSYSTEM LOGSYSTEM CHAR 1241 10 0 Logical System
/ISDFPS/MEQUI /ISDFPS/MEQUI CHAR 1251 18 0 Master Equipment
SHN_OBJTY CR_OBJTY CHAR 1269 2 0 Object types of the CIM resource
SHN_OBJID CR_OBJID NUMC 1271 8 0 CRID Object ID of the resource
SHN_FUNCT_LOC TPLNR CHAR 1279 30 0 IFLOT Functional Location
SHN_EQUIPMENT EQUNR CHAR 1309 18 0 Equipment Number
SHN_ORIGIN COCF_SRN_ORIGIN NUMC 1327 2 0 Origin or Use of Shift Note or Report
UII UII_CHAR72 CHAR 1329 72 0 Unique Item Identifier

1554293Poor performance in EAM lists due to missing phase
757884IS-Healthcare: Additional indexes for SAP DB
604300FAQ: BAPI_ALM_NOTIF* and BAPI_SERVNOT*
365744Expensive SQL Statement on VIQMEL or VIAUFK
664088DB15: QAKL, AFVC, AFVV missing for archiving QM_CONTROL
551133Performance of notification sel.: Implementation of a phase
61861Performance improvement in PM & SM lists (indexes)
77791Error I0316 when archiving functional locations