QALS

Inspection lot record | #transactional | #language | Component: Quality Inspection
Column Name Description
MANDANT FK Client
PRUEFLOS Inspection Lot Number
Column Name Description
Column Name Description
📏 Base Unit of Measure for Inspection Lot Quantity (MENGENEINH):
LOSMENGE Inspection Lot Quantity
LVS_STIMG Sample in base unit of measure provided by WM
LMENGE01 Quantity Posted to Unrestricted-Use Stock
LMENGE02 Quantity Posted to Scrap
LMENGE03 Quantity Posted to Sample
LMENGE04 Quantity Posted to Blocked Stock
LMENGE05 Quantity Posted to Reserves
LMENGE06 Quantity Posted to Another Material
LMENGE07 Quantity Returned to Vendor
LMENGE08 Other Quantity Posted from Inspection Lot Stock
LMENGE09 Other Quantity (2) Posted from Inspection Lot Stock
LMENGEZUB Quantity That Must Be Posted
LMENGEIST Actual Lot Quantity
LMENGESCH Defective Quantity in Inspected Quantity
📏 Lot Container (GEBEH):
ANZGEB QM - No. of Containers
📏 Base Unit of Measure for Sample Unit (EINHPROBE):
GESSTICHPR Inspection Sample Size
LMENGELZ Sample Quantity for Long-Term Characteristics
LMENGEPR Quantity Actually Inspected
LMENGEZER Quantity Destroyed During Inspection
WITHDRAWN_SAMPLE_QTY Withdrawn Quantity for External Sample Size
📏 Unit of Measure of External Sample (EINHPROBE_EXT):
GESSTICHPR_EXT Sample Size from External System
📏 Parallel Unit of Measure of Inspection Lot Quantity (/CWM/MENGENEINH):
/CWM/LOSMENGE Inspection Lot Quantity in Parallel Unit of Measure
/CWM/LMENGE01 Quantity in PUoM Posted to Unrestricted Stock
/CWM/LMENGE02 Quantity in PUoM Posted to Scrap
/CWM/LMENGE03 Quantity Posted to Sample
/CWM/LMENGE04 Quantity in PUoM Posted to Blocked Stock
/CWM/LMENGE05 Quantity in PUoM Posted to Reserves
/CWM/LMENGE06 Quantity in PUoM Posted to a Different Material
/CWM/LMENGE07 Quantity in PUoM Posted Back to Vendor
/CWM/LMENGE08 Other Posted Quantity in PUoM from Inspection Lot Stock
/CWM/LMENGE09 Second Other Posted Quant. from Inspection Lot Stock in PUoM
/CWM/LMENGEZUB Quantity to be Posted in PUoM
/CWM/LMENGEIST Actual Lot Quantity in PUoM
Column Name Description
ENSTEHDAT Date in Time Zone Where Lot Created
ENTSTEZEIT Time in Time Zone Where Lot Created
ERSTELDAT System Date on Which Data Record Was Created
ERSTELZEIT System Time of Lot Creation
AENDERDAT System Date on Which Data Record Was Changed
AENDERZEIT System Time of Lot Change
PASTRTERM Start Date of Inspection in Local Time Zone
PASTRZEIT Inspection Start Time in Local Time Zone
PAENDTERM End Date of Inspection in Local Time Zone
PAENDZEIT Inspection End Time in Local Time Zone
GUELTIGAB Key Date for Selecting Records or Changing Task Lists
ZEUGNISBIS Valid-To Date for Batch Certificate
VFDAT Shelf Life Expiration or Best-Before Date
BUDAT Posting Date in the Document
DABRZ Reference date for settlement
Column Name Description
INSMK Quantity Is or Was in Inspection Stock Show values
STAT01 Inspection Lot Is Created Automatically Show values
STAT02 Partial Lots Exist Show values
STAT04 Data Record Was Changed Using Customer Exit Show values
STAT06 Record Appraisal Costs in Individual QM Order Show values
STAT07 Inspection with Inspection Points Show values
STAT08 Automatic Usage Decision Planned Show values
STAT09 Source Inspection Show values
STAT10 Inspection Specifications from Configuration Show values
STAT14 Completion of Short-Term Inspection Show values
STAT16 Inspection Specifications from Batch Determination Show values
STAT18 Control of Inspection Lot Creation (Lot Summary) Show values
STAT19 Documentation Required for Inspection Lot Show values
STAT20 Inspection Plan Required Show values
STAT21 Enter Sample Manually Show values
STAT22 Inspect with Material Specification Show values
STAT23 Inspection Lot Approval Show values
STAT24 Digital Signature for Insp. Lot in Results Recording Show values
STAT25 Digital Signature for Insp. Lot When Usage Decision Made Show values
STAT29 Digital Signature for Confirmation of Sample Drawing Show values
STAT26 Approved Batch Record Required Show values
STAT27 Inspection Lot is an R/2 Inspection Lot Show values
STAT28 Select Characteristics Manually Show values
STAT31 Trigger Sample Calculation Manually Show values
STAT34 Stock Postings Completed Show values
STAT35 Usage Decision Has Been Made Show values
STAT45 Material as Dynamic Modification Criterion Show values
STAT46 Supplier as Dynamic Modification Criterion Show values
STAT47 Manufacturer as Dynamic Modification Criterion Show values
STAT48 Customer as Dynamic Modification Criterion Show values
STAT49 Machine as Dynamic Modification Criterion Show values
STAT50 Project as Dynamic Modification Criterion Show values
KZSKIPLOT Lot Skipped Show values
DYN Skips Allowed Show values
HPZ 100% Inspection Show values
EIN Serial Numbers Possible Show values
KZDYNERF Dynamic Modification Is Carried Out Show values
STAT30 Origin of Inspection Lot Unit of Measure for LIS Interface Show values
STAT15 Production Resource/Tool Saved for Insp. Lot Show values
STAT13 Inspection Point Type Show values
PPKZTLZU Partial Lot Assignment in an Inspection During Production Show values
STAT12 Confirmation Required for Sample Drawing Show values
STAT17 Manufacturer Part No. Processing Active Show values
CVP_XBLCK Business Purpose Completed Flag Show values
XCHPF Batch Management Requirement Indicator Show values
LTEXTKZ Long Text Exists For Inspection Lot Show values
LVS_STIKZ Indicator: what has happened to insp.sample (QM) in WM Show values
STAT44 Time of Dynamic Modification in Inspection Lot Show values
LTEXTKZBB Logs Exist for Usage Decision Show values
STAT03 Usage Decision Mode (UD Origin) Show values
KZVBR Consumption posting Show values
STAT05 Account Assignment Key: Inspection Lot Show values
STAT32 Inspection Lot for Stability Study Show values
STAT33 Indicator: Multiple Specifications Show values
STAT36 Lot Has Partial Lots Without Insp. Point and Insp. Specs Show values
STAT37 Inspection Lot Is Blocked for Archiving Show values
STAT43 Inspection Lot Created for First Article Inspection Show values
SIGN_TYPE_RR Signature Type: Inspection Lot Results Recording Show values
SIGN_TYPE_UD Signature Type: Inspection Lot Usage Decision Show values
SIGN_TYPE_SM Signature Type: Sample Drawing Show values
SETUP_ORIG Origin of Inspection Lot Setup Show values
EWM_IS_LOCAL X and Blank Show values
INBOUND_PROC Inbound Inspection Process Show values
Column Name Description Domain name
STAT11 GR Blocked Stock KZWES
ANZSN Number of serial numbers INT4
QINFSTATUS QINF Status QINFSTATUS
ERSTELLER Name of User Who Created the Data Record QAENDERER
AENDERER Name of User Who Last Changed Data Record QAENDERER
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
PLNNR Key for Task List Group PLNNR
PLNAL Group Counter ALTNR
ZAEHL Internal counter CIM_COUNT
ZKRIZ Counter for Additional Criteria ZKRIZ
ZAEHL1 Internal counter CIM_COUNT
PRBNAVV Version No. of the Sample-Drawing Procedure QVERSNR
SELREVLV Revision Level REVLV
AUFPL Routing number of operations in the order AUFPL
CUOBJ Configuration (internal object number) CUOBJ
CUOBJ_CH Internal object number of the batch classification CUOBJ
REVLV Revision Level REVLV
LICHN Supplier Batch Number LICHN
KDAUF Sales order number of valuated sales order stock VBELN
KDPOS Sales Order Item of Valuated Sales Order Stock NUM06
MJAHR Material Document Year GJAHR
MBLNR Number of Material Document BELNR
ZEILE Item in Material Document MBLPO
LS_KDAUF Sales Order Number VBELN
LS_KDPOS Item number in Sales Order NUM06
LS_VBELN Delivery VBELN
LS_POSNR Delivery Item POSNR
LS_KDMAT Customer Material IDNEX
KTEXTLOS Short Text QKURZTEXT
KTEXTMAT Short Text for Inspection Object QKURZTEXT
LS_EQUNR Equipment Number EQUNR
LS_TPLNR Functional Location TPLNR
ZUSMKZAEHL Number of Characteristics Recorded Additionally INT2
OFFENNLZMK Number of Outstanding Short-Term Chars That Require Confirm. INT2
OFFEN_LZMK Number of Outstanding Long-Term Chars That Require Confirm. INT2
ANTEIL Share of Scrap in Inspection Lot QFLTP16
QPMATLOS Allowed Share of Scrap QPMATLOS
AUFPS Item Number of Reservation / Dependent Requirements RSPOS
APLZL Internal counter CIM_COUNT
KONT_KDAUF Sales Order Number VBELN
KONT_KDPOS Item number in Sales Order NUM06
IMKEY Internal Key for Real Estate Object IMKEY
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
BEARBSTATU Field Not Used as of 3.0 Field Reserved for SAP CHAR2
STAT38 Field Not Used as of 3.0 Field Reserved for SAP CHAR1
STAT39 Field Not Used as of 3.0 Field Reserved for SAP CHAR1
STAT40 Field Not Used as of 3.0 Field Reserved for SAP CHAR1
STAT41 Field Not Used as of 3.0 Field Reserved for SAP CHAR1
STAT42 Field Not Used as of 3.0 Field Reserved for SAP CHAR1
MENGU Field Not Used as of 3.0 Field Reserved for SAP CHAR1
KZPZADR Field Not Used as of 3.0 Field Reserved for SAP CHAR1
KZPRADR Field Not Used as of 3.0 Field Reserved for SAP CHAR1
ZUSCH Field Not Used as of 3.0 Field Reserved for SAP CHAR1
ZUSTD Field Not Used as of 3.0 Field Reserved for SAP CHAR1
KZERSTLIEF Field Not Used as of 3.0 Field Reserved for SAP CHAR1
KZERSTMUST Field Not Used as of 3.0 Field Reserved for SAP CHAR1
ADDON_DUMMY Dummy Field for ADDON Structures in QM QDUMMY
WAPOS Maintenance item POSNU
ABNUM Maintenance Plan Call Number ABNUM
TRIALID Trial Number RMXTD_TRIALID
RESPONSIBLE Responsible CHAR45
INSP_DOC_NUMBER Inspection Document Number from External System QPLEXT_INSP_DOC_NUMBER
LOG_SYSTEM Logical system LOGSYS
PRIO_PUNKTE Priority Points QPLEXT_PRIOP
SIGNSTRAT_RR Signature Strategy: Inspection Lot Results Recording SIGNSTRAT
SIGNSTRAT_UD Signature Strategy with Individual Signature: Usage Decision SIGNSTRAT
SIGNSTRAT_SM Signature Strategy w. Ind.Signature: Sample Drawing SIGNSTRAT
DUMMY_QALS_INCL_EEW_PS Dummy function in length 1 DUMMY
LOT_GUID Internal Identification for Inspection Lot QALS_GUID
CAT_FROM Stock Type /LIME/STOCK_CATEGORY
CATLOCN_TO Inspection Rule Argument: Location-Independent Stock Type /SCWM/DO_CATLOCN
PROCESS_STEP External Storage Process Step /SCWM/DO_PROCS
COO Country/Region of Origin LAND1
INSP_GROUP Quality Inspection Group /SCWM/DO_QGRP
IOT_GUID GUID of Inspection Object Type UUID
RLGRP Inspection Rule Group /SCWM/DO_QRGRP
EXCCODE Exception Code /SCWM/DO_EXCCODE
Master Data Relations Join Conditions
Asset Subnumber
  • Asset Subnumber
  • Company Code
  • Main Asset Number
  • QALS.MANDANT == ANLA.MANDT
  • QALS.ANLN2 == ANLA.ANLN2
  • QALS.BUKRS == ANLA.BUKRS
  • QALS.ANLN1 == ANLA.ANLN1
