Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table BC490_VBAK_VBAP

BC490: Structure for tables VBAK and VBAP

BC490_VBAK_VBAP (BC490: Structure for tables VBAK and VBAP) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BC490_VBAK_VBAP to other SAP tables.

BC490_VBAK_VBAP table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
 MANDT
CLNT
 3 0
VBELN
Sales Document
 VBELN_VA
CHAR
 10 0
ERDAT
Date on Which Record Was Created
 ERDAT
DATS
 8 0
ERZET
Entry time
 ERZET
TIMS
 6 0
ERNAM
Name of Person who Created the Object
 ERNAM
CHAR
 12 0
ANGDT
Quotation/Inquiry is valid from
 ANGDT_V
DATS
 8 0
BNDDT
Date until which bid/quotation is binding (valid-to date)
 BNDDT
DATS
 8 0
AUDAT
Document Date (Date Received/Sent)
 AUDAT
DATS
 8 0
VBTYP
SD document category
 VBTYP
CHAR
 1 0
TRVOG
Transaction group
 TRVOG
CHAR
 1 0
AUART
Sales Document Type
 AUART
CHAR
 4 0
AUGRU
Order reason (reason for the business transaction)
 AUGRU
CHAR
 3 0
GWLDT
Warranty Date
 GWLDT
DATS
 8 0
SUBMI
Collective number (SD)
 SUBMI_SD
CHAR
 10 0
LIFSK
Delivery block (document header)
 LIFSK
CHAR
 2 0
FAKSK
Billing block in SD document
 FAKSK
CHAR
 2 0
NETWR
Net Value of the Sales Order in Document Currency
 NETWR_AK
CURR
 15 2
WAERK
SD Document Currency
 WAERK
CUKY
 5 0
VKORG
Sales Organization
 VKORG
CHAR
 4 0
VTWEG
Distribution Channel
 VTWEG
CHAR
 2 0
SPART
Division
 SPART
CHAR
 2 0
VKGRP
Sales Group
 VKGRP
CHAR
 3 0
VKBUR
Sales Office
 VKBUR
CHAR
 4 0
GSBER
Business Area
 GSBER
CHAR
 4 0
GSKST
Business area from cost center
 GSKST
CHAR
 4 0
GUEBG
Valid-from date (outline agreements, product proposals)
 GUEBG
DATS
 8 0
GUEEN
Valid-to date (outline agreements, product proposals)
 GUEEN
DATS
 8 0
KNUMV
Number of the document condition
 KNUMV
CHAR
 10 0
VDATU
Requested delivery date
 EDATU_VBAK
DATS
 8 0
VPRGR
Proposed date type
 PRGRS_VBAK
CHAR
 1 0
AUTLF
Complete delivery defined for each sales order?
 AUTLF
CHAR
 1 0
VBKLA
Original system with release and transaction control
 VBKLA
CHAR
 9 0
VBKLT
SD document indicator
 VBKLT
CHAR
 1 0
KALSM
Sales and Distribution: Pricing Procedure in Pricing
 KALSMASD
CHAR
 6 0
VSBED
Shipping Conditions
 VSBED
CHAR
 2 0
FKARA
Proposed billing type for an order-related billing document
 FKARA
CHAR
 4 0
AWAHR
Sales probability
 AWAHR_AK
NUMC
 3 0
KTEXT
Search term for product proposal
 KTEXT_V
CHAR
 40 0
BSTNK
Customer purchase order number
 BSTNK
CHAR
 20 0
BSARK
Customer purchase order type
 BSARK
CHAR
 4 0
BSTDK
Customer purchase order date
 BSTDK
DATS
 8 0
BSTZD
Purchase order number supplement
 BSTZD
CHAR
 4 0
IHREZ
Your Reference
 IHREZ
CHAR
 12 0
BNAME
Name of orderer
 BNAME_V
CHAR
 35 0
TELF1
Telephone Number
 TELF1_VP
CHAR
 16 0
MAHZA
Number of contacts from the customer
 MAHZA
DEC
 3 0
MAHDT
Last customer contact date
 MAHDT
DATS
 8 0
KUNNR
Sold-to party
 KUNAG
CHAR
 10 0
KOSTL
Cost Center
 KOSTL
