SAP Table RQEVA
QM: Usage Decision and Stock Postings
RQEVA (QM: Usage Decision and Stock Postings) 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 RQEVA to other SAP tables.
RQEVA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ANZMODUS | Display Mode for Inspection Characteristics | QANZMODUS | TQ78 | CHAR | 4 | 0 | ||||||||
| STAT14 | Completion of Short-Term Inspection | QSTAT14 | CHAR | 1 | 0 |
Possible values
|
||||||||
| STAT16 | All Inspections Completed | QSTAT16 | CHAR | 1 | 0 |
Possible values
|
||||||||
| STAT19 | Documentation Required for Inspection Lot | QSTAT19 | CHAR | 1 | 0 |
Possible values
|
||||||||
| STAT_BERF | Quantity Update | QMENGU | CHAR | 1 | 0 |
Possible values
|
||||||||
| VKATART | Catalog | QKATART | TQ15 | CHAR | 1 | 0 | ||||||||
| VAUSWAHLMG | Selected Set of the Usage Decision | QVMENGE | QPAM | CHAR | 8 | 0 | ||||||||
| VWERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||
| VERSIONAM | Version Number of the Selected Set Record | QVERSVE | CHAR | 6 | 0 | |||||||||
| VCODEGRP | Code Group of the Usage Decision | QVGRUPPE | QPGR | CHAR | 8 | 0 | ||||||||
| VCODE | Usage Decision Code | QVCODE | QPCD | CHAR | 4 | 0 | ||||||||
| VERSIONCD | Version Number of the Code Record | QVERSNRCD | CHAR | 6 | 0 | |||||||||
| VFOLGEAKTI | Follow-Up Action | QFOLGEAKT | TQ07 | CHAR | 8 | 0 | ||||||||
| QKENNZAHL | Quality Score | QKENNZAHL | DEC | 3 | 0 | |||||||||
| ISTMENGE_F | Actual Lot Quantity | QLMENGISTF | QUAN | 13 | 3 | |||||||||
| GEBUCHMG_F | Quantity Already Posted | QGEBUCHMGF | QUAN | 13 | 3 | |||||||||
| ZUBUCHMG_F | Quantity that Is Still To Be Posted at the Usage Decision | QZUBUCHMGF | QUAN | 13 | 3 | |||||||||
| ANTEIL_C | Estimated Fraction of Nonconforming Units | QAUSANTLC | CHAR | 16 | 0 | |||||||||
| ANTEILMK_C | Estimated Fraction of Nonconforming Units | QANTEILC | CHAR | 16 | 0 | |||||||||
| VMENGE01 | Quantity that Is To Be Posted to Unrestricted-Use Stock | QVMENGE01 | QUAN | 13 | 3 | |||||||||
| VMENGE02 | Quantity that Is To Be Posted to Scrap | QVMENGE02 | QUAN | 13 | 3 | |||||||||
| VMENGE03 | Quantity To Be Posted to Sample Usage | QVMENGE03 | QUAN | 13 | 3 | |||||||||
| VMENGE04 | Quantity that Is Posted to Blocked Stock | QVMENGE04 | QUAN | 13 | 3 | |||||||||
| VMENGE05 | Quantity that Is Posted to Reserve Samples | QVMENGE05 | QUAN | 13 | 3 | |||||||||
| VMENGE06 | Quantity that Is Posted to a New Material | QVMENGE06 | QUAN | 13 | 3 | |||||||||
| VMENGE07 | Quantity that Is To Be Returned to Vendor | QVMENGE07 | QUAN | 13 | 3 | |||||||||
| VMENGE08 | Quantity that Is To Be Posted as Other Quantity | QVMENGE08 | QUAN | 13 | 3 | |||||||||
| VMENGE09 | Quantity that Is To Be Posted as Other Quantity (2) | QVMENGE09 | QUAN | 13 | 3 | |||||||||
| QLGO_VM01 | Storage Location for Quantity Posting to Unrestricted Stock | QLGO_VM01 | T001L | CHAR | 4 | 0 | ||||||||
| QLGO_VM03 | Storage Location for Quantity Posting to Sample | QLGO_VM03 | T001L | CHAR | 4 | 0 | ||||||||
| QLGO_VM04 | Storage Location for Quantity Posting to Blocked Stock | QLGO_VM04 | T001L | CHAR | 4 | 0 | ||||||||
| QLGO_VM06 | Storage Location for Quantity Posting to Different Material | QLGO_VM06 | T001L | CHAR | 4 | 0 | ||||||||
| QLGO_VM08 | Storage Location for Quantity Posting to Other Stock | QLGO_VM08 | T001L | CHAR | 4 | 0 | ||||||||
| KZDUNKEL | Window for Stock Postings Processed in the Background | QVKZDUNKEL | CHAR | 1 | 0 |
Possible values
|
||||||||
| NEU_MAT | Transfer Posting to Another Material Number | QNEU_MAT | MARA | CHAR | 18 | 0 | ||||||||
| NEU_CHARGE | Batch Number for Material Transfer Posting | QNEU_CHARG | MCH1 | CHAR | 10 | 0 | ||||||||
| NEU_UL_Z_F | New Batch Status Unrestricted Use | QZUS_NEU_F | CHAR | 1 | 0 |
Possible values
|
||||||||
| NEU_UL_Z_N | New Batch Status Restricted | QZUS_NEU_N | CHAR | 1 | 0 |
Possible values
|
||||||||
| PROT_ZEILE | Text Line for Log Tables | QPROT_LINE | CHAR | 80 | 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
|
||||||||
| ANZ_QMEL | Number of Quality Notifications for an Inspection Lot | QANZ_QMEL | INT2 | 5 | 0 | |||||||||
| ANZ_FE_POS | Number of Defect Items for Inspection Lot | QANZ_FEHL | INT2 | 5 | 0 | |||||||||
| ANZ_FEHLER | Total Number of Defects Recorded for an Inspection Lot | QANZ_FEHLR | INT4 | 10 | 0 | |||||||||
| NOMATINPUT | No Material/Batch Can Be Entered | QNOMATINPT | CHAR | 1 | 0 |
Possible values
|
||||||||
| INSMK | Quantity Is or Was in Inspection Stock | QVINSMK | CHAR | 1 | 0 |
Possible values
|
||||||||
| INFO_LINE | Text Line for Special Information about Inspection Lot | QINFO_LINE | CHAR | 132 | 0 | |||||||||
| STATUSTEXT | System Status | CO_STTXT | CHAR | 40 | 0 | |||||||||
| ANW_STATUS | Field displaying user status | CO_ASTTX | CHAR | 40 | 0 | |||||||||
| KZ_ANWSTAT | User status active | CO_ASTEX | CHAR | 1 | 0 |
Possible values
|
||||||||
| LOS_AKTUEL | Number of Current Inspection Lot (GET Parameter) | QLOS_LATE | QALS | NUMC | 12 | 0 | ||||||||
| CODE_GRUP | Combined Text for Code Group and Code | QCODE_GRUP | CHAR | 80 | 0 | |||||||||
| BB_FREI_N | Posting to Unrestricted-Use Stock/Restricted-Use Stock | QDYN_TEXT | CHAR | 40 | 0 | |||||||||
| BB_SPERR | Qty Posted to Blocked Stock or Remains in GR Blocked Stock | QDYN_TEXT4 | CHAR | 40 | 0 | |||||||||
| CHARG_ZUST | Batch in Restricted-Use Stock | DZUSTD | CHAR | 1 | 0 |
Possible values
|
||||||||
| GRUND_LIEF | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| ZUS_ALT_F | Current Batch Status | QZUS_ALT_F | CHAR | 1 | 0 |
Possible values
|
||||||||
| ZUS_ALT_N | Current Batch Status Not Released | QZUS_ALT_N | CHAR | 1 | 0 |
Possible values
|
||||||||
| ZUS_NEU_F | New Batch Status Unrestricted Use | QZUS_NEU_F | CHAR | 1 | 0 |
Possible values
|
||||||||
| ZUS_NEU_N | New Batch Status Restricted | QZUS_NEU_N | CHAR | 1 | 0 |
Possible values
|
||||||||
| KZONLYSKIP | Include Skipped Lots Only | QKZONLYSKP | CHAR | 1 | 0 |
Possible values
|
||||||||
| KZLZMKBER | Include Long-Term Characteristics in Selection | QKZLZMKBER | CHAR | 1 | 0 |
Possible values
|
||||||||
| KZCHGZVAKT | Indicator: batch status management active | CHAZV | CHAR | 1 | 0 |
Possible values
|
||||||||
| GRUND | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 | 0 | ||||||||
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 | 0 | ||||||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | 0 | |||||||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||||
| BKTXT | Document Header Text | BKTXT | CHAR | 25 | 0 | |||||||||
| SGTXT01 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| GRUND01 | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||||
| MHD_01 | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8 | 0 | |||||||||
| SGTXT02 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| GRUND02 | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| KOSTL02 | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||||
| SGTXT03 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| GRUND03 | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| KOSTL03 | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||||
| SGTXT04 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| GRUND04 | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| SGTXT05 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| GRUND05 | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| SGTXT06 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| GRUND06 | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| SGTXT07 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| SGTXT08 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| GRUND08 | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| SGTXT09 | Item Text | SGTXT | CHAR | 50 | 0 | |||||||||
| GRUND09 | Reason for Movement | MB_GRBEW | T157D | NUMC | 4 | 0 | ||||||||
| POSTEXT | Text Line | TEXT72 | CHAR | 72 | 0 | |||||||||
| KOSTRCHKRS | Controlling Area for Inspection Lot Cost Centers | QKOKRS | TKA01 | CHAR | 4 | 0 | ||||||||
| ICON_LTEXT | Carrier field for icons | ICON_TEXT | CHAR | 132 | 0 | |||||||||
| OFFEN_PKT | Number of Outstanding Inspection Points | QOFFEN_PKT | NUMC | 4 | 0 | |||||||||
| /CWM/ZUBUCHMG_F | Quantity to be Posted in PUoM | /CWM/QLMENGEZUB | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE01 | Quantity that Is To Be Posted to Unrestricted-Use Stock | QVMENGE01 | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE02 | Quantity that Is To Be Posted to Scrap | QVMENGE02 | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE03 | Quantity To Be Posted to Sample Usage | QVMENGE03 | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE04 | Quantity that Is Posted to Blocked Stock | QVMENGE04 | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE05 | Quantity that Is Posted to Reserve Samples | QVMENGE05 | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE06 | Quantity that Is Posted to a New Material | QVMENGE06 | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE07 | Quantity that Is To Be Returned to Vendor | QVMENGE07 | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE08 | Quantity that Is To Be Posted as Other Quantity | QVMENGE08 | QUAN | 13 | 3 | |||||||||
| /CWM/VMENGE09 | Quantity that Is To Be Posted as Other Quantity (2) | QVMENGE09 | QUAN | 13 | 3 | |||||||||
| /CWM/MENGEINH | Base Unit of Measure for The Inspection Lot Quantity | QLOSMENGEH | UNIT | 3 | 0 | |||||||||
| /CWM/MENGEINH2Q | Parallel Unit of Measure | /CWM/MEINS | UNIT | 3 | 0 | |||||||||
RQEVA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| RQEVA | ANZMODUS | RQEVA | ANZMODUS | TQ78 | Status-dependent processing table for insp. characteristics | MODUS |
| RQEVA | ANZMODUS | SYST | MANDT | TQ78 | Status-dependent processing table for insp. characteristics | MANDT |
| RQEVA | ANZMODUS | SYST | TCODE | TQ78 | Status-dependent processing table for insp. characteristics | TCODE |
| RQEVA | EBELN | QALS | MANDANT | EKKO | Purchasing Document Header | MANDT |
| RQEVA | EBELN | RQEVA | EBELN | EKKO | Purchasing Document Header | EBELN |
| RQEVA | EBELP | RQEVA | EBELP | EKPO | Purchasing Document Item | EBELP |
| RQEVA | EBELP | QALS | MANDANT | EKPO | Purchasing Document Item | MANDT |
| RQEVA | EBELP | RQEVA | EBELN | EKPO | Purchasing Document Item | EBELN |
| RQEVA | GRUND | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND | RQEVA | GRUND | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND | SYST | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND01 | SY | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND01 | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND01 | RQEVA | GRUND01 | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND02 | SY | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND02 | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND02 | RQEVA | GRUND02 | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND03 | RQEVA | GRUND03 | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND03 | SY | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND03 | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND04 | SY | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND04 | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND04 | RQEVA | GRUND04 | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND05 | RQEVA | GRUND05 | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND05 | SY | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND05 | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND06 | SY | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND06 | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND06 | RQEVA | GRUND06 | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND08 | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND08 | RQEVA | GRUND08 | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND08 | SY | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND09 | SY | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND09 | T156 | BWART | T157D | Reason for Movement | BWART |
| RQEVA | GRUND09 | RQEVA | GRUND09 | T157D | Reason for Movement | GRUND |
| RQEVA | GRUND_LIEF | SYST | MANDT | T157D | Reason for Movement | MANDT |
| RQEVA | GRUND_LIEF | '122' | T157D | Reason for Movement | BWART | |
| RQEVA | GRUND_LIEF | RQEVA | GRUND_LIEF | T157D | Reason for Movement | GRUND |
| RQEVA | KOSTL02 | RQEVA | KOSTL02 | CSKS | Cost Center Master Data | KOSTL |
| RQEVA | KOSTL02 | * | CSKS | Cost Center Master Data | DATBI | |
| RQEVA | KOSTL02 | SY | MANDT | CSKS | Cost Center Master Data | MANDT |
| RQEVA | KOSTL02 | RQEVA | KOSTRCHKRS | CSKS | Cost Center Master Data | KOKRS |
| RQEVA | KOSTL03 | * | CSKS | Cost Center Master Data | DATBI | |
| RQEVA | KOSTL03 | SY | MANDT | CSKS | Cost Center Master Data | MANDT |
| RQEVA | KOSTL03 | RQEVA | KOSTRCHKRS | CSKS | Cost Center Master Data | KOKRS |
| RQEVA | KOSTL03 | RQEVA | KOSTL03 | CSKS | Cost Center Master Data | KOSTL |
| RQEVA | KOSTRCHKRS | SY | MANDT | TKA01 | Controlling Areas | MANDT |
| RQEVA | KOSTRCHKRS | RQEVA | KOSTRCHKRS | TKA01 | Controlling Areas | KOKRS |
| RQEVA | LOS_AKTUEL | SYST | MANDT | QALS | Inspection lot record | MANDANT |
| RQEVA | LOS_AKTUEL | RQEVA | LOS_AKTUEL | QALS | Inspection lot record | PRUEFLOS |
| RQEVA | NEU_CHARGE | SYST | MANDT | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| RQEVA | NEU_CHARGE | RQEVA | NEU_MAT | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
| RQEVA | NEU_CHARGE | RQEVA | NEU_CHARGE | MCH1 | Batches (if Batch Management Cross-Plant) | CHARG |
| RQEVA | NEU_MAT | SYST | MANDT | MARA | General Material Data | MANDT |
| RQEVA | NEU_MAT | RQEVA | NEU_MAT | MARA | General Material Data | MATNR |
| RQEVA | QLGO_VM01 | RQEVA | QLGO_VM01 | T001L | Storage Locations | LGORT |
| RQEVA | QLGO_VM01 | SYST | MANDT | T001L | Storage Locations | MANDT |
| RQEVA | QLGO_VM01 | QALS | WERKVORG | T001L | Storage Locations | WERKS |
| RQEVA | QLGO_VM03 | SYST | MANDT | T001L | Storage Locations | MANDT |
| RQEVA | QLGO_VM03 | QALS | WERKVORG | T001L | Storage Locations | WERKS |
| RQEVA | QLGO_VM03 | RQEVA | QLGO_VM03 | T001L | Storage Locations | LGORT |
| RQEVA | QLGO_VM04 | QALS | WERKVORG | T001L | Storage Locations | WERKS |
| RQEVA | QLGO_VM04 | RQEVA | QLGO_VM04 | T001L | Storage Locations | LGORT |
| RQEVA | QLGO_VM04 | SYST | MANDT | T001L | Storage Locations | MANDT |
| RQEVA | QLGO_VM06 | SYST | MANDT | T001L | Storage Locations | MANDT |
| RQEVA | QLGO_VM06 | QALS | WERKVORG | T001L | Storage Locations | WERKS |
| RQEVA | QLGO_VM06 | RQEVA | QLGO_VM06 | T001L | Storage Locations | LGORT |
| RQEVA | QLGO_VM08 | SYST | MANDT | T001L | Storage Locations | MANDT |
| RQEVA | QLGO_VM08 | QALS | WERKVORG | T001L | Storage Locations | WERKS |
| RQEVA | QLGO_VM08 | RQEVA | QLGO_VM08 | T001L | Storage Locations | LGORT |
| RQEVA | VAUSWAHLMG | RQEVA | VAUSWAHLMG | QPAM | Inspection catalog selected sets | AUSWAHLMGE |
| RQEVA | VAUSWAHLMG | SYST | MANDT | QPAM | Inspection catalog selected sets | MANDT |
| RQEVA | VAUSWAHLMG | RQEVA | VWERKS | QPAM | Inspection catalog selected sets | WERKS |
| RQEVA | VAUSWAHLMG | RQEVA | VKATART | QPAM | Inspection catalog selected sets | KATALOGART |
| RQEVA | VCODE | RQEVA | VERSIONCD | QPCD | Inspection catalog codes | VERSION |
| RQEVA | VCODE | SYST | MANDT | QPCD | Inspection catalog codes | MANDT |
| RQEVA | VCODE | RQEVA | VKATART | QPCD | Inspection catalog codes | KATALOGART |
| RQEVA | VCODE | RQEVA | VCODEGRP | QPCD | Inspection catalog codes | CODEGRUPPE |
| RQEVA | VCODE | RQEVA | VCODE | QPCD | Inspection catalog codes | CODE |
| RQEVA | VCODEGRP | SYST | MANDT | QPGR | Inspection catalog code groups | MANDT |
| RQEVA | VCODEGRP | RQEVA | VKATART | QPGR | Inspection catalog code groups | KATALOGART |
| RQEVA | VCODEGRP | RQEVA | VCODEGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
| RQEVA | VFOLGEAKTI | RQEVA | VFOLGEAKTI | TQ07 | Follow-Up Action for Usage Decision of Inspection Lot | FOLGEAKTI |
| RQEVA | VFOLGEAKTI | SYST | MANDT | TQ07 | Follow-Up Action for Usage Decision of Inspection Lot | MANDT |
| RQEVA | VKATART | SYST | MANDT | TQ15 | Inspection catalog type index | MANDT |
| RQEVA | VKATART | RQEVA | VKATART | TQ15 | Inspection catalog type index | KATALOGART |
| RQEVA | VWERKS | SYST | MANDT | T001W | Plants/Branches | MANDT |
| RQEVA | VWERKS | RQEVA | VWERKS | T001W | Plants/Branches | WERKS |
