SAP ABAP View WB2_V_VBRK_VBRP2 (Data Selection from Customer Billing Documents (w/o WBGT))
Hierarchy
EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   LO-GT-TEW (Application Component) Trading Execution Workbench
     WB2B_TEW (Package) Trading Execution Workbench
Basic Data
View Type D Database View 
Database View WB2_V_VBRK_VBRP2  
Short Description Data Selection from Customer Billing Documents (w/o WBGT)    
Root table VBRK   Billing Document: Header Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VBRK VBRK
2 VBRP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VBRP MANDT JL EQ 0 0
2 VBRK MANDT JR EQ AND 0 0
3 VBRP VBELN JL EQ 0 0
4 VBRK VBELN JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VBRK MANDT   MANDT Client
2 VBELN VBRK VBELN   VBELN_VF Billing document
3 MANDT_I VBRP MANDT   MANDT Client
4 VBELN_I VBRP VBELN   VBELN_VF Billing document
5 POSNR_I VBRP POSNR   POSNR_VF Billing item
6 FKART VBRK FKART   FKART Billing Type
7 FKTYP VBRK FKTYP   FKTYP Billing Category
8 VBTYP VBRK VBTYP   VBTYP SD document category
9 WAERK VBRK WAERK   WAERK SD document currency
10 VKORG VBRK VKORG   VKORG Sales Organization
11 VTWEG VBRK VTWEG   VTWEG Distribution Channel
12 KALSM VBRK KALSM   KALSMASD Sales and Distribution: Pricing Procedure in Pricing
13 KNUMV VBRK KNUMV   KNUMV Number of the document condition
14 VSBED VBRK VSBED   VSBED Shipping conditions
15 FKDAT VBRK FKDAT   FKDAT Billing date for billing index and printout
16 BELNR VBRK BELNR   BELNR_D Accounting Document Number
17 GJAHR VBRK GJAHR   GJAHR Fiscal Year
18 POPER VBRK POPER   POPER Posting period
19 KONDA VBRK KONDA   KONDA Price Group (Customer)
20 KDGRP VBRK KDGRP   KDGRP Customer group
21 BZIRK VBRK BZIRK   BZIRK Sales district
22 PLTYP VBRK PLTYP   PLTYP Price list type
23 INCO1 VBRK INCO1   INCO1 Incoterms (part 1)
24 INCO2 VBRK INCO2   INCO2 Incoterms (part 2)
25 EXPKZ VBRK EXPKZ   EXPKZ Export indicator
26 RFBSK VBRK RFBSK   RFBSK Status for transfer to accounting
27 MRNKZ VBRK MRNKZ   MRNKZ Manual invoice maintenance
28 KURRF VBRK KURRF   KURRF Exchange rate for FI postings
29 CPKUR VBRK CPKUR   CPKUR ID:Exchange rate setting (no new rate determ.in bill.doc.)
30 VALTG VBRK VALTG   VALTG Additional value days
31 VALDT VBRK VALDT   VALDT Fixed value date
32 ZTERM VBRK ZTERM   DZTERM Terms of payment key
33 ZLSCH VBRK ZLSCH   SCHZW_BSEG Payment Method
34 KTGRD VBRK KTGRD   KTGRD Account assignment group for this customer
35 LAND1 VBRK LAND1   LLAND Destination Country
36 REGIO VBRK REGIO   REGIO Region (State, Province, County)
37 COUNC VBRK COUNC   COUNC County Code
38 CITYC VBRK CITYC   CITYC City Code
39 BUKRS VBRK BUKRS   BUKRS Company Code
40 TAXK1 VBRK TAXK1   TAXK1 Tax classification 1 for customer
41 TAXK2 VBRK TAXK2   TAXK2 Tax classification 2 for customer
42 TAXK3 VBRK TAXK3   TAXK3 Tax classification 3 for customer
43 TAXK4 VBRK TAXK4   TAXK4 Tax classification 4 for customer
44 TAXK5 VBRK TAXK5   TAXK5 Tax classification 5 for customer
45 TAXK6 VBRK TAXK6   TAXK6 Tax classification 6 for customer
46 TAXK7 VBRK TAXK7   TAXK7 Tax classification 7 for customer
47 TAXK8 VBRK TAXK8   TAXK8 Tax classification 8 for customer
48 TAXK9 VBRK TAXK9   TAXK9 Tax classification 9 for customer
49 NETWR VBRK NETWR   NETWR Net Value in Document Currency
50 ZUKRI VBRK ZUKRI   DZUKRI Combination criteria in the billing document
51 ERNAM VBRK ERNAM   ERNAM Name of Person who Created the Object
52 ERZET VBRK ERZET   ERZET Entry time
53 ERDAT VBRK ERDAT   ERDAT Date on which the record was created
54 STAFO VBRK STAFO   STAFO Update group for statistics update
55 KUNRG VBRK KUNRG   KUNRG Payer
56 KUNAG VBRK KUNAG   KUNAG Sold-to party
57 MABER VBRK MABER   MABER Dunning Area
58 STWAE VBRK STWAE   STWAE Statistics currency
59 EXNUM VBRK EXNUM   EXNUM Number of foreign trade data in MM and SD documents
60 STCEG VBRK STCEG   STCEG VAT Registration Number
61 AEDAT VBRK AEDAT   AEDAT Last Changed On
62 SFAKN VBRK SFAKN   SFAKN Cancelled billing document number
63 KNUMA VBRK KNUMA   KNUMA Agreement (various conditions grouped together)
64 FKART_RL VBRK FKART_RL   FKART_RL Invoice list type
65 FKDAT_RL VBRK FKDAT_RL   FKDAT_RL Billing date for the invoice list
66 KURST VBRK KURST   KURST Exchange Rate Type
67 MSCHL VBRK MSCHL   MSCHL Dunning key
68 MANSP VBRK MANSP   MANSP Dunning block
69 SPART VBRK SPART   SPART Division
70 KKBER VBRK KKBER   KKBER Credit control area
71 KNKLI VBRK KNKLI   KNKLI Customer's account number with credit limit reference
72 CMWAE VBRK CMWAE   WAERS_CM Currency key of credit control area
73 CMKUF VBRK CMKUF   CMKUF Credit data exchange rate at billing document rate
74 HITYP_PR VBRK HITYP_PR   HITYP_PR Hierarchy type for pricing
75 BSTNK_VF VBRK BSTNK_VF   BSTKD Customer purchase order number
76 VBUND VBRK VBUND   RASSC Company ID of trading partner
77 FKART_AB VBRK FKART_AB   FKART_AB Accrual billing type
78 KAPPL VBRK KAPPL   KAPPL Application
79 LANDTX VBRK LANDTX   LANDTX Tax Departure Country
80 STCEG_H VBRK STCEG_H   STCEG_H Origin of sales tax ID number
81 STCEG_L VBRK STCEG_L   STCEG_L Country of sales tax ID number
82 XBLNR VBRK XBLNR   XBLNR_V1 Reference Document Number
83 ZUONR VBRK ZUONR   ORDNR_V Assignment Number
84 MWSBK VBRK MWSBK   MWSBP Tax amount in document currency
85 LOGSYS VBRK LOGSYS   LOGSYS Logical system
86 FKSTO VBRK FKSTO   FKSTO Billing document is cancelled
87 XEGDR VBRK XEGDR   XEGDR Indicator: Triangular deal within the EU ?
88 RPLNR VBRK RPLNR   RPLNR Installment Plan Number
89 LCNUM VBRK LCNUM   LCNUM Financial doc. processing: Internal financial doc. number
90 J_1AFITP VBRK J_1AFITP   J_1AFITP_D Tax type
91 KURRF_DAT VBRK KURRF_DAT   WWERT_D Translation date
92 AKWAE VBRK AKWAE   AKWAE Currency key for letter-of-credit procg in foreign trade
93 AKKUR VBRK AKKUR   AKKUR Exchange rate for letter-of-credit procg in foreign trade
94 KIDNO VBRK KIDNO   KIDNO Payment Reference
95 BVTYP VBRK BVTYP   BVTYP Partner bank type
96 NUMPG VBRK NUMPG   J_1ANOPG Number of pages of invoice
97 BUPLA VBRK BUPLA   BUPLA Business Place
98 UEPOS_I VBRP UEPOS   UEPOS Higher-level item in bill of material structures
99 FKIMG_I VBRP FKIMG   FKIMG Actual billed quantity
100 VRKME_I VBRP VRKME   VRKME Sales unit
101 UMVKZ_I VBRP UMVKZ   UMVKZ Numerator (factor) for conversion of sales quantity into SKU
102 UMVKN_I VBRP UMVKN   UMVKN Denominator (divisor) for conversion of sales qty. into SKU
103 MEINS_I VBRP MEINS   MEINS Base Unit of Measure
104 SMENG_I VBRP SMENG   SMENG Scale quantity in base unit of measure
105 FKLMG_I VBRP FKLMG   FKLMG Billing quantity in stockkeeping unit
106 LMENG_I VBRP LMENG   LMENG Required quantity for mat.management in stockkeeping units
107 NTGEW_I VBRP NTGEW   NTGEW_15 Net weight
108 BRGEW_I VBRP BRGEW   BRGEW_15 Gross weight
109 GEWEI_I VBRP GEWEI   GEWEI Weight Unit
110 VOLUM_I VBRP VOLUM   VOLUM_15 Volume
111 VOLEH_I VBRP VOLEH   VOLEH Volume unit
112 GSBER_I VBRP GSBER   GSBER Business Area
113 PRSDT_I VBRP PRSDT   PRSDT Date for pricing and exchange rate
114 FBUDA_I VBRP FBUDA   FBUDA Date When Services Rendered
115 KURSK_I VBRP KURSK   KURSK Exchange Rate for Pricing and Statistics
116 NETWR_I VBRP NETWR   NETWR_FP Net value of the billing item in document currency
117 VBELV_I VBRP VBELV   VBELV Originating document
118 POSNV_I VBRP POSNV   POSNV Originating item
119 VGBEL_I VBRP VGBEL   VGBEL Document number of the reference document
120 VGPOS_I VBRP VGPOS   VGPOS Item number of the reference item
121 VGTYP_I VBRP VGTYP   VBTYP_V Document category of preceding SD document
122 AUBEL_I VBRP AUBEL   VBELN_VA Sales Document
123 AUPOS_I VBRP AUPOS   POSNR_VA Sales Document Item
124 AUREF_I VBRP AUREF   AUREF Sales document was created from reference
125 MATNR_I VBRP MATNR   MATNR Material Number
126 ARKTX_I VBRP ARKTX   ARKTX Short text for sales order item
127 PMATN_I VBRP PMATN   PMATN Pricing Reference Material
128 CHARG_I VBRP CHARG   CHARG_D Batch Number
129 MATKL_I VBRP MATKL   MATKL Material Group
130 PSTYV_I VBRP PSTYV   PSTYV Sales document item category
131 POSAR_I VBRP POSAR   POSAR Item type
132 PRODH_I VBRP PRODH   PRODH_D Product Hierarchy
133 VSTEL_I VBRP VSTEL   VSTEL Shipping Point/Receiving Point
134 ATPKZ_I VBRP ATPKZ   ATPKZ Replacement part
135 SPART_I VBRP SPART   SPART Division
136 POSPA_I VBRP POSPA   POSPA Item number in the partner segment
137 WERKS_I VBRP WERKS   WERKS_D Plant
138 ALAND_I VBRP ALAND   ALAND Departure country (country from which the goods are sent)
139 WKREG_I VBRP WKREG   WKREG Region in which plant is located
140 WKCOU_I VBRP WKCOU   WKCOU County in which plant is located
141 WKCTY_I VBRP WKCTY   WKCTY City in which plant is located
142 TAXM1_I VBRP TAXM1   TAXM1 Tax classification material
143 TAXM2_I VBRP TAXM2   TAXM2 Tax classification material
144 TAXM3_I VBRP TAXM3   TAXM3 Tax classification material
145 TAXM4_I VBRP TAXM4   TAXM4 Tax Classification 4 Material
146 TAXM5_I VBRP TAXM5   TAXM5 Tax classification 5 for material
147 TAXM6_I VBRP TAXM6   TAXM6 Tax classification 6 for material
148 TAXM7_I VBRP TAXM7   TAXM7 Tax classification 7 for material
149 TAXM8_I VBRP TAXM8   TAXM8 Tax Classification 8 Material
150 TAXM9_I VBRP TAXM9   TAXM9 Tax Classification 9 Material
151 KOWRR_I VBRP KOWRR   KOWRR Statistical values
152 PRSFD_I VBRP PRSFD   PRSFD Carry out pricing
153 SKTOF_I VBRP SKTOF   SKTOF Cash discount indicator
154 SKFBP_I VBRP SKFBP   SKFBP Amount eligible for cash discount in document currency
155 KONDM_I VBRP KONDM   KONDM Material Pricing Group
156 KTGRM_I VBRP KTGRM   KTGRM Account assignment group for this material
157 KOSTL_I VBRP KOSTL   KOSTL Cost Center
158 BONUS_I VBRP BONUS   BONUS Volume rebate group
159 PROVG_I VBRP PROVG   PROVG Commission group
160 EANNR_I VBRP EANNR   EANNR European Article Number (EAN) - obsolete!!!!!
161 VKGRP_I VBRP VKGRP   VKGRP Sales group
162 VKBUR_I VBRP VKBUR   VKBUR Sales office
163 SPARA_I VBRP SPARA   SPART_AK Division for order header
164 SHKZG_I VBRP SHKZG   SHKZG_VF Returns item
165 ERNAM_I VBRP ERNAM   ERNAM Name of Person who Created the Object
166 ERDAT_I VBRP ERDAT   ERDAT Date on which the record was created
167 ERZET_I VBRP ERZET   ERZET Entry time
168 BWTAR_I VBRP BWTAR   BWTAR_D Valuation type
169 LGORT_I VBRP LGORT   LGORT_D Storage location
170 STAFO_I VBRP STAFO   STAFO Update group for statistics update
171 WAVWR_I VBRP WAVWR   WAVWR Cost in document currency
172 KZWI1_I VBRP KZWI1   KZWI1 Subtotal 1 from pricing procedure for condition
173 KZWI2_I VBRP KZWI2   KZWI2 Subtotal 2 from pricing procedure for condition
174 KZWI3_I VBRP KZWI3   KZWI3 Subtotal 3 from pricing procedure for condition
175 KZWI4_I VBRP KZWI4   KZWI4 Subtotal 4 from pricing procedure for condition
176 KZWI5_I VBRP KZWI5   KZWI5 Subtotal 5 from pricing procedure for condition
177 KZWI6_I VBRP KZWI6   KZWI6 Subtotal 6 from pricing procedure for condition
178 STCUR_I VBRP STCUR   STCUR_AP Exchange rate for statistics (Exch.rate at time of creation)
179 UVPRS_I VBRP UVPRS   UVPRS Incomplete with respect to pricing
180 UVALL_I VBRP UVALL   UVALL Generally incomplete
181 EAN11_I VBRP EAN11   EAN11 International Article Number (EAN/UPC)
182 PRCTR_I VBRP PRCTR   PRCTR Profit Center
183 KVGR1_I VBRP KVGR1   KVGR1 Customer group 1
184 KVGR2_I VBRP KVGR2   KVGR2 Customer group 2
185 KVGR3_I VBRP KVGR3   KVGR3 Customer group 3
186 KVGR4_I VBRP KVGR4   KVGR4 Customer group 4
187 KVGR5_I VBRP KVGR5   KVGR5 Customer group 5
188 MVGR1_I VBRP MVGR1   MVGR1 Material group 1
189 MVGR2_I VBRP MVGR2   MVGR2 Material group 2
190 MVGR3_I VBRP MVGR3   MVGR3 Material group 3
191 MVGR4_I VBRP MVGR4   MVGR4 Material group 4
192 MVGR5_I VBRP MVGR5   MVGR5 Material group 5
193 MATWA_I VBRP MATWA   MATWA Material entered
194 BONBA_I VBRP BONBA   BONBA Rebate basis 1
195 KOKRS_I VBRP KOKRS   KOKRS Controlling Area
196 PAOBJNR_I VBRP PAOBJNR   RKEOBJNR Profitability Segment Number (CO-PA)
197 PS_PSP_PNR_I VBRP PS_PSP_PNR   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
198 AUFNR_I VBRP AUFNR   AUFNR Order Number
199 TXJCD_I VBRP TXJCD   TXJCD Tax Jurisdiction
200 CMPRE_I VBRP CMPRE   CMPRE Item credit price
201 CMPNT_I VBRP CMPNT   CMPNT ID: Item with active credit function / relevant for credit
202 CUOBJ_I VBRP CUOBJ   CUOBJ_VA Configuration
203 CUOBJ_CH_I VBRP CUOBJ_CH   CUOBJ_CH Internal object number of the batch classification
204 KOUPD_I VBRP KOUPD   KOUPD Condition update
205 UECHA_I VBRP UECHA   UECHA Higher-Level Item of Batch Split Item
206 XCHAR_I VBRP XCHAR   XCHAR Batch management indicator (internal)
207 ABRVW_I VBRP ABRVW   ABRVW Usage Indicator
208 SERNR_I VBRP SERNR   SERNR BOM explosion number
209 BZIRK_AUFT_I VBRP BZIRK_AUFT   BZIRK_AUFT Sales district of sales order
210 KDGRP_AUFT_I VBRP KDGRP_AUFT   KDGRP_AUFT Customer group of sales order
211 KONDA_AUFT_I VBRP KONDA_AUFT   KONDA_AUFT Price group of sales order
212 LLAND_AUFT_I VBRP LLAND_AUFT   LLAND_AUFT Country of destination of sales order
213 MPROK_I VBRP MPROK   MPROK Status manual price change
214 PLTYP_AUFT_I VBRP PLTYP_AUFT   PLTYP_AUFT Price list type of sales order
215 REGIO_AUFT_I VBRP REGIO_AUFT   REGIO_AUFT Region of sales order
216 VKORG_AUFT_I VBRP VKORG_AUFT   VKORG_AUFT Sales organization of sales order
217 VTWEG_AUFT_I VBRP VTWEG_AUFT   VTWEG_AUFT Distribution channel of sales order
218 ABRBG_I VBRP ABRBG   ABRBG Start of accounting settlement period
219 PROSA_I VBRP PROSA   PROSA ID for material selection - active
220 UEPVW_I VBRP UEPVW   UEPVW ID for higher-level item usage
221 AUTYP_I VBRP AUTYP   VBTYP SD document category
222 STADAT_I VBRP STADAT   STADAT Statistics date
223 FPLNR_I VBRP FPLNR   FPLNR Billing plan number / invoicing plan number
224 FPLTR_I VBRP FPLTR   FPLTR Item for billing plan/invoice plan/payment cards
225 AKTNR_I VBRP AKTNR   WAKTION Promotion
226 KNUMA_PI_I VBRP KNUMA_PI   KNUMA_PI Promotion
227 KNUMA_AG_I VBRP KNUMA_AG   KNUMA_AG Sales deal
228 PREFE_I VBRP PREFE   PREFE Preference indicator in export/import
229 MWSBP_I VBRP MWSBP   MWSBP Tax amount in document currency
230 AUGRU_AUFT_I VBRP AUGRU_AUFT   AUGRU Order reason (reason for the business transaction)
231 FAREG_I VBRP FAREG   FAREG Rule in billing plan/invoice plan
232 UPMAT_I VBRP UPMAT   UPMAT Pricing reference material of main item
233 UKONM_I VBRP UKONM   UKONM Material pricing group of main item
234 CMPRE_FLT_I VBRP CMPRE_FLT   CMPRE_FLT Item credit price
235 ABFOR_I VBRP ABFOR   ABSFORM_CM Form of payment guarantee
236 ABGES_I VBRP ABGES   ABGES_CM Guaranteed (factor between 0 and 1)
237 J_1ARFZ_I VBRP J_1ARFZ   J_1ARFZVAT Reason for zero VAT
238 J_1AREGIO_I VBRP J_1AREGIO   REGIO Region (State, Province, County)
239 J_1AGICD_I VBRP J_1AGICD   J_1AGICD_D Activity Code for Gross Income Tax
240 J_1ADTYP_I VBRP J_1ADTYP   J_1ADTYP_D Distribution Type for Employment Tax
241 J_1ATXREL_I VBRP J_1ATXREL   J_1ATXREL_ Tax relevant classification
242 J_1BCFOP_I VBRP J_1BCFOP   J_1BCFOP CFOP code and extension
243 J_1BTAXLW1_I VBRP J_1BTAXLW1   J_1BTAXLW1 Tax law: ICMS
244 J_1BTAXLW2_I VBRP J_1BTAXLW2   J_1BTAXLW2 Tax law: IPI
245 J_1BTXSDC_I VBRP J_1BTXSDC   J_1BTXSDC_ SD tax code
246 BRTWR_I VBRP BRTWR   BRTWR_FP Gross value of the billing item in document currency
247 WKTNR_I VBRP WKTNR   WKTNR Value contract no.
248 WKTPS_I VBRP WKTPS   WKTPS Value contract item
249 RPLNR_I VBRP RPLNR   RPLNR_AU Payment card plan number of sales document
250 KURSK_DAT_I VBRP KURSK_DAT   WWERT_D Translation date
251 WGRU1_I VBRP WGRU1   WGRU_HIE1 Material group hierarchy 1
252 WGRU2_I VBRP WGRU2   WGRU_HIE2 Material group hierarchy 2
253 KDKG1_I VBRP KDKG1   KDKG1 Customer condition group 1
254 KDKG2_I VBRP KDKG2   KDKG2 Customer condition group 2
255 KDKG3_I VBRP KDKG3   KDKG3 Customer condition group 3
256 KDKG4_I VBRP KDKG4   KDKG4 Customer condition group 4
257 KDKG5_I VBRP KDKG5   KDKG5 Customer condition group 5
258 VKAUS_I VBRP VKAUS   ABRVW Usage Indicator
259 J_1AINDXP_I VBRP J_1AINDXP   J_1AINDXP Inflation Index
260 J_1AIDATEP_I VBRP J_1AIDATEP   J_1AIDATES Indexing base date
261 KZFME_I VBRP KZFME   KZFME ID: Leading unit of measure for completing a transaction
262 MWSKZ_I VBRP MWSKZ   MWSKZ Tax on sales/purchases code
263 VERTT_I VBRP VERTT   RANTYP Contract Type
264 VERTN_I VBRP VERTN   RANL Contract Number
265 SGTXT_I VBRP SGTXT   SGTXT Item Text
266 DELCO_I VBRP DELCO   DELCO Agreed delivery time
267 BEMOT_I VBRP BEMOT   BEMOT Accounting Indicator
268 RRREL_I VBRP RRREL   RR_RELTYP Revenue recognition category
269 AKKUR_I VBRP AKKUR   AKKUR Exchange rate for letter-of-credit procg in foreign trade
270 WMINR_I VBRP WMINR   WMINR Product catalog number
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20131127 
SAP Release Created in 46C