SAP table QPGR (Inspection catalog code groups)

SAP table QPGR has 3 primary key fields being MANDT,KATALOGART,CODEGRUPPE.

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 T000 MANDT
KATALOGART Catalog CHAR 1 0 TQ15 QKATART
CODEGRUPPE 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
Active
D Deactivated
X Deleted
STATUS Status of Master Record CHAR 1 0 QLOESCHKZ1
1 Being Created
2 Released
3 Can No Longer Be Used
4 Deletion Flag

QPGR foreign key relationships

Table Field Check Table Check Field
0 QPGR KATALOGART TQ15 Inspection catalog type index KATALOGART