Inspection Type
  • QALS.MANDANT == TQ30.MANDT
  • QALS.ART == TQ30.ART
Order Number
  • Order Number
  • Client
  • QALS.AUFNR == AUFK.AUFNR
  • QALS.MANDANT == AUFK.MANDT
Order Number for Recording Appraisal Costs
  • Order Number for Recording Appraisal Costs
  • Client
  • QALS.AUFNR_CO == AUFK.AUFNR
  • QALS.MANDANT == AUFK.MANDT
Document Type
  • Document Type
  • Client
  • QALS.BLART == T003.BLART
  • QALS.MANDANT == T003.MANDT
Company Code
  • QALS.MANDANT == T001.MANDT
  • QALS.BUKRS == T001.BUKRS
Movement type (inventory management)
  • QALS.MANDANT == T156.MANDT
  • QALS.BWART == T156.BWART
Batch Number
  • Material Number
  • Client
  • Batch Number
  • QALS.MATNR == MCH1.MATNR
  • QALS.MANDANT == MCH1.MANDT
  • QALS.CHARG == MCH1.CHARG
Batch to Which Goods Are Transferred
  • Material Number to Which the Quantity is Posted
  • Client
  • Batch to Which Goods Are Transferred
  • QALS.MATNRNEU == MCH1.MATNR
  • QALS.MANDANT == MCH1.MANDT
  • QALS.CHARGNEU == MCH1.CHARG
