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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| STICHPRART | Sampling Type | QSTPRART | CHAR | 3 | 0 | |||||||
| KZTAB | Sample from a Sampling Scheme | QKZTAB | CHAR | 1 | 0 |
Possible values
|
||||||
| KZANT | Percentage Sample | QKZANT | CHAR | 1 | 0 |
Possible values
|
||||||
| KZFIX | Fixed Sample | QKZFIX | CHAR | 1 | 0 |
Possible values
|
||||||
| KZ100 | 100% Inspection | QKZ100 | CHAR | 1 | 0 |
Possible values
|
||||||
| KZNVWSA | Sampling Type Cannot Be Used | QKZNVWSA | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 |
