SAP Table QASH
Quality control chart
QASH (Quality control chart) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link QASH to other SAP tables.
QASH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
QRKNR
Control Chart Number
|
QQRKNR |
NUMC
|
12 | 0 | ||||||||||
|
QRKART
Control Chart Type
|
QQRKART | QPSH |
CHAR
|
3 | 0 | |||||||||
|
SPCKRIT
SPC Criterion
|
QSPCKRIT | QPSP |
CHAR
|
3 | 0 | |||||||||
|
WERK
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||
|
PLNTY
Task List Type
|
PLNTY | TCA01 |
CHAR
|
1 | 0 | |||||||||
|
PLNNR
Key for Task List Group
|
PLNNR |
CHAR
|
8 | 0 | ||||||||||
|
PLNAL
Group Counter
|
PLNAL |
CHAR
|
2 | 0 | ||||||||||
|
PLNFL
Sequence
|
PLNFOLGE |
CHAR
|
6 | 0 | ||||||||||
|
PLNKN
Number of the task list node
|
PLNKN |
NUMC
|
8 | 0 | ||||||||||
|
PLMKNR
Inspection Characteristic Number
|
QMERKNRP |
NUMC
|
4 | 0 | ||||||||||
|
QPMK_WERKS
Plant for the Master Inspection Characteristic
|
QZAEHLER |
CHAR
|
4 | 0 | ||||||||||
|
VERWMERKM
Master Inspection Characteristics
|
QMERKNR | QPMK |
CHAR
|
8 | 0 | |||||||||
|
LSART
Inspection Type
|
QPART | TQ30 |
CHAR
|
8 | 0 | |||||||||
|
LSHERKUNFT
Inspection Lot Origin
|
QHERK |
CHAR
|
2 | 0 | ||||||||||
|
LSPRUEFLOS
Inspection Lot Number
|
QPLOS | QALS |
NUMC
|
12 | 0 | |||||||||
|
LSAUFNR
Order Number
|
AUFNR | AUFK |
CHAR
|
12 | 0 | |||||||||
|
POPLATZ
Work Center
|
QPRPLATZ |
CHAR
|
8 | 0 | ||||||||||
|
POPLATZWRK
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||
|
PPEQUNR
Equipment Number
|
EQUNR | EQUI |
CHAR
|
18 | 0 | |||||||||
|
PPTPLNR
Functional Location
|
TPLNR | IFLOT |
CHAR
|
30 | 0 | |||||||||
|
LSMATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||
|
LSCHARG
Batch Number
|
CHARG_D | MCH1 |
CHAR
|
10 | 0 | |||||||||
|
LSLIFCH
Vendor Batch Number
|
LICHN |
CHAR
|
15 | 0 | ||||||||||
|
LSLIFNR
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
LSHERST
Number of Manufacturer
|
QLIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
LSKUNNR
Customer (Ship-To Party)
|
QKUNWE | KNA1 |
CHAR
|
10 | 0 | |||||||||
|
LSEBELN
Purchasing Document Number
|
EBELN | EKKO |
CHAR
|
10 | 0 | |||||||||
|
LSEBELP
Item Number of Purchasing Document
|
EBELP | EKPO |
NUMC
|
5 | 0 | |||||||||
|
LSKDAUF
Sales Order Number
|
KDAUF | VBUK |
CHAR
|
10 | 0 | |||||||||
|
LSKDPOS
Item Number in Sales Order
|
KDPOS |
NUMC
|
6 | 0 | ||||||||||
|
LSLLAND
Country of Destination
|
LLAND | T005 |
CHAR
|
3 | 0 | |||||||||
|
LSKUNAG
Sold-to party
|
KUNAG | KNA1 |
CHAR
|
10 | 0 | |||||||||
|
VORNR
Operation/Activity Number
|
VORNR |
CHAR
|
4 | 0 | ||||||||||
|
KURZTEXT
Short Text
|
QKURZTEXT |
CHAR
|
40 | 0 | ||||||||||
|
STATUS
Control Chart Status
|
QQRKSTATUS |
NUMC
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ENAME
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||
|
EDATUM
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||
|
EZEIT
Time at which data record was created
|
QZEITERSTL |
TIMS
|
6 | 0 | ||||||||||
|
ANAME
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||
|
ADATUM
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||
|
AZEIT
Time at which data record was last changed
|
QZEITAEND |
TIMS
|
6 | 0 | ||||||||||
|
SOLLWERT
Target Value for a Quantitative Characteristic
|
QSOLLWERTE |
FLTP
|
16 | 16 | ||||||||||
|
TOLERANZOB
Upper Specification Limit
|
QTOLOB |
FLTP
|
16 | 16 | ||||||||||
|
TOLERANZUN
Lower Tolerance Limit
|
QTOLUN |
FLTP
|
16 | 16 | ||||||||||
|
GRENZEOB1
First Upper Specification Limit
|
QGRENZOB1 |
FLTP
|
16 | 16 | ||||||||||
|
GRENZEUN1
First Lower Specification Limit
|
QGRENZUN1 |
FLTP
|
16 | 16 | ||||||||||
|
GRENZEOB2
Second Upper Specification Limit
|
QGRENZOB2 |
FLTP
|
16 | 16 | ||||||||||
|
GRENZEUN2
Second Lower Specification Limit
|
QGRENZUN2 |
FLTP
|
16 | 16 | ||||||||||
|
STELLEN
Number of Places to the Right of a Decimal Point (Accuracy)
|
QSTELLEN |
INT1
|
3 | 0 | ||||||||||
|
||||||||||||||
|
SOLLWNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TOLOBNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TOLUNNI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
GRENZOB1NI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
GRENZUN1NI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
GRENZOB2NI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
GRENZUN2NI
Value Not Initial if Set
|
QNINITIAL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
DUMMY10
Text Line for Additional Information
|
QTXT10 |
CHAR
|
10 | 0 | ||||||||||
|
DUMMY20
Text Line for Additional Information
|
QTXT20 |
CHAR
|
20 | 0 | ||||||||||
|
DUMMY40
Text Line for Additional Information
|
QTXT40 |
CHAR
|
40 | 0 | ||||||||||
QASH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QASH | LSART | QASH | MANDT |
TQ30
Inspection types
|
MANDT |
| QASH | LSART | QASH | LSART |
TQ30
Inspection types
|
ART |
| QASH | LSAUFNR | QASH | MANDT |
AUFK
Order master data
|
MANDT |
| QASH | LSAUFNR | QASH | LSAUFNR |
AUFK
Order master data
|
AUFNR |
| QASH | LSCHARG | QASH | LSMATNR |
MCH1
Batches (if Batch Management Cross-Plant)
|
MATNR |
| QASH | LSCHARG | QASH | LSCHARG |
MCH1
Batches (if Batch Management Cross-Plant)
|
CHARG |
| QASH | LSCHARG | QASH | MANDT |
MCH1
Batches (if Batch Management Cross-Plant)
|
MANDT |
| QASH | LSEBELN | QASH | MANDT |
EKKO
Purchasing Document Header
|
MANDT |
| QASH | LSEBELN | QASH | LSEBELN |
EKKO
Purchasing Document Header
|
EBELN |
| QASH | LSEBELP | QASH | LSEBELP |
EKPO
Purchasing Document Item
|
EBELP |
| QASH | LSEBELP | QASH | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| QASH | LSEBELP | QASH | LSEBELN |
EKPO
Purchasing Document Item
|
EBELN |
| QASH | LSHERST | QASH | LSHERST |
LFA1
Vendor Master (General Section)
|
LIFNR |
| QASH | LSHERST | QASH | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| QASH | LSKDAUF | QASH | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| QASH | LSKDAUF | QASH | LSKDAUF |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| QASH | LSKUNAG | QASH | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| QASH | LSKUNAG | QASH | LSKUNAG |
KNA1
General Data in Customer Master
|
KUNNR |
| QASH | LSKUNNR | QASH | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| QASH | LSKUNNR | QASH | LSKUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| QASH | LSLIFNR | QASH | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| QASH | LSLIFNR | QASH | LSLIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| QASH | LSLLAND | QASH | MANDT |
T005
Countries
|
MANDT |
| QASH | LSLLAND | QASH | LSLLAND |
T005
Countries
|
LAND1 |
| QASH | LSMATNR | QASH | MANDT |
MARA
General Material Data
|
MANDT |
| QASH | LSMATNR | QASH | LSMATNR |
MARA
General Material Data
|
MATNR |
| QASH | LSPRUEFLOS | QASH | MANDT |
QALS
Inspection lot record
|
MANDANT |
| QASH | LSPRUEFLOS | QASH | LSPRUEFLOS |
QALS
Inspection lot record
|
PRUEFLOS |
| QASH | MANDT | QASH | MANDT |
T000
Clients
|
MANDT |
| QASH | PLNTY | QASH | MANDT |
TCA01
Task list types
|
MANDT |
| QASH | PLNTY | QASH | PLNTY |
TCA01
Task list types
|
PLNTY |
| QASH | POPLATZWRK | QASH | MANDT |
T001W
Plants/Branches
|
MANDT |
| QASH | POPLATZWRK | QASH | POPLATZWRK |
T001W
Plants/Branches
|
WERKS |
| QASH | PPEQUNR | QASH | MANDT |
EQUI
Equipment master data
|
MANDT |
| QASH | PPEQUNR | QASH | PPEQUNR |
EQUI
Equipment master data
|
EQUNR |
| QASH | PPTPLNR | QASH | MANDT |
IFLOT
Functional Location (Table)
|
MANDT |
| QASH | PPTPLNR | QASH | PPTPLNR |
IFLOT
Functional Location (Table)
|
TPLNR |
| QASH | QRKART | QASH | MANDT |
QPSH
Control chart types
|
MANDT |
| QASH | QRKART | QASH | QRKART |
QPSH
Control chart types
|
QRKART |
| QASH | SPCKRIT | QASH | MANDT |
QPSP
SPC criterion
|
MANDT |
| QASH | SPCKRIT | QASH | SPCKRIT |
QPSP
SPC criterion
|
SPCKRIT |
| QASH | VERWMERKM | QASH | QPMK_WERKS |
QPMK
Inspection characteristic master
|
ZAEHLER |
| QASH | VERWMERKM | QASH | VERWMERKM |
QPMK
Inspection characteristic master
|
MKMNR |
| QASH | VERWMERKM | * |
QPMK
Inspection characteristic master
|
VERSION | |
| QASH | VERWMERKM | QASH | MANDT |
QPMK
Inspection characteristic master
|
MANDT |
| QASH | WERK | QASH | WERK |
T001W
Plants/Branches
|
WERKS |
| QASH | WERK | QASH | MANDT |
T001W
Plants/Branches
|
MANDT |