SAP Table
TQ15 Inspection catalog type index
SAP table TQ15 has 2 primary key fields being MANDT,KATALOGART.
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
TQ15 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||
| KeyKATALOGART | Catalog | CHAR | 1 | 0 | QKATART | ||
| KAM | Selected Sets Are Allowed for This Catalog Type | CHAR | 1 | 0 | QKZKAM | ||
| KAMB | Valuation of Selected Set Is Required | CHAR | 1 | 0 | QKZKAMB | ||
| ERSTELLER | Name of User Who Created the Data Record | CHAR | 12 | 0 | QERSTELLER | ||
| E_DATUM | System Date on Which Data Record Was Created | DATS | 8 | 0 | QDATUMERST | ||
| AENDERER | Name of User Who Last Changed Data Record | CHAR | 12 | 0 | QAENDERER | ||
| A_DATUM | System Date on Which Data Record Was Changed | DATS | 8 | 0 | QDATUMAEND | ||
| HIST | Deactivate Deleted Catalog Entries | CHAR | 1 | 0 | QHISTKAT | ||
| QCATFOA | Follow-Up Action Can Be Assigned in Catalog | CHAR | 1 | 0 | QCATFOA |