SAP ABAP View WB2_V_VBRK_VBRL (Data Selection from Customer Billing Document Lists)

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_VBRL
Short Description	Data Selection from Customer Billing Document Lists
Root table	VBRK	Billing Document: Header Data

Table

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

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			AND	0	0
5	WBGT	MANDT	JL	EQ				0	0
6	VBRK	MANDT	JR	EQ			AND	0	0
7	WBGT	VBELN	JL	EQ				0	0
8	VBRK	VBELN	JR	EQ			AND	0	0
9	WBGT	DOC_TYPE		EQ	'K6'		OR	0	0
10	WBGT	DOC_TYPE		EQ	'K7'		AND	0	0
11	WBGT	POSNR		EQ	'000000'			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	MANDT_W	WBGT	MANDT		☐	MANDT	☐	Client
7	DOC_TYPE_W	WBGT	DOC_TYPE		☐	WB2_DOC_TYPE	☐	Document Type
8	VBELN_W	WBGT	VBELN		☐	WB2_DOCUMENT_NUMBER	☐	General Document Number
9	POSNR_W	WBGT	POSNR		☐	WB2_DOCUMENT_ITEM	☐	Item Number of a Document
10	POSNR_SUB_W	WBGT	POSNR_SUB		☐	WB2_SUB_ITEM	☐	Sub-Item Number of a Document
11	GJAHR_W	WBGT	GJAHR		☐	GJAHR	☐	Fiscal Year
12	FKART	VBRK	FKART		☐	FKART	☐	Billing Type
13	FKTYP	VBRK	FKTYP		☐	FKTYP	☐	Billing Category
14	VBTYP	VBRK	VBTYP		☐	VBTYP	☐	SD document category
15	WAERK	VBRK	WAERK		☐	WAERK	☐	SD document currency
16	VKORG	VBRK	VKORG		☐	VKORG	☐	Sales Organization
17	VTWEG	VBRK	VTWEG		☐	VTWEG	☐	Distribution Channel
18	KALSM	VBRK	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
19	KNUMV	VBRK	KNUMV		☐	KNUMV	☐	Number of the document condition
20	VSBED	VBRK	VSBED		☐	VSBED	☐	Shipping conditions
21	FKDAT	VBRK	FKDAT		☐	FKDAT	☐	Billing date for billing index and printout
22	BELNR	VBRK	BELNR		☐	BELNR_D	☐	Accounting Document Number
23	GJAHR	VBRK	GJAHR		☐	GJAHR	☐	Fiscal Year
24	POPER	VBRK	POPER		☐	POPER	☐	Posting period
25	KONDA	VBRK	KONDA		☐	KONDA	☐	Price Group (Customer)
26	KDGRP	VBRK	KDGRP		☐	KDGRP	☐	Customer group
27	BZIRK	VBRK	BZIRK		☐	BZIRK	☐	Sales district
28	PLTYP	VBRK	PLTYP		☐	PLTYP	☐	Price list type
29	INCO1	VBRK	INCO1		☐	INCO1	☐	Incoterms (part 1)
30	INCO2	VBRK	INCO2		☐	INCO2	☐	Incoterms (part 2)
31	EXPKZ	VBRK	EXPKZ		☐	EXPKZ	☐	Export indicator
32	RFBSK	VBRK	RFBSK		☐	RFBSK	☐	Status for transfer to accounting
33	MRNKZ	VBRK	MRNKZ		☐	MRNKZ	☐	Manual invoice maintenance
34	KURRF	VBRK	KURRF		☐	KURRF	☐	Exchange rate for FI postings
35	CPKUR	VBRK	CPKUR		☐	CPKUR	☐	ID:Exchange rate setting (no new rate determ.in bill.doc.)
36	VALTG	VBRK	VALTG		☐	VALTG	☐	Additional value days
37	VALDT	VBRK	VALDT		☐	VALDT	☐	Fixed value date
38	ZTERM	VBRK	ZTERM		☐	DZTERM	☐	Terms of payment key
39	ZLSCH	VBRK	ZLSCH		☐	SCHZW_BSEG	☐	Payment Method
40	KTGRD	VBRK	KTGRD		☐	KTGRD	☐	Account assignment group for this customer
41	LAND1	VBRK	LAND1		☐	LLAND	☐	Destination Country
42	REGIO	VBRK	REGIO		☐	REGIO	☐	Region (State, Province, County)
43	COUNC	VBRK	COUNC		☐	COUNC	☐	County Code
44	CITYC	VBRK	CITYC		☐	CITYC	☐	City Code
45	BUKRS	VBRK	BUKRS		☐	BUKRS	☐	Company Code
46	TAXK1	VBRK	TAXK1		☐	TAXK1	☐	Tax classification 1 for customer
47	TAXK2	VBRK	TAXK2		☐	TAXK2	☐	Tax classification 2 for customer
48	TAXK3	VBRK	TAXK3		☐	TAXK3	☐	Tax classification 3 for customer
49	TAXK4	VBRK	TAXK4		☐	TAXK4	☐	Tax classification 4 for customer
50	TAXK5	VBRK	TAXK5		☐	TAXK5	☐	Tax classification 5 for customer
51	TAXK6	VBRK	TAXK6		☐	TAXK6	☐	Tax classification 6 for customer
52	TAXK7	VBRK	TAXK7		☐	TAXK7	☐	Tax classification 7 for customer
53	TAXK8	VBRK	TAXK8		☐	TAXK8	☐	Tax classification 8 for customer
54	TAXK9	VBRK	TAXK9		☐	TAXK9	☐	Tax classification 9 for customer
55	NETWR	VBRK	NETWR		☐	NETWR	☐	Net Value in Document Currency
56	ZUKRI	VBRK	ZUKRI		☐	DZUKRI	☐	Combination criteria in the billing document
57	ERNAM	VBRK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
58	ERZET	VBRK	ERZET		☐	ERZET	☐	Entry time
59	ERDAT	VBRK	ERDAT		☐	ERDAT	☐	Date on which the record was created
60	STAFO	VBRK	STAFO		☐	STAFO	☐	Update group for statistics update
61	KUNRG	VBRK	KUNRG		☐	KUNRG	☐	Payer
62	KUNAG	VBRK	KUNAG		☐	KUNAG	☐	Sold-to party
63	MABER	VBRK	MABER		☐	MABER	☐	Dunning Area
64	STWAE	VBRK	STWAE		☐	STWAE	☐	Statistics currency
65	EXNUM	VBRK	EXNUM		☐	EXNUM	☐	Number of foreign trade data in MM and SD documents
66	STCEG	VBRK	STCEG		☐	STCEG	☐	VAT Registration Number
67	AEDAT	VBRK	AEDAT		☐	AEDAT	☐	Last Changed On
68	SFAKN	VBRK	SFAKN		☐	SFAKN	☐	Cancelled billing document number
69	KNUMA	VBRK	KNUMA		☐	KNUMA	☐	Agreement (various conditions grouped together)
70	FKART_RL	VBRK	FKART_RL		☐	FKART_RL	☐	Invoice list type
71	FKDAT_RL	VBRK	FKDAT_RL		☐	FKDAT_RL	☐	Billing date for the invoice list
72	KURST	VBRK	KURST		☐	KURST	☐	Exchange Rate Type
73	MSCHL	VBRK	MSCHL		☐	MSCHL	☐	Dunning key
74	MANSP	VBRK	MANSP		☐	MANSP	☐	Dunning block
75	SPART	VBRK	SPART		☐	SPART	☐	Division
76	KKBER	VBRK	KKBER		☐	KKBER	☐	Credit control area
77	KNKLI	VBRK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
78	CMWAE	VBRK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
79	CMKUF	VBRK	CMKUF		☐	CMKUF	☐	Credit data exchange rate at billing document rate
80	HITYP_PR	VBRK	HITYP_PR		☐	HITYP_PR	☐	Hierarchy type for pricing
81	BSTNK_VF	VBRK	BSTNK_VF		☐	BSTKD	☐	Customer purchase order number
82	VBUND	VBRK	VBUND		☐	RASSC	☐	Company ID of trading partner
83	FKART_AB	VBRK	FKART_AB		☐	FKART_AB	☐	Accrual billing type
84	KAPPL	VBRK	KAPPL		☐	KAPPL	☐	Application
85	LANDTX	VBRK	LANDTX		☐	LANDTX	☐	Tax Departure Country
86	STCEG_H	VBRK	STCEG_H		☐	STCEG_H	☐	Origin of sales tax ID number
87	STCEG_L	VBRK	STCEG_L		☐	STCEG_L	☐	Country of sales tax ID number
88	XBLNR	VBRK	XBLNR		☐	XBLNR_V1	☐	Reference Document Number
89	ZUONR	VBRK	ZUONR		☐	ORDNR_V	☐	Assignment Number
90	MWSBK	VBRK	MWSBK		☐	MWSBP	☐	Tax amount in document currency
91	LOGSYS	VBRK	LOGSYS		☐	LOGSYS	☐	Logical system
92	FKSTO	VBRK	FKSTO		☐	FKSTO	☐	Billing document is cancelled
93	XEGDR	VBRK	XEGDR		☐	XEGDR	☐	Indicator: Triangular deal within the EU ?
94	RPLNR	VBRK	RPLNR		☐	RPLNR	☐	Installment Plan Number
95	LCNUM	VBRK	LCNUM		☐	LCNUM	☐	Financial doc. processing: Internal financial doc. number
96	J_1AFITP	VBRK	J_1AFITP		☐	J_1AFITP_D	☐	Tax type
97	KURRF_DAT	VBRK	KURRF_DAT		☐	WWERT_D	☐	Translation date
98	AKWAE	VBRK	AKWAE		☐	AKWAE	☐	Currency key for letter-of-credit procg in foreign trade
99	AKKUR	VBRK	AKKUR		☐	AKKUR	☐	Exchange rate for letter-of-credit procg in foreign trade
100	KIDNO	VBRK	KIDNO		☐	KIDNO	☐	Payment Reference
101	BVTYP	VBRK	BVTYP		☐	BVTYP	☐	Partner bank type
102	NUMPG	VBRK	NUMPG		☐	J_1ANOPG	☐	Number of pages of invoice
103	BUPLA	VBRK	BUPLA		☐	BUPLA	☐	Business Place
104	VBELN_VF_I	VBRL	VBELN_VF		☐	VBELN_VF	☐	Billing document
105	NETWR_I	VBRL	NETWR		☐	NETWR	☐	Net Value in Document Currency
106	MWSBP_I	VBRL	MWSBP		☐	MWSBP	☐	Tax amount in document currency
107	KWERT_RL_I	VBRL	KWERT_RL		☐	KWERT_RL	☐	Value of Remuneration List Condition of Indiv. Billing Doc.
108	MWSBP_RL_I	VBRL	MWSBP_RL		☐	MWSBP_RL	☐	Amount of Tax in Remuneration List Condition
109	KUNAG_I	VBRL	KUNAG		☐	KUNAG	☐	Sold-to party
110	UVPRS_I	VBRL	UVPRS		☐	UVPRS	☐	Incomplete with respect to pricing
111	LOGSYS_I	VBRL	LOGSYS		☐	LOGSYS	☐	Logical system
112	TKONN_W	WBGT	TKONN		☐	TKONN	☐	Trading Contract: Trading Contract Number
113	TPOSN_W	WBGT	TPOSN		☐	TPOSN	☐	Trading Contract: Item Number
114	TPOSN_SUB_W	WBGT	TPOSN_SUB		☐	TPOSN_SUB	☐	Trading Contract: Sub-Item Number
115	ERNAM_W	WBGT	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
116	ERDAT_W	WBGT	ERDAT		☐	ERDAT	☐	Date on which the record was created
117	TEW_TYPE_W	WBGT	TEW_TYPE		☐	WB2_TEW_TYPE	☐	Trading Execution Workbench Type
118	SCENARIO_W	WBGT	SCENARIO		☐	WB2_BUSINESS_SCENARIO	☐	Business Scenario
119	TKONN_EX_W	WBGT	TKONN_EX		☐	TKONN_EX	☐	Trading Contract: External Document Number
120	COMPLETE_W	WBGT	COMPLETE		☐	WB2_DOCUMENT_COMPLETE_2	☐	Global Trade: Item Closed
121	ERROR_TEW_W	WBGT	ERROR_TEW		☐	WB2B_ERROR_TEW	☐	Global Trade: Error in Follow-On Document Creation
122	BUSINESS_STEP_W	WBGT	BUSINESS_STEP		☐	WB2_STEP	☐	Business Process Step
123	MASTER_STEP_W	WBGT	MASTER_STEP		☐	WB2_MASTER_STEP	☐	Main Step
124	PRE_STEP_W	WBGT	PRE_STEP		☐	WB2_PRE_STEP	☐	Previous Step of Business Process

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