SAP KNVK Customer Master Contact Partner Table data and field list

KNVK is a standard SAP Table which is used to store Customer Master Contact Partner data in SAP systems, such as SAP R/3, S/4HANA, 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. .

KNVK table Technical Details:

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the KNVK table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

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

Key field

Non-key field

< KNVI_KEY_S - Key: Tax Indicators Customer with Client KNVKADRFELD - CAM Address Fields of a Contact Person >

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).

Related SAP tables and the relationships to KNVK

    KNA1 - General Data in Customer Master
        KNVP - Customer Master Partner Functions
        KNVK - Customer Master Contact Partner
        KNVV - Customer Master Sales Data

    VBKPA - SD index: Sales activities by partner function
        VBKA - Sales activities
    KNVV - Customer Master Sales Data
    KNVK - Customer Master Contact Partner
    VBADR - Address work area
        VBFA - Sales Document Flow
            VBAK - Sales Document: Header Data
    SADLSTADM - Administrative Data - Address List
        SADLSTIAD - Administration Table for Address Lists
            SADLSTRECH - Statistical part of an address list (rec. header)
            SADLSTRECB - Dynamic part of address record (record body)
        SADLSTDIR1 - Address List Directory
    SADLSTSORT - Sort Fields for Address List
        VBPA - Sales Document: Partner
            KNA1 - General Data in Customer Master

    KNVK - Customer Master Contact Partner
        KNA1 - General Data in Customer Master
            KNVV - Customer Master Sales Data
            KNVP - Customer Master Partner Functions
            VBAP - Sales Document: Item Data
            LIPS - SD document: Delivery: Item data
            VBRP - Billing Document: Item Data
            VBKA - Sales Activities