VBAP SAP table for – Sales Document: Item Data

Here we would like to draw your attention to VBAP table in SAP. As we know it is being mainly used with the SAP SD-SLS (Sales in SD) component which is coming under SD module (Sales & Distribution). VBAP is a SAP standard transparent table used for storing Sales Document: Item Data related data in SAP. It comes under the package VA.

SAP VBAP table

Table VBAP technical data

TableVBAP
Data storingSales Document: Item Data
ModuleSD
ComponentSD-SLS
SAP PackageVA
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PSTYV
    Its data type is C (Character String) with field length 4
  • 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
  • XCHPF
    Its data type is C (Character String) with field length 1
  • XCHAR
    Its data type is C (Character String) with field length 1
  • POSAR
    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
  • 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
  • LFREL
    Its data type is C (Character String) with field length 1
  • 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
  • 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
  • FKREL
    Its data type is C (Character String) with field length 1
  • 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
  • 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
  • UEPOS
    Its data type is N (Character String with Digits Only) with field length 6
  • 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
  • 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
  • GRPOS
    Its data type is N (Character String with Digits Only) with field length 6
  • 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
  • MPROK
    Its data type is C (Character String) with field length 1
  • VGTYP
    Its data type is C (Character String) with field length 1
  • ABGRU
    Its data type is C (Character String) with field length 2
  • 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
  • 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
  • PRODH : Product Hierarchy
    Its data type is C (Character String) with field length 18
  • 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
  • KALVAR
    Its data type is C (Character String) with field length 4
  • KOSCH
    Its data type is C (Character String) with field length 18
  • ZWERT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • 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
  • 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
  • ZMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • 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
  • 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
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • ZIEME
    Its data type is C (Character String) with field length 3
  • 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
  • LOGSYS_EXT
    Its data type is C (Character String) with field length 10
  • J_1BTAXLW3
    Its data type is C (Character String) with field length 3
  • J_1BTAXLW4
    Its data type is C (Character String) with field length 3
  • J_1BTAXLW5
    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
  • STOCKLOC
    Its data type is C (Character String) with field length 20
  • SLOCTYPE
    Its data type is C (Character String) with field length 4
  • MSR_RET_REASON
    Its data type is C (Character String) with field length 3
  • MSR_REFUND_CODE
    Its data type is C (Character String) with field length 3
  • MSR_APPROV_BLOCK
    Its data type is C (Character String) with field length 1
  • NRAB_KNUMH
    Its data type is C (Character String) with field length 10
  • TRMRISK_RELEVANT
    Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is HANDOVER_LOCATION
  • HANDOVERLOC
    Its data type is C (Character String) with field length 10
  • UMZIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • HANDOVERDATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • HANDOVERTIME
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • TC_AUT_DET
    Its data type is C (Character String) with field length 2
  • MANUAL_TC_REASON
    Its data type is C (Character String) with field length 2
  • FISCAL_INCENTIVE
    Its data type is C (Character String) with field length 4
  • TAX_SUBJECT_ST
    Its data type is C (Character String) with field length 1
  • FISCAL_INCENTIVE_ID
    Its data type is C (Character String) with field length 4
  • SPCSTO
    Its data type is N (Character String with Digits Only) with field length 2
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is /BEV1/SRVBAP_A
  • /BEV1/SRFUND
    Its data type is C (Character String) with field length 2
  • AUFPL_OLC
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL_OLC
    Its data type is N (Character String with Digits Only) with field length 8
  • FERC_IND
    Its data type is C (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • SMENG : Operation Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • FONDS
    Its data type is C (Character String) with field length 10
  • FISTL : Funds Center
    Its data type is C (Character String) with field length 16
  • FKBER : Functional Area
    Its data type is C (Character String) with field length 16
  • GRANT_NBR : Grant
    Its data type is C (Character String) with field length 20
  • IUID_RELEVANT
    Its data type is C (Character String) with field length 1
  • PRS_OBJNR
    Its data type is C (Character String) with field length 22
  • ABLFZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PRS_SD_SPSNR
    Its data type is N (Character String with Digits Only) with field length 8
  • PRS_WORK_PERIOD : Work Period (Internal Representation)
    Its data type is N (Character String with Digits Only) with field length 7
  • PARGB : Trading partner’s business area
    Its data type is C (Character String) with field length 4
  • AUFPL_OAA
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL_OAA
    Its data type is N (Character String with Digits Only) with field length 8
  • 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
  • POSEX
    Its data type is C (Character String) with field length 6
  • KDMAT
    Its data type is C (Character String) with field length 35
  • 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
  • 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
  • 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
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • 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
  • 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
  • MATWA
    Its data type is C (Character String) with field length 18
  • 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
  • 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
  • PMATN
    Its data type is C (Character String) with field length 18
  • 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
  • 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
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • 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
  • 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
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • 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
  • TAXM8
    Its data type is C (Character String) with field length 1
  • TAXM9
    Its data type is C (Character String) with field length 1
  • ARKTX
    Its data type is C (Character String) with field length 40
  • 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
  • MTVFP
    Its data type is C (Character String) with field length 2
  • SUMBD
    Its data type is C (Character String) with field length 1