VBRP is a standard Billing Transparent Table in SAP SD application, which stores Billing 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 VBRP. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
VBRP — Meta Data
Description: | Billing Document: Item Data |
Main Category: | SD |
Sub Category: | Billing |
Table type: | Transparent Table (TRANSP) |
VBRP — 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 | VBRK |
3 | POSNR | Item | X | NUMC | 6 | |
4 | UEPOS | Higher-level item in bill of material structures | NUMC | 6 | ||
5 | FKIMG | Actual billed quantity | QUAN | 13 | ||
6 | VRKME | Sales unit | UNIT | 3 | T006 | |
7 | UMVKZ | Numerator | DEC | 5 | ||
8 | UMVKN | Denominat. | DEC | 5 | ||
9 | MEINS | Base Unit | UNIT | 3 | T006 | |
10 | SMENG | Scale quantity | QUAN | 13 | ||
11 | FKLMG | Billing quantity in stockkeeping unit | QUAN | 13 | ||
12 | LMENG | Required qty | QUAN | 13 | ||
13 | NTGEW | Net Weight | QUAN | 15 | ||
14 | BRGEW | Gross Weight | QUAN | 15 | ||
15 | GEWEI | Weight unit | UNIT | 3 | T006 | |
16 | VOLUM | Volume | QUAN | 15 | ||
17 | VOLEH | Volume unit | UNIT | 3 | T006 | |
18 | GSBER | Business Area | CHAR | 4 | TGSB | |
19 | PRSDT | Pricing date | DATS | 8 | ||
20 | FBUDA | Serv.rendered | DATS | 8 | ||
21 | KURSK | Exchange Rate | DEC | 9 | ||
22 | NETWR | Net value | CURR | 15 | ||
23 | VBELV | Originating document | CHAR | 10 | ||
24 | POSNV | Originating item | NUMC | 6 | ||
25 | VGBEL | Reference doc. | CHAR | 10 | ||
26 | VGPOS | Reference item | NUMC | 6 | ||
27 | VGTYP | Prec.doc.categ. | CHAR | 4 | ||
28 | AUBEL | Sales Document | CHAR | 10 | VBAK | |
29 | AUPOS | Sales Document Item | NUMC | 6 | VBAP | |
30 | AUREF | Sales document was created from reference | CHAR | 1 | ||
31 | MATNR | Material | CHAR | 40 | MARA | |
32 | ARKTX | Description | CHAR | 40 | ||
33 | PMATN | Pricing Reference Material | CHAR | 40 | MARA | |
34 | CHARG | Batch | CHAR | 10 | MCHA | |
35 | MATKL | Material Group | CHAR | 9 | T023 | |
36 | PSTYV | Item category | CHAR | 4 | ||
37 | POSAR | Item type | CHAR | 1 | ||
38 | PRODH | Prod.hierarchy | CHAR | 18 | T179 | |
39 | VSTEL | Shipping Point | CHAR | 4 | TVST | |
40 | ATPKZ | Replacement part | CHAR | 1 | ||
41 | SPART | Division | CHAR | 2 | TSPA | |
42 | POSPA | Item number in the partner segment | NUMC | 6 | VBRP | |
43 | WERKS | Plant | CHAR | 4 | T001W | |
44 | ALAND | Country Key | CHAR | 3 | T005 | |
45 | WKREG | Region in which plant is located | CHAR | 3 | T005S | |
46 | WKCOU | County in which plant is located | CHAR | 3 | ||
47 | WKCTY | City in which plant is located | CHAR | 4 | ||
48 | TAXM1 | Tax classification material | CHAR | 1 | ||
49 | TAXM2 | Tax classification material | CHAR | 1 | ||
50 | TAXM3 | Tax classification material | CHAR | 1 | ||
51 | TAXM4 | Tax classification material | CHAR | 1 | ||
52 | TAXM5 | Tax classification material | CHAR | 1 | ||
53 | TAXM6 | Tax classification material | CHAR | 1 | ||
54 | TAXM7 | Tax classification material | CHAR | 1 | ||
55 | TAXM8 | Tax classification material | CHAR | 1 | ||
56 | TAXM9 | Tax classification material | CHAR | 1 | ||
57 | KOWRR | Statistical values | CHAR | 1 | ||
58 | PRSFD | Carry out pricing | CHAR | 1 | ||
59 | SKTOF | Cash discount indicator | CHAR | 1 | ||
60 | SKFBP | Csh.disc.bas | CURR | 13 | ||
61 | KONDM | Material Pricing Group | CHAR | 2 | T178 | |
62 | KTGRM | Account assignment group for this material | CHAR | 2 | TVKM | |
63 | KOSTL | Cost Center | CHAR | 10 | ||
64 | BONUS | Vol. rebate grp | CHAR | 2 | TVBO | |
65 | PROVG | Commission grp | CHAR | 2 | TVPR | |
66 | EANNR | European Article Number (EAN) - obsolete!!!!! | CHAR | 13 | ||
67 | VKGRP | Sales Group | CHAR | 3 | TVKGR | |
68 | VKBUR | Sales Office | CHAR | 4 | TVBUR | |
69 | SPARA | Division | CHAR | 2 | TSPA | |
70 | SHKZG | Debit/Credit | CHAR | 1 | ||
71 | ERNAM | Created by | CHAR | 12 | ||
72 | ERDAT | Created on | DATS | 8 | ||
73 | ERZET | Time | TIMS | 6 | ||
74 | BWTAR | Valuation Type | CHAR | 10 | T149D | |
75 | LGORT | Stor. Location | CHAR | 4 | T001L | |
76 | STAFO | Update group for statistics update | CHAR | 6 | ||
77 | WAVWR | Cost | CURR | 13 | ||
78 | KZWI1 | Subtotal 1 | CURR | 13 | ||
79 | KZWI2 | Subtotal 2 | CURR | 13 | ||
80 | KZWI3 | Subtotal 3 | CURR | 13 | ||
81 | KZWI4 | Subtotal 4 | CURR | 13 | ||
82 | KZWI5 | Subtotal 5 | CURR | 13 | ||
83 | KZWI6 | Subtotal 6 | CURR | 13 | ||
84 | STCUR | Exch.rate stats | DEC | 9 | ||
85 | UVPRS | Pricing | CHAR | 1 | ||
86 | UVALL | Item | CHAR | 1 | ||
87 | EAN11 | EAN/UPC | CHAR | 18 | ||
88 | PRCTR | Profit Center | CHAR | 10 | ||
89 | KVGR1 | Customer grp 1 | CHAR | 3 | TVV1 | |
90 | KVGR2 | Customer grp 2 | CHAR | 3 | TVV2 | |
91 | KVGR3 | Customer grp 3 | CHAR | 3 | TVV3 | |
92 | KVGR4 | Customer grp 4 | CHAR | 3 | TVV4 | |
93 | KVGR5 | Customer grp 5 | CHAR | 3 | TVV5 | |
94 | MVGR1 | MaterialGroup 1 | CHAR | 3 | TVM1 | |
95 | MVGR2 | MaterialGroup 2 | CHAR | 3 | TVM2 | |
96 | MVGR3 | MaterialGroup 3 | CHAR | 3 | TVM3 | |
97 | MVGR4 | MaterialGroup 4 | CHAR | 3 | TVM4 | |
98 | MVGR5 | MaterialGroup 5 | CHAR | 3 | TVM5 | |
99 | MATWA | MaterialEntered | CHAR | 40 | MARA | |
100 | BONBA | Rebate basis | CURR | 13 | ||
101 | KOKRS | CO Area | CHAR | 4 | TKA01 | |
102 | PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | ||
103 | PS_PSP_PNR | WBS Element | NUMC | 8 | ||
104 | AUFNR | Order | CHAR | 12 | AUFK | |
105 | TXJCD | Jurisdiction for Tax Calculation - Tax Jurisdiction Code | CHAR | 15 | ||
106 | CMPRE | Item credit price | CURR | 11 | ||
107 | CMPNT | ID: Item with active credit function / relevant for credit | CHAR | 1 | ||
108 | CUOBJ | Configuration (internal object number) | NUMC | 18 | ||
109 | CUOBJ_CH | Internal object number of the batch classification | NUMC | 18 | ||
110 | KOUPD | Condition update | CHAR | 1 | ||
111 | UECHA | Higher-Level Item of Batch Split Item | NUMC | 6 | ||
112 | XCHAR | Batch management indicator (internal) | CHAR | 1 | ||
113 | ABRVW | Usage Indicator | CHAR | 3 | TVLV | |
114 | SERNR | BOM explosion number | CHAR | 8 | SNUM | |
115 | BZIRK_AUFT | Sales district of sales order | CHAR | 6 | T171 | |
116 | KDGRP_AUFT | Customer group of sales order | CHAR | 2 | T151 | |
117 | KONDA_AUFT | Price group of sales order | CHAR | 2 | T188 | |
118 | LLAND_AUFT | Country of destination of sales order | CHAR | 3 | T005 | |
119 | MPROK | Status manual price change | CHAR | 1 | ||
120 | PLTYP_AUFT | Price list type of sales order | CHAR | 2 | T189 | |
121 | REGIO_AUFT | Region of sales order | CHAR | 3 | T005S | |
122 | VKORG_AUFT | Sales organization of sales order | CHAR | 4 | TVKO | |
123 | VTWEG_AUFT | Distribution channel of sales order | CHAR | 2 | TVTW | |
124 | ABRBG | Start of accounting settlement period | DATS | 8 | ||
125 | PROSA | ID for material determination | CHAR | 1 | ||
126 | UEPVW | ID for higher-level item usage | CHAR | 1 | ||
127 | AUTYP | Order Category | CHAR | 4 | ||
128 | STADAT | Statistics date | DATS | 8 | ||
129 | FPLNR | Billing plan number / invoicing plan number | CHAR | 10 | FPLA | |
130 | FPLTR | Item for billing plan/invoice plan/payment cards | NUMC | 6 | ||
131 | AKTNR | Promotion | CHAR | 10 | WAKH | |
132 | KNUMA_PI | Promotion | CHAR | 10 | KONA | |
133 | KNUMA_AG | Sales deal | CHAR | 10 | KONA | |
134 | MWSBP | Tax amount | CURR | 13 | ||
135 | AUGRU_AUFT | Order reason (reason for the business transaction) | CHAR | 3 | TVAU | |
136 | FAREG | Billing rule | CHAR | 1 | ||
137 | UPMAT | Pricing reference material of main item | CHAR | 40 | MARA | |
138 | UKONM | Material pricing group of main item | CHAR | 2 | T178 | |
139 | CMPRE_FLT | Item credit price | FLTP | 16 | ||
140 | ABFOR | Form of payment guarantee | CHAR | 2 | T691K | |
141 | ABGES | Guaranteed (factor between 0 and 1) | FLTP | 16 | ||
142 | J_1ARFZ | Single-Character Flag | CHAR | 1 | J_1ARFZ | |
143 | J_1AREGIO | Region (State | CHAR | 3 | T005S | |
144 | J_1AGICD | Single-Character Flag | CHAR | 2 | J_1AGICD | |
145 | J_1ADTYP | Single-Character Flag | CHAR | 2 | J_1ADTYP | |
146 | J_1ATXREL | Single-Character Flag | CHAR | 10 | J_1ATXREL | |
147 | J_1BCFOP | CFOP Code and Extension | CHAR | 10 | J_1BAG | |
148 | J_1BTAXLW1 | Tax law: ICMS | CHAR | 3 | J_1BATL1 | |
149 | J_1BTAXLW2 | Tax law: IPI | CHAR | 3 | J_1BATL2 | |
150 | J_1BTXSDC | SD tax code | CHAR | 2 | J_1BTXSDC | |
151 | BRTWR | Gross Price | CURR | 15 | ||
152 | WKTNR | Value contract no. | CHAR | 10 | VBAK | |
153 | WKTPS | Value contract item | NUMC | 6 | VBAP | |
154 | RPLNR | Number of payment card plan type | CHAR | 10 | FPLA | |
155 | KURSK_DAT | Translatn Date | DATS | 8 | ||
156 | WGRU1 | Material group hierarchy 1 | CHAR | 18 | ||
157 | WGRU2 | Material group hierarchy 2 | CHAR | 18 | ||
158 | KDKG1 | Single-Character Flag | CHAR | 2 | TVKGG | |
159 | KDKG2 | Single-Character Flag | CHAR | 2 | TVKGG | |
160 | KDKG3 | Single-Character Flag | CHAR | 2 | TVKGG | |
161 | KDKG4 | Single-Character Flag | CHAR | 2 | TVKGG | |
162 | KDKG5 | Single-Character Flag | CHAR | 2 | TVKGG | |
163 | VKAUS | Usage Indicator | CHAR | 3 | TVLV | |
164 | J_1AINDXP | Updated information in related user data field | CHAR | 5 | J_1AINFT20 | |
165 | J_1AIDATEP | Updated information in related user data field | DATS | 8 | ||
166 | KZFME | ID: Leading unit of measure for completing a transaction | CHAR | 1 | ||
167 | MWSKZ | Tax code | CHAR | 2 | ||
168 | VERTT | Contract Type | CHAR | 1 | ||
169 | VERTN | Contract Number | CHAR | 13 | ||
170 | SGTXT | Name | CHAR | 50 | ||
171 | DELCO | Checkbox | CHAR | 3 | ||
172 | BEMOT | Accounting Indicator | CHAR | 2 | TBMOT | |
173 | RRREL | Revenue recognition category | CHAR | 1 | ||
174 | WMINR | Catalog | CHAR | 10 | WWMI | |
175 | VGBEL_EX | Document number of the reference document | CHAR | 10 | ||
176 | VGPOS_EX | Item number of the reference item | NUMC | 6 | ||
177 | LOGSYS | Logical system | CHAR | 10 | ||
178 | VGTYP_EX | Category of an external transaction or element | CHAR | 3 | ||
179 | J_1BTAXLW3 | ISS Tax Law | CHAR | 3 | J_1BATL3 | |
180 | J_1BTAXLW4 | Single-Character Flag | CHAR | 3 | J_1BATL4A | |
181 | J_1BTAXLW5 | Single-Character Flag | CHAR | 3 | J_1BATL5 | |
182 | MSR_ID | Process Identification Number | CHAR | 10 | ||
183 | MSR_REFUND_CODE | Returns Refund Code | CHAR | 3 | MSR_C_RET_REFUND | |
184 | MSR_RET_REASON | Return Reason | CHAR | 3 | MSR_C_RET_REASON | |
185 | NRAB_KNUMH | Condition record number | CHAR | 10 | ||
186 | NRAB_VALUE | Condition Value | CURR | 13 | ||
187 | DISPUTE_CASE | Dispute Case | RAW | 16 | ||
188 | FUND_USAGE_ITEM | Fund Usage Item | RAW | 16 | ||
189 | FARR_RELTYPE | Relevance Type for Revenue Accounting | CHAR | 10 | ||
190 | CLAIMS_TAXATION | Claims Taxation | CHAR | 1 | ||
191 | KURRF_DAT_ORIG | Translation date | DATS | 8 | ||
192 | SGT_RCAT | Requirement Segment | CHAR | 40 | ||
193 | SGT_SCAT | Stock Segment | CHAR | 40 | ||
194 | PREFE | Preference indicator in export/import | CHAR | 1 | ||
195 | AKKUR | Exchange rate for letter-of-credit procg in foreign trade | DEC | 9 | ||
196 | WAERK | Doc. Currency | CUKY | 5 | ||
197 | DRAFT | Processing status DRAFT | CHAR | 1 | ||
198 | ACTIVEDOCUMENT | Sales and Distribution Document Number | CHAR | 10 | ||
199 | GRWRT | Statistical value | CURR | 13 | ||
200 | FKSAA | Billing Status for Order-Related Billing Documents | CHAR | 1 | ||
201 | ABSTA | Rejection stat. | CHAR | 1 | ||
202 | ABGRU | RejectionReason | CHAR | 2 | ||
203 | MWSK1 | Tax Code for Distribution | CHAR | 2 | ||
204 | _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | ||
205 | .INCLUDE | 0 | ||||
206 | .INCLUDE | 0 | ||||
207 | DUMMY_BILLGDOCITEM_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | ||
208 | .INCLUDE | 0 | ||||
209 | /CWM/MENGE | Quantity | QUAN | 13 | ||
210 | /CWM/MEINS | Parallel Unit of Measure | UNIT | 3 | * | |
211 | .INCLU--AP | 0 | ||||
212 | ZAPCGKI | NUMC | 4 | /ILE/TV01 | ||
213 | APCGK_EXTENDI | NUMC | 10 | |||
214 | ZABDATI | DATS | 8 | |||
215 | .INCLU--AP | 0 | ||||
216 | AUFPL | Routing number of operations in the order | NUMC | 10 | ||
217 | APLZL | General counter for order | NUMC | 8 | ||
218 | .INCLU--AP | 0 | ||||
219 | DPCNR | Down Payment Chain Number | CHAR | 10 | ||
220 | DCPNR | Transaction Number | NUMC | 3 | ||
221 | DPNRB | Number of Line Item Within Accounting Document | NUMC | 3 | ||
222 | .INCLU--AP | 0 | ||||
223 | BOSFAR | Billing/Invoicing rule (w/o invoicing plan | CHAR | 1 | ||
224 | DP_BELNR | Accounting Document Number | CHAR | 10 | ||
225 | DP_BUKRS | Company Code | CHAR | 4 | ||
226 | DP_GJAHR | Fiscal Year | NUMC | 4 | ||
227 | DP_BUZEI | Number of Line Item Within Accounting Document | NUMC | 3 | ||
228 | .INCLU--AP | 0 | ||||
229 | PACKNO | Package number | NUMC | 10 | ESLH | |
230 | .INCLU--AP | 0 | ||||
231 | PEROP_BEG | Billing Period of Performance Start Date | DATS | 8 | ||
232 | PEROP_END | Billing Period of Performance End Date | DATS | 8 | ||
233 | .INCLU--AP | 0 | ||||
234 | FMFGUS_KEY | United States Federal Government Fields | CHAR | 22 | ||
235 | .INCLU--AP | 0 | ||||
236 | FSH_SEASON_YEAR | Season Year | CHAR | 4 | ||
237 | FSH_SEASON | Season | CHAR | 10 | ||
238 | FSH_COLLECTION | Fashion Collection | CHAR | 10 | * | |
239 | FSH_THEME | Fashion Theme | CHAR | 10 | ||
240 | .INCLU--AP | 0 | ||||
241 | FONDS | Fund | CHAR | 10 | * | |
242 | FISTL | Funds Center | CHAR | 16 | * | |
243 | FKBER | Functional Area | CHAR | 16 | * | |
244 | GRANT_NBR | Grant | CHAR | 20 | ||
245 | BUDGET_PD | Budget Period | CHAR | 10 | * | |
246 | .INCLU--AP | 0 | ||||
247 | .INCLUDE | 0 | ||||
248 | J_3GBELNRI | Document Number | CHAR | 10 | J_3GBELK | |
249 | J_3GPMAUFE | PM Order Number (Owner) | CHAR | 12 | AUFK | |
250 | J_3GPMAUFV | PM Order Number (Administrator) | CHAR | 12 | AUFK | |
251 | J_3GETYPA | Sending Recipient Type | CHAR | 2 | * | |
252 | J_3GETYPE | Receiving Recipient Type | CHAR | 2 | * | |
253 | J_3GORGUEB | Indicator: Across All Organizational Structures | CHAR | 1 | ||
254 | .INCLU--AP | 0 | ||||
255 | OIEDOK | Updated information in related user data field | CHAR | 1 | ||
256 | .INCLUDE | 0 | ||||
257 | OID_EXTBOL | External bill of lading | CHAR | 16 | ||
258 | OID_MISCDL | Miscellaneous delivery number | CHAR | 16 | ||
259 | .INCLUDE | 0 | ||||
260 | OIPIPEVAL | Validation indicator for pipeline fields (X=ON | CHAR | 1 | ||
261 | OIC_LIFNR | Account Number of Vendor or Creditor | CHAR | 10 | LFA1 | |
262 | .INCLUDE | 0 | ||||
263 | OIC_DCITYC | Destination city code | CHAR | 4 | T005G | |
264 | OIC_DCOUNC | Destination county code | CHAR | 3 | T005E | |
265 | OIC_DREGIO | Destination region | CHAR | 3 | T005S | |
266 | OIC_DLAND1 | Destination country | CHAR | 3 | T005 | |
267 | OIC_OCITYC | Origin city code | CHAR | 4 | T005G | |
268 | OIC_OCOUNC | Origin county code | CHAR | 3 | T005E | |
269 | OIC_OREGIO | Origin region | CHAR | 3 | T005S | |
270 | OIC_OLAND1 | Origin country | CHAR | 3 | T005 | |
271 | OIC_PORGIN | Tax origin | CHAR | 15 | ||
272 | OIC_PDESTN | Tax destination | CHAR | 15 | ||
273 | OIC_PTRIP | Pipeline trip number (external) | CHAR | 16 | ||
274 | OIC_PBATCH | Pipeline operators external batch number | CHAR | 16 | ||
275 | OIC_MOT | IS-OIL MAP external details mode of transport | CHAR | 2 | TVTR | |
276 | OIC_AORGIN | Alternate origin | CHAR | 15 | ||
277 | OIC_ADESTN | Alternate destination | CHAR | 15 | ||
278 | OIC_TRUCKN | Truck number | CHAR | 10 | ||
279 | OIA_BASELO | Base location | CHAR | 15 | ||
280 | CMETH | Checkbox | CHAR | 1 | ||
281 | OITAXFROM | Excise duty tax key for 'from' location | CHAR | 2 | OIH4 | |
282 | OIHANTYP | Excise Duty Handling Type | CHAR | 2 | OIH5 | |
283 | OITAXGRP | Excise Duty Group | CHAR | 2 | OIH2 | |
284 | OITAXTO | Excise duty tax key for 'to' location | CHAR | 2 | OIH4 | |
285 | OICERTF1 | Excise tax external license number | CHAR | 15 | ||
286 | OIOILCON | Oil content in a material as a percentage | DEC | 5 | ||
287 | OIDATFM1 | Excise Duty License Valid from Date | DATS | 8 | ||
288 | OIDATTO1 | Valid to date for excise duty tax certificate | DATS | 8 | ||
289 | OIEDBAL | Updated information in related user data field | CHAR | 1 | ||
290 | OIPRICIE | ED pricing: external (indicator) | CHAR | 1 | ||
291 | OIINEX | Updated information in related user data field | CHAR | 2 | OIH16 | |
292 | OIEDBALM | Updated information in related user data field | CHAR | 1 | ||
293 | OITAXLOD | Excise duty tax value for goods loading | CURR | 13 | ||
294 | OITAXISS | Excise duty value for goods issue | CURR | 13 | ||
295 | OITAXINV | Excise duty tax value for an invoice | CURR | 13 | ||
296 | OIDRC | Updated information in related user data field | CHAR | 5 | * | |
297 | OIC_DRCTRY | Single-Character Flag | CHAR | 3 | * | |
298 | OIC_DRCREG | Single-Character Flag | CHAR | 3 | * | |
299 | OIMETIND | Single-Character Flag | CHAR | 4 | * | |
300 | OIWAP | Single-Character Flag | CHAR | 3 | * | |
301 | OISLF | Single-Character Flag | CHAR | 3 | * | |
302 | OIPSDRC | Single-Character Flag | CHAR | 5 | * | |
303 | OICONTNR | Single-Character Flag | CHAR | 10 | ||
304 | OIC_KMPOS | Single-Character Flag | NUMC | 6 | ||
305 | OIC_TIME | Single-Character Flag | TIMS | 6 | ||
306 | OIC_DATE | Date for time pricing | DATS | 8 | ||
307 | OIFEECH | Updated information in related user data field | CHAR | 1 | ||
308 | .INCLUDE | 0 | ||||
309 | OIEXGNUM | Exchange agreement number | CHAR | 10 | ||
310 | OIEXGTYP | Exchange type | CHAR | 4 | TOIA2 | |
311 | OIFEETOT | Fee total | CURR | 13 | ||
312 | OIFEEDT | Fee pricing condition date | DATS | 8 | ||
313 | OINETCYC | Netting cycle (FI blocking indicator) | CHAR | 1 | T008 | |
314 | OIH_LICTP | License type | CHAR | 4 | OIH20 | |
315 | OIH_LICIN | Excise tax internal license number | CHAR | 10 | OIHL | |
316 | OIH_LCFOL | Follow-on license for quantity license | CHAR | 10 | OIHL | |
317 | OIH_FOLQTY | Excise Tax Follow-On License Quantity | QUAN | 13 | ||
318 | OIPBL | Updated information in related user data field | CHAR | 10 | OIFSPBL | |
319 | OISBREL | Sub product/ base product relevence indicator | NUMC | 3 | ||
320 | OIBASPROD | Base product number | CHAR | 40 | * | |
321 | OITITLE | Location of title transfer for Incoterms purposes | CHAR | 1 | ||
322 | OIGNRULE | Single-Character Flag | NUMC | 3 | * | |
323 | OIA_IPMVAT | Updated information in related user data field | CHAR | 1 | ||
324 | .INCLUDE | 0 | ||||
325 | OIINVCYC1 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
326 | OIINVCYC2 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
327 | OIINVCYC3 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
328 | OIINVCYC4 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
329 | OIINVCYC5 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
330 | OIINVCYC6 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
331 | OIINVCYC7 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
332 | OIINVCYC8 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
333 | OIINVCYC9 | Invoice cycle indicator active (X/ ) | CHAR | 1 | ||
334 | OILIKWTF | Open delivery credit value transferred during billing | CURR | 19 | ||
335 | OILIMETF | Open delivery quantity transferred during billing | QUAN | 15 | ||
336 | OIFKIMG | Actual billed quantity | QUAN | 13 | ||
337 | OISMENG | Scale quantity in base unit of measure | QUAN | 13 | ||
338 | OIFKLMG | Billing quantity in stockkeeping unit | QUAN | 13 | ||
339 | OILMENG | Required quantity for mat.management in stockkeeping units | QUAN | 13 | ||
340 | OINTGEW | Net weight | QUAN | 15 | ||
341 | OIBRGEW | Gross weight | QUAN | 15 | ||
342 | OIVOLUM | Volume | QUAN | 15 | ||
343 | OIHFOLQTY | Excise tax follow-on license quantity | QUAN | 13 | ||
344 | OIVMENG | Req. quantity for mat.management in base uom (stand. conv.) | QUAN | 13 | ||
345 | .INCLUDE | 0 | ||||
346 | OISTYP | Service type | CHAR | 4 | * | |
347 | OIRELPCGROUP | Location Payment Card Grouping | CHAR | 4 | * | |
348 | .INCLU--AP | 0 | ||||
349 | OIU_RUN_TKT_NO | was OIU_RUN_TKT_NO | CHAR | 7 | ||
350 | OIU_A_H_VAL_FCT | was OIU_ACT_HEAT_VAL_FCT | QUAN | 13 | ||
351 | OIU_A_H_VAL_F_U | was OIU_MEAS_U | UNIT | 3 | ||
352 | OIU_GRV_AM | was OIB_BDICH | FLTP | 16 | ||
353 | OIU_DENSITY_U | was OIB_BHVEH | UNIT | 3 | ||
354 | OIU_SALE_DT_FROM | was OIU_SA_DT_FROM | DATS | 8 | ||
355 | OIU_SALE_DT_TO | was OIU_SA_DT_TO | DATS | 8 | ||
356 | OIU_PC_WC_NO | was OIU_WC_NO | CHAR | 5 | ||
357 | OIU_PC_MP_NO | was OIU_MP_NO | CHAR | 20 | ||
358 | OIU_PC_WL_NO | was OIU_WL_NO | CHAR | 15 | ||
359 | OIU_DENSTYP | was OIU_DENSTYP | CHAR | 1 | ||
360 | OIU_VLTXNS_NO | was OIU_VLTXNS_NO | NUMC | 12 | ||
361 | OIU_POS_NO | was OIU_POS_NO | NUMC | 3 | ||
362 | OIU_TRNSP_NO | was OIU_TRNSP_NO | CHAR | 10 | ||
363 | OIU_TRNSP_REF_NO | was OIU_TRNSP_REF_NO | CHAR | 25 | ||
364 | OIU_ORIG_MP_NO | was OIU_ORIG_MP_NO | CHAR | 20 | ||
365 | .INCLU--AP | 0 | ||||
366 | PRS_WORK_PERIOD | Work Period (Internal Representation) | NUMC | 7 | ||
367 | .INCLU--AP | 0 | ||||
368 | PPRCTR | Partner Profit Center | CHAR | 10 | * | |
369 | PARGB | Trdg part.BA | CHAR | 4 | * | |
370 | .INCLU--AP | 0 | ||||
371 | AUFPL_OAA | Routing number of operations in the order | NUMC | 10 | ||
372 | APLZL_OAA | Internal counter | NUMC | 8 | ||
373 | .INCLU--AP | 0 | ||||
374 | CAMPAIGN | Updated information in related user data field | RAW | 16 | ||
375 | .INCLU--AP | 0 | ||||
376 | COMPREAS | Abbreviation for Complaints Reason | CHAR | 4 | ||
377 | .INCLU--AP | 0 | ||||
378 | WRF_CHARSTC1 | Characteristic Value 1 | CHAR | 18 | ||
379 | WRF_CHARSTC2 | Characteristic Value 2 | CHAR | 18 | ||
380 | WRF_CHARSTC3 | Characteristic Value 3 | CHAR | 18 |
SAP Help, Wiki Resources, and Forum Discussions on VBRP
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Joining VBRK, VBRP, VBAK, VBAP, LIKP, LIPS | SCN
I just wanted to ask how to join the above subject in one table? Or it isnt possible?
http://scn.sap.com/thread/493171
-
Where to make the change to update VBRP-TXJCD ? | SCN
Hi, do you know how the VBRP-TXJCD (Tax Juridiction code in Billing ) get updated? Which program, function and method?
http://scn.sap.com/message/2873219
-
How can I link table KONV with table VBRP and VBRK using KSCHL field?
How can I link table KONV with table VBRP/VBRK using KSCHL field so that items are fully filtered?
http://scn.sap.com/message/8856256
-
VBRP-TXJCD | SCN
I tested this in my own system, it works. So I would expect same result comes to you.
http://scn.sap.com/message/2875190
-
Difference in Billing Exchange rate(VBRP-KURSK) w.r.t OB08
I'm facing the issue with the exchange rate (VBRP-KURSK) .I know this is the Document currency for Price determination which depends on the setting of TVCPFLP-PFKUR in copy control. Right?
http://scn.sap.com/message/7684250
-
Performance issue with join VBRK & VBRP & KNVV
i wrote a select statement with 2 joins on 3 tables... & also 1 join on VBRK & VBRP and For all entries on KNVV...
http://scn.sap.com/message/8417895
-
VBRP and bkpf - table relation. | SCN
I am looking for a relation between VBRP and bkpf. I was originally looking for vbeln and xblnr, but they are not the same.
http://scn.sap.com/message/3652297
-
2LIS_13_VDITM & VBRP data issue | SCN
I am trying to extract a data for particular customer (sold to party) for particular Bill date.
http://scn.sap.com/message/10183637
-
Relation field between table VBRK/VBRP and BSEG | SCN
Can any body guide on the common fields between VBRK/ VBRP and BSEG, except field "assignment".
http://scn.sap.com/message/6670731
-
How to connect vbrk,vttk,VBRP | SCN
could you tell me how would I connect vbrk ,vttk, VBRP ..i am very new to sap..i dont know how would I connect them in my where clause and which field do I need to select. I need to show all these fields: in vbrk i need the fkdat,vbeln vttk i need the tknum,exti1,exti2 VBRP i need the fkimg in my selection-screen fields are from vbrk ,VBRP and kna1. i have to make a report based on bill...
http://scn.sap.com/message/13232837
-
Time Out error on Select from VBRP | SCN
We get a time out error on Select from VBRP even though we do not have much data.
http://scn.sap.com/message/6240812
Related Tables
TABLE | Description | Functional Area |
---|---|---|
VBRK | Billing Document: Header Data | SD - Billing |
VBAK | Sales Document: Header Data | SD - Sales |
LIPS | SD document: Delivery: Item data | Logistics Execution - Shipping |
LIKP | SD Document: Delivery Header Data | Logistics Execution - Shipping |
VBFA | Sales Document Flow | SD - Basic Functions |
KONV | Conditions (Transaction Data) | SD - Conditions |
VBPA | Sales Document: Partner | SD - Basic Functions |
Transaction Codes for SAP Table VBRP
TCODE | Description | Functional Area |
---|---|---|
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
VTFL | Delivery to bill copying control | SD - Basic Functions |
VF01 | Create Billing Document | SD - Billing |
VA01 | Create Sales Order | SD - Sales |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
SE16 | Data Browser | Basis - Workbench Utilities |
SLIS | FI-SL Spec.Purpose Ledg. Info.System | FI - Information System |
VBKD | Bonus Buy: Condition Types | SD - Free Goods |
FMs for SAP Table VBRP
FM | Description | Functional Area |
---|---|---|
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
REUSE_ALV_EVENTS_GET | Returns table of possible events for a list type | BC - SAP List Viewer |
REUSE_ALV_LIST_DISPLAY | Output a simple list (single line or several lines) | BC - SAP List Viewer |
REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table | BC - SAP List Viewer |
READ_TEXT | SAPscript: Read text | BC - SAPscript |
F4_FILENAME | F4 for filename / Filemanager support to locate file in a directory | PM - Plant Maintenance |
CONVERSION_EXIT_ALPHA_INPUT | Conversion exit ALPHA, external->internal | Basis - Syntax, Compiler, Runtime |
ABAP Reports for SAP Table VBRP
ABAP REPORT | Description | Functional Area |
---|---|---|
RV60AFZC | User Exit for Billing | SD - Material Maintenance |
SAPMV60A | Processing Billing Documents | SD - Billing |
SPRSL | TEXT | 630 - Workbench Tools: Editors |
SAPMV45A | Sales Order Processing | SD - Sales |
RVADIN01 | Print program for invoices | SD - Basic Functions |
RSCONN01 | SAPconnect: Start Send Process | Basis - Communication Services: Mail, Fax, SMS, Telephony |
MV45AFZB | User Exits | SD - Material Maintenance |
RV61AFZB | Modifications | SD - Material Maintenance |
BW Datasources for SAP Table VBRP
BW DATASOURCE | Description | Functional Area |
---|---|---|
2LIS_13_VDITM | Billing Document Item Data | SD - Sales and Distribution |
2LIS_11_VAITM | Sales Document Item Data | SD - Sales and Distribution |
2LIS_13_VDHDR | Billing Doc. Header Data | SD - Sales and Distribution |
2LIS_12_VCITM | Delivery Item Data | SD - Sales and Distribution |
2LIS_11_VAHDR | Sales Document Header Data | SD - Sales and Distribution |
2LIS_13_VDKON | Billing Document Condition | SD - Sales and Distribution |
0FI_AR_4 | Customers: Line Items with Delta Extraction | FI - Accounts Receivable |
2LIS_11_V_ITM | Sales-Shipping Allocation Item Data | SD - Sales and Distribution |
Authorization Objects for SAP Table VBRP
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
V_VBAK_VKO | Sales Document: Authorization for Sales Areas | |
P_PERNR | HR: Master Data - Personnel Number Check | |
S_CARRID | Authorization Object for Airlines | |
I_TCODE | PM: Transaction Code | |
J_1IRG23D | Authorisation object for Depo Transactions | |
V_VBRK_VKO | Billing: Authorization for Sales Organizations | |
E_GRID | Authorization Object for Grid |
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