SAP ABAP View V_QPGR_KAT (Code Groups)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-BF-CAT (Application Component) Catalogs
⤷
QSKT (Package) QM Basic Data: Catalog Data
BBPCRM (Software Component) BBPCRM⤷
CRM-BF-CAT (Application Component) Catalogs⤷
QSKT (Package) QM Basic Data: Catalog Data
Basic Data
| View Type | C | Maintenance View |
| Maintenance View | V_QPGR_KAT | |
| Short Description | Code Groups | |
| Root table | QPGR | Inspection Catalog Code Groups |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | QPGR |
QPGR | ||
| 2 | QPGT |
QPGR | CODEGRUPPE | I |
| 3 | TQ15 |
QPGR | KATALOGART | E |
| 4 | TQ15T |
TQ15 | KATALOGART | I |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | QPGR |
INAKTIV | EQ | ' ' | AND | 0 | 0 | |||
| 2 | QPGT |
INAKTIV | EQ | ' ' | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
QPGR |
MANDT | MANDT | Client | |||
| 2 | KATALOGART |
QPGR |
KATALOGART | S | COMT_CATALOG | Catalog | ||
| 3 | CODEGRUPPE |
QPGR |
CODEGRUPPE | QCODEGRP | Code Group | |||
| 4 | KURZTEXT |
QPGT |
KURZTEXT | QKTEXTGR | Code Group Description | |||
| 5 | STATUS |
QPGR |
STATUS | QLOESCHKZ1 | Status of Master Record | |||
| 6 | LTEXTV |
QPGT |
LTEXTV | H | QLTEXTGRP | Long Text Exists for the Code Group | ||
| 7 | VERWENDUNG |
QPGR |
VERWENDUNG | R | QVERW | Data Record is Being Used | ||
| 8 | INAKTIV |
QPGR |
INAKTIV | R | QINAK | Status of Code Group or Code Record | ||
| 9 | ERSTELLER |
QPGR |
ERSTELLER | R | QERSTELLER | Name of User Who Created the Data Record | ||
| 10 | E_DATUM |
QPGR |
E_DATUM | R | QDATUMERST | Date on Which the Data Record Was Created | ||
| 11 | AENDERER |
QPGR |
AENDERER | R | QAENDERER | Name of User who Most Recently Changed the Data Record | ||
| 12 | A_DATUM |
QPGR |
A_DATUM | R | QDATUMAEND | Date on Which Data Record Was Changed | ||
| 13 | INAKTIV_T |
QPGT |
INAKTIV | H | QINAK | Status of Code Group or Code Record | ||
| 14 | KATALOGTXT |
TQ15T |
KATALOGTXT | S | QTXTCATALG | Short Text for the Catalog | ||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
