KNMTA

Transparent Table Application Table
4 Fields 2 CDS Views

Additional Customer-Material in CMIR

KNMTA is an SAP database table in S/4HANA. Additional Customer-Material in CMIR. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_AdditionalCustomerMaterial view from BASIC Additional Customer Materials
SHSM_KNMT_REF view inner CDS View replacing KNMT_REF

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY guid SYSUUID_X16 UUID
KEY kdmat MATNR_KU Cust. Material
addpostx ADDPOSTX CustMatDescr.

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.

-- Additional Customer-Material in CMIR
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNMTA (
    MANDT,     -- Client [MANDT]
    GUID,      -- UUID [SYSUUID_X16]
    KDMAT,     -- Cust. Material [MATNR_KU]
    ADDPOSTX,  -- CustMatDescr. [ADDPOSTX]
    PRIMARY KEY (MANDT, GUID, KDMAT)
);

Learn More