SAP table QASH (Quality control chart)

SAP table QASH has 2 primary key fields being MANDT,QRKNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
QRKNR Control Chart Number NUMC 12 0 QQRKNR
QRKART Control Chart Type CHAR 3 0 QPSH QQRKART
SPCKRIT SPC Criterion CHAR 3 0 QPSP QSPCKRIT
WERK Plant CHAR 4 0 T001W WERKS_D
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNAL Group Counter CHAR 2 0 PLNAL
PLNFL Sequence CHAR 6 0 PLNFOLGE
PLNKN Number of the Task List Node NUMC 8 0 PLNKN
PLMKNR Inspection Characteristic Number NUMC 4 0 QMERKNRP
QPMK_WERKS Plant for the Master Inspection Characteristic CHAR 4 0 QZAEHLER
VERWMERKM Master Inspection Characteristic CHAR 8 0 QPMK QMERKNR
LSART Inspection Type CHAR 8 0 TQ30 QPART
LSHERKUNFT Inspection Lot Origin CHAR 2 0 QHERK
LSPRUEFLOS Inspection Lot Number NUMC 12 0 QALS QPLOS
LSAUFNR Order Number CHAR 12 0 AUFK AUFNR
POPLATZ Work Center CHAR 8 0 QPRPLATZ
POPLATZWRK Plant CHAR 4 0 T001W WERKS_D
PPEQUNR Equipment Number CHAR 18 0 EQUI EQUNR
PPTPLNR Functional Location CHAR 30 0 IFLOT TPLNR
LSMATNR Material Number CHAR 40 0 MARA MATNR
LSCHARG Batch Number CHAR 10 0 MCH1 CHARG_D
LSLIFCH Supplier Batch Number CHAR 15 0 LICHN
LSLIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LSHERST Number of Manufacturer CHAR 10 0 LFA1 QLIFNR
LSKUNNR Customer (Ship-To Party) CHAR 10 0 KNA1 QKUNWE
LSEBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
LSEBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
LSKDAUF Sales Order Number CHAR 10 0 KDAUF
LSKDPOS Item number in Sales Order NUMC 6 0 KDPOS
LSLLAND Destination Country/Region CHAR 3 0 T005 LLAND
LSKUNAG Sold-to Party CHAR 10 0 KNA1 KUNAG
VORNR Operation/Activity Number CHAR 4 0 VORNR
KURZTEXT Short Text CHAR 40 0 QKURZTEXT
STATUS Control Chart Status NUMC 1 0 QQRKSTATUS
1 New
3 Active
5 Completed
ENAME Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
EDATUM System Date on Which Data Record Was Created DATS 8 0 QDATUMERST
EZEIT System Time at Which Data Record Was Created TIMS 6 0 QZEITERSTL
ANAME Name of Person Who Changed Object CHAR 12 0 AENAM
ADATUM System Date on Which Data Record Was Changed DATS 8 0 QDATUMAEND
AZEIT System Time at Which Data Record Was Changed TIMS 6 0 QZEITAEND
SOLLWERT Target Value for a Quantitative Characteristic FLTP 16 16 QSOLLWERTE
TOLERANZOB Upper Specification Limit FLTP 16 16 QTOLOB
TOLERANZUN Lower Specification Limit FLTP 16 16 QTOLUN
GRENZEOB1 First Upper Specification Limit FLTP 16 16 QGRENZOB1
GRENZEUN1 First Lower Specification Limit FLTP 16 16 QGRENZUN1
GRENZEOB2 Second Upper Specification Limit FLTP 16 16 QGRENZOB2
GRENZEUN2 Second Lower Specification Limit FLTP 16 16 QGRENZUN2
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) INT1 3 0 QSTELLEN
0 To a maximum of 10 decimal places
SOLLWNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZOB1NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZUN1NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZOB2NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZUN2NI Value Not Initial if Set CHAR 1 0 QNINITIAL
DUMMY10 Text Line for Additional Information CHAR 10 0 QTXT10
DUMMY20 Text Line for Additional Information CHAR 20 0 QTXT20
DUMMY40 Text Line for Additional Information CHAR 40 0 QTXT40

QASH foreign key relationships

Table Field Check Table Check Field
0 QASH LSART TQ30 Inspection types MANDT
0 QASH LSART TQ30 Inspection types ART
1 QASH LSAUFNR AUFK Order master data AUFNR
0 QASH LSCHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
1 QASH LSEBELN EKKO Purchasing Document Header MANDT
1 QASH LSEBELN EKKO Purchasing Document Header EBELN
0 QASH LSEBELP EKPO Purchasing Document Item MANDT
0 QASH LSEBELP EKPO Purchasing Document Item EBELN
1 QASH LSHERST LFA1 Supplier Master (General Section) MANDT
1 QASH LSHERST LFA1 Supplier Master (General Section) LIFNR
0 QASH LSKUNAG KNA1 General Data in Customer Master MANDT
0 QASH LSKUNAG KNA1 General Data in Customer Master KUNNR
1 QASH LSKUNNR KNA1 General Data in Customer Master MANDT
1 QASH LSKUNNR KNA1 General Data in Customer Master KUNNR
0 QASH LSLIFNR LFA1 Supplier Master (General Section) MANDT
0 QASH LSLIFNR LFA1 Supplier Master (General Section) LIFNR
1 QASH LSLLAND T005 Countries MANDT
1 QASH LSLLAND T005 Countries LAND1
0 QASH LSMATNR MARA General Material Data MANDT
0 QASH LSMATNR MARA General Material Data MATNR
1 QASH LSPRUEFLOS QALS Inspection lot record MANDANT
0 QASH PLNTY TCA01 Task list types MANDT
1 QASH POPLATZWRK T001W Plants/Branches MANDT
1 QASH POPLATZWRK T001W Plants/Branches WERKS
0 QASH PPEQUNR EQUI Equipment master data MANDT
1 QASH QRKART QPSH Control chart types MANDT
1 QASH QRKART QPSH Control chart types QRKART
0 QASH SPCKRIT QPSP SPC criterion MANDT
0 QASH SPCKRIT QPSP SPC criterion SPCKRIT
1 QASH VERWMERKM QPMK Inspection characteristic master MANDT
1 QASH VERWMERKM QPMK Inspection characteristic master ZAEHLER
1 QASH VERWMERKM QPMK Inspection characteristic master VERSION
0 QASH WERK T001W Plants/Branches WERKS