SAP Table

TQ40 Definition of sample types

SAP table TQ40 has 2 primary key fields being MANDT,PRART.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

TQ40 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyPRART 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
/ Relationships

TQ40 foreign keys.

Table Field Check Table Description Check Field
TQ40 FB_ETIKETT TFDIR Function Module FUNCNAME
TQ40 STSMA TJ20 Status profiles MANDT
TQ40 STSMA TJ20 Status profiles STSMA
Back to SAP tables