QM - Inspection Trend Analysis - Tables

[Former Member]

Dear All,

I would like to create below query report. Pls guide about table names...

Product Name	Material Code	Inspection	Batch	Manufacturer	Vendor bat	Batch Size	UNIT	Mfg.Date	Exp.Date	Residue on	water	Residual	Assay
										0.0 .. 0.2 %	<=  0.5 %	0 .. 2 ppm	97.0 .. 102.0 %
Atorvastatin	25000005	40000000207	314	ABC	6543	1,000.00	KG	00/00/0000	25/12/2014	0.2	0.5	0	97
Atorvastatin	25000005	40000000211	334	XYZ	899	100	KG	00/00/0000	13/03/2014	0.2	0.5	0	97
Atorvastatin	25000005	40000000257	690	SDF	123456	10	KG	03/02/2013	30/11/2013	0.2	0.5	0	98

Thanks in advance..

Randhir Padwal

[thanga_prakash · Accepted solution]

Hello Randhir,

Below is the list of QM tables, You can go through the list and find the relevant tables for your report.

In case if you were unable to find it, please ask your functional consultant to pick the relevant tables.

<b>Important QM Tables</b> 

Area Table Description 

Master Data QMAT Inspection type - material parameters 

Master Data QMHU QM Link Between Inspection Lot and Handling Unit Item 

Master Data QMTB Inspection method master record 

Master Data QMTT Inspection Method Texts 

Master Data QPAC Inspection catalog codes for selected sets 

Master Data QPAM Inspection catalog selected sets 

Master Data QPMK Inspection characteristic master 

Master Data QPMT Master Inspection Characteristics Texts 

Master Data QPMZ Assignment table - insp. methods/master insp. characteristic 

Master Data TQ01D Authorization groups for QM master data 

Master Data TQ01E Text authorization groups for QM master data 

Master Data TQ21 Assignment of screens to screen groups 

Master Data TQ25 QM:screen sequence for master and inspection characteristics 

QM Master Data 

Catalog QPCD Inspection catalog codes 

Catalog QPCT Code texts 

Catalog QPGR Inspection catalog code groups 

Catalog QPGT Code group texts 

Catalog TQ07 Follow-Up Action for Usage Decision of Inspection Lot 

Catalog TQ07A QM: Function Modules for Follow-Up Action 

Catalog TQ07T Language-dependent texts for Table TQ07 

Catalog TQ15 Inspection catalog type index 

Catalog TQ15T Language-dependent texts for table TQ15 

Catalog TQ17 Defect classes 

Catalog TQ17T Language-dependent texts for table TQ17 

Catalog 

Sample Determination QDEB Allwd. Relationships: Sampling Procedures/Dynamic Mod. Rules 

Sample Determination QDEBT Allowed combinations of procedures/dynamic mod. rules: texts 

Sample Determination QDPA Sampling scheme-instructions 

Sample Determination QDPK Sampling scheme header 

Sample Determination QDPKT Sampling scheme: texts 

Sample Determination QDPP Sampling scheme item 

Sample Determination QDQL Quality level 

Sample Determination 

Inspection Char TQ17A Weighting of Char 

Inspection Char TQ11 Inspection Qualification 

Inspection Char TQ29 Tolerance Keys 

Inspection Char T006 Unit of measurement 

Inspection Char 

Dynamic Modification QDBM Valuation mode 

Dynamic Modification QDBMT Valuation Mode: Texts 

Dynamic Modification QDDR Dynamic modification rule (header) 

Dynamic Modification QDDRT Dynamic modification rule: texts 

Dynamic Modification QDEP Allowed inspection severities 

Dynamic Modification QDEPT Allowed Inspection Severities: Texts 

Dynamic Modification QDFB Function modules for the individual procedure categories 

Dynamic Modification QDFBT Function Modules for Procedure: Texts 

Dynamic Modification QDFM Function modules for valuation mode 

Dynamic Modification QDFMT Function Modules for Valuation Mode: Texts 

Dynamic Modification QDPS Inspection stages for a dynamic modification rule

Dynamic Modification QDPST Inspection Stages: Texts 

Dynamic Modification QDSA Sampling type 

Dynamic Modification QDSAT Sampling Type: Texts 

Dynamic Modification QDSV Sampling procedure 

Dynamic Modification QDSVT Sampling Procedure: Texts 

Dynamic Modification TQ39B QM : Activates reference for dyn. modification level 

Dynamic Modification 

Graphics & SPC QASH Quality control chart 

Graphics & SPC QAST Control chart track 

Graphics & SPC QPSH Control chart types 

Graphics & SPC QPSHT Texts for control chart types 

Graphics & SPC QPSP SPC criterion 

