SAP table QDSV (Sampling procedure)

SAP table QDSV has 2 primary key fields being MANDT,STICHPRVER.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
STICHPRVER Sampling Procedure CHAR 8 0 QSTPRVER
STICHPRART Sampling Type CHAR 3 0 QDSA QSTPRART
BEWERTMOD Valuation Mode CHAR 3 0 QDBM QBEWMOD
KZOHI No Inspection Stage Change CHAR 1 0 QKZOHI
KZUMFS Multiple Samples CHAR 1 0 QKZUMFS
No Multiple Samples
1 Dependent Multiple Samples
X Independent Multiple Samples
KZNOCUT Sample Size Not Reduced CHAR 1 0 QKZNOCUT
STPRANZ Number of Samples for Multiple Samples INT1 3 0 QSTPRANZ
STPRUMF Number of Sampling Units in a Sample INT4 10 0 QSTPRUMF
ANNAHMEZ Acceptance Number INT2 5 0 QANNAHMEZ
KFAKTOR K-Factor for a Variable Inspection FLTP 16 16 QKFAKTOR
KFAKTORNI Value Not Initial if Set CHAR 1 0 QNINITIAL
KZNVWSV Sampling Procedure Cannot Be Used CHAR 1 0 QKZNVWSV
KZVWSVPL Sampling Procedure Is Used in Task List CHAR 1 0 QKZVWSVPL
FBKEY Identifier for the Sample Determination Rule CHAR 2 0 QDFB QFBKEY
FBKEYMFS Code for Valuation Rule for Independent Multiple Sampling CHAR 2 0 QDFM QFBKEYMFS
STPRPLAN Sampling Scheme in Sampling Procedure CHAR 3 0 QDPK QSTPRPLANV
PRSCHAERFE Inspection Severity in Sampling Procedure NUMC 3 0 QDEP QPRSCHAERV
AQLWERT AQL Value in Sampling Procedure DEC 7 3 QAQLWERTV
PROZUMF Sample Size as Percentage of Lot Size FLTP 16 16 QPROZUMF
PROZUMFNI Value Not Initial if Set CHAR 1 0 QNINITIAL
PROZAZL Acceptance Number as Percentage of Sample Size FLTP 16 16 QPROZAZL
PROZAZLNI Value Not Initial if Set CHAR 1 0 QNINITIAL
ERSTELLER Name of User Who Created the Data Record CHAR 12 0 QERSTELLER
AENDERER Name of User Who Last Changed Data Record CHAR 12 0 QAENDERER
ERSTELLDAT System Date on Which Data Record Was Created DATS 8 0 QDATUMERST
AENDERDAT System Date on Which Data Record Was Changed DATS 8 0 QDATUMAEND
KZRAST Sampling Procedure for Inspection Points CHAR 1 0 QKZRAST
Without Inspection Points
1 Inspection Points for Plant Maintenance
2 Inspection Points for Sample Management
X Inspection Points for Production
RASTER Inspection Frequency (Only for Inspection with Insp. Points) NUMC 3 0 QRASTER
QRKART Control Chart Type CHAR 3 0 QPSH QQRKART
DUMMY_QDSV_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY

QDSV foreign key relationships

Table Field Check Table Check Field
0 QDSV BEWERTMOD QDBM Valuation mode MANDT
1 QDSV FBKEY QDFB Function modules for the individual procedure categories MANDT
1 QDSV FBKEY QDFB Function modules for the individual procedure categories FBKEY
0 QDSV FBKEYMFS QDFM Function modules for valuation mode MANDT
0 QDSV FBKEYMFS QDFM Function modules for valuation mode FBKEY
1 QDSV PRSCHAERFE QDEP Allowed inspection severities MANDT
0 QDSV QRKART QPSH Control chart types MANDT
0 QDSV QRKART QPSH Control chart types QRKART
1 QDSV STICHPRART QDSA Sampling type MANDT
1 QDSV STICHPRART QDSA Sampling type STICHPRART
0 QDSV STPRPLAN QDPK Sampling scheme header MANDT
0 QDSV STPRPLAN QDPK Sampling scheme header STPRPLAN