KNVV is a standard Customer Master Transparent Table in SAP Logistics application, which stores Customer Master Sales Data 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 KNVV. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

KNVV — Meta Data

Description: Customer Master Sales Data
Main Category: Logistics
Sub Category: Customer Master
Table type: Transparent Table (TRANSP)

KNVV — 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 ERNAM Created by CHAR 12
    7 ERDAT Created on DATS 8
    8 BEGRU Authorization Group CHAR 4
    9 LOEVM Deletion Indicator CHAR 1
    10 VERSG Updated information in related user data field CHAR 1 TVSD
    11 AUFSD Single-Character Flag CHAR 2 TVAST
    12 KALKS Updated information in related user data field CHAR 2 TVKD
    13 KDGRP Customer group CHAR 2 T151
    14 BZIRK Sales district CHAR 6 T171
    15 KONDA Updated information in related user data field CHAR 2 T188
    16 PLTYP Benefit plan type CHAR 2 T189
    17 AWAHR Probability NUMC 3
    18 INCO1 Incoterms CHAR 3 TINC
    19 INCO2 Incoterms 2 CHAR 28
    20 LIFSD Single-Character Flag CHAR 2 TVLS
    21 AUTLF Complete delivery defined for each sales order? CHAR 1
    22 ANTLF Maximum Number of Partial Deliveries Allowed Per Item DEC 1
    23 KZTLF Partial delivery at item level CHAR 1
    24 KZAZU Order Combination Indicator CHAR 1
    25 CHSPL Batch split allowed CHAR 1
    26 LPRIO Delivery Prior. NUMC 2 TPRIO
    27 EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR 12
    28 VSBED Shipping Cond. CHAR 2 TVSB
    29 FAKSD Single-Character Flag CHAR 2 TVFS
    30 MRNKZ Updated information in related user data field CHAR 1
    31 PERFK Invoice dates (calendar identification) CHAR 2 TFACD
    32 PERRL Updated information in related user data field CHAR 2 TFACD
    33 KVAKZ Cost estimate indicator (inactive) CHAR 1
    34 KVAWT Field of length 16 CURR 13
    35 WAERS Currency CUKY 5 TCURC
    36 KLABC Updated information in related user data field CHAR 2
    37 KTGRD AcctAssgGr CHAR 2 TVKT
    38 ZTERM Payt terms CHAR 4
    39 VWERK Delivering Plant CHAR 4 TVKWZ
    40 VKGRP Sales Group CHAR 3 TVBVK
    41 VKBUR Sales Office CHAR 4 TVBUR
    42 VSORT Updated information in related user data field CHAR 10
    43 KVGR1 Customer grp 1 CHAR 3 TVV1
    44 KVGR2 Customer grp 2 CHAR 3 TVV2
    45 KVGR3 Customer grp 3 CHAR 3 TVV3
    46 KVGR4 Customer grp 4 CHAR 3 TVV4
    47 KVGR5 Customer grp 5 CHAR 3 TVV5
    48 BOKRE ID: Customer is to receive rebates CHAR 1
    49 BOIDT Start of validity per.for the rebate index for the customer DATS 8
    50 KURST Exch. Rate Type CHAR 4 TCURV
    51 PRFRE Relevant for price determination ID CHAR 1
    52 PRAT1 Updated information in related user data field CHAR 1
    53 PRAT2 Updated information in related user data field CHAR 1
    54 PRAT3 Updated information in related user data field CHAR 1
    55 PRAT4 Updated information in related user data field CHAR 1
    56 PRAT5 Updated information in related user data field CHAR 1
    57 PRAT6 Updated information in related user data field CHAR 1
    58 PRAT7 Updated information in related user data field CHAR 1
    59 PRAT8 Updated information in related user data field CHAR 1
    60 PRAT9 Updated information in related user data field CHAR 1
    61 PRATA Updated information in related user data field CHAR 1
    62 KABSS Updated information in related user data field CHAR 4 T691P
    63 KKBER Cred.contr.area CHAR 4 T014
    64 CASSD Single-Character Flag CHAR 2
    65 RDOFF Updated information in related user data field CHAR 1
    66 AGREL Updated information in related user data field CHAR 1
    67 MEGRU Updated information in related user data field CHAR 4 TWMEG
    68 UEBTO Overdeliv. Tol. DEC 3
    69 UNTTO Underdel. Tol. DEC 3
    70 UEBTK Unlimited tol. CHAR 1
    71 PVKSM Updated information in related user data field CHAR 2 TPVD
    72 PODKZ Updated information in related user data field CHAR 1
    73 PODTG Updated information in related user data field DEC 11
    74 BLIND Block CHAR 1
    75 CARRIER_NOTIF Carrier is to be notified CHAR 1
    76 CVP_XBLCK_V Updated information in related user data field CHAR 1
    77 .INCLUDE 0
    78 INCOV Incoterms Version CHAR 4 TINCV
    79 INCO2_L Incoterms Location 1 CHAR 70
    80 INCO3_L Incoterms Location 2 CHAR 70
    81 .INCLUDE 0
    82 KNVV_EEW_CONTACT CHAR 1
    83 .INCLU--AP 0
    84 .INCLUDE 0
    85 /BEV1/EMLGPFAND Deposit on Empties CHAR 1
    86 /BEV1/EMLGFORTS Indicator for Empties Update CHAR 1
    87 .INCLU--AP 0
    88 .INCLUDE 0
    89 J_1NBOESL Exchange Key for NF Processing CHAR 3 /NFM/TBOESL
    90 .INCLU--AP 0
    91 FSH_KVGR6 Updated information in related user data field CHAR 3 FSH_TVV6
    92 FSH_KVGR7 Updated information in related user data field CHAR 3 FSH_TVV7
    93 FSH_KVGR8 Updated information in related user data field CHAR 3 FSH_TVV8
    94 FSH_KVGR9 Updated information in related user data field CHAR 3 FSH_TVV9
    95 FSH_KVGR10 Updated information in related user data field CHAR 3 FSH_TVV10
    96 FSH_GRREG CHAR 4 FSH_GRRG_W
    97 FSH_RESGY CHAR 4 FSH_RESG_W
    98 FSH_SC_CID Updated information in related user data field CHAR 2 FSH_SC_VCIDS
    99 FSH_VAS_DETC Updated information in related user data field CHAR 1
    100 FSH_VAS_CG Updated information in related user data field CHAR 3 FSH_VAS_CG
    101 FSH_GRSGY CHAR 4 FSH_GRSG_W
    102 FSH_SS Updated information in related user data field CHAR 3 FSH_OSS
    103 FSH_FRATE Updated information in related user data field NUMC 3
    104 FSH_FRATE_AGG_LEVEL Updated information in related user data field CHAR 1
    105 FSH_MSOCDC Updated information in related user data field CHAR 10 KNA1
    106 FSH_MSOPID Updated information in related user data field CHAR 20
    107 RFM_PSST_RULE Updated information in related user data field CHAR 4
    108 RFM_PSST_EXCLUDE Updated information in related user data field CHAR 1
    109 .INCLU--AP 0
    110 OIC_MOT IS-OIL MAP external details mode of transport CHAR 2 TVTR
    111 .INCLU--AP 0
    112 OILASTOR Single-Character Flag CHAR 10
    113 OIC_HOBIND Updated information in related user data field CHAR 1
    114 OIABTNR Updated information in related user data field CHAR 4 TSAB
    115 OIPAFKT Updated information in related user data field CHAR 2 TPFK
    116 .INCLU--AP 0
    117 OIGROUPNAM Updated information in related user data field CHAR 8 TOIGBC
    118 .INCLU--AP 0
    119 OIHANTYP Excise Duty Handling Type CHAR 2 OIH5
    120 OIINEX Updated information in related user data field CHAR 2 OIH16
    121 OIPFLIC Updated information in related user data field CHAR 2 TPAR
    122 OIHCGROUP Updated information in related user data field CHAR 4 OIH2C_J1B
    123 .INCLU--AP 0

