SAP ABAP Table VBDPA (Document Item View for Inquiries,Quotation,Order)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS-GF (Application Component) Basic Functions
     ⤷ VAD (Package) Application development R/3 printing, SAPscript sales
Basic Data
Table Category INTTAB    Structure 
Structure VBDPA   Table Relationship Diagram
Short Description Document Item View for Inquiries,Quotation,Order    
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 GRPOS GRPOS GRPOS NUMC 6   0   Item for which this item is an alternative  
3 UEPOS UEPOS POSNR NUMC 6   0   Higher-level item in bill of material structures *
4 GRKOR GRKOR GRKOR NUMC 3   0   Delivery group (items are delivered together)  
5 POSEX POSEX POSEX CHAR 6   0   Item Number of the Underlying Purchase Order  
6 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
7 MATWA MATWA MATNR CHAR 18   0   Material entered *
8 PMATN PMATN MATNR CHAR 18   0   Pricing Reference Material *
9 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
10 IDNKD MATNR_KU IDNEX CHAR 35   0   Customer Material Number  
11 ARKTX ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
12 CHARG CHARG_D CHARG CHAR 10   0   Batch Number *
13 MATKL MATKL MATKL CHAR 9   0   Material Group *
14 MATKL_BEZ WGBEZ TEXT20 CHAR 20   0   Material Group Description  
15 PRODH PRODH_D PRODH CHAR 18   0   Product Hierarchy *
16 PRODH_BEZ PRODH_BEZ TEXT20 CHAR 20   0   Description of product hierarchy  
17 SPART SPART SPART CHAR 2   0   Division *
18 SPART_BEZ SPART_BEZ TEXT20 CHAR 20   0   Description of division  
19 WERKS WERKS_D WERKS CHAR 4   0   Plant *
20 LGORT LGORT_D LGORT CHAR 4   0   Storage location *
21 LGOBE LGOBE TEXT16 CHAR 16   0   Description of Storage Location  
22 VSTEL VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point *
23 VSTEL_BEZ VSTEL_BEZ TEXT30 CHAR 30   0   Description of shipping point  
24 ROUTE ROUTE ROUTE CHAR 6   0   Route *
25 ROUTE_BEZ ROUTE_BEZ TEXT40 CHAR 40   0   Route description  
26 GSBER GSBER GSBER CHAR 4   0   Business Area *
27 PSTYV PSTYV PSTYV CHAR 4   0   Sales document item category *
28 PSTYV_BEZ PSTYV_BEZ TEXT20 CHAR 20   0   Description of item category  
29 POSAR POSAR POSAR CHAR 1   0   Item type  
30 HERKL CHAR03 CHAR3 CHAR 3   0   Three-digit character field for IDocs  
31 BRGEW BRGEW_AP MENG15 QUAN 15   3   Gross weight of item  
32 NTGEW NTGEW_AP MENG15 QUAN 15   3   Net weight of item  
33 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
34 VOLUM VOLUM_AP MENG15 QUAN 15   3   Volume of the item  
35 VOLEH VOLEH MEINS UNIT 3   0   Volume unit T006
36 NETWR NETWR_AP WERTV8 CURR 15   2   Net value of the order item in document currency  
37 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
38 NETPR NETPR WERTV6 CURR 11   2   Net price  
39 KPEIN KPEIN KPEIN DEC 5   0   Condition pricing unit  
40 KMEIN KMEIN MEINS UNIT 3   0   Condition Unit T006
41 LFDAT LFDAT_EXT CHAR10 CHAR 10   0   Delivery date  
42 LSMENG LSMENG MENG15 QUAN 15   3   Cumulative Target Delivery Qty (all dlv-relev.sched.lines)  
43 KWMENG KWMENG MENG15 QUAN 15   3   Cumulative order quantity in sales units  
44 KBMENG KBMENG MENG15 QUAN 15   3   Cumulative confirmed quantity in sales unit  
45 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
46 FMENG FMENG XFELD CHAR 1   0   Quantity is fixed  
47 ZMENG DZMENG MENG13 QUAN 13   3   Target quantity in sales units  
48 ZIEME DZIEME MEINS UNIT 3   0   Target quantity UoM *
49 ZWERT DZWERT WERT7 CURR 13   2   Target value for outline agreement in document currency  
50 UMZIZ UMZIZ UMBSZ DEC 5   0   Factor for converting sales units to base units (target qty)  
51 UMZIN UMZIN UMBSN DEC 5   0   Factor for converting sales units to base units (target qty)  
52 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
53 SMENG SMENG MENG13 QUAN 13   3   Scale quantity in base unit of measure  
54 UEBTK UEBTK_V XFELD CHAR 1   0   Unlimited overdelivery allowed  
55 UEBTO UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
56 UNTTO UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
57 VBELN_VANG VBELN_VON VBELN CHAR 10   0   Preceding sales and distribution document VBUK
58 VBTYP_VANG VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
59 AUDAT_VANG AUDAT_VANG DATUM DATS 8   0   Quotation Date  
60 KUNWE KUNWE KUNNR CHAR 10   0   Ship-to party KNA1
61 ANRED_WE ANRED TEXT15 CHAR 15   0   Title  
62 ADRNR_WE AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
63 ADRNP_WE AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
64 ADDRESS_TYPE_WE AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
65 NAME1_WE NAME1_GP NAME CHAR 35   0   Name 1  
66 NAME2_WE NAME2_GP NAME CHAR 35   0   Name 2  
67 NAME3_WE NAME3_GP NAME CHAR 35   0   Name 3  
68 NAME4_WE NAME4_GP NAME CHAR 35   0   Name 4  
69 STRAS_WE STRAS_GP TEXT35 CHAR 35   0   House number and street  
70 PFACH_WE PFACH PFACH CHAR 10   0   PO Box  
71 PFORT_WE PFORT_GP TEXT35 CHAR 35   0   PO Box city  
72 PSTL2_WE PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
73 LAND1_WE LAND1 LAND1 CHAR 3   0   Country Key T005
74 SPRAS_WE SPRAS SPRAS LANG 1   0   Language Key *
75 PSTLZ_WE PSTLZ PSTLZ CHAR 10   0   Postal Code  
76 ORT01_WE ORT01_GP TEXT35 CHAR 35   0   City  
77 ORT02_WE ORT02_GP TEXT35 CHAR 35   0   District  
78 REGIO_WE REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
79 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
80 KURSK_DAT WWERT_D DATUM DATS 8   0   Translation date  
81 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
82 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
83 INCO1_BEZ INCO1_BEZ TEXT30 CHAR 30   0   Incoterm description  
84 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
85 ZTERM_BEZ DZTERM_BEZ TEXT30 CHAR 30   0   Description of terms of payment  
86 ZTERM_TX1 TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
87 ZTERM_TX2 TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
88 ZTERM_TX3 TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
89 ZTERM_TX4 TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
90 ABGRU ABGRU ABGRU CHAR 2   0   Reason for rejection of quotations and sales orders  
91 ABGRU_BEZ ABGRU_BEZ TEXT40 CHAR 40   0   Description of reason for rejection  
92 TDNAME TDOBNAME TDOBNAME CHAR 70   0   Name  
93 ATPKZ ATPKZ ATPKZ CHAR 1   0   Replacement part  
94 FAKSP FAKSP FAKSP CHAR 2   0   Lock *
95 LFREL LFREL XFELD CHAR 1   0   Item is Relevant for Delivery  
96 FKREL FKREL FKREL CHAR 1   0   Relevant for Billing  
97 ANTLF ANTLF ANTLF DEC 1   0   Maximum number of partial deliveries allowed per item  
98 KZTLF KZTLF KZTLF CHAR 1   0   Partial delivery at item level  
99 SKTOF SKTOF XFELD CHAR 1   0   Cash discount indicator  
100 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
101 CHSPL CHSPL XFELD CHAR 1   0   Batch split allowed  
102 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type *
103 BONUS BONUS BONUS CHAR 2   0   Volume rebate group *
104 PROVG PROVG PROVG CHAR 2   0   Commission group *
105 KTGRM KTGRM KTGRM CHAR 2   0   Account assignment group for this material *
106 KONDM KONDM KONDM CHAR 2   0   Material Pricing Group *
107 KDGRP KDGRP KDGRP CHAR 2   0   Customer group *
108 KDGRP_BEZ KDGRP_BEZ TEXT20 CHAR 20   0   Description of customer group  
109 BZIRK BZIRK BZIRK CHAR 6   0   Sales district *
110 BZIRK_BEZ BZTXT TEXT20 CHAR 20   0   Name of the district  
111 VALTG VALTG TAGE2 NUMC 2   0   Additional value days  
112 VALDT VALDT DATUM DATS 8   0   Fixed value date  
113 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
114 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
115 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
116 BMENG BMENG MENG13 QUAN 13   3   Confirmed quantity  
117 EDATU EDATU DATUM DATS 8   0   Schedule line date  
118 EZEIT EZEIT_VBEP UZEIT TIMS 6   0   Arrival time  
119 DATBEZ DATBEZ TEXT8 CHAR 8   0   Description of the date format (day, week, month)  
120 PRGRS PRGRS PRGRS CHAR 1   0   Date type (day, week, month, interval)  
121 POSNR_NEU POSNR_NEU XFELD CHAR 1   0   New item  
122 ETENR_DA ETENR_DA XFELD CHAR 1   0   There is more than one confirmed schedule line  
123 CUOBJ CUOBJ_VA CUOBJ NUMC 18   0   Configuration  
124 CUOBJ_CH CUOBJ_CH CUOBJ NUMC 18   0   Internal object number of the batch classification  
125 VSMNG VSMNG MENG13 QUAN 13   3   Delivered quantity in sales units  
126 ANZSN ANZSN INT4 INT4 10   0   Number of serial numbers  
127 FPLNR FPLNR FPLNR CHAR 10   0   Billing plan number / invoicing plan number *
128 DELCO DELCO DELCO CHAR 3   0   Agreed delivery time  
129 DELCO_BEZ BEZEI20 TEXT20 CHAR 20   0   Description  
130 BSTKD BSTKD BSTKD CHAR 35   0   Customer purchase order number  
131 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
132 BSARK BSARK BSARK CHAR 4   0   Customer Order Type *
133 BSARK_BEZ BSARK_BEZ TEXT20 CHAR 20   0   Description of purchase order type  
134 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
135 BSTKD_E BSTKD_E BSTKD CHAR 35   0   Ship-to Party's Purchase Order Number  
136 BSTDK_E BSTDK_E DATUM DATS 8   0   Ship-to party's PO date  
137 BSARK_E BSARK_E BSARK CHAR 4   0   Ship-to party purchase order type *
138 BSARK_BEZE BSARK_BEZ TEXT20 CHAR 20   0   Description of purchase order type  
139 IHREZ_E IHREZ_E TEXT12 CHAR 12   0   Ship-to party character  
140 POSEX_E POSEX_E POSEX CHAR 6   0   Item Number of the Underlying Purchase Order  
141 VGBEL VGBEL VBELN CHAR 10   0   Document number of the reference document *
142 VGPOS VGPOS POSNR NUMC 6   0   Item number of the reference item *
143 UEPVW UEPVW UEPVW CHAR 1   0   ID for higher-level item usage  
144 DRAGR DRAGR CHAR1 CHAR 1   0   Not relevant for printing  
145 PREFE PREFE PREFE CHAR 1   0   Preference indicator in export/import  
146 ATTYP ATTYP ATTYP CHAR 2   0   Material Category  
147 .INCLUDE       0   0   Multistep Returns - Item Data for Printing  
148 MSR_ID MSR_PROCESS_ID MSR_PROCESS_ID CHAR 10   0   Process Identification Number  
149 MSR_ITEM MSR_PROCESS_ITEM MSR_PROCESS_ITEM NUMC 6   0   Item Number  
150 RMA_CUSTOMER MSR_CRMA_NR MSR_RMA_NR CHAR 20   0   Customer RMA Number  
151 MSR_RET_REASON MSR_RETURNS_REASON MSR_RETURNS_REASON CHAR 3   0   Return Reason *
152 MSR_RET_REASON_TEXT MSR_RET_REASON_TEXT TEXT60 CHAR 60   0   Return Reason Description  
153 MSR_MAT_RECEIVED MSR_MATERIAL_RECEIVED XFELD CHAR 1   0   Material Received  
154 MSR_FU_CODE MSR_FU_CODE MSR_FU_CODE CHAR 4   0   Follow-Up Activity Code *
155 MSR_FU_CODE_TEXT MSR_FU_CODE_TEXT TEXT60 CHAR 60   0   Follow-Up Activity Description  
156 MSR_FORW_VENDOR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
157 MSR_FWV_TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
158 MSR_FWV_ADDRNUM AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
159 MSR_FWV_NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
160 MSR_FWV_NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
161 MSR_FWV_NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
162 MSR_FWV_NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
163 MSR_FWV_STREET AD_STREET TEXT60 CHAR 60   0   Street  
164 MSR_FWV_PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
165 MSR_FWV_PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
166 MSR_FWV_CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
167 MSR_FWV_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
168 MSR_FWV_LANGU SPRAS SPRAS LANG 1   0   Language Key *
169 MSR_FWV_POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
170 MSR_FWV_CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
171 MSR_FWV_CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
172 MSR_FWV_REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
173 MSR_DDA_TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
174 MSR_DDA_ADDRNUM AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
175 MSR_DDA_NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
176 MSR_DDA_NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
177 MSR_DDA_NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
178 MSR_DDA_NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
179 MSR_DDA_STREET AD_STREET TEXT60 CHAR 60   0   Street  
180 MSR_DDA_PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
181 MSR_DDA_PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
182 MSR_DDA_CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
183 MSR_DDA_COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
184 MSR_DDA_LANGU SPRAS SPRAS LANG 1   0   Language Key *
185 MSR_DDA_POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
186 MSR_DDA_CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
187 MSR_DDA_CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
188 MSR_DDA_REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
189 RMA_VENDOR MSR_VRMA_NR MSR_RMA_NR CHAR 20   0   Vendor RMA Number  
190 MSR_INSP_CODE MSR_INSPECTION_CODE QCODE CHAR 4   0   Inspection Code *
191 MSR_INSP_CODE_TX MSR_INSPECTION_COMMENT MSR_INSPECTION_COMMENT CHAR 40   0   Inspection Comment  
192 INSPECTION_CODE_FTEXT1 TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
193 INSPECTION_CODE_FTEXT2 TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
194 INSPECTION_CODE_FTEXT3 TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
195 INSPECTION_CODE_FTEXT4 TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
196 AT_CUSTOMER_SITE MSR_AT_CUSTOMER_SITE XFELD CHAR 1   0   Inspection at Customer Site  
197 MSR_REFUND_CODE MSR_RETURNS_REFUND_CODE MSR_RETURNS_REFUND_CODE CHAR 3   0   Returns Refund Code  
198 MSR_REFUND_CODE_TEXT MSR_REFUND_CODE_TEXT TEXT60 CHAR 60   0   Refund Code Description  
199 MSR_FORW_PLANT1 WERKS_D WERKS CHAR 4   0   Plant *
200 MSR_PLANT1_TXT NAME1 TEXT30 CHAR 30   0   Name  
201 MSR_FORW_PLANT2 WERKS_D WERKS CHAR 4   0   Plant *
202 MSR_PLANT2_TXT NAME1 TEXT30 CHAR 30   0   Name  
203 MSR_FORW_PLANT3 WERKS_D WERKS CHAR 4   0   Plant *
204 MSR_PLANT3_TXT NAME1 TEXT30 CHAR 30   0   Name  
205 .INCLUDE       0   0   Doc.Item View Inquiry, Quotation, Sales Order: Cust.Modific.  
206 DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
207 .INCLU--AP       0   0   Append for VBDPA - Inquiry, Quotation, Order: Customer Mod.  
208 /BEV1/EMMVGR1 MVGR1 MVGR1 CHAR 3   0   Material group 1 *
209 /BEV1/EMMVGR2 MVGR2 MVGR2 CHAR 3   0   Material group 2 *
210 /BEV1/EMMVGR3 MVGR3 MVGR3 CHAR 3   0   Material group 3 *
211 /BEV1/EMMVGR4 MVGR4 MVGR4 CHAR 3   0   Material group 4 *
212 /BEV1/EMMVGR5 MVGR5 MVGR5 CHAR 3   0   Material group 5 *
213 /BEV1/EMNEUPOS POSNR POSNR NUMC 6   0   Item number of the SD document *
214 .INCLU--AP       0   0   Append of reload  
215 ACTIVITY_TYPE /DSD/SV_RELOAD_ACTIVITY_TYPE CHAR2 CHAR 2   0   Reload Activity Type  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VBDPA GEWEI T006 MSEHI    
2 VBDPA INCO1 TINC INCO1    
3 VBDPA KMEIN T006 MSEHI    
4 VBDPA KUNWE KNA1 KUNNR    
5 VBDPA LAND1_WE T005 LAND1    
6 VBDPA MATNR MARA MATNR    
7 VBDPA POSNR VBUP POSNR    
8 VBDPA REGIO_WE T005S BLAND    
9 VBDPA VBELN_VANG VBUK VBELN    
10 VBDPA VOLEH T006 MSEHI    
11 VBDPA VRKME T006 MSEHI    
12 VBDPA WAERK TCURC WAERS    
History
Last changed by/on SAP  20140121 
SAP Release Created in