SAP CMD_MATERIAL_S_QMAT Table in S/4 HANA - CMD: Material Parameters for Inspection Type
CMD_MATERIAL_S_QMAT is a standard SAP Table which is used to store CMD: Material Parameters for Inspection Type data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP CMD_MATERIAL_S_QMAT table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: CMD_MATERIAL_S_QMAT
CMD_MATERIAL_S_QMAT table structure field list
Below is the full CMD_MATERIAL_S_QMAT field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| ART | Inspection Type | QPART | CHAR | 8(0) | TQ30 | QPART | QLA | |||
| MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
| WERKS | Plant | WERKS_D | CHAR | 4(0) | T001W | WERKS | WRK | H_T001W_C | WERKS | |
| PPL | Inspection with Task List | QPPL | CHAR | 1(0) | QKZ | |||||
| SPEZUEBER | Inspect with Material Specification | QSPEZUEBER | CHAR | 1(0) | QKZ | |||||
| CONF | Inspection Specifications from Configuration | QCONF | CHAR | 1(0) | QKZ | |||||
| TLS | Inspection Specifications from Batch Determination | QCHARG | CHAR | 1(0) | QKZ | |||||
| APP | Automatic Specification Assignment | QAPP_D | CHAR | 1(0) | QKZ | |||||
| MER | Inspect by Characteristics | QMERK | CHAR | 1(0) | QKZ | |||||
| INSMK | Post to Inspection Stock | QINSMK | CHAR | 1(0) | QKZ | |||||
| AVE | Automatic Usage Decision Planned | QAUTO_VE | CHAR | 1(0) | QKZ | |||||
| STICHPRVER | Sampling Procedure | QSTPRVER | CHAR | 8(0) | Assigned to domain | QSTPRVER | QSV | |||
| DYNREGEL | Dynamic Modification Rule | QDYNREGEL | CHAR | 3(0) | Assigned to domain | QDYNREGEL | QDR | |||
| SPROZ | Inspection Percentage | QSPROZ | DEC | 3(0) | DEC3 | |||||
| HPZ | 100% Inspection | QHPZ | CHAR | 1(0) | QKZ | |||||
| DYN | Skips Allowed | QDYN | CHAR | 1(0) | QKZ | |||||
| MPB | Enter Sample Manually | QMPB | CHAR | 1(0) | QKZ | |||||
| MST | Trigger Sample Calculation Manually | QMST | CHAR | 1(0) | QKZ | |||||
| EIN | Serial Number Management Possible | QEINZ | CHAR | 1(0) | QKZ | |||||
| MPDAU | Average Inspection Duration | QMPDAU | DEC | 3(0) | DEC3 | |||||
| CHG | Control of Inspection Lot Creation (Lot Summary) | Q1WELOS | CHAR | 1(0) | TQ32C | Q1WELOS | ||||
| QKZVERF | Procedure for Calculating Quality Score | QKZVERF | CHAR | 2(0) | TQ06 | QKZVERF | ||||
| QPMAT | Allowed Share of Scrap (Percent) in Inspection Lot | QAUSSCHUSS | DEC | 6(4) | QPMAT | |||||
| KZPRFKOST | Record Appraisal Costs in Individual QM Order | QKZPRFKOST | CHAR | 1(0) | QKZ | |||||
| AUFNR_CO | Order Number for Recording Appraisal Costs | QAUFNR_CO | CHAR | 12(0) | AUFK | ALPHA | AUFNR | ANR | ||
| AKTIV | Inspection Type - Material Combination is Active | QMATAKTIV | CHAR | 1(0) | QKZ | |||||
| APA | Preferred Inspection Type | QAPA | CHAR | 1(0) | QKZ | |||||
| AFR | Inspection for Handling Unit | QAFR | CHAR | 1(0) | QKZ | |||||
| MMA | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1(0) | CHAR1 | |||||
| FEH | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1(0) | CHAR1 | |||||
| PRFRQ | Field Not Used as of 3.0 Field Reserved for SAP | QPRFRQ | DEC | 3(0) | QPRFRQ | |||||
| NKMPR | Field Not Used as of 3.0 Field Reserved for SAP | QNKMPR | DATS | 8(0) | DATUM | |||||
| MS_FLAG | Indicator: Multiple Specifications | Q_MS_FLG | CHAR | 1(0) | Q_MS_FLG | |||||
| CHG_ORIG_17 | Inspection Lot Summary (Warehouse-Managed Stock) | QLOT_CONTROL_ORIGIN_17 | CHAR | 1(0) | /SCWM/DO_QDOC_CNTRL |
Search for further information about these or an SAP related objects