SAP Table
QPCD Inspection catalog codes
SAP table QPCD has 5 primary key fields being MANDT,KATALOGART,CODEGRUPPE,CODE,VERSION.
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
QPCD 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 | QPGR | QCODEGRP | |||||||
| KeyCODE | Code | CHAR | 4 | 0 | QCODE | ||||||||
| KeyVERSION | 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 | ||||||||
|
|||||||||||||
| 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 | ||||||||
/ Relationships