Level at Which Dynamic Modification Parameters Are Defined QALS.DYNHEAD == TQ39A.DYNLEVEL
Dynamic Modification Rule
  • QALS.MANDANT == QDDR.MANDT
  • QALS.DYNREGEL == QDDR.DYNREGEL
Base Unit of Measure for Sample Unit
  • QALS.MANDANT == T006.MANDT
  • QALS.EINHPROBE == T006.MSEHI
Purchasing organization
  • QALS.MANDANT == T024E.MANDT
  • QALS.EKORG == T024E.EKORG
Material number corresponding to manufacturer part number
  • Material number corresponding to manufacturer part number
  • Client
  • QALS.EMATNR == MARA.MATNR
  • QALS.MANDANT == MARA.MANDT
External Numbering of Units to Be Inspected
  • QALS.MANDANT == TQ12.MANDT
  • QALS.EXTNUM == TQ12.EXTNUM
Lot Container
  • QALS.MANDANT == T006.MANDT
  • QALS.GEBEH == T006.MSEHI
Business Area
  • QALS.MANDANT == TGSB.MANDT
  • QALS.GSBER == TGSB.GSBER
Inspection Lot Origin QALS.HERKUNFT == TQ31.HERKUNFT
Number of Manufacturer
  • QALS.MANDANT == LFA1.MANDT
  • QALS.HERSTELLER == LFA1.LIFNR
