SAP table QPCD (Inspection catalog codes)
SAP table QPCD has 5 primary key fields being MANDT,KATALOGART,CODEGRUPPE,CODE,VERSION.
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
Client
CLNT
3
0
T000
MANDT
Catalog
CHAR
1
0
TQ15
QKATART
Code Group
CHAR
8
0
QPGR
QCODEGRP
Code
CHAR
4
0
QCODE
Version Number
CHAR
6
0
QVERSNR
GUELTIGAB
Valid-From Date
DATS
8
0
DATUV
FEHLKLASSE
Defect Class
CHAR
2
0
TQ17
QFEHLKLAS
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
INAKTIV
Status of Code Group or Code Record
CHAR
1
0
QINAK
Possible values
Active
D
Deactivated
X
Deleted
VERWENDUNG
Data Record Is Used
CHAR
1
0
QVERW
GELOESCHT
Data Record Was Deleted
CHAR
1
0
QGEL
FOLGEAKTI
Follow-Up Action
CHAR
8
0
QFOLGEAKTI
CODE4ACTIONBOX_REL
Task Code Is Used for Action Box of Notification
CHAR
1
0
QCODE4ACTIONBOX_REL
QPCD foreign key relationships
Table
Field
Check Table
Check Field
0 QPCD
CODEGRUPPE
QPGR Inspection catalog code groups
MANDT
0 QPCD
CODEGRUPPE
QPGR Inspection catalog code groups
KATALOGART
1 QPCD
FEHLKLASSE
TQ17 Defect classes
MANDT
0 QPCD
KATALOGART
TQ15 Inspection catalog type index
KATALOGART