KNMT_ADDR

Transparent Table Application Table
7 Fields 1 CDS Views

Customer-Material Info Record - Address dep. attributes

KNMT_ADDR is an SAP database table in S/4HANA. Customer-Material Info Record - Address dep. attributes. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CustMatlAddrDepdntInfo view from BASIC Customer Material Address Dependent Info

Fields (7)

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
KEY adrnr BU_ADDRNUM Address Number
werks WERKS_EXT Plant

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 - Address dep. attributes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNMT_ADDR (
    MANDT,  -- Client [MANDT]
    VKORG,  -- Sales Org. [VKORG]
    VTWEG,  -- Distr. Channel [VTWEG]
    KUNNR,  -- Customer [KUNNR_V]
    MATNR,  -- Material [MATNR]
    ADRNR,  -- Address Number [BU_ADDRNUM]
    WERKS,  -- Plant [WERKS_EXT]
    PRIMARY KEY (MANDT, VKORG, VTWEG, KUNNR, MATNR, ADRNR)
);

Learn More