QALS

Transparent Table Application Table
237 Fields 8 CDS Views

Inspection lot record

QALS is an SAP database table in S/4HANA. Inspection lot record. It contains 237 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
E_InspectionLot view from EXTENSION Inspection Lot Extension
FNDEI_QALS_BLOCKINGINFO view from Blocking Info View for table QALS
FNDEI_QALS_FILTER view from Filter View for table QALS
I_InspectionLot view from BASIC Inspection Lot
PPH_DDL_MDQM_EWM_1 view from
PPH_DDL_QM_IL_EWM_1 view from
PPH_E_MDQM view from
PPH_E_MDQM view union_all

Fields (237)

KeyField Data ElementDescription DomainTypeLength
KEY mandant mandt Client
KEY prueflos qplos Inspection Lot
werk werks_d Plant
art qpart Inspection Type
herkunft qherk Insp. Lot Orig.
objnr j_objnr Object number
obtyp j_obtyp Object Type
stsma j_stsma Status Profile
qmatauth qmatauth QM Matl Auth.
stat11 kzwes GR Blocked Stck
insmk qvinsmk Insp. Stock
stat01 qstat01 Lot Created
stat02 qkzqalt Partial Lots
stat04 quser_exit Ind. modified
stat06 qkzprfkost Indiv. QM Order
stat07 qkzfertprf Prod. insp.
stat08 qauto_ve Auto UD
stat09 qabnahmprf Source insp.
stat10 qconf Configuration
stat14 qstat14 Short-term ins.
stat16 qcharg Batch determtn
stat18 q1welos Lot Creation
stat19 qstat19 Docu. Required
stat20 qstat20 Insp.plan reqd
stat21 qstat21 Manual sample
stat22 qspezueber Insp. with spec.
stat23 qkzgenlos Lot Approval
stat24 sig_il_res Dig. Sig. in RR
stat25 sig_il_usa Dig. Sig. UD
stat29 sig_il_sdr DigSig SmplDraw
stat26 xgchp Batch rec. req.
stat27 qstat27 R/2 insp. lot
stat28 qstat28 Man. charSelec.
stat31 qstat31 Man. smplCalc.
stat34 qstat34 StckPostCompl.
stat35 qstat35 Usage Dec. Made
stat45 qstat45 Dyn. material
stat46 qstat46 Dyn. Supplier
stat47 qstat47 Dyn. manufact.
stat48 qstat48 Dyn. customer
stat49 qstat49 Dyn. machine
stat50 qstat50 Dyn. project
kzskiplot qkzskiplot Lot Skipped
dyn qdyn Skips Allowed
hpz qhpz 100% Inspection
ein qeinz Serial Numbers
anzsn anzsn No.serial no.
kzdynerf qkzdynerf DynModification
dynhead qdynhead Dyn. Mod. Level
stprver qstprver Smpl. Procedure
extnum qextnum Ext. Numbering
stafo stafo Update Group
stat30 qunitorigin Origin of Inspection Lot Unit of Measure for LIS Interface
qinfstatus qinfstatus QINF Status
enstehdat qentst Lot Created
entstezeit qentstzeit Time
ersteller qersteller Created By
ersteldat qdatumerst Created On
erstelzeit qerstezeit Syst. Time
aenderer qaenderer Changed By
aenderdat qdatumaend Changed On
aenderzeit qaendezeit Time
changeddatetime tzntstmps Time Stamp
pastrterm qprstart Start Date
pastrzeit qstartzeit Time
paendterm qprende End Date
paendzeit qendezeit Time
plnty plnty Task List Type
plnnr plnnr Group
pplverw pln_verwe Usage
plnal plnal Group Counter
zaehl cim_count Counter
zkriz dzkriz Add. Crit. Cntr
stat15 qfhm_mode Production Resource/Tool Saved for Insp. Lot
slwbez qslwbez Field Combinat.
stat13 qppkttyp InspPt type
ppkztlzu qppkztlzu PL Assignment
zaehl1 cim_count Counter
prbnaverf qprziehver Drawing Proc.
prbnavv qversnprzv Version
stat12 qkzquit Confirmation
selmatnr matnr Material
selrevlv revlv Revision Level
selwerk werks_d Plant
sellifnr elifn Supplier
stat17 qherst MPN active
selherst qlifnr Manufacturer
selkunnr ekunn Customer
selpplverw pln_verwe Usage
gueltigab qstichtag Key Date
aufnr aufnr Order
aufpl co_aufpl Plan No.f.Oper.
cuobj cuobj Int. object no.
cuobj_ch cuobj_ch Int.object no.
verid verid Prod. Version
sa_aufnr sa_aufnr RS header
cvp_xblck cvp_xblck Purpose Completed
kunnr qkunwe Customer
lifnr elifn Supplier
hersteller qlifnr Manufacturer
ematnr ematn MPN: Material
matnr matnr Material
revlv revlv Revision Level
xchpf xchpf Batch Mgmt Rqt
charg charg_d Batch
lagortchrg lgort_d Location
zeugnisbis qzeugbis Valid To
vfdat vfdat SLED/BBD
lichn lichn Supplier Batch
sobkz sobkz Special Stock
ps_psp_pnr mat_pspnr WBS Element
kdauf mat_kdauf Sales order
kdpos mat_kdpos Sales ord. item
ekorg ekorg Purchasing Org.
ebeln ebeln Purchasing Doc.
ebelp ebelp Item
etenr eeten Schedule Line
blart blart Document Type
mjahr mjahr Mat. Doc. Year
mblnr mblnr Material Doc.
zeile mblpo Mat. Doc.Item
budat budat Posting Date
bwart bwart Movement Type
werkvorg qwerkvorg Plant for Stock
lagortvorg qlgortvorg StLoc.ILotStock
lgnum lgnum Warehouse No.
lgtyp lgtyp Storage Type
lgpla lgpla Storage Bin
ls_kdauf kdauf Sales Order
ls_kdpos kdpos Sales Ord. Item
ls_vbeln vbeln_vl Delivery
ls_posnr posnr_vl Item
ls_abrvw qabrvw Delivery cat.
ls_route route Route
ls_lland lland Dest. Ctry/Reg
ls_kunag kunag Sold-to Party
ls_vkorg vkorg Sales Org.
ls_kdmat kdmat Customer Mat.
sprache spras Language
ktextlos qkurztext Short Text
ltextkz qltextlos Long text
ktextmat qktextobj Obj short text
ls_equnr equnr Equipment
ls_tplnr tplnr Functional loc.
zusmkzaehl qzusmkzhl Charcs Recorded
offennlzmk qoffenlzmk Short-Term Char
offen_lzmk qoffelzmk Long-Term Char.
losmenge qlosmenge Insp. Lot Qty
mengeneinh qlosmengeh Base Unit
anzgeb qanzgeb No. Containers
gebeh qgebeh Lot Container
lvs_stikz lvs_stikz In.insp.sample WM
lvs_stimg lvs_stimg In.samp.(StkUn)
gesstichpr qgestich Sample Size
einhprobe qprobemgeh Sample UOM
dynregel qdynregel Dyn. Mod. Rule
stat44 qdyntime Time DynModif.
prstufe qprstufe Insp. Stage
prschaerfe qprschaerf Insp. Severity
lmenge01 qlmenge01f Unrestr. Stck
lmenge02 qlmenge02f Scrap quantity
lmenge03 qlmenge03f Sample
lmenge04 qlmenge04f Blocked
lmenge05 qlmenge05f Reserves
lmenge06 qlmenge06f New Material
matnrneu qmatnrneu Material
chargneu qchargneu Batch
lmenge07 qlmenge07f Return to Supp.
lmenge08 qlmenge08f Other quantity
lmenge09 qlmenge09f Other qty. 2
lmengezub qlmengezub Postings
lmengelz qlmengelz Long-term qty
lmengepr qlmengepr Inspected qty
lmengezer qlmengezer Destroyed Qty
lmengeist qlmengeist Actual Lot Qty
lmengesch qlmengesch Defective Qty
ltextkzbb qltextkzbb Logs
anteil qausanteil Share of Scrap
qkzverf qkzverf Q-Score Proc.
stat03 qmodus_ud UD Mode
qpmatlos qpmatlos Allowed Scrap %
aufnr_co qaufnr_co QM Order
kzvbr kzvbr Consumption
knttp knttp Acct Assgmt Cat
pstyp pstyp Item Category
stat05 qkzqalsknt Acct Assgmt Key
kostl kostl Cost Center
aufps rspos Item no.
anln1 anln1 Asset
anln2 anln2 Sub-number
kont_pspnr ps_psp_pnr WBS Element
nplnr nplnr Network
aplzl cim_count Counter
kont_kdauf kdauf Sales Order
kont_kdpos kdpos Sales Ord. Item
imkey imkey Real Estate Key
dabrz dabrbez Reference date
kstrg kstrg Cost Object
paobjnr rkeobjnr Profit. segment
prctr prctr Profit Center
gsber gsber Business Area
konto saknr G/L Account
kokrs kokrs CO Area
bukrs bukrs Company Code
sernp serail SerialNoProfile
los_ref qlos_ref Ref. insp. lot
bearbstatu q_unused02 Empty
stat32 qstabi Insp. Lot Stab.
stat33 q_ms_flg Multiple Specs
stat36 qtls_wo_insppoint No Insp. Point
stat37 ql_blocked4archiving Blckd for Archiving
stat38 q_unused01 Dummy
stat39 q_unused01 Dummy
stat40 q_unused01 Dummy
stat41 q_unused01 Dummy
stat42 q_unused01 Dummy
stat43 qinsp_fai Created for FAI
mengu q_unused01 Dummy
kzpzadr q_unused01 Dummy
kzpradr q_unused01 Dummy
zusch q_unused01 Dummy
zustd q_unused01 Dummy
kzerstlief q_unused01 Dummy
kzerstmust q_unused01 Dummy
insp_doc_number qinsp_doc_number Insp. Doc. No.
log_system logsys Logical system
gesstichpr_ext qgestich_ext Sample Size
einhprobe_ext qprobemgeh_ext Sample UOM
prio_punkte qprio_punkte Priority Points
sign_type_rr sign_type_rr Sig.Type R.R.
sign_type_ud sign_type_ud Sig.Type U.D.
sign_type_sm sign_type_sm Sig.Type SD
signstrat_rr signstrat_rr Sig.Strategy R.R.
signstrat_ud signstrat_ud Sig.Strategy U.D.
signstrat_sm signstrat_sm SigStrat SampDr
lot_guid qals_guid Insp. Lot GUID
setup_orig ql_setup_orig Insp. Setup Origin

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.

