SAP ABAP Table QCVV (Certificate Profile: List of Preliminary Products)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ QC (Package) QM quality certificate
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
QC (Package) QM quality certificate
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | QCVV |
Table Relationship Diagram 
|
| Short Description | Certificate Profile: List of Preliminary Products |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDANT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | CTYP |
QZGTYP | QZGTYP | CHAR | 4 | 0 | Certificate Type | TQ05 | |
| 3 | VORLNR |
QVORLNR | QVORLNR | CHAR | 12 | 0 | Certificate Profile Number | QCVK | |
| 4 | VERSION |
QCVERSION | QVERSNR | CHAR | 6 | 0 | Version Number of Certificate Profile | ||
| 5 | VMKATEG |
QCVMATKAT | QCVMATKAT | CHAR | 1 | 0 | Category of Data Origin (Insp. Lot/Batch) for Certificate | ||
| 6 | MATNR |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 7 | COUNTER |
QCVVCOUNT | NUMC3 | NUMC | 3 | 0 | Sequential Number for Material in a Certificate Profile | ||
| 8 | BLOCKNR |
QBLOCKNR | NUMC4 | NUMC | 4 | 0 | Number of Characteristic Block | ||
| 9 | VMSORTNR |
QCSORTNR | NUMC4 | NUMC | 4 | 0 | Sort Number in List of Materials for Certificate Profile | ||
| 10 | HERKUNFT |
QHERK | QHERK | CHAR | 2 | 0 | Inspection Lot Origin | TQ31 | |
| 11 | ART |
QPART | QPART | CHAR | 8 | 0 | Inspection Type | TQ30 | |
| 12 | KZGUTLOSE |
QKZGUTLOSE | QKZ | CHAR | 1 | 0 | Indicator: Only Lots Whose Usage Decision is OK | ||
| 13 | MINQKZ |
QKZMIN | QKENNZAHL | DEC | 3 | 0 | Minimum Quality Score for Good Quality |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | QCVV | ART |  TQ30 |
ART |
REF | 1 | CN |
| 2 | QCVV | CTYP | TQ05 |
ZGTYP |
KEY | 1 | CN |
| 3 | QCVV | HERKUNFT | TQ31 |
HERKUNFT |
KEY | ||
| 4 | QCVV | MANDANT | T000 |
MANDT |
KEY | 1 | CN |
| 5 | QCVV | MATNR | MARA |
MATNR |
KEY | 1 | CN |
| 6 | QCVV | VORLNR | QCVK |
VORLNR |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20030605 |
| SAP Release Created in |
