SAP table QALS (Inspection lot record)

SAP table QALS has 2 primary key fields being MANDANT,PRUEFLOS.

Field Description Data Type Length Decimals Checktable Data Element
MANDANT Client CLNT 3 0 T000 MANDT
PRUEFLOS Inspection Lot Number NUMC 12 0 QPLOS
WERK Plant CHAR 4 0 T001W WERKS_D
ART Inspection Type CHAR 8 0 TQ30 QPART
HERKUNFT Inspection Lot Origin CHAR 2 0 TQ31 QHERK
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
OBTYP Object Type CHAR 3 0 TJ03 J_OBTYP
STSMA Status Profile CHAR 8 0 TJ20 J_STSMA
QMATAUTH Material Authorization Group for Activities in QM CHAR 6 0 TQ01B QMATAUTH
STAT11 GR Blocked Stock CHAR 1 0 KZWES
INSMK Quantity Is or Was in Inspection Stock CHAR 1 0 QVINSMK
STAT01 Inspection Lot Is Created Automatically CHAR 1 0 QSTAT01
STAT02 Partial Lots Exist CHAR 1 0 QKZQALT
STAT04 Data Record Was Changed Using Customer Exit CHAR 1 0 QUSER_EXIT
STAT06 Record Appraisal Costs in Individual QM Order CHAR 1 0 QKZPRFKOST
STAT07 Inspection with Inspection Points CHAR 1 0 QKZFERTPRF
STAT08 Automatic Usage Decision Planned CHAR 1 0 QAUTO_VE
STAT09 Source Inspection CHAR 1 0 QABNAHMPRF
STAT10 Inspection Specifications from Configuration CHAR 1 0 QCONF
STAT14 Completion of Short-Term Inspection CHAR 1 0 QSTAT14
STAT16 Inspection Specifications from Batch Determination CHAR 1 0 QCHARG
STAT18 Control of Inspection Lot Creation (Lot Summary) CHAR 1 0 Q1WELOS
An inspection lot for each document item
1 An insp. lot per material document, material and batch
2 An inspection lot for each material and batch
3 One Inspection Lot for Each Batch Split Item
X An insp. lot per purch. order item, or order item and batch
Y Early lot creation for the order item
STAT19 Documentation Required for Inspection Lot CHAR 1 0 QSTAT19
STAT20 Inspection Plan Required CHAR 1 0 QSTAT20
STAT21 Enter Sample Manually CHAR 1 0 QSTAT21
STAT22 Inspect with Material Specification CHAR 1 0 QSPEZUEBER
STAT23 Inspection Lot Approval CHAR 1 0 QKZGENLOS
Approval Not Required
1 Automatic Approval Despite Material Specification
2 No Automatic Approval for Inspection with Matl Specification
STAT24 Digital Signature for Insp. Lot in Results Recording CHAR 1 0 SIG_IL_RES
Not Required
1 Required for Results Recording
2 Required for Results Recording 'New' Digital Signature
STAT25 Digital Signature for Insp. Lot When Usage Decision Made CHAR 1 0 SIG_IL_USA
Not Required
1 Required for Making Usage Decision
2 Required for Making the Usage Decision New Digital Signature
STAT29 Digital Signature for Confirmation of Sample Drawing CHAR 1 0 SIG_IL_SDR
Not Required
1 Required for Confirmation of Sample Drawing
2 Req. for Conf. of Sample Drawing 'New' Digital Sig.
STAT26 Approved Batch Record Required CHAR 1 0 XGCHP
STAT27 Inspection Lot is an R/2 Inspection Lot CHAR 1 0 QSTAT27
STAT28 Select Characteristics Manually CHAR 1 0 QSTAT28
STAT31 Trigger Sample Calculation Manually CHAR 1 0 QSTAT31
STAT34 Stock Postings Completed CHAR 1 0 QSTAT34
STAT35 Usage Decision Has Been Made CHAR 1 0 QSTAT35
STAT45 Material as Dynamic Modification Criterion CHAR 1 0 QSTAT45
STAT46 Supplier as Dynamic Modification Criterion CHAR 1 0 QSTAT46
STAT47 Manufacturer as Dynamic Modification Criterion CHAR 1 0 QSTAT47
STAT48 Customer as Dynamic Modification Criterion CHAR 1 0 QSTAT48
STAT49 Machine as Dynamic Modification Criterion CHAR 1 0 QSTAT49
STAT50 Project as Dynamic Modification Criterion CHAR 1 0 QSTAT50
KZSKIPLOT Lot Skipped CHAR 1 0 QKZSKIPLOT
DYN Skips Allowed CHAR 1 0 QDYN
HPZ 100% Inspection CHAR 1 0 QHPZ
EIN Serial Numbers Possible CHAR 1 0 QEINZ
ANZSN Number of serial numbers INT4 10 0 ANZSN
KZDYNERF Dynamic Modification Is Carried Out CHAR 1 0 QKZDYNERF
DYNHEAD Level at Which Dynamic Modification Parameters Are Defined CHAR 1 0 TQ39A QDYNHEAD
STPRVER Sampling Procedure CHAR 8 0 QDSV QSTPRVER
EXTNUM External Numbering of Units to Be Inspected CHAR 1 0 TQ12 QEXTNUM
STAFO Update Group for statistics update CHAR 6 0 TMCB STAFO
STAT30 Origin of Inspection Lot Unit of Measure for LIS Interface CHAR 1 0 QUNITORIGIN
Not defined
1 Base unit of measure for the material
2 Equipment/functional location
9 Deviating base unit of measure
QINFSTATUS QINF Status CHAR 8 0 QINFSTATUS
ENSTEHDAT Date in Time Zone Where Lot Created DATS 8 0 QENTST
ENTSTEZEIT Time in Time Zone Where Lot Created TIMS 6 0 QENTSTZEIT
ERSTELLER Name of User Who Created the Data Record CHAR 12 0 QERSTELLER
ERSTELDAT System Date on Which Data Record Was Created DATS 8 0 QDATUMERST
ERSTELZEIT System Time of Lot Creation TIMS 6 0 QERSTEZEIT
AENDERER Name of User Who Last Changed Data Record CHAR 12 0 QAENDERER
AENDERDAT System Date on Which Data Record Was Changed DATS 8 0 QDATUMAEND
AENDERZEIT System Time of Lot Change TIMS 6 0 QAENDEZEIT
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
PASTRTERM Start Date of Inspection in Local Time Zone DATS 8 0 QPRSTART
PASTRZEIT Inspection Start Time in Local Time Zone TIMS 6 0 QSTARTZEIT
PAENDTERM End Date of Inspection in Local Time Zone DATS 8 0 QPRENDE
PAENDZEIT Inspection End Time in Local Time Zone TIMS 6 0 QENDEZEIT
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PPLVERW Task List Usage CHAR 3 0 T411 PLN_VERWE
PLNAL Group Counter CHAR 2 0 PLNAL
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
ZKRIZ Counter for Additional Criteria NUMC 7 0 DZKRIZ
STAT15 Production Resource/Tool Saved for Insp. Lot CHAR 1 0 QFHM_MODE
SLWBEZ Identifier for Inspection Point Field Combination CHAR 3 0 TQ79 QSLWBEZ
STAT13 Inspection Point Type CHAR 1 0 QPPKTTYP
Freely-Defined Inspection Point
1 Inspection Point for Equipment
2 Inspection Point for Funct. Location
3 Inspection Point for Sample
4 Inspection Point for Serialized Material
PPKZTLZU Partial Lot Assignment in an Inspection During Production CHAR 1 0 QPPKZTLZU
Partial lot assignment according to plant default values
0 Partial lots not supported
1 Partial lot for each inspection point
2 Partial lot and batch for each inspection point
3 Partial lot for inspection points of 'last' inspection oper.
4 Partial lot and batch for insp. points of 'last' operation
ZAEHL1 Internal counter NUMC 8 0 CIM_COUNT
PRBNAVERF Sample-Drawing Procedure CHAR 8 0 QPRVK QPRZIEHVER
PRBNAVV Version No. of the Sample-Drawing Procedure CHAR 6 0 QVERSNPRZV
STAT12 Confirmation Required for Sample Drawing CHAR 1 0 QKZQUIT
SELMATNR Material Number CHAR 40 0 MARA MATNR
SELREVLV Revision Level CHAR 2 0 REVLV
SELWERK Plant CHAR 4 0 T001W WERKS_D
SELLIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
STAT17 Manufacturer Part No. Processing Active CHAR 1 0 QHERST
SELHERST Number of Manufacturer CHAR 10 0 LFA1 QLIFNR
SELKUNNR Account number of customer CHAR 10 0 KNA1 EKUNN
SELPPLVERW Task List Usage CHAR 3 0 T411 PLN_VERWE
GUELTIGAB Key Date for Selecting Records or Changing Task Lists DATS 8 0 QSTICHTAG
AUFNR Order Number CHAR 12 0 AUFK AUFNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
CUOBJ_CH Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
VERID Production Version CHAR 4 0 MKAL VERID
SA_AUFNR Run schedule header number CHAR 12 0 SAFK SA_AUFNR
CVP_XBLCK Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked
KUNNR Customer (Ship-To Party) CHAR 10 0 KNA1 QKUNWE
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
HERSTELLER Number of Manufacturer CHAR 10 0 LFA1 QLIFNR
EMATNR Material number corresponding to manufacturer part number CHAR 40 0 MARA EMATN
MATNR Material Number CHAR 40 0 MARA MATNR
REVLV Revision Level CHAR 2 0 REVLV
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
LAGORTCHRG Storage location CHAR 4 0 MCHB LGORT_D
ZEUGNISBIS Valid-To Date for Batch Certificate DATS 8 0 QZEUGBIS
VFDAT Shelf Life Expiration or Best-Before Date DATS 8 0 VFDAT
LICHN Supplier Batch Number CHAR 15 0 LICHN
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
PS_PSP_PNR Valuated Sales Order Stock WBS Element NUMC 8 0 PRPS MAT_PSPNR
KDAUF Sales order number of valuated sales order stock CHAR 10 0 MAT_KDAUF
KDPOS Sales Order Item of Valuated Sales Order Stock NUMC 6 0 MAT_KDPOS
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ETENR Delivery Schedule Line Counter NUMC 4 0 EKET EETEN
BLART Document Type CHAR 2 0 T003 BLART
MJAHR Material Document Year NUMC 4 0 MJAHR
MBLNR Number of Material Document CHAR 10 0 MBLNR
ZEILE Item in Material Document NUMC 4 0 MBLPO
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
WERKVORG Plant Where Stock for Inspection Lot Is Held CHAR 4 0 T001W QWERKVORG
LAGORTVORG Storage Location for Inspection Lot Stock CHAR 4 0 T001L QLGORTVORG
LGNUM Warehouse Number / Warehouse Complex CHAR 3 0 T300 LGNUM
LGTYP Storage Type CHAR 3 0 T301 LGTYP
LGPLA Storage Bin CHAR 10 0 LAGP LGPLA
LS_KDAUF Sales Order Number CHAR 10 0 KDAUF
LS_KDPOS Item number in Sales Order NUMC 6 0 KDPOS
LS_VBELN Delivery CHAR 10 0 VBELN_VL
LS_POSNR Delivery Item NUMC 6 0 POSNR_VL
LS_ABRVW Delivery Category CHAR 3 0 TVLV QABRVW
LS_ROUTE Route CHAR 6 0 TVRO ROUTE
LS_LLAND Destination Country/Region CHAR 3 0 T005 LLAND
LS_KUNAG Sold-to Party CHAR 10 0 KNA1 KUNAG
LS_VKORG Sales Organization CHAR 4 0 TVKO VKORG
LS_KDMAT Customer Material CHAR 35 0 KDMAT
SPRACHE Language Key LANG 1 0 T002 SPRAS
KTEXTLOS Short Text CHAR 40 0 QKURZTEXT
LTEXTKZ Long Text Exists For Inspection Lot CHAR 1 0 QLTEXTLOS
KTEXTMAT Short Text for Inspection Object CHAR 40 0 QKTEXTOBJ
LS_EQUNR Equipment Number CHAR 18 0 EQUNR
LS_TPLNR Functional Location CHAR 30 0 TPLNR
ZUSMKZAEHL Number of Characteristics Recorded Additionally INT2 5 0 QZUSMKZHL
OFFENNLZMK Number of Outstanding Short-Term Chars That Require Confirm. INT2 5 0 QOFFENLZMK
OFFEN_LZMK Number of Outstanding Long-Term Chars That Require Confirm. INT2 5 0 QOFFELZMK
LOSMENGE Inspection Lot Quantity QUAN 13 3 QLOSMENGE
MENGENEINH Base Unit of Measure for Inspection Lot Quantity UNIT 3 0 T006 QLOSMENGEH
ANZGEB QM - No. of Containers QUAN 6 3 QANZGEB
GEBEH Lot Container UNIT 3 0 T006 QGEBEH
LVS_STIKZ Indicator: what has happened to insp.sample (QM) in WM CHAR 1 0 LVS_STIKZ
Still no activity in WM for inspection sample
1 Inspection sample in WM transferred to sample storage bin
2 Inspection sample in WM left in GR area
3 Insp.sample in WM ignored; quantity in unknown storage bin
LVS_STIMG Sample in base unit of measure provided by WM QUAN 13 3 LVS_STIMG
GESSTICHPR Inspection Sample Size QUAN 13 3 QGESTICH
EINHPROBE Base Unit of Measure for Sample Unit UNIT 3 0 T006 QPROBEMGEH
DYNREGEL Dynamic Modification Rule CHAR 3 0 QDDR QDYNREGEL
STAT44 Time of Dynamic Modification in Inspection Lot CHAR 1 0 QDYNTIME
3.0 lot -> Determine time of dyn. modif. from dyn. mod. rule
1 Dynamic modification at the usage decision
X Dynamic modification at lot creation
PRSTUFE Inspection Stage NUMC 4 0 QDPS QPRSTUFE
PRSCHAERFE Inspection Severity NUMC 3 0 QDEP QPRSCHAERF
LMENGE01 Quantity Posted to Unrestricted-Use Stock QUAN 13 3 QLMENGE01F
LMENGE02 Quantity Posted to Scrap QUAN 13 3 QLMENGE02F
LMENGE03 Quantity Posted to Sample QUAN 13 3 QLMENGE03F
LMENGE04 Quantity Posted to Blocked Stock QUAN 13 3 QLMENGE04F
LMENGE05 Quantity Posted to Reserves QUAN 13 3 QLMENGE05F
LMENGE06 Quantity Posted to Another Material QUAN 13 3 QLMENGE06F
MATNRNEU Material Number to Which the Quantity is Posted CHAR 40 0 MARA QMATNRNEU
CHARGNEU Batch to Which Goods Are Transferred CHAR 10 0 MCH1 QCHARGNEU
LMENGE07 Quantity Returned to Vendor QUAN 13 3 QLMENGE07F
LMENGE08 Other Quantity Posted from Inspection Lot Stock QUAN 13 3 QLMENGE08F
LMENGE09 Other Quantity (2) Posted from Inspection Lot Stock QUAN 13 3 QLMENGE09F
LMENGEZUB Quantity That Must Be Posted QUAN 13 3 QLMENGEZUB
LMENGELZ Sample Quantity for Long-Term Characteristics QUAN 13 3 QLMENGELZ
LMENGEPR Quantity Actually Inspected QUAN 13 3 QLMENGEPR
LMENGEZER Quantity Destroyed During Inspection QUAN 13 3 QLMENGEZER
LMENGEIST Actual Lot Quantity QUAN 13 3 QLMENGEIST
LMENGESCH Defective Quantity in Inspected Quantity QUAN 13 3 QLMENGESCH
LTEXTKZBB Logs Exist for Usage Decision CHAR 1 0 QLTEXTKZBB
ANTEIL Share of Scrap in Inspection Lot FLTP 16 16 QAUSANTEIL
QKZVERF Procedure for Calculating Quality Score CHAR 2 0 TQ06 QKZVERF
STAT03 Usage Decision Mode (UD Origin) CHAR 1 0 QMODUS_UD
A UD using QM-IDI (interface)
B Automatic UD (Job Scheduling)
C Worklist (lists)
D UD using BAPI
E Other UD mode
F Automatic UD (Results Recording)
G Automatic UD with Inspection Completion (Job Scheduling)
H Automatic UD (Skip Lot)
QPMATLOS Allowed Share of Scrap FLTP 16 16 QPMATLOS
AUFNR_CO Order Number for Recording Appraisal Costs CHAR 12 0 AUFK QAUFNR_CO
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
PSTYP Item category in purchasing document CHAR 1 0 T163 PSTYP
STAT05 Account Assignment Key: Inspection Lot CHAR 1 0 QKZQALSKNT
A Cost center
B Order
C Project
D Cost object
E Network
F Real est.
G Sales order
H Profitability segment
I Fixed asset
J Reconciliation object
K Repetitive manufacturing
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
AUFPS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
KONT_PSPNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
NPLNR Network Number for Account Assignment CHAR 12 0 AUFK NPLNR
APLZL Internal counter NUMC 8 0 CIM_COUNT
KONT_KDAUF Sales Order Number CHAR 10 0 KDAUF
KONT_KDPOS Item number in Sales Order NUMC 6 0 KDPOS
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
KSTRG Cost Object CHAR 12 0 CKPH KSTRG
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
GSBER Business Area CHAR 4 0 TGSB GSBER
KONTO G/L Account Number CHAR 10 0 SKA1 SAKNR
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
BUKRS Company Code CHAR 4 0 T001 BUKRS
SERNP Serial Number Profile CHAR 4 0 T377P SERAIL
LOS_REF Inspection Lot Number Which Is Referenced NUMC 12 0 QALS QLOS_REF
BEARBSTATU Field Not Used as of 3.0 Field Reserved for SAP CHAR 2 0 Q_UNUSED02
STAT32 Inspection Lot for Stability Study CHAR 1 0 QSTABI
No inspection lot for stability study
1 Initial inspection
2 Inspection lot for storage condition (created automatically)
3 Inspection lot for storage condition (created manually)
STAT33 Indicator: Multiple Specifications CHAR 1 0 Q_MS_FLG
Insp. Plan/Assignment for Dependent Char. Specifications
X Inspection Plan/Assignment for Multiple Specifications
STAT36 Lot Has Partial Lots Without Insp. Point and Insp. Specs CHAR 1 0 QTLS_WO_INSPPOINT
STAT37 Inspection Lot Is Blocked for Archiving CHAR 1 0 QL_BLOCKED4ARCHIVING
STAT38 Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
STAT39 Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
STAT40 Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
STAT41 Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
STAT42 Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
STAT43 Inspection Lot Created for First Article Inspection CHAR 1 0 QINSP_FAI
Not Created for First Article Inspection
E Created for External First Article Inspection
F Created for First Article Inspection
MENGU Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
KZPZADR Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
KZPRADR Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
ZUSCH Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
ZUSTD Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
KZERSTLIEF Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
KZERSTMUST Field Not Used as of 3.0 Field Reserved for SAP CHAR 1 0 Q_UNUSED01
ADDON_DUMMY Dummy Field for ADDON Structures in QM CHAR 1 0 QDUMMY
WARPL Maintenance Plan CHAR 12 0 MPLA WARPL
WAPOS Maintenance item CHAR 16 0 WAPOS
ABNUM Maintenance Plan Call Number INT4 10 0 ABNUM
STRAT Maintenance Strategy CHAR 6 0 T351 STRAT
TRIALID Trial Number CHAR 12 0 RMXTE_TRIALID
RESPONSIBLE Responsible CHAR 45 0 ESEREALO
INSP_DOC_NUMBER Inspection Document Number from External System CHAR 30 0 QINSP_DOC_NUMBER
LOG_SYSTEM Logical system CHAR 10 0 LOGSYS
GESSTICHPR_EXT Sample Size from External System QUAN 13 3 QGESTICH_EXT
EINHPROBE_EXT Unit of Measure of External Sample UNIT 3 0 QPROBEMGEH_EXT
PRIO_PUNKTE Priority Points INT4 10 0 QPRIO_PUNKTE
SIGN_TYPE_RR Signature Type: Inspection Lot Results Recording CHAR 1 0 SIGN_TYPE_RR
SIGN_TYPE_UD Signature Type: Inspection Lot Usage Decision CHAR 1 0 SIGN_TYPE_UD
SIGN_TYPE_SM Signature Type: Sample Drawing CHAR 1 0 SIGN_TYPE_SM
SIGNSTRAT_RR Signature Strategy: Inspection Lot Results Recording CHAR 8 0 SIGNSTRAT_RR
SIGNSTRAT_UD Signature Strategy with Individual Signature: Usage Decision CHAR 8 0 SIGNSTRAT_UD
SIGNSTRAT_SM Signature Strategy w. Ind.Signature: Sample Drawing CHAR 8 0 SIGNSTRAT_SM
DUMMY_QALS_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
LOT_GUID Internal Identification for Inspection Lot RAW 16 0 QALS_GUID
SETUP_ORIG Origin of Inspection Lot Setup CHAR 1 0 QL_SETUP_ORIG
Setup from Material Master (QMAT)
I Setup from Inspection Rule
N Setup Without Inspection Rule
EWM_IS_LOCAL X and Blank CHAR 1 0 QKZ
Indicator is not set
X Indicator is set
CAT_FROM Stock Type CHAR 2 0 /LIME/STOCK_CATEGORY
CATLOCN_TO Inspection Rule Argument: Location-Independent Stock Type CHAR 2 0 * /SCWM/DE_QCATLOCN
PROCESS_STEP External Storage Process Step CHAR 4 0 * /SCWM/DE_PROCS
COO Country/Region of Origin CHAR 3 0 /SCWM/DE_COO
INSP_GROUP Quality Inspection Group CHAR 4 0 * /SCWM/DE_QGRP
INBOUND_PROC Inbound Inspection Process CHAR 1 0 /SCWM/DE_QINB_PROC
IOT_GUID GUID of Inspection Object Type RAW 16 0 QIE_TV_IOBTYP_GUID
RLGRP Inspection Rule Group CHAR 4 0 * /SCWM/DE_QRGRP
EXCCODE Exception Code CHAR 4 0 * /SCWM/DE_EXCCODE
WITHDRAWN_SAMPLE_QTY Withdrawn Quantity for External Sample Size QUAN 31 14 /SCWM/DE_QDOC_WITHDRAWN_SAMPLE
/CWM/LOSMENGE Inspection Lot Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/QLOSMENGE
/CWM/MENGENEINH Parallel Unit of Measure of Inspection Lot Quantity UNIT 3 0 * /CWM/QLOSMENGEH
/CWM/LMENGE01 Quantity in PUoM Posted to Unrestricted Stock QUAN 13 3 /CWM/QLMENGE01F
/CWM/LMENGE02 Quantity in PUoM Posted to Scrap QUAN 13 3 /CWM/QLMENGE02F
/CWM/LMENGE03 Quantity Posted to Sample QUAN 13 3 /CWM/QLMENGE03F
/CWM/LMENGE04 Quantity in PUoM Posted to Blocked Stock QUAN 13 3 /CWM/QLMENGE04F
/CWM/LMENGE05 Quantity in PUoM Posted to Reserves QUAN 13 3 /CWM/QLMENGE05F
/CWM/LMENGE06 Quantity in PUoM Posted to a Different Material QUAN 13 3 /CWM/QLMENGE06F
/CWM/LMENGE07 Quantity in PUoM Posted Back to Vendor QUAN 13 3 /CWM/QLMENGE07F
/CWM/LMENGE08 Other Posted Quantity in PUoM from Inspection Lot Stock QUAN 13 3 /CWM/QLMENGE08F
/CWM/LMENGE09 Second Other Posted Quant. from Inspection Lot Stock in PUoM QUAN 13 3 /CWM/QLMENGE09F
/CWM/LMENGEZUB Quantity to be Posted in PUoM QUAN 13 3 /CWM/QLMENGEZUB
/CWM/LMENGEIST Actual Lot Quantity in PUoM QUAN 13 3 /CWM/QLMENGEIST

