SAP ABAP Table VBDPR (Document Item View for Billing)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

Table Category	INTTAB	Structure
Structure	VBDPR	Table Relationship Diagram
Short Description	Document Item View for Billing

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	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
2	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
3	POSPA	☐	POSPA	POSNR	NUMC	6	0	Item number in the partner segment	VBUP
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
6	IDNKD	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
7	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
8	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
9	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
10	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
11	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
12	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
13	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
14	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
15	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
16	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
17	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
18	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
19	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
20	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
21	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
22	KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
23	ANRED_WE	☐	ANRED	TEXT15	CHAR	15	0	Title
24	ADRNR_WE	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
25	ADRNP_WE	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
26	ADDRESS_TYPE_WE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
27	NAME1_WE	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
28	NAME2_WE	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
29	NAME3_WE	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
30	NAME4_WE	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
31	STRAS_WE	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
32	PFACH_WE	☐	PFACH	PFACH	CHAR	10	0	PO Box
33	PFORT_WE	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
34	PSTL2_WE	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
35	LAND1_WE	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
36	SPRAS_WE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
37	PSTLZ_WE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
38	ORT01_WE	☐	ORT01_GP	TEXT35	CHAR	35	0	City
39	ORT02_WE	☐	ORT02_GP	TEXT35	CHAR	35	0	District
40	REGIO_WE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
41	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
42	VBELN_VL	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
43	POSNR_VL	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
44	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
45	LFDAT	☐	LFDAT	DATUM	DATS	8	0	Delivery date
46	LEDAT	☐	LEDAT	DATUM	DATS	8	0	Delivery Creation Date
47	VBELN_VAUF	☐	VBELN_VAUF	VBELN	CHAR	10	0	Order	VBUK
48	POSNR_VAUF	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
49	VGTYP_VAUF	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
50	AUDAT	☐	AUDAT_VAUF	DATUM	DATS	8	0	Sales order date
51	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
52	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
53	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
54	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
55	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
56	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
57	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
58	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	*
59	VSART_BEZ	☐	VERSARTBEZ	TEXT20	CHAR	20	0	Description of the shipping type
60	SKFBP	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
61	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
62	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
63	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
64	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
65	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
66	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
67	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
68	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
69	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
70	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
71	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
72	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
73	VBELN_VAG	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
74	POSNR_VAG	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
75	AGDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
76	VBELN_VKT	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
77	POSNR_VKT	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
78	KTDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
79	VBELN_VG2	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
80	POSNR_VG2	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
81	G2DAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
82	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
83	SUGRD	☐	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution	*
84	SUDRU	☐	SUDRU	XFELD	CHAR	1	0	Original entry will be printed
85	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
86	FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
87	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	*
88	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	*
89	.INCLUDE	☐				0	0	Foreign Trade: Item Data for Billing View
90	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	*
91	EXPOS	☐	EXPOS	EXPOS	NUMC	6	0	Internal item number for foreign trade data in MM and SD
92	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	*
93	EXPRF	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	*
94	EXART	☐	EXART	EXART	CHAR	2	0	Business Transaction Type for Foreign Trade	*
95	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
96	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	*
97	GRWRT	☐	GRWRT	GRWRT	CURR	13	2	Statistical value for foreign trade
98	HERTI	☐	LANDX	TEXT15	CHAR	15	0	Country Name
99	HERTA	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	*
100	STXT1	☐	STXT1	CHAR40	CHAR	40	0	Description of commodity code - First line
101	STXT2	☐	STXT2	CHAR40	CHAR	40	0	Description of commodity code - Second line
102	STXT3	☐	STXT3	CHAR40	CHAR	40	0	Description of commodity code - Third line
103	STXT4	☐	STXT4	CHAR40	CHAR	40	0	Description of commodity code - Fourth line
104	STXT5	☐	STXT5	CHAR40	CHAR	40	0	Description of commodity code - Fifth line
105	STXT6	☐	STXT6	CHAR40	CHAR	40	0	Description of commodity code - Sixth line
106	STXT7	☐	STXT7	CHAR40	CHAR	40	0	Description of commodity code - Seventh line
107	BEMAS	☐	BEMEH	MEINS	UNIT	3	0	Supplementary unit	*
108	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
109	BOLNR	☐	BOLNR	CHAR35	CHAR	35	0	Bill of lading
110	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	*
111	TRAID	☐	TRAID	TRAID	CHAR	20	0	Means-of-transport ID
112	HERBL	☐	HERBL	HERBL	CHAR	2	0	State of manufacture
113	BMGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
114	MOWNR	☐	MOWNR	MOWNR	CHAR	12	0	CAP: Number of CAP products list	*
115	GPNUM	☐	GPNUM	GPNUM	CHAR	9	0	Production statistics: PRODCOM number for foreign trade	*
116	CASNR	☐	CASNR	CASNR	CHAR	15	0	CAS number for pharmaceutical products in foreign trade	*
117	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
118	WZOLL	☐	WZOLL	GRWRT	CURR	13	2	Customs val. in doc.currency in imp.procg for foreign trade
119	VERLD	☐	VERLD	LAND1	CHAR	3	0	Country of dispatch for Foreign Trade	*
120	HANLD	☐	HANLD	LAND1	CHAR	3	0	Trading country for foreign trade	*
121	TEXT1	☐	BEZEI40	TEXT40	CHAR	40	0	Description
122	TEXT2	☐	BEZEI40	TEXT40	CHAR	40	0	Description
123	TEXT3	☐	BEZEI40	TEXT40	CHAR	40	0	Description
124	COKON	☐	COKON	COKON	CHAR	6	0	Customs quota code for import processing in foreign trade	*
125	COPHA	☐	COPHA	COPHA	CHAR	6	0	Pharmaceutical products code (Foreign Trade)	*
126	COADI	☐	COADI	COADI	CHAR	6	0	Anti-dumping code for import processing in foreign trade	*
127	PRONU	☐	PRONU	PRONU	CHAR	25	0	Invoice: Number of invoice document for import processing
128	PRODA	☐	PRODA	DATUM	DATS	8	0	Invoice: Date of invoice document for import processing
129	VORPA	☐	VORPA	VORPA	CHAR	10	0	Preliminary document: Document type for foreign trade procg	*
130	VORNU	☐	VORNU	CHAR25	CHAR	25	0	Preliminary document: No. of preliminary doc.f.import procg
131	VORDA	☐	VORDA	DATUM	DATS	8	0	Preliminary document: Date of preliminary doc.f.import procg
132	BEHOE	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
133	KENNU	☐	KENNU	CHAR06	CHAR	6	0	Preliminary document: Customs office/ID number for import
134	VOISO	☐	VOISO	INTCA	CHAR	2	0	Prelim. doc.: ISO code of ctry issuing the preliminary doc.
135	PREFA	☐	PREFA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	*
136	PREFN	☐	PREFN	CHAR25	CHAR	25	0	Preference: Official number of preference document - Import
137	PREDU	☐	PREDU	DATUM	DATS	8	0	Preference: Date of preference document for import procg
138	PRISO	☐	PRISO	INTCA	CHAR	2	0	Preference: ISO code of country issuing the preference doc.
139	PRHOE	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
140	PRUEL	☐	PRUEL	DATUM	DATS	8	0	Preference: Validity date of preference document for import
141	NACAR	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
142	NACNU	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
143	NACDA	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
144	NAISO	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
145	NAHOE	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
146	NAUEL	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
147	NACA2	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
148	NACN2	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
149	NACD2	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
150	NAIS2	☐	PRISO	INTCA	CHAR	2	0	Preference: ISO code of country issuing the preference doc.
151	NAHO2	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
152	NAUE2	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
153	NACA3	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
154	NACN3	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
155	NACD3	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
156	NAIS3	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
157	NAHO3	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
158	NAUE3	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
159	NACA4	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
160	NACN4	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
161	NACD4	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
162	NAIS4	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
163	NAHO4	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
164	NAUE4	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
165	NACA5	☐	NACAR	NACAR	CHAR	10	0	Verification documents: Type of certificate for import	*
166	NACN5	☐	NACNU	CHAR25	CHAR	25	0	Verification docs: Official no. of verific. doc. - Import
167	NACD5	☐	NACDA	DATUM	DATS	8	0	Verification documents: Date of verif.doc. for import procg
168	NAIS5	☐	NAISO	INTCA	CHAR	2	0	Verification doc: ISO code of ctry supplying verific.doc.
169	NAHO5	☐	BEHOE	BEHOE	CHAR	10	0	Issuing authority for relevant Foreign Trade document	*
170	NAUE5	☐	NAUEL	DATUM	DATS	8	0	Verification docs: Validity date of verific.doc. for import
171	EXDAR	☐	EXDAR	VORPA	CHAR	10	0	Export document: Export document type for foreign trade	*
172	EXDAA	☐	EXDAA	CHAR25	CHAR	25	0	Export document: Official number of export document
173	EXDAB	☐	EXDAB	CHAR25	CHAR	25	0	Export document: Valid-to number of export document
174	EXDTA	☐	EXDTA	VORPA	CHAR	10	0	T document: Type of T document for foreign trade	*
175	EXDT2	☐	EXDT2	CHAR25	CHAR	25	0	T document: Official number of T document for foreign trade
176	EXDTB	☐	EXDTB	CHAR25	CHAR	25	0	T doc.: Official no. for next page of T doc. f.foreign trade
177	EXDPA	☐	EXDPA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	*
178	EXPRE	☐	EXPRE	CHAR25	CHAR	25	0	Preference: Official number of preference document - Export
179	EXDT5	☐	EXDT5	CHAR25	CHAR	25	0	CAP: Official number of T5 document for foreign trade
180	COIMP	☐	COIMP	STAWN	CHAR	17	0	Code number for import processing in foreign trade	*
181	GBNUM	☐	GB_NR	CHAR20	CHAR	20	0	Foreign Trade:Customs declaration list no. for Foreign Trade
182	REGNR	☐	RG_NR	CHAR20	CHAR	20	0	Registration number for import processing in foreign trade
183	PRENC	☐	PRENC	PRENC	CHAR	1	0	Exemption certificate: Indicator for legal control
184	PRENO	☐	PRENN	PRENN	CHAR	8	0	Exemption certificate number for legal control
185	PREND	☐	PREND	PREND	DATS	8	0	Exemption certificate: Issue date of exemption certificate
186	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	*
187	IMPMA	☐	IMPMA	MEINS	UNIT	3	0	Second unit of measurement	*
188	IMGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
189	.INCLUDE	☐				0	0	Doc.Item View Billing Document: Customer Modification
190	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
191	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
192	UECHA	☐	UECHA	POSNR	NUMC	6	0	Higher-Level Item of Batch Split Item	*
193	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
194	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
195	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
196	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
197	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
198	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
199	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
200	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
201	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
202	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
203	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
204	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
205	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
206	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
207	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	*
208	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
209	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
210	BSARK_E	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	*
211	IHREZ_E	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
212	POSEX_E	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
213	VBKLT	☐	VBKLT	VBKLT	CHAR	1	0	SD document indicator
214	SHKZG	☐	SHKZG_VF	SHKZG_VF	CHAR	1	0	Returns item
215	AUTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
216	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
217	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
218	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
219	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
220	VKAUS	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	*
221	.INCLUDE	☐				0	0	Document Item View Billing Document: Country-Specific Fields
222	STEUCL	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
223	J_1ARFZ	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT	*
224	KBETRL	☐	KBETR_KOND	WERTV6	CURR	11	2	Rate (condition amount or percentage) where no scale exists
225	MATNR_VG2	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
226	FKIMG_VG2	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
227	VRKME_VG2	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
228	NETWR_VG2	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
229	MWSBP_VG2	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
230	BRTWR_VG2	☐	BRTWR_FP	WERTV8	CURR	15	2	Gross value of the billing item in document currency
231	NETPR_VG2	☐	NETPR	WERTV6	CURR	11	2	Net price
232	MWSPR_VG2	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
233	J_1ARFZ_VG2	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT	*
234	XBLNR_VL	☐	XBLNR_LIKP	XBLNR_LIKP	CHAR	25	0	Reference Document Number
235	LIFNR_CONSIGNOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
236	NETPRL	☐	NETPR	WERTV6	CURR	11	2	Net price
237	MWSKL	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
238	BRTWR	☐	BRTWR_FP	WERTV8	CURR	15	2	Gross value of the billing item in document currency
239	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
240	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
241	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
242	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
243	PRCTR_IV	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
244	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
245	.INCLUDE	☐				0	0	Multistep Returns - Item Data for Printing
246	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
247	MSR_ITEM	☐	MSR_PROCESS_ITEM	MSR_PROCESS_ITEM	NUMC	6	0	Item Number
248	RMA_CUSTOMER	☐	MSR_CRMA_NR	MSR_RMA_NR	CHAR	20	0	Customer RMA Number
249	MSR_RET_REASON	☐	MSR_RETURNS_REASON	MSR_RETURNS_REASON	CHAR	3	0	Return Reason	*
250	MSR_RET_REASON_TEXT	☐	MSR_RET_REASON_TEXT	TEXT60	CHAR	60	0	Return Reason Description
251	MSR_MAT_RECEIVED	☐	MSR_MATERIAL_RECEIVED	XFELD	CHAR	1	0	Material Received
252	MSR_FU_CODE	☐	MSR_FU_CODE	MSR_FU_CODE	CHAR	4	0	Follow-Up Activity Code	*
253	MSR_FU_CODE_TEXT	☐	MSR_FU_CODE_TEXT	TEXT60	CHAR	60	0	Follow-Up Activity Description
254	MSR_FORW_VENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
255	MSR_FWV_TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
256	MSR_FWV_ADDRNUM	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
257	MSR_FWV_NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
258	MSR_FWV_NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
259	MSR_FWV_NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
260	MSR_FWV_NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
261	MSR_FWV_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
262	MSR_FWV_PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
263	MSR_FWV_PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
264	MSR_FWV_CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	*
265	MSR_FWV_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
266	MSR_FWV_LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
267	MSR_FWV_POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
268	MSR_FWV_CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
269	MSR_FWV_CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
270	MSR_FWV_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
271	RMA_VENDOR	☐	MSR_VRMA_NR	MSR_RMA_NR	CHAR	20	0	Vendor RMA Number
272	MSR_INSP_CODE	☐	MSR_INSPECTION_CODE	QCODE	CHAR	4	0	Inspection Code	*
273	MSR_INSP_CODE_TX	☐	MSR_INSPECTION_COMMENT	MSR_INSPECTION_COMMENT	CHAR	40	0	Inspection Comment
274	MSR_REFUND_CODE	☐	MSR_RETURNS_REFUND_CODE	MSR_RETURNS_REFUND_CODE	CHAR	3	0	Returns Refund Code
275	MSR_REFUND_CODE_TEXT	☐	MSR_REFUND_CODE_TEXT	TEXT60	CHAR	60	0	Refund Code Description
276	MSR_FORW_PLANT1	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
277	MSR_PLANT1_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
278	MSR_FORW_PLANT2	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
279	MSR_PLANT2_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
280	MSR_FORW_PLANT3	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
281	MSR_PLANT3_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
282	MSR_SPLIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
283	VBELN_VF_REVERSED	☐	VBELN_VF_REVERSED	VBELN	CHAR	10	0	Reversed Billing Document	*
284	POSNR_VF_REVERSED	☐	POSNR_VF_REVERSED	POSNR	NUMC	6	0	Reversed Billing Item	*
285	POSNR_VF_PARTNER	☐	POSNR_VF_PARTNER	POSNR	NUMC	6	0	Partner Billing Item	*
286	.INCLU--AP	☐				0	0	Append for VBDPR - Billing Document: Customer Modification
287	/BEV1/EMMVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
288	/BEV1/EMMVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
289	/BEV1/EMMVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
290	/BEV1/EMMVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
291	/BEV1/EMMVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
292	/BEV1/EMNEUPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
293	/BEV1/EMPRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBDPR	GEWEI	T006	MSEHI
2	VBDPR	KMEIN	T006	MSEHI
3	VBDPR	KUNWE	KNA1	KUNNR
4	VBDPR	LAND1_WE	T005	LAND1
5	VBDPR	MATNR	MARA	MATNR
6	VBDPR	MATWA	MARA	MATNR
7	VBDPR	POSNR	VBUP	POSNR
8	VBDPR	POSNR_VAUF	VBUP	POSNR
9	VBDPR	POSPA	VBUP	POSNR
10	VBDPR	REGIO_WE	T005S	BLAND
11	VBDPR	VBELN_VAUF	VBUK	VBELN
12	VBDPR	VBELN_VL	VBUK	VBELN
13	VBDPR	VGBEL	VBUK	VBELN
14	VBDPR	VGPOS	VBUP	POSNR
15	VBDPR	VOLEH	T006	MSEHI
16	VBDPR	VRKME	T006	MSEHI
17	VBDPR	WAERK	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in