This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →The table QMEL (Quality Notification) is a standard table in SAP ERP. It belongs to the package IWOC.
Table | QMEL |
Short Text | Quality Notification |
Package | IWOC |
Table Type | Transparent Table |
Field Name | Key | Description | Data Element | Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
QMNUM | ✔ | Notification No | QMNUM | CHAR | 12 | |
QMART | Notification Type | QMART | CHAR | 2 | TQ80 | |
QMTXT | Short Text | QMTXT | CHAR | 40 | ||
ARTPR | Priority Type | ARTPR | CHAR | 2 | T356A | |
PRIOK | Priority | PRIOK | CHAR | 1 | T356 | |
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | ||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | ||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | ||
AEDAT | Changed On | AEDAT | DATS | 8 | ||
MZEIT | Time of Notification | MZEIT | TIMS | 6 | ||
QMDAT | Date of Notification | QMDAT | DATS | 8 | ||
QMNAM | Name of Person Reporting Notification | QMNAM | CHAR | 12 | ||
STRMN | Required start date | STRMN | DATS | 8 | ||
STRUR | Required Start Time | STRUR | TIMS | 6 | ||
LTRMN | Required End Date | LTRMN | DATS | 8 | ||
LTRUR | Requested End Time | LTRUR | TIMS | 6 | ||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | |
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | |
VERID | Production Version | VERID | CHAR | 4 | MKAL | |
RM_MATNR | Material number of the production version | RM_MATNR | CHAR | 18 | MKAL | |
RM_WERKS | Plant of production version | RM_WERKS | CHAR | 4 | MKAL | |
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | SAFK | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | |
REVLV | Revision Level | REVLV | CHAR | 2 | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | |
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | |
KZKRI | Indicator: Critical part | KZKRI | CHAR | 1 | ||
KZDKZ | Documentation required indicator | KZDKZ | CHAR | 1 | ||
KUNUM | Account Number of Customer | QKUNUM | CHAR | 10 | KNA1 | |
FEKNZ | Error Records Exist | FEKNZ | CHAR | 1 | ||
MAKNZ | Task Records Exist | MAKNZ | CHAR | 1 | ||
OBJNR | Object Number for Status Management | QMOBJNR | CHAR | 22 | ONR00 | |
QMDAB | Date for Notification Completion | QMDAB | DATS | 8 | ||
QMZAB | Completion Time of Notification | QMZAB | TIMS | 6 | ||
RBNR | Catalog Profile | RBNR | CHAR | 9 | T352B | |
RBNRI | Origin of Notifications Catalog Profile | RBNRI | CHAR | 1 | ||
INDTX | Object Long Text Available | INDLTX | CHAR | 1 | ||
KZMLA | Primary language indicator for text segment | KZMLA | CHAR | 1 | ||
HERKZ | Origin of Notification | HERKZ | CHAR | 2 | ||
BEZDT | Notification Reference Date | BEZDT | DATS | 8 | ||
BEZUR | Notification Reference Time | BEZUR_D | TIMS | 6 | ||
LIFNUM | Vendor Account Number | LIFNUM | CHAR | 10 | LFA1 | |
BUNAME | Author of a Q/PM Notification | BUNAME | CHAR | 12 | * | |
VBELN | Sales Order Number | KDAUF | CHAR | 10 | VBUK | |
BSTNK | Customer purchase order number | BSTKD | CHAR | 35 | ||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | ||
SPART | Division | SPART | CHAR | 2 | TSPA | |
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | |
ADRNR | Addresses: Address Number | CADNR | CHAR | 10 | * | |
AEZEIT | Time of Change | AEZEIT | TIMS | 6 | ||
ERZEIT | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | ||
MAWERK | Plant for Material | QMAWERKS | CHAR | 4 | T001W | |
QMKAT | Catalog Type - Coding | QMKAT | CHAR | 1 | TQ15 | |
QMGRP | Code Group - Coding | QMGRP | CHAR | 8 | QPGR | |
QMCOD | Coding | QMCOD | CHAR | 4 | * | |
AUSWIRK | Key for a Scenario | QSCENARIO | CHAR | 4 | TQ81 | |
TEILEV | Usage of Parts | QTEILEV | CHAR | 4 | TQ81V | |
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QALS | |
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | |
LGORTCHARG | Storage Location of Batch | QLGORTCHAR | CHAR | 4 | T001L | |
LICHN | Vendor Batch Number | LICHN | CHAR | 15 | ||
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | LFA1 | |
EMATNR | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | MARA | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | |
BKGRP | Purchasing Group | BKGRP | CHAR | 3 | T024 | |
LGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4 | T001L | |
FERTAUFNR | Order Number (Production Order) | FERTAUFNR | CHAR | 12 | AUFK | |
FERTAUFPL | Plan Number for Operations in Order (Production Order) | FERTAUFPL | NUMC | 10 | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | |
EBELP | Item Number of Purchasing Document | QEBELP | NUMC | 5 | EKPO | |
MJAHR | Material Document Year | MJAHR | NUMC | 4 | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ||
MBLPO | Item in Material Document | QMBLPO | NUMC | 4 | ||
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | |
LS_KDPOS | Item number of the SD document | POSNR | NUMC | 6 | VBUP | |
LS_VBELN | Delivery | VBELN_VL | CHAR | 10 | VBUK | |
LS_POSNR | Delivery Item | QPOSNR_VL | NUMC | 6 | VBUP | |
CROBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | ||
ARBPL | Object ID of the Work Center | LGWID | NUMC | 8 | CRID | |
ARBPLWERK | Plant for Work Center | QARBPWERKS | CHAR | 4 | T001W | |
FEART | Report Type for Defects Recording | QFEART | CHAR | 8 | TQ86 | |
PNLKN | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | ||
MGEIG | Defective Quantity (Internal) | MGEIG | QUAN | 13 | ||
MGFRD | Defective Quantity (External) | MGFRD | QUAN | 13 | ||
MGEIN | Unit of Measure | MGEIN | UNIT | 3 | T006 | |
BZMNG | General Reference Quantity | QBZMNG | QUAN | 13 | ||
RKMNG | Complaint Quantity | RKMNG | QUAN | 13 | ||
RGMNG | Return Delivery Quantity | RGMNG | QUAN | 13 | ||
RKDAT | Date of Return Delivery | RKDAT | DATS | 8 | ||
COAUFNR | Order Number (QM Order) | COAUFNR | CHAR | 12 | AUFK | |
QWRNUM | Reference Notification Number | QWRNUM | CHAR | 12 | QMEL | |
REFNUM | External Reference Number | QMEXTNR | CHAR | 20 | ||
KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | ||
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | ||
SERIALNR | Serial Number | GERNR | CHAR | 18 | ||
KZLOESCH | Delete Data Record | KZLOESCH | CHAR | 1 | ||
PRODDAT | Production Date | QPRODDAT | DATS | 8 | ||
DEVICEID | Additional Device Data | DEVICEID | CHAR | 40 | ||
VKBUR | Sales Office | VKBUR | CHAR | 4 | TVKBZ | |
VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | |
AUTKZ | Data Record Created with Function 'Create with Copy Model' | QAUTKZ | CHAR | 1 | ||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | * | |
BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | ||
PROFIL_TYP | Object Type | OTYPE | CHAR | 2 | * | |
PROFIL_ID | Object ID | OBJEKTID | NUMC | 8 | ||
HANDLE | Globally unique identifier (linked to time segment, etc) | TSEGGUID | CHAR | 22 | ||
TSEGFL | Time segment exists | TSEGEXISTS | CHAR | 1 | ||
TSEGTP | Template | TSEGTEMPLA | CHAR | 10 | TTSEGTPLH | |
TZONSO | Time Zone for Notification | TZONSO | CHAR | 6 | TTZZ | |
TZONID | Origin of Time Zone in Notification | TZONSMID | CHAR | 1 | ||
FUNKTION | Keys for Function in Action Box | QNFUNKTION | CHAR | 4 | ||
/SAPSMOSS/INSTN | Installation number | /SAPSMOSS/R3INSTN | CHAR | 10 | /SAPSMOSS/INSTN | |
/SAPSMOSS/MNUMM | SAPNet notification number | /SAPSMOSS/MNUMM | NUMC | 24 | ||
/SAPSMOSS/OSSYS | Operating system and version | /SAPSMOSS/OSSYS | CHAR | 10 | /SAPSMOSS/OSYS | |
/SAPSMOSS/DBSYS | Database system | /SAPSMOSS/DBSYS | CHAR | 10 | /SAPSMOSS/DBSY | |
/SAPSMOSS/REL | R/3 Release | /SAPSMOSS/R3REL | CHAR | 10 | /SAPSMOSS/REL | |
/SAPSMOSS/COMP | Area | /SAPSMOSS/R3COMP | CHAR | 20 | ||
/SAPSMOSS/FRONT | Frontend | /SAPSMOSS/FRONTEND | CHAR | 10 | /SAPSMOSS/FRNT | |
/SAPSMOSS/SYSTYP | R/3 System type | /SAPSMOSS/R3SYSTYPE | CHAR | 1 | /SAPSMOSS/SYST | |
/SAPSMOSS/ADDID | Add-on ID | /SAPSMOSS/R3ADDID | CHAR | 10 | /SAPSMOSS/ADDID | |
/SAPSMOSS/ADDREL | Add-On Release | /SAPSMOSS/R3ADDREL | CHAR | 10 | /SAPSMOSS/ADDRL | |
/SAPSMOSS/TSTMP | SAPNet time stamp | /SAPSMOSS/NSTSTMP | NUMC | 14 | ||
/SAPSMOSS/STATUS | Status of R/3 notification in SAPNet | /SAPSMOSS/STATUS | CHAR | 1 | /SAPSMOSS/STAT | |
/SAPSMOSS/ERDAT | Date on which notification was completed at SAP | /SAPSMOSS/ERDAT | DATS | 8 | ||
/SAPSMOSS/ERZEIT | Time when notification was completed at SAP | /SAPSMOSS/ERZEIT | TIMS | 6 | ||
/SAPSMOSS/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | ||
/SAPSMOSS/MANDT | Client ID | SYMANDT | CLNT | 3 | * | |
PSP_NR | WBS Element | PS_POSNR | NUMC | 8 | * | |
ESTIMATED_COSTS | Estimated Costs for a Claim | PS_COSTS | CURR | 13 | ||
CLAIMED_COSTS | Costs Claimed | COSTS_CLAIM | CURR | 13 | ||
RESULT_COSTS | Costs Accepted | COSTS_RESULT | CURR | 13 | ||
CHANCE | Chance of Completing a Claim | PS_CHANCE | NUMC | 2 | ||
OPPONENT | Partner Type | PS_OPPONENT | CHAR | 2 | ||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | * | |
KALVAR | Costing Variant for Postprocessing with Unit Costing | CK_KALVAR | CHAR | 4 | * | |
OBJNR_REAL | Object number of real CO account assignment | J_OBJNR_REAL | CHAR | 22 | ONR00 | |
OBJNR_STAT | Auxiliary account assignment 1 | OBJNR_N1 | CHAR | 22 | ONR00 | |
PHASE | Notification Processing Phase | QM_PHASE | CHAR | 1 | ||
/ISDFPS/OBJNR | Object number | J_OBJNR | CHAR | 22 | * | |
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | * | |
/ISDFPS/MEQUI | Master Equipment | /ISDFPS/MEQUI | CHAR | 18 | * | |
SHN_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | ||
SHN_OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | * | |
SHN_FUNCT_LOC | Functional Location | TPLNR | CHAR | 30 | * | |
SHN_EQUIPMENT | Equipment Number | EQUNR | CHAR | 18 | * | |
SHN_ORIGIN | Origin or Use of Shift Note or Report | COCF_SRN_ORIGIN | NUMC | 2 | ||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 |