SAP ABAP View WB2_V_VBRK_VBRL2 (Data Selection from Cust. Billing Doc. Lists (without 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_VBRL2
Short Description	Data Selection from Cust. Billing Doc. Lists (without WBGT)
Root table	VBRK	Billing Document: Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBRK	VBRK
2	VBRL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBRL	MANDT	JL	EQ				0	0
2	VBRK	MANDT	JR	EQ			AND	0	0
3	VBRL	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	VBRL	MANDT		☐	MANDT	☐	Client
4	VBELN_I	VBRL	VBELN		☐	VBELN_RL	☐	Invoice list
5	POSNR_I	VBRL	POSNR		☐	POSNR_RL	☐	Invoice list 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	VBELN_VF_I	VBRL	VBELN_VF		☐	VBELN_VF	☐	Billing document
99	NETWR_I	VBRL	NETWR		☐	NETWR	☐	Net Value in Document Currency
100	MWSBP_I	VBRL	MWSBP		☐	MWSBP	☐	Tax amount in document currency
101	KWERT_RL_I	VBRL	KWERT_RL		☐	KWERT_RL	☐	Value of Remuneration List Condition of Indiv. Billing Doc.
102	MWSBP_RL_I	VBRL	MWSBP_RL		☐	MWSBP_RL	☐	Amount of Tax in Remuneration List Condition
103	KUNAG_I	VBRL	KUNAG		☐	KUNAG	☐	Sold-to party
104	UVPRS_I	VBRL	UVPRS		☐	UVPRS	☐	Incomplete with respect to pricing
105	LOGSYS_I	VBRL	LOGSYS		☐	LOGSYS	☐	Logical system

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	20130529
SAP Release Created in	46C