SAP ABAP Table WB2_V_VBRK_VBRP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	WB2_V_VBRK_VBRP	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
3	MANDT_I	☑	MANDT	MANDT	CLNT	3	0	Client	T000
4	VBELN_I	☑	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
5	POSNR_I	☑	POSNR_VF	POSNR	NUMC	6	0	Billing item	VBUP
6	MANDT_W	☑	MANDT	MANDT	CLNT	3	0	Client	T000
7	DOC_TYPE_W	☑	WB2_DOC_TYPE	WB2_DOC_TYPE	CHAR	2	0	Document Type
8	VBELN_W	☑	WB2_DOCUMENT_NUMBER	VBELN	CHAR	10	0	General Document Number
9	POSNR_W	☑	WB2_DOCUMENT_ITEM	POSNR	NUMC	6	0	Item Number of a Document
10	POSNR_SUB_W	☑	WB2_SUB_ITEM	TPOSN	NUMC	6	0	Sub-Item Number of a Document
11	GJAHR_W	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
12	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
13	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
14	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
15	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
16	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
17	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
18	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
19	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
20	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
21	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
22	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
23	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
24	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
25	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
26	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
27	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
28	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
29	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
30	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
31	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
32	RFBSK	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
33	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
34	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
35	CPKUR	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
36	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
37	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
38	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
39	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
40	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
41	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
42	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
43	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
44	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
45	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
46	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer
47	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer
48	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer
49	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer
50	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer
51	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer
52	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer
53	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer
54	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer
55	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
56	ZUKRI	☐	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
57	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
58	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
59	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
60	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
61	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
62	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
63	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
64	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
65	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
66	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
67	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
68	SFAKN	☐	SFAKN	VBELN	CHAR	10	0	Cancelled billing document number	VBUK
69	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
70	FKART_RL	☐	FKART_RL	FKART	CHAR	4	0	Invoice list type	TVFK
71	FKDAT_RL	☐	FKDAT_RL	DATUM	DATS	8	0	Billing date for the invoice list
72	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
73	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
74	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
75	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
76	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
77	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
78	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
79	CMKUF	☐	CMKUF	KURRF	DEC	9	5	Credit data exchange rate at billing document rate
80	HITYP_PR	☐	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing	THIT
81	BSTNK_VF	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
82	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
83	FKART_AB	☐	FKART_AB	FKART	CHAR	4	0	Accrual billing type
84	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application
85	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country
86	STCEG_H	☐	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
87	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number
88	XBLNR	☐	XBLNR_V1	XBLNR1	CHAR	16	0	Reference Document Number
89	ZUONR	☐	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
90	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
91	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system
92	FKSTO	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
93	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
94	RPLNR	☐	RPLNR	FPLNR	CHAR	10	0	Installment Plan Number	FPLA
95	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
96	J_1AFITP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
97	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
98	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade	TCURC
99	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
100	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
101	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
102	NUMPG	☐	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
103	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
104	UEPOS_I	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	VBUP
105	FKIMG_I	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
106	VRKME_I	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
107	UMVKZ_I	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
108	UMVKN_I	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
109	MEINS_I	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
110	SMENG_I	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
111	FKLMG_I	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
112	LMENG_I	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
113	NTGEW_I	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
114	BRGEW_I	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
115	GEWEI_I	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
116	VOLUM_I	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
117	VOLEH_I	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
118	GSBER_I	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
119	PRSDT_I	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
120	FBUDA_I	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
121	KURSK_I	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
122	NETWR_I	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
123	VBELV_I	☐	VBELV	VBELN	CHAR	10	0	Originating document	VBUK
124	POSNV_I	☐	POSNV	POSNR	NUMC	6	0	Originating item	VBUP
125	VGBEL_I	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
126	VGPOS_I	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
127	VGTYP_I	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
128	AUBEL_I	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
129	AUPOS_I	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
130	AUREF_I	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
131	MATNR_I	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
132	ARKTX_I	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
133	PMATN_I	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
134	CHARG_I	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
135	MATKL_I	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
136	PSTYV_I	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category
137	POSAR_I	☐	POSAR	POSAR	CHAR	1	0	Item type
138	PRODH_I	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
139	VSTEL_I	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
140	ATPKZ_I	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
141	SPART_I	☐	SPART	SPART	CHAR	2	0	Division	TSPA
142	POSPA_I	☐	POSPA	POSNR	NUMC	6	0	Item number in the partner segment	VBUP
143	WERKS_I	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
144	ALAND_I	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
145	WKREG_I	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	T005S
146	WKCOU_I	☐	WKCOU	CHAR3	CHAR	3	0	County in which plant is located
147	WKCTY_I	☐	WKCTY	CHAR4	CHAR	4	0	City in which plant is located
148	TAXM1_I	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material
149	TAXM2_I	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material
150	TAXM3_I	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material
151	TAXM4_I	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material
152	TAXM5_I	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material
153	TAXM6_I	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material
154	TAXM7_I	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material
155	TAXM8_I	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material
156	TAXM9_I	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material
157	KOWRR_I	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
158	PRSFD_I	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
159	SKTOF_I	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
160	SKFBP_I	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
161	KONDM_I	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	T178
162	KTGRM_I	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
163	KOSTL_I	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
164	BONUS_I	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
165	PROVG_I	☐	PROVG	PROVG	CHAR	2	0	Commission group	TVPR
166	EANNR_I	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
167	VKGRP_I	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
168	VKBUR_I	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
169	SPARA_I	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TSPA
170	SHKZG_I	☐	SHKZG_VF	SHKZG_VF	CHAR	1	0	Returns item
171	ERNAM_I	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
172	ERDAT_I	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
173	ERZET_I	☐	ERZET	UZEIT	TIMS	6	0	Entry time
174	BWTAR_I	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
175	LGORT_I	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
176	STAFO_I	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
177	WAVWR_I	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
178	KZWI1_I	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
179	KZWI2_I	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
180	KZWI3_I	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
181	KZWI4_I	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
182	KZWI5_I	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
183	KZWI6_I	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
184	STCUR_I	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
185	UVPRS_I	☐	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
186	UVALL_I	☐	UVALL	XFELD	CHAR	1	0	Generally incomplete
187	EAN11_I	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
188	PRCTR_I	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
189	KVGR1_I	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
190	KVGR2_I	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
191	KVGR3_I	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
192	KVGR4_I	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
193	KVGR5_I	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
194	MVGR1_I	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
195	MVGR2_I	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
196	MVGR3_I	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
197	MVGR4_I	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
198	MVGR5_I	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
199	MATWA_I	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
200	BONBA_I	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
201	KOKRS_I	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
202	PAOBJNR_I	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
203	PS_PSP_PNR_I	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
204	AUFNR_I	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
205	TXJCD_I	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
206	CMPRE_I	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
207	CMPNT_I	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
208	CUOBJ_I	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
209	CUOBJ_CH_I	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
210	KOUPD_I	☐	KOUPD	XFELD	CHAR	1	0	Condition update
211	UECHA_I	☐	UECHA	POSNR	NUMC	6	0	Higher-Level Item of Batch Split Item
212	XCHAR_I	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
213	ABRVW_I	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
214	SERNR_I	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
215	BZIRK_AUFT_I	☐	BZIRK_AUFT	BZIRK	CHAR	6	0	Sales district of sales order	T171
216	KDGRP_AUFT_I	☐	KDGRP_AUFT	KDGRP	CHAR	2	0	Customer group of sales order	T151
217	KONDA_AUFT_I	☐	KONDA_AUFT	KONDA	CHAR	2	0	Price group of sales order	T188
218	LLAND_AUFT_I	☐	LLAND_AUFT	LAND1	CHAR	3	0	Country of destination of sales order	T005
219	MPROK_I	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
220	PLTYP_AUFT_I	☐	PLTYP_AUFT	PLTYP	CHAR	2	0	Price list type of sales order	T189
221	REGIO_AUFT_I	☐	REGIO_AUFT	REGIO	CHAR	3	0	Region of sales order	T005S
222	VKORG_AUFT_I	☐	VKORG_AUFT	VKORG	CHAR	4	0	Sales organization of sales order	TVKO
223	VTWEG_AUFT_I	☐	VTWEG_AUFT	VTWEG	CHAR	2	0	Distribution channel of sales order	TVTW
224	ABRBG_I	☐	ABRBG	DATUM	DATS	8	0	Start of accounting settlement period
225	PROSA_I	☐	PROSA	PROSA	CHAR	1	0	ID for material selection - active
226	UEPVW_I	☐	UEPVW	UEPVW	CHAR	1	0	ID for higher-level item usage
227	AUTYP_I	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
228	STADAT_I	☐	STADAT	DATUM	DATS	8	0	Statistics date
229	FPLNR_I	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	FPLA
230	FPLTR_I	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards
231	AKTNR_I	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
232	KNUMA_PI_I	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion	KONA
233	KNUMA_AG_I	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	KONA
234	PREFE_I	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
235	MWSBP_I	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
236	AUGRU_AUFT_I	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
237	FAREG_I	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
238	UPMAT_I	☐	UPMAT	MATNR	CHAR	18	0	Pricing reference material of main item	MARA
239	UKONM_I	☐	UKONM	KONDM	CHAR	2	0	Material pricing group of main item	T178
240	CMPRE_FLT_I	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
241	ABFOR_I	☐	ABSFORM_CM	ABSFORM_CM	CHAR	2	0	Form of payment guarantee	T691K
242	ABGES_I	☐	ABGES_CM	FLTP	FLTP	16	16	Guaranteed (factor between 0 and 1)
243	J_1ARFZ_I	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT	J_1ARFZ
244	J_1AREGIO_I	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
245	J_1AGICD_I	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
246	J_1ADTYP_I	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
247	J_1ATXREL_I	☐	J_1ATXREL_	J_1ATXREL	CHAR	10	0	Tax relevant classification	J_1ATXREL
248	J_1BCFOP_I	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	J_1BAG
249	J_1BTAXLW1_I	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS	J_1BATL1
250	J_1BTAXLW2_I	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI	J_1BATL2
251	J_1BTXSDC_I	☐	J_1BTXSDC_	J_1BTXSDC	CHAR	2	0	SD tax code	J_1BTXSDC
252	BRTWR_I	☐	BRTWR_FP	WERTV8	CURR	15	2	Gross value of the billing item in document currency
253	WKTNR_I	☐	WKTNR	VBELN	CHAR	10	0	Value contract no.	VBUK
254	WKTPS_I	☐	WKTPS	POSNR	NUMC	6	0	Value contract item	VBUP
255	RPLNR_I	☐	RPLNR_AU	FPLNR	CHAR	10	0	Payment card plan number of sales document	FPLA
256	KURSK_DAT_I	☐	WWERT_D	DATUM	DATS	8	0	Translation date
257	WGRU1_I	☐	WGRU_HIE1	KLASSE	CHAR	18	0	Material group hierarchy 1
258	WGRU2_I	☐	WGRU_HIE2	KLASSE	CHAR	18	0	Material group hierarchy 2
259	KDKG1_I	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
260	KDKG2_I	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
261	KDKG3_I	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
262	KDKG4_I	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
263	KDKG5_I	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
264	VKAUS_I	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	TVLV
265	J_1AINDXP_I	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
266	J_1AIDATEP_I	☐	J_1AIDATES	J_1AUDATEP	DATS	8	0	Indexing base date
267	KZFME_I	☐	KZFME	KZFME	CHAR	1	0	ID: Leading unit of measure for completing a transaction
268	MWSKZ_I	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
269	VERTT_I	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
270	VERTN_I	☐	RANL	RANL	CHAR	13	0	Contract Number
271	SGTXT_I	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
272	DELCO_I	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
273	BEMOT_I	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
274	RRREL_I	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
275	AKKUR_I	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
276	WMINR_I	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
277	TKONN_W	☐	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	WBHK
278	TPOSN_W	☐	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number	WBHI
279	TPOSN_SUB_W	☐	TPOSN_SUB	TPOSN	NUMC	6	0	Trading Contract: Sub-Item Number	WBHI
280	ERNAM_W	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
281	ERDAT_W	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
282	TEW_TYPE_W	☐	WB2_TEW_TYPE	WB2_TEW_TYPE	CHAR	4	0	Trading Execution Workbench Type	TEWTYPE
283	SCENARIO_W	☐	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario	TEWSCENARIO
284	TKONN_EX_W	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
285	COMPLETE_W	☐	WB2_DOCUMENT_COMPLETE_2	WB2_DOCUMENT_COMPLETE_2	CHAR	1	0	Global Trade: Item Closed
286	ERROR_TEW_W	☐	WB2B_ERROR_TEW	WB2B_ERROR_TEW	CHAR	1	0	Global Trade: Error in Follow-On Document Creation
287	BUSINESS_STEP_W	☐	WB2_STEP	WB2_STEP	CHAR	4	0	Business Process Step	TEWSTEP
288	MASTER_STEP_W	☐	WB2_MASTER_STEP	WB2_STEP	CHAR	4	0	Main Step
289	PRE_STEP_W	☐	WB2_PRE_STEP	WB2_STEP	CHAR	4	0	Previous Step of Business Process

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WB2_V_VBRK_VBRP	ABFOR_I	T691K	ABSFO	REF	C	CN
2	WB2_V_VBRK_VBRP	ABRVW_I	TVLV	ABRVW	REF	C	CN
3	WB2_V_VBRK_VBRP	AKTNR_I	WAKH	AKTNR	REF	C	CN
4	WB2_V_VBRK_VBRP	AKWAE	TCURC	WAERS	REF	1	CN
5	WB2_V_VBRK_VBRP	ALAND_I	T005	LAND1	REF	1	CN
6	WB2_V_VBRK_VBRP	AUBEL_I	VBUK	VBELN	REF	C	CN
7	WB2_V_VBRK_VBRP	AUFNR_I	AUFK	AUFNR	REF	C	CN
8	WB2_V_VBRK_VBRP	AUGRU_AUFT_I	TVAU	AUGRU	REF	C	CN
9	WB2_V_VBRK_VBRP	AUPOS_I	VBUP	POSNR	REF	C	CN
10	WB2_V_VBRK_VBRP	BEMOT_I	TBMOT	BEMOT		C	CN
11	WB2_V_VBRK_VBRP	BONUS_I	TVBO	BONUS	REF	C	CN
12	WB2_V_VBRK_VBRP	BUKRS	T001	BUKRS	REF	1	CN
13	WB2_V_VBRK_VBRP	BUPLA	J_1BBRANCH	BRANCH		C	CN
14	WB2_V_VBRK_VBRP	BUSINESS_STEP_W	TEWSTEP	STEP	KEY	1	CN
15	WB2_V_VBRK_VBRP	BWTAR_I	T149D	BWTAR	REF	C	CN
16	WB2_V_VBRK_VBRP	BZIRK	T171	BZIRK	REF	C	CN
17	WB2_V_VBRK_VBRP	BZIRK_AUFT_I	T171	BZIRK	REF	C	CN
18	WB2_V_VBRK_VBRP	CHARG_I	MCHA	CHARG	REF	C	CN
19	WB2_V_VBRK_VBRP	CITYC	T005G	CITYC	REF	C	CN
20	WB2_V_VBRK_VBRP	CMWAE	TCURC	WAERS	REF	C	CN
21	WB2_V_VBRK_VBRP	COUNC	T005E	COUNC	REF	C	CN
22	WB2_V_VBRK_VBRP	EXNUM	EIKP	EXNUM	REF	C	CN
23	WB2_V_VBRK_VBRP	FKART	TVFK	FKART	REF	1	CN
24	WB2_V_VBRK_VBRP	FKART_RL	TVFK	FKART	REF	C	CN
25	WB2_V_VBRK_VBRP	FPLNR_I	FPLA	FPLNR	REF	C	CN
26	WB2_V_VBRK_VBRP	GEWEI_I	T006	MSEHI	REF	C	CN
27	WB2_V_VBRK_VBRP	GSBER_I	TGSB	GSBER	REF	C	CN
28	WB2_V_VBRK_VBRP	HITYP_PR	THIT	HITYP	REF	C	CN
29	WB2_V_VBRK_VBRP	INCO1	TINC	INCO1	REF	C	CN
30	WB2_V_VBRK_VBRP	J_1ADTYP_I	J_1ADTYP	J_1ADTYP	KEY	1	CN
31	WB2_V_VBRK_VBRP	J_1AFITP	J_1AFITP	J_1AFITP		1	CN
32	WB2_V_VBRK_VBRP	J_1AGICD_I	J_1AGICD	J_1AGICD	KEY	1	CN
33	WB2_V_VBRK_VBRP	J_1AINDXP_I	J_1AINFT20	J_1AINDX	KEY	1	CN
34	WB2_V_VBRK_VBRP	J_1AREGIO_I	T005S	BLAND	KEY	1	CN
35	WB2_V_VBRK_VBRP	J_1ARFZ_I	J_1ARFZ	J_1ARFZ	KEY	1	CN
36	WB2_V_VBRK_VBRP	J_1ATXREL_I	J_1ATXREL	J_1ATXREL	KEY	1	CN
37	WB2_V_VBRK_VBRP	J_1BCFOP_I	J_1BAG	CFOP	KEY	1	CN
38	WB2_V_VBRK_VBRP	J_1BTAXLW1_I	J_1BATL1	TAXLAW	KEY	1	CN
39	WB2_V_VBRK_VBRP	J_1BTAXLW2_I	J_1BATL2	TAXLAW	KEY	1	CN
40	WB2_V_VBRK_VBRP	J_1BTXSDC_I	J_1BTXSDC	TAXCODE	KEY	1	CN
41	WB2_V_VBRK_VBRP	KALSM	T683	KALSM	REF	1	CN
42	WB2_V_VBRK_VBRP	KDGRP	T151	KDGRP	REF	C	CN
43	WB2_V_VBRK_VBRP	KDGRP_AUFT_I	T151	KDGRP	REF	C	CN
44	WB2_V_VBRK_VBRP	KDKG1_I	TVKGG	KDKGR		C	CN
45	WB2_V_VBRK_VBRP	KDKG2_I	TVKGG	KDKGR		C	CN
46	WB2_V_VBRK_VBRP	KDKG3_I	TVKGG	KDKGR		C	CN
47	WB2_V_VBRK_VBRP	KDKG4_I	TVKGG	KDKGR		C	CN
48	WB2_V_VBRK_VBRP	KDKG5_I	TVKGG	KDKGR		C	CN
49	WB2_V_VBRK_VBRP	KKBER	T014	KKBER	REF	C	CN
50	WB2_V_VBRK_VBRP	KNKLI	KNA1	KUNNR	REF	C	CN
51	WB2_V_VBRK_VBRP	KNUMA	KONA	KNUMA	REF	C	CN
52	WB2_V_VBRK_VBRP	KNUMA_AG_I	KONA	KNUMA	REF	C	CN
53	WB2_V_VBRK_VBRP	KNUMA_PI_I	KONA	KNUMA	REF	C	CN
54	WB2_V_VBRK_VBRP	KOKRS_I	TKA01	KOKRS	REF	C	CN
55	WB2_V_VBRK_VBRP	KONDA	T188	KONDA	REF	C	CN
56	WB2_V_VBRK_VBRP	KONDA_AUFT_I	T188	KONDA	REF	C	CN
57	WB2_V_VBRK_VBRP	KONDM_I	T178	KONDM	REF	C	CN
58	WB2_V_VBRK_VBRP	KTGRD	TVKT	KTGRD	REF	C	CN
59	WB2_V_VBRK_VBRP	KTGRM_I	TVKM	KTGRM	REF	C	CN
60	WB2_V_VBRK_VBRP	KUNAG	KNA1	KUNNR	REF	1	CN
61	WB2_V_VBRK_VBRP	KUNRG	KNA1	KUNNR	REF	1	CN
62	WB2_V_VBRK_VBRP	KURST	TCURV	KURST	REF	C	CN
63	WB2_V_VBRK_VBRP	KVGR1_I	TVV1	KVGR1	REF	C	CN
64	WB2_V_VBRK_VBRP	KVGR2_I	TVV2	KVGR2	REF	C	CN
65	WB2_V_VBRK_VBRP	KVGR3_I	TVV3	KVGR3	REF	C	CN
66	WB2_V_VBRK_VBRP	KVGR4_I	TVV4	KVGR4	REF	C	CN
67	WB2_V_VBRK_VBRP	KVGR5_I	TVV5	KVGR5	REF	C	CN
68	WB2_V_VBRK_VBRP	LAND1	T005	LAND1	REF	C	CN
69	WB2_V_VBRK_VBRP	LCNUM	AKKP	LCNUM		C	CN
70	WB2_V_VBRK_VBRP	LGORT_I	T001L	LGORT	REF	C	CN
71	WB2_V_VBRK_VBRP	LLAND_AUFT_I	T005	LAND1	REF	C	CN
72	WB2_V_VBRK_VBRP	MABER	T047M	MABER	REF	C	CN
73	WB2_V_VBRK_VBRP	MANDT	T000	MANDT	KEY	1	CN
74	WB2_V_VBRK_VBRP	MANDT_I	T000	MANDT	KEY	1	CN
75	WB2_V_VBRK_VBRP	MANDT_W	T000	MANDT
76	WB2_V_VBRK_VBRP	MANSP	T040S	MANSP	REF	C	CN
77	WB2_V_VBRK_VBRP	MATKL_I	T023	MATKL	REF	C	CN
78	WB2_V_VBRK_VBRP	MATNR_I	MARA	MATNR	REF	C	CN
79	WB2_V_VBRK_VBRP	MATWA_I	MARA	MATNR	REF	C	CN
80	WB2_V_VBRK_VBRP	MEINS_I	T006	MSEHI	REF	C	CN
81	WB2_V_VBRK_VBRP	MSCHL	T040	MSCHL	REF	C	CN
82	WB2_V_VBRK_VBRP	MVGR1_I	TVM1	MVGR1	REF	C	CN
83	WB2_V_VBRK_VBRP	MVGR2_I	TVM2	MVGR2	REF	C	CN
84	WB2_V_VBRK_VBRP	MVGR3_I	TVM3	MVGR3	REF	C	CN
85	WB2_V_VBRK_VBRP	MVGR4_I	TVM4	MVGR4	REF	C	CN
86	WB2_V_VBRK_VBRP	MVGR5_I	TVM5	MVGR5	REF	C	CN
87	WB2_V_VBRK_VBRP	PLTYP	T189	PLTYP	REF	C	CN
88	WB2_V_VBRK_VBRP	PLTYP_AUFT_I	T189	PLTYP	REF	C	CN
89	WB2_V_VBRK_VBRP	PMATN_I	MARA	MATNR	REF	C	CN
90	WB2_V_VBRK_VBRP	POSNR_I	VBUP	POSNR	KEY	1	C
91	WB2_V_VBRK_VBRP	POSNV_I	VBUP	POSNR	REF	C	CN
92	WB2_V_VBRK_VBRP	POSPA_I	VBUP	POSNR	REF	C	CN
93	WB2_V_VBRK_VBRP	PRODH_I	T179	PRODH	REF	C	CN
94	WB2_V_VBRK_VBRP	PROVG_I	TVPR	PROVG	REF	C	CN
95	WB2_V_VBRK_VBRP	REGIO	T005S	BLAND	REF	C	CN
96	WB2_V_VBRK_VBRP	REGIO_AUFT_I	T005S	BLAND	REF	C	CN
97	WB2_V_VBRK_VBRP	RPLNR	FPLA	FPLNR	REF	C	C
98	WB2_V_VBRK_VBRP	RPLNR_I	FPLA	FPLNR	REF	C	N
99	WB2_V_VBRK_VBRP	SCENARIO_W	TEWSCENARIO	SCENARIO	REF	1	CN
100	WB2_V_VBRK_VBRP	SERNR_I	SNUM	SERNR	REF	C	CN
101	WB2_V_VBRK_VBRP	SFAKN	VBUK	VBELN	REF	C	CN
102	WB2_V_VBRK_VBRP	SPARA_I	TSPA	SPART	REF	C	CN
103	WB2_V_VBRK_VBRP	SPART	TSPA	SPART	REF	C	CN
104	WB2_V_VBRK_VBRP	SPART_I	TSPA	SPART	REF	C	CN
105	WB2_V_VBRK_VBRP	STWAE	TCURC	WAERS	REF	C	CN
106	WB2_V_VBRK_VBRP	TEW_TYPE_W	TEWTYPE	TEW_TYPE	REF	1	CN
107	WB2_V_VBRK_VBRP	TKONN_W	WBHK	TKONN
108	WB2_V_VBRK_VBRP	TPOSN_SUB_W	WBHI	TPOSN_SUB
109	WB2_V_VBRK_VBRP	TPOSN_W	WBHI	TPOSN
110	WB2_V_VBRK_VBRP	UEPOS_I	VBUP	POSNR	REF	C	CN
111	WB2_V_VBRK_VBRP	UKONM_I	T178	KONDM	REF	C	CN
112	WB2_V_VBRK_VBRP	UPMAT_I	MARA	MATNR	REF	C	CN
113	WB2_V_VBRK_VBRP	VBELN	VBUK	VBELN	KEY	1	C
114	WB2_V_VBRK_VBRP	VBELN_I	VBUK	VBELN	KEY	1	CN
115	WB2_V_VBRK_VBRP	VBELV_I	VBUK	VBELN	REF	C	CN
116	WB2_V_VBRK_VBRP	VBUND	T880	RCOMP	REF	C	CN
117	WB2_V_VBRK_VBRP	VGBEL_I	VBUK	VBELN	REF	1	CN
118	WB2_V_VBRK_VBRP	VGPOS_I	VBUP	POSNR	REF	1	CN
119	WB2_V_VBRK_VBRP	VKAUS_I	TVLV	ABRVW		C	CN
120	WB2_V_VBRK_VBRP	VKBUR_I	TVBUR	VKBUR	REF	C	CN
121	WB2_V_VBRK_VBRP	VKGRP_I	TVKGR	VKGRP	REF	C	CN
122	WB2_V_VBRK_VBRP	VKORG	TVKO	VKORG	REF	C	CN
123	WB2_V_VBRK_VBRP	VKORG_AUFT_I	TVKO	VKORG	REF	C	CN
124	WB2_V_VBRK_VBRP	VOLEH_I	T006	MSEHI	REF	C	CN
125	WB2_V_VBRK_VBRP	VRKME_I	T006	MSEHI	REF	C	CN
126	WB2_V_VBRK_VBRP	VSBED	TVSB	VSBED	REF	C	CN
127	WB2_V_VBRK_VBRP	VSTEL_I	TVST	VSTEL	REF	C	CN
128	WB2_V_VBRK_VBRP	VTWEG	TVTW	VTWEG	REF	C	CN
129	WB2_V_VBRK_VBRP	VTWEG_AUFT_I	TVTW	VTWEG	REF	C	CN
130	WB2_V_VBRK_VBRP	WAERK	TCURC	WAERS	REF	1	CN
131	WB2_V_VBRK_VBRP	WERKS_I	T001W	WERKS	REF	C	CN
132	WB2_V_VBRK_VBRP	WKREG_I	T005S	BLAND	REF	C	CN
133	WB2_V_VBRK_VBRP	WKTNR_I	VBUK	VBELN	REF	C	CN
134	WB2_V_VBRK_VBRP	WKTPS_I	VBUP	POSNR	REF	C	CN
135	WB2_V_VBRK_VBRP	WMINR_I	WWMI	WMINR	REF	1	CN
136	WB2_V_VBRK_VBRP	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in