TQ79

Transparent Table Customizing (protected)
29 Fields 1 CDS Views

Table with inspection point/user field combinations

TQ79 is an SAP database table in S/4HANA. Table with inspection point/user field combinations. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InspSubsetFieldCombination view from BASIC Inspection Point Field Combination

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY slwbez qslwbez Field Combinat.
ppkttyp qppkttyp InspPt type
equnrakt qkzusrakt User Fld Active
tplnrakt qkzusrakt User Fld Active
phynrakt qkzusrakt User Fld Active
sfi_akt qkzusrakt User Fld Active
userc1akt qkzusrakt User Fld Active
userc2akt qkzusrakt User Fld Active
usern1akt qkzusrakt User Fld Active
usern2akt qkzusrakt User Fld Active
userd1akt qkzusrakt User Fld Active
usert1akt qkzusrakt User Fld Active
probeanz qprobeanz InspPtSummz
last_valid qsample_last_valid Last Sample
ppvemenge qppvemenge Selected Set
ppvewerk qppvewerk Plant
ppvecodgra qppvecodgr Code Group
ppvecodea qppvecoda Code
ppvecodgrr qppvecodgr Code Group
ppvecoder qppvecodr Code
function1 qfbname Name
function1_act qfb_active Use func module
function2 qfbname Name
function2_act qfb_active Use func module
function3 qfbname Name
function3_act qfb_active Use func module
function4 qfbname Name
function4_act qfb_active Use func module

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.

-- Table with inspection point/user field combinations
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TQ79 (
    MANDT,          -- Client [mandt]
    SLWBEZ,         -- Field Combinat. [qslwbez]
    PPKTTYP,        -- InspPt type [qppkttyp]
    EQUNRAKT,       -- User Fld Active [qkzusrakt]
    TPLNRAKT,       -- User Fld Active [qkzusrakt]
    PHYNRAKT,       -- User Fld Active [qkzusrakt]
    SFI_AKT,        -- User Fld Active [qkzusrakt]
    USERC1AKT,      -- User Fld Active [qkzusrakt]
    USERC2AKT,      -- User Fld Active [qkzusrakt]
    USERN1AKT,      -- User Fld Active [qkzusrakt]
    USERN2AKT,      -- User Fld Active [qkzusrakt]
    USERD1AKT,      -- User Fld Active [qkzusrakt]
    USERT1AKT,      -- User Fld Active [qkzusrakt]
    PROBEANZ,       -- InspPtSummz [qprobeanz]
    LAST_VALID,     -- Last Sample [qsample_last_valid]
    PPVEMENGE,      -- Selected Set [qppvemenge]
    PPVEWERK,       -- Plant [qppvewerk]
    PPVECODGRA,     -- Code Group [qppvecodgr]
    PPVECODEA,      -- Code [qppvecoda]
    PPVECODGRR,     -- Code Group [qppvecodgr]
    PPVECODER,      -- Code [qppvecodr]
    FUNCTION1,      -- Name [qfbname]
    FUNCTION1_ACT,  -- Use func module [qfb_active]
    FUNCTION2,      -- Name [qfbname]
    FUNCTION2_ACT,  -- Use func module [qfb_active]
    FUNCTION3,      -- Name [qfbname]
    FUNCTION3_ACT,  -- Use func module [qfb_active]
    FUNCTION4,      -- Name [qfbname]
    FUNCTION4_ACT,  -- Use func module [qfb_active]
    PRIMARY KEY (MANDT, SLWBEZ)
);

Learn More