SAP Table QDSV

Sampling procedure

QDSV (Sampling procedure) 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 QDSV to other SAP tables.

QDSV table fields

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

QDSV foreign key relationships

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