TQEC30

Transparent Table Customizing Table

Settings for Copy Inspection Results Function/Operation UD

TQEC30 is an SAP database table in S/4HANA. Settings for Copy Inspection Results Function/Operation UD. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InspectionOperationStatus view left_outer BASIC Inspection Operation Status

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY art qpart Inspection Type
KEY werk werks_d Plant
qa_activ qec_qa_activ Control in Lot
qe_activ qec_qe_activ Control in RR
char_close qec_close Close Char.
plan_origin qec_plan_origin DatOrigin in TL
res_origin qec_res_origin Data Origin-RR
selection qec_selection Selection Proc.
mapping qec_mapping Mapping Proc.
log_del qec_log_del Days Before Del
log_show qec_log_show Log
oper_completion qec_oc_ud Operation UD
oc_vewerk qec_oc_werk Plant
oc_vemenge qec_oc_qvemenge UD Selected Set
oc_veversion qec_oc_qveversion Code Version
oc_vedatum qec_oc_qvedatum UD Code Date
oc_qkzvewerks qec_oc_qkzvewerks SelSet in plant

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.

-- Settings for Copy Inspection Results Function/Operation UD
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQEC30 (
    MANDT,            -- Client [mandt]
    ART,              -- Inspection Type [qpart]
    WERK,             -- Plant [werks_d]
    QA_ACTIV,         -- Control in Lot [qec_qa_activ]
    QE_ACTIV,         -- Control in RR [qec_qe_activ]
    CHAR_CLOSE,       -- Close Char. [qec_close]
    PLAN_ORIGIN,      -- DatOrigin in TL [qec_plan_origin]
    RES_ORIGIN,       -- Data Origin-RR [qec_res_origin]
    SELECTION,        -- Selection Proc. [qec_selection]
    MAPPING,          -- Mapping Proc. [qec_mapping]
    LOG_DEL,          -- Days Before Del [qec_log_del]
    LOG_SHOW,         -- Log [qec_log_show]
    OPER_COMPLETION,  -- Operation UD [qec_oc_ud]
    OC_VEWERK,        -- Plant [qec_oc_werk]
    OC_VEMENGE,       -- UD Selected Set [qec_oc_qvemenge]
    OC_VEVERSION,     -- Code Version [qec_oc_qveversion]
    OC_VEDATUM,       -- UD Code Date [qec_oc_qvedatum]
    OC_QKZVEWERKS,    -- SelSet in plant [qec_oc_qkzvewerks]
    PRIMARY KEY (MANDT, ART, WERK)
);