QIE_INSP_DOC

Transparent Table Application Table
129 Fields 1 CDS Views

Inspection Document

QIE_INSP_DOC is an SAP database table in S/4HANA. Inspection Document. It contains 129 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EWM_QIEInspection view_entity from BASIC

Fields (129)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid QIE_TV_ENTITY_GUID GUID
insp_doc_number QIE_TV_INSP_DOCUMENT_NUMBER Inspection Document
iobtyp_guid QIE_TV_ENTITY_GUID GUID
lot_size QIE_TV_LOT_SIZE Lot Size
lot_unit QIE_TV_LOT_UNIT Unit of Lot Size
qlevel_guid QIE_TV_ENTITY_GUID GUID
insp_stag_id QIE_TV_INSP_STAG_ID Insp. Stage
skip QIE_TV_SKIP Skip
processor QIE_TV_PROCESSOR Processor
container QIE_TV_SAMP_DRW_UNIT Unit
numb_containers QIE_TV_NUMB_CONTAINER Number Cont.
property_xml abap.rstr
insp_proc QIE_TV_INSP_PROC Inspection Procedure
dmod_rule_id QIE_TV_DMOD_RULE_ID Dynamic Mod. Rule
dcod_bund_id QIE_TV_DCOD_BUND_ID Code Group
dmod_crit_id QIE_TV_DMOD_CRIT_ID Dynamic Mod.Criteria
auth_group QIE_TV_AUTH_GROUP Authorization Group
sample_type QIE_TV_SAMPLE_TYPE Sampling Type
sample_size_fix QIE_TV_FIX_SAMPSIZE Sample Size
sample_unit QIE_TV_SAMPLE_UNIT Unit for Sample Size
numb_accept QIE_TV_NUMB_ACCEPT Acceptance No.
sample_size_prc QIE_TV_PERCENT_SAMPSIZE Sample Size (%)
numb_accept_prc QIE_TV_PERC_SAMPSIZE_AC Acceptance Number(%)
samp_schm_id QIE_TV_SAMP_SCHM_ID Sampling Scheme
insp_level QIE_TV_INSP_LEVEL Insp. Level
insp_severity QIE_TV_INSP_SEVERITY Insp. Severity
aql_value QIE_TV_AQL_VALUE AQL Value
crule_sampsize QIE_TV_CRULE_SAMPSIZE Calculation Rule
valuation_mode QIE_TV_VALUATION_MODE Valuation Mode
nr_range_id QIE_TV_NR_RANGE_ID Number Range
actvt_prof PPFDCNTXT Action Profile
item_dcbd_id QIE_TV_DCOD_BUND_ID Code Group
element_type QIE_TV_ELEM_TYPE_ID Element Type
samp_drwp_guid QIE_TV_ENTITY_GUID GUID
samp_drwu_guid QIE_TV_ENTITY_GUID GUID
samp_dcbd_id QIE_TV_DCOD_BUND_ID Code Group
syst_id QIE_TV_QM_SYST_ID External System
inst_id QIE_TV_INST_ID Installation
qmsy_attrs_guid QIE_TV_ENTITY_GUID GUID
find_type_id QIE_TV_FIND_TYPE_ID Finding Type
cat_filter_id QIE_TV_CAT_FILT_ID Catalog Filter
dummy DUMMY Dummy function in length 1
procs /SCWM/DE_PROCS External Step
rlgrp /SCWM/DE_QRGRP Insp. Rule Grp
catlocn /SCWM/DE_CATLOCN Non-Dep Stk Ty.
torel /SCWM/DE_QSTOCK Mvmt Relevance
furel /SCWM/DE_QFUREL Quality Control
procty /SCWM/DE_QFUPROCTY Whse Proc. Type
duration /SCWM/DE_QDURA Insp.Dur.
duraunit /SCWM/DE_QDURAUNIT Time Unit
qdoc_cntrl /SCWM/DE_QDOC_CNTRL Insp. Creation Ctrl
qcontrol_extern QIE_TV_CREATED_BY_QINF From External System
gr_block_by_qinf QIE_TV_GR_BLOCK_BY_QINF GR Block Q Info Rec.
insp_control QIE_TV_INSP_CNTRL_BY_QINF Insp. Control Q Info
art QPART Inspection Type
ppl QPPL Insp with TList
plnty PLNTY Task List Type
plnnr PLNNR Group
plnal CP_S_PLNAL Group Counter
app QAPP_D Auto.assignment
mer QMERK Inspect Charcs
ave QAUTO_VE Auto UD
stichprver QSTPRVER Smpl. Procedure
dynregel QDYNREGEL Dyn. Mod. Rule
sproz QSPROZ Inspection %
hpz QHPZ 100% Inspection
dyn QDYN Skips Allowed
mst QMST Manl Samp. Calc
mpdau QMPDAU Avg. insp. dur.
qkzverf QKZVERF Q-Score Proc.
qpmat QAUSSCHUSS Allowed Scrap %
kzprfkost QKZPRFKOST Indiv. QM Order
aufnr_co QAUFNR_CO QM Order
aktiv QMATAKTIV InspType-Matl
ms_flag Q_MS_FLG Multiple Specs
insp_proc_org QIE_TV_ENTITY_GUID GUID
samp_type_org QIE_TV_ENTITY_GUID GUID
dmod_rule_org QIE_TV_ENTITY_GUID GUID
dcod_bund_org QIE_TV_ENTITY_GUID GUID
dmod_crit_org QIE_TV_ENTITY_GUID GUID
auth_group_org QIE_TV_ENTITY_GUID GUID
nr_range_org QIE_TV_ENTITY_GUID GUID
item_dcbd_id_org QIE_TV_ENTITY_GUID GUID
sample_org QIE_TV_ENTITY_GUID GUID
ext_syst_org QIE_TV_ENTITY_GUID GUID
find_org QIE_TV_ENTITY_GUID GUID
cons_org QIE_TV_ENTITY_GUID GUID
actvt_prof_org QIE_TV_ENTITY_GUID GUID
qcontrol_org QIE_TV_ENTITY_GUID GUID
insp_lot_org QIE_TV_ENTITY_GUID GUID
auto_decided QIE_TV_AUTO_DECIDED Auto. Insp. Decision
deci_code_id QIE_TV_DECI_CODE_ID Decision
quality_score QIE_TV_QUALITY_SCORE Quality Score
dmod_valuation QIE_TV_DMOD_VALUATION Dyn. Mod. Valuation
prop_valuation QIE_TV_PROP_VALUATION Valuation Proposal
insp_valuation QIE_TV_INSP_VALUATION Insp. Valuation
decided_on QIE_TV_DECIDED_ON Decided On
decided_by QIE_TV_DECIDED_BY Decision Maker
follow_up QIE_TV_FOLLOW_UP Foll.-Up Action
created_by QIE_TV_CREATED_BY Created by
created_on QIE_TV_CREATED_ON Created On
changed_by QIE_TV_CHANGED_BY Changed by
changed_on QIE_TV_CHANGED_ON Changed On
dummy1 DUMMY Dummy function in length 1
relat /SCWM/DE_QRELAT Release
qinspat /SCWM/DE_QINSPDAT Time of Insp.
fuexe /SCWM/DE_QFUEXE Foll.-UpActnPst
owner /SCWM/DE_OWNER Owner
cat /SCWM/DE_CAT Stock Type
cat_from /SCWM/DE_CAT Stock Type
fupext /SCWM/DE_QRET_PC Process Key
productno /SCWM/DE_MATNR Product
cwunit /SCWM/DE_CWUNIT Val. Quantity
cwrel /SCWM/DE_CWREL CW-Relevant
cwreq /SCWM/DE_CWREQ Val. Qty Input Req.
proc_start /SCWM/DE_LM_START_ACT Actual Start Date/Time
proc_finish /SCWM/DE_LM_FINISH_ACT Actual End Date/Time
followup_cntrl /SCWM/QFOLLOWUP_CNTRL FUPControl
pchg_type /SCWM/DE_QPCHG_TYPE Postg.Chg. Type
crea_by_ext_syst XFELD Checkbox
exp_dlv_inspqty /SCWM/DE_QDOC_EXP_DLV_QTY Plnd Insp. Qty
actdlv /SCWM/DE_QACTDLV Follw-UpAct. LF
no_dlv_itms_isum NUM4 Number
withdrawn_sample_qty /SCWM/DE_QDOC_WITHDRAWN_SAMPLE Withdrawn Quantity
inspqty_unit /SCWM/DE_QQTY_UNIT Base UoM (EWM Qty)
qmsgzg /SCWM/DE_QMSGZG Syst. Response
qzgtyp /SCWM/DE_QZGTYP Cert. Type
docno_asn /SCWM/SP_DOCNO_ASN ASN

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 Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QIE_INSP_DOC (
    CLIENT,                -- Client [MANDT]
    GUID,                  -- GUID [QIE_TV_ENTITY_GUID]
    INSP_DOC_NUMBER,       -- Inspection Document [QIE_TV_INSP_DOCUMENT_NUMBER]
    IOBTYP_GUID,           -- GUID [QIE_TV_ENTITY_GUID]
    LOT_SIZE,              -- Lot Size [QIE_TV_LOT_SIZE]
    LOT_UNIT,              -- Unit of Lot Size [QIE_TV_LOT_UNIT]
    QLEVEL_GUID,           -- GUID [QIE_TV_ENTITY_GUID]
    INSP_STAG_ID,          -- Insp. Stage [QIE_TV_INSP_STAG_ID]
    SKIP,                  -- Skip [QIE_TV_SKIP]
    PROCESSOR,             -- Processor [QIE_TV_PROCESSOR]
    CONTAINER,             -- Unit [QIE_TV_SAMP_DRW_UNIT]
    NUMB_CONTAINERS,       -- Number Cont. [QIE_TV_NUMB_CONTAINER]
    PROPERTY_XML,          -- abap.rstr
    INSP_PROC,             -- Inspection Procedure [QIE_TV_INSP_PROC]
    DMOD_RULE_ID,          -- Dynamic Mod. Rule [QIE_TV_DMOD_RULE_ID]
    DCOD_BUND_ID,          -- Code Group [QIE_TV_DCOD_BUND_ID]
    DMOD_CRIT_ID,          -- Dynamic Mod.Criteria [QIE_TV_DMOD_CRIT_ID]
    AUTH_GROUP,            -- Authorization Group [QIE_TV_AUTH_GROUP]
    SAMPLE_TYPE,           -- Sampling Type [QIE_TV_SAMPLE_TYPE]
    SAMPLE_SIZE_FIX,       -- Sample Size [QIE_TV_FIX_SAMPSIZE]
    SAMPLE_UNIT,           -- Unit for Sample Size [QIE_TV_SAMPLE_UNIT]
    NUMB_ACCEPT,           -- Acceptance No. [QIE_TV_NUMB_ACCEPT]
    SAMPLE_SIZE_PRC,       -- Sample Size (%) [QIE_TV_PERCENT_SAMPSIZE]
    NUMB_ACCEPT_PRC,       -- Acceptance Number(%) [QIE_TV_PERC_SAMPSIZE_AC]
    SAMP_SCHM_ID,          -- Sampling Scheme [QIE_TV_SAMP_SCHM_ID]
    INSP_LEVEL,            -- Insp. Level [QIE_TV_INSP_LEVEL]
    INSP_SEVERITY,         -- Insp. Severity [QIE_TV_INSP_SEVERITY]
    AQL_VALUE,             -- AQL Value [QIE_TV_AQL_VALUE]
    CRULE_SAMPSIZE,        -- Calculation Rule [QIE_TV_CRULE_SAMPSIZE]
    VALUATION_MODE,        -- Valuation Mode [QIE_TV_VALUATION_MODE]
    NR_RANGE_ID,           -- Number Range [QIE_TV_NR_RANGE_ID]
    ACTVT_PROF,            -- Action Profile [PPFDCNTXT]
    ITEM_DCBD_ID,          -- Code Group [QIE_TV_DCOD_BUND_ID]
    ELEMENT_TYPE,          -- Element Type [QIE_TV_ELEM_TYPE_ID]
    SAMP_DRWP_GUID,        -- GUID [QIE_TV_ENTITY_GUID]
    SAMP_DRWU_GUID,        -- GUID [QIE_TV_ENTITY_GUID]
    SAMP_DCBD_ID,          -- Code Group [QIE_TV_DCOD_BUND_ID]
    SYST_ID,               -- External System [QIE_TV_QM_SYST_ID]
    INST_ID,               -- Installation [QIE_TV_INST_ID]
    QMSY_ATTRS_GUID,       -- GUID [QIE_TV_ENTITY_GUID]
    FIND_TYPE_ID,          -- Finding Type [QIE_TV_FIND_TYPE_ID]
    CAT_FILTER_ID,         -- Catalog Filter [QIE_TV_CAT_FILT_ID]
    DUMMY,                 -- Dummy function in length 1 [DUMMY]
    PROCS,                 -- External Step [/SCWM/DE_PROCS]
    RLGRP,                 -- Insp. Rule Grp [/SCWM/DE_QRGRP]
    CATLOCN,               -- Non-Dep Stk Ty. [/SCWM/DE_CATLOCN]
    TOREL,                 -- Mvmt Relevance [/SCWM/DE_QSTOCK]
    FUREL,                 -- Quality Control [/SCWM/DE_QFUREL]
    PROCTY,                -- Whse Proc. Type [/SCWM/DE_QFUPROCTY]
    DURATION,              -- Insp.Dur. [/SCWM/DE_QDURA]
    DURAUNIT,              -- Time Unit [/SCWM/DE_QDURAUNIT]
    QDOC_CNTRL,            -- Insp. Creation Ctrl [/SCWM/DE_QDOC_CNTRL]
    QCONTROL_EXTERN,       -- From External System [QIE_TV_CREATED_BY_QINF]
    GR_BLOCK_BY_QINF,      -- GR Block Q Info Rec. [QIE_TV_GR_BLOCK_BY_QINF]
    INSP_CONTROL,          -- Insp. Control Q Info [QIE_TV_INSP_CNTRL_BY_QINF]
    ART,                   -- Inspection Type [QPART]
    PPL,                   -- Insp with TList [QPPL]
    PLNTY,                 -- Task List Type [PLNTY]
    PLNNR,                 -- Group [PLNNR]
    PLNAL,                 -- Group Counter [CP_S_PLNAL]
    APP,                   -- Auto.assignment [QAPP_D]
    MER,                   -- Inspect Charcs [QMERK]
    AVE,                   -- Auto UD [QAUTO_VE]
    STICHPRVER,            -- Smpl. Procedure [QSTPRVER]
    DYNREGEL,              -- Dyn. Mod. Rule [QDYNREGEL]
    SPROZ,                 -- Inspection % [QSPROZ]
    HPZ,                   -- 100% Inspection [QHPZ]
    DYN,                   -- Skips Allowed [QDYN]
    MST,                   -- Manl Samp. Calc [QMST]
    MPDAU,                 -- Avg. insp. dur. [QMPDAU]
    QKZVERF,               -- Q-Score Proc. [QKZVERF]
    QPMAT,                 -- Allowed Scrap % [QAUSSCHUSS]
    KZPRFKOST,             -- Indiv. QM Order [QKZPRFKOST]
    AUFNR_CO,              -- QM Order [QAUFNR_CO]
    AKTIV,                 -- InspType-Matl [QMATAKTIV]
    MS_FLAG,               -- Multiple Specs [Q_MS_FLG]
    INSP_PROC_ORG,         -- GUID [QIE_TV_ENTITY_GUID]
    SAMP_TYPE_ORG,         -- GUID [QIE_TV_ENTITY_GUID]
    DMOD_RULE_ORG,         -- GUID [QIE_TV_ENTITY_GUID]
    DCOD_BUND_ORG,         -- GUID [QIE_TV_ENTITY_GUID]
    DMOD_CRIT_ORG,         -- GUID [QIE_TV_ENTITY_GUID]
    AUTH_GROUP_ORG,        -- GUID [QIE_TV_ENTITY_GUID]
    NR_RANGE_ORG,          -- GUID [QIE_TV_ENTITY_GUID]
    ITEM_DCBD_ID_ORG,      -- GUID [QIE_TV_ENTITY_GUID]
    SAMPLE_ORG,            -- GUID [QIE_TV_ENTITY_GUID]
    EXT_SYST_ORG,          -- GUID [QIE_TV_ENTITY_GUID]
    FIND_ORG,              -- GUID [QIE_TV_ENTITY_GUID]
    CONS_ORG,              -- GUID [QIE_TV_ENTITY_GUID]
    ACTVT_PROF_ORG,        -- GUID [QIE_TV_ENTITY_GUID]
    QCONTROL_ORG,          -- GUID [QIE_TV_ENTITY_GUID]
    INSP_LOT_ORG,          -- GUID [QIE_TV_ENTITY_GUID]
    AUTO_DECIDED,          -- Auto. Insp. Decision [QIE_TV_AUTO_DECIDED]
    DECI_CODE_ID,          -- Decision [QIE_TV_DECI_CODE_ID]
    QUALITY_SCORE,         -- Quality Score [QIE_TV_QUALITY_SCORE]
    DMOD_VALUATION,        -- Dyn. Mod. Valuation [QIE_TV_DMOD_VALUATION]
    PROP_VALUATION,        -- Valuation Proposal [QIE_TV_PROP_VALUATION]
    INSP_VALUATION,        -- Insp. Valuation [QIE_TV_INSP_VALUATION]
    DECIDED_ON,            -- Decided On [QIE_TV_DECIDED_ON]
    DECIDED_BY,            -- Decision Maker [QIE_TV_DECIDED_BY]
    FOLLOW_UP,             -- Foll.-Up Action [QIE_TV_FOLLOW_UP]
    CREATED_BY,            -- Created by [QIE_TV_CREATED_BY]
    CREATED_ON,            -- Created On [QIE_TV_CREATED_ON]
    CHANGED_BY,            -- Changed by [QIE_TV_CHANGED_BY]
    CHANGED_ON,            -- Changed On [QIE_TV_CHANGED_ON]
    DUMMY1,                -- Dummy function in length 1 [DUMMY]
    RELAT,                 -- Release [/SCWM/DE_QRELAT]
    QINSPAT,               -- Time of Insp. [/SCWM/DE_QINSPDAT]
    FUEXE,                 -- Foll.-UpActnPst [/SCWM/DE_QFUEXE]
    OWNER,                 -- Owner [/SCWM/DE_OWNER]
    CAT,                   -- Stock Type [/SCWM/DE_CAT]
    CAT_FROM,              -- Stock Type [/SCWM/DE_CAT]
    FUPEXT,                -- Process Key [/SCWM/DE_QRET_PC]
    PRODUCTNO,             -- Product [/SCWM/DE_MATNR]
    CWUNIT,                -- Val. Quantity [/SCWM/DE_CWUNIT]
    CWREL,                 -- CW-Relevant [/SCWM/DE_CWREL]
    CWREQ,                 -- Val. Qty Input Req. [/SCWM/DE_CWREQ]
    PROC_START,            -- Actual Start Date/Time [/SCWM/DE_LM_START_ACT]
    PROC_FINISH,           -- Actual End Date/Time [/SCWM/DE_LM_FINISH_ACT]
    FOLLOWUP_CNTRL,        -- FUPControl [/SCWM/QFOLLOWUP_CNTRL]
    PCHG_TYPE,             -- Postg.Chg. Type [/SCWM/DE_QPCHG_TYPE]
    CREA_BY_EXT_SYST,      -- Checkbox [XFELD]
    EXP_DLV_INSPQTY,       -- Plnd Insp. Qty [/SCWM/DE_QDOC_EXP_DLV_QTY]
    ACTDLV,                -- Follw-UpAct. LF [/SCWM/DE_QACTDLV]
    NO_DLV_ITMS_ISUM,      -- Number [NUM4]
    WITHDRAWN_SAMPLE_QTY,  -- Withdrawn Quantity [/SCWM/DE_QDOC_WITHDRAWN_SAMPLE]
    INSPQTY_UNIT,          -- Base UoM (EWM Qty) [/SCWM/DE_QQTY_UNIT]
    QMSGZG,                -- Syst. Response [/SCWM/DE_QMSGZG]
    QZGTYP,                -- Cert. Type [/SCWM/DE_QZGTYP]
    DOCNO_ASN,             -- ASN [/SCWM/SP_DOCNO_ASN]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More