SAP table KNVK (Customer Master Contact Partner)

SAP table KNVK has 2 primary key fields being MANDT,PARNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
PARNR Number of Contact Person NUMC 10 0 PARNR
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
NAMEV First name CHAR 35 0 NAMEV_VP
NAME1 Name 1 CHAR 35 0 NAME1_GP
ORT01 City CHAR 35 0 ORT01_GP
ADRND Business address CHAR 10 0 * ADRND
ADRNP Home address CHAR 10 0 * ADRNP
ABTPA Contact person's department at customer CHAR 12 0 ABTEI_PA
ABTNR Contact person department CHAR 4 0 TSAB ABTNR_PA
UEPAR Higher-Level Partner NUMC 10 0 UEPAR
TELF1 First telephone number CHAR 16 0 TELF1
ANRED Form of address for contact person (Mr, Mrs...etc) CHAR 30 0 ANRED_AP
PAFKT Contact person function CHAR 2 0 TPFK PAFKT
PARVO Partner's Authority CHAR 1 0 TVPV PARVO
PAVIP VIP Partner CHAR 1 0 TVIP PAVIP
PARGE Partner's gender CHAR 1 0 * PARGE
PARLA Partner language LANG 1 0 T002 PARLA
GBDAT Date of Birth DATS 8 0 GBDAT
VRTNR Representative number NUMC 10 0 VTRNR
BRYTH Call frequency CHAR 4 0 TVBR BRYTH
AKVER Buying habits CHAR 2 0 TVAV AKVER
NMAIL Advertising material indicator CHAR 1 0 NMAIL
PARAU Notes about contact person CHAR 40 0 PARAU
PARH1 Contact person: Attribute 1 CHAR 2 0 TVPH PAAT1
PARH2 Contact person: Attribute 2 CHAR 2 0 TVP2 PAAT2
PARH3 Contact person: Attribute 3 CHAR 2 0 TVP3 PAAT3
PARH4 Contact person: Attribute 4 CHAR 2 0 TVP4 PAAT4
PARH5 Contact person: Attribute 5 CHAR 2 0 TVP5 PAAT5
MOAB1 Contact person's visiting hours: Monday morning from ... TIMS 6 0 BEMOAB1
MOBI1 Contact person's visiting hours: Monday morning until ... TIMS 6 0 BEMOBI1
MOAB2 Contact person's visiting hours: Monday afternoon from ... TIMS 6 0 BEMOAB2
MOBI2 Contact person's visiting hours: Monday afternoon until ... TIMS 6 0 BEMOBI2
DIAB1 Contact person's visiting hours: Tuesday morning from... TIMS 6 0 BEDIAB1
DIBI1 Contact person's visiting hours: Tuesday morning until ... TIMS 6 0 BEDIBI1
DIAB2 Contact person's visiting hours: Tuesday afternoon from.. TIMS 6 0 BEDIAB2
DIBI2 Contact person's visiting hours: Tuesday afternoon until ... TIMS 6 0 BEDIBI2
MIAB1 Contact person's visiting hours: Wednesday morning from... TIMS 6 0 BEMIAB1
MIBI1 Contact person's visiting hours: Wednesday morning until ... TIMS 6 0 BEMIBI1
MIAB2 Contact person's visiting hours: Wednesday afternoon from .. TIMS 6 0 BEMIAB2
MIBI2 Contact person's visiting hours: Wednesday afternoon until.. TIMS 6 0 BEMIBI2
DOAB1 Contact person's visiting hours: Thursday morning from .... TIMS 6 0 BEDOAB1
DOBI1 Contact person's visiting hours: Thursday morning until .... TIMS 6 0 BEDOBI1
DOAB2 Contact person's visiting hours: Thursday afternoon from... TIMS 6 0 BEDOAB2
DOBI2 Contact person's visiting hours: Thursday afternoon until .. TIMS 6 0 BEDOBI2
FRAB1 Contact person's visiting hours: Friday morning from ... TIMS 6 0 BEFRAB1
FRBI1 Contact person's visiting hours: Friday morning until ... TIMS 6 0 BEFRBI1
FRAB2 Contact person's visiting hours: Friday afternoon from ... TIMS 6 0 BEFRAB2
FRBI2 Contact person's visiting hours: Friday afternoon until ... TIMS 6 0 BEFRBI2
SAAB1 Contact person's visiting hours: Saturday morning from ... TIMS 6 0 BESAAB1
SABI1 Contact person's visiting hours: Saturday morning until ... TIMS 6 0 BESABI1
SAAB2 Contact person's visiting hours: Saturday afternoon from ... TIMS 6 0 BESAAB2
SABI2 Contact person's visiting hours: Saturday afternoon until .. TIMS 6 0 BESABI2
SOAB1 Contact person's visiting hours: Sunday morning from ... TIMS 6 0 BESOAB1
SOBI1 Contact person's visiting hours: Sunday morning until ... TIMS 6 0 BESOBI1
SOAB2 Contact person's visiting hours: Sunday afternoon from ... TIMS 6 0 BESOAB2
SOBI2 Contact person's visiting hours: Sunday afternoon until ... TIMS 6 0 BESOBI2
PAKN1 Contact person: Attribute 6 CHAR 3 0 TVP6 PAAT6
PAKN2 Contact person: Attribute 7 CHAR 3 0 TVP7 PAAT7
PAKN3 Contact person: Attribute 8 CHAR 3 0 TVP8 PAAT8
PAKN4 Contact person: Attribute 9 CHAR 3 0 TVP9 PAAT9
PAKN5 Contact person: Attribute 10 CHAR 3 0 TVP0 PAAT0
SORTL Sort field CHAR 10 0 SORTL
FAMST Marital Status Key CHAR 1 0 T502T FAMST
SPNAM Nickname CHAR 10 0 SPNAM
TITEL_AP Title of contact person (description of function) CHAR 35 0 TITEL_AP
ERDAT Date on which the Record Was Created DATS 8 0 ERDAT_RF
ERNAM Name of Person who Created the Object CHAR 12 0 ERNAM_RF
DUEFL Status of Data Transfer into Subsequent Release CHAR 1 0 DUEFL_BKPF
Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LOEVM Central Deletion Flag for Master Record CHAR 1 0 LOEVM_X
KZHERK Internal indicator for origin of the CP: Customer or Vendor CHAR 1 0 KZHERK
ADRNP_2 Address Number CHAR 10 0 * AD_ADDRNUM
PRSNR Person Number CHAR 10 0 AD_PERSNUM
CVP_XBLCK_K Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked

