Important SAP QM Tables (Quality Management)

Important SAP QM Tables by Functionality (Quality Management ): PM Object Location and Account Assignment table – ILOA, Plant Maintenance: Partners table – IHPA … Functional Location. SAP tables list are classified by Business Topics. The list is completed with Other Objects which are none SAP QM exclusive but are used in SAP QM.

Important SAP QM Tables for QM Master Data

SAP QM Tables for Quality Management Master data are:

Table Description
QMATInspection type – material parameters
QMHUQM Link Between Inspection Lot and Handling Unit Item
QMTBInspection method master record
QMTTInspection Method Texts
QPACInspection catalog codes for selected sets
QPAMInspection catalog selected sets
QPMKInspection characteristic master
QPMTMaster Inspection Characteristics Texts
QPMZAssignment table – insp. methods/master insp. characteristic
TQ01DAuthorization groups for QM master data
TQ01EText authorization groups for QM master data
TQ21Assignment of screens to screen groups
TQ25QM:screen sequence for master and inspection characteristics

Important SAP QM Tables QM Catalog

The main SAP QM Tables for Quality Management Catalog are:

Table Description
QPCDInspection catalog codes
QPCTCode texts
QPGRInspection catalog code groups
QPGTCode group texts
TQ07Follow-Up Action for Usage Decision of Inspection Lot
TQ07AQM: Function Modules for Follow-Up Action
TQ07TLanguage-dependent texts for Table TQ07
TQ15Inspection catalog type index
TQ15TLanguage-dependent texts for table TQ15
TQ17Defect classes
TQ17TLanguage-dependent texts for table TQ17

Sample Determination

Sample Determination is based on these SAP QM Tables:

Table Description
QDEBAllwd. Relationships: Sampling Procedures/Dynamic Mod. Rules
QDEBTAllowed combinations of procedures/dynamic mod. rules: texts
QDPASampling scheme-instructions
QDPKSampling scheme header
QDPKTSampling scheme: texts
QDPPSampling scheme item
QDQLQuality level

Inspection Char

Inspection Char in Quality Management Data model are based on the following SAP QM Tables

Table Description
TQ17AWeighting of Char
TQ11Inspection Qualification
TQ29Tolerance Keys
T006Unit of measurement

Dynamic Modification

Table Description
QDBMValuation mode
QDBMTValuation Mode: Texts
QDDRDynamic modification rule (header)
QDDRTDynamic modification rule: texts
QDEPAllowed inspection severities
QDEPTAllowed Inspection Severities: Texts
QDFBFunction modules for the individual procedure categories
QDFBTFunction Modules for Procedure: Texts
QDFMFunction modules for valuation mode
QDFMTFunction Modules for Valuation Mode: Texts
QDPSInspection stages for a dynamic modification rule
QDPSTInspection Stages: Texts
QDSASampling type
QDSATSampling Type: Texts
QDSVSampling procedure
QDSVTSampling Procedure: Texts
TQ39BQM : Activates reference for dyn. modification level

Graphics & SPC

Table Description
QASHQuality control chart
QASTControl chart track
QPSHControl chart types
QPSHTTexts for control chart types
QPSPSPC criterion
QPSPTTexts for SPC criteria
QPSTControl chart track
QPSTTTexts for control chart tracks

Specifications

Table Description
QMSPQM: material specification

Inspection Plan

Main SAP QM Tables for Inspection Plan are :

Table Description
MAPLMaterial Assignment
PLPOOperation Details
PLMKInspection plan characteristics
PLMWMAPL-Dependent Charac. Specifications (Inspection Plan)
TQ03QSS: Control for Screen Texts/TABLE NOT USED (Rel. 4.6)
TQ29ADependency tolerance key – nominal measurement
TQ72Type of share calculation
TQ72TTexts for type of share calculation
TQ75QM formula parameters
TQ75FField names for QM formulas
TQ75KShort text for Table TQ75F
TQ75TDescription of formula parameters

Qm in procurement

Procurement SAP QM Tables Diagram is based on :

Table Description
TQ02QM system definition
TQ02AQM system assignment and QM system requirements
TQ02BQM system
TQ02TQM system description
TQ02UDescription QM system
TQ04AFunctions that can be blocked
TQ04SQM block functions : texts
TQ05QM certificate categories for procurement
TQ05TQM: text table for certificate types
TQ08Control of QM in procurement
TQ08TQM: text for QM procurement keys
TQ09QM: agreement of QM document types
TQ09TQM: agreement of QM document types
TQ32AInspection type to status assignment from status profile

QM in SD

Table Description
TQ32BFind insp.type for quality insp. for delivery note

Inspection lot

Table Description
QALSInspection lot record
QALTPartial lot
T156QMovement Type: Material-Independent Control
TQ30Inspection types
TQ30TTexts for inspection types
TQ32Assignment of inspection type to origin
TQ32CLot creation allowed values for the origin
TQ32C_T Texts for lot creation indicator
TQ33Relevant fields for origin
TQ34Default values for inspection type

Important SAP QM Tables for Inspection point

Table Description
QAPPInspection point
TQ79Table with inspection point/user field combinations
TQ79TKey words for inspeciton point user fields

Important SAP QM Tables for Results Recording

