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 |