KNVK

Transparent Table Application Table
75 Fields 5 CDS Views

Customer Master Contact Partner

KNVK is an SAP database table in S/4HANA. Customer Master Contact Partner. It contains 75 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_BPCONTACT_D view from EXTENSION Extensibility BP Contact Core
I_ContactPerson view from BASIC Contact Person
I_ContactPersonDEX view_entity from BASIC Data Extraction for Contact Person
I_PMContactPerson view_entity from BASIC Plant Maintenance Contact Person
SHSM_UDM_CONTACT_PERS view from Value-Help for Customer Contacts

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY parnr PARNR Contact Person
kunnr KUNNR Customer
namev NAMEV_VP First Name
name1 NAME1_GP Name
ort01 ORT01_GP City
adrnd ADRND BusinessAddress
adrnp ADRNP Home address
abtpa ABTEI_PA Customer dept.
abtnr ABTNR_PA Department
uepar UEPAR HighLevelPartnr
telf1 TELF1 Telephone 1
anred ANRED_AP Form of address
pafkt PAFKT Function
parvo PARVO Authority
pavip PAVIP VIP
parge PARGE Gender
parla PARLA Language
gbdat GBDAT Birth date
vrtnr VTRNR Represent.no.
bryth BRYTH Call frequency
akver AKVER Buying habits
nmail NMAIL Advertising mat
parau PARAU Notes
parh1 PAAT1 Attribute 1
parh2 PAAT2 Attribute 2
parh3 PAAT3 Attribute 3
parh4 PAAT4 Attribute 4
parh5 PAAT5 Attribute 5
moab1 BEMOAB1 Monday
mobi1 BEMOBI1 Monday
moab2 BEMOAB2 Monday
mobi2 BEMOBI2 Monday
diab1 BEDIAB1 Tuesday
dibi1 BEDIBI1 Tuesday
diab2 BEDIAB2 Tuesday
dibi2 BEDIBI2 Tuesday
miab1 BEMIAB1 Wednesday
mibi1 BEMIBI1 Wednesday
miab2 BEMIAB2 Wednesday
mibi2 BEMIBI2 Wednesday
doab1 BEDOAB1 Thursday
dobi1 BEDOBI1 Thursday
doab2 BEDOAB2 Thursday
dobi2 BEDOBI2 Thursday
frab1 BEFRAB1 Friday
frbi1 BEFRBI1 Friday
frab2 BEFRAB2 Friday
frbi2 BEFRBI2 Friday
saab1 BESAAB1 Saturday
sabi1 BESABI1 Saturday
saab2 BESAAB2 Saturday
sabi2 BESABI2 Saturday
soab1 BESOAB1 Sunday
sobi1 BESOBI1 Sunday
soab2 BESOAB2 Sunday
sobi2 BESOBI2 Sunday
pakn1 PAAT6 Attribute 6
pakn2 PAAT7 Attribute 7
pakn3 PAAT8 Attribute 8
pakn4 PAAT9 Attribute 9
pakn5 PAAT0 Attribute 10
sortl SORTL Search term
famst FAMST Marital stat.
spnam SPNAM Nickname
titel_ap TITEL_AP Title/function
erdat ERDAT_RF Created On
ernam ERNAM_RF Created by
duefl DUEFL_BKPF Data Transfer Status
lifnr LIFNR Supplier
loevm LOEVM_X Deletion Flag
kzherk KZHERK Origin
adrnp_2 AD_ADDRNUM Address Number
prsnr AD_PERSNUM Person Number
cvp_xblck_k CVP_XBLCK Purpose Completed

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 Contact Partner
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVK (
    MANDT,        -- Client [MANDT]
    PARNR,        -- Contact Person [PARNR]
    KUNNR,        -- Customer [KUNNR]
    NAMEV,        -- First Name [NAMEV_VP]
    NAME1,        -- Name [NAME1_GP]
    ORT01,        -- City [ORT01_GP]
    ADRND,        -- BusinessAddress [ADRND]
    ADRNP,        -- Home address [ADRNP]
    ABTPA,        -- Customer dept. [ABTEI_PA]
    ABTNR,        -- Department [ABTNR_PA]
    UEPAR,        -- HighLevelPartnr [UEPAR]
    TELF1,        -- Telephone 1 [TELF1]
    ANRED,        -- Form of address [ANRED_AP]
    PAFKT,        -- Function [PAFKT]
    PARVO,        -- Authority [PARVO]
    PAVIP,        -- VIP [PAVIP]
    PARGE,        -- Gender [PARGE]
    PARLA,        -- Language [PARLA]
    GBDAT,        -- Birth date [GBDAT]
    VRTNR,        -- Represent.no. [VTRNR]
    BRYTH,        -- Call frequency [BRYTH]
    AKVER,        -- Buying habits [AKVER]
    NMAIL,        -- Advertising mat [NMAIL]
    PARAU,        -- Notes [PARAU]
    PARH1,        -- Attribute 1 [PAAT1]
    PARH2,        -- Attribute 2 [PAAT2]
    PARH3,        -- Attribute 3 [PAAT3]
    PARH4,        -- Attribute 4 [PAAT4]
    PARH5,        -- Attribute 5 [PAAT5]
    MOAB1,        -- Monday [BEMOAB1]
    MOBI1,        -- Monday [BEMOBI1]
    MOAB2,        -- Monday [BEMOAB2]
    MOBI2,        -- Monday [BEMOBI2]
    DIAB1,        -- Tuesday [BEDIAB1]
    DIBI1,        -- Tuesday [BEDIBI1]
    DIAB2,        -- Tuesday [BEDIAB2]
    DIBI2,        -- Tuesday [BEDIBI2]
    MIAB1,        -- Wednesday [BEMIAB1]
    MIBI1,        -- Wednesday [BEMIBI1]
    MIAB2,        -- Wednesday [BEMIAB2]
    MIBI2,        -- Wednesday [BEMIBI2]
    DOAB1,        -- Thursday [BEDOAB1]
    DOBI1,        -- Thursday [BEDOBI1]
    DOAB2,        -- Thursday [BEDOAB2]
    DOBI2,        -- Thursday [BEDOBI2]
    FRAB1,        -- Friday [BEFRAB1]
    FRBI1,        -- Friday [BEFRBI1]
    FRAB2,        -- Friday [BEFRAB2]
    FRBI2,        -- Friday [BEFRBI2]
    SAAB1,        -- Saturday [BESAAB1]
    SABI1,        -- Saturday [BESABI1]
    SAAB2,        -- Saturday [BESAAB2]
    SABI2,        -- Saturday [BESABI2]
    SOAB1,        -- Sunday [BESOAB1]
    SOBI1,        -- Sunday [BESOBI1]
    SOAB2,        -- Sunday [BESOAB2]
    SOBI2,        -- Sunday [BESOBI2]
    PAKN1,        -- Attribute 6 [PAAT6]
    PAKN2,        -- Attribute 7 [PAAT7]
    PAKN3,        -- Attribute 8 [PAAT8]
    PAKN4,        -- Attribute 9 [PAAT9]
    PAKN5,        -- Attribute 10 [PAAT0]
    SORTL,        -- Search term [SORTL]
    FAMST,        -- Marital stat. [FAMST]
    SPNAM,        -- Nickname [SPNAM]
    TITEL_AP,     -- Title/function [TITEL_AP]
    ERDAT,        -- Created On [ERDAT_RF]
    ERNAM,        -- Created by [ERNAM_RF]
    DUEFL,        -- Data Transfer Status [DUEFL_BKPF]
    LIFNR,        -- Supplier [LIFNR]
    LOEVM,        -- Deletion Flag [LOEVM_X]
    KZHERK,       -- Origin [KZHERK]
    ADRNP_2,      -- Address Number [AD_ADDRNUM]
    PRSNR,        -- Person Number [AD_PERSNUM]
    CVP_XBLCK_K,  -- Purpose Completed [CVP_XBLCK]
    PRIMARY KEY (MANDT, PARNR)
);

Learn More