CHAR
 10 0
STAFO
Update group for statistics update
 STAFO
CHAR
 6 0
STWAE
Statistics currency
 STWAE
CUKY
 5 0
AEDAT
Changed On
 AEDAT
DATS
 8 0
KVGR1
Customer group 1
 KVGR1
CHAR
 3 0
KVGR2
Customer group 2
 KVGR2
CHAR
 3 0
KVGR3
Customer group 3
 KVGR3
CHAR
 3 0
KVGR4
Customer group 4
 KVGR4
CHAR
 3 0
KVGR5
Customer group 5
 KVGR5
CHAR
 3 0
KNUMA
Agreement (various conditions grouped together)
 KNUMA
CHAR
 10 0
KOKRS
Controlling Area
 KOKRS
CHAR
 4 0
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
 PS_PSP_PNR
NUMC
 8 0
KURST
Exchange Rate Type
 KURST
CHAR
 4 0
KKBER
Credit control area
 KKBER
CHAR
 4 0
KNKLI
Customer's account number with credit limit reference
 KNKLI
CHAR
 10 0
GRUPP
Customer Credit Group
 GRUPP_CM
CHAR
 4 0
SBGRP
Credit representative group for credit management
 SBGRP_CM
CHAR
 3 0
CTLPC
Credit management: Risk category
 CTLPC_CM
CHAR
 3 0
CMWAE
Currency key of credit control area
 WAERS_CM
CUKY
 5 0
CMFRE
Release date of the document determined by credit management
 CMFRE
DATS
 8 0
CMNUP
Date of next credit check of document
 CMNUP
DATS
 8 0
CMNGV
Next date
 CMNGV
DATS
 8 0
AMTBL
Released credit value of the document
 AMTBL_CM
CURR
 15 2
HITYP_PR
Hierarchy type for pricing
 HITYP_PR
CHAR
 1 0
ABRVW
Usage Indicator
 ABRVW
CHAR
 3 0
ABDIS
MRP for delivery schedule types
 ABDIS
CHAR
 1 0
VGBEL
Document number of the reference document
 VGBEL
CHAR
 10 0
OBJNR
Object number at header level
 OBJKO
CHAR
 22 0
BUKRS_VF
Company code to be billed
 BUKRS_VF
CHAR
 4 0
TAXK1
Alternative tax classification
 TAXK1_AK
CHAR
 1 0
TAXK2
Tax classification 2 for customer
 TAXK2
CHAR
 1 0
TAXK3
Tax classification 3 for customer
 TAXK3
CHAR
 1 0
TAXK4
Tax Classification 4 Customer
 TAXK4
CHAR
 1 0
TAXK5
Tax classification 5 for customer
 TAXK5
CHAR
 1 0
TAXK6
Tax classification 6 for customer
 TAXK6
CHAR
 1 0
TAXK7
Tax classification 7 for customer
 TAXK7
CHAR
 1 0
TAXK8
Tax classification 8 for customer
 TAXK8
CHAR
 1 0
TAXK9
Tax classification 9 for customer
 TAXK9
CHAR
 1 0
XBLNR
Reference Document Number
 XBLNR_V
CHAR
 16 0
ZUONR
Assignment number
 ORDNR_V
CHAR
 18 0
VGTYP
Document category of preceding SD document
 VBTYP_V
CHAR
 1 0
KALSM_CH
Search procedure for batch determination
 KALSMA_CH
CHAR
 6 0
AGRZR
Accrual period for order-related billing docs.to be accrued
 AGRZR
NUMC
 2 0
AUFNR
Order Number
 AUFNR
CHAR
 12 0
QMNUM
Notification No
 QMNUM
CHAR
 12 0
VBELN_GRP
Mster contract number
 VBELN_GRP
CHAR
 10 0
SCHEME_GRP
Referencing requirement: Procedure
 SCHEME_GRP
CHAR
 4 0
ABRUF_PART
Check partner authorizations
 ABRUF_PART
CHAR
 1 0
ABHOD
Pick up date
 ABHOD
DATS
 8 0
ABHOV
Pick up time
 ABHOZ
TIMS
 6 0
ABHOB
Pick up time
 ABHOZ
TIMS
 6 0
