SAP ABAP Table MCQMEL (Notification)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ QM-QC-IS (Application Component) Information System
⤷ QG04 (Package) QM/BW Connection
⤷ QM-QC-IS (Application Component) Information System
⤷ QG04 (Package) QM/BW Connection
Basic Data
Table Category | INTTAB | Structure |
Structure | MCQMEL | Table Relationship Diagram |
Short Description | Notification |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Communication Structure: Notification - Characteristics | |||||
2 | QMNUM | QMNUM | QMNUM | CHAR | 12 | 0 | Message Number | * | |
3 | QMART | QMART | QMART | CHAR | 2 | 0 | Message Type | * | |
4 | OBJNR_NTF | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
5 | HERKZ | HERKZ | HERKZ | CHAR | 2 | 0 | Origin Indicator for Notification | ||
6 | QMKAT | QMKAT | QKATART | CHAR | 1 | 0 | Catalog type - coding | * | |
7 | QMGRP | QMGRP | QCODEGRP | CHAR | 8 | 0 | Code group - coding | * | |
8 | QMCOD | QMCOD | QCODE | CHAR | 4 | 0 | Coding | * | |
9 | .INCLUDE | 0 | 0 | Communication Structure: Notification - Chars Ref. to Matl | |||||
10 | MAWERK | QMAWERKS | WERKS | CHAR | 4 | 0 | Plant for Material | * | |
11 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
12 | REVLV | REVLV | REVLV | CHAR | 2 | 0 | Revision level | ||
13 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
14 | LGORTCHARG | QLGORTCHAR | LGORT | CHAR | 4 | 0 | Storage Location of Batch | * | |
15 | SERIALNR | GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
16 | MJAHR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
17 | MBLNR | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
18 | MBLPO | QMBLPO | MBLPO | NUMC | 4 | 0 | Item in Material Document | ||
19 | LGORTVORG | QLGORTVORG | LGORT | CHAR | 4 | 0 | Storage Location for Inspection Lot Stock | * | |
20 | .INCLUDE | 0 | 0 | Comm. Structure: Notifs - Characteristics w/ Ref. Customer | |||||
21 | KUNUM | KUNUM | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
22 | KUNWE | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
23 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
24 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
25 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
26 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
27 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
28 | VBELN | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
29 | BSTNK | BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
30 | BSTDK | BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
31 | LS_KDAUF | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | * | |
32 | LS_KDPOS | KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
33 | LS_VBELN | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
34 | LS_POSNR | QPOSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
35 | KDMAT | MATNR_KU | IDNEX | CHAR | 35 | 0 | Customer Material Number | ||
36 | .INCLUDE | 0 | 0 | Communication Structure: Notif.- Chars Reference to Vendor | |||||
37 | LIFNUM | LIFNUM | LIFNR | CHAR | 10 | 0 | Vendor Account Number | * | |
38 | HERSTELLER | QLIFNR | LIFNR | CHAR | 10 | 0 | Number of Manufacturer | * | |
39 | EMATNR | EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
40 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
41 | BKGRP | BKGRP | EKGRP | CHAR | 3 | 0 | Purchasing Group | * | |
42 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
43 | EBELP | QEBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
44 | .INCLUDE | 0 | 0 | Communication Structure: Notification - Internal Characs | |||||
45 | FERTAUFNR | FERTAUFNR | AUFNR | CHAR | 12 | 0 | Order Number (Production Order) | * | |
46 | FERTAUFPL | FERTAUFPL | AUFPL | NUMC | 10 | 0 | Plan Number for Operations in Order (Production Order) | ||
47 | COAUFNR | COAUFNR | AUFNR | CHAR | 12 | 0 | Order Number (QM Order) | * | |
48 | BUNAME | BUNAME | XUBNAME | CHAR | 12 | 0 | Author of a Q/PM Notification | * | |
49 | .INCLUDE | 0 | 0 | Communication Structure: Notif.- Chars Reference to Service | |||||
50 | IWERK | IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | * | |
51 | INGRP | INGRP | INGRP | CHAR | 3 | 0 | Planner Group for Customer Service and Plant Maintenance | * | |
52 | TPLNR | TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | * | |
53 | EQUNR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
54 | BAUTL_HD | BAUTL | MATNR | CHAR | 18 | 0 | Assembly | * | |
55 | EBORT_HD | EBORT | TEXT20 | CHAR | 20 | 0 | Installation Point for Subitem | ||
56 | BTPLN | BTPLN | TPLNR | CHAR | 30 | 0 | Functional Location Affected | * | |
57 | BEQUI | BEQUI | EQUNR | CHAR | 18 | 0 | Equipment Affected | * | |
58 | INSPK | INSPK | USNAM | CHAR | 12 | 0 | Name of Person Responsible for Technical Inspection | ||
59 | CROBJTY | PM_OBJTY | CR_OBJTY | CHAR | 2 | 0 | Object Type of CIM Resources for Work Center | ||
60 | ARBPL | LGWID | CR_OBJID | NUMC | 8 | 0 | Object ID of the Work Center | * | |
61 | ARBPLWERK | QARBPWERKS | WERKS | CHAR | 4 | 0 | Plant for Work Center | * | |
62 | GEWRK | GEWRK | ARBPL | CHAR | 8 | 0 | Main work center for maintenance tasks | ||
63 | .INCLUDE | 0 | 0 | Comm. structure: Location and account assignment (PM/CS) | |||||
64 | ABCKZ | ABCKZ | ABCKZ | CHAR | 1 | 0 | ABC Indicator for Technical Object | * | |
65 | SWERK | SWERK | WERKS | CHAR | 4 | 0 | Maintenance Plant | * | |
66 | STORT | STORT | AP_STAND | CHAR | 10 | 0 | Asset location | * | |
67 | BEBER | BEBER | BEBER | CHAR | 3 | 0 | Organizational Area | * | |
68 | MSGRP | RAUMNR | CHAR8 | CHAR | 8 | 0 | Room | ||
69 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
70 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
71 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
72 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
73 | .INCLUDE | 0 | 0 | Communication Structure: Notif. Structure: Local Time Stamp | |||||
74 | QMNAM | QMNAM | USNAM | CHAR | 12 | 0 | Name of declarant | ||
75 | QMDAT | QMDAT | DATUM | DATS | 8 | 0 | Date of Notification | ||
76 | MZEIT | MZEIT | UHRZT | TIMS | 6 | 0 | Notification Time | ||
77 | QMDAB | QMDAB | DATUM | DATS | 8 | 0 | Date for Completion of Notification | ||
78 | QMZAB | QMZAB | UZEIT | TIMS | 6 | 0 | Completion Time of Notification | ||
79 | STRMN | STRMN | DATUM | DATS | 8 | 0 | Desired Start Date | ||
80 | STRUR | STRUR | UZEIT | TIMS | 6 | 0 | Desired Start Time | ||
81 | LTRMN | LTRMN | DATUM | DATS | 8 | 0 | Required Finish Date | ||
82 | LTRUR | LTRUR | UZEIT | TIMS | 6 | 0 | Required End Date-Time | ||
83 | .INCLUDE | 0 | 0 | Communication Structure: Notification - System Time Stamp | |||||
84 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
85 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
86 | ERZEIT | ERZEIT | UHRZT | TIMS | 6 | 0 | Time, at Which Record Was Added | ||
87 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
88 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
89 | AEZEIT | AEZEIT | UHRZT | TIMS | 6 | 0 | Time of Change | ||
90 | .INCLUDE | 0 | 0 | Communication Structure: Notification - Key Figures | |||||
91 | EHTAG | QEINHTAG | MEINS | UNIT | 3 | 0 | Lead Time Unit (Day) | * | |
92 | BASIC_UNIT | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
93 | MGEIN | MGEIN | MEINS | UNIT | 3 | 0 | Unit of Measure | * | |
94 | ZHLMELD | QZHLMELD | INT4 | INT4 | 10 | 0 | No. of Notifications | ||
95 | ZHLMOFN | QZHLMOFN | INT4 | INT4 | 10 | 0 | No. of Notifications with Status Outstanding | ||
96 | ZHLERL_TE | QZHLERL_TE | INT4 | INT4 | 10 | 0 | Number of Notifications Completed on Schedule | ||
97 | SUMDLZT | QNSUMDLZT | QSTATWERT | FLTP | 16 | 16 | Total Lead Time of Notifications | ||
98 | ZHLMASS | QZHLMASS | INT4 | INT4 | 10 | 0 | No. of Tasks | ||
99 | ZHLMAOF | QZHLMAOF | INT4 | INT4 | 10 | 0 | Number of Tasks with Status 'Outstanding' or 'Released' | ||
100 | ZHLMERF | QZHLMERF | INT4 | INT4 | 10 | 0 | No. of Tasks with Status Successful | ||
101 | MGEIG | MGEIG | MENGE | QUAN | 13 | 3 | Defective Quantity (Internal) | ||
102 | BMGEIG | BMGEIG | MENGE | QUAN | 13 | 3 | Internal Defective Quantity in Base Units of Measure | ||
103 | MGFRD | MGFRD | MENGE | QUAN | 13 | 3 | Defective Quantity (External) | ||
104 | BMGFRD | BMGFRD | MENGE | QUAN | 13 | 3 | External Defective Quantity in Base Units of Measure | ||
105 | RKMNG | RKMNG | MENGE | QUAN | 13 | 3 | Complaint Quantity | ||
106 | BRKMNG | BRKMNG | MENGE | QUAN | 13 | 3 | Complaint Quantity in Base Units of Measure | ||
107 | RGMNG | RGMNG | MENGE | QUAN | 13 | 3 | Return Delivery Quantity | ||
108 | BRGMNG | BRGMNG | MENGE | QUAN | 13 | 3 | Return Delivery Quantity in Base Units of Measure | ||
109 | MSAUS | MSAUS | XFELD | CHAR | 1 | 0 | Breakdown Indicator | ||
110 | AUSZT1 | AUSZT | FLTP | FLTP | 16 | 16 | Breakdown Duration | ||
111 | SUNIT | MAUEH | MEINS | UNIT | 3 | 0 | Unit for Breakdown Duration | * | |
112 | .INCLUDE | 0 | 0 | Comm Structure: Message -Breakdowns | |||||
113 | AUSVN | AUSVN | DATUM | DATS | 8 | 0 | Start of Malfunction (Date) | ||
114 | AUSBS | AUSBS | DATUM | DATS | 8 | 0 | End of Malfunction (Date) | ||
115 | AUZTV | AUZTV | UHRZT | TIMS | 6 | 0 | Start of Malfunction (Time) | ||
116 | AUZTB | AUZTB | UHRZT | TIMS | 6 | 0 | End of Malfunction (Time) | ||
117 | .INCLUDE | 0 | 0 | PM-BW: Extraction Structure for Linear Data | |||||
118 | START_POINT | EAML_START_POINT | EAML_POINT | CHAR | 18 | 0 | Start Point | ||
119 | END_POINT | EAML_END_POINT | EAML_POINT | CHAR | 18 | 0 | End Point | ||
120 | LINEAR_LENGTH | EAML_LINEAR_LENGTH_SI | EAML_POINT_SI | FLTP | 16 | 16 | Length in SI Unit | ||
121 | LINEAR_UNIT | EAML_LINEAR_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Linear Data | * | |
122 | .INCLUDE | 0 | 0 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |