KNVP is a standard Basic Functions Transparent Table in SAP FI application, which stores Customer Master Partner Functions data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for KNVP. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

KNVP — Meta Data

Description: Customer Master Partner Functions
Main Category: FI
Sub Category: Basic Functions
Table type: Transparent Table (TRANSP)

KNVP — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 KUNNR Customer X CHAR 10 KNA1
    3 VKORG Sales Org. X CHAR 4 TVKO
    4 VTWEG Distr. Channel X CHAR 2 TVTW
    5 SPART Division X CHAR 2 TSPA
    6 PARVW Partner function X CHAR 2 TPAR
    7 PARZA Partner counter X NUMC 3
    8 KUNN2 Customer number of business partner CHAR 10 KNA1
    9 LIFNR Vendor CHAR 10 LFA1
    10 PERNR Personnel No. NUMC 8
    11 PARNR Number of contact person NUMC 10
    12 KNREF Customer description of partner (plant CHAR 30
    13 DEFPA Default partner CHAR 1

SAP Help, Wiki Resources, and Forum Discussions on KNVP

Click the above link for the full list of resources and help pages, only the first few are posted below

  • Partener functions (R/3 table KNVP) | SCN

    I need to load data from SAP R/3 KNVP table (partner functions) regularly in my SAP BW system. There is any Business Content Data Source in R/3 for that table? How can I load that data on a delta basis?

    http://scn.sap.com/message/175352

  • I want to retrive data from KNVP table but it shows records in miss order.

    So it shows 1st record = 1150010 instead of 100510. I want to show 1st record as 100510. Can any one please tell me why it shows such miss order.

    http://scn.sap.com/message/4705826

  • Replicate partner functions (R/3->CRM) base on employee number (KNVP-PERNR)

    We are trying to replicate an partner-function base on personnel number/employee number for customers from R/3 to CRM. For those partner-functions only the employee number is filled in KNVP-PERNR (the KNVP-KUNN2, KNVP-LIFNR and KNVP-PARNR are empty). If we follow the replication proces we don't see the employee number getting mapped to the "bapimtcs structure" (in function module COM_BUPA_MWX_CREA...

    http://scn.sap.com/message/9729859

  • How to delete the data from KNVP without using the delete statement

    I have a requirement that I have to delete the data from KNVP table without using any delete statement. For it I have to use the Standard BAPI or any standard program.

    http://scn.sap.com/message/4288593

  • Delta enabling for an extractor for KNVP table | SCN

    I have created a generic extractor based on a view for the table KNVP and doing a full load everyday which is causing a performance issue. As there is no date field or a time stamp field I'm not able to make this as delta enabled. Can anyone please let me know how I can change this to a delta enabled extractor.

    http://scn.sap.com/message/13764834

  • KNVP | SCN

    KNVP table is used to maintain the partner functions of Sold To Party or Payer etc..

    http://scn.sap.com/message/2387511

  • Create records in KNVP and knvv | SCN

    Hi,

    please some one guide me how to create the records in knvv and KNVP tables.

    Thanks,

    http://scn.sap.com/message/5648513

  • Update customer adding partner functions (KNVP) | SCN

    I need to insert new partner functions in a customer. I have been looking for a BAPI but it does not exist. Here in the forum I have seen some threads saying you can use SD_CUSTOMER_MAINTAIN_ALL but there are other threads saying you have to do a BDC because SD_CUSTOMER_MAINTAIN_ALL have not to be used for that at all.

    http://scn.sap.com/message/10505182

  • Using the KNVP table in SQVI | SCN

    I'm able to get the Partner function field to appear on my report, however, the are several text fields associated with PARVW that I can't get displayed. According to my technical help button, this information is in the RF02D table, which SQVI won't let me include into my query.

    http://scn.sap.com/message/8201413

  • F2 802: System error in table KNVP | SCN

    I'm trying to insert a new entrie SH partner function in a customer master record, witch have already 1000 entries for SH, and the system gives me a message:

    http://scn.sap.com/message/3135394

  • Ship to party entry in KNVP | SCN

    I have created a ship to party. This does not have partner functions tab page in sales area data. Also the ship to party account group is not configured to accept the partner functions. casually i checked the KNVP table for this ship to party, system showing entry in KNVP with out a value KUNN2.

    http://scn.sap.com/message/4505308


Related Tables

TABLE Description Functional Area
KNVV Customer Master Sales Data Logistics - Customer Master
KNB1 Customer Master (Company Code) FI - Financial Accounting
VBPA Sales Document: Partner SD - Basic Functions
VBAK Sales Document: Header Data SD - Sales
KNVK Customer Master Contact Partner Logistics - Customer Master
KNVI Customer Master Tax Indicator SD - Billing
KNBK Customer Master (Bank Details) FI - Financial Accounting

Transaction Codes for SAP Table KNVP

TCODE Description Functional Area
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE16 Data Browser Basis - Workbench Utilities
VA01 Create Sales Order SD - Sales
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
MGMT Device Configuration Basis - SAP NetWeaver Mobile - Use subcomponents
SE38 ABAP Editor Basis - ABAP Editor
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SE37 ABAP Function Modules Basis - Function Builder

FMs for SAP Table KNVP

FM Description Functional Area
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
WS_UPLOAD OBSOLETE: Transfer Presentation Server File to Internal Table Basis - Graphic
TEXT_CONVERT_XLS_TO_SAP Dekodierung EXCEL Format in SAP Datenformat Treasury - Treasury
BAPI_CUSTOMER_CREATEFROMDATA1 Only for ONLINE Store!!! BAPI Create Cstmr for BO Cstmr (KNA1) - with CAM Logistics - Customer Master
F4IF_INT_TABLE_VALUE_REQUEST F4 help also returning the value to be displayed in internal table Basis - F4 Help

ABAP Reports for SAP Table KNVP

ABAP REPORT Description Functional Area
SAPMF02D Customer Master Data Logistics - Customer Master
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
RVKUSTA1 Customer Fact Sheet SD - Basic Functions
RFBIDE00 Batch Input Interface for Customers FI - Financial Accounting
SAPLSPO1 ?...
SAPMF02K Vendor Master Data FI - Basic Functions
SAPMV45A Sales Order Processing SD - Sales
RSAP0001 Program for object type SAP0001 : BapiService Basis - BW Service API

BW Datasources for SAP Table KNVP

BW DATASOURCE Description Functional Area
0CUSTOMER_ATTR Customer Number Logistics - Logistics - General
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
0CUST_SALES_ATTR Customer number Logistics - Logistics - General
0CONSUMER_ATTR Consumer SD - Sales and Distribution
0COSTCENTER_ATTR Cost center CO - Cost Center Accounting
0MATERIAL_ATTR Material Number Logistics - Logistics - General
2LIS_11_VASCL Sales Document Schedule Line SD - Sales and Distribution
0OI_TD_OIGSPA Partner in TD shipment -

Authorization Objects for SAP Table KNVP

AUTHORIZATION OBJECT Description Functional Area
C_VKORG Transfer of Sales Organization Data
F_KNA1_AEN Customer: Change Authorization for Certain Fields
S_TCODE Transaction Code Check at Transaction Start
S_RFC Authorization Check for RFC Access
F_KNA1_GRP Customer: Account Group Authorization
S_DEVELOP ABAP Workbench
S_CTS_ADMI Administration Functions in Change and Transport System

Most searched SAP Financial Accounting Tables