QASH

Transparent Table Application Table
60 Fields 1 CDS Views

Quality control chart

QASH is an SAP database table in S/4HANA. Quality control chart. It contains 60 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_QualityControlChart view from BASIC Quality Control Chart

Fields (60)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY qrknr QQRKNR Control Chart
qrkart QQRKART Ctrl Chart Type
spckrit QSPCKRIT SPC Criterion
werk WERKS_D Plant
plnty PLNTY Task List Type
plnnr PLNNR Group
plnal PLNAL Group Counter
plnfl PLNFOLGE Sequence
plnkn PLNKN Node
plmknr QMERKNRP Characteristic
qpmk_werks QZAEHLER Plant
verwmerkm QMERKNR Master IC
lsart QPART Inspection Type
lsherkunft QHERK Insp. Lot Orig.
lsprueflos QPLOS Inspection Lot
lsaufnr AUFNR Order
poplatz QPRPLATZ Work Center
poplatzwrk WERKS_D Plant
ppequnr EQUNR Equipment
pptplnr TPLNR Functional loc.
lsmatnr MATNR Material
lscharg CHARG_D Batch
lslifch LICHN Supplier Batch
lslifnr LIFNR Supplier
lsherst QLIFNR Manufacturer
lskunnr QKUNWE Customer
lsebeln EBELN Purchasing Doc.
lsebelp EBELP Item
lskdauf KDAUF Sales Order
lskdpos KDPOS Sales Ord. Item
lslland LLAND Dest. Ctry/Reg
lskunag KUNAG Sold-to Party
vornr VORNR Activity
kurztext QKURZTEXT Short Text
status QQRKSTATUS Status
ename ERNAM Created By
edatum QDATUMERST Created On
ezeit QZEITERSTL Time
aname AENAM Changed By
adatum QDATUMAEND Changed On
azeit QZEITAEND Time
sollwert QSOLLWERTE Target Value
toleranzob QTOLOB Upper Limit
toleranzun QTOLUN Lower Limit
grenzeob1 QGRENZOB1 1st Upper Limit
grenzeun1 QGRENZUN1 1st Lower Limit
grenzeob2 QGRENZOB2 2nd Upper Limit
grenzeun2 QGRENZUN2 2nd Lower Limit
stellen QSTELLEN Decimal Places
sollwni QNINITIAL Not Initial
tolobni QNINITIAL Not Initial
tolunni QNINITIAL Not Initial
grenzob1ni QNINITIAL Not Initial
grenzun1ni QNINITIAL Not Initial
grenzob2ni QNINITIAL Not Initial
grenzun2ni QNINITIAL Not Initial
dummy10 QTXT10 Info Field 1
dummy20 QTXT20 Info Field 2
dummy40 QTXT40 Info Field 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Quality control chart
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QASH (
    MANDT,       -- Client [MANDT]
    QRKNR,       -- Control Chart [QQRKNR]
    QRKART,      -- Ctrl Chart Type [QQRKART]
    SPCKRIT,     -- SPC Criterion [QSPCKRIT]
    WERK,        -- Plant [WERKS_D]
    PLNTY,       -- Task List Type [PLNTY]
    PLNNR,       -- Group [PLNNR]
    PLNAL,       -- Group Counter [PLNAL]
    PLNFL,       -- Sequence [PLNFOLGE]
    PLNKN,       -- Node [PLNKN]
    PLMKNR,      -- Characteristic [QMERKNRP]
    QPMK_WERKS,  -- Plant [QZAEHLER]
    VERWMERKM,   -- Master IC [QMERKNR]
    LSART,       -- Inspection Type [QPART]
    LSHERKUNFT,  -- Insp. Lot Orig. [QHERK]
    LSPRUEFLOS,  -- Inspection Lot [QPLOS]
    LSAUFNR,     -- Order [AUFNR]
    POPLATZ,     -- Work Center [QPRPLATZ]
    POPLATZWRK,  -- Plant [WERKS_D]
    PPEQUNR,     -- Equipment [EQUNR]
    PPTPLNR,     -- Functional loc. [TPLNR]
    LSMATNR,     -- Material [MATNR]
    LSCHARG,     -- Batch [CHARG_D]
    LSLIFCH,     -- Supplier Batch [LICHN]
    LSLIFNR,     -- Supplier [LIFNR]
    LSHERST,     -- Manufacturer [QLIFNR]
    LSKUNNR,     -- Customer [QKUNWE]
    LSEBELN,     -- Purchasing Doc. [EBELN]
    LSEBELP,     -- Item [EBELP]
    LSKDAUF,     -- Sales Order [KDAUF]
    LSKDPOS,     -- Sales Ord. Item [KDPOS]
    LSLLAND,     -- Dest. Ctry/Reg [LLAND]
    LSKUNAG,     -- Sold-to Party [KUNAG]
    VORNR,       -- Activity [VORNR]
    KURZTEXT,    -- Short Text [QKURZTEXT]
    STATUS,      -- Status [QQRKSTATUS]
    ENAME,       -- Created By [ERNAM]
    EDATUM,      -- Created On [QDATUMERST]
    EZEIT,       -- Time [QZEITERSTL]
    ANAME,       -- Changed By [AENAM]
    ADATUM,      -- Changed On [QDATUMAEND]
    AZEIT,       -- Time [QZEITAEND]
    SOLLWERT,    -- Target Value [QSOLLWERTE]
    TOLERANZOB,  -- Upper Limit [QTOLOB]
    TOLERANZUN,  -- Lower Limit [QTOLUN]
    GRENZEOB1,   -- 1st Upper Limit [QGRENZOB1]
    GRENZEUN1,   -- 1st Lower Limit [QGRENZUN1]
    GRENZEOB2,   -- 2nd Upper Limit [QGRENZOB2]
    GRENZEUN2,   -- 2nd Lower Limit [QGRENZUN2]
    STELLEN,     -- Decimal Places [QSTELLEN]
    SOLLWNI,     -- Not Initial [QNINITIAL]
    TOLOBNI,     -- Not Initial [QNINITIAL]
    TOLUNNI,     -- Not Initial [QNINITIAL]
    GRENZOB1NI,  -- Not Initial [QNINITIAL]
    GRENZUN1NI,  -- Not Initial [QNINITIAL]
    GRENZOB2NI,  -- Not Initial [QNINITIAL]
    GRENZUN2NI,  -- Not Initial [QNINITIAL]
    DUMMY10,     -- Info Field 1 [QTXT10]
    DUMMY20,     -- Info Field 2 [QTXT20]
    DUMMY40,     -- Info Field 3 [QTXT40]
    PRIMARY KEY (MANDT, QRKNR)
);

Learn More