RPLNR
Number of payment card plan type
 RPLNR
CHAR
 10 0
VZEIT
Proposed schedule line time (local with ref. to sales org.)
 EZEIT_VBAK
TIMS
 6 0
STCEG_L
Tax Destination Country
 LAND1TX
CHAR
 3 0
LANDTX
Tax departure country
 LANDTX
CHAR
 3 0
XEGDR
Indicator: Triangular deal within the EU ?
 XEGDR
CHAR
 1 0
ENQUEUE_GRP
Block master contr. until all lower level contracts updated
 ENQUEUE_GRP
CHAR
 1 0
DAT_FZAU
Cml delivery order qty date
 DAT_FZAU
DATS
 8 0
FMBDAT
Material Staging/Availability Date
 MBDAT
DATS
 8 0
VSNMR_V
Sales document version number
 VSNMR_V
CHAR
 12 0
POSNR
Sales Document Item
 POSNR_VA
NUMC
 6 0
MATNR
Material Number
 MATNR
CHAR
 18 0
MATWA
Material entered
 MATWA
CHAR
 18 0
PMATN
Pricing Reference Material
 PMATN
CHAR
 18 0
CHARG
Batch Number
 CHARG_D
CHAR
 10 0
MATKL
Material Group
 MATKL
CHAR
 9 0
ARKTX
Short text for sales order item
 ARKTX
CHAR
 40 0
PSTYV
Sales document item category
 PSTYV
CHAR
 4 0
POSAR
Item type
 POSAR
CHAR
 1 0
LFREL
Item is relevant for delivery
 LFREL_AP
CHAR
 1 0
FKREL
Relevant for Billing
 FKREL
CHAR
 1 0
UEPOS
Higher-level item in bill of material structures
 UEPOS
NUMC
 6 0
GRPOS
Item for which this item is an alternative
 GRPOS
NUMC
 6 0
ABGRU
Reason for rejection of quotations and sales orders
 ABGRU_VA
CHAR
 2 0
PRODH
Product hierarchy
 PRODH_D
CHAR
 18 0
ZWERT
Target Value for Outline Agreement in Document Currency
 DZWERT
CURR
 13 2
ZMENG
Target quantity in sales units
 DZMENG
QUAN
 13 3
ZIEME
Target quantity UoM
 DZIEME
UNIT
 3 0
UMZIZ
Factor for converting sales units to base units (target qty)
 UMZIZ
DEC
 5 0
UMZIN
Factor for converting sales units to base units (target qty)
 UMZIN
DEC
 5 0
MEINS
Base Unit of Measure
 MEINS
UNIT
 3 0
SMENG
Scale quantity in base unit of measure
 SMENG
QUAN
 13 3
ABLFZ
Rounding quantity for delivery
 ABLFZ
QUAN
 13 3
ABDAT
Reconciliation Date for Agreed Cumulative Quantity
 ABDAT
DATS
 8 0
ABSFZ
Allowed deviation in quantity (absolute)
 ABSFZ
QUAN
 13 3
POSEX
Item Number of the Underlying Purchase Order
 POSEX
CHAR
 6 0
KDMAT
Material Number Used by Customer
 MATNR_KU
CHAR
 35 0
KBVER
Allowed deviation in quantity (in percent)
 KBVER
DEC
 3 0
KEVER
Days by which the quantity can be shifted
 KEVER
DEC
 3 0
VKGRU
Repair Processing: Classification of Items
 VKGRU
CHAR
 3 0
VKAUS
Usage Indicator
 ABRVW
CHAR
 3 0
GRKOR
Delivery group (items are delivered together)
 GRKOR
NUMC
 3 0
FMENG
Quantity is Fixed
 FMENG
CHAR
 1 0
UEBTK
Unlimited overdelivery allowed
 UEBTK_V
CHAR
 1 0
UEBTO
Overdelivery Tolerance Limit
 UEBTO
DEC
 3 1
UNTTO
Underdelivery Tolerance Limit
 UNTTO
DEC
 3 1
FAKSP
Billing block for item
 FAKSP_AP
CHAR
 2 0
ATPKZ
Replacement part
 ATPKZ
CHAR
 1 0
RKFKF
Method of billing for CO/PPC orders
 RKFKF