Graphics & SPC QPSPT Texts for SPC criteria 

Graphics & SPC QPST Control chart track 

Graphics & SPC QPSTT Texts for control chart tracks 

Graphics & SPC 

Specifications QMSP QM: material specification 

Specifications 

Inspection Plan PLKO Inspection plan Header 

Inspection Plan MAPL Material Assignement 

Inspection Plan PLPO Operation Details 

Inspection Plan PLMK Inspection plan characteristics 

Inspection Plan PLMW MAPL-Dependent Charac. Specifications (Inspection Plan) 

Inspection Plan TQ03 QSS: Control for Screen Texts/TABLE NOT USED (Rel. 4.6) 

Inspection Plan TQ29A Dependency tolerance key - nominal measurement 

Inspection Plan TQ72 Type of share calculation 

Inspection Plan TQ72T Texts for type of share calculation 

Inspection Plan TQ75 QM formula parameters 

Inspection Plan TQ75F Field names for QM formulas 

Inspection Plan TQ75K Short text for Table TQ75F 

Inspection Plan TQ75T Description of formula parameters 

Inspection Plan 

Qm in procurement QINF QM-info record for material and vendor 

Qm in procurement TQ02 QM system definition 

Qm in procurement TQ02A QM system assignment and QM system requirements 

Qm in procurement TQ02B QM system 

Qm in procurement TQ02T QM system description 

Qm in procurement TQ02U Description QM system 

Qm in procurement TQ04A Functions that can be blocked 

Qm in procurement TQ04S QM block functions : texts 

Qm in procurement TQ05 QM certificate categories for procurement 

Qm in procurement TQ05T QM: text table for certificate types 

Qm in procurement TQ08 Control of QM in procurement 

Qm in procurement TQ08T QM: text for QM procurement keys 

Qm in procurement TQ09 QM: agreement of QM document types 

Qm in procurement TQ09T QM: agreement of QM document types 

Qm in procurement TQ32A Inspection type to status assignment from status profile 

Qm in procurement 

QM in SD QVDM QM Info Record - QM Control in SD 

QM in SD TQ32B Find insp.type for quality insp. for delivery note 

QM in SD 

Inspectio lot QALS Inspection lot record 

Inspectio lot QALT Partial lot 

Inspectio lot T156Q Movement Type: Material-Independent Control 

Inspectio lot TQ30 Inspection types 

Inspectio lot TQ30T Texts for inspection types 

Inspectio lot TQ32 Assignment of inspection type to origin 

Inspectio lot TQ32C Lot creation allowed values for the origin 

Inspectio lot TQ32C _T Texts for lot creation indicator 

Inspectio lot TQ33 Relevant fields for origin 

Inspectio lot TQ34 Default values for inspection type 

Inspectio lot 

Inspection point QAPP Inspection point 

Inspection point TQ79 Table with inspection point/user field combinations 

Inspection point TQ79T Key words for inspeciton point user fields 

Inspection point 

Results Recording QAES Sample unit table 

Results Recording QAKL Results table for value classes 

Results Recording QAMR Characteristic results during inspection processing 

Results Recording QAMV Characteristic specifications for inspection processing 

Results Recording QASE Results table for the sample unit 

Results Recording QASR Sample results for inspection characteristics 

Results Recording QASV Sample specifications for inspection processing 

Results Recording TQ12 Ind. external numbering for test units in results recording 

Results Recording TQ12T Texts for the ind. for ext. numbering of units to be insp. 

Results Recording TQ70 Control table for results recording 

Results Recording TQ70C Function codes for navigation from the char.overview screen 

Results Recording TQ70E Screen-based processing tables 

Results Recording TQ70F Navigation during results recording 

Results Recording TQ70S Characteristic overview screen for results recording 

Results Recording TQ73 Origin of results data 

Results Recording TQ73T Texts for origin of results data 

Results Recording TQ74 Recording configuration 

Results Recording TQ74T Recording configuration 

Results Recording TQ76 Processing status of inspection characteristics 

Results Recording TQ76T Texts for the processing status of insp. characteristics 

Results Recording TQ77 Attributes for the Inspection Characteristic 

Results Recording TQ77T Text Tables for Attributes 

Results Recording TQ78 Status-dependent processing table for insp. characteristics 

Results Recording TQ78T Texts for the status-specific proc. table for insp. char. 

Results Recording 

Defects recording TQ84 Confirmation profile 

Defects recording TQ84T Text table for confirmation profile 

Defects recording TQ86 Report category for defects recording 

Defects recording TQ86A Assignment report category for work center 

Defects recording TQ86T Text table for report category 

Defects recording V_T35 2B_F Generated table for view V_T352B_F 

Defects recording 

