VBAP is a standard Sales Transparent Table in SAP SD application, which stores Sales Document: Item Data data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for VBAP. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
VBAP — Meta Data
Description: | Sales Document: Item Data |
Main Category: | SD |
Sub Category: | Sales |
Table type: | Transparent Table (TRANSP) |
VBAP — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | T000 |
2 | VBELN | Sales Document | X | CHAR | 10 | VBAK |
3 | POSNR | Item | X | NUMC | 6 | |
4 | MATNR | Material | CHAR | 40 | MARA | |
5 | MATWA | MaterialEntered | CHAR | 40 | MARA | |
6 | PMATN | Pricing Reference Material | CHAR | 40 | MARA | |
7 | CHARG | Batch | CHAR | 10 | MCHA | |
8 | MATKL | Material Group | CHAR | 9 | T023 | |
9 | ARKTX | Description | CHAR | 40 | ||
10 | PSTYV | Item category | CHAR | 4 | TVPT | |
11 | POSAR | Item type | CHAR | 1 | ||
12 | LFREL | Item is relevant for delivery | CHAR | 1 | ||
13 | FKREL | Relevant for Billing | CHAR | 1 | ||
14 | UEPOS | Higher-level item in bill of material structures | NUMC | 6 | ||
15 | GRPOS | Item for which this item is an alternative | NUMC | 6 | ||
16 | ABGRU | RejectionReason | CHAR | 2 | TVAG | |
17 | PRODH | Prod.hierarchy | CHAR | 18 | T179 | |
18 | ZWERT | Target Value | CURR | 13 | ||
19 | ZMENG | Target quantity | QUAN | 13 | ||
20 | ZIEME | Target qty UoM | UNIT | 3 | T006 | |
21 | UMZIZ | Convers.factor | DEC | 5 | ||
22 | UMZIN | Convers.factor | DEC | 5 | ||
23 | MEINS | Base Unit | UNIT | 3 | T006 | |
24 | SMENG | Scale quantity | QUAN | 13 | ||
25 | ABLFZ | Rounding quantity for delivery | QUAN | 13 | ||
26 | ABDAT | Reconciliation Date for Agreed Cumulative Quantity | DATS | 8 | ||
27 | ABSFZ | Allowed deviation in quantity (absolute) | QUAN | 13 | ||
28 | POSEX | External item number | CHAR | 6 | ||
29 | KDMAT | Material belonging to the customer | CHAR | 35 | ||
30 | KBVER | Allowed deviation in quantity (in percent) | DEC | 3 | ||
31 | KEVER | Days by which the quantity can be shifted | DEC | 3 | ||
32 | VKGRU | Repair Processing: Classification of Items | CHAR | 3 | TVRMAVK | |
33 | VKAUS | Usage Indicator | CHAR | 3 | TVLV | |
34 | GRKOR | Delivery group (items are delivered together) | NUMC | 3 | ||
35 | FMENG | Quantity is Fixed | CHAR | 1 | ||
36 | UEBTK | Unlimited tol. | CHAR | 1 | ||
37 | UEBTO | Overdeliv. Tol. | DEC | 3 | ||
38 | UNTTO | Underdel. Tol. | DEC | 3 | ||
39 | FAKSP | Billing block | CHAR | 2 | TVFS | |
40 | ATPKZ | Replacement part | CHAR | 1 | ||
41 | RKFKF | Method of billing for CO/PPC orders | CHAR | 1 | ||
42 | SPART | Division | CHAR | 2 | TSPA | |
43 | GSBER | Business Area | CHAR | 4 | TGSB | |
44 | NETWR | Net value | CURR | 15 | ||
45 | WAERK | Doc. Currency | CUKY | 5 | TCURC | |
46 | ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | DEC | 1 | ||
47 | KZTLF | Partial delivery at item level | CHAR | 1 | ||
48 | CHSPL | Batch split allowed | CHAR | 1 | ||
49 | KWMENG | Order quantity | QUAN | 15 | ||
50 | LSMENG | Required DlvQty | QUAN | 15 | ||
51 | KBMENG | CumConfirmedQty | QUAN | 15 | ||
52 | KLMENG | CumConfirmedQty | QUAN | 15 | ||
53 | VRKME | Sales unit | UNIT | 3 | T006 | |
54 | UMVKZ | Numerator | DEC | 5 | ||
55 | UMVKN | Denominat. | DEC | 5 | ||
56 | BRGEW | Gross Weight | QUAN | 15 | ||
57 | NTGEW | Net Weight | QUAN | 15 | ||
58 | GEWEI | Weight unit | UNIT | 3 | T006 | |
59 | VOLUM | Volume | QUAN | 15 | ||
60 | VOLEH | Volume unit | UNIT | 3 | T006 | |
61 | VBELV | Originating document | CHAR | 10 | ||
62 | POSNV | Originating item | NUMC | 6 | ||
63 | VGBEL | Reference doc. | CHAR | 10 | ||
64 | VGPOS | Reference item | NUMC | 6 | ||
65 | VOREF | Complete reference indicator | CHAR | 1 | ||
66 | UPFLU | Update indicator for delivery document flow | CHAR | 1 | ||
67 | ERLRE | Completion rule for quotation / contract | CHAR | 1 | ||
68 | LPRIO | Delivery Prior. | NUMC | 2 | TPRIO | |
69 | WERKS | Plant | CHAR | 4 | ||
70 | LGORT | Stor. Location | CHAR | 4 | T001L | |
71 | VSTEL | Shipping Point | CHAR | 4 | TVST | |
72 | ROUTE | Route | CHAR | 6 | TVRO | |
73 | STKEY | Origin of the bill of material | CHAR | 1 | ||
74 | STDAT | Key date of the bill of material | DATS | 8 | ||
75 | STLNR | Bill of material | CHAR | 8 | ||
76 | STPOS | Bill of material item number VBAP not used | DEC | 5 | ||
77 | AWAHR | Probability | NUMC | 3 | ||
78 | ERDAT | Created on | DATS | 8 | ||
79 | ERNAM | Created by | CHAR | 12 | ||
80 | ERZET | Time | TIMS | 6 | ||
81 | TAXM1 | Tax classification material | CHAR | 1 | ||
82 | TAXM2 | Tax classification material | CHAR | 1 | ||
83 | TAXM3 | Tax classification material | CHAR | 1 | ||
84 | TAXM4 | Tax classification material | CHAR | 1 | ||
85 | TAXM5 | Tax classification material | CHAR | 1 | ||
86 | TAXM6 | Tax classification material | CHAR | 1 | ||
87 | TAXM7 | Tax classification material | CHAR | 1 | ||
88 | TAXM8 | Tax classification material | CHAR | 1 | ||
89 | TAXM9 | Tax classification material | CHAR | 1 | ||
90 | VBEAF | Fixed proc.time | DEC | 5 | ||
91 | VBEAV | Var. proc. time | DEC | 5 | ||
92 | VGREF | Preceding document has resulted from reference | CHAR | 1 | ||
93 | NETPR | Net price | CURR | 11 | ||
94 | KPEIN | Pricing unit | DEC | 5 | ||
95 | KMEIN | Unit of measure | UNIT | 3 | T006 | |
96 | SHKZG | Debit/Credit | CHAR | 1 | ||
97 | SKTOF | Cash discount indicator | CHAR | 1 | ||
98 | MTVFP | Checking Group for Availability Check | CHAR | 2 | TMVF | |
99 | SUMBD | Summing up of requirements | CHAR | 1 | ||
100 | KONDM | Material Pricing Group | CHAR | 2 | T178 | |
101 | KTGRM | Account assignment group for this material | CHAR | 2 | TVKM | |
102 | BONUS | Vol. rebate grp | CHAR | 2 | TVBO | |
103 | PROVG | Commission grp | CHAR | 2 | TVPR | |
104 | EANNR | European Article Number (EAN) - obsolete!!!!! | CHAR | 13 | ||
105 | PRSOK | Pricing is OK | CHAR | 1 | ||
106 | BWTAR | Valuation Type | CHAR | 10 | T149D | |
107 | BWTEX | Indicator: Separate valuation | CHAR | 1 | ||
108 | XCHPF | Batch management requirement indicator | CHAR | 1 | ||
109 | XCHAR | Batch management indicator (internal) | CHAR | 1 | ||
110 | LFMNG | Min. dely qty | QUAN | 13 | ||
111 | STAFO | Update group for statistics update | CHAR | 6 | ||
112 | WAVWR | Cost | CURR | 13 | ||
113 | KZWI1 | Subtotal 1 | CURR | 13 | ||
114 | KZWI2 | Subtotal 2 | CURR | 13 | ||
115 | KZWI3 | Subtotal 3 | CURR | 13 | ||
116 | KZWI4 | Subtotal 4 | CURR | 13 | ||
117 | KZWI5 | Subtotal 5 | CURR | 13 | ||
118 | KZWI6 | Subtotal 6 | CURR | 13 | ||
119 | STCUR | Exch.rate stats | DEC | 9 | ||
120 | AEDAT | Changed on | DATS | 8 | ||
121 | EAN11 | EAN/UPC | CHAR | 18 | ||
122 | FIXMG | Delivery date and quantity fixed | CHAR | 1 | ||
123 | PRCTR | Profit Center | CHAR | 10 | ||
124 | MVGR1 | MaterialGroup 1 | CHAR | 3 | TVM1 | |
125 | MVGR2 | MaterialGroup 2 | CHAR | 3 | TVM2 | |
126 | MVGR3 | MaterialGroup 3 | CHAR | 3 | TVM3 | |
127 | MVGR4 | MaterialGroup 4 | CHAR | 3 | TVM4 | |
128 | MVGR5 | MaterialGroup 5 | CHAR | 3 | TVM5 | |
129 | KMPMG | Component quantity | QUAN | 13 | ||
130 | SUGRD | Reasn | CHAR | 4 | TVSU | |
131 | SOBKZ | Special Stock | CHAR | 1 | T148 | |
132 | VPZUO | Allocation Indicator | CHAR | 1 | ||
133 | PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | ||
134 | PS_PSP_PNR | WBS Element | NUMC | 8 | PRPS | |
135 | AUFNR | Order | CHAR | 12 | AUFK | |
136 | VPMAT | Planning material | CHAR | 40 | MARA | |
137 | VPWRK | Planning plant | CHAR | 4 | T001W | |
138 | PRBME | Base unit of measure for product group | UNIT | 3 | T006 | |
139 | UMREF | Conversion factor: quantities | FLTP | 16 | ||
140 | KNTTP | Account Assignment Category | CHAR | 1 | T163K | |
141 | KZVBR | Consumption posting | CHAR | 1 | ||
142 | SERNR | BOM explosion number | CHAR | 8 | SNUM | |
143 | OBJNR | Object number | CHAR | 22 | ONR00 | |
144 | ABGRS | Results Analysis Key | CHAR | 6 | TKKAA | |
145 | BEDAE | Requirements type | CHAR | 4 | T459A | |
146 | CMPRE | Item credit price | CURR | 11 | ||
147 | CMTFG | ID for partial release of order item | CHAR | 1 | ||
148 | CMPNT | ID: Item with active credit function / relevant for credit | CHAR | 1 | ||
149 | CMKUA | Exchange rate | DEC | 9 | ||
150 | CUOBJ | Configuration (internal object number) | NUMC | 18 | ||
151 | CUOBJ_CH | Internal object number of the batch classification | NUMC | 18 | ||
152 | CEPOK | Status expected price | CHAR | 1 | ||
153 | KOUPD | Condition update | CHAR | 1 | ||
154 | SERAIL | Serial Number Profile | CHAR | 4 | T377P | |
155 | ANZSN | Number of Serial Numbers | INT4 | 10 | ||
156 | NACHL | Customer has not posted goods receipt | CHAR | 1 | ||
157 | MAGRV | Material Group: Packaging Materials | CHAR | 4 | TVEGR | |
158 | MPROK | Status manual price change | CHAR | 1 | ||
159 | VGTYP | Prec.doc.categ. | CHAR | 4 | ||
160 | PROSA | ID for material determination | CHAR | 1 | ||
161 | UEPVW | ID for higher-level item usage | CHAR | 1 | ||
162 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | NUMC | 12 | ||
163 | KLVAR | Costing Variant | CHAR | 4 | ||
164 | SPOSN | BOM Item Number | CHAR | 4 | ||
165 | KOWRR | Statistical values | CHAR | 1 | ||
166 | STADAT | Statistics date | DATS | 8 | ||
167 | EXART | Business Transaction Type for Foreign Trade | CHAR | 2 | ||
168 | PREFE | Preference indicator in export/import | CHAR | 1 | ||
169 | KNUMH | Number of condition record from batch determination | CHAR | 10 | ||
170 | CLINT | Internal Class Number | NUMC | 10 | KLAH | |
171 | CHMVS | Batches: Exit to quantity proposal | NUMC | 3 | ||
172 | STLTY | BOM category | CHAR | 1 | ||
173 | STLKN | BOM item node number | NUMC | 8 | ||
174 | STPOZ | Internal counter | NUMC | 8 | ||
175 | STMAN | Inconsistent configuration | CHAR | 1 | ||
176 | ZSCHL_K | Overhead key | CHAR | 6 | ||
177 | KALSM_K | Costing Sheet | CHAR | 6 | T683 | |
178 | KALVAR | Costing Variant | CHAR | 4 | TCK03 | |
179 | KOSCH | Product allocation determination procedure | CHAR | 18 | T190S | |
180 | UPMAT | Pricing reference material of main item | CHAR | 40 | MARA | |
181 | UKONM | Material pricing group of main item | CHAR | 2 | T178 | |
182 | MFRGR | Material freight group | CHAR | 8 | TMFG | |
183 | PLAVO | Planning delivery schedule instruction | CHAR | 4 | TVZP | |
184 | KANNR | KANBAN/sequence number | CHAR | 35 | ||
185 | CMPRE_FLT | Item credit price | FLTP | 16 | ||
186 | ABFOR | Form of payment guarantee | CHAR | 2 | T691K | |
187 | ABGES | Guaranteed (factor between 0 and 1) | FLTP | 16 | ||
188 | J_1BCFOP | CFOP Code and Extension | CHAR | 10 | J_1BAG | |
189 | J_1BTAXLW1 | Tax law: ICMS | CHAR | 3 | J_1BATL1 | |
190 | J_1BTAXLW2 | Tax law: IPI | CHAR | 3 | J_1BATL2 | |
191 | J_1BTXSDC | SD tax code | CHAR | 2 | J_1BTXSDC | |
192 | WKTNR | Value contract no. | CHAR | 10 | VBAK | |
193 | WKTPS | Value contract item | NUMC | 6 | VBAP | |
194 | SKOPF | Assortment module | CHAR | 18 | WSOH | |
195 | KZBWS | Valuation of Special Stock | CHAR | 1 | ||
196 | WGRU1 | Material group hierarchy 1 | CHAR | 18 | ||
197 | WGRU2 | Material group hierarchy 2 | CHAR | 18 | ||
198 | KNUMA_PI | Promotion | CHAR | 10 | KONA | |
199 | KNUMA_AG | Sales deal | CHAR | 10 | KONA | |
200 | KZFME | ID: Leading unit of measure for completing a transaction | CHAR | 1 | ||
201 | LSTANR | Free goods delivery control | CHAR | 1 | ||
202 | TECHS | Parameter Variant/Standard Variant | CHAR | 12 | ||
203 | MWSBP | Tax amount | CURR | 13 | ||
204 | BERID | MRP Area | CHAR | 10 | ||
205 | PCTRF | Profit Center for Billing | CHAR | 10 | ||
206 | LOGSYS_EXT | Logical system | CHAR | 10 | ||
207 | J_1BTAXLW3 | ISS Tax Law | CHAR | 3 | J_1BATL3 | |
208 | J_1BTAXLW4 | Single-Character Flag | CHAR | 3 | J_1BATL4A | |
209 | J_1BTAXLW5 | Single-Character Flag | CHAR | 3 | J_1BATL5 | |
210 | STOCKLOC | Location | CHAR | 20 | ||
211 | SLOCTYPE | Location Type | CHAR | 4 | ||
212 | MSR_RET_REASON | Return Reason | CHAR | 3 | MSR_C_RET_REASON | |
213 | MSR_REFUND_CODE | Returns Refund Code | CHAR | 3 | MSR_C_RET_REFUND | |
214 | MSR_APPROV_BLOCK | Approval Block | CHAR | 1 | ||
215 | NRAB_KNUMH | Condition record number | CHAR | 10 | ||
216 | TRMRISK_RELEVANT | Updated information in related user data field | CHAR | 2 | ||
217 | SGT_RCAT | Requirement Segment | CHAR | 40 | ||
218 | VBKD_POSNR | Sales Document Item | NUMC | 6 | ||
219 | VEDA_POSNR | Sales Document Item | NUMC | 6 | ||
220 | .INCLUDE | 0 | ||||
221 | HANDOVERLOC | Location for a physical handover of goods | CHAR | 10 | ||
222 | EXT_REF_ITEM_ID | CHAR | 40 | |||
223 | .INCLUDE | 0 | ||||
224 | HANDOVERDATE | Updated information in related user data field | DATS | 8 | ||
225 | HANDOVERTIME | Updated information in related user data field | TIMS | 6 | ||
226 | .INCLUDE | 0 | ||||
227 | .INCLUDE | 0 | ||||
228 | TC_AUT_DET | Updated information in related user data field | CHAR | 2 | * | |
229 | MANUAL_TC_REASON | Updated information in related user data field | CHAR | 2 | * | |
230 | FISCAL_INCENTIVE | Updated information in related user data field | CHAR | 4 | * | |
231 | TAX_SUBJECT_ST | Updated information in related user data field | CHAR | 1 | ||
232 | FISCAL_INCENTIVE_ID | Updated information in related user data field | CHAR | 4 | * | |
233 | SPCSTO | Nota Fiscal Special Case for CFOP Determination | NUMC | 2 | * | |
234 | REVACC_REFID | Updated information in related user data field | CHAR | 30 | ||
235 | REVACC_REFTYPE | Updated information in related user data field | CHAR | 3 | ||
236 | _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | ||
237 | .INCLUDE | 0 | ||||
238 | ABSTA | Rejection stat. | CHAR | 1 | ||
239 | BESTA | Confirmation Status of Document Item | CHAR | 1 | ||
240 | CMPPI | Status of credit check against financial document | CHAR | 1 | ||
241 | CMPPJ | Status of credit check against export credit insurance | CHAR | 1 | ||
242 | COSTA | Confirmation status for ALE | CHAR | 1 | ||
243 | DCSTA | Delay status | CHAR | 1 | ||
244 | FKSAA | Billing Status for Order-Related Billing Documents | CHAR | 1 | ||
245 | FSSTA | Billing block status for items | CHAR | 1 | ||
246 | GBSTA | Overall processing status of the SD document item | CHAR | 1 | ||
247 | LFGSA | Overall delivery status of the item | CHAR | 1 | ||
248 | LFSTA | Delivery status | CHAR | 1 | ||
249 | LSSTA | Delivery block status for item | CHAR | 1 | ||
250 | MANEK | Manual Completion of Contract | CHAR | 1 | ||
251 | RFGSA | Reference stat. | CHAR | 1 | ||
252 | RFSTA | Reference stat. | CHAR | 1 | ||
253 | UVALL | Item | CHAR | 1 | ||
254 | UVFAK | Item bill.data | CHAR | 1 | ||
255 | UVPRS | Pricing | CHAR | 1 | ||
256 | UVVLK | Item deliv.data | CHAR | 1 | ||
257 | UVP01 | Customer reserves 1: Item status | CHAR | 1 | ||
258 | UVP02 | Customer reserves 2: Item status | CHAR | 1 | ||
259 | UVP03 | Item reserves 3: Item status | CHAR | 1 | ||
260 | UVP04 | Item reserves 4: Item status | CHAR | 1 | ||
261 | UVP05 | Customer reserves 5: Item status | CHAR | 1 | ||
262 | WBSTA | GoodsMovementSt | CHAR | 1 | ||
263 | EMCST | CHAR | 1 | |||
264 | SLCST | Scope of check: Street for sanctioned party list | CHAR | 1 | ||
265 | TOTAL_LCCST | CHAR | 1 | |||
266 | PCSTA | CHAR | 1 | |||
267 | .INCLU--AP | 0 | ||||
268 | OIFINAL | Final Delivery Indicator | CHAR | 1 | ||
269 | REQQTY_BU | QUAN | 15 | |||
270 | HANDLE | Worldwide unique key for LIKP-VBELN | CHAR | 32 | ||
271 | PBS_STATE | CHAR | 1 | |||
272 | IFRS15_RELEVANCE | CHAR | 1 | |||
273 | IFRS15_TOTAL_SSP | CURR | 15 | |||
274 | REVFP | Rule for transferring the results of the availability check | CHAR | 1 | ||
275 | CAPPED_NET_AMOUNT | CURR | 15 | |||
276 | CAPPED_NET_AMOUNT_ALERT_THLD | NUMC | 3 | |||
277 | SESSION_CREATION_DATE | DATS | 8 | |||
278 | SESSION_CREATION_TIME | TIMS | 6 | |||
279 | ORIGINAL_PLANT | Transportation Cross-Docking: Supplying Plant | CHAR | 4 | ||
280 | ATP_ABC_SUBSTITUTION_STATUS | CHAR | 1 | |||
281 | .INCLUDE | 0 | ||||
282 | DUMMY_SLSDOCITEM_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | ||
283 | .INCLUDE | 0 | ||||
284 | PO_QUAN | Updated information in related user data field | QUAN | 13 | ||
285 | PO_UNIT | Updated information in related user data field | UNIT | 3 | * | |
286 | .INCLUDE | 0 | ||||
287 | MILL_SE_GPOSN | Character Field of Length 1 | NUMC | 6 | ||
288 | .INCLUDE | 0 | ||||
289 | MILL_BATCH_SEL_F | CHAR | 1 | |||
290 | .INCLU--AP | 0 | ||||
291 | CPD_UPDAT | Time Stamp | DEC | 15 | ||
292 | .INCLU--AP | 0 | ||||
293 | ZAPCGKI | NUMC | 4 | /ILE/TV01 | ||
294 | APCGK_EXTENDI | NUMC | 10 | |||
295 | ZABDATI | DATS | 8 | |||
296 | .INCLU--AP | 0 | ||||
297 | AUFPL_OLC | Routing number of operations in the order | NUMC | 10 | ||
298 | APLZL_OLC | Internal counter | NUMC | 8 | ||
299 | .INCLU--AP | 0 | ||||
300 | AD01PROFNR | Dynamic Item Processor Profile | CHAR | 8 | AD01C_PROF | |
301 | .INCLU--AP | 0 | ||||
302 | .INCLUDE | 0 | ||||
303 | ADMOI | Updated information in related user data field | CHAR | 4 | CSPCMOI | |
304 | ADICC | Interchangeability Code | NUMC | 2 | CSPCICC | |
305 | ADPRI | Updated information in related user data field | CHAR | 3 | CSPCPRI | |
306 | .INCLU--AP | 0 | ||||
307 | ADDNS | Updated information in related user data field | CHAR | 1 | ||
308 | ADACN | Updated information in related user data field | CHAR | 10 | ||
309 | .INCLU--AP | 0 | ||||
310 | LABSG | Indicator for Inbound Forecast and JIT Delivery Schedules | CHAR | 1 | ||
311 | FABSG | Indicator for Inbound Forecast Delivery Schedule Headers | CHAR | 1 | ||
312 | PR_L_L | Profile for Comparison of Frcst.DelSched with Frcst.DelSched | CHAR | 10 | ESD_TOPR | |
313 | PR_F_F | Profile for Comparison of JIT Del.Sched. with JIT Del.Sched. | CHAR | 10 | ESD_TOPR | |
314 | PR_F_L | Profile for Comp. of JIT Del.Sched. with Forecast Del.Sched. | CHAR | 10 | ESD_TOPR | |
315 | .INCLU--AP | 0 | ||||
316 | FERC_IND | Regulatory indicator | CHAR | 4 | FERC_C7 | |
317 | .INCLU--AP | 0 | ||||
318 | FSH_SEASON_YEAR | Season Year | CHAR | 4 | FSH_SEASONS | |
319 | FSH_SEASON | Season | CHAR | 10 | FSH_SEASONS | |
320 | FSH_COLLECTION | Fashion Collection | CHAR | 10 | FSH_COLLECTIONS | |
321 | FSH_THEME | Fashion Theme | CHAR | 10 | FSH_THEMES | |
322 | FSH_CRSD | Condition Record Number for Seasons | CHAR | 10 | ||
323 | FSH_SEAREF | Season Determined from Reference Document | CHAR | 1 | ||
324 | FSH_CANDATE | Updated information in related user data field | DATS | 8 | ||
325 | FSH_PSM_PFM_SPLIT | CHAR | 15 | |||
326 | .INCLUDE | 0 | ||||
327 | FSH_VAS_REL | Character Field of Length 1 | CHAR | 1 | ||
328 | FSH_VAS_PRNT_ID | Item Number of Purchasing Document | NUMC | 6 | ||
329 | FSH_TRANSACTION | Transaction Number | CHAR | 10 | ||
330 | FSH_ITEM_GROUP | Item Group | NUMC | 5 | ||
331 | FSH_ITEM | Character Field of Length 1 | NUMC | 5 | ||
332 | FSH_VASREF | Character Field of Length 1 | CHAR | 1 | ||
333 | FSH_GRID_COND_REC | Updated information in related user data field | CHAR | 32 | ||
334 | FSH_PQR_UEPOS | Character Field of Length 1 | NUMC | 6 | ||
335 | .INCLU--AP | 0 | ||||
336 | KOSTL | Cost Center | CHAR | 10 | * | |
337 | FONDS | Fund | CHAR | 10 | * | |
338 | FISTL | Funds Center | CHAR | 16 | * | |
339 | FKBER | Functional Area | CHAR | 16 | * | |
340 | GRANT_NBR | Grant | CHAR | 20 | ||
341 | BUDGET_PD | Budget Period | CHAR | 10 | * | |
342 | .INCLU--AP | 0 | ||||
343 | IUID_RELEVANT | Updated information in related user data field | CHAR | 1 | ||
344 | .INCLU--AP | 0 | ||||
345 | .INCLUDE | 0 | ||||
346 | EQUNR | Equipment Number | CHAR | 18 | EQUI | |
347 | EQART | Type of Technical Object | CHAR | 10 | T370K | |
348 | J_3GLVART | Single-Character Flag | CHAR | 4 | J_3GLEIART | |
349 | J_3GDATVO | From Date | DATS | 8 | ||
350 | J_3GDATBI | Valid To Date | DATS | 8 | ||
351 | J_3GBELNRI | Document Number | CHAR | 10 | J_3GBELK | |
352 | J_3GPOSNRI | Document Item | NUMC | 5 | J_3GBELP | |
353 | .INCLU--AP | 0 | ||||
354 | .INCLUDE | 0 | ||||
355 | OID_EXTBOL | External bill of lading | CHAR | 16 | ||
356 | OID_MISCDL | Miscellaneous delivery number | CHAR | 16 | ||
357 | OIPLANTD | Single-Character Flag | CHAR | 1 | ||
358 | OIBYPASS | Single-Character Flag | CHAR | 1 | ||
359 | OIEDOK | Updated information in related user data field | CHAR | 1 | ||
360 | CMETH | Checkbox | CHAR | 1 | ||
361 | OITAXFROM | Excise duty tax key for 'from' location | CHAR | 2 | OIH4 | |
362 | OIHANTYP | Excise Duty Handling Type | CHAR | 2 | OIH5 | |
363 | OITAXGRP | Excise Duty Group | CHAR | 2 | OIH2 | |
364 | OITAXTO | Excise duty tax key for 'to' location | CHAR | 2 | OIH4 | |
365 | OICERTF1 | Excise tax external license number | CHAR | 15 | ||
366 | OIOILCON | Oil content in a material as a percentage | DEC | 5 | ||
367 | OIEDBAL | Updated information in related user data field | CHAR | 1 | ||
368 | OIPRICIE | ED pricing: external (indicator) | CHAR | 1 | ||
369 | OIINEX | Updated information in related user data field | CHAR | 2 | OIH16 | |
370 | OIEDBALM | Updated information in related user data field | CHAR | 1 | ||
371 | OIDRC | Updated information in related user data field | CHAR | 5 | OICDC | |
372 | OIC_DRCTRY | Single-Character Flag | CHAR | 3 | * | |
373 | OIC_DRCREG | Single-Character Flag | CHAR | 3 | * | |
374 | OIMETIND | Single-Character Flag | CHAR | 4 | * | |
375 | OIWAP | Single-Character Flag | CHAR | 3 | * | |
376 | OISLF | Single-Character Flag | CHAR | 3 | * | |
377 | OIPSDRC | Single-Character Flag | CHAR | 5 | * | |
378 | .INCLUDE | 0 | ||||
379 | OIPIPEVAL | Validation indicator for pipeline fields (X=ON | CHAR | 1 | ||
380 | OIC_LIFNR | Account Number of Vendor or Creditor | CHAR | 10 | LFA1 | |
381 | .INCLUDE | 0 | ||||
382 | OIC_DCITYC | Destination city code | CHAR | 4 | T005G | |
383 | OIC_DCOUNC | Destination county code | CHAR | 3 | T005E | |
384 | OIC_DREGIO | Destination region | CHAR | 3 | T005S | |
385 | OIC_DLAND1 | Destination country | CHAR | 3 | T005 | |
386 | OIC_OCITYC | Origin city code | CHAR | 4 | T005G | |
387 | OIC_OCOUNC | Origin county code | CHAR | 3 | T005E | |
388 | OIC_OREGIO | Origin region | CHAR | 3 | T005S | |
389 | OIC_OLAND1 | Origin country | CHAR | 3 | T005 | |
390 | OIC_PORGIN | Tax origin | CHAR | 15 | ||
391 | OIC_PDESTN | Tax destination | CHAR | 15 | ||
392 | OIC_PTRIP | Pipeline trip number (external) | CHAR | 16 | ||
393 | OIC_PBATCH | Pipeline operators external batch number | CHAR | 16 | ||
394 | OIC_MOT | IS-OIL MAP external details mode of transport | CHAR | 2 | TVTR | |
395 | OIC_AORGIN | Alternate origin | CHAR | 15 | ||
396 | OIC_ADESTN | Alternate destination | CHAR | 15 | ||
397 | OIC_TRUCKN | Truck number | CHAR | 10 | ||
398 | OIA_BASELO | Base location | CHAR | 15 | ||
399 | .INCLUDE | 0 | ||||
400 | OIEXGNUM | Exchange agreement number | CHAR | 10 | ||
401 | OIEXGTYP | Exchange type | CHAR | 4 | TOIA2 | |
402 | OIFEETOT | Fee total | CURR | 13 | ||
403 | OIFEEDT | Fee pricing condition date | DATS | 8 | ||
404 | OINETCYC | Netting cycle (FI blocking indicator) | CHAR | 1 | T008 | |
405 | OICONTNR | Single-Character Flag | CHAR | 10 | ||
406 | OIC_KMPOS | Single-Character Flag | NUMC | 6 | ||
407 | OIFEECH | Updated information in related user data field | CHAR | 1 | ||
408 | OIH_LICTP | License type | CHAR | 4 | OIH20 | |
409 | OIH_LICIN | Excise tax internal license number | CHAR | 10 | ||
410 | OIH_LCFOL | Follow-on license for quantity license | CHAR | 10 | OIHL | |
411 | OIH_FOLQTY | Excise Tax Follow-On License Quantity | QUAN | 13 | ||
412 | OISBREL | Sub product/ base product relevence indicator | NUMC | 3 | ||
413 | OIBASPROD | Base product number | CHAR | 40 | * | |
414 | OIDMSG_PRD | Single-Character Flag | CHAR | 1 | ||
415 | OIDMSG_QTY | Single-Character Flag | CHAR | 1 | ||
416 | OIDMSG_UOM | Single-Character Flag | CHAR | 1 | ||
417 | OIDMSG_DAT | Single-Character Flag | CHAR | 1 | ||
418 | OIDMSG_TRM | Single-Character Flag | CHAR | 1 | ||
419 | OIDMSG_SHP | Single-Character Flag | CHAR | 1 | ||
420 | OIGNRULE | Single-Character Flag | NUMC | 3 | * | |
421 | OID_SHIP | Ship-to party | CHAR | 10 | * | |
422 | .INCLUDE | 0 | ||||
423 | OIBWTAR_IM | Valuation type | CHAR | 10 | T149D | |
424 | OIHANTYP_IM | Excise Duty Handling Type | CHAR | 2 | OIH5 | |
425 | OITAXGRP_IM | Excise Duty Group | CHAR | 2 | OIH2 | |
426 | OITAXFROM_IM | Excise duty tax key for 'from' location | CHAR | 2 | OIH4 | |
427 | OITAXTO_IM | Excise duty tax key for 'to' location | CHAR | 2 | OIH4 | |
428 | OIEDBAL_IM | Excise duty balancing is required (indicator) | CHAR | 1 | ||
429 | OIEDBALM_IM | Excise duty balancing method indicator | CHAR | 1 | ||
430 | OIPRICIE_IM | ED pricing: external (indicator) | CHAR | 1 | ||
431 | .INCLUDE | 0 | ||||
432 | OIBWTAR_EX | Valuation type | CHAR | 10 | T149D | |
433 | OIHANTYP_EX | Excise Duty Handling Type | CHAR | 2 | OIH5 | |
434 | OITAXGRP_EX | Excise Duty Group | CHAR | 2 | OIH2 | |
435 | OITAXFROM_EX | Excise duty tax key for 'from' location | CHAR | 2 | OIH4 | |
436 | OITAXTO_EX | Excise duty tax key for 'to' location | CHAR | 2 | OIH4 | |
437 | OIEDBAL_EX | Excise duty balancing is required (indicator) | CHAR | 1 | ||
438 | OIEDBALM_EX | Excise duty balancing method indicator | CHAR | 1 | ||
439 | OIPRICIE_EX | ED pricing: external (indicator) | CHAR | 1 | ||
440 | OIINEX_EX | Code for internal or external excise duty rate determination | CHAR | 2 | OIH16 | |
441 | OICERTF1_EX | Excise tax external license number | CHAR | 15 | ||
442 | OIH_LICTP_EX | License type | CHAR | 4 | OIH20 | |
443 | OIH_LICIN_EX | Excise tax internal license number | CHAR | 10 | ||
444 | OIH_LCFOL_EX | Follow-on license for quantity license | CHAR | 10 | OIHL | |
445 | OIH_FOLQTY_EX | Excise tax follow-on license quantity | QUAN | 13 | ||
446 | OIHTAXRCP_EX | CHAR | 10 | |||
447 | OIHNOTWERKS | CHAR | 4 | |||
448 | OIHNOTLGORT | CHAR | 4 | * | ||
449 | OIHCOTDISCH | CHAR | 1 | |||
450 | .INCLU--AP | 0 | ||||
451 | OIU_MP_NO | Obsolete | CHAR | 20 | ||
452 | OIU_WL_NO | Obsolete | CHAR | 15 | ||
453 | OIU_WC_NO | Obsolete | CHAR | 5 | ||
454 | .INCLU--AP | 0 | ||||
455 | .INCLUDE | 0 | ||||
456 | PRS_OBJNR | Text string 22 characters | CHAR | 22 | ||
457 | .INCLU--AP | 0 | ||||
458 | PRS_SD_SPSNR | Standard WBS Element for Project Inception via SD | NUMC | 8 | * | |
459 | PRS_WORK_PERIOD | Work Period (Internal Representation) | NUMC | 7 | ||
460 | .INCLU--AP | 0 | ||||
461 | TAS | Single-Character Flag | CHAR | 30 | ||
462 | BETC | Single-Character Flag | CHAR | 10 | ||
463 | MOD_ALLOW | Single-Character Flag | CHAR | 1 | ||
464 | CANCEL_ALLOW | Single-Character Flag | CHAR | 1 | ||
465 | PAY_METHOD | Payroll payment method | CHAR | 10 | ||
466 | BPN | Single-Character Flag | CHAR | 6 | T880 | |
467 | REP_FREQ | Single-Character Flag | CHAR | 3 | ||
468 | FMFGUS_KEY | United States Federal Government Fields | CHAR | 22 | ||
469 | .INCLU--AP | 0 | ||||
470 | RFM_PSST_RULE | Updated information in related user data field | CHAR | 4 | ||
471 | RFM_PSST_GROUP | Updated information in related user data field | CHAR | 10 | ||
472 | .INCLU--AP | 0 | ||||
473 | PARGB | Trdg part.BA | CHAR | 4 | * | |
474 | .INCLU--AP | 0 | ||||
475 | AUFPL_OAA | Routing number of operations in the order | NUMC | 10 | ||
476 | APLZL_OAA | Internal counter | NUMC | 8 | ||
477 | .INCLU--AP | 0 | ||||
478 | VLCENDCU | End Customer (Central Business Partner) | CHAR | 10 | ||
479 | .INCLU--AP | 0 | ||||
480 | WRF_CHARSTC1 | Characteristic Value 1 | CHAR | 18 | ||
481 | WRF_CHARSTC2 | Characteristic Value 2 | CHAR | 18 | ||
482 | WRF_CHARSTC3 | Characteristic Value 3 | CHAR | 18 | ||
483 | .INCLU--AP | 0 | ||||
484 | .INCLUDE | 0 | ||||
485 | .INCLUDE | 0 | ||||
486 | ARSNUM | Number of reservation/dependent requirements | NUMC | 10 | * | |
487 | ARSPOS | Item number of reservation/dependent requirements | NUMC | 4 | ||
488 | .INCLUDE | 0 | ||||
489 | WTYSC_CLMITEM | Updated information in related user data field | CHAR | 16 |
SAP Help, Wiki Resources, and Forum Discussions on VBAP
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Custom field in table VBAP for incompletion log not functioning as expected
You need to create your own PAI module, which will execute similar code as in the VBAP_FULLEN (for new item) and VBAP_BEARBEITEN (for changed items) modules. I believe you can call the modules also from the screens you've mentioned. You need at least to execute the form VBAP_BEARBEITEN, in which the system executes the incompletion log check.
http://scn.sap.com/message/10968234
-
How to change VBAP-MATNR and ARKTX using BAPI_SALESORDER_CHANGE
Hi ALL.
I'd like to chenge VBAP-MATNR and ARKTX using BAPI_SALESORDER_CHANGE.
I set parameters below.
ORDER_ITEM_IN-MATERIAL
ORDER_ITEM_INX-MATERIAL
ORDER_ITEM_IN-SHORT_TEXT
ORDER_ITEM_INX-SHORT_TEXT
but It change ONLY VBAP-MATNR. NOT change the value of VBAP-ARKTX.
I don't know why and how to do.
If you know that, let me kno...
http://scn.sap.com/message/11135016
-
Xkwert = xworkm * VBAP-ZSCHL_K.-Not working | SCN
Dear gurus,
ZPR0: Condition Value:100..
I enter overhead key in va01 as: 3.
VBAP-ZSCHL_K-- I entered as:3
Now I need a routine for ;
100*3=300
How can I type code?
*xkwert = xworkm * VBAP-ZSCHL_K.--This code is not working..
http://scn.sap.com/message/10676902
-
Can we update the field VBAP-BEDAE in USEREXIT_SAVE_DOCUMENT_PREPARE
I have a requirement to change the requirment type(VBAP-BEDAE) of the Sales order item to be changed to custom requirment type, when ever the item quantity is changed.
http://scn.sap.com/message/10522992
-
How to update "profit center for billing"(VBAP-PCTRF) for sales order.
Now, we need to bring "profit center for billing" in sales order to correspondence with meterial master, while BAPI "BAPI_SALESORDER_CHANGE" contain not this field, is there any way to achieve except modify database table directly.
http://scn.sap.com/thread/1530232
-
VBAPKOM and VBAP | SCN
I have a requirement to move value of the field from the communication structure VBAPKOM to VBAP.
http://scn.sap.com/message/10536148
-
Creating Debit Memo Request and changing mvgr1 field in VBAP
I'm trying to create a Debit Memo Request when there is a contract. During this process, I want to change the VBAP-mvgr1 field if it's a certain project type. I've tried almost all of the userexits in Include MV45AFZZ using xVBAP. I've mostly tried userexit_move_field_to_VBAP, userexit_save_document and userexit_save_document_prepare. In debug mode I see it change, but it doesn't change in VBAP...
http://scn.sap.com/message/10234094
-
Credit - Field VBAP-CMPRE | SCN
When i Create a new order the field VBAP-CMPRE is not valued. Do you know the reason?
http://scn.sap.com/message/10467721
-
Fetching data from vbak, VBAP, vbrp giving error | SCN
hi,
u can do by this following example
use this inside the loop
READ TABLE IT_vbak INTO WA_vbak WITH KEY vbeln = WA_FINAL-vbeln.
& give the final records as follows
WA_FINAL-FKLMG = WA_vbrp-FKLMG.
WA_FINAL-MATNR = WA_vbrp-MATNR.
WA_FINAL-ARKTX = WA_vbrp-ARKTX.
u have to read all the records into...
http://scn.sap.com/message/11067935
-
What are the join conditions for creating SAP Query by joining tables- VBAK, VBAP, LIKP, LIPS, VBRK & VBRP
Please let me know the join conditions for creating SAP Query by joining tables- VBAK, VBAP, LIKP, LIPS, VBRK & VBRP.
http://scn.sap.com/message/13627296
-
Problem to update VBAP-ERLRE field in a standard table----Its urgent
I need to create custom utility program to update ERLRE field(already it was set with B for thos specific orders,i need to upadte with null value for those) in production for specific orders.I checked FM: sd_salesdocument_change, but ITEM_IN STRUCTURE BAPISDITM ,ITEM_INX STRUCTURE BAPISDITMX OPTIONAL
http://scn.sap.com/message/1163933
Related Tables
TABLE | Description | Functional Area |
---|---|---|
VBAK | Sales Document: Header Data | SD - Sales |
VBRP | Billing Document: Item Data | SD - Billing |
LIPS | SD document: Delivery: Item data | Logistics Execution - Shipping |
VBEP | Sales Document: Schedule Line Data | SD - Sales |
MARA | General Material Data | Logistics - Material Master |
VBKD | Sales Document: Business Data | SD - Sales |
VBRK | Billing Document: Header Data | SD - Billing |
Transaction Codes for SAP Table VBAP
TCODE | Description | Functional Area |
---|---|---|
VA01 | Create Sales Order | SD - Sales |
VA02 | Change Sales Order | SD - Sales |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
SE16 | Data Browser | Basis - Workbench Utilities |
VBKD | Bonus Buy: Condition Types | SD - Free Goods |
VA03 | Display Sales Order | SD - Sales |
SE38 | ABAP Editor | Basis - ABAP Editor |
FMs for SAP Table VBAP
FM | Description | Functional Area |
---|---|---|
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
BAPI_SALESORDER_CHANGE | Sales order: Change Sales Order | SD - Basic Functions |
BAPI_SALESORDER_CREATEFROMDAT2 | Sales order: Create Sales Order | SD - Basic Functions |
BAPI_TRANSACTION_COMMIT | Execute external Commit when using BAPIs | Basis - ALE Integration Technology |
REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table | BC - SAP List Viewer |
REUSE_ALV_LIST_DISPLAY | Output a simple list (single line or several lines) | BC - SAP List Viewer |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
CONVERSION_EXIT_ALPHA_INPUT | Conversion exit ALPHA, external->internal | Basis - Syntax, Compiler, Runtime |
ABAP Reports for SAP Table VBAP
ABAP REPORT | Description | Functional Area |
---|---|---|
SAPMV45A | Sales Order Processing | SD - Sales |
MV45AFZB | User Exits | SD - Material Maintenance |
OLE2INCL | Include with TYPE Definition | Basis - Use BC-FES-CTL (see SAP Note 842824) |
SAPFV45P | Sales: Item Processing | SD - Sales |
SDRQCR21 | Recovery of Sales and Delivery Requirements | SD - Basic Functions |
MV50AFZ1 | User Exit as of 21D for Delivery Processing | SD - Material Maintenance |
BDCRECX1 | Include f | Basis - UI Services, Screen, Batch Input |
RVADOR01 | Print Program for Sales Documents | SD - Basic Functions |
BW Datasources for SAP Table VBAP
BW DATASOURCE | Description | Functional Area |
---|---|---|
2LIS_11_VAITM | Sales Document Item Data | SD - Sales and Distribution |
2LIS_11_VAHDR | Sales Document Header Data | SD - Sales and Distribution |
2LIS_12_VCITM | Delivery Item Data | SD - Sales and Distribution |
2LIS_13_VDITM | Billing Document Item Data | SD - Sales and Distribution |
2LIS_12_VCHDR | Delivery Header Data | SD - Sales and Distribution |
2LIS_11_VASCL | Sales Document Schedule Line | SD - Sales and Distribution |
2LIS_02_HDR | Purchasing Data (Header Level) | MM - Materials Management |
2LIS_03_BF | Goods Movements From Inventory Management | MM - Materials Management |
Authorization Objects for SAP Table VBAP
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
E_GRID | Authorization Object for Grid | |
S_CARRID | Authorization Object for Airlines | |
I_SWERK | PM: Maintenance Plant | |
S_USER_GRP | User Master Maintenance: User Groups | |
S_RS_COMP | Business Explorer - Components | |
S_RFC | Authorization Check for RFC Access | |
P_TCODE | HR: Transaction codes | |
S_PROGRAM | ABAP: Program Flow Checks |
Most searched SAP Sales and Distribution Tables
- Sales Order Tables
- Plant Tables
- Document Type Tables
- Delivery Tables
- Pricing Tables
- Billing Document Tables
- Sales Organization Tables
- Outbound Delivery Tables
- Pricing Conditions Tables
- Contract Tables
- Internal Order Tables
- Item Category Tables
- Pricing Procedure Tables
- Condition Types Tables
- Billing Tables
- Output Type Tables
- Customer Group Tables
- Price List Tables
- Condition Record Tables
- Order Type Tables
- Sales Order Type Tables
- Info Record Tables