Account Assignment Category
  • QALS.MANDANT == T163K.MANDT
  • QALS.KNTTP == T163K.KNTTP
Controlling Area
  • QALS.MANDANT == TKA01.MANDT
  • QALS.KOKRS == TKA01.KOKRS
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • QALS.[column in domain "KTOPL"] == SKA1.KTOPL
  • QALS.MANDANT == SKA1.MANDT
  • QALS.KONTO == SKA1.SAKNR
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • QALS.MANDANT == CSKS.MANDT
  • QALS.[column in domain "DATBI"] == CSKS.DATBI
  • QALS.KOSTL == CSKS.KOSTL
  • QALS.KOKRS == CSKS.KOKRS
Cost Object
  • Cost Object
  • ?
  • Client
  • QALS.KSTRG == CKPH.KSTRG
  • QALS.[column in domain "DATBI"] == CKPH.DATBI
  • QALS.MANDANT == CKPH.MANDT
Customer (Ship-To Party)
  • QALS.MANDANT == KNA1.MANDT
  • QALS.KUNNR == KNA1.KUNNR
Storage location
  • Storage location
  • Material Number
  • Batch Number
  • Client
  • Plant
  • QALS.LAGORTCHRG == MCHB.LGORT
  • QALS.MATNR == MCHB.MATNR
  • QALS.CHARG == MCHB.CHARG
  • QALS.MANDANT == MCHB.MANDT
  • QALS.WERK == MCHB.WERKS
