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