SAP Table
QPGR Inspection catalog code groups
SAP table QPGR has 3 primary key fields being MANDT,KATALOGART,CODEGRUPPE.
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
QPGR columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyKATALOGART | Catalog | CHAR | 1 | 0 | TQ15 | QKATART | |||||||||
| KeyCODEGRUPPE | Code Group | CHAR | 8 | 0 | QCODEGRP | ||||||||||
| 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 | ||||||||||
| VERWENDUNG | Data Record Is Used | CHAR | 1 | 0 | QVERW | ||||||||||
| INAKTIV | Status of Code Group or Code Record | CHAR | 1 | 0 | QINAK | ||||||||||
|
|||||||||||||||
| STATUS | Status of Master Record | CHAR | 1 | 0 | QLOESCHKZ1 | ||||||||||
|
|||||||||||||||
/ Relationships
QPGR foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| QPGR | KATALOGART | TQ15 | Inspection catalog type index | KATALOGART |