Table Description
QAESSample unit table
QAKLResults table for value classes
QAMRCharacteristic results during inspection processing
QAMVCharacteristic specifications for inspection processing
QASEResults table for the sample unit
QASRSample results for inspection characteristics
QASVSample specifications for inspection processing
TQ12Ind. external numbering for test units in results recording
TQ12TTexts for the ind. for ext. numbering of units to be insp.
TQ70Control table for results recording
TQ70CFunction codes for navigation from the char.overview screen
TQ70EScreen-based processing tables
TQ70FNavigation during results recording
TQ70SCharacteristic overview screen for results recording
TQ73Origin of results data
TQ73TTexts for origin of results data
TQ74Recording configuration
TQ74TRecording configuration
TQ76Processing status of inspection characteristics
TQ76TTexts for the processing status of insp. characteristics
TQ77Attributes for the Inspection Characteristic
TQ77TText Tables for Attributes
TQ78Status-dependent processing table for insp. characteristics
TQ78TTexts for the status-specific proc. table for insp. char.

Important SAP QM Tables for Defects recording

Table Description
TQ84Confirmation profile
TQ84TText table for confirmation profile
TQ86Report category for defects recording
TQ86AAssignment report category for work center
TQ86TText table for report category
V_T352B_F Generated table for view V_T352B_F

Important SAP QM Tables for Usage decision

SAP QM Tables for Usage Decision are:

Table Description
QAMBQM: Link Between Inspection Lot and Material Document
QAVEInspection processing: Usage decision
TQ06Procedure for Calculating the Quality Score
TQ06TLanguage-specific texts for Table TQ06
TQ07MQM: Inventory postings with usage decision

Important SAP QM Tables for Sample Mgmt

Sample Management in SAP QM TAbles model is:

Table Description
QPRNSample drawing of phys. samples
QPRSMaster record for phys. samples
QPRVKSample-drawing procedure
QPRVKT Header for sample drawing procedure texts
QPRVPSample-drawing items
QPRVPT Items for sample drawing procedure texts
TQ40Definition of sample types
TQ40TText table for sample type
TQ41Storage locations for physical samples
TQ41TTexts for storage locations
TQ42Physical sample containers
TQ42TTexts for phys. sample containers

Important SAP QM Tables for QMIS

Table Description
S068Vendor statistics
S069Material statistics
S097QM notifications: Matl anal.
S098QM notification: Vendor anal.
S099QM notifications: Cust. anal.
S100Problems: Material analysis
S102Problems: Vendor analysis
S103Problems: Customer analysis
S104Customer statistics
S161Inspection results: General
S162Quantitative insp. results
S163Quant. Insp. Result: Vendor
S164Quant. Insp. Result: Vendor
S165Inspection result: gen. custs
S166Insp. Results: Quant. Customer
TQ55Assign inspection lot origin for update group
TQ56Definition of quality score classes
TQ56TText table for the definition of quality score classes
TQ57Assignment of quality score key to info structure

Important SAP QM Tables for Quality Certificates

Table Description
QCPRQM quality certificates in procurement
I000Conditions for certificate profile
KONDIConditions: Data part for certificates
QCVKCertificate profile header
QCVMCertificate profile characteristic level
QCVMTCertificate profile characteristic level: texts
QCVVCertificate Profile: List of Preliminary Products
TQ61Result value origin for certificates
TQ61TOrigin of result values for certificates: texts
TQ62Output strategy for skip characteristics
TQ62TOutput strategy for skip characteristics: texts
TQ63Origin of insp. specs for certificates (function modules)
TQ63TOrigin of inspection specifications for certificates: texts
TQ64Origin of characteristic short text for certificates
TQ64TOrigin of characteristic short text for certificates: texts
TQ65Certificates: Combinations allowed for origins and specs/values
TQ67Certificate-Relevant Output Types

Important SAP QM Tables for Quality Notification

Quality Notification in SAP Quality Management are stored in these SAP QM Tables:

Table Description
QMELNotification header
QMFEItem
QMSMTask
QMMAActivities
T352CCatalog types for each catalog profile
TQ81Notification Scenario
TQ81VUsage of parts
TQ81V_TTexts for usage of parts
TQ81_TTexts for Notification Scenarios
TQ82Change of Notification Type
TQ83Partner Functions for Codes
TQ85Function table for follow-up functions
TQ85RRules for Follow-Up Functions
TQ85_T Action box text table
TQ8COAssignment of reference orders to notification type

To complete this list, check SAP Quality Management Tables and their Relationship ‘s scn post.

Other Objects

Here a list of SAP QM related tables. This list contains list of main SAP Tables used in SAP QM and other SAP modules:

Table Description
MARAMaterial Number
T001WPlant
LFA1Vendor
KNA1Customer
AUFKOrder Number
SAFKRun Schedule Header Number
MCH1Batch Number
MCHABatch Record
EKKOPurchasing Document Header
EKPOPurchasing document Item
EKETDelivery Schedule
VBUKDelivery Header
VBUPDelivery Item
CSKSCost Center
EQUIEquipment Number

If I missed a relevant SAP QM tables, please add a comment and I will update the list. Thanks

 

Sab125

Hi. I have been working as SAP Technical and functional for a decade. Through this blog, I am trying to share with you my experience. Hopefull, it makes your ways easier path ...Sab