-- Inspection lot record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QALS (
    MANDANT,          -- Client [mandt]
    PRUEFLOS,         -- Inspection Lot [qplos]
    WERK,             -- Plant [werks_d]
    ART,              -- Inspection Type [qpart]
    HERKUNFT,         -- Insp. Lot Orig. [qherk]
    OBJNR,            -- Object number [j_objnr]
    OBTYP,            -- Object Type [j_obtyp]
    STSMA,            -- Status Profile [j_stsma]
    QMATAUTH,         -- QM Matl Auth. [qmatauth]
    STAT11,           -- GR Blocked Stck [kzwes]
    INSMK,            -- Insp. Stock [qvinsmk]
    STAT01,           -- Lot Created [qstat01]
    STAT02,           -- Partial Lots [qkzqalt]
    STAT04,           -- Ind. modified [quser_exit]
    STAT06,           -- Indiv. QM Order [qkzprfkost]
    STAT07,           -- Prod. insp. [qkzfertprf]
    STAT08,           -- Auto UD [qauto_ve]
    STAT09,           -- Source insp. [qabnahmprf]
    STAT10,           -- Configuration [qconf]
    STAT14,           -- Short-term ins. [qstat14]
    STAT16,           -- Batch determtn [qcharg]
    STAT18,           -- Lot Creation [q1welos]
    STAT19,           -- Docu. Required [qstat19]
    STAT20,           -- Insp.plan reqd [qstat20]
    STAT21,           -- Manual sample [qstat21]
    STAT22,           -- Insp. with spec. [qspezueber]
    STAT23,           -- Lot Approval [qkzgenlos]
    STAT24,           -- Dig. Sig. in RR [sig_il_res]
    STAT25,           -- Dig. Sig. UD [sig_il_usa]
    STAT29,           -- DigSig SmplDraw [sig_il_sdr]
    STAT26,           -- Batch rec. req. [xgchp]
    STAT27,           -- R/2 insp. lot [qstat27]
    STAT28,           -- Man. charSelec. [qstat28]
    STAT31,           -- Man. smplCalc. [qstat31]
    STAT34,           -- StckPostCompl. [qstat34]
    STAT35,           -- Usage Dec. Made [qstat35]
    STAT45,           -- Dyn. material [qstat45]
    STAT46,           -- Dyn. Supplier [qstat46]
    STAT47,           -- Dyn. manufact. [qstat47]
    STAT48,           -- Dyn. customer [qstat48]
    STAT49,           -- Dyn. machine [qstat49]
    STAT50,           -- Dyn. project [qstat50]
    KZSKIPLOT,        -- Lot Skipped [qkzskiplot]
    DYN,              -- Skips Allowed [qdyn]
    HPZ,              -- 100% Inspection [qhpz]
    EIN,              -- Serial Numbers [qeinz]
    ANZSN,            -- No.serial no. [anzsn]
    KZDYNERF,         -- DynModification [qkzdynerf]
    DYNHEAD,          -- Dyn. Mod. Level [qdynhead]
    STPRVER,          -- Smpl. Procedure [qstprver]
    EXTNUM,           -- Ext. Numbering [qextnum]
    STAFO,            -- Update Group [stafo]
    STAT30,           -- Origin of Inspection Lot Unit of Measure for LIS Interface [qunitorigin]
    QINFSTATUS,       -- QINF Status [qinfstatus]
    ENSTEHDAT,        -- Lot Created [qentst]
    ENTSTEZEIT,       -- Time [qentstzeit]
    ERSTELLER,        -- Created By [qersteller]
    ERSTELDAT,        -- Created On [qdatumerst]
    ERSTELZEIT,       -- Syst. Time [qerstezeit]
    AENDERER,         -- Changed By [qaenderer]
    AENDERDAT,        -- Changed On [qdatumaend]
    AENDERZEIT,       -- Time [qaendezeit]
    CHANGEDDATETIME,  -- Time Stamp [tzntstmps]
    PASTRTERM,        -- Start Date [qprstart]
    PASTRZEIT,        -- Time [qstartzeit]
    PAENDTERM,        -- End Date [qprende]
    PAENDZEIT,        -- Time [qendezeit]
    PLNTY,            -- Task List Type [plnty]
    PLNNR,            -- Group [plnnr]
    PPLVERW,          -- Usage [pln_verwe]
    PLNAL,            -- Group Counter [plnal]
    ZAEHL,            -- Counter [cim_count]
    ZKRIZ,            -- Add. Crit. Cntr [dzkriz]
    STAT15,           -- Production Resource/Tool Saved for Insp. Lot [qfhm_mode]
    SLWBEZ,           -- Field Combinat. [qslwbez]
    STAT13,           -- InspPt type [qppkttyp]
    PPKZTLZU,         -- PL Assignment [qppkztlzu]
    ZAEHL1,           -- Counter [cim_count]
    PRBNAVERF,        -- Drawing Proc. [qprziehver]
    PRBNAVV,          -- Version [qversnprzv]
    STAT12,           -- Confirmation [qkzquit]
    SELMATNR,         -- Material [matnr]
    SELREVLV,         -- Revision Level [revlv]
    SELWERK,          -- Plant [werks_d]
    SELLIFNR,         -- Supplier [elifn]
    STAT17,           -- MPN active [qherst]
    SELHERST,         -- Manufacturer [qlifnr]
    SELKUNNR,         -- Customer [ekunn]
    SELPPLVERW,       -- Usage [pln_verwe]
    GUELTIGAB,        -- Key Date [qstichtag]
    AUFNR,            -- Order [aufnr]
    AUFPL,            -- Plan No.f.Oper. [co_aufpl]
    CUOBJ,            -- Int. object no. [cuobj]
    CUOBJ_CH,         -- Int.object no. [cuobj_ch]
    VERID,            -- Prod. Version [verid]
    SA_AUFNR,         -- RS header [sa_aufnr]
    CVP_XBLCK,        -- Purpose Completed [cvp_xblck]
    KUNNR,            -- Customer [qkunwe]
    LIFNR,            -- Supplier [elifn]
    HERSTELLER,       -- Manufacturer [qlifnr]
    EMATNR,           -- MPN: Material [ematn]
    MATNR,            -- Material [matnr]
    REVLV,            -- Revision Level [revlv]
    XCHPF,            -- Batch Mgmt Rqt [xchpf]
    CHARG,            -- Batch [charg_d]
    LAGORTCHRG,       -- Location [lgort_d]
    ZEUGNISBIS,       -- Valid To [qzeugbis]
    VFDAT,            -- SLED/BBD [vfdat]
    LICHN,            -- Supplier Batch [lichn]
    SOBKZ,            -- Special Stock [sobkz]
    PS_PSP_PNR,       -- WBS Element [mat_pspnr]
    KDAUF,            -- Sales order [mat_kdauf]
    KDPOS,            -- Sales ord. item [mat_kdpos]
    EKORG,            -- Purchasing Org. [ekorg]
    EBELN,            -- Purchasing Doc. [ebeln]
    EBELP,            -- Item [ebelp]
    ETENR,            -- Schedule Line [eeten]
    BLART,            -- Document Type [blart]
    MJAHR,            -- Mat. Doc. Year [mjahr]
    MBLNR,            -- Material Doc. [mblnr]
    ZEILE,            -- Mat. Doc.Item [mblpo]
    BUDAT,            -- Posting Date [budat]
    BWART,            -- Movement Type [bwart]
    WERKVORG,         -- Plant for Stock [qwerkvorg]
    LAGORTVORG,       -- StLoc.ILotStock [qlgortvorg]
    LGNUM,            -- Warehouse No. [lgnum]
    LGTYP,            -- Storage Type [lgtyp]
    LGPLA,            -- Storage Bin [lgpla]
    LS_KDAUF,         -- Sales Order [kdauf]
    LS_KDPOS,         -- Sales Ord. Item [kdpos]
    LS_VBELN,         -- Delivery [vbeln_vl]
    LS_POSNR,         -- Item [posnr_vl]
    LS_ABRVW,         -- Delivery cat. [qabrvw]
    LS_ROUTE,         -- Route [route]
    LS_LLAND,         -- Dest. Ctry/Reg [lland]
    LS_KUNAG,         -- Sold-to Party [kunag]
    LS_VKORG,         -- Sales Org. [vkorg]
    LS_KDMAT,         -- Customer Mat. [kdmat]
    SPRACHE,          -- Language [spras]
    KTEXTLOS,         -- Short Text [qkurztext]
    LTEXTKZ,          -- Long text [qltextlos]
    KTEXTMAT,         -- Obj short text [qktextobj]
    LS_EQUNR,         -- Equipment [equnr]
    LS_TPLNR,         -- Functional loc. [tplnr]
    ZUSMKZAEHL,       -- Charcs Recorded [qzusmkzhl]
    OFFENNLZMK,       -- Short-Term Char [qoffenlzmk]
    OFFEN_LZMK,       -- Long-Term Char. [qoffelzmk]
    LOSMENGE,         -- Insp. Lot Qty [qlosmenge]
    MENGENEINH,       -- Base Unit [qlosmengeh]
    ANZGEB,           -- No. Containers [qanzgeb]
    GEBEH,            -- Lot Container [qgebeh]
    LVS_STIKZ,        -- In.insp.sample WM [lvs_stikz]
    LVS_STIMG,        -- In.samp.(StkUn) [lvs_stimg]
    GESSTICHPR,       -- Sample Size [qgestich]
    EINHPROBE,        -- Sample UOM [qprobemgeh]
    DYNREGEL,         -- Dyn. Mod. Rule [qdynregel]
    STAT44,           -- Time DynModif. [qdyntime]
    PRSTUFE,          -- Insp. Stage [qprstufe]
    PRSCHAERFE,       -- Insp. Severity [qprschaerf]
    LMENGE01,         -- Unrestr. Stck [qlmenge01f]
    LMENGE02,         -- Scrap quantity [qlmenge02f]
    LMENGE03,         -- Sample [qlmenge03f]
    LMENGE04,         -- Blocked [qlmenge04f]
    LMENGE05,         -- Reserves [qlmenge05f]
    LMENGE06,         -- New Material [qlmenge06f]
    MATNRNEU,         -- Material [qmatnrneu]
    CHARGNEU,         -- Batch [qchargneu]
    LMENGE07,         -- Return to Supp. [qlmenge07f]
    LMENGE08,         -- Other quantity [qlmenge08f]
    LMENGE09,         -- Other qty. 2 [qlmenge09f]
    LMENGEZUB,        -- Postings [qlmengezub]
    LMENGELZ,         -- Long-term qty [qlmengelz]
    LMENGEPR,         -- Inspected qty [qlmengepr]
    LMENGEZER,        -- Destroyed Qty [qlmengezer]
    LMENGEIST,        -- Actual Lot Qty [qlmengeist]
    LMENGESCH,        -- Defective Qty [qlmengesch]
    LTEXTKZBB,        -- Logs [qltextkzbb]
    ANTEIL,           -- Share of Scrap [qausanteil]
    QKZVERF,          -- Q-Score Proc. [qkzverf]
    STAT03,           -- UD Mode [qmodus_ud]
    QPMATLOS,         -- Allowed Scrap % [qpmatlos]
    AUFNR_CO,         -- QM Order [qaufnr_co]
    KZVBR,            -- Consumption [kzvbr]
    KNTTP,            -- Acct Assgmt Cat [knttp]
    PSTYP,            -- Item Category [pstyp]
    STAT05,           -- Acct Assgmt Key [qkzqalsknt]
    KOSTL,            -- Cost Center [kostl]
    AUFPS,            -- Item no. [rspos]
    ANLN1,            -- Asset [anln1]
    ANLN2,            -- Sub-number [anln2]
    KONT_PSPNR,       -- WBS Element [ps_psp_pnr]
    NPLNR,            -- Network [nplnr]
    APLZL,            -- Counter [cim_count]
    KONT_KDAUF,       -- Sales Order [kdauf]
    KONT_KDPOS,       -- Sales Ord. Item [kdpos]
    IMKEY,            -- Real Estate Key [imkey]
    DABRZ,            -- Reference date [dabrbez]
    KSTRG,            -- Cost Object [kstrg]
    PAOBJNR,          -- Profit. segment [rkeobjnr]
    PRCTR,            -- Profit Center [prctr]
    GSBER,            -- Business Area [gsber]
    KONTO,            -- G/L Account [saknr]
    KOKRS,            -- CO Area [kokrs]
    BUKRS,            -- Company Code [bukrs]
    SERNP,            -- SerialNoProfile [serail]
    LOS_REF,          -- Ref. insp. lot [qlos_ref]
    BEARBSTATU,       -- Empty [q_unused02]
    STAT32,           -- Insp. Lot Stab. [qstabi]
    STAT33,           -- Multiple Specs [q_ms_flg]
    STAT36,           -- No Insp. Point [qtls_wo_insppoint]
    STAT37,           -- Blckd for Archiving [ql_blocked4archiving]
    STAT38,           -- Dummy [q_unused01]
    STAT39,           -- Dummy [q_unused01]
    STAT40,           -- Dummy [q_unused01]
    STAT41,           -- Dummy [q_unused01]
    STAT42,           -- Dummy [q_unused01]
    STAT43,           -- Created for FAI [qinsp_fai]
    MENGU,            -- Dummy [q_unused01]
    KZPZADR,          -- Dummy [q_unused01]
    KZPRADR,          -- Dummy [q_unused01]
    ZUSCH,            -- Dummy [q_unused01]
    ZUSTD,            -- Dummy [q_unused01]
    KZERSTLIEF,       -- Dummy [q_unused01]
    KZERSTMUST,       -- Dummy [q_unused01]
    INSP_DOC_NUMBER,  -- Insp. Doc. No. [qinsp_doc_number]
    LOG_SYSTEM,       -- Logical system [logsys]
    GESSTICHPR_EXT,   -- Sample Size [qgestich_ext]
    EINHPROBE_EXT,    -- Sample UOM [qprobemgeh_ext]
    PRIO_PUNKTE,      -- Priority Points [qprio_punkte]
    SIGN_TYPE_RR,     -- Sig.Type R.R. [sign_type_rr]
    SIGN_TYPE_UD,     -- Sig.Type U.D. [sign_type_ud]
    SIGN_TYPE_SM,     -- Sig.Type SD [sign_type_sm]
    SIGNSTRAT_RR,     -- Sig.Strategy R.R. [signstrat_rr]
    SIGNSTRAT_UD,     -- Sig.Strategy U.D. [signstrat_ud]
    SIGNSTRAT_SM,     -- SigStrat SampDr [signstrat_sm]
    LOT_GUID,         -- Insp. Lot GUID [qals_guid]
    SETUP_ORIG,       -- Insp. Setup Origin [ql_setup_orig]
    PRIMARY KEY (MANDANT, PRUEFLOS)
);

Learn More