KNMT

Transparent Table Application Table
31 Fields 7 CDS Views

Customer-Material Info Record Data Table

KNMT is an SAP database table in S/4HANA. Customer-Material Info Record Data Table. It contains 31 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_CustomerMaterial view from EXTENSION Extension View for KNMT
I_CustomerMaterial view from BASIC Customer Material Information
I_CustomerMaterial_2 view from BASIC Customer Material
I_CustomerMaterialValueHelp view from BASIC Customer Material Value Help
P_CL_SDM_SD_KNMT_SORTL view from BASIC
SHSM_KNMT_REF view from CDS View replacing KNMT_REF
SHSM_KNMT_REF view union CDS View replacing KNMT_REF

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vkorg VKORG Sales Org.
KEY vtweg VTWEG Distr. Channel
KEY kunnr KUNNR_V Customer
KEY matnr MATNR Material
ernam ERNAM Created By
erdat ERDAT Created On
sortl SORTL Search term
kdmat MATNR_KU Cust. Material
postx KDPTX Customer Descr.
lprio LPRIO Delivery Prior.
minlf MINLF Min. Dely Qty
meins MEINS Base Unit
chspl CHSPL Batch split
kztlf KZTLF Part.dlv./item
antlf ANTLF Max.Part.Deliv.
untto UNTTO Underdel. Tol.
uebto UEBTO Overdeliv. Tol.
uebtk UEBTK_V Unlimited Tol.
werks WERKS_EXT Plant
rdprf RDPRF Rnding Profile
megru MEGRU UoM Group
j_1btxsdc J_1BTXSDC_ Tax Code
vwpos VWPOS Item Usage
vrkme_t VRKME Sales Unit
umvkn_t UMVKN Denominat.
umvkz_t UMVKZ Numerator
guid SYSUUID_X16 UUID
dummy_slscusmat_incl_eew_ps DUMMY Dummy function in length 1
upd_tmstmp TIMESTAMPL Time Stamp
last_changed_by_user LAST_CHANGED_BY_USER Last Changed By

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.

-- Customer-Material Info Record Data Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNMT (
    MANDT,                        -- Client [MANDT]
    VKORG,                        -- Sales Org. [VKORG]
    VTWEG,                        -- Distr. Channel [VTWEG]
    KUNNR,                        -- Customer [KUNNR_V]
    MATNR,                        -- Material [MATNR]
    ERNAM,                        -- Created By [ERNAM]
    ERDAT,                        -- Created On [ERDAT]
    SORTL,                        -- Search term [SORTL]
    KDMAT,                        -- Cust. Material [MATNR_KU]
    POSTX,                        -- Customer Descr. [KDPTX]
    LPRIO,                        -- Delivery Prior. [LPRIO]
    MINLF,                        -- Min. Dely Qty [MINLF]
    MEINS,                        -- Base Unit [MEINS]
    CHSPL,                        -- Batch split [CHSPL]
    KZTLF,                        -- Part.dlv./item [KZTLF]
    ANTLF,                        -- Max.Part.Deliv. [ANTLF]
    UNTTO,                        -- Underdel. Tol. [UNTTO]
    UEBTO,                        -- Overdeliv. Tol. [UEBTO]
    UEBTK,                        -- Unlimited Tol. [UEBTK_V]
    WERKS,                        -- Plant [WERKS_EXT]
    RDPRF,                        -- Rnding Profile [RDPRF]
    MEGRU,                        -- UoM Group [MEGRU]
    J_1BTXSDC,                    -- Tax Code [J_1BTXSDC_]
    VWPOS,                        -- Item Usage [VWPOS]
    VRKME_T,                      -- Sales Unit [VRKME]
    UMVKN_T,                      -- Denominat. [UMVKN]
    UMVKZ_T,                      -- Numerator [UMVKZ]
    GUID,                         -- UUID [SYSUUID_X16]
    DUMMY_SLSCUSMAT_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    UPD_TMSTMP,                   -- Time Stamp [TIMESTAMPL]
    LAST_CHANGED_BY_USER,         -- Last Changed By [LAST_CHANGED_BY_USER]
    PRIMARY KEY (MANDT, VKORG, VTWEG, KUNNR, MATNR)
);

Learn More