VSVBAP_CN SAP table for – Version: Sales document: Item data

Here we would like to draw your attention to VSVBAP_CN table in SAP. As we know it is being mainly used with the SAP PS-SIM (Simulation in PS) component which is coming under PS module (Project Systems). VSVBAP_CN is a SAP standard transparent table used for storing Version: Sales document: Item data related data in SAP. It comes under the package CNVS.

SAP VSVBAP_CN table

Table VSVBAP_CN technical data

TableVSVBAP_CN
Data storingVersion: Sales document: Item data
ModulePS
ComponentPS-SIM
SAP PackageCNVS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VSVBAP_CN 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 VSVBAP_CN table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • MTVFP
    Its data type is C (Character String) with field length 2
  • SUMBD
    Its data type is C (Character String) with field length 1
  • KONDM : Material pricing group
    Its data type is C (Character String) with field length 2
  • KTGRM
    Its data type is C (Character String) with field length 2
  • BONUS
    Its data type is C (Character String) with field length 2
  • PROVG : Key for defining time intervals in a relationship
    Its data type is C (Character String) with field length 2
  • EANNR : European Article Number (EAN) – obsolete!!!!!
    Its data type is C (Character String) with field length 13
  • PRSOK
    Its data type is C (Character String) with field length 1
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • BWTEX
    Its data type is C (Character String) with field length 1
  • ARKTX
    Its data type is C (Character String) with field length 40
  • XCHPF
    Its data type is C (Character String) with field length 1
  • XCHAR
    Its data type is C (Character String) with field length 1
  • LFMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • STAFO
    Its data type is C (Character String) with field length 6
  • WAVWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PSTYV
    Its data type is C (Character String) with field length 4
  • KZWI6
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • STCUR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EAN11 : International Article Number (EAN/UPC)
    Its data type is C (Character String) with field length 18
  • FIXMG
    Its data type is C (Character String) with field length 1
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • MVGR1
    Its data type is C (Character String) with field length 3
  • MVGR2 : Material group 2
    Its data type is C (Character String) with field length 3
  • MVGR3
    Its data type is C (Character String) with field length 3
  • MVGR4
    Its data type is C (Character String) with field length 3
  • POSAR
    Its data type is C (Character String) with field length 1
  • MVGR5
    Its data type is C (Character String) with field length 3
  • KMPMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SUGRD
    Its data type is C (Character String) with field length 4
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • VPZUO
    Its data type is C (Character String) with field length 1
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is N (Character String with Digits Only) with field length 10
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is N (Character String with Digits Only) with field length 8
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • VPMAT
    Its data type is C (Character String) with field length 18
  • VPWRK
    Its data type is C (Character String) with field length 4
  • LFREL
    Its data type is C (Character String) with field length 1
  • PRBME
    Its data type is C (Character String) with field length 3
  • UMREF
    Its data type is F (Floating point number) with field length 8
  • KNTTP : Account assignment category
    Its data type is C (Character String) with field length 1
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • SERNR : BOM explosion number
    Its data type is C (Character String) with field length 8
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • ABGRS
    Its data type is C (Character String) with field length 6
  • BEDAE
    Its data type is C (Character String) with field length 4
  • CMPRE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • CMTFG
    Its data type is C (Character String) with field length 1
  • FKREL
    Its data type is C (Character String) with field length 1
  • CMPNT
    Its data type is C (Character String) with field length 1
  • CMKUA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • CUOBJ : Configuration (internal object number)
    Its data type is N (Character String with Digits Only) with field length 18
  • CUOBJ_CH
    Its data type is N (Character String with Digits Only) with field length 18
  • CEPOK
    Its data type is C (Character String) with field length 1
  • KOUPD
    Its data type is C (Character String) with field length 1
  • SERAIL : Serial Number Profile
    Its data type is C (Character String) with field length 4
  • ANZSN : Number of serial numbers
    Its data type is X (Byte string) with field length 4
  • NACHL
    Its data type is C (Character String) with field length 1
  • MAGRV
    Its data type is C (Character String) with field length 4
  • UEPOS
    Its data type is N (Character String with Digits Only) with field length 6
  • MPROK
    Its data type is C (Character String) with field length 1
  • VGTYP
    Its data type is C (Character String) with field length 1
  • PROSA
    Its data type is C (Character String) with field length 1
  • UEPVW
    Its data type is C (Character String) with field length 1
  • KALNR : Cost Estimate Number for Cost Est. w/o Qty Structure
    Its data type is N (Character String with Digits Only) with field length 12
  • KLVAR : Costing Variant
    Its data type is C (Character String) with field length 4
  • SPOSN
    Its data type is C (Character String) with field length 4
  • KOWRR
    Its data type is C (Character String) with field length 1
  • STADAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EXART
    Its data type is C (Character String) with field length 2
  • GRPOS
    Its data type is N (Character String with Digits Only) with field length 6
  • PREFE
    Its data type is C (Character String) with field length 1
  • KNUMH : Condition record number
    Its data type is C (Character String) with field length 10
  • CLINT : Internal class number describing effectivity type
    Its data type is N (Character String with Digits Only) with field length 10
  • CHMVS
    Its data type is N (Character String with Digits Only) with field length 3
  • STLTY : BOM Category
    Its data type is C (Character String) with field length 1
  • STLKN
    Its data type is N (Character String with Digits Only) with field length 8
  • STPOZ
    Its data type is N (Character String with Digits Only) with field length 8
  • STMAN
    Its data type is C (Character String) with field length 1
  • ZSCHL_K
    Its data type is C (Character String) with field length 6
  • KALSM_K
    Its data type is C (Character String) with field length 6
  • ABGRU
    Its data type is C (Character String) with field length 2
  • KALVAR
    Its data type is C (Character String) with field length 4
  • KOSCH
    Its data type is C (Character String) with field length 18
  • UPMAT : Pricing reference material of main item
    Its data type is C (Character String) with field length 18
  • UKONM : Material pricing group of main item
    Its data type is C (Character String) with field length 2
  • MFRGR
    Its data type is C (Character String) with field length 8
  • PLAVO
    Its data type is C (Character String) with field length 4
  • KANNR
    Its data type is C (Character String) with field length 35
  • CMPRE_FLT
    Its data type is F (Floating point number) with field length 8
  • ABFOR
    Its data type is C (Character String) with field length 2
  • ABGES
    Its data type is F (Floating point number) with field length 8
  • PRODH : Product Hierarchy
    Its data type is C (Character String) with field length 18
  • J_1BCFOP
    Its data type is C (Character String) with field length 10
  • J_1BTAXLW1
    Its data type is C (Character String) with field length 3
  • J_1BTAXLW2
    Its data type is C (Character String) with field length 3
  • J_1BTXSDC : SD tax code
    Its data type is C (Character String) with field length 2
  • WKTNR
    Its data type is C (Character String) with field length 10
  • WKTPS
    Its data type is N (Character String with Digits Only) with field length 6
  • SKOPF
    Its data type is C (Character String) with field length 18
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • WGRU1
    Its data type is C (Character String) with field length 18
  • WGRU2
    Its data type is C (Character String) with field length 18
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is VSKEY_INC
  • ZWERT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KNUMA_PI
    Its data type is C (Character String) with field length 10
  • KNUMA_AG : Sales deal
    Its data type is C (Character String) with field length 10
  • KZFME
    Its data type is C (Character String) with field length 1
  • LSTANR
    Its data type is C (Character String) with field length 1
  • TECHS : Parameter Variant/Standard Variant
    Its data type is C (Character String) with field length 12
  • MWSBP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BERID : MRP Area
    Its data type is C (Character String) with field length 10
  • PCTRF
    Its data type is C (Character String) with field length 10
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is FERC_VSVBAP_CN
  • FERC_IND
    Its data type is C (Character String) with field length 4
  • ZMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ZIEME
    Its data type is C (Character String) with field length 3
  • UMZIZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • UMZIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • SMENG : Operation Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ABLFZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ABDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ABSFZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VSNMR
    Its a key field. Its data type is C (Character String) with field length 12
  • POSEX
    Its data type is C (Character String) with field length 6
  • KDMAT
    Its data type is C (Character String) with field length 35
  • KBVER
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • KEVER
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • VKGRU
    Its data type is C (Character String) with field length 3
  • VKAUS
    Its data type is C (Character String) with field length 3
  • GRKOR
    Its data type is N (Character String with Digits Only) with field length 3
  • FMENG
    Its data type is C (Character String) with field length 1
  • UEBTK : Indicator: Unlimited Overdelivery Allowed
    Its data type is C (Character String) with field length 1
  • UEBTO : Overdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • UNTTO : Underdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • FAKSP
    Its data type is C (Character String) with field length 2
  • ATPKZ
    Its data type is C (Character String) with field length 1
  • RKFKF
    Its data type is C (Character String) with field length 1
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WAERK : SD document currency
    Its data type is C (Character String) with field length 5
  • ANTLF
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 1
  • KZTLF
    Its data type is C (Character String) with field length 1
  • POSNR : Item number of the SD document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • CHSPL
    Its data type is C (Character String) with field length 1
  • KWMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LSMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KBMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KLMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VRKME : Sales unit
    Its data type is C (Character String) with field length 3
  • UMVKZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • UMVKN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • BRGEW : Gross Weight
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NTGEW : Net Weight
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • GEWEI : Weight Unit
    Its data type is C (Character String) with field length 3
  • VOLUM : Volume
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VOLEH : Unit for the Volume
    Its data type is C (Character String) with field length 3
  • VBELV
    Its data type is C (Character String) with field length 10
  • POSNV
    Its data type is N (Character String with Digits Only) with field length 6
  • VGBEL : Document number of the reference document
    Its data type is C (Character String) with field length 10
  • VGPOS : Item number of the reference item
    Its data type is N (Character String with Digits Only) with field length 6
  • VOREF
    Its data type is C (Character String) with field length 1
  • UPFLU
    Its data type is C (Character String) with field length 1
  • ERLRE
    Its data type is C (Character String) with field length 1
  • MATWA
    Its data type is C (Character String) with field length 18
  • LPRIO
    Its data type is N (Character String with Digits Only) with field length 2
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • VSTEL
    Its data type is C (Character String) with field length 4
  • ROUTE
    Its data type is C (Character String) with field length 6
  • STKEY
    Its data type is C (Character String) with field length 1
  • STDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • STLNR : Bill of Material
    Its data type is C (Character String) with field length 8
  • STPOS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • AWAHR
    Its data type is N (Character String with Digits Only) with field length 3
  • PMATN
    Its data type is C (Character String) with field length 18
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • ERZET : Entry time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • TAXM1 : Tax classification material
    Its data type is C (Character String) with field length 1
  • TAXM2 : Tax classification material
    Its data type is C (Character String) with field length 1
  • TAXM3 : Tax classification material
    Its data type is C (Character String) with field length 1
  • TAXM4 : Tax Classification 4 Material
    Its data type is C (Character String) with field length 1
  • TAXM5
    Its data type is C (Character String) with field length 1
  • TAXM6
    Its data type is C (Character String) with field length 1
  • TAXM7
    Its data type is C (Character String) with field length 1
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • TAXM8
    Its data type is C (Character String) with field length 1
  • TAXM9
    Its data type is C (Character String) with field length 1
  • VBEAF
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VBEAV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VGREF
    Its data type is C (Character String) with field length 1
  • NETPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • KPEIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • KMEIN
    Its data type is C (Character String) with field length 3
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • SKTOF
    Its data type is C (Character String) with field length 1