SAP Table
TQ05 QM certificate categories for procurement
SAP table TQ05 has 2 primary key fields being MANDT,ZGTYP.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TQ05 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||||||||||
| KeyZGTYP | 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 | ||||||||||||||||||||
|
|||||||||||||||||||||||||
| 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 | |||||||||||||||||||