SAP table TQ40 (Definition of sample types)
SAP table TQ40 has 2 primary key fields being MANDT,PRART.
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 | |
| PRART | Material Sample Type | CHAR | 2 | 0 | QPRART | ||
| NUMKR | Number of Number Range for Material Samples | CHAR | 2 | 0 | QPR_NK | ||
| STSMA | Status Profile for Material Samples | CHAR | 8 | 0 | TJ20 | QSTSMA_PRS | |
| FB_ETIKETT | Function Module for Printing Labels | CHAR | 30 | 0 | TFDIR | QFBS_QPR1 | |
| QKZ_ETDR | Print Sample Label Immediately | CHAR | 1 | 0 | QKZ_ETDR | ||
| BS_SCHL | Screen Control Key for Material Samples | CHAR | 2 | 0 | TQ46 | QBSS_PROBE |
TQ40 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TQ40 | FB_ETIKETT | TFDIR | Function Module | FUNCNAME |
| 1 TQ40 | STSMA | TJ20 | Status profiles | MANDT |
| 1 TQ40 | STSMA | TJ20 | Status profiles | STSMA |