SAP Table QDSA
Sampling type
QDSA (Sampling type) 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 QDSA to other SAP tables.
QDSA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
STICHPRART
Sampling Type
|
QSTPRART |
CHAR
|
3 | 0 | ||||||||
|
KZTAB
Sample from a Sampling Scheme
|
QKZTAB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZANT
Percentage Sample
|
QKZANT |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZFIX
Fixed Sample
|
QKZFIX |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZ100
100% Inspection
|
QKZ100 |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZNVWSA
Sampling Type Cannot Be Used
|
QKZNVWSA |
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 | ||||||||
QDSA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QDSA | MANDT | QDSA | MANDT |
T000
Clients
|
MANDT |