KNVV_ADDR

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

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
inco1 INCO1 Incoterms
lifsd LIFSD_V DelBlckSalesAr.
vkbur VKBUR Sales Office
vkgrp VKGRP Sales Group
vsbed VSBED Shipping Conditions
vwerk DWERK_EXT Deliver.Plant
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
knvv_addr_eew_cust KNVV_ADDR_EEW_CUST Customer sales addr. dep. extensibility
inco2_key /SCMTMS/INC_LOC_1_KEY Incoterm Location 1
inco3_key /SCMTMS/INC_LOC_2_KEY Incoterm Location 2
inco4_key /SCMTMS/INC_DEV_PLACE_DEST_KEY Dev. Destination

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]
    INCO1,               -- Incoterms [INCO1]
    LIFSD,               -- DelBlckSalesAr. [LIFSD_V]
    VKBUR,               -- Sales Office [VKBUR]
    VKGRP,               -- Sales Group [VKGRP]
    VSBED,               -- Shipping Conditions [VSBED]
    VWERK,               -- Deliver.Plant [DWERK_EXT]
    INCOV,               -- Inco. Version [INCOV]
    INCO2_L,             -- Inco. Location1 [INCO2_L]
    INCO3_L,             -- Inco. Location2 [INCO3_L]
    KNVV_ADDR_EEW_CUST,  -- Customer sales addr. dep. extensibility [KNVV_ADDR_EEW_CUST]
    INCO2_KEY,           -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY]
    INCO3_KEY,           -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY]
    INCO4_KEY,           -- Dev. Destination [/SCMTMS/INC_DEV_PLACE_DEST_KEY]
    PRIMARY KEY (MANDT, KUNNR, ADRNR, VKORG, VTWEG, SPART)
);

Learn More