KNVK SAP (Customer Master Contact Partner) Table details

Dictionary Type: Table
Description: Customer Master Contact Partner




ABAP Code to SELECT data from KNVK
Related tables to KNVK
Access table KNVK




Table field list including key, data, relationships and ABAP select examples

KNVK is a standard SAP Table which is used to store Customer Master Contact Partner data and is available within R/3 SAP systems depending on the version and release level.

The KNVK table consists of various fields, each holding specific information or linking keys about Customer Master Contact Partner data available in SAP. These include PARNR (Number of contact person), KUNNR (Customer Numbers), NAMEV (First name), NAME1 (Name 1).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP KNVK table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PARNRNumber of contact person PARNRNUMC10PARNRVPA
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
NAMEVFirst name NAMEV_VPCHAR35NAME
NAME1Name 1 NAME1_GPCHAR35NAME
ORT01City ORT01_GPCHAR35TEXT35
ADRNDBusiness address ADRNDCHAR10Assigned to domainALPHAADRNR
ADRNPHome address ADRNPCHAR10Assigned to domainALPHAADRNR
ABTPAContact person's department at customer ABTEI_PACHAR12ABTEI
ABTNRContact person department ABTNR_PACHAR4TSABABTNR
UEPARHigher-level partner UEPARNUMC10PARNR
TELF1First telephone number TELF1CHAR16TEXT16
ANREDForm of address for contact person (Mr, Mrs...etc) ANRED_APCHAR30TEXT30
PAFKTContact person function PAFKTCHAR2TPFKPAFKT
PARVOPartner's Authority PARVOCHAR1TVPVPARVO
PAVIPVIP Partner PAVIPCHAR1TVIPPAVIP
PARGEPartner's gender PARGECHAR1GESCH
PARLAPartner language PARLALANG1T002ISOLASPRAS
GBDATDate of Birth GBDATDATS8PDATEGBDAT
VRTNRRepresentative number VTRNRNUMC10VTRNR
BRYTHCall frequency BRYTHCHAR4TVBRBRYTH
AKVERBuying habits AKVERCHAR2TVAVAKVER
NMAILAdvertising material indicator NMAILCHAR1XFELD
PARAUNotes about contact person PARAUCHAR40TEXT40
PARH1Contact person: Attribute 1 PAAT1CHAR2TVPHPARHO
PARH2Contact person: Attribute 2 PAAT2CHAR2TVP2PAAT2
PARH3Contact person: Attribute 3 PAAT3CHAR2TVP3PAAT3
PARH4Contact person: Attribute 4 PAAT4CHAR2TVP4PAAT4
PARH5Contact person: Attribute 5 PAAT5CHAR2TVP5PAAT5
MOAB1Contact person's visiting hours: Monday morning from ... BEMOAB1TIMS6UHRZT
MOBI1Contact person's visiting hours: Monday morning until ... BEMOBI1TIMS6UHRZT
MOAB2Contact person's visiting hours: Monday afternoon from ... BEMOAB2TIMS6UHRZT
MOBI2Contact person's visiting hours: Monday afternoon until ... BEMOBI2TIMS6UHRZT
DIAB1Contact person's visiting hours: Tuesday morning from... BEDIAB1TIMS6UHRZT
DIBI1Contact person's visiting hours: Tuesday morning until ... BEDIBI1TIMS6UHRZT
DIAB2Contact person's visiting hours: Tuesday afternoon from.. BEDIAB2TIMS6UHRZT
DIBI2Contact person's visiting hours: Tuesday afternoon until ... BEDIBI2TIMS6UHRZT
MIAB1Contact person's visiting hours: Wednesday morning from... BEMIAB1TIMS6UHRZT
MIBI1Contact person's visiting hours: Wednesday morning until ... BEMIBI1TIMS6UHRZT
MIAB2Contact person's visiting hours: Wednesday afternoon from .. BEMIAB2TIMS6UHRZT
MIBI2Contact person's visiting hours: Wednesday afternoon until.. BEMIBI2TIMS6UHRZT
DOAB1Contact person's visiting hours: Thursday morning from .... BEDOAB1TIMS6UHRZT
DOBI1Contact person's visiting hours: Thursday morning until .... BEDOBI1TIMS6UHRZT
DOAB2Contact person's visiting hours: Thursday afternoon from... BEDOAB2TIMS6UHRZT
DOBI2Contact person's visiting hours: Thursday afternoon until .. BEDOBI2TIMS6UHRZT
FRAB1Contact person's visiting hours: Friday morning from ... BEFRAB1TIMS6UHRZT
FRBI1Contact person's visiting hours: Friday morning until ... BEFRBI1TIMS6UHRZT
FRAB2Contact person's visiting hours: Friday afternoon from ... BEFRAB2TIMS6UHRZT
FRBI2Contact person's visiting hours: Friday afternoon until ... BEFRBI2TIMS6UHRZT
SAAB1Contact person's visiting hours: Saturday morning from ... BESAAB1TIMS6UHRZT
SABI1Contact person's visiting hours: Saturday morning until ... BESABI1TIMS6UHRZT
SAAB2Contact person's visiting hours: Saturday afternoon from ... BESAAB2TIMS6UHRZT
SABI2Contact person's visiting hours: Saturday afternoon until .. BESABI2TIMS6UHRZT
SOAB1Contact person's visiting hours: Sunday morning from ... BESOAB1TIMS6UHRZT
SOBI1Contact person's visiting hours: Sunday morning until ... BESOBI1TIMS6UHRZT
SOAB2Contact person's visiting hours: Sunday afternoon from ... BESOAB2TIMS6UHRZT
SOBI2Contact person's visiting hours: Sunday afternoon until ... BESOBI2TIMS6UHRZT
PAKN1Contact person: Attribute 6 PAAT6CHAR3TVP6PAAT6
PAKN2Contact person: Attribute 7 PAAT7CHAR3TVP7PAAT7
PAKN3Contact person: Attribute 8 PAAT8CHAR3TVP8PAAT8
PAKN4Contact person: Attribute 9 PAAT9CHAR3TVP9PAAT9
PAKN5Contact person: Attribute 10 PAAT0CHAR3TVP0PAAT0
SORTLSort field SORTLCHAR10CHAR10
FAMSTMarital Status Key FAMSTCHAR1T502TFAMST
SPNAMNickname SPNAMCHAR10TEXT10
TITEL_APTitle of contact person (description of function) TITEL_APCHAR35TEXT35
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
DUEFLStatus of Data Transfer into Subsequent Release DUEFL_BKPFCHAR1DUEFL_BKPF
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
LOEVMCentral Deletion Flag for Master Record LOEVM_XCHAR1XFELD
KZHERKInternal indicator for origin of the CP: Customer or Vendor KZHERKCHAR1XFELD
ADRNP_2Address number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
PRSNRPerson number AD_PERSNUMCHAR10Assigned to domainALPHAAD_PERSNUMCDTADDRESS

Key field Non-key field



How do I retrieve data from SAP table KNVK using ABAP code

The following ABAP code Example will allow you to do a basic selection on KNVK to SELECT all data from the table
DATA: WA_KNVK TYPE KNVK.

SELECT SINGLE *
FROM KNVK
INTO CORRESPONDING FIELDS OF WA_KNVK
WHERE...

How to access SAP table KNVK

Within an ECC or HANA version of SAP you can also view further information about KNVK and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!