- Home
- Resources
- SAP Tables
- 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.
Source: TQ05 (QM certificate categories for procurement)
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 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
ZGLIEF |
Certificate Required for Each Delivery |
QZGLIEF |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
ZGPRUEF |
Explicit Inspection of GR Certificate Necessary |
QZGPRUEF |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
MSGART |
Control if Certificate Is Not Available |
QMSGZG |
|
CHAR |
|
1 |
0 |
Possible values
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 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
QGRPOP |
Prevent Certificate Confirmation at GR |
QCGRPOP |
|
CHAR |
|
1 |
0 |
Possible values
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 |