1. Home
  2. Resources
  3. SAP Tables
  4. TQ05 - QM certificate categories for procurement

SAP Table TQ05

QM certificate categories for procurement

TQ05 (QM certificate categories for procurement) 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 TQ05 to other SAP tables.

TQ05 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
ZGTYP Certificate Type QZGTYP CHAR 4 0
WEPRF Certificate Required for Each Purchase Order Item QWEPRF CHAR 1 0
NULL Indicator is not set
X Indicator is set
ZGLIEF Certificate Required for Each Delivery QZGLIEF CHAR 1 0
NULL Indicator is not set
X Indicator is set
ZGPRUEF Explicit Inspection of GR Certificate Necessary QZGPRUEF CHAR 1 0
NULL Indicator is not set
X Indicator is set
MSGART Control if Certificate Is Not Available QMSGZG CHAR 1 0
E Without lot: Blocked stock, with lot: Status
A Without lot: Blocked stock, with lot: Error message
B Without lot: Blocked stock, with lot: Status, No skipToStock
C Without lot: Error message, with lot: Status
D Without lot: Error message, with lot: Error message
F Without lot: Error message, with lot: Status, no skipToStock
W Warning
I Information
N No notification
STSMA Status Profile J_STSMA TJ20 CHAR 8 0
QCPRACT Enhanced Certificate Processing Active QCPRACT CHAR 1 0
NULL Indicator is not set
X Indicator is set
QGRPOP Prevent Certificate Confirmation at GR QCGRPOP CHAR 1 0
NULL Indicator is not set
X Indicator is set
QREMIND Reminder Deadline (Days) QCREMIND NUMC 4 0
QESCAL Escalation Deadline (days) After Sending Reminder QCESCAL NUMC 4 0

TQ05 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TQ05 STSMA TQ05 MANDT TJ20 Status profiles MANDT
TQ05 STSMA TQ05 STSMA TJ20 Status profiles STSMA