TQ33

Transparent Table Customizing (protected)

Relevant fields for origin

TQ33 is an SAP database table in S/4HANA. Relevant fields for origin. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InspectionLotOriginSettings view from BASIC Settings for Inspection Lot Origin

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY herkunft QHERK Insp. Lot Orig.
numkr NRNR No. Range No.
dynkrit QDYNKRIT_D Dyn. criterion
plnty PLNTY Task List Type
plnst PLNST Status
bestrel QBESTREL Stock-relevant

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.

-- Relevant fields for origin
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ33 (
    MANDT,     -- Client [MANDT]
    HERKUNFT,  -- Insp. Lot Orig. [QHERK]
    NUMKR,     -- No. Range No. [NRNR]
    DYNKRIT,   -- Dyn. criterion [QDYNKRIT_D]
    PLNTY,     -- Task List Type [PLNTY]
    PLNST,     -- Status [PLNST]
    BESTREL,   -- Stock-relevant [QBESTREL]
    PRIMARY KEY (MANDT, HERKUNFT)
);