TQ30

Transparent Table Customizing (protected)
19 Fields 1 CDS Views

Inspection types

TQ30 is an SAP database table in S/4HANA. Inspection types. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InspectionLotType view from BASIC Inspection Type

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY art QPART Inspection Type
pplverw QPLN_VERWE Task List Usage
bilds QBILDS Key for Field Control (Not Used After 3.0)
vemenge QVEMENGE UD Selected Set
veversion QVEVERSION Code version
vedatum QVEDATUM UD Code Date
kzvewerks QKZVEWERKS Sel. Set in Plant
kzpzdr QKZPZDR Prnt smpl.inst.
kzpadr QKZPADR Print inspInstr
kzmessage QKZMESSAGE Print Messages
stsma J_STSMA Status Profile
erfsicht QERFSICHT Recording View
steus STEUS Control Key
qmart QMART Notifictn Type
vornr VORNR Activity
prart QPRART Sample Type
einemeld QEINEMELD 1 QNot. per Lot
auart QAUARTTQ30 Order Type

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 types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ30 (
    MANDT,      -- Client [MANDT]
    ART,        -- Inspection Type [QPART]
    PPLVERW,    -- Task List Usage [QPLN_VERWE]
    BILDS,      -- Key for Field Control (Not Used After 3.0) [QBILDS]
    VEMENGE,    -- UD Selected Set [QVEMENGE]
    VEVERSION,  -- Code version [QVEVERSION]
    VEDATUM,    -- UD Code Date [QVEDATUM]
    KZVEWERKS,  -- Sel. Set in Plant [QKZVEWERKS]
    KZPZDR,     -- Prnt smpl.inst. [QKZPZDR]
    KZPADR,     -- Print inspInstr [QKZPADR]
    KZMESSAGE,  -- Print Messages [QKZMESSAGE]
    STSMA,      -- Status Profile [J_STSMA]
    ERFSICHT,   -- Recording View [QERFSICHT]
    STEUS,      -- Control Key [STEUS]
    QMART,      -- Notifictn Type [QMART]
    VORNR,      -- Activity [VORNR]
    PRART,      -- Sample Type [QPRART]
    EINEMELD,   -- 1 QNot. per Lot [QEINEMELD]
    AUART,      -- Order Type [QAUARTTQ30]
    PRIMARY KEY (MANDT, ART)
);

Learn More