Menu

SAP Table QALS

Inspection lot record

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table QALS (Inspection lot record) is a standard table in SAP ERP. It belongs to the package QL.

Technical Information

Table QALS
Short Text Inspection lot record
Package QL
Table Type Transparent Table

Fields for Table QALS

Field Name Key Description Data Element Type Length Check Table
MANDANT Client MANDT CLNT 3 T000
PRUEFLOS Inspection Lot Number QPLOS NUMC 12
WERK Plant WERKS_D CHAR 4 T001W
ART Inspection Type QPART CHAR 8 TQ30
HERKUNFT Inspection Lot Origin QHERK CHAR 2 TQ31
OBJNR Object number J_OBJNR CHAR 22 ONR00
OBTYP Object Category J_OBTYP CHAR 3 TJ03
STSMA Status Profile J_STSMA CHAR 8 TJ20
QMATAUTH Material Authorization Group for Activities in QM QMATAUTH CHAR 6 TQ01B
STAT11 GR blocked stock KZWES CHAR 1
INSMK Quantity Is or Was in Inspection Stock QVINSMK CHAR 1
STAT01 Inspection Lot is Created Automatically QSTAT01 CHAR 1
STAT02 Partial Lots Exist QKZQALT CHAR 1
STAT04 Data Record Was Changed Using Customer Exit QUSER_EXIT CHAR 1
STAT06 Record Appraisal Costs in Individual QM Order QKZPRFKOST CHAR 1
STAT07 Inspection with Inspection Points QKZFERTPRF CHAR 1
STAT08 Automatic Usage Decision Planned QAUTO_VE CHAR 1
STAT09 Source Inspection QABNAHMPRF CHAR 1
STAT10 Inspection Specifications from Configuration QCONF CHAR 1
STAT14 Completion of Short-Term Inspection QSTAT14 CHAR 1
STAT16 Inspection Specifications from Batch Determination QCHARG CHAR 1
STAT18 Control of Inspection Lot Creation (Lot Summary) Q1WELOS CHAR 1
STAT19 Documentation Required for Inspection Lot QSTAT19 CHAR 1
STAT20 Inspection Plan Required QSTAT20 CHAR 1
STAT21 Enter Sample Manually QSTAT21 CHAR 1
STAT22 Inspect with Material Specification QSPEZUEBER CHAR 1
STAT23 Inspection Lot Approval QKZGENLOS CHAR 1
STAT24 Digital Signature for Insp. Lot in Results Recording SIG_IL_RES CHAR 1
STAT25 Digital Signature for Insp. Lot when Usage Decision Made SIG_IL_USA CHAR 1
STAT29 Digital Signature for Confirmation of Phys.-Sample Drawing SIG_IL_SDR CHAR 1
STAT26 Indicator: Approved batch record required XGCHP CHAR 1
STAT27 Inspection Lot is an R/2 Inspection Lot QSTAT27 CHAR 1
STAT28 Select Characteristics Manually QSTAT28 CHAR 1
STAT31 Trigger Sample Calculation Manually QSTAT31 CHAR 1
STAT34 Stock Postings Completed QSTAT34 CHAR 1
STAT35 Usage Decision Has Been Made QSTAT35 CHAR 1
STAT45 Material as Dynamic Modification Criterion QSTAT45 CHAR 1
STAT46 Vendor as Dynamic Modification Criterion QSTAT46 CHAR 1
STAT47 Manufacturer as Dynamic Modification Criterion QSTAT47 CHAR 1
STAT48 Customer as Dynamic Modification Criterion QSTAT48 CHAR 1
STAT49 Machine as Dynamic Modification Criterion QSTAT49 CHAR 1
STAT50 Project as Dynamic Modification Criterion QSTAT50 CHAR 1
KZSKIPLOT Lot Skipped QKZSKIPLOT CHAR 1
DYN Skips Allowed QDYN CHAR 1
HPZ 100% Inspection QHPZ CHAR 1
EIN Serial Number Management Possible QEINZ CHAR 1
ANZSN Number of serial numbers ANZSN INT4 10
KZDYNERF Dynamic Modification Is Carried Out QKZDYNERF CHAR 1
DYNHEAD Level at Which Dynamic Modification Parameters Are Defined QDYNHEAD CHAR 1 TQ39A
STPRVER Sampling Procedure QSTPRVER CHAR 8 QDSV
EXTNUM External Numbering of Units to be Inspected QEXTNUM CHAR 1 TQ12
STAFO Update group for statistics update STAFO CHAR 6 TMCB
STAT30 Origin of Inspection Lot Unit of Measure for LIS Interface QUNITORIGIN CHAR 1
QINFSTATUS QINF Status QINFSTATUS CHAR 8 *
ENSTEHDAT Date of Lot Creation QENTST DATS 8
ENTSTEZEIT Time of Lot Creation QENTSTZEIT TIMS 6
ERSTELLER Name of User Who Created the Data Record QERSTELLER CHAR 12
ERSTELDAT Date on Which the Data Record Was Created QDATUMERST DATS 8
ERSTELZEIT Time of Lot Creation QERSTEZEIT TIMS 6
AENDERER Name of User who Most Recently Changed the Data Record QAENDERER CHAR 12
AENDERDAT Date on Which Data Record Was Changed QDATUMAEND DATS 8
AENDERZEIT Time of Lot Change QAENDEZEIT TIMS 6
PASTRTERM Inspection Start Date QPRSTART DATS 8
PASTRZEIT Inspection Start Time QSTARTZEIT TIMS 6
PAENDTERM End Date of the Inspection QPRENDE DATS 8
PAENDZEIT Inspection End Time QENDEZEIT TIMS 6
PLNTY Task List Type PLNTY CHAR 1 TCA01
PLNNR Key for Task List Group PLNNR CHAR 8
PPLVERW Task list usage PLN_VERWE CHAR 3 T411
PLNAL Group Counter PLNAL CHAR 2
ZAEHL Internal counter CIM_COUNT NUMC 8
ZKRIZ Counter for additional criteria DZKRIZ NUMC 7
STAT15 Production Resource/Tool Saved for Insp. Lot QFHM_MODE CHAR 1
SLWBEZ Identification for the Inspection Point Field Combination QSLWBEZ CHAR 3 TQ79
STAT13 Inspection Point Type QPPKTTYP CHAR 1
PPKZTLZU Partial Lot Assignment in an Inspection During Production QPPKZTLZU CHAR 1
ZAEHL1 Internal counter CIM_COUNT NUMC 8
PRBNAVERF Sample-Drawing Procedure QPRZIEHVER CHAR 8 QPRVK
PRBNAVV Version No. of the Sample-Drawing Procedure QVERSNPRZV CHAR 6
STAT12 Confirmation Required for Physical-Sample Drawing QKZQUIT CHAR 1
SELMATNR Material Number MATNR CHAR 18 MARA
SELREVLV Revision Level REVLV CHAR 2
SELWERK Plant WERKS_D CHAR 4 T001W
SELLIFNR Vendor Account Number ELIFN CHAR 10 LFA1
STAT17 Manufacturer Part No. Processing Active QHERST CHAR 1
SELHERST Number of Manufacturer QLIFNR CHAR 10 LFA1
SELKUNNR Account Number of Customer EKUNN CHAR 10 KNA1
SELPPLVERW Task list usage PLN_VERWE CHAR 3 T411
GUELTIGAB Key Date for Selecting Records or Changing Task Lists QSTICHTAG DATS 8
AUFNR Order Number AUFNR CHAR 12 AUFK
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10
CUOBJ Configuration (internal object number) CUOBJ NUMC 18
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18
VERID Production Version VERID CHAR 4 MKAL
SA_AUFNR Run schedule header number SA_AUFNR CHAR 12 SAFK
KUNNR Customer (Ship-To Party) QKUNWE CHAR 10 KNA1
LIFNR Vendor Account Number ELIFN CHAR 10 LFA1
HERSTELLER Number of Manufacturer QLIFNR CHAR 10 LFA1
EMATNR Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 MARA
MATNR Material Number MATNR CHAR 18 MARA
REVLV Revision Level REVLV CHAR 2
XCHPF Batch management requirement indicator XCHPF CHAR 1
CHARG Batch Number CHARG_D CHAR 10 MCH1
LAGORTCHRG Storage Location LGORT_D CHAR 4 MCHB
ZEUGNISBIS Valid-To Date for The Batch Certificate QZEUGBIS DATS 8
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8
LICHN Vendor Batch Number LICHN CHAR 15
SOBKZ Special Stock Indicator SOBKZ CHAR 1 T148
PS_PSP_PNR Valuated Sales Order Stock WBS Element MAT_PSPNR NUMC 8 PRPS
KDAUF Sales Order Number of Valuated Sales Order Stock MAT_KDAUF CHAR 10 VBUK
KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6
EKORG Purchasing Organization EKORG CHAR 4 T024E
EBELN Purchasing Document Number EBELN CHAR 10 EKKO
EBELP Item Number of Purchasing Document EBELP NUMC 5 EKPO
ETENR Delivery Schedule Line Counter EETEN NUMC 4 EKET
BLART Document Type BLART CHAR 2 T003
MJAHR Material Document Year MJAHR NUMC 4
MBLNR Number of Material Document MBLNR CHAR 10
ZEILE Item in Material Document MBLPO NUMC 4
BUDAT Posting Date in the Document BUDAT DATS 8
BWART Movement Type (Inventory Management) BWART CHAR 3 T156
WERKVORG Plant Where Stock for Inspection Lot Is Held QWERKVORG CHAR 4 T001W
LAGORTVORG Storage Location for Inspection Lot Stock QLGORTVORG CHAR 4 T001L
LGNUM Warehouse Number / Warehouse Complex LGNUM CHAR 3 T300
LGTYP Storage Type LGTYP CHAR 3 T301
LGPLA Storage Bin LGPLA CHAR 10 LAGP
LS_KDAUF Sales Order Number KDAUF CHAR 10 VBUK
LS_KDPOS Item Number in Sales Order KDPOS NUMC 6
LS_VBELN Delivery VBELN_VL CHAR 10 VBUK
LS_POSNR Delivery Item POSNR_VL NUMC 6 VBUP
LS_ABRVW Delivery Category QABRVW CHAR 3 TVLV
LS_ROUTE Route ROUTE CHAR 6 TVRO
LS_LLAND Country of Destination LLAND CHAR 3 T005
LS_KUNAG Sold-to party KUNAG CHAR 10 KNA1
LS_VKORG Sales Organization VKORG CHAR 4 TVKO
LS_KDMAT Material belonging to the customer KDMAT CHAR 35
SPRACHE Language Key SPRAS LANG 1 T002
KTEXTLOS Short Text QKURZTEXT CHAR 40
LTEXTKZ Long Text Exists For Inspection Lot QLTEXTLOS CHAR 1
KTEXTMAT Short Text for Inspection Object QKTEXTOBJ CHAR 40
ZUSMKZAEHL Number of Characteristics Recorded Additionally QZUSMKZHL INT2 5
OFFENNLZMK Number of Outstanding Short-Term Chars Which Require Conf. QOFFENLZMK INT2 5
OFFEN_LZMK Number of Outstanding Long-Term Chars Which Require Conf. QOFFELZMK INT2 5
LOSMENGE Inspection Lot Quantity QLOSMENGE QUAN 13
MENGENEINH Base Unit of Measure for The Inspection Lot Quantity QLOSMENGEH UNIT 3 T006
ANZGEB QM - No. of Containers QANZGEB QUAN 6
GEBEH Lot Container QGEBEH UNIT 3 T006
LVS_STIKZ Indicator: what has happened to insp.sample (QM) in WM LVS_STIKZ CHAR 1
LVS_STIMG Sample in base unit of measure provided by WM LVS_STIMG QUAN 13
GESSTICHPR Sample Size QGESTICH QUAN 13
EINHPROBE Base Unit of Measure for the Sample Unit QPROBEMGEH UNIT 3 T006
DYNREGEL Dynamic Modification Rule QDYNREGEL CHAR 3 QDDR
STAT44 Time of Dynamic Modification in Inspection Lot QDYNTIME CHAR 1
PRSTUFE Inspection Stage QPRSTUFE NUMC 4 QDPS
PRSCHAERFE Inspection Severity QPRSCHAERF NUMC 3 QDEP
LMENGE01 Quantity Posted to Unrestricted-Use Stock QLMENGE01F QUAN 13
LMENGE02 Quantity Posted to Scrap QLMENGE02F QUAN 13
LMENGE03 Quantity Posted to Sample QLMENGE03F QUAN 13
LMENGE04 Quantity Posted to Blocked Stock QLMENGE04F QUAN 13
LMENGE05 Quantity Posted to Reserves QLMENGE05F QUAN 13
LMENGE06 Quantity Posted to Another Material QLMENGE06F QUAN 13
MATNRNEU Material Number to Which the Quantity is Posted QMATNRNEU CHAR 18 MARA
CHARGNEU Batch to Which Goods Are Transferred QCHARGNEU CHAR 10 MCH1
LMENGE07 Quantity Returned to Vendor QLMENGE07F QUAN 13
LMENGE08 Other Quantity Posted from Inspection Lot Stock QLMENGE08F QUAN 13
LMENGE09 Other Quantity (2) Posted from Inspection Lot Stock QLMENGE09F QUAN 13
LMENGEZUB Quantity That Must Be Posted QLMENGEZUB QUAN 13
LMENGELZ Sample Quantity for Long-Term Characteristics QLMENGELZ QUAN 13
LMENGEPR Quantity Actually Inspected QLMENGEPR QUAN 13
LMENGEZER Quantity Destroyed During Inspection QLMENGEZER QUAN 13
LMENGEIST Actual Lot Quantity QLMENGEIST QUAN 13
LMENGESCH Defective Quantity in Inspected Quantity QLMENGESCH QUAN 13
LTEXTKZBB Logs Exist for Usage Decision QLTEXTKZBB CHAR 1
ANTEIL Share of Scrap in Inspection Lot QAUSANTEIL FLTP 16
QKZVERF Procedure for Calculating Quality Score QKZVERF CHAR 2 TQ06
STAT03 Usage Decision Mmode (UD Origin) QMODUS_UD CHAR 1
QPMATLOS Allowed Share of Scrap QPMATLOS FLTP 16
AUFNR_CO Order Number for Recording Appraisal Costs QAUFNR_CO CHAR 12 AUFK
KZVBR Consumption Posting KZVBR CHAR 1
KNTTP Account Assignment Category KNTTP CHAR 1 T163K
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 T163
STAT05 Account Assignment Key: Inspection Lot QKZQALSKNT CHAR 1
KOSTL Cost Center KOSTL CHAR 10 CSKS
AUFPS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4
ANLN1 Main Asset Number ANLN1 CHAR 12 ANLH
ANLN2 Asset Subnumber ANLN2 CHAR 4 ANLA
KONT_PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 PRPS
NPLNR Network Number for Account Assignment NPLNR CHAR 12 AUFK
APLZL Internal counter CIM_COUNT NUMC 8
KONT_KDAUF Sales Order Number KDAUF CHAR 10 VBUK
KONT_KDPOS Item Number in Sales Order KDPOS NUMC 6
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8
DABRZ Reference Date for Settlement DABRBEZ DATS 8
KSTRG Cost Object KSTRG CHAR 12 CKPH
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10
PRCTR Profit Center PRCTR CHAR 10 CEPC
GSBER Business Area GSBER CHAR 4 TGSB
KONTO G/L Account Number SAKNR CHAR 10 SKA1
KOKRS Controlling Area KOKRS CHAR 4 TKA01
BUKRS Company Code BUKRS CHAR 4 T001
SERNP Serial Number Profile SERAIL CHAR 4 T377P
LOS_REF Inspection Lot Number Which Is Referenced QLOS_REF NUMC 12 QALS
BEARBSTATU Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED02 CHAR 2
STAT32 Inspection lot for stability study QSTABI CHAR 1
STAT33 Indicator: Multiple Specifications Q_MS_FLG CHAR 1
STAT36 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
STAT37 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
STAT38 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
STAT39 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
STAT40 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
STAT41 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
STAT42 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
STAT43 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
MENGU Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
KZPZADR Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
KZPRADR Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
ZUSCH Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
ZUSTD Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
KZERSTLIEF Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
KZERSTMUST Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1
ADDON_DUMMY Dummy Field for ADDON Structures in QM QDUMMY CHAR 1
WARPL Maintenance Plan WARPL CHAR 12 MPLA
WAPOS Maintenance item WAPOS CHAR 16
ABNUM Maintenance Plan Call Number ABNUM INT4 10
STRAT Maintenance strategy STRAT CHAR 6 T351
TRIALID Trial Number RMXTE_TRIALID CHAR 12
RESPONSIBLE Responsible ESEREALO CHAR 45
INSP_DOC_NUMBER Inspection Document Number from External System QINSP_DOC_NUMBER CHAR 30
LOG_SYSTEM Logical system LOGSYS CHAR 10 *
GESSTICHPR_EXT Sample Size from External System QGESTICH_EXT QUAN 13
EINHPROBE_EXT Unit of Measure of External Sample QPROBEMGEH_EXT UNIT 3 *
PRIO_PUNKTE Priority Points QPRIO_PUNKTE INT4 10
SIGN_TYPE_RR Signature Type: Inspection Lot Results Recording SIGN_TYPE_RR CHAR 1
SIGN_TYPE_UD Signature Type: Inspection Lot Usage Decision SIGN_TYPE_UD CHAR 1
SIGN_TYPE_SM Signature Type: Physical-Sample Drawing SIGN_TYPE_SM CHAR 1
SIGNSTRAT_RR Signature Strategy: Inspection Lot Results Recording SIGNSTRAT_RR CHAR 8 *
SIGNSTRAT_UD Signature Strategy with Individual Signature: Usage Decision SIGNSTRAT_UD CHAR 8 *
SIGNSTRAT_SM Signature Strategy w. Ind.Signature: Physical-Sample Drawing SIGNSTRAT_SM CHAR 8 *