SAP ABAP Table RQMQMEL3 (General Notification - Notifications (Reporting))
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       QQM (Package) QM quality notification
Basic Data
Table Category INTTAB    Structure 
Structure RQMQMEL3   Table Relationship Diagram
Short Description General Notification - Notifications (Reporting)    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 QMNUM QMNUM QMNUM CHAR 12   0   Message Number *
3 QMART QMART QMART CHAR 2   0   Message Type TQ80
4 QMTXT QMTXT TEXT40 CHAR 40   0   Short Text  
5 ARTPR ARTPR ARTPR CHAR 2   0   Priority Type T356A
6 PRIOK PRIOK PRIOK CHAR 1   0   Priority T356
7 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
8 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
9 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
10 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
11 MZEIT MZEIT UHRZT TIMS 6   0   Notification Time  
12 QMDAT QMDAT DATUM DATS 8   0   Date of Notification  
13 QMNAM QMNAM USNAM CHAR 12   0   Name of declarant  
14 STRMN STRMN DATUM DATS 8   0   Desired Start Date  
15 STRUR STRUR UZEIT TIMS 6   0   Desired Start Time  
16 LTRMN LTRMN DATUM DATS 8   0   Required Finish Date  
17 LTRUR LTRUR UZEIT TIMS 6   0   Required End Date-Time  
18 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
19 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
20 VERID VERID VERID CHAR 4   0   Production Version MKAL
21 RM_MATNR RM_MATNR MATNR CHAR 18   0   Material number of the production version MKAL
22 RM_WERKS RM_WERKS WERKS CHAR 4   0   Plant of production version MKAL
23 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
24 REVLV REVLV REVLV CHAR 2   0   Revision level  
25 KUNUM QKUNUM KUNNR CHAR 10   0   Account Number of Customer KNA1
26 FEKNZ FEKNZ CHAR1 CHAR 1   0   Error Records Exist  
27 MAKNZ MAKNZ CHAR1 CHAR 1   0   Task Records Exist  
28 OBJNR QMOBJNR J_OBJNR CHAR 22   0   Object Number for Status Management ONR00
29 QMDAB QMDAB DATUM DATS 8   0   Date for Completion of Notification  
30 QMZAB QMZAB UZEIT TIMS 6   0   Completion Time of Notification  
31 RBNR RBNR RBNR CHAR 9   0   Report layout T352B
32 RBNRI RBNRI RBNRI CHAR 1   0   Origin of Notifications Catalog Profile  
33 INDTX INDLTX CHAR1 CHAR 1   0   Object Long Text Available  
34 KZMLA KZMLA CHAR1 CHAR 1   0   Primary language indicator for text segment  
35 HERKZ HERKZ HERKZ CHAR 2   0   Origin Indicator for Notification  
36 BEZDT BEZDT DATUM DATS 8   0   Notification Reference Date  
37 BEZUR BEZUR_D UZEIT TIMS 6   0   Notification Reference Time  
38 LIFNUM LIFNUM LIFNR CHAR 10   0   Vendor Account Number LFA1
39 BUNAME BUNAME XUBNAME CHAR 12   0   Author of a Q/PM Notification *
40 VBELN KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
41 BSTNK BSTKD BSTKD CHAR 35   0   Customer purchase order number  
42 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
43 SPART SPART SPART CHAR 2   0   Division TSPA
44 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
45 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
46 ADRNR CADNR CADRNR CHAR 10   0   Addresses: Address Number *
47 AEZEIT AEZEIT UHRZT TIMS 6   0   Time of Change  
48 ERZEIT ERZEIT UHRZT TIMS 6   0   Time, at Which Record Was Added  
49 MAWERK QMAWERKS WERKS CHAR 4   0   Plant for Material T001W
50 QMKAT QMKAT QKATART CHAR 1   0   Catalog type - coding TQ15
51 QMGRP QMGRP QCODEGRP CHAR 8   0   Code group - coding QPGR
52 QMCOD QMCOD QCODE CHAR 4   0   Coding *
53 PRUEFLOS QPLOS QPLOS NUMC 12   0   Inspection Lot Number QALS
54 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCH1
55 LGORTCHARG QLGORTCHAR LGORT CHAR 4   0   Storage Location of Batch T001L
56 LICHN LICHN LICHN CHAR 15   0   Vendor Batch Number  
57 HERSTELLER QLIFNR LIFNR CHAR 10   0   Number of Manufacturer LFA1
58 EMATNR EMATN MATNR CHAR 18   0   Material number corresponding to manufacturer part number MARA
59 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
60 BKGRP BKGRP EKGRP CHAR 3   0   Purchasing Group T024
61 LGORTVORG QLGORTVORG LGORT CHAR 4   0   Storage Location for Inspection Lot Stock T001L
62 FERTAUFNR FERTAUFNR AUFNR CHAR 12   0   Order Number (Production Order) AUFK
63 FERTAUFPL FERTAUFPL AUFPL NUMC 10   0   Plan Number for Operations in Order (Production Order)  
64 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
65 EBELP QEBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
66 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
67 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
68 MBLPO QMBLPO MBLPO NUMC 4   0   Item in Material Document  
69 LS_KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
70 LS_KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
71 LS_VBELN VBELN_VL VBELN CHAR 10   0   Delivery VBUK
72 LS_POSNR QPOSNR_VL POSNR NUMC 6   0   Delivery Item VBUP
73 CROBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
74 ARBPL LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center CRID
75 ARBPLWERK QARBPWERKS WERKS CHAR 4   0   Plant for Work Center T001W
76 FEART QFEART QFEART CHAR 8   0   Report Type for Defects Recording TQ86
77 PNLKN QLFNKN KNTNR NUMC 8   0   Current Node Number from Order Counter APLZL  
78 MGEIG MGEIG MENGE QUAN 13   3   Defective Quantity (Internal)  
79 MGFRD MGFRD MENGE QUAN 13   3   Defective Quantity (External)  
80 MGEIN MGEIN MEINS UNIT 3   0   Unit of Measure T006
81 BZMNG QBZMNG MENGE QUAN 13   3   General Reference Quantity  
82 RKMNG RKMNG MENGE QUAN 13   3   Complaint Quantity  
83 RGMNG RGMNG MENGE QUAN 13   3   Return Delivery Quantity  
84 RKDAT RKDAT DATUM DATS 8   0   Date of Return Delivery  
85 COAUFNR COAUFNR AUFNR CHAR 12   0   Order Number (QM Order) AUFK
86 QWRNUM QWRNUM QMNUM CHAR 12   0   Reference Notification Number QMEL
87 REFNUM QMEXTNR CHAR020 CHAR 20   0   External Reference Number  
88 KDMAT MATNR_KU IDNEX CHAR 35   0   Customer Material Number  
89 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
90 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
91 KZLOESCH KZLOESCH CHAR1 CHAR 1   0   Delete Data Record  
92 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
93 KTXTGR QMGRPTEXT QKURZTEXT CHAR 40   0   Code Group Text for Coding  
94 KTXTCD QMCODETEXT QTEXT80 CHAR 80   0   Code Text for Coding  
95 STTXT QMSTTXT TEXT40 CHAR 40   0   System Status for Notification  
96 BARBZT BARBZT DEC9_2 DEC 11   2   Processing Time  
97 MARBEH MARBEH MEINS UNIT 3   0   Processing Time Unit T006
98 NAME_LIST I_NAME_LST NAME CHAR 35   0   Name for list displays  
99 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
100 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
101 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
102 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
103 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
104 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
105 STREET AD_STREET TEXT60 CHAR 60   0   Street  
106 ARBPL_I ARBPL ARBPL CHAR 8   0   Work center  
107 VORNR QVORNR VORNR CHAR 4   0   Operation Number  
108 VORKTEXT QKURZTEXT QKURZTEXT CHAR 40   0   Short Text  
109 FERTVORNR QVORNR VORNR CHAR 4   0   Operation Number  
110 FERTVORKTX QKURZTEXT QKURZTEXT CHAR 40   0   Short Text  
111 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
112 VKGRP VKGRP VKGRP CHAR 3   0   Sales group *
113 PRIOKX PRIOKX TEXT20 CHAR 20   0   Priority Text  
114 MATKTX MAKTX TEXT40 CHAR 40   0   Material description  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RQMQMEL3 ARBPL CRID OBJID REF C CN
2 RQMQMEL3 ARBPLWERK T001W WERKS    
3 RQMQMEL3 ARTPR T356A ARTPR    
4 RQMQMEL3 AUFNR AUFK AUFNR    
5 RQMQMEL3 BKGRP T024 EKGRP    
6 RQMQMEL3 CHARG MCH1 CHARG    
7 RQMQMEL3 COAUFNR AUFK AUFNR    
8 RQMQMEL3 COUNTRY T005 LAND1    
9 RQMQMEL3 EBELN EKKO EBELN REF C CN
10 RQMQMEL3 EBELP EKPO EBELP    
11 RQMQMEL3 EKORG T024E EKORG    
12 RQMQMEL3 EMATNR MARA MATNR C CN
13 RQMQMEL3 FEART TQ86 FEART    
14 RQMQMEL3 FERTAUFNR AUFK AUFNR    
15 RQMQMEL3 HERSTELLER LFA1 LIFNR    
16 RQMQMEL3 KUNUM KNA1 KUNNR    
17 RQMQMEL3 LGORTCHARG T001L LGORT    
18 RQMQMEL3 LGORTVORG T001L LGORT    
19 RQMQMEL3 LIFNUM LFA1 LIFNR    
20 RQMQMEL3 LS_KDAUF VBUK VBELN REF C CN
21 RQMQMEL3 LS_POSNR VBUP POSNR REF C CN
22 RQMQMEL3 LS_VBELN VBUK VBELN REF C CN
23 RQMQMEL3 MANDT T000 MANDT    
24 RQMQMEL3 MARBEH T006 MSEHI    
25 RQMQMEL3 MATNR MARA MATNR    
26 RQMQMEL3 MAWERK T001W WERKS    
27 RQMQMEL3 MGEIN T006 MSEHI    
28 RQMQMEL3 OBJNR ONR00 OBJNR    
29 RQMQMEL3 PRIOK T356 PRIOK    
30 RQMQMEL3 PRUEFLOS QALS PRUEFLOS    
31 RQMQMEL3 QMART TQ80 QMART    
32 RQMQMEL3 QMGRP QPGR CODEGRUPPE REF C CN
33 RQMQMEL3 QMKAT TQ15 KATALOGART    
34 RQMQMEL3 QWRNUM QMEL QMNUM    
35 RQMQMEL3 RBNR T352B RBNR    
36 RQMQMEL3 REGION T005S BLAND    
37 RQMQMEL3 RM_MATNR MKAL MATNR    
38 RQMQMEL3 RM_WERKS MKAL WERKS    
39 RQMQMEL3 SPART TSPA SPART    
40 RQMQMEL3 VBELN VBUK VBELN    
41 RQMQMEL3 VERID MKAL VERID KEY C CN
42 RQMQMEL3 VKORG TVKO VKORG    
43 RQMQMEL3 VTWEG TVTW VTWEG    
44 RQMQMEL3 WAERS TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in