SAP Table KNVP

Customer Master Partner Functions

KNVP (Customer Master Partner Functions) 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 KNVP to other SAP tables.

KNVP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
PARVW Partner Function PARVW TPAR CHAR 2 0
PARZA Partner counter PARZA NUMC 3 0
KUNN2 Customer number of business partner KUNN2 KNA1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
PERNR Personnel Number PERNR_D NUMC 8 0
PARNR Number of contact person PARNR NUMC 10 0
KNREF Customer description of partner (plant, storage location) KNREF CHAR 30 0
DEFPA Default Partner DEFPA CHAR 1 0
X Yes
NULL No
EFFECTIVE_DATE Field of type DATS DATS DATS 8 0

KNVP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KNVP KUNN2 KNVP MANDT KNA1 General Data in Customer Master MANDT
KNVP KUNN2 KNVP KUNN2 KNA1 General Data in Customer Master KUNNR
KNVP KUNNR KNVP MANDT KNA1 General Data in Customer Master MANDT
KNVP KUNNR KNVP KUNNR KNA1 General Data in Customer Master KUNNR
KNVP LIFNR KNVP MANDT LFA1 Vendor Master (General Section) MANDT
KNVP LIFNR KNVP LIFNR LFA1 Vendor Master (General Section) LIFNR
KNVP MANDT KNVP MANDT T000 Clients MANDT
KNVP PARVW KNVP MANDT TPAR Business Partner: Functions MANDT
KNVP PARVW KNVP PARVW TPAR Business Partner: Functions PARVW
KNVP SPART KNVP MANDT TSPA Organizational Unit: Sales Divisions MANDT
KNVP SPART KNVP SPART TSPA Organizational Unit: Sales Divisions SPART
KNVP VKORG KNVP VKORG TVKO Organizational Unit: Sales Organizations VKORG
KNVP VKORG KNVP MANDT TVKO Organizational Unit: Sales Organizations MANDT
KNVP VTWEG KNVP MANDT TVTW Organizational Unit: Distribution Channels MANDT
KNVP VTWEG KNVP VTWEG TVTW Organizational Unit: Distribution Channels VTWEG