CHAR
 1 0
ANTLF
Maximum Number of Partial Deliveries Allowed Per Item
 ANTLF
DEC
 1 0
KZTLF
Partial delivery at item level
 KZTLF
CHAR
 1 0
CHSPL
Batch split allowed
 CHSPL
CHAR
 1 0
KWMENG
Cumulative Order Quantity in Sales Units
 KWMENG
QUAN
 15 3
LSMENG
Cumulative required delivery qty (all dlv-relev.sched.lines)
 LSMENG
QUAN
 15 3
KBMENG
Cumulative confirmed quantity in sales unit
 KBMENG
QUAN
 15 3
KLMENG
Cumulative confirmed quantity in base unit
 KLMENG
QUAN
 15 3
VRKME
Sales unit
 VRKME
UNIT
 3 0
UMVKZ
Numerator (factor) for conversion of sales quantity into SKU
 UMVKZ
DEC
 5 0
UMVKN
Denominator (Divisor) for Conversion of Sales Qty into SKU
 UMVKN
DEC
 5 0
BRGEW
Gross Weight of the Item
 BRGEW_AP
QUAN
 15 3
NTGEW
Net Weight of the Item
 NTGEW_AP
QUAN
 15 3
GEWEI
Weight Unit
 GEWEI
UNIT
 3 0
VOLUM
Volume of the item
 VOLUM_AP
QUAN
 15 3
VOLEH
Volume unit
 VOLEH
UNIT
 3 0
VBELV
Originating document
 VBELV
CHAR
 10 0
POSNV
Originating item
 POSNV
NUMC
 6 0
VGPOS
Item number of the reference item
 VGPOS
NUMC
 6 0
VOREF
Complete reference indicator
 VOREF
CHAR
 1 0
UPFLU
Update indicator for sales document document flow
 UPFLV
CHAR
 1 0
ERLRE
Completion rule for quotation / contract
 ERLRE
CHAR
 1 0
LPRIO
Delivery Priority
 LPRIO
NUMC
 2 0
WERKS
Plant
 WERKS_D
CHAR
 4 0
LGORT
Storage Location
 LGORT_D
CHAR
 4 0
VSTEL
Shipping Point/Receiving Point
 VSTEL
CHAR
 4 0
ROUTE
Route
 ROUTE
CHAR
 6 0
STKEY
Origin of the bill of material
 STKEY
CHAR
 1 0
STDAT
Key date of the bill of material
 STDAT
DATS
 8 0
STLNR
Bill of material
 STNUM
CHAR
 8 0
STPOS
Bill of material item number VBAP not used
 STPOS_VBAP
DEC
 5 0
TAXM1
Tax classification material
 TAXMT
CHAR
 1 0
TAXM2
Tax classification material
 TAXMT
CHAR
 1 0
TAXM3
Tax classification material
 TAXMT
CHAR
 1 0
TAXM4
Tax classification material
 TAXMT
CHAR
 1 0
TAXM5
Tax classification material
 TAXMT
CHAR
 1 0
TAXM6
Tax classification material
 TAXMT
CHAR
 1 0
TAXM7
Tax classification material
 TAXMT
CHAR
 1 0
TAXM8
Tax classification material
 TAXMT
CHAR
 1 0
TAXM9
Tax classification material
 TAXMT
CHAR
 1 0
VBEAF
Fixed shipping processing time in days (= setup time)
 VBEAF
DEC
 5 2
VBEAV
Variable shipping processing time in days
 VBEAV
DEC
 5 2
VGREF
Preceding document has resulted from reference
 VGREF
CHAR
 1 0
NETPR
Net price
 NETPR
CURR
 11 2
KPEIN
Condition pricing unit
 KPEIN
DEC
 5 0
KMEIN
Condition unit
 KMEIN
UNIT
 3 0
SHKZG
Returns Item
 SHKZG_VA
CHAR
 1 0
SKTOF
Cash discount indicator
 SKTOF
CHAR
 1 0
MTVFP
Checking Group for Availability Check
 MTVFP
CHAR
 2 0
SUMBD
Summing up of requirements
 SUMBD
CHAR
 1 0
KONDM
Material Pricing Group
 KONDM
