SAP Tabel VSVBAP_CN (Version: Sales document: Item data)

SAP table VSVBAP_CN has 4 primary key fields being MANDT,VSNMR,VBELN,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
VSNMR Number or description of a version CHAR 12 0 VSNMR
VBELN Sales Document CHAR 10 0 VBELN_VA
POSNR Sales Document Item NUMC 6 0 POSNR_VA
MATNR Material Number CHAR 40 0 MATNR
MATWA Material Entered CHAR 40 0 MATWA
PMATN Pricing Reference Material CHAR 40 0 PMATN
CHARG Batch Number CHAR 10 0 CHARG_D
MATKL Material Group CHAR 9 0 MATKL
ARKTX Short text for sales order item CHAR 40 0 ARKTX
PSTYV Sales document item category CHAR 4 0 PSTYV
POSAR Item Type CHAR 1 0 POSAR
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 CHAR 1 0 LFREL_AP
FKREL Relevant for Billing CHAR 1 0 FKREL
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)
O Delivery-rel. invoices for partial quantity - No zero qtys
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
W Delivery-Rel. ICB of StTransportOrders in CRM - No Zero Qtys
X Billing request related via an order related billing plan
Y Intercompany billing – delivery-related invoice
UEPOS Higher-Level Item in Bill of Material Structures NUMC 6 0 UEPOS
GRPOS Item for Which this Item is an Alternative NUMC 6 0 GRPOS
ABGRU Reason for Rejection of Sales Documents CHAR 2 0 ABGRU_VA
PRODH Product hierarchy CHAR 18 0 PRODH_D
ZWERT Target Value for Outline Agreement in Document Currency CURR 13 2 DZWERT
ZMENG Target Quantity in Sales Units QUAN 13 3 DZMENG
ZIEME Target Quantity UoM UNIT 3 0 DZIEME
UMZIZ Factor for Converting Sales Units to Base Units (Target Qty) DEC 5 0 UMZIZ
UMZIN Factor for Converting Sales Units to Base Units (Target Qty) DEC 5 0 UMZIN
MEINS Base Unit of Measure UNIT 3 0 MEINS
SMENG Scale Quantity in base unit of measure QUAN 13 3 SMENG
ABLFZ Rounding quantity for delivery QUAN 13 3 ABLFZ
ABDAT Reconciliation date for agreed cumulative quantity DATS 8 0 ABDAT
ABSFZ Allowed deviation in quantity (absolute) QUAN 13 3 ABSFZ
POSEX Item Number of the Underlying Purchase Order CHAR 6 0 POSEX
KDMAT Material Number Used by Customer CHAR 35 0 MATNR_KU
KBVER Allowed deviation in quantity (in percent) DEC 3 0 KBVER
KEVER Days by which the quantity can be shifted DEC 3 0 KEVER
VKGRU Repair Processing: Classification of Items CHAR 3 0 VKGRU
VKAUS Unused - Reserve Length 3 CHAR 3 0 VKAUS
GRKOR Delivery Group (Items are delivered together) NUMC 3 0 GRKOR
FMENG Quantity is fixed CHAR 1 0 FMENG
UEBTK Unlimited Overdelivery Allowed CHAR 1 0 UEBTK_V
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
FAKSP Billing Block for Item CHAR 2 0 FAKSP_AP
ATPKZ Replacement part CHAR 1 0 ATPKZ
No
A Optional substitute part
B Mandatory substitute part
RKFKF Method of billing for CO/PPC orders CHAR 1 0 RKFKF
SPART Division CHAR 2 0 SPART
GSBER Business Area CHAR 4 0 GSBER
NETWR Net Value of the Order Item in Document Currency CURR 15 2 NETWR_AP
WAERK SD Document Currency CUKY 5 0 WAERK
ANTLF Maximum Number of Partial Deliveries Allowed Per Item DEC 1 0 ANTLF
KZTLF Partial delivery at item level CHAR 1 0 KZTLF
Partial delivery allowed
A Create a delivery with quantity 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 CHAR 1 0 CHSPL
KWMENG Cumulative order quantity in sales units QUAN 15 3 KWMENG
LSMENG Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines) QUAN 15 3 LSMENG
KBMENG Cumulative Confirmed Quantity in Sales Unit QUAN 15 3 KBMENG
KLMENG Cumulative Confirmed Quantity in Base Unit QUAN 15 3 KLMENG
VRKME Sales unit UNIT 3 0 VRKME
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
BRGEW Gross Weight of the Item QUAN 15 3 BRGEW_AP
NTGEW Net Weight of the Item QUAN 15 3 NTGEW_AP
GEWEI Weight Unit UNIT 3 0 GEWEI
VOLUM Volume of the item QUAN 15 3 VOLUM_AP
VOLEH Volume unit UNIT 3 0 VOLEH
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
VOREF Complete Reference Indicator CHAR 1 0 VOREF
UPFLU Update indicator for flow table CHAR 1 0 UPFLU
ERLRE Completion Rule for Quotation / Contract CHAR 1 0 ERLRE
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 NUMC 2 0 LPRIO
WERKS Plant CHAR 4 0 WERKS_D
LGORT Storage location CHAR 4 0 LGORT_D
VSTEL Shipping Point / Receiving Point CHAR 4 0 VSTEL
ROUTE Route CHAR 6 0 ROUTE
STKEY Origin of the bill of material CHAR 1 0 STKEY
STDAT Key date of the bill of material DATS 8 0 STDAT
STLNR Bill of Material CHAR 8 0 STNUM
STPOS Bill of material item number VBAP not used DEC 5 0 STPOS_VBAP
AWAHR Order Probability of the Item NUMC 3 0 AWAHR
000 Sales order probability
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERZET Entry time TIMS 6 0 ERZET
TAXM1 Tax Classification for Material CHAR 1 0 TAXMT
TAXM2 Tax Classification for Material CHAR 1 0 TAXMT
TAXM3 Tax Classification for Material CHAR 1 0 TAXMT
TAXM4 Tax Classification for Material CHAR 1 0 TAXMT
TAXM5 Tax Classification for Material CHAR 1 0 TAXMT
TAXM6 Tax Classification for Material CHAR 1 0 TAXMT
TAXM7 Tax Classification for Material CHAR 1 0 TAXMT
TAXM8 Tax Classification for Material CHAR 1 0 TAXMT
TAXM9 Tax Classification for Material CHAR 1 0 TAXMT
VBEAF Fixed shipping processing time in days (= setup time) DEC 5 2 VBEAF
VBEAV Variable shipping processing time in days DEC 5 2 VBEAV
VGREF Preceding document has resulted from reference CHAR 1 0 VGREF
NETPR Net Price CURR 11 2 NETPR
KPEIN Condition Pricing Unit DEC 5 0 KPEIN
KMEIN Condition Unit UNIT 3 0 KMEIN
SHKZG Returns Item CHAR 1 0 SHKZG_VA
SKTOF Cash Discount Indicator CHAR 1 0 SKTOF
MTVFP Checking Group for Availability Check CHAR 2 0 MTVFP
SUMBD Summing up of requirements CHAR 1 0 SUMBD
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 Price Group CHAR 2 0 KONDM
KTGRM Account Assignment Group for Material CHAR 2 0 KTGRM
BONUS Volume rebate group CHAR 2 0 BONUS
PROVG Commission Group CHAR 2 0 PROVG
EANNR European Article Number (EAN) - obsolete!!!!! CHAR 13 0 EANNR
PRSOK Pricing is OK CHAR 1 0 PRSOK
BWTAR Valuation Type CHAR 10 0 BWTAR_D
BWTEX Indicator: Separate valuation CHAR 1 0 BWTEX
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
XCHAR Batch management indicator (internal) CHAR 1 0 XCHAR
LFMNG Minimum Delivery Quantity in Delivery Note Processing QUAN 13 3 MINLF
STAFO Update Group for statistics update CHAR 6 0 STAFO
WAVWR Cost in Document Currency CURR 13 2 WAVWR
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
STCUR Exchange rate for statistics (Exch.rate at time of creation) DEC 9 5 STCUR_AP
AEDAT Last Changed On DATS 8 0 AEDAT
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
FIXMG Delivery Date and Quantity Fixed CHAR 1 0 FIXMG
PRCTR Profit Center CHAR 10 0 PRCTR
MVGR1 Material Group 1 CHAR 3 0 MVGR1
MVGR2 Material Group 2 CHAR 3 0 MVGR2
MVGR3 Material Group 3 CHAR 3 0 MVGR3
MVGR4 Material Group 4 CHAR 3 0 MVGR4
MVGR5 Material Group 5 CHAR 3 0 MVGR5
KMPMG Component Quantity QUAN 13 3 KMPMG
SUGRD Reason for material substitution CHAR 4 0 SUGRD
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
VPZUO Allocation Indicator CHAR 1 0 VPZUO
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
AUFNR Order Number CHAR 12 0 AUFNR
VPMAT Planning material CHAR 40 0 VPMAT
VPWRK Planning plant CHAR 4 0 VPWRK
PRBME Base unit of measure for product group UNIT 3 0 PRBME
UMREF Conversion factor: quantities FLTP 16 16 UMREFF
KNTTP Account Assignment Category CHAR 1 0 KNTTP
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
SERNR BOM explosion number CHAR 8 0 SERNR
OBJNR Object Number at Item Level CHAR 22 0 OBJPO
ABGRS Results Analysis Key CHAR 6 0 ABGR_SCHL
BEDAE Requirements type CHAR 4 0 BEDAE
CMPRE Item credit price CURR 11 2 CMPRE
CMTFG ID for partial release of order item, credit block CHAR 1 0 CMTFG
CMPNT ID: Item with active credit function / relevant for credit CHAR 1 0 CMPNT
CMKUA Credit data exchange rate for requested delivery date DEC 9 5 CMKUA
CUOBJ Configuration NUMC 18 0 CUOBJ_VA
CUOBJ_CH Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
CEPOK Status expected price CHAR 1 0 CEPOK
Not Relevant
A Expected price correct
B Expected price not correct
C Expected price not correct, but released
KOUPD Condition Update CHAR 1 0 KOUPD
SERAIL Serial Number Profile CHAR 4 0 SERAIL
ANZSN Number of serial numbers INT4 10 0 ANZSN
NACHL Customer has not posted goods receipt CHAR 1 0 NACHL
MAGRV Material Group: Packaging Materials CHAR 4 0 MAGRV
MPROK Status manual price change CHAR 1 0 MPROK
No manual price change
A Manual price change carried out
B Condition manually deleted
C Manual price change released
VGTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
PROSA ID for material determination CHAR 1 0 PROSA
No product selection
A Replaced item
B Replacement item
UEPVW ID for higher-level item usage CHAR 1 0 UEPVW
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 NUMC 12 0 CK_KALNR
KLVAR Costing Variant CHAR 4 0 CK_KLVAR
SPOSN BOM Item Number CHAR 4 0 SPOSN
KOWRR Statistical Values CHAR 1 0 KOWRR
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 DATS 8 0 STADAT
EXART Business Transaction Type CHAR 2 0 EXART
PREFE Customs Preference CHAR 1 0 PREFE
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 CHAR 10 0 KNUMH_CH
CLINT Internal Class Number NUMC 10 0 CLINT
CHMVS Batches: Exit to quantity proposal NUMC 3 0 CHMVS
STLTY BOM category CHAR 1 0 STLTY
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
P Work Breakdown Structure BOM
S Standard BOM
T Functional Location BOM
STLKN BOM item node number NUMC 8 0 STLKN
STPOZ Internal counter NUMC 8 0 CIM_COUNT
STMAN Indicator: manual change to sales order BOM CHAR 1 0 CS_KNDVB
ZSCHL_K Overhead key CHAR 6 0 AUFZSCHL
KALSM_K Costing Sheet CHAR 6 0 AUFKALSM
KALVAR Costing Variant CHAR 4 0 CK_KLVAR
KOSCH Product allocation determination procedure CHAR 18 0 KOSCH
UPMAT Pricing reference material of main item CHAR 40 0 UPMAT
UKONM Material pricing group of main item CHAR 2 0 UKONM
MFRGR Material freight group CHAR 8 0 MFRGR
PLAVO Instruction for Planning Delivery Schedule CHAR 4 0 PLAVO
KANNR KANBAN/Sequence Number CHAR 35 0 KANNR
CMPRE_FLT Item Credit Price FLTP 16 16 CMPRE_FLT
ABFOR Form of payment guarantee CHAR 2 0 ABSFORM_CM
ABGES Guaranteed (factor between 0 and 1) FLTP 16 16 ABGES_CM
J_1BCFOP CFOP Code and Extension CHAR 10 0 J_1BCFOP
J_1BTAXLW1 Tax law: ICMS CHAR 3 0 J_1BTAXLW1
J_1BTAXLW2 Tax law: IPI CHAR 3 0 J_1BTAXLW2
J_1BTXSDC SD tax code CHAR 2 0 J_1BTXSDC_
WKTNR Value Contract No. CHAR 10 0 WKTNR
WKTPS Value Contract Item NUMC 6 0 WKTPS
SKOPF Assortment module CHAR 18 0 W_SORTK
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
WGRU1 Material group hierarchy 1 CHAR 18 0 MCW_WGRU1
WGRU2 Material group hierarchy 2 CHAR 18 0 MCW_WGRU2
KNUMA_PI Sales Promotion CHAR 10 0 KNUMA_PI
KNUMA_AG Sales Deal CHAR 10 0 KNUMA_AG
KZFME ID: Leading unit of measure for completing a transaction CHAR 1 0 KZFME
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 CHAR 1 0 LSTANR
TECHS Parameter Variant/Standard Variant CHAR 12 0 TECHS
MWSBP Tax Amount in Document Currency CURR 13 2 MWSBP
BERID MRP Area CHAR 10 0 BERID
PCTRF Profit Center for Billing CHAR 10 0 PCTRF
CPD_UPDAT Time Stamp DEC 15 0 /CPD/PFP_TSTMP
AD01PROFNR Dynamic Item Processor Profile CHAR 8 0 AD01PROFNR
AD01RRRA Resource related results analysis CHAR 1 0 CNEV_RRRA
FERC_IND Regulatory indicator CHAR 4 0 FERC_C7 FE_IND
ARSNUM Number of reservation/dependent requirements NUMC 10 0 * WTYSC_RSNUM
ARSPOS Item number of reservation/dependent requirements NUMC 4 0 WTYSC_RSPOS
WTYSC_CLMITEM Claim item number CHAR 16 0 WTYSC_CLMITEM

VSVBAP_CN foreign key relationships

Table Field Check Table Check Field
0 VSVBAP_CN FERC_IND FERC_C7 Regulatory indicators MANDT
0 VSVBAP_CN FERC_IND FERC_C7 Regulatory indicators IND