SAP QALS_QAVE_EXT Table in S/4 HANA - Structure for RQEEAL10 + Custom fields from QALS and QAVE
QALS_QAVE_EXT is a standard SAP Table which is used to store Structure for RQEEAL10 + Custom fields from QALS and QAVE data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP QALS_QAVE_EXT table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: QALS_QAVE_EXT
QALS_QAVE_EXT table structure field list
Below is the full QALS_QAVE_EXT field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12(0) | QALS | QPLOS | QLS | QALS | PRUEFLOS | |
STTXT | System Status | CO_STTXT | CHAR | 40(0) | CHAR40 | |||||
USTXT | Field displaying user status | CO_ASTTX | CHAR | 40(0) | CHAR40 | |||||
WERK | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
ART | Inspection Type | QPART | CHAR | 8(0) | Assigned to domain | QPART | QLA | |||
HERKUNFT | Inspection Lot Origin | QHERK | CHAR | 2(0) | Assigned to domain | QHERK | QHK | |||
OBJNR | Object number | J_OBJNR | CHAR | 22(0) | Assigned to domain | J_OBJNR | ONR | |||
OBTYP | Object Category | J_OBTYP | CHAR | 3(0) | Assigned to domain | J_OBTYP | ||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10(0) | AUFPL | |||||
KTEXTMAT | Short Text for Inspection Object | QKTEXTOBJ | CHAR | 40(0) | QKURZTEXT | |||||
STSMA | Status Profile | J_STSMA | CHAR | 8(0) | Assigned to domain | J_STSMA | ||||
QMATAUTH | Material Authorization Group for Activities in QM | QMATAUTH | CHAR | 6(0) | Assigned to domain | QMATAUTH | ||||
STAT11 | GR Blocked Stock | KZWES | CHAR | 1(0) | KZWES | |||||
INSMK | Quantity Is or Was in Inspection Stock | QVINSMK | CHAR | 1(0) | QKZ | |||||
STAT02 | Partial Lots Exist | QKZQALT | CHAR | 1(0) | QKZ | |||||
STAT07 | Inspection with Inspection Points | QKZFERTPRF | CHAR | 1(0) | QKZ | |||||
STAT06 | Record Appraisal Costs in Individual QM Order | QKZPRFKOST | CHAR | 1(0) | QKZ | |||||
STAT09 | Source Inspection | QABNAHMPRF | CHAR | 1(0) | BSTYP | |||||
STAT19 | Documentation Required for Inspection Lot | QSTAT19 | CHAR | 1(0) | QKZ | |||||
STAT23 | Inspection Lot Approval | QKZGENLOS | CHAR | 1(0) | QKZGENLOS | |||||
STAT24 | Digital Signature for Insp. Lot in Results Recording | SIG_IL_RES | CHAR | 1(0) | SIG_IL_RES | |||||
STAT25 | Digital Signature for Insp. Lot when Usage Decision Made | SIG_IL_USA | CHAR | 1(0) | SIG_IL_USA | |||||
KZSKIPLOT | Lot Skipped | QKZSKIPLOT | CHAR | 1(0) | QKZ | |||||
HPZ | 100% Inspection | QHPZ | CHAR | 1(0) | QKZ | |||||
DYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | QDYNHEAD | CHAR | 1(0) | Assigned to domain | QDYNHEAD | ||||
STPRVER | Sampling Procedure | QSTPRVER | CHAR | 8(0) | Assigned to domain | QSTPRVER | QSV | |||
ENSTEHDAT | Date of Lot Creation | QENTST | DATS | 8(0) | DATUM | |||||
ENTSTEZEIT | Time of Lot Creation | QENTSTZEIT | TIMS | 6(0) | QZEIT | |||||
ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12(0) | QAENDERER | |||||
ERSTELDAT | Date on Which Data Record Was Created | QDATUMERST | DATS | 8(0) | DATUM | |||||
ERSTELZEIT | Time of Lot Creation | QERSTEZEIT | TIMS | 6(0) | QZEIT | |||||
AENDERER | Name of User Who Last Changed Data Record | QAENDERER | CHAR | 12(0) | QAENDERER | |||||
AENDERDAT | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8(0) | DATUM | |||||
AENDERZEIT | Time of Lot Change | QAENDEZEIT | TIMS | 6(0) | QZEIT | |||||
PASTRTERM | Start Date of Inspection | QPRSTART | DATS | 8(0) | DATUM | |||||
PASTRZEIT | Inspection Start Time | QSTARTZEIT | TIMS | 6(0) | QZEIT | |||||
PAENDTERM | End Date of Inspection | QPRENDE | DATS | 8(0) | DATUM | |||||
PAENDZEIT | Inspection End Time | QENDEZEIT | TIMS | 6(0) | QZEIT | |||||
PLNTY | Task List Type | PLNTY | CHAR | 1(0) | PLNTY | PTY | H_TCA01 | PLNTY | ||
PLNNR | Key for Task List Group | PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
PPLVERW | Task list usage | PLN_VERWE | CHAR | 3(0) | PLN_VERWE | H_T411 | VERWE | |||
PLNAL | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
SLWBEZ | Identifier for Inspection Point Field Combination | QSLWBEZ | CHAR | 3(0) | Assigned to domain | QSLWBEZ | QBK | |||
STAT13 | Inspection Point Type | QPPKTTYP | CHAR | 1(0) | QPPKTTYP | |||||
PRBNAVERF | Sample-Drawing Procedure | QPRZIEHVER | CHAR | 8(0) | Assigned to domain | QPRZIEHVER | QPV | |||
PRBNAVV | Version No. of the Sample-Drawing Procedure | QVERSNPRZV | CHAR | 6(0) | ALPHA | QVERSNR | ||||
STAT12 | Confirmation Required for Sample Drawing | QKZQUIT | CHAR | 1(0) | QKZ | |||||
SELMATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
SELREVLV | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
SELWERK | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
SELLIFNR | Vendor's account number | ELIFN | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
SELHERST | Number of Manufacturer | QLIFNR | CHAR | 10(0) | Assigned to domain | ALPHA | LIFNR | LIF | ||
SELKUNNR | Account number of customer | EKUNN | CHAR | 10(0) | Assigned to domain | ALPHA | KUNNR | KUN | ||
SELPPLVERW | Task list usage | PLN_VERWE | CHAR | 3(0) | PLN_VERWE | H_T411 | VERWE | |||
GUELTIGAB | Valid-From Date | DATUV | DATS | 8(0) | DATUM | |||||
AUFNR | Order Number | AUFNR | CHAR | 12(0) | Assigned to domain | ALPHA | AUFNR | ANR | ||
VERID | Production Version | VERID | CHAR | 4(0) | Assigned to domain | VERID | VER | |||
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12(0) | Assigned to domain | ALPHA | SA_AUFNR | |||
KUNNR | Customer (Ship-To Party) | QKUNWE | CHAR | 10(0) | ALPHA | KUNNR | DEBI | KUNNR | ||
LIFNR | Vendor's account number | ELIFN | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10(0) | Assigned to domain | ALPHA | LIFNR | LIF | ||
EMATNR | Material number | EMATNR | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | MAT | ||
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
REVLV | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1(0) | XFELD | |||||
CHARG | Batch Number | CHARG_D | CHAR | 10(0) | Assigned to domain | CHARG | CHA | |||
LAGORTCHRG | Storage location | LGORT_D | CHAR | 4(0) | Assigned to domain | LGORT | LAG | |||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1(0) | Assigned to domain | SOBKZ | ||||
EKORG | Purchasing organization | EKORG | CHAR | 4(0) | Assigned to domain | EKORG | EKO | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | ALPHA | EBELN | BES | MEKK_C | EBELN | |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | Assigned to domain | EBELP | BSP | |||
ETENR | Delivery Schedule Line Counter | EETEN | NUMC | 4(0) | Assigned to domain | EETEN | ||||
BLART | Document type | BLART | CHAR | 2(0) | Assigned to domain | BLART | BAR | |||
MJAHR | Material Document Year | MJAHR | NUMC | 4(0) | GJAHR | GJAHR | MJA | |||
MBLNR | Number of Material Document | MBLNR | CHAR | 10(0) | ALPHA | BELNR | MBN | |||
ZEILE | Item in Material Document | MBLPO | NUMC | 4(0) | MBLPO | POS | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
BWART | Movement type (inventory management) | BWART | CHAR | 3(0) | Assigned to domain | BWART | BWA | |||
WERKVORG | Plant Where Stock for Inspection Lot Is Held | QWERKVORG | CHAR | 4(0) | Assigned to domain | WERKS | ||||
LAGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4(0) | Assigned to domain | LGORT | ||||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3(0) | Assigned to domain | LGNUM | LGN | |||
LGTYP | Storage Type | LGTYP | CHAR | 3(0) | LGTYP | LGT | H_T301 | LGTYP | ||
LGPLA | Storage Bin | LGPLA | CHAR | 10(0) | LGPLA | LGP | LAG1 | LGPLA | ||
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
LS_KDPOS | Item number in Sales Order | KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10(0) | ALPHA | VBELN | VL | |||
LS_POSNR | Delivery Item | POSNR_VL | NUMC | 6(0) | POSNR | |||||
LS_ABRVW | Delivery Category | QABRVW | CHAR | 3(0) | Assigned to domain | ABRVW | ||||
LS_ROUTE | Route | ROUTE | CHAR | 6(0) | Assigned to domain | ROUTE | ||||
LS_LLAND | Destination Country | LLAND | CHAR | 3(0) | Assigned to domain | LAND1 | VLL | |||
LS_KUNAG | Sold-To Party | KUNAG | CHAR | 10(0) | Assigned to domain | ALPHA | KUNNR | VAG | ||
LS_VKORG | Sales Organization | VKORG | CHAR | 4(0) | VKORG | VKO | C_VKORG | VKORG | ||
LS_KDMAT | Customer Material | KDMAT | CHAR | 35(0) | IDNEX | |||||
SPRACHE | Language Key | SPRAS | LANG | 1(0) | ISOLA | SPRAS | SPR | H_T002 | SPRAS | |
KTEXTLOS | Short Text | QKURZTEXT | CHAR | 40(0) | QKURZTEXT | |||||
ZUSMKZAEHL | Number of Characteristics Recorded Additionally | QZUSMKZHL | INT2 | 5(0) | INT2 | |||||
OFFENNLZMK | Number of Outstanding Short-Term Chars That Require Confirm. | QOFFENLZMK | INT2 | 5(0) | INT2 | |||||
OFFEN_LZMK | Number of Outstanding Long-Term Chars That Require Confirm. | QOFFELZMK | INT2 | 5(0) | INT2 | |||||
LOSMENGE | Inspection Lot Quantity | QLOSMENGE | QUAN | 13(3) | QMENGEPLOS | |||||
MENGENEINH | Base Unit of Measure for Inspection Lot Quantity | QLOSMENGEH | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
ANZGEB | QM - No. of Containers | QANZGEB | QUAN | 6(3) | QGEBPLOS | |||||
GEBEH | Lot Container | QGEBEH | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
GESSTICHPR | Inspection Sample Size | QGESTICH | QUAN | 13(3) | QMENGEPLOS | |||||
EINHPROBE | Base Unit of Measure for Sample Unit | QPROBEMGEH | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
DYNREGEL | Dynamic Modification Rule | QDYNREGEL | CHAR | 3(0) | Assigned to domain | QDYNREGEL | QDR | |||
STAT44 | Immediate Dynamic Modification at Inspection Lot Creation | QKZDYNAUT | CHAR | 1(0) | QKZ | |||||
PRSTUFE | Inspection Stage | QPRSTUFE | NUMC | 4(0) | Assigned to domain | QPRSTUFE | ||||
PRSCHAERFE | Inspection Severity | QPRSCHAERF | NUMC | 3(0) | Assigned to domain | QPRSCHAERF | ||||
LMENGE01 | Quantity Posted to Unrestricted-Use Stock | QLMENGE01F | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGE02 | Quantity Posted to Scrap | QLMENGE02F | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGE03 | Quantity Posted to Sample | QLMENGE03F | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGE04 | Quantity Posted to Blocked Stock | QLMENGE04F | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGE05 | Quantity Posted to Reserves | QLMENGE05F | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGE06 | Quantity Posted to Another Material | QLMENGE06F | QUAN | 13(3) | QMENGEPLOS | |||||
MATNRNEU | Material Number to Which the Quantity is Posted | QMATNRNEU | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | MAT | ||
CHARGNEU | Batch to Which Goods Are Transferred | QCHARGNEU | CHAR | 10(0) | Assigned to domain | CHARG | CHA | |||
LMENGE07 | Quantity Returned to Vendor | QLMENGE07F | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGE08 | Other Quantity Posted from Inspection Lot Stock | QLMENGE08F | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGE09 | Other Quantity (2) Posted from Inspection Lot Stock | QLMENGE09F | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGEZUB | Quantity That Must Be Posted | QLMENGEZUB | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGELZ | Sample Quantity for Long-Term Characteristics | QLMENGELZ | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGEPR | Quantity Actually Inspected | QLMENGEPR | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGEZER | Quantity Destroyed During Inspection | QLMENGEZER | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGEIST | Actual Lot Quantity | QLMENGEIST | QUAN | 13(3) | QMENGEPLOS | |||||
LMENGESCH | Defective Quantity in Inspected Quantity | QLMENGESCH | QUAN | 13(3) | QMENGEPLOS | |||||
ANTEIL | Share of Scrap in Inspection Lot | QAUSANTEIL | FLTP | 16(16) | QFLTP16 | |||||
STAT03 | Usage Decision Mode (UD Origin) | QMODUS_UD | CHAR | 1(0) | QMODUS_UD | |||||
QPMATLOS | Allowed Share of Scrap | QPMATLOS | FLTP | 16(16) | QPMATLOS | |||||
AUFNR_CO | Order Number for Recording Appraisal Costs | QAUFNR_CO | CHAR | 12(0) | Assigned to domain | ALPHA | AUFNR | ANR | ||
KZVBR | Consumption posting | KZVBR | CHAR | 1(0) | KZVBR | |||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1(0) | Assigned to domain | KNTTP | KNT | |||
STAT05 | Account Assignment Key: Inspection Lot | QKZQALSKNT | CHAR | 1(0) | QKZQALSKNT | |||||
KOSTL | Cost Center | KOSTL | CHAR | 10(0) | Assigned to domain | ALPHA | KOSTL | KOS | ||
AUFPS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4(0) | RSPOS | RPO | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12(0) | Assigned to domain | ALPHA | ANLN1 | AN1 | ||
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4(0) | Assigned to domain | ALPHA | ANLN2 | AN2 | ||
PS_PSP_PNR | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 8(0) | Assigned to domain | ABPSP | PS_POSNR | |||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12(0) | Assigned to domain | ALPHA | AUFNR | NET | ||
APLZL | Internal counter | CIM_COUNT | NUMC | 8(0) | CIM_COUNT | |||||
KDAUF | Sales order number of valuated sales order stock | MAT_KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10(0) | RKEOBJNR | |||||
PRCTR | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
GSBER | Business Area | GSBER | CHAR | 4(0) | Assigned to domain | GSBER | GSB | |||
KONTO | G/L Account Number | SAKNR | CHAR | 10(0) | ALPHA | SAKNR | SAK | C_SAKNR | SAKNR | |
KOKRS | Controlling Area | KOKRS | CHAR | 4(0) | Assigned to domain | CACCD | CAC | |||
BUKRS | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
SERNP | Serial Number Profile | SERAIL | CHAR | 4(0) | Assigned to domain | SERAIL | ||||
KONT_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8(0) | Assigned to domain | ABPSP | PS_POSNR | |||
KONT_KDAUF | Sales Order Number | KDAUF | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
KONT_KDPOS | Item number in Sales Order | KDPOS | NUMC | 6(0) | NUM06 | KPO | ||||
STAT16 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1(0) | CHAR1 | |||||
INSP_DOC_NUMBER | Inspection Document Number from External System | QINSP_DOC_NUMBER | CHAR | 30(0) | QPLEXT_INSP_DOC_NUMBER | |||||
PRIO_PUNKTE | Priority Points | QPRIO_PUNKTE | INT4 | 10(0) | QPLEXT_PRIOP | |||||
LICHN | Supplier Batch Number | LICHN | CHAR | 15(0) | LICHN | |||||
STAT36 | Lot Has Partial Lots Without Insp. Point and Insp. Specs | QTLS_WO_INSPPOINT | CHAR | 1(0) | QKZ | |||||
.INCLU--AP | 0(0) | |||||||||
/CWM/LOSMENGE | Inspection Lot Quantity in Parallel Unit of Measure | /CWM/LOSMENGE | QUAN | 13(3) | MENG13 | |||||
/CWM/MENGEINH2Q | Parallel Unit of Measure | /CWM/MEINS | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
VBEWERTUNG | Code Valuation | QBEWERTUNG | CHAR | 1(0) | QBEWERTUNG | |||||
QKENNZAHL | Quality Score | QKENNZAHL | DEC | 3(0) | QKENNZAHL | |||||
KZART | Inspection Lot, Partial Lot, Single Unit, Interval | QKZART | CHAR | 1(0) | QKZART | |||||
VKATART | Catalog | QKATART | CHAR | 1(0) | Assigned to domain | QKATART | QKT | |||
VAUSWAHLMG | Selected Set of the Usage Decision | QVMENGE | CHAR | 8(0) | Assigned to domain | QAUSWAHLMG | ||||
VCODEGRP | Code Group of the Usage Decision | QVGRUPPE | CHAR | 8(0) | Assigned to domain | QCODEGRP | CGP | |||
VCODE | Usage Decision Code | QVCODE | CHAR | 4(0) | Assigned to domain | QCODE | ||||
DBEWERTUNG | Valuation Rule | QBEWERT | CHAR | 2(0) | Assigned to domain | QKEY1 | ||||
VFOLGEAKTI | Follow-Up Action | QFOLGEAKTI | CHAR | 8(0) | Assigned to domain | QFOLGEAKTI | ||||
VNAME | Person Who Made the Usage Decision | QVNAME | CHAR | 12(0) | QAENDERER | |||||
VDATUM | Date when Usage Decision Was Recorded | QVEDATUM | DATS | 8(0) | DATUM | |||||
VEZEITERF | Time when Usage Decision Was Recorded | QVEZEITERF | TIMS | 6(0) | QZEIT | |||||
VAENAME | Person Who Changed the Usage Decision | QVAENAME | CHAR | 12(0) | QAENDERER | |||||
VAEDATUM | Change Date of Usage Decision | QVAEDATUM | DATS | 8(0) | DATUM | |||||
VEZEITAEN | Time when Usage Decision Changed | QVEZEITAEN | TIMS | 6(0) | QZEIT | |||||
DUMMY_QAVE_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY | |||||
DUMMY_QALS_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY | |||||
DUMMY_QAVE_INCL_EEW_TR | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY | |||||
DUMMY_QALS_INCL_EEW_TR | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY |
Search for further information about these or an SAP related objects