SAP ABAP Table MCQAVEB (QIS: communication structure for the usage decision)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ QM-QC-IS (Application Component) Information System
⤷ QG02 (Package) QM quality information system
⤷ QM-QC-IS (Application Component) Information System
⤷ QG02 (Package) QM quality information system
Basic Data
Table Category | INTTAB | Structure |
Structure | MCQAVEB | Table Relationship Diagram |
Short Description | QIS: communication structure for the usage decision |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
2 | .INCLUDE | 0 | 0 | Usage decision: interface to QIS | |||||
3 | .INCLUDE | 0 | 0 | Inspection processing: Usage decision | |||||
4 | MANDANT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
5 | PRUEFLOS | QPLOS | QPLOS | NUMC | 12 | 0 | Inspection Lot Number | QALS | |
6 | KZART | QKZART | QKZART | CHAR | 1 | 0 | Inspection Lot, Partial Lot, Single Unit, Interval | ||
7 | ZAEHLER | QVEZAEHLER | QVERSNR | CHAR | 6 | 0 | Counter for Usage Decision | ||
8 | VKATART | QKATART | QKATART | CHAR | 1 | 0 | Catalog | TQ15 | |
9 | VWERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
10 | VAUSWAHLMG | QVMENGE | QAUSWAHLMG | CHAR | 8 | 0 | Selected Set of the Usage Decision | QPAM | |
11 | VCODEGRP | QVGRUPPE | QCODEGRP | CHAR | 8 | 0 | Code Group of the Usage Decision | QPGR | |
12 | VCODE | QVCODE | QCODE | CHAR | 4 | 0 | Usage Decision Code | QPCD | |
13 | VERSIONAM | QVERSVE | QVERSNR | CHAR | 6 | 0 | Version Number of the Selected Set Record | ||
14 | VERSIONCD | QVERSNRCD | QVERSNR | CHAR | 6 | 0 | Version Number of the Code Record | ||
15 | VBEWERTUNG | QBEWERTUNG | QBEWERTUNG | CHAR | 1 | 0 | Code Valuation | ||
16 | DBEWERTUNG | QDBEWERT | QBEWERTUNG | CHAR | 1 | 0 | Dynamic Modif. Valuation According to Worst Case Principle | ||
17 | VFOLGEAKTI | QFOLGEAKTI | QFOLGEAKTI | CHAR | 8 | 0 | Follow-Up Action | TQ07 | |
18 | QKENNZAHL | QKENNZAHL | QKENNZAHL | DEC | 3 | 0 | Quality Score | ||
19 | LTEXTKZ | QLTEXTAVE | QKZ | CHAR | 1 | 0 | Long Text for Usage Decision | ||
20 | VNAME | QVNAME | QAENDERER | CHAR | 12 | 0 | Person who Made the Usage Decision | ||
21 | VDATUM | QVEDATUM | DATUM | DATS | 8 | 0 | Date of Code Used for Usage Decision | ||
22 | VEZEITERF | QVEZEITERF | QZEIT | TIMS | 6 | 0 | Time when Usage Decision Was Recorded | ||
23 | VAENAME | QVAENAME | QAENDERER | CHAR | 12 | 0 | Person who Changed the Usage Decision | ||
24 | VAEDATUM | QVAEDATUM | DATUM | DATS | 8 | 0 | Change Date of Usage Decision | ||
25 | VEZEITAEN | QVEZEITAEN | QZEIT | TIMS | 6 | 0 | Time when Usage Decision Changed | ||
26 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | TMCB | |
27 | TEILLOS | QTLOS | QTLOS | NUMC | 6 | 0 | Partial lot number | QALT | |
28 | VORGLFNR | QLFNKN | KNTNR | NUMC | 8 | 0 | Current Node Number from Order Counter APLZL | ||
29 | .INCLUDE | 0 | 0 | Additional structure | |||||
30 | QKZDEF | QQKZDEF | QQKZDEF | CHAR | 2 | 0 | Definition of Quality Score Classes | * | |
31 | OBGRKL_A | QOBGRKL_A | QKENNZAHL | DEC | 3 | 0 | Upper Limit of Quality Score Class A | ||
32 | UNGRKL_A | QUNGRKL_A | QKENNZAHL | DEC | 3 | 0 | Lower Limit of Quality Score Class A | ||
33 | OBGRKL_B | QOBGRKL_B | QKENNZAHL | DEC | 3 | 0 | Upper Limit of Quality Score Class B | ||
34 | UNGRKL_B | QUNGRKL_B | QKENNZAHL | DEC | 3 | 0 | Lower Limit of Quality Score Class B | ||
35 | OBGRKL_C | QOBGRKL_C | QKENNZAHL | DEC | 3 | 0 | Upper Limit of Quality Score Class C | ||
36 | UNGRKL_C | QUNGRKL_C | QKENNZAHL | DEC | 3 | 0 | Lower Limit of Quality Score Class C | ||
37 | OBGRKL_D | QOBGRKL_D | QKENNZAHL | DEC | 3 | 0 | Upper Limit of Quality Score Class D | ||
38 | UNGRKL_D | QUNGRKL_D | QKENNZAHL | DEC | 3 | 0 | Lower Limit of Quality Score Class D | ||
39 | OBGRKL_E | QOBGRKL_E | QKENNZAHL | DEC | 3 | 0 | Upper Limit of Quality Score Class E | ||
40 | UNGRKL_E | QUNGRKL_E | QKENNZAHL | DEC | 3 | 0 | Lower Limit of Quality Score Class E | ||
41 | QKZ2 | QQKZ2 | QSTATWERT | FLTP | 16 | 16 | Quality Score Squared | ||
42 | DLZEIT | QDLZEIT | QSTATWERT | FLTP | 16 | 16 | Lead Time in Days | ||
43 | DLZEIT2 | QDLZT2 | QSTATWERT | FLTP | 16 | 16 | Lead Time Squared | ||
44 | EINHTAG | QEINHTAG | MEINS | UNIT | 3 | 0 | Lead Time Unit (Day) | * | |
45 | .INCLUDE | 0 | 0 | User structure: usage decision | |||||
46 | UDUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCQAVEB | MANDANT | T000 | MANDT | KEY | 1 | CN |
2 | MCQAVEB | PRUEFLOS | QALS | PRUEFLOS | KEY | 1 | CN |
3 | MCQAVEB | STAFO | TMCB | STAFO | REF | C | CN |
4 | MCQAVEB | TEILLOS | QALT | TEILLOS | REF | C | C |
5 | MCQAVEB | VAUSWAHLMG | QPAM | AUSWAHLMGE | REF | 1 | CN |
6 | MCQAVEB | VCODE | QPCD | CODE | REF | 1 | CN |
7 | MCQAVEB | VCODEGRP | QPGR | CODEGRUPPE | REF | 1 | CN |
8 | MCQAVEB | VFOLGEAKTI | TQ07 | FOLGEAKTI | REF | C | CN |
9 | MCQAVEB | VKATART | TQ15 | KATALOGART | |||
10 | MCQAVEB | VWERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20041209 |
SAP Release Created in | 470 |