Storage Location for Inspection Lot Stock
  • Storage Location for Inspection Lot Stock
  • Client
  • Plant Where Stock for Inspection Lot Is Held
  • QALS.LAGORTVORG == T001L.LGORT
  • QALS.MANDANT == T001L.MANDT
  • QALS.WERKVORG == T001L.WERKS
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • QALS.LGNUM == T300.LGNUM
  • QALS.MANDANT == T300.MANDT
Storage Bin
  • Storage Bin
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • QALS.MANDANT == LAGP.MANDT
  • QALS.LGPLA == LAGP.LGPLA
  • QALS.LGNUM == LAGP.LGNUM
  • QALS.LGTYP == LAGP.LGTYP
Storage Type
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Type
  • QALS.LGNUM == T301.LGNUM
  • QALS.MANDANT == T301.MANDT
  • QALS.LGTYP == T301.LGTYP
Vendor's account number
  • QALS.MANDANT == LFA1.MANDT
  • QALS.LIFNR == LFA1.LIFNR
Delivery Category
  • Delivery Category
  • Client
  • QALS.LS_ABRVW == TVLV.ABRVW
  • QALS.MANDANT == TVLV.MANDT
Sold-to Party
  • QALS.MANDANT == KNA1.MANDT
  • QALS.LS_KUNAG == KNA1.KUNNR
Destination Country/Region
  • Destination Country/Region
  • Client
  • QALS.LS_LLAND == T005.LAND1
  • QALS.MANDANT == T005.MANDT
Route
  • QALS.MANDANT == TVRO.MANDT
  • QALS.LS_ROUTE == TVRO.ROUTE
Sales Organization
  • QALS.MANDANT == TVKO.MANDT
  • QALS.LS_VKORG == TVKO.VKORG
Client QALS.MANDANT == T000.MANDT
Material Number
  • Material Number
  • Client
  • QALS.MATNR == MARA.MATNR
  • QALS.MANDANT == MARA.MANDT
Material Number to Which the Quantity is Posted
  • Material Number to Which the Quantity is Posted
  • Client
  • QALS.MATNRNEU == MARA.MATNR
  • QALS.MANDANT == MARA.MANDT
Base Unit of Measure for Inspection Lot Quantity
  • QALS.MANDANT == T006.MANDT
  • QALS.MENGENEINH == T006.MSEHI
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • QALS.NPLNR == AUFK.AUFNR
  • QALS.MANDANT == AUFK.MANDT
Object Type QALS.OBTYP == TJ03.OBTYP
Task List Type
  • QALS.MANDANT == TCA01.MANDT
  • QALS.PLNTY == TCA01.PLNTY
Task List Usage
  • Task List Usage
  • Client
  • QALS.PPLVERW == T411.VERWE
  • QALS.MANDANT == T411.MANDT
Sample-Drawing Procedure
  • Sample-Drawing Procedure
  • Version No. of the Sample-Drawing Procedure
  • Client
  • QALS.PRBNAVERF == QPRVK.PRZIEHVERF
  • QALS.PRBNAVV == QPRVK.VERSION
  • QALS.MANDANT == QPRVK.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • QALS.MANDANT == CEPC.MANDT
  • QALS.[column in domain "DATBI"] == CEPC.DATBI
  • QALS.[column in domain "KOKRS"] == CEPC.KOKRS
  • QALS.PRCTR == CEPC.PRCTR
