1. Home
  2. Resources
  3. SAP Tables
  4. RQMSP - QM: material specification internal structure

SAP Table RQMSP

QM: material specification internal structure

RQMSP (QM: material specification internal structure) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RQMSP to other SAP tables.

RQMSP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
ZAEHLER Internal Counter for DB Objects Q_COUNT NUMC 6 0
DATUV Date, for Which the Change Is Planned QPLANDAT DATS 8 0
ATINN Internal characteristic ATINN NUMC 10 0
WERKS Plant for the Master Inspection Characteristic QZAEHLER CHAR 4 0
MKMNR Master Inspection Characteristics QMERKNR QPMK CHAR 8 0
VERSION Version Number of the Master Inspection Characteristic QVERSNRMK CHAR 6 0
SOLLWERT Target Value for a Quantitative Characteristic QSOLLWERTE FLTP 16 16
SOLLWNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLERANZOB Upper Specification Limit QTOLOB FLTP 16 16
TOLOBNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLERANZUN Lower Tolerance Limit QTOLUN FLTP 16 16
TOLUNNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MASSEINHSW Unit of Measurement, in Which Quantitative Data Is Stored QMASSEH T006 UNIT 3 0
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) QSTELLEN INT1 3 0
0 To a maximum of 10 decimal places
AUSWMENGE1 Assigned Code Group or Selected Set QCGRAUSW CHAR 8 0
AUSWMGWRK1 Plant of the Assigned Selected Set QWERKAUSW T001W CHAR 4 0
VERSION1 Version Number QVERSNR CHAR 6 0
STEUERKZ Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL CHAR 30 0
STICHPRVER Sampling Procedure in Inspection Characteristic QSTICHVERF QDSV CHAR 8 0
PROBEMGEH Sample Unit of Measure QPROBME T006 UNIT 3 0
PRUEFEINH Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK DEC 5 2
REFERAMK Values Are Referenced in the Specification QREFERAMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
STICHPRPP Sampling Procedure for Inspection Point Processing QSTICHPNKT QDSV CHAR 8 0
QERGDATH Planned Results Data Origin QERGDATHPL TQ73 CHAR 2 0
CHARACT_ID1 Characteristic Description for Quality Data Exchange QCHARACT_ID1 CHAR 40 0
ATCOD Code for value dependency ATCOD CHAR 1 0
ATNAM Characteristic Name ATNAM CHAR 30 0
ATBEZ Characteristic description ATBEZ CHAR 30 0
KURZTEXT Short Text for Inspection Characteristic QTXT_CHA CHAR 40 0
KURZTEXTAM Short Description of the Selected Set QKTEXTAM CHAR 40 0
STICHPRTXT Short Text for the Sampling Procedure QTXTSMPPRO CHAR 40 0
STICHPPTXT Short Text for the Sampling Procedure QTXTSMPPRO CHAR 40 0
SEL_FLG Field for selecting records SEL_FLG CHAR 1 0
LOEKZ X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
QUANTITAT Quantitative Characteristic QKZQUNMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANZST Number of Characters ANZST INT2 5 0
ANZDZ Number of Decimal Places ANZDZ INT2 5 0
ATERF Entry Required ATERF CHAR 1 0
X Yes
NULL No
* Reference indicator
ATFOR Data type of characteristic ATFOR CHAR 4 0
CHAR Character Format
CURR Currency Format
DATE Date Format
NUM Numeric Format
TIME Time Format
UDEF User-Defined Data Type
ATFLV Internal floating point from ATFLV FLTP 16 16
ATFLVNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
ATFLB Internal floating point value to ATFLB FLTP 16 16
ATFLBNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MSEHI Unit of Measurement MSEHI UNIT 3 0
WERKAMK Plant WERKS_D CHAR 4 0
KATALOGART Catalog QKATART CHAR 1 0
AUSWAHLMGE Selected Set QAUSWAHLMG CHAR 8 0

RQMSP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RQMSP AUSWMGWRK1 RQMSP AUSWMGWRK1 T001W Plants/Branches WERKS
RQMSP AUSWMGWRK1 RQMSP MANDT T001W Plants/Branches MANDT
RQMSP MANDT RQMSP MANDT T000 Clients MANDT
RQMSP MASSEINHSW RQMSP MANDT T006 Units of Measurement MANDT
RQMSP MASSEINHSW RQMSP MASSEINHSW T006 Units of Measurement MSEHI
RQMSP MATNR RQMSP MANDT MARA General Material Data MANDT
RQMSP MATNR RQMSP MATNR MARA General Material Data MATNR
RQMSP MKMNR RQMSP WERKS QPMK Inspection characteristic master ZAEHLER
RQMSP MKMNR RQMSP MKMNR QPMK Inspection characteristic master MKMNR
RQMSP MKMNR RQMSP VERSION QPMK Inspection characteristic master VERSION
RQMSP MKMNR RQMSP MANDT QPMK Inspection characteristic master MANDT
RQMSP PROBEMGEH RQMSP MANDT T006 Units of Measurement MANDT
RQMSP PROBEMGEH RQMSP PROBEMGEH T006 Units of Measurement MSEHI
RQMSP QERGDATH RQMSP QERGDATH TQ73 Origin of results data QERGDATH
RQMSP QERGDATH RQMSP MANDT TQ73 Origin of results data MANDT
RQMSP STICHPRPP RQMSP MANDT QDSV Sampling procedure MANDT
RQMSP STICHPRPP RQMSP STICHPRPP QDSV Sampling procedure STICHPRVER
RQMSP STICHPRVER RQMSP MANDT QDSV Sampling procedure MANDT
RQMSP STICHPRVER RQMSP STICHPRVER QDSV Sampling procedure STICHPRVER