SE11 ABAP Dictionary SE11 VBAP

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VBAP

Sales Document: Item Data

SAP SD Transparent Table 232 Fields

Primary Key:

MANDT VBELN POSNR

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	VBELN	KEY	Sales Doc.	CHAR	10	-	VBAK	Sales Document
3	POSNR	KEY	Item	NUMC	6	-	-	Sales Document Item
4	MATNR	-	Material	CHAR	18	-	MARA	Material Number
5	MATWA	-	MatEntered	CHAR	18	-	-	Material entered
6	PMATN	-	Pr.RefMatl	CHAR	18	-	-	Pricing Reference Material
7	CHARG	-	Batch	CHAR	10	-	-	Batch Number
8	MATKL	-	Matl Group	CHAR	9	-	-	Material Group
9	ARKTX	-	Desc.	CHAR	40	-	-	Short text for sales order item
10	PSTYV	-	Item cat.	CHAR	4	-	-	Sales document item category
11	POSAR	-	Item type	CHAR	1	-	-	Item type
12	LFREL	-	Item deliv	CHAR	1	-	-	Item is relevant for delivery
13	FKREL	-	RelBilling	CHAR	1	-	-	Relevant for Billing
14	UEPOS	-	HighLevItm	NUMC	6	-	-	Higher-level item in bill of material structures
15	GRPOS	-	Alt.to itm	NUMC	6	-	-	Item for which this item is an alternative
16	ABGRU	-	Rej.reason	CHAR	2	-	-	Reason for rejection of quotations and sales orders
17	PRODH	-	Prod.hier.	CHAR	18	-	-	Product hierarchy
18	ZWERT	-	Targ. Val.	CURR	13	2	-	Target Value for Outline Agreement in Document Currency
19	ZMENG	-	Target qty	QUAN	13	3	-	Target quantity in sales units
20	ZIEME	-	Target UoM	UNIT	3	-	-	Target quantity UoM
21	UMZIZ	-	ConvFactor	DEC	5	-	-	Factor for converting sales units to base units (target qty)
22	UMZIN	-	ConvFactor	DEC	5	-	-	Factor for converting sales units to base units (target qty)
23	MEINS	-	Unit	UNIT	3	-	-	Base Unit of Measure
24	SMENG	-	Scale qty	QUAN	13	3	-	Scale quantity in base unit of measure
25	ABLFZ	-	Round qty	QUAN	13	3	-	Rounding quantity for delivery
26	ABDAT	-	Recon.Date	DATS	8	-	-	Reconciliation Date for Agreed Cumulative Quantity
27	ABSFZ	-	Absol. dev	QUAN	13	3	-	Allowed deviation in quantity (absolute)
28	POSEX	-	PO item	CHAR	6	-	-	Item Number of the Underlying Purchase Order
29	KDMAT	-	Cust. Mat.	CHAR	35	-	-	Material Number Used by Customer
30	KBVER	-	% deviat.	DEC	3	-	-	Allowed deviation in quantity (in percent)
31	KEVER	-	Dev. days	DEC	3	-	-	Days by which the quantity can be shifted
32	VKGRU	-	Class.Item	CHAR	3	-	-	Repair Processing: Classification of Items
33	VKAUS	-	Usage	CHAR	3	-	-	Usage Indicator
34	GRKOR	-	DelivGroup	NUMC	3	-	-	Delivery group (items are delivered together)
35	FMENG	-	Fixed Qty	CHAR	1	-	-	Quantity is Fixed
36	UEBTK	-	Unlimited	CHAR	1	-	-	Unlimited overdelivery allowed
37	UEBTO	-	Over. Tol.	DEC	3	1	-	Overdelivery Tolerance Limit
38	UNTTO	-	Under.Tol.	DEC	3	1	-	Underdelivery Tolerance Limit
39	FAKSP	-	Bill.block	CHAR	2	-	-	Billing block for item
40	ATPKZ	-	Replacemt	CHAR	1	-	-	Replacement part
41	RKFKF	-	Bill.meth.	CHAR	1	-	-	Method of billing for CO/PPC orders
42	SPART	-	Division	CHAR	2	-	-	Division
43	GSBER	-	Bus. Area	CHAR	4	-	-	Business Area
44	NETWR	-	Net value	CURR	15	2	-	Net value of the order item in document currency
45	WAERK	-	Currency	CUKY	5	-	TCURC	SD Document Currency
46	ANTLF	-	MaxPartDlv	DEC	1	-	-	Maximum Number of Partial Deliveries Allowed Per Item
47	KZTLF	-	Part.dlv.	CHAR	1	-	-	Partial delivery at item level
48	CHSPL	-	Btch split	CHAR	1	-	-	Batch split allowed
49	KWMENG	-	Order qty	QUAN	15	3	-	Cumulative Order Quantity in Sales Units
50	LSMENG	-	ReqDlvQty	QUAN	15	3	-	Cumulative required delivery qty (all dlv-relev.sched.lines)
51	KBMENG	-	Cum.cf.qty	QUAN	15	3	-	Cumulative confirmed quantity in sales unit
52	KLMENG	-	Cum.cf.qty	QUAN	15	3	-	Cumulative confirmed quantity in base unit
53	VRKME	-	Sales unit	UNIT	3	-	-	Sales unit
54	UMVKZ	-	Numerator	DEC	5	-	-	Numerator (factor) for conversion of sales quantity into SKU
55	UMVKN	-	Denominat.	DEC	5	-	-	Denominator (Divisor) for Conversion of Sales Qty into SKU
56	BRGEW	-	Gross	QUAN	15	3	-	Gross Weight of the Item
57	NTGEW	-	Net weight	QUAN	15	3	-	Net Weight of the Item
58	GEWEI	-	WeightUnit	UNIT	3	-	-	Weight Unit
59	VOLUM	-	Volume	QUAN	15	3	-	Volume of the item
60	VOLEH	-	VolumeUnit	UNIT	3	-	-	Volume unit
61	VBELV	-	OriginDoc.	CHAR	10	-	-	Originating document
62	POSNV	-	Item	NUMC	6	-	-	Originating item
63	VGBEL	-	Ref.doc.	CHAR	10	-	-	Document number of the reference document
64	VGPOS	-	Ref.item	NUMC	6	-	-	Item number of the reference item
65	VOREF	-	Compl.ref.	CHAR	1	-	-	Complete reference indicator
66	UPFLU	-	UpdateFlow	CHAR	1	-	-	Update indicator for sales document document flow
67	ERLRE	-	Compl.rule	CHAR	1	-	-	Completion rule for quotation / contract
68	LPRIO	-	Dlv.Prior.	NUMC	2	-	-	Delivery Priority
69	WERKS	-	Plant	CHAR	4	-	T001W	Plant (Own or External)
70	LGORT	-	Stor. Loc.	CHAR	4	-	T001L	Storage Location
71	VSTEL	-	Ship Point	CHAR	4	-	-	Shipping Point/Receiving Point
72	ROUTE	-	Route	CHAR	6	-	-	Route
73	STKEY	-	BOM origin	CHAR	1	-	-	Origin of the bill of material
74	STDAT	-	BOM key dt	DATS	8	-	-	Key date of the bill of material
75	STLNR	-	BOM	CHAR	8	-	-	Bill of material
76	STPOS	-	BOM Itm No	DEC	5	-	-	Bill of material item number VBAP not used
77	AWAHR	-	Probab.	NUMC	3	-	-	Order probability of the item
78	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
79	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
80	ERZET	-	Time	TIMS	6	-	-	Entry time
81	TAXM1	-	Tax class.	CHAR	1	-	-	Tax classification material
82	TAXM2	-	Tax class.	CHAR	1	-	-	Tax classification material
83	TAXM3	-	Tax class.	CHAR	1	-	-	Tax classification material
84	TAXM4	-	Tax class.	CHAR	1	-	-	Tax classification material
85	TAXM5	-	Tax class.	CHAR	1	-	-	Tax classification material
86	TAXM6	-	Tax class.	CHAR	1	-	-	Tax classification material
87	TAXM7	-	Tax class.	CHAR	1	-	-	Tax classification material
88	TAXM8	-	Tax class.	CHAR	1	-	-	Tax classification material
89	TAXM9	-	Tax class.	CHAR	1	-	-	Tax classification material
90	VBEAF	-	Fixed PrTi	DEC	5	2	-	Fixed shipping processing time in days (= setup time)
91	VBEAV	-	VarPrcTime	DEC	5	2	-	Variable shipping processing time in days
92	VGREF	-	Prec. Ref.	CHAR	1	-	-	Preceding document has resulted from reference
93	NETPR	-	Net price	CURR	11	2	-	Net price
94	KPEIN	-	Unit	DEC	5	-	-	Condition pricing unit
95	KMEIN	-	Unit	UNIT	3	-	-	Condition unit
96	SHKZG	-	Returns	CHAR	1	-	-	Returns Item
97	SKTOF	-	Cash.disc.	CHAR	1	-	-	Cash discount indicator
98	MTVFP	-	AvailCheck	CHAR	2	-	-	Checking Group for Availability Check
99	SUMBD	-	Req.totals	CHAR	1	-	-	Summing up of requirements
100	KONDM	-	Mat.pr.grp	CHAR	2	-	-	Material Pricing Group
101	KTGRM	-	AcctAsgnmt	CHAR	2	-	-	Account assignment group for this material
102	BONUS	-	Rebate grp	CHAR	2	-	-	Volume rebate group
103	PROVG	-	Comm.grp	CHAR	2	-	-	Commission group
104	EANNR	-	EAN no.	CHAR	13	-	-	European Article Number (EAN) - obsolete!!!!!
105	PRSOK	-	Pricing	CHAR	1	-	-	Pricing is OK
106	BWTAR	-	Val. Type	CHAR	10	-	-	Valuation Type
107	BWTEX	-	Sep.val.	CHAR	1	-	-	Indicator: Separate valuation
108	XCHPF	-	Batch mgmt	CHAR	1	-	-	Batch management requirement indicator
109	XCHAR	-	Batches	CHAR	1	-	-	Batch management indicator (internal)
110	LFMNG	-	Dely qty	QUAN	13	3	-	Minimum delivery quantity in delivery note processing
111	STAFO	-	Update grp	CHAR	6	-	-	Update group for statistics update
112	WAVWR	-	Cost	CURR	13	2	-	Cost in document currency
113	KZWI1	-	Subtotal 1	CURR	13	2	-	Subtotal 1 from pricing procedure for condition
114	KZWI2	-	Subtotal 2	CURR	13	2	-	Subtotal 2 from pricing procedure for condition
115	KZWI3	-	Subtotal 3	CURR	13	2	-	Subtotal 3 from pricing procedure for condition
116	KZWI4	-	Subtotal 4	CURR	13	2	-	Subtotal 4 from pricing procedure for condition
117	KZWI5	-	Subtotal 5	CURR	13	2	-	Subtotal 5 from pricing procedure for condition
118	KZWI6	-	Subtotal 6	CURR	13	2	-	Subtotal 6 from pricing procedure for condition
119	STCUR	-	ExRateStat	DEC	9	5	-	Exchange rate for statistics (Exch.rate at time of creation)
120	AEDAT	-	Chngd	DATS	8	-	-	Changed On
121	EAN11	-	EAN/UPC	CHAR	18	-	-	International Article Number (EAN/UPC)
122	FIXMG	-	Fixed	CHAR	1	-	-	Delivery date and quantity fixed
123	PRCTR	-	Profit Ctr	CHAR	10	-	-	Profit Center
124	MVGR1	-	Matl grp 1	CHAR	3	-	-	Material group 1
125	MVGR2	-	Matl grp 2	CHAR	3	-	-	Material group 2
126	MVGR3	-	Matl grp 3	CHAR	3	-	-	Material group 3
127	MVGR4	-	Matl grp 4	CHAR	3	-	-	Material group 4
128	MVGR5	-	Matl grp 5	CHAR	3	-	-	Material group 5
129	KMPMG	-	Quantity	QUAN	13	3	-	Component quantity
130	SUGRD	-	Reason	CHAR	4	-	-	Reason for material substitution
131	SOBKZ	-	Spec.Stock	CHAR	1	-	-	Special Stock Indicator
132	VPZUO	-	Alloc.ind.	CHAR	1	-	-	Allocation Indicator
133	PAOBJNR	-	Prof.Segmt	NUMC	10	-	-	Profitability Segment Number (CO-PA)
134	PS_PSP_PNR	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
135	AUFNR	-	Order	CHAR	12	-	-	Order Number
136	VPMAT	-	Plng matl	CHAR	18	-	-	Planning material
137	VPWRK	-	Plng plant	CHAR	4	-	-	Planning plant
138	PRBME	-	PG unit	UNIT	3	-	-	Base unit of measure for product group
139	UMREF	-	Conversion	FLTP	16	16	-	Conversion factor: quantities
140	KNTTP	-	AcctAssCat	CHAR	1	-	-	Account Assignment Category
141	KZVBR	-	Consumpt.	CHAR	1	-	-	Consumption Posting
142	SERNR	-	BOMexpl.no	CHAR	8	-	-	BOM explosion number
143	OBJNR	-	ObjNo Itm	CHAR	22	-	-	Object number at item level
144	ABGRS	-	RA Key	CHAR	6	-	-	Results Analysis Key
145	BEDAE	-	RqType	CHAR	4	-	-	Requirements type
146	CMPRE	-	Price	CURR	11	2	-	Item credit price
147	CMTFG	-	Release	CHAR	1	-	-	ID for partial release of order item, credit block
148	CMPNT	-	Active	CHAR	1	-	-	ID: Item with active credit function / relevant for credit
149	CMKUA	-	Exch.rate	DEC	9	5	-	Credit data exchange rate for requested delivery date
150	CUOBJ	-	Configurtn	NUMC	18	-	-	Configuration
151	CUOBJ_CH	-	IntObjNo.	NUMC	18	-	-	Internal object number of the batch classification
152	CEPOK	-	Expect.pr.	CHAR	1	-	-	Status expected price
153	KOUPD	-	CondUpdate	CHAR	1	-	-	Condition update
154	SERAIL	-	Profile	CHAR	4	-	-	Serial Number Profile
155	ANZSN	-	No.ser.no.	INT4	10	-	-	Number of serial numbers
156	NACHL	-	No GR	CHAR	1	-	-	Customer has not posted goods receipt
157	MAGRV	-	Mat.Grp PM	CHAR	4	-	-	Material Group: Packaging Materials
158	MPROK	-	ManualPric	CHAR	1	-	-	Status manual price change
159	VGTYP	-	Doc.cat.	CHAR	1	-	-	Document category of preceding SD document
160	PROSA	-	MatDetermA	CHAR	1	-	-	ID for material determination
161	UEPVW	-	Us.HLitem	CHAR	1	-	-	ID for higher-level item usage
162	KALNR	-	CENo	NUMC	12	-	-	Cost Estimate Number for Cost Est. w/o Qty Structure
163	KLVAR	-	Cstg Vrnt	CHAR	4	-	-	Costing Variant
164	SPOSN	-	Item	CHAR	4	-	-	BOM Item Number
165	KOWRR	-	Stat.value	CHAR	1	-	-	Statistical values
166	STADAT	-	Stats.date	DATS	8	-	-	Statistics date
167	EXART	-	BusTransTy	CHAR	2	-	-	Business Transaction Type for Foreign Trade
168	PREFE	-	Preference	CHAR	1	-	-	Preference indicator in export/import
169	KNUMH	-	NoCndRec.B	CHAR	10	-	-	Number of condition record from batch determination
170	CLINT	-	IntClassNo	NUMC	10	-	-	Internal Class Number
171	CHMVS	-	QtyProposl	NUMC	3	-	-	Batches: Exit to quantity proposal
172	STLTY	-	BOM cat	CHAR	1	-	-	BOM category
173	STLKN	-	Nodes	NUMC	8	-	-	BOM item node number
174	STPOZ	-	Counter	NUMC	8	-	-	Internal counter
175	STMAN	-	Incons.con	CHAR	1	-	-	Inconsistent configuration
176	ZSCHL_K	-	OH key	CHAR	6	-	-	Overhead key
177	KALSM_K	-	Cstg Sheet	CHAR	6	-	-	Costing Sheet
178	KALVAR	-	Cstg Vrnt	CHAR	4	-	-	Costing Variant
179	KOSCH	-	Prod.all.	CHAR	18	-	-	Product allocation determination procedure
180	UPMAT	-	MnItm PRM	CHAR	18	-	-	Pricing reference material of main item
181	UKONM	-	MnItem MPG	CHAR	2	-	-	Material pricing group of main item
182	MFRGR	-	MatlFrtGrp	CHAR	8	-	-	Material freight group
183	PLAVO	-	Instructn	CHAR	4	-	-	Planning delivery schedule instruction
184	KANNR	-	SequenceNo	CHAR	35	-	-	KANBAN/sequence number
185	CMPRE_FLT	-	Credit pr.	FLTP	16	16	-	Item credit price
186	ABFOR	-	PaytGuarFm	CHAR	2	-	-	Form of payment guarantee
187	ABGES	-	Guaranteed	FLTP	16	16	-	Guaranteed (factor between 0 and 1)
188	J_1BCFOP	-	CFOP	CHAR	10	-	-	CFOP Code and Extension
189	J_1BTAXLW1	-	ICMS text	CHAR	3	-	-	Tax law: ICMS
190	J_1BTAXLW2	-	IPI text	CHAR	3	-	-	Tax law: IPI
191	J_1BTXSDC	-	Tax code	CHAR	2	-	-	SD tax code
192	WKTNR	-	ValContrNo	CHAR	10	-	-	Value contract no.
193	WKTPS	-	VC item	NUMC	6	-	-	Value contract item
194	SKOPF	-	Module	CHAR	18	-	-	Assortment module
195	KZBWS	-	Valuation	CHAR	1	-	-	Valuation of Special Stock
196	WGRU1	-	MatGroup 1	CHAR	18	-	-	Material group hierarchy 1
197	WGRU2	-	MatGroup 2	CHAR	18	-	-	Material group hierarchy 2
198	KNUMA_PI	-	Promotion	CHAR	10	-	-	Promotion
199	KNUMA_AG	-	Sales deal	CHAR	10	-	-	Sales deal
200	KZFME	-	Lead. UoM	CHAR	1	-	-	ID: Leading unit of measure for completing a transaction
201	LSTANR	-	FGDelyCont	CHAR	1	-	-	Free goods delivery control
202	TECHS	-	StdVariant	CHAR	12	-	-	Parameter Variant/Standard Variant
203	MWSBP	-	Tax	CURR	13	2	-	Tax amount in document currency
204	BERID	-	MRP Area	CHAR	10	-	-	MRP Area
205	PCTRF	-	PrCtr Bill	CHAR	10	-	-	Profit Center for Billing
206	LOGSYS_EXT	-	LogSystem	CHAR	10	-	-	Logical system
207	J_1BTAXLW3	-	ISS Law	CHAR	3	-	-	ISS Tax Law
208	J_1BTAXLW4	-	COFINS Law	CHAR	3	-	-	COFINS Tax Law
209	J_1BTAXLW5	-	PIS Law	CHAR	3	-	-	PIS Tax Law
210	STOCKLOC	-	Location	CHAR	20	-	-	First Inventory-Managing Location
211	SLOCTYPE	-	Loc. Type	CHAR	4	-	-	Type of First Inventory-Managing Location
212	MSR_RET_REASON	-	Ret.Reason	CHAR	3	-	-	Return Reason
213	MSR_REFUND_CODE	-	Ref. Code	CHAR	3	-	-	Returns Refund Code
214	MSR_APPROV_BLOCK	-	Approval	CHAR	1	-	-	Approval Block
215	/BEV1/SRFUND	-	Ana./RfRej	CHAR	2	-	-	Analysis/Reason for Rejection
216	AUFPL_OLC	-	Plan no.	NUMC	10	-	-	Routing number of operations in the order
217	APLZL_OLC	-	Counter	NUMC	8	-	-	Internal counter
218	FERC_IND	-	Reg. ind.	CHAR	4	-	-	Regulatory indicator
219	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
220	FONDS	-	Fund	CHAR	10	-	-	Fund
221	FISTL	-	Funds Ctr	CHAR	16	-	-	Funds Center
222	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
223	GRANT_NBR	-	Grant	CHAR	20	-	-	Grant
224	BUDGET_PD	-	BP	CHAR	10	-	-	FM: Budget Period
225	IUID_RELEVANT	-	IUID Cust.	CHAR	1	-	-	IUID Relevant for Customer
226	MILL_SE_GPOSN	-	Global Itm	NUMC	6	-	-	Global Item
227	PRS_OBJNR	-	EnMg:ObjNr	CHAR	22	-	-	Engagement mgmt: Object number
228	ARSNUM	-	Reserv.no.	NUMC	10	-	-	Number of reservation/dependent requirements
229	ARSPOS	-	Item No.	NUMC	4	-	-	Item number of reservation/dependent requirements
230	WTYSC_CLMITEM	-	Clm Item	CHAR	16	-	-	Claim item number
231	ZZDEA_LICENSE	-	DEA No.	CHAR	9	-	-	DEA Number
232	ZZDEA_SCHEDULE	-	DEA Sched	CHAR	2	-	-	DEA Schedule Key

Foreign Keys & Joins

VBAK → N : 1

              VBAP-VBELN = VBAK-VBELN            

MARA → N : 1

              VBAP-MATNR = MARA-MATNR            

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk VBAP.

Interactive ERD Diagrams

SAP SD - Sales Tables Relation → SAP SD Table Mapping & Document Flow →

Standard T-Codes

VA03 VA01 VA02 VA05

Related Tables

VBAK MARA TCURC T001W T001L VBEP VBEH VBKD

ANSI SQL Query

SELECT a.VBELN,
       a.POSNR,
       a.MATNR,
       a.MATWA,
       a.PMATN,
       a.CHARG,
       a.MATKL
FROM VBAP AS a
LEFT JOIN VBAK AS b
  ON b.MANDT = a.MANDT
 AND b.VBELN = a.VBELN
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~vbeln,
       a~posnr,
       a~matnr,
       a~matwa,
       a~pmatn,
       a~charg,
       a~matkl
  FROM vbap AS a
  LEFT OUTER JOIN vbak AS b
    ON b~VBELN = a~VBELN
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vbap)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBAP

VBAP

Dictionary Fields Fields

Foreign Keys & Joins

Related References & SQL