SAP Table MCQAVE
Usage decision: interface to QIS
MCQAVE (Usage decision: interface to QIS) 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 MCQAVE to other SAP tables.
MCQAVE table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDANT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
PRUEFLOS | Inspection Lot Number | QPLOS | QALS | NUMC | 12 | 0 | ||||||||||||||
KZART | Inspection Lot, Partial Lot, Single Unit, Interval | QKZART | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
ZAEHLER | Counter for Usage Decision | QVEZAEHLER | CHAR | 6 | 0 | |||||||||||||||
VKATART | Catalog | QKATART | TQ15 | CHAR | 1 | 0 | ||||||||||||||
VWERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||
VAUSWAHLMG | Selected Set of the Usage Decision | QVMENGE | QPAM | CHAR | 8 | 0 | ||||||||||||||
VCODEGRP | Code Group of the Usage Decision | QVGRUPPE | QPGR | CHAR | 8 | 0 | ||||||||||||||
VCODE | Usage Decision Code | QVCODE | QPCD | CHAR | 4 | 0 | ||||||||||||||
VERSIONAM | Version Number of the Selected Set Record | QVERSVE | CHAR | 6 | 0 | |||||||||||||||
VERSIONCD | Version Number of the Code Record | QVERSNRCD | CHAR | 6 | 0 | |||||||||||||||
VBEWERTUNG | Code Valuation | QBEWERTUNG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
DBEWERTUNG | Dynamic Modif. Valuation According to Worst Case Principle | QDBEWERT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
VFOLGEAKTI | Follow-Up Action | QFOLGEAKTI | TQ07 | CHAR | 8 | 0 | ||||||||||||||
QKENNZAHL | Quality Score | QKENNZAHL | DEC | 3 | 0 | |||||||||||||||
LTEXTKZ | Long Text for Usage Decision | QLTEXTAVE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
VNAME | Person who Made the Usage Decision | QVNAME | CHAR | 12 | 0 | |||||||||||||||
VDATUM | Date of Code Used for Usage Decision | QVEDATUM | DATS | 8 | 0 | |||||||||||||||
VEZEITERF | Time when Usage Decision Was Recorded | QVEZEITERF | TIMS | 6 | 0 | |||||||||||||||
VAENAME | Person who Changed the Usage Decision | QVAENAME | CHAR | 12 | 0 | |||||||||||||||
VAEDATUM | Change Date of Usage Decision | QVAEDATUM | DATS | 8 | 0 | |||||||||||||||
VEZEITAEN | Time when Usage Decision Changed | QVEZEITAEN | TIMS | 6 | 0 | |||||||||||||||
STAFO | Update group for statistics update | STAFO | TMCB | CHAR | 6 | 0 | ||||||||||||||
TEILLOS | Partial lot number | QTLOS | QALT | NUMC | 6 | 0 | ||||||||||||||
VORGLFNR | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | 0 | |||||||||||||||
QKZDEF | Definition of Quality Score Classes | QQKZDEF | CHAR | 2 | 0 | |||||||||||||||
OBGRKL_A | Upper Limit of Quality Score Class A | QOBGRKL_A | DEC | 3 | 0 | |||||||||||||||
UNGRKL_A | Lower Limit of Quality Score Class A | QUNGRKL_A | DEC | 3 | 0 | |||||||||||||||
OBGRKL_B | Upper Limit of Quality Score Class B | QOBGRKL_B | DEC | 3 | 0 | |||||||||||||||
UNGRKL_B | Lower Limit of Quality Score Class B | QUNGRKL_B | DEC | 3 | 0 | |||||||||||||||
OBGRKL_C | Upper Limit of Quality Score Class C | QOBGRKL_C | DEC | 3 | 0 | |||||||||||||||
UNGRKL_C | Lower Limit of Quality Score Class C | QUNGRKL_C | DEC | 3 | 0 | |||||||||||||||
OBGRKL_D | Upper Limit of Quality Score Class D | QOBGRKL_D | DEC | 3 | 0 | |||||||||||||||
UNGRKL_D | Lower Limit of Quality Score Class D | QUNGRKL_D | DEC | 3 | 0 | |||||||||||||||
OBGRKL_E | Upper Limit of Quality Score Class E | QOBGRKL_E | DEC | 3 | 0 | |||||||||||||||
UNGRKL_E | Lower Limit of Quality Score Class E | QUNGRKL_E | DEC | 3 | 0 | |||||||||||||||
QKZ2 | Quality Score Squared | QQKZ2 | FLTP | 16 | 16 | |||||||||||||||
DLZEIT | Lead Time in Days | QDLZEIT | FLTP | 16 | 16 | |||||||||||||||
DLZEIT2 | Lead Time Squared | QDLZT2 | FLTP | 16 | 16 | |||||||||||||||
EINHTAG | Lead Time Unit (Day) | QEINHTAG | UNIT | 3 | 0 | |||||||||||||||
UDUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 |
MCQAVE foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
MCQAVE | MANDANT | MCQAVE | MANDANT | T000 | Clients | MANDT |
MCQAVE | PRUEFLOS | MCQAVE | MANDANT | QALS | Inspection lot record | MANDANT |
MCQAVE | PRUEFLOS | MCQAVE | PRUEFLOS | QALS | Inspection lot record | PRUEFLOS |
MCQAVE | STAFO | MCQAVE | MANDANT | TMCB | Update groups | MANDT |
MCQAVE | STAFO | MCQAVE | STAFO | TMCB | Update groups | STAFO |
MCQAVE | TEILLOS | MCQAVE | MANDANT | QALT | Partial lot | MANDANT |
MCQAVE | TEILLOS | MCQAVE | PRUEFLOS | QALT | Partial lot | PRUEFLOS |
MCQAVE | TEILLOS | MCQAVE | TEILLOS | QALT | Partial lot | TEILLOS |
MCQAVE | VAUSWAHLMG | MCQAVE | VAUSWAHLMG | QPAM | Inspection catalog selected sets | AUSWAHLMGE |
MCQAVE | VAUSWAHLMG | MCQAVE | MANDANT | QPAM | Inspection catalog selected sets | MANDT |
MCQAVE | VAUSWAHLMG | MCQAVE | VWERKS | QPAM | Inspection catalog selected sets | WERKS |
MCQAVE | VAUSWAHLMG | MCQAVE | VKATART | QPAM | Inspection catalog selected sets | KATALOGART |
MCQAVE | VCODE | MCQAVE | VERSIONCD | QPCD | Inspection catalog codes | VERSION |
MCQAVE | VCODE | MCQAVE | MANDANT | QPCD | Inspection catalog codes | MANDT |
MCQAVE | VCODE | MCQAVE | VKATART | QPCD | Inspection catalog codes | KATALOGART |
MCQAVE | VCODE | MCQAVE | VCODEGRP | QPCD | Inspection catalog codes | CODEGRUPPE |
MCQAVE | VCODE | MCQAVE | VCODE | QPCD | Inspection catalog codes | CODE |
MCQAVE | VCODEGRP | MCQAVE | MANDANT | QPGR | Inspection catalog code groups | MANDT |
MCQAVE | VCODEGRP | MCQAVE | VKATART | QPGR | Inspection catalog code groups | KATALOGART |
MCQAVE | VCODEGRP | MCQAVE | VCODEGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
MCQAVE | VFOLGEAKTI | MCQAVE | MANDANT | TQ07 | Follow-Up Action for Usage Decision of Inspection Lot | MANDT |
MCQAVE | VFOLGEAKTI | MCQAVE | VFOLGEAKTI | TQ07 | Follow-Up Action for Usage Decision of Inspection Lot | FOLGEAKTI |
MCQAVE | VKATART | MCQAVE | MANDANT | TQ15 | Inspection catalog type index | MANDT |
MCQAVE | VKATART | MCQAVE | VKATART | TQ15 | Inspection catalog type index | KATALOGART |
MCQAVE | VWERKS | MCQAVE | MANDANT | T001W | Plants/Branches | MANDT |
MCQAVE | VWERKS | MCQAVE | VWERKS | T001W | Plants/Branches | WERKS |