SAP Table QALS - Inspection lot record

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDANT X MANDT CLNT 0 3 0 T000 Client
PRUEFLOS X QPLOS NUMC 3 12 0 QALS Inspection Lot Number
WERK WERKS_D CHAR 15 4 0 T001W Plant
ART QPART CHAR 19 8 0 TQ30 Inspection Type
HERKUNFT QHERK CHAR 27 2 0 Inspection Lot Origin
OBJNR J_OBJNR CHAR 29 22 0 ONR00 Object number
OBTYP J_OBTYP CHAR 51 3 0 TJ03 Object Category
STSMA J_STSMA CHAR 54 8 0 Status Profile
QMATAUTH QMATAUTH CHAR 62 6 0 Material Authorization Group for Activities in QM
STAT11 KZWES CHAR 68 1 0 GR blocked stock
INSMK QVINSMK CHAR 69 1 0 Quantity Is or Was in Inspection Stock
STAT01 QSTAT01 CHAR 70 1 0 Inspection Lot is Created Automatically
STAT02 QKZQALT CHAR 71 1 0 Partial Lots Exist
STAT04 QUSER_EXIT CHAR 72 1 0 Data Record Was Changed Using Customer Exit
STAT06 QKZPRFKOST CHAR 73 1 0 Record Appraisal Costs in Individual QM Order
STAT07 QKZFERTPRF CHAR 74 1 0 Inspection with Inspection Points
STAT08 QAUTO_VE CHAR 75 1 0 Automatic Usage Decision Planned
STAT09 QABNAHMPRF CHAR 76 1 0 Source Inspection
STAT10 QCONF CHAR 77 1 0 Inspection Specifications from Configuration
STAT14 QSTAT14 CHAR 78 1 0 Completion of Short-Term Inspection
STAT16 QCHARG CHAR 79 1 0 Inspection Specifications from Batch Determination
STAT18 Q1WELOS CHAR 80 1 0 Control of Inspection Lot Creation (Lot Summary)
STAT19 QSTAT19 CHAR 81 1 0 Documentation Required for Inspection Lot
STAT20 QSTAT20 CHAR 82 1 0 Inspection Plan Required
STAT21 QSTAT21 CHAR 83 1 0 Enter Sample Manually
STAT22 QSPEZUEBER CHAR 84 1 0 Inspect with Material Specification
STAT23 QKZGENLOS CHAR 85 1 0 Inspection Lot Approval
STAT24 SIG_IL_RES CHAR 86 1 0 Digital Signature for Insp. Lot in Results Recording
STAT25 SIG_IL_USA CHAR 87 1 0 Digital Signature for Insp. Lot when Usage Decision Made
STAT29 SIG_IL_SDR CHAR 88 1 0 Digital Signature for Confirmation of Phys.-Sample Drawing
STAT26 XGCHP CHAR 89 1 0 Indicator: Approved batch record required
STAT27 QSTAT27 CHAR 90 1 0 Inspection Lot is an R/2 Inspection Lot
STAT28 QSTAT28 CHAR 91 1 0 Select Characteristics Manually
STAT31 QSTAT31 CHAR 92 1 0 Trigger Sample Calculation Manually
STAT34 QSTAT34 CHAR 93 1 0 Stock Postings Completed
STAT35 QSTAT35 CHAR 94 1 0 Usage Decision Has Been Made
STAT45 QSTAT45 CHAR 95 1 0 Material as Dynamic Modification Criterion
STAT46 QSTAT46 CHAR 96 1 0 Vendor as Dynamic Modification Criterion
STAT47 QSTAT47 CHAR 97 1 0 Manufacturer as Dynamic Modification Criterion
STAT48 QSTAT48 CHAR 98 1 0 Customer as Dynamic Modification Criterion
STAT49 QSTAT49 CHAR 99 1 0 Machine as Dynamic Modification Criterion
STAT50 QSTAT50 CHAR 100 1 0 Project as Dynamic Modification Criterion
KZSKIPLOT QKZSKIPLOT CHAR 101 1 0 Lot Skipped
DYN QDYN CHAR 102 1 0 Skips Allowed
HPZ QHPZ CHAR 103 1 0 100% Inspection
EIN QEINZ CHAR 104 1 0 Serial Number Management Possible
ANZSN ANZSN INT4 108 10 0 Number of serial numbers
KZDYNERF QKZDYNERF CHAR 112 1 0 Dynamic Modification Is Carried Out
DYNHEAD QDYNHEAD CHAR 113 1 0 Level at Which Dynamic Modification Parameters Are Defined
STPRVER QSTPRVER CHAR 114 8 0 Sampling Procedure
EXTNUM QEXTNUM CHAR 122 1 0 External Numbering of Units to be Inspected
STAFO STAFO CHAR 123 6 0 Update group for statistics update
STAT30 QUNITORIGIN CHAR 129 1 0 Origin of Inspection Lot Unit of Measure for LIS Interface
QINFSTATUS QINFSTATUS CHAR 130 8 0 QINF Status
ENSTEHDAT QENTST DATS 138 8 0 Date of Lot Creation
ENTSTEZEIT QENTSTZEIT TIMS 146 6 0 Time of Lot Creation
ERSTELLER QERSTELLER CHAR 152 12 0 Name of User Who Created the Data Record
ERSTELDAT QDATUMERST DATS 164 8 0 Date on Which the Data Record Was Created
ERSTELZEIT QERSTEZEIT TIMS 172 6 0 Time of Lot Creation
AENDERER QAENDERER CHAR 178 12 0 Name of User who Most Recently Changed the Data Record
AENDERDAT QDATUMAEND DATS 190 8 0 Date on Which Data Record Was Changed
AENDERZEIT QAENDEZEIT TIMS 198 6 0 Time of Lot Change
PASTRTERM QPRSTART DATS 204 8 0 Inspection Start Date
PASTRZEIT QSTARTZEIT TIMS 212 6 0 Inspection Start Time
PAENDTERM QPRENDE DATS 218 8 0 End Date of the Inspection
PAENDZEIT QENDEZEIT TIMS 226 6 0 Inspection End Time
PLNTY PLNTY CHAR 232 1 0 TCA01 Task List Type
PLNNR PLNNR CHAR 233 8 0 Key for Task List Group
PPLVERW PLN_VERWE CHAR 241 3 0 T411 Task list usage
PLNAL PLNAL CHAR 244 2 0 Group Counter
ZAEHL CIM_COUNT NUMC 246 8 0 Internal counter
ZKRIZ DZKRIZ NUMC 254 7 0 Counter for additional criteria
STAT15 QFHM_MODE CHAR 261 1 0 Production Resource/Tool Saved for Insp. Lot
SLWBEZ QSLWBEZ CHAR 262 3 0 Identification for the Inspection Point Field Combination
STAT13 QPPKTTYP CHAR 265 1 0 Inspection Point Type
PPKZTLZU QPPKZTLZU CHAR 266 1 0 Partial Lot Assignment in an Inspection During Production
ZAEHL1 CIM_COUNT NUMC 267 8 0 Internal counter
PRBNAVERF QPRZIEHVER CHAR 275 8 0 QPRVK Sample-Drawing Procedure
PRBNAVV QVERSNPRZV CHAR 283 6 0 Version No. of the Sample-Drawing Procedure
STAT12 QKZQUIT CHAR 289 1 0 Confirmation Required for Physical-Sample Drawing
SELMATNR MATNR CHAR 290 18 0 MARA Material Number
SELREVLV REVLV CHAR 308 2 0 Revision Level
SELWERK WERKS_D CHAR 310 4 0 T001W Plant
SELLIFNR ELIFN CHAR 314 10 0 LFA1 Vendor Account Number
STAT17 QHERST CHAR 324 1 0 Manufacturer Part No. Processing Active
SELHERST QLIFNR CHAR 325 10 0 LFA1 Number of Manufacturer
SELKUNNR EKUNN CHAR 335 10 0 KNA1 Account Number of Customer
SELPPLVERW PLN_VERWE CHAR 345 3 0 T411 Task list usage
GUELTIGAB QSTICHTAG DATS 348 8 0 Key Date for Selecting Records or Changing Task Lists
AUFNR AUFNR CHAR 356 12 0 AUFK Order Number
AUFPL CO_AUFPL NUMC 368 10 0 Routing number of operations in the order
CUOBJ CUOBJ NUMC 378 18 0 Configuration (internal object number)
CUOBJ_CH CUOBJ_CH NUMC 396 18 0 Internal object number of the batch classification
VERID VERID CHAR 414 4 0 Production Version
SA_AUFNR SA_AUFNR CHAR 418 12 0 Run schedule header number
KUNNR QKUNWE CHAR 430 10 0 KNA1 Customer (Ship-To Party)
LIFNR ELIFN CHAR 440 10 0 LFA1 Vendor Account Number
HERSTELLER QLIFNR CHAR 450 10 0 LFA1 Number of Manufacturer
EMATNR EMATN CHAR 460 18 0 MARA Material Number Corresponding to Manufacturer Part Number
MATNR MATNR CHAR 478 18 0 MARA Material Number
REVLV REVLV CHAR 496 2 0 Revision Level
XCHPF XCHPF CHAR 498 1 0 Batch management requirement indicator
CHARG CHARG_D CHAR 499 10 0 MCH1 Batch Number
LAGORTCHRG LGORT_D CHAR 509 4 0 T001L Storage Location
ZEUGNISBIS QZEUGBIS DATS 513 8 0 Valid-To Date for The Batch Certificate
VFDAT VFDAT DATS 521 8 0 Shelf Life Expiration or Best-Before Date
LICHN LICHN CHAR 529 15 0 Vendor Batch Number
SOBKZ SOBKZ CHAR 544 1 0 T148 Special Stock Indicator
PS_PSP_PNR MAT_PSPNR NUMC 545 8 0 PRPS Valuated Sales Order Stock WBS Element
KDAUF MAT_KDAUF CHAR 553 10 0 Sales Order Number of Valuated Sales Order Stock
KDPOS MAT_KDPOS NUMC 563 6 0 Sales Order Item of Valuated Sales Order Stock
EKORG EKORG CHAR 569 4 0 T024E Purchasing Organization
EBELN EBELN CHAR 573 10 0 EKKO Purchasing Document Number
EBELP EBELP NUMC 583 5 0 EKPO Item Number of Purchasing Document
ETENR EETEN NUMC 588 4 0 EKET Delivery Schedule Line Counter
BLART BLART CHAR 592 2 0 T003 Document Type
MJAHR MJAHR NUMC 594 4 0 Material Document Year
MBLNR MBLNR CHAR 598 10 0 Number of Material Document
ZEILE MBLPO NUMC 608 4 0 Item in Material Document
BUDAT BUDAT DATS 612 8 0 Posting Date in the Document
BWART BWART CHAR 620 3 0 T156 Movement Type (Inventory Management)
WERKVORG QWERKVORG CHAR 623 4 0 T001W Plant Where Stock for Inspection Lot Is Held
LAGORTVORG QLGORTVORG CHAR 627 4 0 T001L Storage Location for Inspection Lot Stock
LGNUM LGNUM CHAR 631 3 0 T300 Warehouse Number / Warehouse Complex
LGTYP LGTYP CHAR 634 3 0 T301 Storage Type
LGPLA LGPLA CHAR 637 10 0 LAGP Storage Bin
LS_KDAUF KDAUF CHAR 647 10 0 Sales Order Number
LS_KDPOS KDPOS NUMC 657 6 0 Item Number in Sales Order
LS_VBELN VBELN_VL CHAR 663 10 0 Delivery
LS_POSNR POSNR_VL NUMC 673 6 0 Delivery Item
LS_ABRVW QABRVW CHAR 679 3 0 TVLV Delivery Category
LS_ROUTE ROUTE CHAR 682 6 0 TVRO Route
LS_LLAND LLAND CHAR 688 3 0 T005 Country of Destination
LS_KUNAG KUNAG CHAR 691 10 0 KNA1 Sold-to party
LS_VKORG VKORG CHAR 701 4 0 TVKO Sales Organization
LS_KDMAT KDMAT CHAR 705 35 0 Material belonging to the customer
SPRACHE SPRAS LANG 740 1 0 T002 Language Key
KTEXTLOS QKURZTEXT CHAR 741 40 0 Short Text
LTEXTKZ QLTEXTLOS CHAR 781 1 0 Long Text Exists For Inspection Lot
KTEXTMAT QKTEXTOBJ CHAR 782 40 0 Short Text for Inspection Object
ZUSMKZAEHL QZUSMKZHL INT2 822 5 0 Number of Characteristics Recorded Additionally
OFFENNLZMK QOFFENLZMK INT2 824 5 0 Number of Outstanding Short-Term Chars Which Require Conf.
OFFEN_LZMK QOFFELZMK INT2 826 5 0 Number of Outstanding Long-Term Chars Which Require Conf.
LOSMENGE QLOSMENGE QUAN 828 13 3 Inspection Lot Quantity
MENGENEINH QLOSMENGEH UNIT 835 3 0 T006 Base Unit of Measure for The Inspection Lot Quantity
ANZGEB QANZGEB QUAN 838 6 3 QM - No. of Containers
GEBEH QGEBEH UNIT 842 3 0 T006 Lot Container
LVS_STIKZ LVS_STIKZ CHAR 845 1 0 Indicator: what has happened to insp.sample (QM) in WM
LVS_STIMG LVS_STIMG QUAN 846 13 3 Sample in base unit of measure provided by WM
GESSTICHPR QGESTICH QUAN 853 13 3 Sample Size
EINHPROBE QPROBEMGEH UNIT 860 3 0 T006 Base Unit of Measure for the Sample Unit
DYNREGEL QDYNREGEL CHAR 863 3 0 Dynamic Modification Rule
STAT44 QDYNTIME CHAR 866 1 0 Time of Dynamic Modification in Inspection Lot
PRSTUFE QPRSTUFE NUMC 867 4 0 QDPS Inspection Stage
PRSCHAERFE QPRSCHAERF NUMC 871 3 0 QDEP Inspection Severity
LMENGE01 QLMENGE01F QUAN 874 13 3 Quantity Posted to Unrestricted-Use Stock
LMENGE02 QLMENGE02F QUAN 881 13 3 Quantity Posted to Scrap
LMENGE03 QLMENGE03F QUAN 888 13 3 Quantity Posted to Sample
LMENGE04 QLMENGE04F QUAN 895 13 3 Quantity Posted to Blocked Stock
LMENGE05 QLMENGE05F QUAN 902 13 3 Quantity Posted to Reserves
LMENGE06 QLMENGE06F QUAN 909 13 3 Quantity Posted to Another Material
MATNRNEU QMATNRNEU CHAR 916 18 0 MARA Material Number to Which the Quantity is Posted
CHARGNEU QCHARGNEU CHAR 934 10 0 MCH1 Batch to Which Goods Are Transferred
LMENGE07 QLMENGE07F QUAN 944 13 3 Quantity Returned to Vendor
LMENGE08 QLMENGE08F QUAN 951 13 3 Other Quantity Posted from Inspection Lot Stock
LMENGE09 QLMENGE09F QUAN 958 13 3 Other Quantity (2) Posted from Inspection Lot Stock
LMENGEZUB QLMENGEZUB QUAN 965 13 3 Quantity That Must Be Posted
LMENGELZ QLMENGELZ QUAN 972 13 3 Sample Quantity for Long-Term Characteristics
LMENGEPR QLMENGEPR QUAN 979 13 3 Quantity Actually Inspected
LMENGEZER QLMENGEZER QUAN 986 13 3 Quantity Destroyed During Inspection
LMENGEIST QLMENGEIST QUAN 993 13 3 Actual Lot Quantity
LMENGESCH QLMENGESCH QUAN 1000 13 3 Defective Quantity in Inspected Quantity
LTEXTKZBB QLTEXTKZBB CHAR 1007 1 0 Logs Exist for Usage Decision
ANTEIL QAUSANTEIL FLTP 1008 16 16 Share of Scrap in Inspection Lot
QKZVERF QKZVERF CHAR 1016 2 0 Procedure for Calculating Quality Score
STAT03 QMODUS_UD CHAR 1018 1 0 Usage Decision Mmode (UD Origin)
QPMATLOS QPMATLOS FLTP 1024 16 16 Allowed Share of Scrap
AUFNR_CO QAUFNR_CO CHAR 1032 12 0 AUFK Order Number for Recording Appraisal Costs
KZVBR KZVBR CHAR 1044 1 0 Consumption Posting
KNTTP KNTTP CHAR 1045 1 0 T163K Account Assignment Category
PSTYP PSTYP CHAR 1046 1 0 T163 Item Category in Purchasing Document
STAT05 QKZQALSKNT CHAR 1047 1 0 Account Assignment Key: Inspection Lot
KOSTL KOSTL CHAR 1048 10 0 Cost Center
AUFPS RSPOS NUMC 1058 4 0 Item Number of Reservation/Dependent Requirement
ANLN1 ANLN1 CHAR 1062 12 0 ANLH Main Asset Number
ANLN2 ANLN2 CHAR 1074 4 0 ANLA Asset Subnumber
KONT_PSPNR PS_PSP_PNR NUMC 1078 8 0 PRPS Work Breakdown Structure Element (WBS Element)
NPLNR NPLNR CHAR 1086 12 0 AUFK Network Number for Account Assignment
APLZL CIM_COUNT NUMC 1098 8 0 Internal counter
KONT_KDAUF KDAUF CHAR 1106 10 0 Sales Order Number
KONT_KDPOS KDPOS NUMC 1116 6 0 Item Number in Sales Order
IMKEY IMKEY CHAR 1122 8 0 Internal Key for Real Estate Object
DABRZ DABRBEZ DATS 1130 8 0 Reference Date for Settlement
KSTRG KSTRG CHAR 1138 12 0 CKPH Cost Object
PAOBJNR RKEOBJNR NUMC 1150 10 0 Profitability Segment Number (CO-PA)
PRCTR PRCTR CHAR 1160 10 0 Profit Center
GSBER GSBER CHAR 1170 4 0 TGSB Business Area
KONTO SAKNR CHAR 1174 10 0 G/L Account Number
KOKRS KOKRS CHAR 1184 4 0 TKA01 Controlling Area
BUKRS BUKRS CHAR 1188 4 0 T001 Company Code
SERNP SERAIL CHAR 1192 4 0 T377P Serial Number Profile
LOS_REF QLOS_REF NUMC 1196 12 0 QALS Inspection Lot Number Which Is Referenced
BEARBSTATU Q_UNUSED02 CHAR 1208 2 0 Field Not Used as of 3.0 Field Reserved for SAP
STAT32 QSTABI CHAR 1210 1 0 Inspection lot for stability study
STAT33 Q_MS_FLG CHAR 1211 1 0 Indicator: Multiple Specifications
STAT36 Q_UNUSED01 CHAR 1212 1 0 Field Not Used as of 3.0 Field Reserved for SAP
STAT37 Q_UNUSED01 CHAR 1213 1 0 Field Not Used as of 3.0 Field Reserved for SAP
STAT38 Q_UNUSED01 CHAR 1214 1 0 Field Not Used as of 3.0 Field Reserved for SAP
STAT39 Q_UNUSED01 CHAR 1215 1 0 Field Not Used as of 3.0 Field Reserved for SAP
STAT40 Q_UNUSED01 CHAR 1216 1 0 Field Not Used as of 3.0 Field Reserved for SAP
STAT41 Q_UNUSED01 CHAR 1217 1 0 Field Not Used as of 3.0 Field Reserved for SAP
STAT42 Q_UNUSED01 CHAR 1218 1 0 Field Not Used as of 3.0 Field Reserved for SAP
STAT43 Q_UNUSED01 CHAR 1219 1 0 Field Not Used as of 3.0 Field Reserved for SAP
MENGU Q_UNUSED01 CHAR 1220 1 0 Field Not Used as of 3.0 Field Reserved for SAP
KZPZADR Q_UNUSED01 CHAR 1221 1 0 Field Not Used as of 3.0 Field Reserved for SAP
KZPRADR Q_UNUSED01 CHAR 1222 1 0 Field Not Used as of 3.0 Field Reserved for SAP
ZUSCH Q_UNUSED01 CHAR 1223 1 0 Field Not Used as of 3.0 Field Reserved for SAP
ZUSTD Q_UNUSED01 CHAR 1224 1 0 Field Not Used as of 3.0 Field Reserved for SAP
KZERSTLIEF Q_UNUSED01 CHAR 1225 1 0 Field Not Used as of 3.0 Field Reserved for SAP
KZERSTMUST Q_UNUSED01 CHAR 1226 1 0 Field Not Used as of 3.0 Field Reserved for SAP
ADDON_DUMMY QDUMMY CHAR 1228 1 0 Dummy Field for ADDON Structures in QM
WARPL WARPL CHAR 1232 12 0 MPLA Maintenance Plan
WAPOS WAPOS CHAR 1244 16 0 Maintenance item
ABNUM ABNUM INT4 1260 10 0 Maintenance Plan Call Number
STRAT STRAT CHAR 1264 6 0 Maintenance strategy
TRIALID RMXTE_TRIALID CHAR 1272 12 0 Trial Number
RESPONSIBLE ESEREALO CHAR 1284 45 0 Responsible
INSP_DOC_NUMBER QINSP_DOC_NUMBER CHAR 1332 30 0 Inspection Document Number from External System
LOG_SYSTEM LOGSYS CHAR 1362 10 0 Logical system
GESSTICHPR_EXT QGESTICH_EXT QUAN 1372 13 3 Sample Size from External System
EINHPROBE_EXT QPROBEMGEH_EXT UNIT 1379 3 0 Unit of Measure of External Sample
PRIO_PUNKTE QPRIO_PUNKTE INT4 1384 10 0 Priority Points
SIGN_TYPE_RR SIGN_TYPE_RR CHAR 1388 1 0 Signature Type: Inspection Lot Results Recording
SIGN_TYPE_UD SIGN_TYPE_UD CHAR 1389 1 0 Signature Type: Inspection Lot Usage Decision
SIGN_TYPE_SM SIGN_TYPE_SM CHAR 1390 1 0 Signature Type: Physical-Sample Drawing
SIGNSTRAT_RR SIGNSTRAT_RR CHAR 1391 8 0 TC85 Signature Strategy: Inspection Lot Results Recording
SIGNSTRAT_UD SIGNSTRAT_UD CHAR 1399 8 0 TC85 Signature Strategy with Individual Signature: Usage Decision
SIGNSTRAT_SM SIGNSTRAT_SM CHAR 1407 8 0 TC85 Signature Strategy w. Ind.Signature: Physical-Sample Drawing

89541Inspection lot exists w/o status object: EM BS001
664088DB15: QAKL, AFVC, AFVV missing for archiving QM_CONTROL
545168Object QM_CONTROL: QAMB is not archived
489100ORACLE: Performance problems when setting status DLFL
208100Missing inspection lots during GR for order