Inspection Severity
  • Inspection Severity
  • Client
  • QALS.PRSCHAERFE == QDEP.PRSCHAERFE
  • QALS.MANDANT == QDEP.MANDT
Inspection Stage
  • Inspection Stage
  • Client
  • Dynamic Modification Rule
  • QALS.PRSTUFE == QDPS.PRSTUFE
  • QALS.MANDANT == QDPS.MANDT
  • QALS.DYNREGEL == QDPS.DYNREGEL
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • QALS.PSTYP == T163.PSTYP
  • QALS.MANDANT == T163.MANDT
Procedure for Calculating Quality Score
  • Procedure for Calculating Quality Score
  • Client
  • QALS.QKZVERF == TQ06.QKZVERF
  • QALS.MANDANT == TQ06.MANDT
Material Authorization Group for Activities in QM
  • QALS.MANDANT == TQ01B.MANDT
  • QALS.QMATAUTH == TQ01B.QMATAUTH
Production Version Number
  • Run schedule header number
  • Client
  • QALS.SA_AUFNR == SAFK.AUFNR
  • QALS.MANDANT == SAFK.MANDT
Number of Manufacturer
  • QALS.MANDANT == LFA1.MANDT
  • QALS.SELHERST == LFA1.LIFNR
Account number of customer
  • QALS.MANDANT == KNA1.MANDT
  • QALS.SELKUNNR == KNA1.KUNNR
Vendor's account number
  • QALS.MANDANT == LFA1.MANDT
  • QALS.SELLIFNR == LFA1.LIFNR
Material Number
  • Material Number
  • Client
  • QALS.SELMATNR == MARA.MATNR
  • QALS.MANDANT == MARA.MANDT
Task List Usage
  • Task List Usage
  • Client
  • QALS.SELPPLVERW == T411.VERWE
  • QALS.MANDANT == T411.MANDT
Plant
  • QALS.MANDANT == T001W.MANDT
  • QALS.SELWERK == T001W.WERKS
Serial Number Profile
  • QALS.MANDANT == T377P.MANDT
  • QALS.SERNP == T377P.SERAIL
Inspection Point Identification
  • QALS.MANDANT == TQ79.MANDT
  • QALS.SLWBEZ == TQ79.SLWBEZ
Special Stock Indicator
  • QALS.MANDANT == T148.MANDT
  • QALS.SOBKZ == T148.SOBKZ
Language Key QALS.SPRACHE == T002.SPRAS
Update Group for statistics update
  • QALS.MANDANT == TMCB.MANDT
  • QALS.STAFO == TMCB.STAFO
Sampling Procedure
  • Sampling Procedure
  • Client
  • QALS.STPRVER == QDSV.STICHPRVER
  • QALS.MANDANT == QDSV.MANDT
Maintenance Strategy
  • Maintenance Strategy
  • Client
  • QALS.STRAT == T351.STRAT
  • QALS.MANDANT == T351.MANDT
Status Profile
  • QALS.MANDANT == TJ20.MANDT
  • QALS.STSMA == TJ20.STSMA
Production Version
  • Plant
  • Material Number
  • Production Version
  • Client
  • QALS.WERK == MKAL.WERKS
  • QALS.MATNR == MKAL.MATNR
  • QALS.VERID == MKAL.VERID
  • QALS.MANDANT == MKAL.MANDT
Maintenance Plan
  • Maintenance Plan
  • Client
  • QALS.WARPL == MPLA.WARPL
  • QALS.MANDANT == MPLA.MANDT
Plant
  • QALS.MANDANT == T001W.MANDT
  • QALS.WERK == T001W.WERKS
Plant Where Stock for Inspection Lot Is Held
  • QALS.MANDANT == T001W.MANDT
  • QALS.WERKVORG == T001W.WERKS