QALS foreign key relationships

Table Field Check Table Check Field
0 QALS ANLN1 ANLH Main asset number BUKRS
0 QALS ANLN1 ANLH Main asset number ANLN1
1 QALS ANLN2 ANLA Asset Master Record Segment BUKRS
1 QALS ANLN2 ANLA Asset Master Record Segment ANLN1
1 QALS ANLN2 ANLA Asset Master Record Segment ANLN2
0 QALS ART TQ30 Inspection types MANDT
0 QALS ART TQ30 Inspection types ART
1 QALS AUFNR AUFK Order master data AUFNR
0 QALS AUFNR_CO AUFK Order master data AUFNR
1 QALS BLART T003 Document Types MANDT
0 QALS BUKRS T001 Company Codes BUKRS
1 QALS BWART T156 Movement Type MANDT
1 QALS BWART T156 Movement Type BWART
0 QALS CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
1 QALS CHARGNEU MCH1 Batches (if Batch Management Cross-Plant) MANDT
0 QALS DYNHEAD TQ39A Definition of dynamic modification level DYNLEVEL
1 QALS DYNREGEL QDDR Dynamic modification rule (header) MANDT
0 QALS EBELN EKKO Purchasing Document Header MANDT
0 QALS EBELN EKKO Purchasing Document Header EBELN
1 QALS EBELP EKPO Purchasing Document Item MANDT
1 QALS EBELP EKPO Purchasing Document Item EBELN
0 QALS EINHPROBE T006 Units of Measurement MSEHI
1 QALS EKORG T024E Purchasing Organizations EKORG
0 QALS EMATNR MARA General Material Data MATNR
1 QALS ETENR EKET Scheduling Agreement Schedule Lines MANDT
1 QALS ETENR EKET Scheduling Agreement Schedule Lines EBELN
1 QALS ETENR EKET Scheduling Agreement Schedule Lines EBELP
1 QALS ETENR EKET Scheduling Agreement Schedule Lines ETENR
0 QALS EXTNUM TQ12 Ind. external numbering for test units in results recording MANDT
0 QALS EXTNUM TQ12 Ind. external numbering for test units in results recording EXTNUM
1 QALS GEBEH T006 Units of Measurement MSEHI
0 QALS GSBER TGSB Business Areas MANDT
0 QALS GSBER TGSB Business Areas GSBER
1 QALS HERKUNFT TQ31 Inspection Lot Origins HERKUNFT
0 QALS HERSTELLER LFA1 Supplier Master (General Section) MANDT
0 QALS HERSTELLER LFA1 Supplier Master (General Section) LIFNR
1 QALS KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
1 QALS KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
0 QALS KOKRS TKA01 Controlling Areas MANDT
1 QALS KONTO SKA1 G/L Account Master (Chart of Accounts) MANDT
1 QALS KONTO SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 QALS KONTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 QALS KONT_PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 QALS KONT_PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 QALS KOSTL CSKS Cost Center Master Record MANDT
1 QALS KOSTL CSKS Cost Center Master Record KOKRS
1 QALS KOSTL CSKS Cost Center Master Record KOSTL
1 QALS KOSTL CSKS Cost Center Master Record DATBI
0 QALS KSTRG CKPH Master Record: Cost Object ID Number MANDT
0 QALS KSTRG CKPH Master Record: Cost Object ID Number KSTRG
0 QALS KSTRG CKPH Master Record: Cost Object ID Number DATBI
1 QALS KUNNR KNA1 General Data in Customer Master MANDT
1 QALS KUNNR KNA1 General Data in Customer Master KUNNR
0 QALS LAGORTCHRG MCHB Batch Stocks MANDT
0 QALS LAGORTCHRG MCHB Batch Stocks WERKS
0 QALS LAGORTCHRG MCHB Batch Stocks LGORT
0 QALS LAGORTCHRG MCHB Batch Stocks CHARG
1 QALS LAGORTVORG T001L Storage Locations MANDT
1 QALS LAGORTVORG T001L Storage Locations WERKS
0 QALS LGNUM T300 WM Warehouse Numbers MANDT
0 QALS LGNUM T300 WM Warehouse Numbers LGNUM
1 QALS LGPLA LAGP Storage bins MANDT
1 QALS LGPLA LAGP Storage bins LGNUM
1 QALS LGPLA LAGP Storage bins LGPLA
0 QALS LGTYP T301 WM Storage Types MANDT
0 QALS LGTYP T301 WM Storage Types LGNUM
0 QALS LGTYP T301 WM Storage Types LGTYP
1 QALS LIFNR LFA1 Supplier Master (General Section) MANDT
1 QALS LIFNR LFA1 Supplier Master (General Section) LIFNR
0 QALS LOS_REF QALS Inspection lot record MANDANT
1 QALS LS_ABRVW TVLV Check table for release orders: Usage ID ABRVW
0 QALS LS_KUNAG KNA1 General Data in Customer Master MANDT
0 QALS LS_KUNAG KNA1 General Data in Customer Master KUNNR
1 QALS LS_LLAND T005 Countries MANDT
1 QALS LS_LLAND T005 Countries LAND1
0 QALS LS_ROUTE TVRO Routes MANDT
0 QALS LS_ROUTE TVRO Routes ROUTE
1 QALS LS_VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 QALS LS_VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 QALS MANDANT T000 Clients MANDT
1 QALS MATNR MARA General Material Data MATNR
0 QALS MATNRNEU MARA General Material Data MATNR
1 QALS MENGENEINH T006 Units of Measurement MSEHI
0 QALS NPLNR AUFK Order master data AUFNR
1 QALS OBJNR ONR00 General Object Number MANDT
0 QALS OBTYP TJ03 Object types OBTYP
1 QALS PLNTY TCA01 Task list types MANDT
0 QALS PPLVERW T411 Task list usage MANDT
1 QALS PRBNAVERF QPRVK Sample-drawing procedure MANDT
1 QALS PRBNAVERF QPRVK Sample-drawing procedure VERSION
0 QALS PRCTR CEPC Profit Center Master Data Table PRCTR
0 QALS PRCTR CEPC Profit Center Master Data Table DATBI
0 QALS PRCTR CEPC Profit Center Master Data Table KOKRS
1 QALS PRSCHAERFE QDEP Allowed inspection severities MANDT
0 QALS PRSTUFE QDPS Inspection stages for a dynamic modification rule MANDT
0 QALS PRSTUFE QDPS Inspection stages for a dynamic modification rule DYNREGEL
0 QALS PRSTUFE QDPS Inspection stages for a dynamic modification rule PRSTUFE
1 QALS PSTYP T163 Item Categories in Purchasing Document MANDT
1 QALS PSTYP T163 Item Categories in Purchasing Document PSTYP
0 QALS PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 QALS PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 QALS QKZVERF TQ06 Procedure for Calculating the Quality Score QKZVERF
0 QALS QMATAUTH TQ01B Material authorization groups in quality management MANDT
0 QALS QMATAUTH TQ01B Material authorization groups in quality management QMATAUTH
1 QALS SA_AUFNR SAFK Run Schedule Master Data MANDT
1 QALS SA_AUFNR SAFK Run Schedule Master Data AUFNR
0 QALS SELHERST LFA1 Supplier Master (General Section) MANDT
0 QALS SELHERST LFA1 Supplier Master (General Section) LIFNR
1 QALS SELKUNNR KNA1 General Data in Customer Master MANDT
1 QALS SELKUNNR KNA1 General Data in Customer Master KUNNR
0 QALS SELLIFNR LFA1 Supplier Master (General Section) MANDT
0 QALS SELLIFNR LFA1 Supplier Master (General Section) LIFNR
1 QALS SELMATNR MARA General Material Data MATNR
0 QALS SELPPLVERW T411 Task list usage MANDT
1 QALS SELWERK T001W Plants/Branches MANDT
1 QALS SELWERK T001W Plants/Branches WERKS
0 QALS SERNP T377P Serial Number Management Profiles MANDT
1 QALS SLWBEZ TQ79 Table with inspection point/user field combinations MANDT
0 QALS SOBKZ T148 Special Stock Indicator MANDT
0 QALS SOBKZ T148 Special Stock Indicator SOBKZ
1 QALS SPRACHE T002 Language Keys (Component BC-I18) SPRAS
0 QALS STAFO TMCB Update groups MANDT
0 QALS STAFO TMCB Update groups STAFO
1 QALS STPRVER QDSV Sampling procedure MANDT
0 QALS STRAT T351 Maintenance strategy MANDT
1 QALS STSMA TJ20 Status profiles MANDT
1 QALS STSMA TJ20 Status profiles STSMA
0 QALS VERID MKAL Production Versions of Material WERKS
0 QALS VERID MKAL Production Versions of Material VERID
1 QALS WARPL MPLA Maintenance plan WARPL
0 QALS WERK T001W Plants/Branches MANDT
0 QALS WERK T001W Plants/Branches WERKS
1 QALS WERKVORG T001W Plants/Branches MANDT
1 QALS WERKVORG T001W Plants/Branches WERKS