KNMT

Transparent Table Application Table
30 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 30 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 (30)

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
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]
    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