SAP Table TQ40
Definition of sample types
TQ40 (Definition of sample types) 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 TQ40 to other SAP tables.
TQ40 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| PRART | Physical-Sample Type | QPRART | CHAR | 2 | 0 | |||||||
| NUMKR | Number of the Number Range for Physical Samples | QPR_NK | CHAR | 2 | 0 | |||||||
| STSMA | Status Profile for Physical Samples | QSTSMA_PRS | TJ20 | CHAR | 8 | 0 | ||||||
| FB_ETIKETT | Function Module for Printing Labels | QFBS_QPR1 | TFDIR | CHAR | 30 | 0 | ||||||
| QKZ_ETDR | Print Physical-Sample Label Immediately | QKZ_ETDR | CHAR | 1 | 0 |
Possible values
|
||||||
| BS_SCHL | Screen Control Key for Physical Samples | QBSS_PROBE | TQ46 | CHAR | 2 | 0 | ||||||
TQ40 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TQ40 | BS_SCHL | TQ40 | BS_SCHL | TQ46 | Screen Control Key for Physical-Sample Type | BS_SCHL |
| TQ40 | FB_ETIKETT | TQ40 | FB_ETIKETT | TFDIR | Function Module | FUNCNAME |
| TQ40 | MANDT | TQ40 | MANDT | T000 | Clients | MANDT |
| TQ40 | STSMA | TQ40 | MANDT | TJ20 | Status profiles | MANDT |
| TQ40 | STSMA | TQ40 | STSMA | TJ20 | Status profiles | STSMA |
