QPAM

Transparent Table Customizing Table
15 Fields 3 CDS Views

Inspection catalog selected sets

QPAM is an SAP database table in S/4HANA. Inspection catalog selected sets. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CharcAttribSelectedCodeSet view from BASIC Selected Set for Characteristic Attribute
I_InspectionSelectedSet view from BASIC Inspection Selected Set
I_UsageDcsnSelectedCodeSet view from BASIC Selected Set of Codes for Usage Decision

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY werks WERKS_D Plant
KEY katalogart QKATART Catalog
KEY auswahlmge QAUSWAHLMG Selected Set
ksp01 SPRAS Language
ktx01 QKTEXTAM Short Text
ltextv QLTEXTMGE Long Text
ersteller QERSTELLER Created By
e_datum QDATUMERST Created On
aenderer QAENDERER Changed By
a_datum QDATUMAEND Changed On
verwendung QVERW Record Used
status QLOESCHKZ1 Status
defaultcodegr QDEFAULTCODEGRP Default Code Group
defaultcode QDEFAULTCODE Default Code

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 catalog selected sets
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPAM (
    MANDT,          -- Client [MANDT]
    WERKS,          -- Plant [WERKS_D]
    KATALOGART,     -- Catalog [QKATART]
    AUSWAHLMGE,     -- Selected Set [QAUSWAHLMG]
    KSP01,          -- Language [SPRAS]
    KTX01,          -- Short Text [QKTEXTAM]
    LTEXTV,         -- Long Text [QLTEXTMGE]
    ERSTELLER,      -- Created By [QERSTELLER]
    E_DATUM,        -- Created On [QDATUMERST]
    AENDERER,       -- Changed By [QAENDERER]
    A_DATUM,        -- Changed On [QDATUMAEND]
    VERWENDUNG,     -- Record Used [QVERW]
    STATUS,         -- Status [QLOESCHKZ1]
    DEFAULTCODEGR,  -- Default Code Group [QDEFAULTCODEGRP]
    DEFAULTCODE,    -- Default Code [QDEFAULTCODE]
    PRIMARY KEY (MANDT, WERKS, KATALOGART, AUSWAHLMGE)
);

Learn More