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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
KZUMFS
Multiple Samples
|
QKZUMFS |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
KZNOCUT
Sample Size Not Reduced
|
QKZNOCUT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
KZNVWSV
Sampling Procedure Cannot Be Used
|
QKZNVWSV |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
KZVWSVPL
Sampling Procedure Is Used in Inspection Plan
|
QKZVWSVPL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
PROZAZL
Acceptance Number as Percentage of Sample Size
|
QPROZAZL |
FLTP
|
16 | 16 | ||||||||||||
|
PROZAZLNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 |