QPMKLTEXT

Transparent Table Application Table
14 Fields 1 CDS Views

Master Inspection Characteristic Long Text

QPMKLTEXT is an SAP database table in S/4HANA. Master Inspection Characteristic Long Text. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InspSpecVersionLongText view_entity from BASIC MIC Long Text

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY zaehler QZAEHLER Plant
KEY mkmnr QMERKNR Master IC
KEY version QVERSNRMK Version
KEY counter QLTCOUNTER Counter
KEY langu LANGU Language
created_by ERNAM Created By
created_at TZNTSTMPS Time Stamp
changed_by AENAM Changed By
changed_at TZNTSTMPS Time Stamp
textid TDID Text ID
content QLONGTEXT Long Text
mimetype DD_FTI_MIME_TYPE MIME Type
txt_compatibility QTXT_COMPATIBILITY Text Compatibility

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.

-- Master Inspection Characteristic Long Text
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QPMKLTEXT (
    CLIENT,             -- Client [MANDT]
    ZAEHLER,            -- Plant [QZAEHLER]
    MKMNR,              -- Master IC [QMERKNR]
    VERSION,            -- Version [QVERSNRMK]
    COUNTER,            -- Counter [QLTCOUNTER]
    LANGU,              -- Language [LANGU]
    CREATED_BY,         -- Created By [ERNAM]
    CREATED_AT,         -- Time Stamp [TZNTSTMPS]
    CHANGED_BY,         -- Changed By [AENAM]
    CHANGED_AT,         -- Time Stamp [TZNTSTMPS]
    TEXTID,             -- Text ID [TDID]
    CONTENT,            -- Long Text [QLONGTEXT]
    MIMETYPE,           -- MIME Type [DD_FTI_MIME_TYPE]
    TXT_COMPATIBILITY,  -- Text Compatibility [QTXT_COMPATIBILITY]
    PRIMARY KEY (CLIENT, ZAEHLER, MKMNR, VERSION, COUNTER, LANGU)
);

Learn More