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