KNVV SAP table for – Customer Master Sales Data

Here we would like to draw your attention to KNVV table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). KNVV is a SAP standard transparent table used for storing Customer Master Sales Data related data in SAP. It comes under the package VS.

SAP KNVV table

Table KNVV technical data

TableKNVV
Data storingCustomer Master Sales Data
ModuleLO
ComponentLO-MD
SAP PackageVS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP KNVV Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in KNVV table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • VERSG
    Its data type is C (Character String) with field length 1
  • AUFSD
    Its data type is C (Character String) with field length 2
  • KALKS
    Its data type is C (Character String) with field length 1
  • BZIRK
    Its data type is C (Character String) with field length 6
  • AWAHR
    Its data type is N (Character String with Digits Only) with field length 3
  • INCO2 : Incoterms (part 2)
    Its data type is C (Character String) with field length 28
  • ANTLF
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 1
  • KZAZU
    Its data type is C (Character String) with field length 1
  • LPRIO
    Its data type is N (Character String with Digits Only) with field length 2
  • VSBED
    Its data type is C (Character String) with field length 2
  • VKORG : Sales Organization
    Its a key field. Its data type is C (Character String) with field length 4
  • MRNKZ
    Its data type is C (Character String) with field length 1
  • PERFK
    Its data type is C (Character String) with field length 2
  • KVAKZ
    Its data type is C (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • KTGRD
    Its data type is C (Character String) with field length 2
  • VWERK
    Its data type is C (Character String) with field length 4
  • VKGRP : Sales group
    Its data type is C (Character String) with field length 3
  • VKBUR : Sales office
    Its data type is C (Character String) with field length 4
  • KVGR1
    Its data type is C (Character String) with field length 3
  • KVGR2
    Its data type is C (Character String) with field length 3
  • KVGR3
    Its data type is C (Character String) with field length 3
  • KVGR5
    Its data type is C (Character String) with field length 3
  • BOIDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SPART : Division
    Its a key field. Its data type is C (Character String) with field length 2
  • PRFRE
    Its data type is C (Character String) with field length 1
  • PRAT2
    Its data type is C (Character String) with field length 1
  • PRAT4
    Its data type is C (Character String) with field length 1
  • PRAT7
    Its data type is C (Character String) with field length 1
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • PRATA
    Its data type is C (Character String) with field length 1
  • KKBER
    Its data type is C (Character String) with field length 4
  • CASSD
    Its data type is C (Character String) with field length 2
  • RDOFF
    Its data type is C (Character String) with field length 1
  • AGREL
    Its data type is C (Character String) with field length 1
  • MEGRU
    Its data type is C (Character String) with field length 4
  • UNTTO : Underdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UEBTK : Indicator: Unlimited Overdelivery Allowed
    Its data type is C (Character String) with field length 1
  • PODTG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • CARRIER_NOTIF
    Its data type is C (Character String) with field length 1
  • /BEV1/EMLGPFAND
    Its data type is C (Character String) with field length 1
  • BEGRU
    Its data type is C (Character String) with field length 4