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 | Possible values | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
ZGLIEF
Certificate Required for Each Delivery
|
QZGLIEF |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
ZGPRUEF
Explicit Inspection of GR Certificate Necessary
|
QZGPRUEF |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MSGART
Control if Certificate Is Not Available
|
QMSGZG |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
STSMA
Status Profile
|
J_STSMA | TJ20 |
CHAR
|
8 | 0 | |||||||||||||||||||||
|
QCPRACT
Enhanced Certificate Processing Active
|
QCPRACT |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
QGRPOP
Prevent Certificate Confirmation at GR
|
QCGRPOP |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
QREMIND
Reminder Deadline (Days)
|
QCREMIND |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
QESCAL
Escalation Deadline (days) After Sending Reminder
|
QCESCAL |
NUMC
|
4 | 0 | ||||||||||||||||||||||