QALS is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of QALS in SAP.
- Table description : Inspection lot record
- Module : CRM
- Parent Module : CRM
- Package : QL
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP QALS Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDANT | Client | MANDT | MANDT |
| PRUEFLOS | Inspection Lot Number | QPLOS | QPLOS |
| WERK | Plant | WERKS_D | WERKS |
| ART | Inspection Type | QPART | QPART |
| HERKUNFT | Inspection Lot Origin | QHERK | QHERK |
| OBJNR | Object number | J_OBJNR | J_OBJNR |
| OBTYP | Object Category | J_OBTYP | J_OBTYP |
| STSMA | Status Profile | J_STSMA | J_STSMA |
| QMATAUTH | Material authorization group for activities in QM | QMATAUTH | QMATAUTH |
| STAT11 | GR blocked stock | KZWES | KZWES |
| INSMK | Quantity Is or Was in Inspection Stock | QVINSMK | QKZ |
| STAT01 | Inspection Lot is Created Automatically | QSTAT01 | QKZ |
| STAT02 | Partial Lots Exist | QKZQALT | QKZ |
| STAT04 | Data Record Was Changed Using Customer Exit | QUSER_EXIT | QKZ |
| STAT06 | Record Appraisal Costs in Individual QM Order | QKZPRFKOST | QKZ |
| STAT07 | Inspection with Inspection Points | QKZFERTPRF | QKZ |
| STAT08 | Automatic Usage Decision Planned | QAUTO_VE | QKZ |
| STAT09 | Source Inspection | QABNAHMPRF | BSTYP |
| STAT10 | Inspection Specifications from Configuration | QCONF | QKZ |
| STAT14 | Completion of Short-Term Inspection | QSTAT14 | QKZ |
| STAT16 | Inspection Specifications from Batch Determination | QCHARG | QKZ |
| STAT18 | Control of Inspection Lot Creation (Lot Summary) | Q1WELOS | Q1WELOS |
| STAT19 | Documentation Required for Inspection Lot | QSTAT19 | QKZ |
| STAT20 | Inspection Plan Required | QSTAT20 | QKZ |
| STAT21 | Enter Sample Manually | QSTAT21 | QKZ |
| STAT22 | Inspect with Material Specification | QSPEZUEBER | QKZ |
| STAT23 | Inspection Lot Approval | QKZGENLOS | QKZGENLOS |
| STAT24 | Digital Signature for Insp. Lot in Results Recording | SIG_IL_RES | SIG_IL_RES |
| STAT25 | Digital Signature for Insp. Lot when Usage Decision Made | SIG_IL_USA | SIG_IL_USA |
| STAT29 | Digital Signature for Confirmation of Phys.-Sample Drawing | SIG_IL_SDR | SIG_IL_SDR |
| STAT26 | Indicator: Approved batch record required | XGCHP | XFELD |
| STAT27 | Inspection Lot is an R/2 Inspection Lot | QSTAT27 | QKZ |
| STAT28 | Select Characteristics Manually | QSTAT28 | QKZ |
| STAT31 | Trigger Sample Calculation Manually | QSTAT31 | QKZ |
| STAT34 | Stock Postings Completed | QSTAT34 | QKZ |
| STAT35 | Usage Decision Has Been Made | QSTAT35 | QKZ |
| STAT45 | Material as Dynamic Modification Criterion | QSTAT45 | QKZ |
| STAT46 | Vendor as Dynamic Modification Criterion | QSTAT46 | QKZ |
| STAT47 | Manufacturer as Dynamic Modification Criterion | QSTAT47 | QKZ |
| STAT48 | Customer as Dynamic Modification Criterion | QSTAT48 | QKZ |
| STAT49 | Machine as Dynamic Modification Criterion | QSTAT49 | QKZ |
| STAT50 | Project as Dynamic Modification Criterion | QSTAT50 | QKZ |
| KZSKIPLOT | Lot Skipped | QKZSKIPLOT | QKZ |
| DYN | Skips Allowed | QDYN | QKZ |
| HPZ | 100% Inspection | QHPZ | QKZ |
| EIN | Serial Number Management Possible | QEINZ | QKZ |
| ANZSN | Number of serial numbers | ANZSN | INT4 |
| KZDYNERF | Dynamic Modification Is Carried Out | QKZDYNERF | QKZ |
| DYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | QDYNHEAD | QDYNHEAD |
| STPRVER | Sampling Procedure | QSTPRVER | QSTPRVER |
| EXTNUM | External Numbering of Units to be Inspected | QEXTNUM | QEXTNUM |
| STAFO | Update group for statistics update | STAFO | STAFO |
| STAT30 | Origin of Inspection Lot Unit of Measure for LIS Interface | QUNITORIGIN | QUNITORIGIN |
| QINFSTATUS | QINF Status | QINFSTATUS | QINFSTATUS |
| ENSTEHDAT | Date of Lot Creation | QENTST | DATUM |
| ENTSTEZEIT | Time of Lot Creation | QENTSTZEIT | QZEIT |
| ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | QAENDERER |
| ERSTELDAT | Date on Which the Data Record Was Created | QDATUMERST | DATUM |
| ERSTELZEIT | Time of Lot Creation | QERSTEZEIT | QZEIT |
| AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | QAENDERER |
| AENDERDAT | Date on Which Data Record Was Changed | QDATUMAEND | DATUM |
| AENDERZEIT | Time of Lot Change | QAENDEZEIT | QZEIT |
| PASTRTERM | Inspection Start Date | QPRSTART | DATUM |
| PASTRZEIT | Inspection Start Time | QSTARTZEIT | QZEIT |
| PAENDTERM | End Date of the Inspection | QPRENDE | DATUM |
| PAENDZEIT | Inspection End Time | QENDEZEIT | QZEIT |
| PLNTY | Task List Type | PLNTY | PLNTY |
| PLNNR | Key for Task List Group | PLNNR | PLNNR |
| PPLVERW | Task list usage | PLN_VERWE | PLN_VERWE |
| PLNAL | Group Counter | PLNAL | ALTNR |
| ZAEHL | Internal counter | CIM_COUNT | CIM_COUNT |
| ZKRIZ | Counter for additional criteria | DZKRIZ | ZKRIZ |
| STAT15 | Production Resource/Tool Saved for Insp. Lot | QFHM_MODE | QKZ |
| SLWBEZ | Identification for the Inspection Point Field Combination | QSLWBEZ | QSLWBEZ |
| STAT13 | Inspection Point Type | QPPKTTYP | QPPKTTYP |
| PPKZTLZU | Partial Lot Assignment in an Inspection During Production | QPPKZTLZU | QPPKZTLZU |
| ZAEHL1 | Internal counter | CIM_COUNT | CIM_COUNT |
| PRBNAVERF | Sample-Drawing Procedure | QPRZIEHVER | QPRZIEHVER |
| PRBNAVV | Version No. of the Sample-Drawing Procedure | QVERSNPRZV | QVERSNR |
| STAT12 | Confirmation Required for Physical-Sample Drawing | QKZQUIT | QKZ |
| SELMATNR | Material Number | MATNR | MATNR |
| SELREVLV | Revision level | REVLV | REVLV |
| SELWERK | Plant | WERKS_D | WERKS |
| SELLIFNR | Vendor's account number | ELIFN | LIFNR |
| STAT17 | Manufacturer Part No. Processing Active | QHERST | QKZ |
| SELHERST | Number of Manufacturer | QLIFNR | LIFNR |
| SELKUNNR | Account number of customer | EKUNN | KUNNR |
| SELPPLVERW | Task list usage | PLN_VERWE | PLN_VERWE |
| GUELTIGAB | Key Date for Selecting Records or Changing Task Lists | QSTICHTAG | DATUM |
| AUFNR | Order Number | AUFNR | AUFNR |
| AUFPL | Routing number of operations in the order | CO_AUFPL | AUFPL |
| CUOBJ | Configuration (internal object number) | CUOBJ | CUOBJ |
| CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | CUOBJ |
| VERID | Production Version | VERID | VERID |
| SA_AUFNR | Run schedule header number | SA_AUFNR | SA_AUFNR |
| KUNNR | Customer (Ship-To Party) | QKUNWE | KUNNR |
| LIFNR | Vendor's account number | ELIFN | LIFNR |
| HERSTELLER | Number of Manufacturer | QLIFNR | LIFNR |
| EMATNR | Material number corresponding to manufacturer part number | EMATN | MATNR |
| MATNR | Material Number | MATNR | MATNR |
| REVLV | Revision level | REVLV | REVLV |
| XCHPF | Batch management requirement indicator | XCHPF | XFELD |
| CHARG | Batch Number | CHARG_D | CHARG |
| LAGORTCHRG | Storage location | LGORT_D | LGORT |
| ZEUGNISBIS | Valid-To Date for The Batch Certificate | QZEUGBIS | DATUM |
| VFDAT | Shelf Life Expiration or Best-Before Date | VFDAT | DATUM |
| LICHN | Vendor Batch Number | LICHN | LICHN |
| SOBKZ | Special Stock Indicator | SOBKZ | SOBKZ |
| PS_PSP_PNR | Valuated customer stock WBS element | MAT_PSPNR | PS_POSNR |
| KDAUF | Sales order number of valuated sales order stock | MAT_KDAUF | VBELN |
| KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUM06 |
| EKORG | Purchasing organization | EKORG | EKORG |
| EBELN | Purchasing Document Number | EBELN | EBELN |
| EBELP | Item Number of Purchasing Document | EBELP | EBELP |
| ETENR | Delivery Schedule Line Counter | EETEN | EETEN |
| BLART | Document type | BLART | BLART |
| MJAHR | Year of material document | MJAHR | GJAHR |
| MBLNR | Number of Material Document | MBLNR | BELNR |
| ZEILE | Item in material document | MBLPO | MBLPO |
| BUDAT | Posting Date in the Document | BUDAT | DATUM |
| BWART | Movement type (inventory management) | BWART | BWART |
| WERKVORG | Plant Where Stock for Inspection Lot Is Held | QWERKVORG | WERKS |
| LAGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | LGORT |
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | LGNUM |
| LGTYP | Storage Type | LGTYP | LGTYP |
| LGPLA | Storage Bin | LGPLA | LGPLA |
| LS_KDAUF | Sales Order Number | KDAUF | VBELN |
| LS_KDPOS | Item number in Sales Order | KDPOS | NUM06 |
| LS_VBELN | Delivery | VBELN_VL | VBELN |
| LS_POSNR | Delivery Item | POSNR_VL | POSNR |
| LS_ABRVW | Delivery Category | QABRVW | ABRVW |
| LS_ROUTE | Route | ROUTE | ROUTE |
| LS_LLAND | Destination Country | LLAND | LAND1 |
| LS_KUNAG | Sold-to party | KUNAG | KUNNR |
| LS_VKORG | Sales Organization | VKORG | VKORG |
| LS_KDMAT | Material belonging to the customer | KDMAT | IDNEX |
| SPRACHE | Language Key | SPRAS | SPRAS |
| KTEXTLOS | Short Text | QKURZTEXT | QKURZTEXT |
| LTEXTKZ | Long Text Exists For Inspection Lot | QLTEXTLOS | QKZ |
| KTEXTMAT | Short Text for Inspection Object | QKTEXTOBJ | QKURZTEXT |
| ZUSMKZAEHL | Number of Characteristics Recorded Additionally | QZUSMKZHL | INT2 |
| OFFENNLZMK | Number of Outstanding Short-Term Chars Which Require Conf. | QOFFENLZMK | INT2 |
| OFFEN_LZMK | Number of Outstanding Long-Term Chars Which Require Conf. | QOFFELZMK | INT2 |
| LOSMENGE | Inspection Lot Quantity | QLOSMENGE | QMENGEPLOS |
| MENGENEINH | Base Unit of Measure for The Inspection Lot Quantity | QLOSMENGEH | MEINS |
| ANZGEB | QM - No. of Containers | QANZGEB | QGEBPLOS |
| GEBEH | Lot Container | QGEBEH | MEINS |
| LVS_STIKZ | Indicator: what has happened to insp.sample (QM) in WM | LVS_STIKZ | LVS_STIKZ |
| LVS_STIMG | Sample in base unit of measure provided by WM | LVS_STIMG | MENG13 |
| GESSTICHPR | Sample Size | QGESTICH | QMENGEPLOS |
| EINHPROBE | Base Unit of Measure for the Sample Unit | QPROBEMGEH | MEINS |
| DYNREGEL | Dynamic Modification Rule | QDYNREGEL | QDYNREGEL |
| STAT44 | Time of Dynamic Modification in Inspection Lot | QDYNTIME | QDYNTIME |
| PRSTUFE | Inspection Stage | QPRSTUFE | QPRSTUFE |
| PRSCHAERFE | Inspection Severity | QPRSCHAERF | QPRSCHAERF |
| LMENGE01 | Quantity Posted to Unrestricted-Use Stock | QLMENGE01F | QMENGEPLOS |
| LMENGE02 | Quantity Posted to Scrap | QLMENGE02F | QMENGEPLOS |
| LMENGE03 | Quantity Posted to Sample | QLMENGE03F | QMENGEPLOS |
| LMENGE04 | Quantity Posted to Blocked Stock | QLMENGE04F | QMENGEPLOS |
| LMENGE05 | Quantity Posted to Reserves | QLMENGE05F | QMENGEPLOS |
| LMENGE06 | Quantity Posted to Another Material | QLMENGE06F | QMENGEPLOS |
| MATNRNEU | Material Number to Which the Quantity is Posted | QMATNRNEU | MATNR |
| CHARGNEU | Batch to Which Goods Are Transferred | QCHARGNEU | CHARG |
| LMENGE07 | Quantity Returned to Vendor | QLMENGE07F | QMENGEPLOS |
| LMENGE08 | Other Quantity Posted from Inspection Lot Stock | QLMENGE08F | QMENGEPLOS |
| LMENGE09 | Other Quantity (2) Posted from Inspection Lot Stock | QLMENGE09F | QMENGEPLOS |
| LMENGEZUB | Quantity That Must Be Posted | QLMENGEZUB | QMENGEPLOS |
| LMENGELZ | Sample Quantity for Long-Term Characteristics | QLMENGELZ | QMENGEPLOS |
| LMENGEPR | Quantity Actually Inspected | QLMENGEPR | QMENGEPLOS |
| LMENGEZER | Quantity Destroyed During Inspection | QLMENGEZER | QMENGEPLOS |
| LMENGEIST | Actual Lot Quantity | QLMENGEIST | QMENGEPLOS |
| LMENGESCH | Defective Quantity in Inspected Quantity | QLMENGESCH | QMENGEPLOS |
| LTEXTKZBB | Logs Exist for Usage Decision | QLTEXTKZBB | QKZ |
| ANTEIL | Share of Scrap in Inspection Lot | QAUSANTEIL | QFLTP16 |
| QKZVERF | Procedure for Calculating Quality Score | QKZVERF | QKZVERF |
| STAT03 | Usage Decision Mmode (UD Origin) | QMODUS_UD | QMODUS_UD |
| QPMATLOS | Allowed Share of Scrap | QPMATLOS | QPMATLOS |
| AUFNR_CO | Order Number for Recording Appraisal Costs | QAUFNR_CO | AUFNR |
| KZVBR | Consumption posting | KZVBR | KZVBR |
| KNTTP | Account assignment category | KNTTP | KNTTP |
| PSTYP | Item category in purchasing document | PSTYP | PSTYP |
| STAT05 | Account Assignment Key: Inspection Lot | QKZQALSKNT | QKZQALSKNT |
| KOSTL | Cost Center | KOSTL | KOSTL |
| AUFPS | Item Number of Reservation / Dependent Requirements | RSPOS | RSPOS |
| ANLN1 | Main Asset Number | ANLN1 | ANLN1 |
| ANLN2 | Asset Subnumber | ANLN2 | ANLN2 |
| KONT_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PS_POSNR |
| NPLNR | Network Number for Account Assignment | NPLNR | AUFNR |
| APLZL | Internal counter | CIM_COUNT | CIM_COUNT |
| KONT_KDAUF | Sales Order Number | KDAUF | VBELN |
| KONT_KDPOS | Item number in Sales Order | KDPOS | NUM06 |
| IMKEY | Internal Key for Real Estate Object | IMKEY | IMKEY |
| DABRZ | Reference date for settlement | DABRBEZ | DDAT |
| KSTRG | Cost Object | KSTRG | KSTRG |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | RKEOBJNR |
| PRCTR | Profit Center | PRCTR | PRCTR |
| GSBER | Business Area | GSBER | GSBER |
| KONTO | G/L Account Number | SAKNR | SAKNR |
| KOKRS | Controlling Area | KOKRS | CACCD |
| BUKRS | Company Code | BUKRS | BUKRS |
| SERNP | Serial Number Profile | SERAIL | SERAIL |
| LOS_REF | Inspection Lot Number Which Is Referenced | QLOS_REF | QPLOS |
| .INCLUDE | |||
| BEARBSTATU | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED02 | CHAR2 |
| STAT32 | Inspection lot for stability study | QSTABI | QSTABI |
| STAT33 | Indicator: Multiple Specifications | Q_MS_FLG | Q_MS_FLG |
| STAT36 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| STAT37 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| STAT38 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| STAT39 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| STAT40 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| STAT41 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| STAT42 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| STAT43 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| MENGU | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| KZPZADR | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| KZPRADR | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| ZUSCH | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| ZUSTD | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| KZERSTLIEF | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| KZERSTMUST | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR1 |
| .INCLUDE | PLM ADDON for Inspection Lot | ||
| ADDON_DUMMY | Dummy Field for ADDON Structures in QM | QDUMMY | QDUMMY |
| .INCLU--AP | Addon Fields for Table QALS for the Stability Study | ||
| WARPL | Maintenance Plan | WARPL | WARPL |
| WAPOS | Maintenance item | WAPOS | POSNU |
| ABNUM | Maintenance Plan Call Number | ABNUM | ABNUM |
| STRAT | Maintenance strategy | STRAT | WSTRA |
| .INCLU--AP | Additional Data for Trial Management | ||
| TRIALID | Trial Number | RMXTE_TRIALID | RMXTD_TRIALID |
| RESPONSIBLE | Responsible | ESEREALO | CHAR45 |
| INSP_DOC_NUMBER | Inspection Document Number from External System | QINSP_DOC_NUMBER | QPLEXT_INSP_DOC_NUMBER |
| LOG_SYSTEM | Logical system | LOGSYS | LOGSYS |
| GESSTICHPR_EXT | Sample Size from External System | QGESTICH_EXT | QPLEXT_PROBEMNG |
| EINHPROBE_EXT | Unit of Measure of External Sample | QPROBEMGEH_EXT | QPLEXT_PROBEMGEH |
| PRIO_PUNKTE | Priority Points | QPRIO_PUNKTE | QPLEXT_PRIOP |
| SIGN_TYPE_RR | Signature Type: Inspection Lot Results Recording | SIGN_TYPE_RR | SIGN_TYPE |
| SIGN_TYPE_UD | Signature Type: Inspection Lot Usage Decision | SIGN_TYPE_UD | SIGN_TYPE_SINGLE |
| SIGN_TYPE_SM | Signature Type: Physical-Sample Drawing | SIGN_TYPE_SM | SIGN_TYPE_SINGLE |
| SIGNSTRAT_RR | Signature Strategy: Inspection Lot Results Recording | SIGNSTRAT_RR | SIGNSTRAT |
| SIGNSTRAT_UD | Signature Strategy with Individual Signature: Usage Decision | SIGNSTRAT_UD | SIGNSTRAT |
| SIGNSTRAT_SM | Signature Strategy w. Ind.Signature: Physical-Sample Drawing | SIGNSTRAT_SM | SIGNSTRAT |
QALS related tables
| Table | Note |
|---|---|
| QALS | Inspection lot record |
| DFKKMDUGP | Master Data Lot: Items of the Groups of a Lot |
| QAMB | QM: Link Between Inspection Lot and Material Document |
| QMHU | QM Link Between Inspection Lot and Handling Unit Item |
| REBR4 | EBR: Inspection Scope of Insp. Lot in Deviation Analysis |
| S072 | Individual Records for Inspection Lot |
| S290 | BW: Inspection Lot/Usage Dec. |
| S290BIW1 | S290BIW1 * BW: Inspection Lot/Usage Decision |
| S290BIW2 | S290BIW2 * BW: Inspection Lot/Usage Decision |
| SER04 | Document Header for Serial Numbers for Inspection Lot |
| TC73 | Digital Signature for Inspection Lot |
| TQ07 | Follow-Up Action for Usage Decision of Inspection Lot |
| TQ31 | Inspection Lot Origins |
| TQ31T | Descriptions of Inspection Lot Origins |
| TQ55 | Assign inspection lot origin for update group |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP