KNVV_ADDR

Transparent Table Application Table
6 Fields 2 CDS Views

Customer Master Sales Data - Address dep. attributes

KNVV_ADDR is an SAP database table in S/4HANA. Customer Master Sales Data - Address dep. attributes. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CustSlsAreaAddrDepdntInfo view from EXTENSION Ext: Info Depdnt on Cust Addr Sls Area
I_CustSlsAreaAddrDepdntInfo view from BASIC Info Depdnt on Cust Addr and Sales Area

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kunnr kunnr Customer
KEY adrnr bu_addrnum Address Number
KEY vkorg vkorg Sales Org.
KEY vtweg vtweg Distr. Channel
KEY spart spart Division

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 Master Sales Data - Address dep. attributes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVV_ADDR (
    MANDT,  -- Client [mandt]
    KUNNR,  -- Customer [kunnr]
    ADRNR,  -- Address Number [bu_addrnum]
    VKORG,  -- Sales Org. [vkorg]
    VTWEG,  -- Distr. Channel [vtweg]
    SPART,  -- Division [spart]
    PRIMARY KEY (MANDT, KUNNR, ADRNR, VKORG, VTWEG, SPART)
);

Learn More