QPAC SAP (Inspection catalog codes for selected sets) Table details
Dictionary Type: Table
Description: Inspection catalog codes for selected sets
Description: Inspection catalog codes for selected sets
Table field list including key, data, relationships and ABAP select examples
QPAC is a standard SAP Table which is used to store Inspection catalog codes for selected sets data and is available within R/3 SAP systems depending on the version and release level.
The QPAC table consists of various fields, each holding specific information or linking keys about Inspection catalog codes for selected sets data available in SAP. These include WERKS (Plant), KATALOGART (Catalog), AUSWAHLMGE (Selected Set), CODEGRUPPE (Code Group).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP QPAC table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| KATALOGART | Catalog | QKATART | CHAR | 1 | TQ15 | QKATART | QKT | ||
| AUSWAHLMGE | Selected Set | QAUSWAHLMG | CHAR | 8 | QPAM | QAUSWAHLMG | AWM | ||
| CODEGRUPPE | Code Group | QCODEGRP | CHAR | 8 | QPGR | QCODEGRP | CGP | ||
| CODE | Code | QCODE | CHAR | 4 | QPCD | QCODE | QCODE | ||
| VERSIONAM | Version Number of the Selected Set Record | QVERSNRAM | CHAR | 6 | ALPHA | QVERSNR | |||
| GUELTIGAB | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
| VERSIONCD | Version Number of the Code Record | QVERSNRCD | CHAR | 6 | ALPHA | QVERSNR | |||
| MASSNAHME | Short Text for Task | QMASSKTEXT | CHAR | 40 | QKURZTEXT | ||||
| LTEXTMASSV | Long Text Exists for the Task | QLTEXTMS | CHAR | 1 | QKZ | ||||
| AUSWIRKUNG | Short Text About Effect | QAUSWKTEXT | CHAR | 40 | QKURZTEXT | ||||
| LTEXTAUSWV | Long Text Exists for the Effect | QLTEXTAW | CHAR | 1 | QKZ | ||||
| BEWERTUNG | Code Valuation | QBEWERTUNG | CHAR | 1 | QBEWERTUNG | ||||
| FEHLKLASSE | Defect Class | QFEHLKLAS | CHAR | 2 | TQ17 | QFEHLKLAS | |||
| WAEHRUNG | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| FKOSTEN | Nonconformity Costs | QFKOSTEN | CURR | 10(2) | QFKOSTEN | ||||
| MUSSTEXTKZ | Text Must Be Entered when Results Are Confirmed | QMUSSTKZ | CHAR | 1 | QKZ | ||||
| AENDERKZ | Consider Long-Term Characteristics for Stock Proposal | Q1LZEITMK | CHAR | 1 | Q1LZEITMK | ||||
| ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | QAENDERER | ||||
| E_DATUM | Date on Which the Data Record Was Created | QDATUMERST | DATS | 8 | DATUM | ||||
| AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
| A_DATUM | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | DATUM | ||||
| GELOESCHT | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
| QKENNZAHL | Quality Score | QKENNZ | INT4 | 10 | QKENNZ | ||||
| FOLGEAKTI | Follow-Up Action | QFOLGEAKTI | CHAR | 8 | TQ07 | QFOLGEAKTI | |||
| BB_VORSCH | Stock Posting Proposal | Q_BB_VOR | CHAR | 1 | QKZ | ||||
| BB_DUNKEL | Background Processing of Stock Screen | Q_BB_DARK | CHAR | 1 | QKZ | ||||
| FELDNAME | Posting Proposal in Usage Decision | QMGBUCH | CHAR | 10 | QMGBUCH |
| Key field | Non-key field |
How do I retrieve data from SAP table QPAC using ABAP code
The following ABAP code Example will allow you to do a basic selection on QPAC to SELECT all data from the tableDATA: WA_QPAC TYPE QPAC.
SELECT SINGLE *
FROM QPAC
INTO CORRESPONDING FIELDS OF WA_QPAC
WHERE...
How to access SAP table QPAC
Within an ECC or HANA version of SAP you can also view further information about QPAC and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects