KNVH

Transparent Table Application Table
18 Fields 2 CDS Views

Customer Hierarchies

KNVH is an SAP database table in S/4HANA. Customer Hierarchies. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CustomerBySalesHierarchyNode view from BASIC Hierarchy node for Cust by Sales Area
SHSM_KNVH view from CDS view replacing KNVH in search help KNVH

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hityp HITYP_KH Hierarchy type
KEY kunnr KUNNR_KH Customer
KEY vkorg VKORG Sales Org.
KEY vtweg VTWEG Distr. Channel
KEY spart SPART Division
KEY datab DATAB_KH Valid from
datbi DATBI_KH Valid to
hkunnr HKUNNR_KH HgLvCust.
hvkorg HVKORG HgLv sales org.
hvtweg HVTWEG HgLv.distrib.ch
hspart HSPART HgLv division
grpno GRPNO Routine Number
bokre BOKRE Rebate
prfre PRFRE Price determin.
hzuor HZUOR Hier.assignment
node_guid NODE_GUID_KH Cu. Hr. Node GUID
node_id NODE_ID_KH Cu. Hr. Node ID

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 Hierarchies
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVH (
    MANDT,      -- Client [MANDT]
    HITYP,      -- Hierarchy type [HITYP_KH]
    KUNNR,      -- Customer [KUNNR_KH]
    VKORG,      -- Sales Org. [VKORG]
    VTWEG,      -- Distr. Channel [VTWEG]
    SPART,      -- Division [SPART]
    DATAB,      -- Valid from [DATAB_KH]
    DATBI,      -- Valid to [DATBI_KH]
    HKUNNR,     -- HgLvCust. [HKUNNR_KH]
    HVKORG,     -- HgLv sales org. [HVKORG]
    HVTWEG,     -- HgLv.distrib.ch [HVTWEG]
    HSPART,     -- HgLv division [HSPART]
    GRPNO,      -- Routine Number [GRPNO]
    BOKRE,      -- Rebate [BOKRE]
    PRFRE,      -- Price determin. [PRFRE]
    HZUOR,      -- Hier.assignment [HZUOR]
    NODE_GUID,  -- Cu. Hr. Node GUID [NODE_GUID_KH]
    NODE_ID,    -- Cu. Hr. Node ID [NODE_ID_KH]
    PRIMARY KEY (MANDT, HITYP, KUNNR, VKORG, VTWEG, SPART, DATAB)
);

Learn More