1. Home
  2. Resources
  3. SAP Tables
  4. VSVBAP_CN - Version: Sales document: Item data

SAP Table VSVBAP_CN

Version: Sales document: Item data

VSVBAP_CN (Version: Sales document: Item data) 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 VSVBAP_CN to other SAP tables.

VSVBAP_CN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
VSNMR Number or description of a version VSNMR CHAR 12 0
VBELN Sales Document VBELN_VA CHAR 10 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
NULL Standard Item
A Value Item
B Text item
C Packing item (will be generated)
D Material not relevant
E Packaging Item (External)
LFREL Item is relevant for delivery LFREL_AP CHAR 1 0
X Yes
NULL No
FKREL Relevant for Billing FKREL CHAR 1 0
NULL Not relevant for billing
A Delivery-related billing document
B Relevant for order-related billing - status acc.to order qty
C Relevant for ord.-related billing - status acc.to target qty
D Relevant for pro forma
F Order-related billing doc. - status according to invoice qty
G Order-related billing of the delivery quantity
H Delivery-related billing - no zero quantities
I Order-relevant billing - billing plan
J Relevant for deliveries across EU countries
K Delivery-related invoices for partial quantity
L Pro forma - no zero quantities
M Delivery-related invoices-no zero qtys (incl main batch itm)
N Pro forma - no zero quantities (including main batch items)
P Delivery-related invoices for CSFG - No batch split items
Q Delivery-related invoices for CRM
R Delivery-related invoices for CRM - No zero quantities
S IBS-DI: Order-Related Bill. Doc. with DP w/o Billing Plan
T Delivery-Related Invoices for CRM with IB in CRM
U Delivery-Rel. Invoices for CRM with IB in CRM - No Zero Qtys
V Delivery-Related ICB of Stock Transport Orders in CRM
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 Unused - Reserve Length 3 VKAUS CHAR 3 0
GRKOR Delivery group (items are delivered together) GRKOR NUMC 3 0
FMENG Quantity is Fixed FMENG CHAR 1 0
X Yes
NULL No
UEBTK Unlimited overdelivery allowed UEBTK_V CHAR 1 0
X Yes
NULL No
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
NULL No
A Optional substitute part
B Mandatory substitute part
RKFKF Method of billing for CO/PPC orders RKFKF CHAR 1 0
SPART Division SPART CHAR 2 0
GSBER Business Area GSBER CHAR 4 0
NETWR Net value of the order item in document currency NETWR_AP CURR 15 2
WAERK SD Document Currency WAERK CUKY 5 0
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
KZTLF Partial delivery at item level KZTLF CHAR 1 0
NULL Partial delivery allowed
A Create a delivery with qty greater than zero
B Create only one delivery (also with quantity = 0)
C Only complete delivery allowed
D No limit to subsequent deliveries
CHSPL Batch split allowed CHSPL CHAR 1 0
X Yes
NULL No
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
VGBEL Document number of the reference document VGBEL CHAR 10 0
VGPOS Item number of the reference item VGPOS NUMC 6 0
VOREF Complete reference indicator VOREF CHAR 1 0
X Yes
NULL No
UPFLU Update indicator for flow table UPFLU CHAR 1 0
X Yes
NULL No
ERLRE Completion rule for quotation / contract ERLRE CHAR 1 0
NULL Not relevant for completion
A Item is completed with the first reference
B Item is completed after full quantity has been referenced
C Item is completed after the target qty is fully referenced
D Item is referenced via contract release
E Item is completed after full target value is referenced
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
AWAHR Order probability of the item AWAHR NUMC 3 0
000 Sales order probability
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERZET Entry time ERZET TIMS 6 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
X Yes
NULL No
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
X Yes
NULL No
SKTOF Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
MTVFP Checking Group for Availability Check MTVFP CHAR 2 0
SUMBD Summing up of requirements SUMBD CHAR 1 0
A Single records
B Totals records per day
C Totals records per week, reqs date on Monday of current week
D Totals records per week, reqs date on Monday of fol. week
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
X Yes
NULL No
BWTAR Valuation Type BWTAR_D CHAR 10 0
BWTEX Indicator: Separate valuation BWTEX CHAR 1 0
X Yes
NULL No
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
XCHAR Batch management indicator (internal) XCHAR CHAR 1 0
X Yes
NULL No
LFMNG Minimum delivery quantity in delivery note processing MINLF QUAN 13 3
STAFO Update group for statistics update STAFO CHAR 6 0
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
AEDAT Changed On AEDAT DATS 8 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
FIXMG Delivery date and quantity fixed FIXMG CHAR 1 0
X Yes
NULL No
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
NULL No consumption with customer requirements
1 Consume planning with assembly
2 Consume planning w/o assembly
3 Consume planning material (w/o assembly)
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
AUFNR Order Number AUFNR CHAR 12 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
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
SERNR BOM explosion number SERNR CHAR 8 0
OBJNR Object number at item level OBJPO CHAR 22 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
X Yes
NULL No
CMPNT ID: Item with active credit function / relevant for credit CMPNT CHAR 1 0
X Yes
NULL No
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
NULL Not Relevant
A Expected price correct
B Expected price not correct
C Expected price not correct, but released
KOUPD Condition update KOUPD CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
MAGRV Material Group: Packaging Materials MAGRV CHAR 4 0
MPROK Status manual price change MPROK CHAR 1 0
NULL No manual price change
A Manual price change carried out
B Condition manually deleted
C Manual price change released
VGTYP Document category of preceding SD document VBTYP_V CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
PROSA ID for material determination PROSA CHAR 1 0
NULL No product selection
A Replaced item
B Replacement item
UEPVW ID for higher-level item usage UEPVW CHAR 1 0
A Product selection
B Free goods (inclusive bonus)
C Free goods (on-top bonus)
D Repairs
E ** unused **
F Cross selling
G Complete goods (purchase order)
H Automotive (subitem)
I CRM Repairs
K Kit Component
R Replacement Kit Component
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
NULL System will copy item to header totals
X No cumulation - Values cannot be used statistically
Y No cumulation - Values can be used statistically
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
A Not checked
B Checked - price influenced
C Generally allowed
D Generally not allowed
E Authorized for preference: set manually
F Not authorized for preference: component of mixed origins
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
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLKN BOM item node number STLKN NUMC 8 0
STPOZ Internal counter CIM_COUNT NUMC 8 0
STMAN Indicator: manual change to sales order BOM CS_KNDVB 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
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
WGRU1 Material group hierarchy 1 MCW_WGRU1 CHAR 18 0
WGRU2 Material group hierarchy 2 MCW_WGRU2 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
NULL Base Unit of Measure has Priority
A Proportional Unit has Priority (Active Ingredient)
B Product Unit of Measure has Priority (Steel)
LSTANR Free goods delivery control LSTANR CHAR 1 0
NULL Delivery takes place regardless of main item
A Delivery only if main item is partially delivered
B Delivery only if main item is fully delivered
C Delivery if main item is part. delivered, only with main itm
E Delivery proportional to quantity in main item
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
PCTRF Profit Center for Billing PCTRF CHAR 10 0
FERC_IND Regulatory indicator FE_IND FERC_C7 CHAR 4 0
ARSNUM Number of reservation/dependent requirements WTYSC_RSNUM NUMC 10 0
ARSPOS Item number of reservation/dependent requirements WTYSC_RSPOS NUMC 4 0
WTYSC_CLMITEM Claim item number WTYSC_CLMITEM CHAR 16 0

VSVBAP_CN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VSVBAP_CN FERC_IND VSVBAP_CN MANDT FERC_C7 Regulatory indicators MANDT
VSVBAP_CN FERC_IND VSVBAP_CN FERC_IND FERC_C7 Regulatory indicators IND