SAP ABAP Table S097 (QM notifications: material analysis)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S097   Table Relationship Diagram
Short Description QM notifications: material analysis    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
9 QMART QMART QMART CHAR 2   0   Message Type TQ80
10 MAWERK QMAWERKS WERKS CHAR 4   0   Plant for Material T001W
11 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
12 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
13 BASME MEINS MEINS UNIT 3   0   Base Unit of Measure *
14 ZHLMELD QZHLMELD INT4 INT4 10   0   No. of Notifications  
15 ZHLMOFN QZHLMOFN INT4 INT4 10   0   No. of Notifications with Status Outstanding  
16 ZHLMIAR QZHLMIAR INT4 INT4 10   0   No. of Notifications with Status Being Processed  
17 ZHLMMAB QZHLMMAB INT4 INT4 10   0   No. of Notifications with Status Completed  
18 ZHLMRST QZHLMRST INT4 INT4 10   0   No. of Notifications with Stauts Reset  
19 ZHLMAOF QZHLMAOF INT4 INT4 10   0   Number of Tasks with Status 'Outstanding' or 'Released'  
20 ZHLMASS QZHLMASS INT4 INT4 10   0   No. of Tasks  
21 ZHLMAER QZHLMAER INT4 INT4 10   0   No. of Tasks with Status Completed  
22 ZHLMERF QZHLMERF INT4 INT4 10   0   No. of Tasks with Status Successful  
23 SMMGEIG QSMMGEIG QKUMMENGE QUAN 17   3   Total Defective Quantity (Internal)  
24 SMMGFRD QSMMGFRD QKUMMENGE QUAN 17   3   Total Defective Quantity (External)  
25 SMRKMNG QSMRKMNG QKUMMENGE QUAN 17   3   Total Complaint Quantity  
26 SMRGMNG QSMRGMNG QKUMMENGE QUAN 17   3   Total Quantity Returned  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S097 MANDT T000 MANDT    
2 S097 MATNR MARA MATNR    
3 S097 MAWERK T001W WERKS    
4 S097 QMART TQ80 QMART    
History
Last changed by/on SAP  20050411 
SAP Release Created in