SAP ABAP Table QMSP (QM: material specification)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QM (Package) QM inspection specifications

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QMSP	Table Relationship Diagram
Short Description	QM: material specification

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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	ZAEHLER	☑	Q_COUNT	Q_COUNT	NUMC	6	0	Internal Counter for DB Objects
4	DATUV	☐	QPLANDAT	DATUM	DATS	8	0	Date, for Which the Change Is Planned
5	ATINN	☐	ATINN	ATINN	NUMC	10	0	Internal characteristic	*
6	WERKS	☐	QZAEHLER	QZAEHLER	CHAR	4	0	Plant for the Master Inspection Characteristic
7	MKMNR	☐	QMERKNR	QMERKNR	CHAR	8	0	Master Inspection Characteristics	QPMK
8	VERSION	☐	QVERSNRMK	QVERSNR	CHAR	6	0	Version Number of the Master Inspection Characteristic
9	SOLLWERT	☐	QSOLLWERTE	QSOLLWERTE	FLTP	16	16	Target Value for a Quantitative Characteristic
10	SOLLWNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
11	TOLERANZOB	☐	QTOLOB	QSOLLWERTE	FLTP	16	16	Upper Specification Limit
12	TOLOBNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
13	TOLERANZUN	☐	QTOLUN	QSOLLWERTE	FLTP	16	16	Lower Tolerance Limit
14	TOLUNNI	☐	QNINITIAL	QKZ	CHAR	1	0	Value Not Initial if Set
15	MASSEINHSW	☐	QMASSEH	MEINS	UNIT	3	0	Unit of Measurement, in Which Quantitative Data Is Stored	T006
16	STELLEN	☐	QSTELLEN	QSTELLEN	INT1	3	0	Number of Places to the Right of a Decimal Point (Accuracy)
17	AUSWMENGE1	☐	QCGRAUSW	QCGRAUSW	CHAR	8	0	Assigned Code Group or Selected Set
18	AUSWMGWRK1	☐	QWERKAUSW	WERKS	CHAR	4	0	Plant of the Assigned Selected Set	T001W
19	VERSION1	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
20	STEUERKZ	☐	QMKCONTROL	QMKCONTROL	CHAR	30	0	Cntrl Indicator String for Insp. Char./Master Insp. Char.
21	STICHPRVER	☐	QSTICHVERF	QSTPRVER	CHAR	8	0	Sampling Procedure in Inspection Characteristic	QDSV
22	PROBEMGEH	☐	QPROBME	MEINS	UNIT	3	0	Sample Unit of Measure	T006
23	PRUEFEINH	☐	QPROBEFAK	QPROBEFAK	DEC	5	2	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)
24	REFERAMK	☐	QREFERAMK	QKZ	CHAR	1	0	Values Are Referenced in the Specification
25	STICHPRPP	☐	QSTICHPNKT	QSTPRVER	CHAR	8	0	Sampling Procedure for Inspection Point Processing	QDSV
26	QERGDATH	☐	QERGDATHPL	QERGDATH	CHAR	2	0	Planned Results Data Origin	TQ73
27	CHARACT_ID1	☐	QCHARACT_ID1	QCHARACT_ID	CHAR	40	0	Characteristic Description for Quality Data Exchange

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QMSP	AUSWMGWRK1	T001W	WERKS	REF	C	CN
2	QMSP	MANDT	T000	MANDT	KEY	1	CN
3	QMSP	MASSEINHSW	T006	MSEHI	REF	C	CN
4	QMSP	MATNR	MARA	MATNR	KEY	1	CN
5	QMSP	MKMNR	QPMK	MKMNR
6	QMSP	PROBEMGEH	T006	MSEHI	REF	C	CN
7	QMSP	QERGDATH	TQ73	QERGDATH
8	QMSP	STICHPRPP	QDSV	STICHPRVER		1	CN
9	QMSP	STICHPRVER	QDSV	STICHPRVER	REF	C	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in