SAP table KNVP (Customer Master Partner Functions)

The SAP table KNVP (Customer Master Partner Functions) is a standard table in SAP ERP systems that stores data related to customer master partner functions. It is used to manage and maintain the relationships between customers and their associated partner functions, facilitating effective customer relationship management within the SAP system.

In SAP, partner functions are roles that business partners play in specific transactions or processes. For example, in the context of customer management, partner functions can include roles such as sold-to party, ship-to party, bill-to party, and payer. These roles help define the responsibilities and interactions of each partner within the business process, ensuring that the right tasks are assigned to the appropriate parties. The SAP table KNVP (Customer Master Partner Functions) is used to manage and maintain these relationships, facilitating effective customer relationship management within the SAP system.

SAP table KNVP has 7 primary key fields being MANDT,KUNNR,VKORG,VTWEG,SPART,PARVW,PARZA.

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 T000 MANDT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
PARVW Partner Function CHAR 2 0 TPAR PARVW
PARZA Partner counter NUMC 3 0 PARZA
KUNN2 Customer number of business partner CHAR 10 0 KNA1 KUNN2
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
PERNR Personnel Number NUMC 8 0 PERNR_D
PARNR Number of Contact Person NUMC 10 0 PARNR
KNREF Customer description of partner (plant, storage location) CHAR 30 0 KNREF
DEFPA Default Partner CHAR 1 0 DEFPA
ADRNR Business Partner Address Number (from BUT020) CHAR 10 0 BUT020 BU_ADDRNUM

KNVP foreign key relationships

Table Field Check Table Check Field
0 KNVP ADRNR BUT020 BP: Addresses PARTNER
1 KNVP KUNN2 KNA1 General Data in Customer Master MANDT
1 KNVP KUNN2 KNA1 General Data in Customer Master KUNNR
0 KNVP KUNNR KNA1 General Data in Customer Master MANDT
0 KNVP KUNNR KNA1 General Data in Customer Master KUNNR
1 KNVP LIFNR LFA1 Supplier Master (General Section) MANDT
1 KNVP LIFNR LFA1 Supplier Master (General Section) LIFNR
0 KNVP MANDT T000 Clients MANDT
1 KNVP PARVW TPAR Business Partner: Functions PARVW
0 KNVP SPART TSPA Organizational Unit: Sales Divisions MANDT
0 KNVP SPART TSPA Organizational Unit: Sales Divisions SPART
1 KNVP VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 KNVP VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 KNVP VTWEG TVTW Organizational Unit: Distribution Channels MANDT
0 KNVP VTWEG TVTW Organizational Unit: Distribution Channels VTWEG