SAP Table QPACV
Logical data base QAM (QPAC and QPCT)
QPACV (Logical data base QAM (QPAC and QPCT)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link QPACV to other SAP tables.
QPACV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||
| KATALOGART | Catalog | QKATART | TQ15 | CHAR | 1 | 0 | ||||||||
| AUSWAHLMGE | Selected Set | QAUSWAHLMG | QPAM | CHAR | 8 | 0 | ||||||||
| CODEGRUPPE | Code Group | QCODEGRP | QPGR | CHAR | 8 | 0 | ||||||||
| CODE | Code | QCODE | QPCD | CHAR | 4 | 0 | ||||||||
| VERSIONAM | Version Number of the Selected Set Record | QVERSNRAM | CHAR | 6 | 0 | |||||||||
| GUELTIGAB | Valid-From Date | DATUV | DATS | 8 | 0 | |||||||||
| VERSIONCD | Version Number of the Code Record | QVERSNRCD | CHAR | 6 | 0 | |||||||||
| MASSNAHME | Short Text for Task | QMASSKTEXT | CHAR | 40 | 0 | |||||||||
| LTEXTMASSV | Long Text Exists for the Task | QLTEXTMS | CHAR | 1 | 0 |
Possible values
|
||||||||
| AUSWIRKUNG | Short Text About Effect | QAUSWKTEXT | CHAR | 40 | 0 | |||||||||
| LTEXTAUSWV | Long Text Exists for the Effect | QLTEXTAW | CHAR | 1 | 0 |
Possible values
|
||||||||
| BEWERTUNG | Code Valuation | QBEWERTUNG | CHAR | 1 | 0 |
Possible values
|
||||||||
| FEHLKLASSE | Defect Class | QFEHLKLAS | TQ17 | CHAR | 2 | 0 | ||||||||
| WAEHRUNG | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||
| FKOSTEN | Nonconformity Costs | QFKOSTEN | CURR | 10 | 2 | |||||||||
| MUSSTEXTKZ | Text Must Be Entered when Results Are Confirmed | QMUSSTKZ | CHAR | 1 | 0 |
Possible values
|
||||||||
| AENDERKZ | Create Change Documents | QAENKZ | CHAR | 1 | 0 |
Possible values
|
||||||||
| ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | 0 | |||||||||
| E_DATUM | Date on Which the Data Record Was Created | QDATUMERST | DATS | 8 | 0 | |||||||||
| AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | 0 | |||||||||
| A_DATUM | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | 0 | |||||||||
| GELOESCHT | Data Record Was Deleted | QGELOESCHT | CHAR | 1 | 0 |
Possible values
|
||||||||
| QKENNZAHL | Quality Score | QKENNZ | INT4 | 10 | 0 | |||||||||
| FOLGEAKTI | Follow-Up Action | QFOLGEAKTI | TQ07 | CHAR | 8 | 0 | ||||||||
| SPRACHE | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||
| KURZTEXT | Short Text | QKURZTEXT | CHAR | 40 | 0 | |||||||||
| LTEXTV | Long Text Exists for the Code | QLTEXTCODE | CHAR | 1 | 0 |
Possible values
|
||||||||
| INAKTIV | Status of Code Group or Code Record | QINAK | CHAR | 1 | 0 |
Possible values
|
||||||||
QPACV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| QPACV | AUSWAHLMGE | QPACV | MANDT | QPAM | Inspection catalog selected sets | MANDT |
| QPACV | AUSWAHLMGE | QPACV | WERKS | QPAM | Inspection catalog selected sets | WERKS |
| QPACV | AUSWAHLMGE | QPACV | KATALOGART | QPAM | Inspection catalog selected sets | KATALOGART |
| QPACV | AUSWAHLMGE | QPACV | AUSWAHLMGE | QPAM | Inspection catalog selected sets | AUSWAHLMGE |
| QPACV | CODE | QPACV | MANDT | QPCD | Inspection catalog codes | MANDT |
| QPACV | CODE | QPACV | KATALOGART | QPCD | Inspection catalog codes | KATALOGART |
| QPACV | CODE | QPACV | CODEGRUPPE | QPCD | Inspection catalog codes | CODEGRUPPE |
| QPACV | CODE | QPACV | CODE | QPCD | Inspection catalog codes | CODE |
| QPACV | CODE | QPACV | VERSIONAM | QPCD | Inspection catalog codes | VERSION |
| QPACV | CODEGRUPPE | QPACV | KATALOGART | QPGR | Inspection catalog code groups | KATALOGART |
| QPACV | CODEGRUPPE | QPACV | CODEGRUPPE | QPGR | Inspection catalog code groups | CODEGRUPPE |
| QPACV | CODEGRUPPE | QPACV | MANDT | QPGR | Inspection catalog code groups | MANDT |
| QPACV | FEHLKLASSE | QPACV | MANDT | TQ17 | Defect classes | MANDT |
| QPACV | FEHLKLASSE | QPACV | FEHLKLASSE | TQ17 | Defect classes | FEHLKLASSE |
| QPACV | FOLGEAKTI | QPACV | MANDT | TQ07 | Follow-Up Action for Usage Decision of Inspection Lot | MANDT |
| QPACV | FOLGEAKTI | QPACV | FOLGEAKTI | TQ07 | Follow-Up Action for Usage Decision of Inspection Lot | FOLGEAKTI |
| QPACV | KATALOGART | QPACV | MANDT | TQ15 | Inspection catalog type index | MANDT |
| QPACV | KATALOGART | QPACV | KATALOGART | TQ15 | Inspection catalog type index | KATALOGART |
| QPACV | MANDT | QPACV | MANDT | T000 | Clients | MANDT |
| QPACV | SPRACHE | QPACV | SPRACHE | T002 | Language Keys (Component BC-I18) | SPRAS |
| QPACV | WAEHRUNG | QPACV | MANDT | TCURC | Currency Codes | MANDT |
| QPACV | WAEHRUNG | QPACV | WAEHRUNG | TCURC | Currency Codes | WAERS |
| QPACV | WERKS | QPACV | MANDT | T001W | Plants/Branches | MANDT |
| QPACV | WERKS | QPACV | WERKS | T001W | Plants/Branches | WERKS |
