SAP ABAP Table VQQMELST (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure VQQMELST   Table Relationship Diagram
Short Description Generated Table for View    
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 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
3 STAT J_STATUS J_STATUS CHAR 5   0   Object status  
4 QMNUM QMNUM QMNUM CHAR 12   0   Message Number  
5 QMART QMART QMART CHAR 2   0   Message Type TQ80
6 QMTXT QMTXT TEXT40 CHAR 40   0   Short Text  
7 ARTPR ARTPR ARTPR CHAR 2   0   Priority Type T356A
8 PRIOK PRIOK PRIOK CHAR 1   0   Priority T356
9 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
10 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
11 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
12 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
13 MZEIT MZEIT UHRZT TIMS 6   0   Notification Time  
14 QMDAT QMDAT DATUM DATS 8   0   Date of Notification  
15 QMNAM QMNAM USNAM CHAR 12   0   Name of declarant  
16 STRMN STRMN DATUM DATS 8   0   Desired Start Date  
17 STRUR STRUR UZEIT TIMS 6   0   Desired Start Time  
18 LTRMN LTRMN DATUM DATS 8   0   Required Finish Date  
19 LTRUR LTRUR UZEIT TIMS 6   0   Required End Date-Time  
20 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
21 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
22 VERID VERID VERID CHAR 4   0   Production Version MKAL
23 RM_MATNR RM_MATNR MATNR CHAR 18   0   Material number of the production version MKAL
24 RM_WERKS RM_WERKS WERKS CHAR 4   0   Plant of production version MKAL
25 SA_AUFNR SA_AUFNR SA_AUFNR CHAR 12   0   Run schedule header number SAFK
26 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
27 REVLV REVLV REVLV CHAR 2   0   Revision level  
28 MATKL MATKL MATKL CHAR 9   0   Material Group T023
29 PRDHA PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
30 KZKRI KZKRI XFELD CHAR 1   0   Indicator: Critical part  
31 KZDKZ KZDKZ XFELD CHAR 1   0   Documentation required indicator  
32 KUNUM QKUNUM KUNNR CHAR 10   0   Account Number of Customer KNA1
33 FEKNZ FEKNZ CHAR1 CHAR 1   0   Error Records Exist  
34 MAKNZ MAKNZ CHAR1 CHAR 1   0   Task Records Exist  
35 QMDAB QMDAB DATUM DATS 8   0   Date for Completion of Notification  
36 QMZAB QMZAB UZEIT TIMS 6   0   Completion Time of Notification  
37 RBNR RBNR RBNR CHAR 9   0   Report layout T352B
38 RBNRI RBNRI RBNRI CHAR 1   0   Origin of Notifications Catalog Profile  
39 INDTX INDLTX CHAR1 CHAR 1   0   Object Long Text Available  
40 KZMLA KZMLA CHAR1 CHAR 1   0   Primary language indicator for text segment  
41 HERKZ HERKZ HERKZ CHAR 2   0   Origin Indicator for Notification  
42 BEZDT BEZDT DATUM DATS 8   0   Notification Reference Date  
43 BEZUR BEZUR_D UZEIT TIMS 6   0   Notification Reference Time  
44 LIFNUM LIFNUM LIFNR CHAR 10   0   Vendor Account Number LFA1
45 BUNAME BUNAME XUBNAME CHAR 12   0   Author of a Q/PM Notification  
46 VBELN KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
47 BSTNK BSTKD BSTKD CHAR 35   0   Customer purchase order number  
48 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
49 SPART SPART SPART CHAR 2   0   Division TSPA
50 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
51 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
52 ADRNR CADNR CADRNR CHAR 10   0   Addresses: Address Number  
53 AEZEIT AEZEIT UHRZT TIMS 6   0   Time of Change  
54 ERZEIT ERZEIT UHRZT TIMS 6   0   Time, at Which Record Was Added  
55 MAWERK QMAWERKS WERKS CHAR 4   0   Plant for Material T001W
56 QMKAT QMKAT QKATART CHAR 1   0   Catalog type - coding TQ15
57 QMGRP QMGRP QCODEGRP CHAR 8   0   Code group - coding QPGR
58 QMCOD QMCOD QCODE CHAR 4   0   Coding  
59 AUSWIRK QSCENARIO QSCENARIO CHAR 4   0   Key for a Scenario TQ81
60 TEILEV QTEILEV QTEILEV CHAR 4   0   Usage of Parts TQ81V
61 PRUEFLOS QPLOS QPLOS NUMC 12   0   Inspection Lot Number QALS
62 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCH1
63 LGORTCHARG QLGORTCHAR LGORT CHAR 4   0   Storage Location of Batch T001L
64 LICHN LICHN LICHN CHAR 15   0   Vendor Batch Number  
65 HERSTELLER QLIFNR LIFNR CHAR 10   0   Number of Manufacturer LFA1
66 EMATNR EMATN MATNR CHAR 18   0   Material number corresponding to manufacturer part number MARA
67 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
68 BKGRP BKGRP EKGRP CHAR 3   0   Purchasing Group T024
69 LGORTVORG QLGORTVORG LGORT CHAR 4   0   Storage Location for Inspection Lot Stock T001L
70 FERTAUFNR FERTAUFNR AUFNR CHAR 12   0   Order Number (Production Order) AUFK
71 FERTAUFPL FERTAUFPL AUFPL NUMC 10   0   Plan Number for Operations in Order (Production Order)  
72 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
73 EBELP QEBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
74 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
75 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
76 MBLPO QMBLPO MBLPO NUMC 4   0   Item in Material Document  
77 LS_KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number VBUK
78 LS_KDPOS POSNR POSNR NUMC 6   0   Item number of the SD document VBUP
79 LS_VBELN VBELN_VL VBELN CHAR 10   0   Delivery VBUK
80 LS_POSNR QPOSNR_VL POSNR NUMC 6   0   Delivery Item VBUP
81 CROBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
82 ARBPL LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center CRID
83 ARBPLWERK QARBPWERKS WERKS CHAR 4   0   Plant for Work Center T001W
84 FEART QFEART QFEART CHAR 8   0   Report Type for Defects Recording TQ86
85 PNLKN QLFNKN KNTNR NUMC 8   0   Current Node Number from Order Counter APLZL  
86 MGEIG MGEIG MENGE QUAN 13   3   Defective Quantity (Internal)  
87 MGFRD MGFRD MENGE QUAN 13   3   Defective Quantity (External)  
88 MGEIN MGEIN MEINS UNIT 3   0   Unit of Measure T006
89 BZMNG QBZMNG MENGE QUAN 13   3   General Reference Quantity  
90 RKMNG RKMNG MENGE QUAN 13   3   Complaint Quantity  
91 RGMNG RGMNG MENGE QUAN 13   3   Return Delivery Quantity  
92 RKDAT RKDAT DATUM DATS 8   0   Date of Return Delivery  
93 COAUFNR COAUFNR AUFNR CHAR 12   0   Order Number (QM Order) AUFK
94 QWRNUM QWRNUM QMNUM CHAR 12   0   Reference Notification Number QMEL
95 REFNUM QMEXTNR CHAR020 CHAR 20   0   External Reference Number  
96 KDMAT MATNR_KU IDNEX CHAR 35   0   Customer Material Number  
97 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
98 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
99 KZLOESCH KZLOESCH CHAR1 CHAR 1   0   Delete Data Record  
100 PRODDAT QPRODDAT DATUM DATS 8   0   Production Date  
101 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
102 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
103 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
104 AUTKZ QAUTKZ QKZ CHAR 1   0   Data Record Created with Function 'Create with Copy Model'  
105 BEDID BEDID BEDID NUMC 12   0   ID of the capacity requirements record  
106 BEDZL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
107 PROFIL_TYP OTYPE OTYPE CHAR 2   0   Object Type  
108 PROFIL_ID OBJEKTID NUM08 NUMC 8   0   Object ID  
109 HANDLE TSEGGUID SYSUUID_22 CHAR 22   0   Globally unique identifier (linked to time segment, etc)  
110 TSEGFL TSEGEXISTS FLAG CHAR 1   0   Time segment exists  
111 TSEGTP TSEGTEMPLA TSEGTEMPLA CHAR 10   0   Template TTSEGTPLH
112 TZONSO TZONSO TZNZONE CHAR 6   0   Time zone for notification TTZZ
113 TZONID TZONSMID TZONSMID CHAR 1   0   Origin of Time Zone in Notification  
114 FUNKTION QNFUNKTION CHAR4 CHAR 4   0   Keys for Function in Action Box  
115 /SAPSMOSS/INSTN /SAPSMOSS/R3INSTN /SAPSMOSS/R3INSTN CHAR 10   0   Installation number /SAPSMOSS/INSTN
116 /SAPSMOSS/MNUMM /SAPSMOSS/MNUMM /SAPSMOSS/MNUMM NUMC 24   0   SAPNet notification number  
117 /SAPSMOSS/OSSYS /SAPSMOSS/OSSYS /SAPSMOSS/OSSYS CHAR 10   0   Operating system and version /SAPSMOSS/OSYS
118 /SAPSMOSS/DBSYS /SAPSMOSS/DBSYS /SAPSMOSS/DBSYS CHAR 10   0   Database system /SAPSMOSS/DBSY
119 /SAPSMOSS/REL /SAPSMOSS/R3REL /SAPSMOSS/R3REL CHAR 10   0   R/3 Release /SAPSMOSS/REL
120 /SAPSMOSS/COMP /SAPSMOSS/R3COMP /SAPSMOSS/R3COMP CHAR 20   0   Area  
121 /SAPSMOSS/FRONT /SAPSMOSS/FRONTEND /SAPSMOSS/FRONTEND CHAR 10   0   Frontend /SAPSMOSS/FRNT
122 /SAPSMOSS/SYSTYP /SAPSMOSS/R3SYSTYPE /SAPSMOSS/R3SYSTYPE CHAR 1   0   R/3 System type /SAPSMOSS/SYST
123 /SAPSMOSS/ADDID /SAPSMOSS/R3ADDID /SAPSMOSS/R3ADDID CHAR 10   0   Add-on ID /SAPSMOSS/ADDID
124 /SAPSMOSS/ADDREL /SAPSMOSS/R3ADDREL /SAPSMOSS/R3ADDREL CHAR 10   0   Add-On Release /SAPSMOSS/ADDRL
125 /SAPSMOSS/TSTMP /SAPSMOSS/NSTSTMP TZNTIMESTP NUMC 14   0   SAPNet time stamp  
126 /SAPSMOSS/STATUS /SAPSMOSS/STATUS /SAPSMOSS/STATUS CHAR 1   0   Status of R/3 notification in SAPNet /SAPSMOSS/STAT
127 /SAPSMOSS/ERDAT /SAPSMOSS/ERDAT DATUM DATS 8   0   Date on which notification was completed at SAP  
128 /SAPSMOSS/ERZEIT /SAPSMOSS/ERZEIT UHRZT TIMS 6   0   Time when notification was completed at SAP  
129 /SAPSMOSS/SYSID SYSYSID SYCHAR08 CHAR 8   0   Name of SAP System  
130 /SAPSMOSS/MANDT SYMANDT MANDT CLNT 3   0   Client ID  
131 PSP_NR PS_POSNR PS_POSNR NUMC 8   0   WBS Element  
132 ESTIMATED_COSTS PS_COSTS WERTV7 CURR 13   2   Estimated Costs for a Claim  
133 CLAIMED_COSTS COSTS_CLAIM WERTV7 CURR 13   2   Costs Claimed  
134 RESULT_COSTS COSTS_RESULT WERTV7 CURR 13   2   Costs Accepted  
135 CHANCE PS_CHANCE PS_CHANCE NUMC 2   0   Chance of Completing a Claim  
136 OPPONENT PS_OPPONENT OPPONENT CHAR 2   0   Partner Type  
137 KALNR CK_KALNR CK_KALNR NUMC 12   0   Cost Estimate Number for Cost Est. w/o Qty Structure  
138 KALVAR CK_KALVAR KLVAR CHAR 4   0   Costing Variant for Postprocessing with Unit Costing  
139 OBJNR_REAL J_OBJNR_REAL J_OBJNR CHAR 22   0   Object number of real CO account assignment ONR00
140 OBJNR_STAT OBJNR_N1 J_OBJNR CHAR 22   0   Auxiliary account assignment 1 ONR00
141 PHASE QM_PHASE QM_PHASE CHAR 1   0   Notification Processing Phase  
142 /ISDFPS/OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number  
143 LOGSYSTEM LOGSYSTEM LOGSYS CHAR 10   0   Logical System  
144 /ISDFPS/MEQUI /ISDFPS/MEQUI EQUNR CHAR 18   0   Master Equipment  
145 SHN_OBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
146 SHN_OBJID CR_OBJID CR_OBJID NUMC 8   0   Object ID of the resource  
147 SHN_FUNCT_LOC TPLNR TPLNR CHAR 30   0   Functional Location  
148 SHN_EQUIPMENT EQUNR EQUNR CHAR 18   0   Equipment Number  
149 SHN_ORIGIN COCF_SRN_ORIGIN COCF_SRN_ORIGIN NUMC 2   0   Origin or Use of Shift Note or Report  
150 UII UII_CHAR72 UII_CHAR72 CHAR 72   0   Unique Item Identifier  
151 AUSVN AUSVN DATUM DATS 8   0   Start of Malfunction (Date)  
152 AUSBS AUSBS DATUM DATS 8   0   End of Malfunction (Date)  
153 AUZTV AUZTV UHRZT TIMS 6   0   Start of Malfunction (Time)  
154 AUZTB AUZTB UHRZT TIMS 6   0   End of Malfunction (Time)  
155 MSAUS MSAUS XFELD CHAR 1   0   Breakdown Indicator  
156 BTPLN BTPLN TPLNR CHAR 30   0   Functional Location Affected IFLOT
157 BEQUI BEQUI EQUNR CHAR 18   0   Equipment Affected EQUI
158 AUSWK AUSWK AUSWK CHAR 1   0   Effect on Operation T357A
159 VERFV VERFV NUM3 NUMC 3   0   Availability Before Malfunction  
160 VERFN VERFN NUM3 NUMC 3   0   Availability After Malfunction  
161 VERFM VERFM NUM3 NUMC 3   0   Availability After Completion of Task  
162 ANLZV ANLZV ANLAZ CHAR 1   0   System Condition Before Malfunction T357Z
163 ANLZN ANLZN ANLAZ CHAR 1   0   System Condition After Malfunction T357Z
164 ANLZE ANLZE ANLAZ CHAR 1   0   System Condition After Completion of Task T357Z
165 INACT J_INACT J_INACT CHAR 1   0   Indicator: Status Is Inactive  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VQQMELST /SAPSMOSS/ADDID /SAPSMOSS/ADDID R3ADDID    
2 VQQMELST /SAPSMOSS/ADDREL /SAPSMOSS/ADDRL R3ADDREL    
3 VQQMELST /SAPSMOSS/DBSYS /SAPSMOSS/DBSY DBSYS REF 1 CN
4 VQQMELST /SAPSMOSS/FRONT /SAPSMOSS/FRNT FRONTEND REF    
5 VQQMELST /SAPSMOSS/INSTN /SAPSMOSS/INSTN R3INSTN REF 1 CN
6 VQQMELST /SAPSMOSS/OSSYS /SAPSMOSS/OSYS OSSYS REF 1 CN
7 VQQMELST /SAPSMOSS/REL /SAPSMOSS/REL R3REL REF 1 CN
8 VQQMELST /SAPSMOSS/STATUS /SAPSMOSS/STAT STATUS    
9 VQQMELST /SAPSMOSS/SYSTYP /SAPSMOSS/SYST R3SYSTYPE REF 1 CN
10 VQQMELST ANLZE T357Z ANLAZ REF C CN
11 VQQMELST ANLZN T357Z ANLAZ REF C CN
12 VQQMELST ANLZV T357Z ANLAZ REF C CN
13 VQQMELST ARBPL CRID OBJID REF C CN
14 VQQMELST ARBPLWERK T001W WERKS    
15 VQQMELST ARTPR T356A ARTPR REF C CN
16 VQQMELST AUFNR AUFK AUFNR REF C CN
17 VQQMELST AUSWIRK TQ81 AUSWIRK KEY    
18 VQQMELST AUSWK T357A AUSWK REF C CN
19 VQQMELST BEQUI EQUI EQUNR REF C CN
20 VQQMELST BKGRP T024 EKGRP    
21 VQQMELST BTPLN IFLOT TPLNR REF C CN
22 VQQMELST CHARG MCH1 CHARG    
23 VQQMELST COAUFNR AUFK AUFNR    
24 VQQMELST EBELN EKKO EBELN REF C CN
25 VQQMELST EBELP EKPO EBELP    
26 VQQMELST EKORG T024E EKORG    
27 VQQMELST EMATNR MARA MATNR C CN
28 VQQMELST FEART TQ86 FEART REF C CN
29 VQQMELST FERTAUFNR AUFK AUFNR    
30 VQQMELST HERSTELLER LFA1 LIFNR    
31 VQQMELST KUNUM KNA1 KUNNR REF C CN
32 VQQMELST LGORTCHARG T001L LGORT    
33 VQQMELST LGORTVORG T001L LGORT    
34 VQQMELST LIFNUM LFA1 LIFNR    
35 VQQMELST LS_KDAUF VBUK VBELN REF C CN
36 VQQMELST LS_KDPOS VBUP POSNR    
37 VQQMELST LS_POSNR VBUP POSNR REF C CN
38 VQQMELST LS_VBELN VBUK VBELN REF C CN
39 VQQMELST MANDT T000 MANDT KEY 1 CN
40 VQQMELST MATKL T023 MATKL    
41 VQQMELST MATNR MARA MATNR REF C CN
42 VQQMELST MAWERK T001W WERKS    
43 VQQMELST MGEIN T006 MSEHI    
44 VQQMELST OBJNR ONR00 OBJNR KEY 1 CN
45 VQQMELST OBJNR_REAL ONR00 OBJNR REF C CN
46 VQQMELST OBJNR_STAT ONR00 OBJNR REF C CN
47 VQQMELST PRDHA T179 PRODH    
48 VQQMELST PRIOK T356 PRIOK REF C CN
49 VQQMELST PRUEFLOS QALS PRUEFLOS    
50 VQQMELST QMART TQ80 QMART REF C CN
51 VQQMELST QMGRP QPGR CODEGRUPPE REF C CN
52 VQQMELST QMKAT TQ15 KATALOGART    
53 VQQMELST QWRNUM QMEL QMNUM    
54 VQQMELST RBNR T352B RBNR REF C CN
55 VQQMELST RM_MATNR MKAL MATNR    
56 VQQMELST RM_WERKS MKAL WERKS    
57 VQQMELST SA_AUFNR SAFK AUFNR KEY C CN
58 VQQMELST SPART TSPA SPART    
59 VQQMELST TEILEV TQ81V TEILEV    
60 VQQMELST TSEGTP TTSEGTPLH TEPL REF 1 CN
61 VQQMELST TZONSO TTZZ TZONE REF 1 CN
62 VQQMELST VBELN VBUK VBELN    
63 VQQMELST VERID MKAL VERID    
64 VQQMELST VKBUR TVKBZ VKBUR REF C CN
65 VQQMELST VKGRP TVBVK VKGRP REF C CN
66 VQQMELST VKORG TVKO VKORG    
67 VQQMELST VTWEG TVTW VTWEG    
68 VQQMELST WAERS TCURC WAERS REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in