SAP Help, Wiki Resources, and Forum Discussions on KNVV

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


Related Tables

TABLE Description Functional Area
KNB1 Customer Master (Company Code) FI - Financial Accounting
VBAK Sales Document: Header Data SD - Sales
KNVP Customer Master Partner Functions FI - Basic Functions
VBRK Billing Document: Header Data SD - Billing
VBRP Billing Document: Item Data SD - Billing
MARA General Material Data Logistics - Material Master
LIKP SD Document: Delivery Header Data Logistics Execution - Shipping

Transaction Codes for SAP Table KNVV

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
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
XD01 Create Customer (Centrally) FI - Basic Functions
SE38 ABAP Editor Basis - ABAP Editor
VBKD Bonus Buy: Condition Types SD - Free Goods

FMs for SAP Table KNVV

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
READ_TEXT SAPscript: Read text BC - SAPscript
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
EXIT_SAPMF02D_001 Customers: User Exit for Checks prior to Saving FI - Basic Functions
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime

ABAP Reports for SAP Table KNVV

ABAP REPORT Description Functional Area
SAPMF02D Customer Master Data Logistics - Customer Master
RFBIDE00 Batch Input Interface for Customers FI - Financial Accounting
SAPMV45A Sales Order Processing SD - Sales
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SALV_DEMO_METADATA Demonstration of Setting Meta Data Basis - SAP List Viewer
SAPLSPO1 ?...
SPRSL TEXT 630 - Workbench Tools: Editors
SAPMF02K Vendor Master Data FI - Basic Functions

BW Datasources for SAP Table KNVV

Authorization Objects for SAP Table KNVV

AUTHORIZATION OBJECT Description Functional Area
V_VBAK_VKO Sales Document: Authorization for Sales Areas
C_VKORG Transfer of Sales Organization Data
F_KNA1_AEN Customer: Change Authorization for Certain Fields
A_S_WERK Asset Master Data Maintenance: Company Code/Plant
ECM_VAL Change Management: Validity
J_1IEWT_HC health check for Migration to EWT
S_TABU_DIS Table Maintenance (via standard tools such as SM30)