1. Home
  2. Resources
  3. SAP Tables
  4. KNVK - Customer Master Contact Partner

SAP Table KNVK

Customer Master Contact Partner

KNVK (Customer Master Contact Partner) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link KNVK to other SAP tables.

KNVK table fields

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

KNVK foreign key relationships

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