Usage decision QAMB QM: Link Between Inspection Lot and Material Document 

Usage decision QAVE Inspection processing: Usage decision 

Usage decision TQ06 Procedure for Calculating the Quality Score 

Usage decision TQ06T Language-specific texts for Table TQ06 

Usage decision TQ07M QM: Inventory postings with usage decision 

Usage decision 

Sample Mgmt QPRN Sample drawing of phys. samples 

Sample Mgmt QPRS Master record for phys. samples 

Sample Mgmt QPRVK Sample-drawing procedure 

Sample Mgmt QPRVK T Header for sample drawing procedure texts 

Sample Mgmt QPRVP Sample-drawing items 

Sample Mgmt QPRVP T Items for sample drawing procedure texts 

Sample Mgmt TQ40 Definition of sample types 

Sample Mgmt TQ40T Text table for sample type 

Sample Mgmt TQ41 Storage locations for physical samples 

Sample Mgmt TQ41T Texts for storage locations 

Sample Mgmt TQ42 Physical sample containers 

Sample Mgmt TQ42T Texts for phys. sample containers 

Sample Mgmt 

QMIS S068 Vendor statistics 

QMIS S069 Material statistics 

QMIS S097 QM notifications: Matl anal. 

QMIS S098 QM notification: Vendor anal. 

QMIS S099 QM notifications: Cust. anal. 

QMIS S100 Problems: Material analysis 

QMIS S102 Problems: Vendor analysis 

QMIS S103 Problems: Customer analysis 

QMIS S104 Customer statistics 

QMIS S161 Inspection results: General 

QMIS S162 Quantitative insp. results 

QMIS S163 Quant. Insp. Result: Vendor 

QMIS S164 Quant. Insp. Result: Vendor 

QMIS S165 Inspection result: gen. custs 

QMIS S166 Insp. Results: Quant. Customer 

QMIS TQ55 Assign inspection lot origin for update group 

QMIS TQ56 Definition of quality score classes 

QMIS TQ56T Text table for the definition of quality score classes 

QMIS TQ57 Assignment of quality score key to info structure 

QMIS 

Quality Certificates QCPR QM quality certificates in procurement 

Quality Certificates I000 Conditions for certificate profile 

Quality Certificates KONDI Conditions: Data part for certificates 

Quality Certificates QCVK Certificate profile header 

Quality Certificates QCVM Certificate profile characteristic level 

Quality Certificates QCVMT Certificate profile characteristic level: texts 

Quality Certificates QCVV Certificate Profile: List of Preliminary Products 

Quality Certificates TQ61 Result value origin for certificates 

Quality Certificates TQ61T Origin of result values for certificates: texts 

Quality Certificates TQ62 Output strategy for skip characteristics 

Quality Certificates TQ62T Output strategy for skip characteristics: texts 

Quality Certificates TQ63 Origin of insp. specs for certificates (function modules) 

Quality Certificates TQ63T Origin of inspection specifications for certificates: texts 

Quality Certificates TQ64 Origin of characteristic short text for certificates 

Quality Certificates TQ64T Origin of characteristic short text for certificates: texts 

Quality Certificates TQ65 Certificates: Combinations allowed for origins, specs/values 

Quality Certificates TQ67 Certificate-Relevant Output Types 

Quality Certificates 

Quality Notification QMEL Notification header 

Quality Notification QMFE Item 

Quality Notification QMSM Task 

Quality Notification QMMA Activities 

Quality Notification T352C Catalog types for each catalog profile 

Quality Notification TQ81 Notification Scenario 

Quality Notification TQ81V Usage of parts 

Quality Notification TQ81V_T Texts for usage of parts 

Quality Notification TQ81_T Texts for Notification Scenarios 

Quality Notification TQ82 Change of Notification Type 

Quality Notification TQ83 Partner Functions for Codes 

Quality Notification TQ85 Function table for follow-up functions 

Quality Notification TQ85R Rules for Follow-Up Functions 

Quality Notification TQ85_T Action box text table 

Quality Notification TQ8CO Assignment of reference orders to notification type 

Quality Notification 

Other Objects MARA Material Number 

Other Objects T001W Plant 

Other Objects LFA1 Vendor 

Other Objects KNA1 Customer 

Other Objects AUFK Order Number 

Other Objects SAFK Run Schedule Header Number 

Other Objects MCH1 Batch Number 

Other Objects MCHA Batch Record 

Other Objects EKKO Purchasing Document Header 

Other Objects EKPO Purchasing document Item 

Other Objects EKET Delivery Schedule 

Other Objects VBUK Delivery Header 

Other Objects VBUP Delivery Item 

Other Objects CSKS Cost Center 

Other Objects EQUI Equipment Number

Regards,

Thanga