SAP ABAP View M_QMELESM (Generated View for Matchcode ID QMEL -E)
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
View Type D Database View 
Database View M_QMELESM  
Short Description Generated View for Matchcode ID QMEL -E    
Root table QMEL   Quality Notification 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 QMEL QMEL
2 QMIH  
3 ILOA  
4 QMSM  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 QMEL MANDT JL EQ 0 1 KZLOESCH
2 QMIH MANDT JR EQ AND 0 1 KZLOESCH
3 QMEL QMNUM JL EQ 0 1 KZLOESCH
4 QMIH QMNUM JR EQ AND 0 1 KZLOESCH
5 ILOA MANDT JL EQ 0 1 KZLOESCH
6 QMIH MANDT JR EQ AND 0 1 KZLOESCH
7 ILOA ILOAN JL EQ 0 1 KZLOESCH
8 QMIH ILOAN JR EQ AND 0 1 KZLOESCH
9 QMSM MANDT JL EQ 0 1 KZLOESCH
10 QMIH MANDT JR EQ AND 0 1 KZLOESCH
11 QMSM QMNUM JL EQ 0 1 KZLOESCH
12 QMIH QMNUM JR EQ AND 0 1 KZLOESCH
13 QMEL LIFNUM NE ' ' AND 0 10 LIFNUM
14 QMEL KZLOESCH EQ ' ' 0 1 KZLOESCH
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT QMEL MANDT   MANDT Client
2 LIFNUM QMEL LIFNUM   LIFNUM Vendor Account Number
3 QMART QMEL QMART   QMART Message Type
4 QMNUM QMEL QMNUM   QMNUM Message Number
5 QMTXT QMEL QMTXT   QMTXT Short Text
6 QMDAB QMEL QMDAB   QMDAB Date for Completion of Notification
7 ERNAM QMEL ERNAM   ERNAM Name of Person who Created the Object
8 MANUM QMSM MANUM   MANUM Sequential Task Number
9 FENUM QMSM FENUM   FELFD Item Number in Item Record
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in