KNVK foreign key relationships

Table Field Check Table Check Field
0 KNVK ABTNR TSAB Contact persons: standard departments MANDT
0 KNVK ABTNR TSAB Contact persons: standard departments ABTNR
1 KNVK AKVER TVAV Contact Person: Buying Habits MANDT
0 KNVK BRYTH TVBR Contact Person: Frequency of Visits MANDT
0 KNVK BRYTH TVBR Contact Person: Frequency of Visits BRYTH
1 KNVK FAMST T502T Marital Status Designators MANDT
1 KNVK FAMST T502T Marital Status Designators SPRSL
1 KNVK FAMST T502T Marital Status Designators FAMST
0 KNVK KUNNR KNA1 General Data in Customer Master MANDT
0 KNVK KUNNR KNA1 General Data in Customer Master KUNNR
1 KNVK LIFNR LFA1 Supplier Master (General Section) MANDT
1 KNVK LIFNR LFA1 Supplier Master (General Section) LIFNR
0 KNVK PAFKT TPFK Contact Persons: Functions MANDT
0 KNVK PAFKT TPFK Contact Persons: Functions PAFKT
1 KNVK PAKN1 TVP6 Contact Person: Attribute 6 MANDT
0 KNVK PAKN2 TVP7 Contact Person: Attribute 7 MANDT
1 KNVK PAKN3 TVP8 Contact Person: Attribute 8 MANDT
0 KNVK PAKN4 TVP9 Contact Person: Attribute 9 MANDT
1 KNVK PAKN5 TVP0 Contact Person: Attribute 10 MANDT
0 KNVK PARH1 TVPH Contact Person: Hobbies MANDT
1 KNVK PARH2 TVP2 Contact Person: Attribute 2 MANDT
1 KNVK PARH2 TVP2 Contact Person: Attribute 2 PAAT2
0 KNVK PARH3 TVP3 Contact Person: Attribute 3 MANDT
0 KNVK PARH3 TVP3 Contact Person: Attribute 3 PAAT3
1 KNVK PARH4 TVP4 Contact Person: Attribute 4 MANDT
1 KNVK PARH4 TVP4 Contact Person: Attribute 4 PAAT4
0 KNVK PARH5 TVP5 Contact Person: Attribute 5 MANDT
0 KNVK PARH5 TVP5 Contact Person: Attribute 5 PAAT5
1 KNVK PARLA T002 Language Keys (Component BC-I18) SPRAS
0 KNVK PARVO TVPV Contact Person: Decision Authority MANDT
0 KNVK PARVO TVPV Contact Person: Decision Authority PARVO
1 KNVK PAVIP TVIP Contact Person: VIP Indicator MANDT
1 KNVK PAVIP TVIP Contact Person: VIP Indicator PAVIP