CHAR
 2 0
KTGRM
Account assignment group for this material
 KTGRM
CHAR
 2 0
BONUS
Volume rebate group
 BONUS
CHAR
 2 0
PROVG
Commission group
 PROVG
CHAR
 2 0
EANNR
European Article Number (EAN) - obsolete!!!!!
 EANNR
CHAR
 13 0
PRSOK
Pricing is OK
 PRSOK
CHAR
 1 0
BWTAR
Valuation Type
 BWTAR_D
CHAR
 10 0
BWTEX
Indicator: Separate valuation
 BWTEX
CHAR
 1 0
XCHPF
Batch management requirement indicator
 XCHPF
CHAR
 1 0
XCHAR
Batch management indicator (internal)
 XCHAR
CHAR
 1 0
LFMNG
Minimum delivery quantity in delivery note processing
 MINLF
QUAN
 13 3
WAVWR
Cost in document currency
 WAVWR
CURR
 13 2
KZWI1
Subtotal 1 from pricing procedure for condition
 KZWI1
CURR
 13 2
KZWI2
Subtotal 2 from pricing procedure for condition
 KZWI2
CURR
 13 2
KZWI3
Subtotal 3 from pricing procedure for condition
 KZWI3
CURR
 13 2
KZWI4
Subtotal 4 from pricing procedure for condition
 KZWI4
CURR
 13 2
KZWI5
Subtotal 5 from pricing procedure for condition
 KZWI5
CURR
 13 2
KZWI6
Subtotal 6 from pricing procedure for condition
 KZWI6
CURR
 13 2
STCUR
Exchange rate for statistics (Exch.rate at time of creation)
 STCUR_AP
DEC
 9 5
EAN11
International Article Number (EAN/UPC)
 EAN11
CHAR
 18 0
FIXMG
Delivery date and quantity fixed
 FIXMG
CHAR
 1 0
PRCTR
Profit Center
 PRCTR
CHAR
 10 0
MVGR1
Material group 1
 MVGR1
CHAR
 3 0
MVGR2
Material group 2
 MVGR2
CHAR
 3 0
MVGR3
Material group 3
 MVGR3
CHAR
 3 0
MVGR4
Material group 4
 MVGR4
CHAR
 3 0
MVGR5
Material group 5
 MVGR5
CHAR
 3 0
KMPMG
Component quantity
 KMPMG
QUAN
 13 3
SUGRD
Reason for material substitution
 SUGRD
CHAR
 4 0
SOBKZ
Special Stock Indicator
 SOBKZ
CHAR
 1 0
VPZUO
Allocation Indicator
 VPZUO
CHAR
 1 0
PAOBJNR
Profitability Segment Number (CO-PA)
 RKEOBJNR
NUMC
 10 0
VPMAT
Planning material
 VPMAT
CHAR
 18 0
VPWRK
Planning plant
 VPWRK
CHAR
 4 0
PRBME
Base unit of measure for product group
 PRBME
UNIT
 3 0
UMREF
Conversion factor: quantities
 UMREFF
FLTP
 16 16
KNTTP
Account Assignment Category
 KNTTP
CHAR
 1 0
KZVBR
Consumption Posting
 KZVBR
CHAR
 1 0
SERNR
BOM explosion number
 SERNR
CHAR
 8 0
ABGRS
Results Analysis Key
 ABGR_SCHL
CHAR
 6 0
BEDAE
Requirements type
 BEDAE
CHAR
 4 0
CMPRE
Item credit price
 CMPRE
CURR
 11 2
CMTFG
ID for partial release of order item, credit block
 CMTFG
CHAR
 1 0
CMPNT
ID: Item with active credit function / relevant for credit
 CMPNT
CHAR
 1 0
CMKUA
Credit data exchange rate for requested delivery date
 CMKUA
DEC
 9 5
CUOBJ
Configuration
 CUOBJ_VA
NUMC
 18 0
CUOBJ_CH
Internal object number of the batch classification
 CUOBJ_CH
NUMC
 18 0
CEPOK
Status expected price
 CEPOK
CHAR
 1 0
KOUPD
Condition update
 KOUPD
CHAR
 1 0
SERAIL
Serial Number Profile
 SERAIL
