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 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||
| 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 |
Possible values
|
||||||||
| SOLLWNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| TOLOBNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| TOLUNNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| GRENZOB1NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| GRENZUN1NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| GRENZOB2NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| GRENZUN2NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| 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 | LSART | TQ30 | Inspection types | ART |
| QASH | LSART | QASH | MANDT | TQ30 | Inspection types | MANDT |
| QASH | LSAUFNR | QASH | MANDT | AUFK | Order master data | MANDT |
| QASH | LSAUFNR | QASH | LSAUFNR | AUFK | Order master data | AUFNR |
| 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 | LSCHARG | QASH | LSMATNR | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
| QASH | LSEBELN | QASH | MANDT | EKKO | Purchasing Document Header | MANDT |
| QASH | LSEBELN | QASH | LSEBELN | EKKO | Purchasing Document Header | EBELN |
| QASH | LSEBELP | QASH | MANDT | EKPO | Purchasing Document Item | MANDT |
| QASH | LSEBELP | QASH | LSEBELN | EKPO | Purchasing Document Item | EBELN |
| QASH | LSEBELP | QASH | LSEBELP | EKPO | Purchasing Document Item | EBELP |
| QASH | LSHERST | QASH | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| QASH | LSHERST | QASH | LSHERST | LFA1 | Vendor Master (General Section) | LIFNR |
| 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 | LSKUNAG | KNA1 | General Data in Customer Master | KUNNR |
| QASH | LSKUNAG | QASH | MANDT | KNA1 | General Data in Customer Master | MANDT |
| 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 | LSLIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| QASH | LSLIFNR | QASH | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| 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 | VERWMERKM | QPMK | Inspection characteristic master | MKMNR |
| QASH | VERWMERKM | * | QPMK | Inspection characteristic master | VERSION | |
| QASH | VERWMERKM | QASH | MANDT | QPMK | Inspection characteristic master | MANDT |
| QASH | VERWMERKM | QASH | QPMK_WERKS | QPMK | Inspection characteristic master | ZAEHLER |
| QASH | WERK | QASH | MANDT | T001W | Plants/Branches | MANDT |
| QASH | WERK | QASH | WERK | T001W | Plants/Branches | WERKS |
