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 |
|
|||||||||
| 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 |
|
|||||||||
| 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 |