CHAR
 4 0
ANZSN
Number of serial numbers
 ANZSN
INT4
 10 0
NACHL
Customer has not posted goods receipt
 NACHL
CHAR
 1 0
MAGRV
Material Group: Packaging Materials
 MAGRV
CHAR
 4 0
MPROK
Status manual price change
 MPROK
CHAR
 1 0
PROSA
ID for material determination
 PROSA
CHAR
 1 0
UEPVW
ID for higher-level item usage
 UEPVW
CHAR
 1 0
KALNR
Cost Estimate Number for Cost Est. w/o Qty Structure
 CK_KALNR
NUMC
 12 0
KLVAR
Costing Variant
 CK_KLVAR
CHAR
 4 0
SPOSN
BOM Item Number
 SPOSN
CHAR
 4 0
KOWRR
Statistical values
 KOWRR
CHAR
 1 0
STADAT
Statistics date
 STADAT
DATS
 8 0
EXART
Business Transaction Type for Foreign Trade
 EXART
CHAR
 2 0
PREFE
Preference indicator in export/import
 PREFE
CHAR
 1 0
KNUMH
Number of condition record from batch determination
 KNUMH_CH
CHAR
 10 0
CLINT
Internal Class Number
 CLINT
NUMC
 10 0
CHMVS
Batches: Exit to quantity proposal
 CHMVS
NUMC
 3 0
STLTY
BOM category
 STLTY
CHAR
 1 0
STLKN
BOM item node number
 STLKN
NUMC
 8 0
STPOZ
Internal counter
 CIM_COUNT
NUMC
 8 0
STMAN
Inconsistent configuration
 CUINK
CHAR
 1 0
ZSCHL_K
Overhead key
 AUFZSCHL
CHAR
 6 0
KALSM_K
Costing Sheet
 AUFKALSM
CHAR
 6 0
KALVAR
Costing Variant
 CK_KLVAR
CHAR
 4 0
KOSCH
Product allocation determination procedure
 KOSCH
CHAR
 18 0
UPMAT
Pricing reference material of main item
 UPMAT
CHAR
 18 0
UKONM
Material pricing group of main item
 UKONM
CHAR
 2 0
MFRGR
Material freight group
 MFRGR
CHAR
 8 0
PLAVO
Planning delivery schedule instruction
 PLAVO
CHAR
 4 0
KANNR
KANBAN/sequence number
 KANNR
CHAR
 35 0
CMPRE_FLT
Item credit price
 CMPRE_FLT
FLTP
 16 16
ABFOR
Form of payment guarantee
 ABSFORM_CM
CHAR
 2 0
ABGES
Guaranteed (factor between 0 and 1)
 ABGES_CM
FLTP
 16 16
J_1BCFOP
CFOP Code and Extension
 J_1BCFOP
CHAR
 10 0
J_1BTAXLW1
Tax law: ICMS
 J_1BTAXLW1
CHAR
 3 0
J_1BTAXLW2
Tax law: IPI
 J_1BTAXLW2
CHAR
 3 0
J_1BTXSDC
SD tax code
 J_1BTXSDC_
CHAR
 2 0
WKTNR
Value contract no.
 WKTNR
CHAR
 10 0
WKTPS
Value contract item
 WKTPS
NUMC
 6 0
SKOPF
Assortment module
 W_SORTK
CHAR
 18 0
KZBWS
Valuation of Special Stock
 KZBWS
CHAR
 1 0
WGRU1
Material group hierarchy 1
 WGRU_HIE1
CHAR
 18 0
WGRU2
Material group hierarchy 2
 WGRU_HIE2
CHAR
 18 0
KNUMA_PI
Promotion
 KNUMA_PI
CHAR
 10 0
KNUMA_AG
Sales deal
 KNUMA_AG
CHAR
 10 0
KZFME
ID: Leading unit of measure for completing a transaction
 KZFME
CHAR
 1 0
LSTANR
Free goods delivery control
 LSTANR
CHAR
 1 0
TECHS
Parameter Variant/Standard Variant
 TECHS
CHAR
 12 0
MWSBP
Tax amount in document currency
 MWSBP
CURR
 13 2
BERID
MRP Area
 BERID
CHAR
 10 0