SE11 ABAP Dictionary SE11 VBRP

Popular:

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

VBRP

Billing Document: Item Data

SAP SD Transparent Table 198 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	Bill.Doc.	CHAR	10	-	VBAK	Billing Document
3	POSNR	KEY	Item	NUMC	6	-	-	Billing item
4	UEPOS	-	HighLevItm	NUMC	6	-	-	Higher-level item in bill of material structures
5	FKIMG	-	Bill.qty	QUAN	13	3	-	Actual Invoiced Quantity
6	VRKME	-	Sales unit	UNIT	3	-	-	Sales unit
7	UMVKZ	-	Numerator	DEC	5	-	-	Numerator (factor) for conversion of sales quantity into SKU
8	UMVKN	-	Denominat.	DEC	5	-	-	Denominator (Divisor) for Conversion of Sales Qty into SKU
9	MEINS	-	Unit	UNIT	3	-	-	Base Unit of Measure
10	SMENG	-	Scale qty	QUAN	13	3	-	Scale quantity in base unit of measure
11	FKLMG	-	BillQtySKU	QUAN	13	3	-	Billing quantity in stockkeeping unit
12	LMENG	-	Req.qty	QUAN	13	3	-	Required quantity for mat.management in stockkeeping units
13	NTGEW	-	Net	QUAN	15	3	-	Net weight
14	BRGEW	-	Gross	QUAN	15	3	-	Gross weight
15	GEWEI	-	WeightUnit	UNIT	3	-	-	Weight Unit
16	VOLUM	-	Volume	QUAN	15	3	-	Volume
17	VOLEH	-	VolumeUnit	UNIT	3	-	-	Volume unit
18	GSBER	-	Bus. Area	CHAR	4	-	-	Business Area
19	PRSDT	-	Pricing dt	DATS	8	-	-	Date for pricing and exchange rate
20	FBUDA	-	Serv.rend.	DATS	8	-	-	Date on which services rendered
21	KURSK	-	Exch. Rate	DEC	9	5	-	Exchange Rate for Price Determination
22	NETWR	-	Net value	CURR	15	2	-	Net value of the billing item in document currency
23	VBELV	-	OriginDoc.	CHAR	10	-	-	Originating document
24	POSNV	-	Item	NUMC	6	-	-	Originating item
25	VGBEL	-	Ref.doc.	CHAR	10	-	-	Document number of the reference document
26	VGPOS	-	Ref.item	NUMC	6	-	-	Item number of the reference item
27	VGTYP	-	Doc.cat.	CHAR	1	-	-	Document category of preceding SD document
28	AUBEL	-	Sales Doc.	CHAR	10	-	-	Sales Document
29	AUPOS	-	Item	NUMC	6	-	-	Sales Document Item
30	AUREF	-	SaleDocRef	CHAR	1	-	-	Sales document was created from reference
31	MATNR	-	Material	CHAR	18	-	MARA	Material Number
32	ARKTX	-	Desc.	CHAR	40	-	-	Short text for sales order item
33	PMATN	-	Pr.RefMatl	CHAR	18	-	-	Pricing Reference Material
34	CHARG	-	Batch	CHAR	10	-	-	Batch Number
35	MATKL	-	Matl Group	CHAR	9	-	-	Material Group
36	PSTYV	-	Item cat.	CHAR	4	-	-	Sales document item category
37	POSAR	-	Item type	CHAR	1	-	-	Item type
38	PRODH	-	Prod.hier.	CHAR	18	-	-	Product hierarchy
39	VSTEL	-	Ship Point	CHAR	4	-	-	Shipping Point/Receiving Point
40	ATPKZ	-	Replacemt	CHAR	1	-	-	Replacement part
41	SPART	-	Division	CHAR	2	-	-	Division
42	POSPA	-	Partn.item	NUMC	6	-	-	Item number in the partner segment
43	WERKS	-	Plant	CHAR	4	-	T001W	Plant
44	ALAND	-	Country	CHAR	3	-	-	Departure country (country from which the goods are sent)
45	WKREG	-	PlntRegion	CHAR	3	-	-	Region in which plant is located
46	WKCOU	-	PlntCounty	CHAR	3	-	-	County in which plant is located
47	WKCTY	-	Plant city	CHAR	4	-	-	City in which plant is located
48	TAXM1	-	TaxCl.Mat	CHAR	1	-	-	Tax classification material
49	TAXM2	-	TaxCl.2Mat	CHAR	1	-	-	Tax classification 2 for material
50	TAXM3	-	TaxCl.3Mat	CHAR	1	-	-	Tax classification 3 for material
51	TAXM4	-	TaxCl.4Mat	CHAR	1	-	-	Tax Classification 4 Material
52	TAXM5	-	TaxCl.5Mat	CHAR	1	-	-	Tax classification 5 for material
53	TAXM6	-	TaxCl.6Mat	CHAR	1	-	-	Tax classification 6 for material
54	TAXM7	-	TaxCl.7Mat	CHAR	1	-	-	Tax classification 7 for material
55	TAXM8	-	TaxCl.8Mat	CHAR	1	-	-	Tax Classification 8 Material
56	TAXM9	-	TaxCl.9Mat	CHAR	1	-	-	Tax Classification 9 Material
57	KOWRR	-	Stat.value	CHAR	1	-	-	Statistical values
58	PRSFD	-	Pricing	CHAR	1	-	-	Carry out pricing
59	SKTOF	-	Cash.disc.	CHAR	1	-	-	Cash discount indicator
60	SKFBP	-	Cshdiscbas	CURR	13	2	-	Amount eligible for cash discount in document currency
61	KONDM	-	Mat.pr.grp	CHAR	2	-	-	Material Pricing Group
62	KTGRM	-	AcctAsgnmt	CHAR	2	-	-	Account assignment group for this material
63	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
64	BONUS	-	Rebate grp	CHAR	2	-	-	Volume rebate group
65	PROVG	-	Comm.grp	CHAR	2	-	-	Commission group
66	EANNR	-	EAN no.	CHAR	13	-	-	European Article Number (EAN) - obsolete!!!!!
67	VKGRP	-	Sales Grp	CHAR	3	-	-	Sales Group
68	VKBUR	-	Sales Off.	CHAR	4	-	-	Sales Office
69	SPARA	-	Division	CHAR	2	-	-	Division for order header
70	SHKZG	-	Returns	CHAR	1	-	-	Returns item
71	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
72	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
73	ERZET	-	Time	TIMS	6	-	-	Entry time
74	BWTAR	-	Val. Type	CHAR	10	-	-	Valuation Type
75	LGORT	-	Stor. Loc.	CHAR	4	-	T001L	Storage Location
76	STAFO	-	Update grp	CHAR	6	-	-	Update group for statistics update
77	WAVWR	-	Cost	CURR	13	2	-	Cost in document currency
78	KZWI1	-	Subtotal 1	CURR	13	2	-	Subtotal 1 from pricing procedure for condition
79	KZWI2	-	Subtotal 2	CURR	13	2	-	Subtotal 2 from pricing procedure for condition
80	KZWI3	-	Subtotal 3	CURR	13	2	-	Subtotal 3 from pricing procedure for condition
81	KZWI4	-	Subtotal 4	CURR	13	2	-	Subtotal 4 from pricing procedure for condition
82	KZWI5	-	Subtotal 5	CURR	13	2	-	Subtotal 5 from pricing procedure for condition
83	KZWI6	-	Subtotal 6	CURR	13	2	-	Subtotal 6 from pricing procedure for condition
84	STCUR	-	ExRateStat	DEC	9	5	-	Exchange rate for statistics (Exch.rate at time of creation)
85	UVPRS	-	Pricing	CHAR	1	-	-	Incomplete with respect to pricing
86	UVALL	-	General	CHAR	1	-	-	Generally incomplete
87	EAN11	-	EAN/UPC	CHAR	18	-	-	International Article Number (EAN/UPC)
88	PRCTR	-	Profit Ctr	CHAR	10	-	-	Profit Center
89	KVGR1	-	Cust.grp 1	CHAR	3	-	-	Customer group 1
90	KVGR2	-	Cust.grp.2	CHAR	3	-	-	Customer group 2
91	KVGR3	-	Cust.grp.3	CHAR	3	-	-	Customer group 3
92	KVGR4	-	Cust.grp.4	CHAR	3	-	-	Customer group 4
93	KVGR5	-	Cust.grp.5	CHAR	3	-	-	Customer group 5
94	MVGR1	-	Matl grp 1	CHAR	3	-	-	Material group 1
95	MVGR2	-	Matl grp 2	CHAR	3	-	-	Material group 2
96	MVGR3	-	Matl grp 3	CHAR	3	-	-	Material group 3
97	MVGR4	-	Matl grp 4	CHAR	3	-	-	Material group 4
98	MVGR5	-	Matl grp 5	CHAR	3	-	-	Material group 5
99	MATWA	-	MatEntered	CHAR	18	-	-	Material entered
100	BONBA	-	Reb.basis	CURR	13	2	-	Rebate basis 1
101	KOKRS	-	CO Area	CHAR	4	-	-	Controlling Area
102	PAOBJNR	-	Prof.Segmt	NUMC	10	-	-	Profitability Segment Number (CO-PA)
103	PS_PSP_PNR	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
104	AUFNR	-	Order	CHAR	12	-	-	Order Number
105	TXJCD	-	Tax Jur.	CHAR	15	-	-	Tax Jurisdiction
106	CMPRE	-	Price	CURR	11	2	-	Item credit price
107	CMPNT	-	Active	CHAR	1	-	-	ID: Item with active credit function / relevant for credit
108	CUOBJ	-	Configurtn	NUMC	18	-	-	Configuration
109	CUOBJ_CH	-	IntObjNo.	NUMC	18	-	-	Internal object number of the batch classification
110	KOUPD	-	CondUpdate	CHAR	1	-	-	Condition update
111	UECHA	-	HghItmBtch	NUMC	6	-	-	Higher-Level Item of Batch Split Item
112	XCHAR	-	Batches	CHAR	1	-	-	Batch management indicator (internal)
113	ABRVW	-	Usage	CHAR	3	-	-	Usage Indicator
114	SERNR	-	BOMexpl.no	CHAR	8	-	-	BOM explosion number
115	BZIRK_AUFT	-	SlsDistOrd	CHAR	6	-	-	Sales district of sales order
116	KDGRP_AUFT	-	CustGrpOrd	CHAR	2	-	-	Customer group of sales order
117	KONDA_AUFT	-	PricGrpOrd	CHAR	2	-	-	Price group of sales order
118	LLAND_AUFT	-	DestCtryOr	CHAR	3	-	-	Country of destination of sales order
119	MPROK	-	ManualPric	CHAR	1	-	-	Status manual price change
120	PLTYP_AUFT	-	PrLstOrder	CHAR	2	-	-	Price list type of sales order
121	REGIO_AUFT	-	RegionOrd.	CHAR	3	-	-	Region of sales order
122	VKORG_AUFT	-	SOrg-order	CHAR	4	-	-	Sales organization of sales order
123	VTWEG_AUFT	-	DistChOrd.	CHAR	2	-	-	Distribution channel of sales order
124	ABRBG	-	AccSetStrt	DATS	8	-	-	Start of accounting settlement period
125	PROSA	-	MatDetermA	CHAR	1	-	-	ID for material determination
126	UEPVW	-	Us.HLitem	CHAR	1	-	-	ID for higher-level item usage
127	AUTYP	-	Doc.cat.	CHAR	1	-	-	SD document category
128	STADAT	-	Stats.date	DATS	8	-	-	Statistics date
129	FPLNR	-	Bill.plan	CHAR	10	-	-	Billing plan number / invoicing plan number
130	FPLTR	-	Item	NUMC	6	-	-	Item for billing plan/invoice plan/payment cards
131	AKTNR	-	Promotion	CHAR	10	-	-	Promotion
132	KNUMA_PI	-	Promotion	CHAR	10	-	-	Promotion
133	KNUMA_AG	-	Sales deal	CHAR	10	-	-	Sales deal
134	PREFE	-	Preference	CHAR	1	-	-	Preference indicator in export/import
135	MWSBP	-	Tax	CURR	13	2	-	Tax amount in document currency
136	AUGRU_AUFT	-	Ord.reason	CHAR	3	-	-	Order reason (reason for the business transaction)
137	FAREG	-	Bill.rule	CHAR	1	-	-	Rule in billing plan/invoice plan
138	UPMAT	-	MnItm PRM	CHAR	18	-	-	Pricing reference material of main item
139	UKONM	-	MnItem MPG	CHAR	2	-	-	Material pricing group of main item
140	CMPRE_FLT	-	Credit pr.	FLTP	16	16	-	Item credit price
141	ABFOR	-	PaytGuarFm	CHAR	2	-	-	Form of payment guarantee
142	ABGES	-	Guaranteed	FLTP	16	16	-	Guaranteed (factor between 0 and 1)
143	J_1ARFZ	-	Reason	CHAR	1	-	-	Reason for zero VAT
144	J_1AREGIO	-	Region	CHAR	3	-	-	Region (State, Province, County)
145	J_1AGICD	-	Activity	CHAR	2	-	-	Activity Code for Gross Income Tax
146	J_1ADTYP	-	Distribut.	CHAR	2	-	-	Distribution Type for Employment Tax
147	J_1ATXREL	-	Tax rel.	CHAR	10	-	-	Tax relevant classification
148	J_1BCFOP	-	CFOP	CHAR	10	-	-	CFOP Code and Extension
149	J_1BTAXLW1	-	ICMS text	CHAR	3	-	-	Tax law: ICMS
150	J_1BTAXLW2	-	IPI text	CHAR	3	-	-	Tax law: IPI
151	J_1BTXSDC	-	Tax code	CHAR	2	-	-	SD tax code
152	BRTWR	-	Gross val.	CURR	15	2	-	Gross value of the billing item in document currency
153	WKTNR	-	ValContrNo	CHAR	10	-	-	Value contract no.
154	WKTPS	-	VC item	NUMC	6	-	-	Value contract item
155	RPLNR	-	Paym.plan	CHAR	10	-	-	Payment card plan number of sales document
156	KURSK_DAT	-	TranslDate	DATS	8	-	-	Translation Date
157	WGRU1	-	MatGroup 1	CHAR	18	-	-	Material group hierarchy 1
158	WGRU2	-	MatGroup 2	CHAR	18	-	-	Material group hierarchy 2
159	KDKG1	-	CondGrp 1	CHAR	2	-	-	Customer condition group 1
160	KDKG2	-	CondGrp 2	CHAR	2	-	-	Customer condition group 2
161	KDKG3	-	CondGrp 3	CHAR	2	-	-	Customer condition group 3
162	KDKG4	-	CondGrp 4	CHAR	2	-	-	Customer condition group 4
163	KDKG5	-	CondGrp 5	CHAR	2	-	-	Customer condition group 5
164	VKAUS	-	Usage	CHAR	3	-	-	Usage Indicator
165	J_1AINDXP	-	Inf. index	CHAR	5	-	-	Inflation Index
166	J_1AIDATEP	-	Date Index	DATS	8	-	-	Indexing base date
167	KZFME	-	Lead. UoM	CHAR	1	-	-	ID: Leading unit of measure for completing a transaction
168	MWSKZ	-	Tax Code	CHAR	2	-	-	Sales Tax Code
169	VERTT	-	Cont.Type	CHAR	1	-	-	Contract Type
170	VERTN	-	Contract	CHAR	13	-	-	Contract Number
171	SGTXT	-	Text	CHAR	50	-	-	Item Text
172	DELCO	-	Del. time	CHAR	3	-	-	Agreed delivery time
173	BEMOT	-	AcctIndic	CHAR	2	-	-	Accounting Indicator
174	RRREL	-	Rev. recog	CHAR	1	-	-	Revenue recognition category
175	AKKUR	-	LetterRate	DEC	9	5	-	Exchange rate for letter-of-credit procg in foreign trade
176	WMINR	-	Catalog	CHAR	10	-	-	Product catalog number
177	VGBEL_EX	-	Ref.doc.	CHAR	10	-	-	Document number of the reference document
178	VGPOS_EX	-	Ref.item	NUMC	6	-	-	Item number of the reference item
179	LOGSYS	-	LogSystem	CHAR	10	-	-	Logical system
180	VGTYP_EX	-	Category	CHAR	3	-	-	Category of an external transaction or element
181	J_1BTAXLW3	-	ISS Law	CHAR	3	-	-	ISS Tax Law
182	J_1BTAXLW4	-	COFINS Law	CHAR	3	-	-	COFINS Tax Law
183	J_1BTAXLW5	-	PIS Law	CHAR	3	-	-	PIS Tax Law
184	MSR_ID	-	Process ID	CHAR	10	-	-	Process Identification Number
185	MSR_REFUND_CODE	-	Ref. Code	CHAR	3	-	-	Returns Refund Code
186	MSR_RET_REASON	-	Ret.Reason	CHAR	3	-	-	Return Reason
187	AUFPL	-	Plan no.	NUMC	10	-	-	Routing number of operations in the order
188	APLZL	-	Counter	NUMC	8	-	-	Internal counter
189	PEROP_BEG	-	Start Date	DATS	8	-	-	Period of Performance Start Date
190	PEROP_END	-	End Date	DATS	8	-	-	Period of Performance End Date
191	FONDS	-	Fund	CHAR	10	-	-	Fund
192	FISTL	-	Funds Ctr	CHAR	16	-	-	Funds Center
193	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
194	GRANT_NBR	-	Grant	CHAR	20	-	-	Grant
195	BUDGET_PD	-	BP	CHAR	10	-	-	FM: Budget Period
196	CAMPAIGN	-	CGPL_GUID	RAW	16	-	-	Generic project planning: GUID from external R/3 system
197	COMPREAS	-	Abb.	CHAR	4	-	-	Abbreviation for Complaints Reason
198	YYCALLID	-	CC ID	CHAR	3	-	-	Call Center ID

Related References & SQL

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

Interactive ERD Diagrams

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

Standard T-Codes

VF03 VF02 VF05

Related Tables

VBAK MARA T001W T001L VBRK VRKPA VRPMA VKDFS

ANSI SQL Query

SELECT a.VBELN,
       a.POSNR,
       a.UEPOS,
       a.FKIMG,
       a.VRKME,
       a.UMVKZ,
       a.UMVKN
FROM VBRP AS a
WHERE a.VBELN = '0000004987'
  AND a.POSNR = '0001';

ABAP OpenSQL (7.40+)

SELECT a~vbeln,
       a~posnr,
       a~uepos,
       a~fkimg,
       a~vrkme,
       a~umvkz,
       a~umvkn
  FROM vbrp AS a
  WHERE a~vbeln = '0000004987'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_vbrp)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VBRP

VBRP

Dictionary Fields Fields

Related References & SQL