SAP table reference

TQ40

Definition of sample types

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table TQ40.

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

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

TQ40 fields.

7 fields

Field	Description	Data type	Length	Check table	Data element
Key MANDT	Client	CLNT	3	T000	MANDT
Key PRART	Material Sample Type	CHAR	2		QPRART
NUMKR	Number of Number Range for Material Samples	CHAR	2		QPR_NK
STSMA	Status Profile for Material Samples	CHAR	8	TJ20	QSTSMA_PRS
FB_ETIKETT	Function Module for Printing Labels	CHAR	30	TFDIR	QFBS_QPR1
QKZ_ETDR	Print Sample Label Immediately	CHAR	1		QKZ_ETDR
BS_SCHL	Screen Control Key for Material Samples	CHAR	2	TQ46	QBSS_PROBE

/ Relationships

TQ40 relationships.

3 relationships

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