KNVP

Transparent Table Application Table
14 Fields 6 CDS Views

Customer Master Partner Functions

KNVP is an SAP database table in S/4HANA. Customer Master Partner Functions. It contains 14 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/dmbe/i_Shipto_With_Admin_Data view inner Ship To View Contaning Admin Data
/dmbe/i_Shipto_Without_Adm_Dat view inner Ship To View With Empty Admin Data
I_BusinessPartnerPartFunc view from BASIC Core view for BP Partner Functions
I_CustomerPartnerFunction view from BASIC Core for BP Partner Functions
I_CustSalesPartnerFunc view from BASIC Customer Sales Area Partner Function
I_CustSalesPartnerFunc_2 view from BASIC Customer Sales Area Partner Function

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kunnr KUNNR Customer
KEY vkorg VKORG Sales Org.
KEY vtweg VTWEG Distr. Channel
KEY spart SPART Division
KEY parvw PARVW Partner Functn
KEY parza PARZA Partner counter
kunn2 KUNN2 Customer
lifnr LIFNR Supplier
pernr PERNR_D Personnel No.
parnr PARNR Contact Person
knref KNREF Partner desc.
defpa DEFPA Default Partner
adrnr BU_ADDRNUM Address Number

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 Partner Functions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVP (
    MANDT,  -- Client [MANDT]
    KUNNR,  -- Customer [KUNNR]
    VKORG,  -- Sales Org. [VKORG]
    VTWEG,  -- Distr. Channel [VTWEG]
    SPART,  -- Division [SPART]
    PARVW,  -- Partner Functn [PARVW]
    PARZA,  -- Partner counter [PARZA]
    KUNN2,  -- Customer [KUNN2]
    LIFNR,  -- Supplier [LIFNR]
    PERNR,  -- Personnel No. [PERNR_D]
    PARNR,  -- Contact Person [PARNR]
    KNREF,  -- Partner desc. [KNREF]
    DEFPA,  -- Default Partner [DEFPA]
    ADRNR,  -- Address Number [BU_ADDRNUM]
    PRIMARY KEY (MANDT, KUNNR, VKORG, VTWEG, SPART, PARVW, PARZA)
);

Learn More