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
L Usage decision for inspection lot
T Usage decision for partial lot
K Usage decision for interval
E Usage decision for single unit
1 Task for the notification
O For Operation Completion
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
NULL Not valuated
A Accepted (OK)
R Rejected (not OK)
DBEWERTUNG Dynamic Modif. Valuation According to Worst Case Principle QDBEWERT CHAR 1 0
NULL Not valuated
A Accepted (OK)
R Rejected (not OK)
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
NULL Indicator is not set
X Indicator is set
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