SAP table TQ05 (QM certificate categories for procurement)

SAP table TQ05 has 2 primary key fields being MANDT,ZGTYP.

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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
ZGTYP Certificate Type CHAR 4 0 QZGTYP
WEPRF Certificate Required for Each Purchase Order Item CHAR 1 0 QWEPRF
ZGLIEF Certificate Required for Each Delivery CHAR 1 0 QZGLIEF
ZGPRUEF Explicit Inspection of GR Certificate Necessary CHAR 1 0 QZGPRUEF
MSGART Control If Certificate Is Not Available CHAR 1 0 QMSGZG
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
E Without Lot: Blocked Stock, with Lot: Status
F Without Lot: Error Message, with Lot: Status, No SkipToStock
I Information
N No Message
W Warning
STSMA Status Profile CHAR 8 0 TJ20 J_STSMA
QCPRACT Enhanced Certificate Processing Active CHAR 1 0 QCPRACT
QGRPOP Prevent Certificate Confirmation at GR CHAR 1 0 QCGRPOP
QREMIND Reminder Deadline (Days) NUMC 4 0 QCREMIND
QESCAL Escalation Deadline (Days) After Sending Reminder NUMC 4 0 QCESCAL
SIGN_TYPE Signature Type CHAR 1 0 QSIGNTYPE
SIGNSTRAT Signature Strategy CHAR 8 0 TC85 QSIGNSTRAT

TQ05 foreign key relationships

Table Field Check Table Check Field
0 TQ05 SIGNSTRAT TC85 Signature Strategy MANDT
0 TQ05 SIGNSTRAT TC85 Signature Strategy APPLICID
1 TQ05 STSMA TJ20 Status profiles MANDT
1 TQ05 STSMA TJ20 Status profiles STSMA