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