SAP ABAP View WB2_V_WBRK_WBRL2 (Data Selection from Agency Document 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_WBRK_WBRL2
Short Description	Data Selection from Agency Document Lists (without WBGT)
Root table	WBRK	Agency business: Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WBRK	WBRK
2	WBRL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WBRL	MANDT	JL	EQ				0	0
2	WBRK	MANDT	JR	EQ			AND	0	0
3	WBRL	WBELN	JL	EQ				0	0
4	WBRK	WBELN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	WBRK	MANDT		☐	MANDT	☐	Client
2	WBELN	WBRK	WBELN		☐	WBELN_AG	☐	Agency Business: Document Number
3	MANDT_I	WBRL	MANDT		☐	MANDT	☐	Client
4	WBELN_I	WBRL	WBELN		☐	WBELN_RL	☐	Agency Business: Document Number of Remuneration List
5	POSNR_I	WBRL	POSNR		☐	WPOSNR_RL	☐	Agency business: Item in list
6	LFART	WBRK	LFART		☐	WFART	☐	Agency business: Billing document type
7	LFTYP	WBRK	LFTYP		☐	WFTYP	☐	Agency business: Billing category
8	WRART	WBRK	WRART		☐	WRART	☐	Agency business: Payment type
9	WBTYP	WBRK	WBTYP		☐	WBTYP	☐	Settlement request: Payment type
10	WRTYP	WBRK	WRTYP		☐	WRTYP	☐	Entry category: payment
11	ABART	WBRK	ABART		☐	NAFKT	☐	Settlement Type
12	KALSM	WBRK	KALSM		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
13	KALSMD	WBRK	KALSMD		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
14	WFDAT	WBRK	WFDAT		☐	WFDAT	☐	Agency business: Posting date
15	RFBSK	WBRK	RFBSK		☐	WFBSK	☐	Status for transfer to accounting
16	LIFRE	WBRK	LIFRE		☐	LIFRE	☐	Different Invoicing Party
17	LNRZB	WBRK	LNRZB		☐	W_LIFZE	☐	Agency business: Payee
18	KUNRE	WBRK	KUNRE		☐	KUNRE	☐	Bill-to party
19	KUNRG	WBRK	KUNRG		☐	KUNRG	☐	Payer
20	EKORG	WBRK	EKORG		☐	EKORG	☐	Purchasing organization
21	VKORG	WBRK	VKORG		☐	VKORG	☐	Sales Organization
22	VTWEG	WBRK	VTWEG		☐	VTWEG	☐	Distribution Channel
23	SPART	WBRK	SPART		☐	SPART	☐	Division
24	BUKRS	WBRK	BUKRS		☐	BUKRS	☐	Company Code
25	ERZET	WBRK	ERZET		☐	ERZET	☐	Entry time
26	ERDAT	WBRK	ERDAT		☐	ERDAT	☐	Date on which the record was created
27	ERNAM	WBRK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
28	AEDAT	WBRK	AEDAT		☐	AEDAT	☐	Last Changed On
29	BLDAT	WBRK	BLDAT		☐	BLDAT	☐	Document Date in Document
30	XBLNR	WBRK	XBLNR		☐	XBLNR1	☐	Reference Document Number
31	ZUONR	WBRK	ZUONR		☐	DZUONR	☐	Assignment number
32	WAERL	WBRK	WAERL		☐	WAERL	☐	Currency of Agency Document
33	WSTWAE	WBRK	WSTWAE		☐	WSTWAE	☐	Agency Business: Statistics Currency
34	WKURS	WBRK	WKURS		☐	WKURS	☐	Exchange Rate
35	STCUR	WBRK	STCUR		☐	STCUR	☐	Exchange rate for statistics
36	KUFIX	WBRK	KUFIX		☐	WKUFIX	☐	Indicator: Fixing of exchange rate
37	WKURS_DAT	WBRK	WKURS_DAT		☐	WWERT_D	☐	Translation date
38	BRTWR	WBRK	BRTWR		☐	BRTWR_LF	☐	Agenncy Business: Gross value in document currency
39	ZTERM	WBRK	ZTERM		☐	DZTERM	☐	Terms of payment key
40	ZBD1T	WBRK	ZBD1T		☐	DZBDET	☐	Cash (Prompt Payment) Discount Days
41	ZBD1P	WBRK	ZBD1P		☐	DZBD1P	☐	Cash discount percentage 1
42	ZBD2T	WBRK	ZBD2T		☐	DZBD2T	☐	Cash discount days 2
43	ZBD2P	WBRK	ZBD2P		☐	DZBD2P	☐	Cash Discount Percentage 2
44	ZBD3T	WBRK	ZBD3T		☐	DZBD3T	☐	Net Payment Terms Period
45	ZLSCH	WBRK	ZLSCH		☐	DZLSCH	☐	Payment method
46	NETWR	WBRK	NETWR		☐	NETWR_LF	☐	Agency Business: Net value in document currency
47	NETWRD	WBRK	NETWRD		☐	NETWRD_LF	☐	Agency value: Net Value in Document Currency (Customer-Side)
48	BRTWRD	WBRK	BRTWRD		☐	BRTWRD_LF	☐	Agency Business: Gross Value of Doc.Currency (Customr-Side)
49	ZTERMD	WBRK	ZTERMD		☐	WZTERMD	☐	Terms of Payment Key for Customer
50	ZBD1TD	WBRK	ZBD1TD		☐	WZBD1TD	☐	Cash Discount Period for Customer
51	ZBD1PD	WBRK	ZBD1PD		☐	WZBD1PD	☐	Cash discount percentage 1 customer
52	ZBD2TD	WBRK	ZBD2TD		☐	WZBD2TD	☐	Cash discount period 2 customer
53	ZBD2PD	WBRK	ZBD2PD		☐	WZBD2PD	☐	Cash Discount Percentage 2 Customer
54	ZBD3TD	WBRK	ZBD3TD		☐	WZBD3TD	☐	Deadline for Customer Net Condition
55	ZLSCHD	WBRK	ZLSCHD		☐	SCHZW_BSEGD	☐	Customer payment method
56	GSKTOD	WBRK	GSKTOD		☐	SKFBP	☐	Amount eligible for cash discount in document currency
57	GSKTO	WBRK	GSKTO		☐	SKFBP	☐	Amount eligible for cash discount in document currency
58	FKSTO	WBRK	FKSTO		☐	FKSTO	☐	Billing document is cancelled
59	KAPPL	WBRK	KAPPL		☐	KAPPL	☐	Application
60	KNUMV	WBRK	KNUMV		☐	KNUMV	☐	Number of the document condition
61	KNUMVD	WBRK	KNUMVD		☐	KNUMV	☐	Number of the document condition
62	STAFO	WBRK	STAFO		☐	STAFO	☐	Update group for statistics update
63	LFAKS	WBRK	LFAKS		☐	LFAKS	☐	Agency business: cancelled (reversed) document
64	KNUMA	WBRK	KNUMA		☐	KNUMA	☐	Agreement (various conditions grouped together)
65	LFART_RL	WBRK	LFART_RL		☐	WFART_RL	☐	Remuneration List Type, Vendor Billing Document
66	WFDAT_RL	WBRK	WFDAT_RL		☐	WFDAT_RL	☐	Agency Business: Posting Date for the Remuneration List
67	WBELN_RL	WBRK	WBELN_RL		☐	WBELN_RL	☐	Agency Business: Document Number of Remuneration List
68	EKGRP	WBRK	EKGRP		☐	EKGRP	☐	Purchasing group
69	VALTG	WBRK	VALTG		☐	WVALTG	☐	Additional value days
70	VALDT	WBRK	VALDT		☐	WVALDT	☐	Fixed Value Date
71	MWSBK	WBRK	MWSBK		☐	MWSBP	☐	Tax amount in document currency
72	MWSBKD	WBRK	MWSBKD		☐	MWSBPD	☐	Tax amount in document currency (customer-side)
73	NAVNK	WBRK	NAVNK		☐	NAVNW	☐	Non-deductible input tax
74	LOGSYS	WBRK	LOGSYS		☐	LOGSYS	☐	Logical system
75	DIEKZ	WBRK	DIEKZ		☐	DIEKZ	☐	Service indicator (foreign payment)
76	LANDL	WBRK	LANDL		☐	LANDL	☐	Supplying Country
77	LZBKZ	WBRK	LZBKZ		☐	LZBKZ	☐	State central bank indicator
78	KKBER	WBRK	KKBER		☐	KKBER	☐	Credit control area
79	LFGRU	WBRK	LFGRU		☐	WFGRU	☐	Agency business: Reason for activity
80	VALTGD	WBRK	VALTGD		☐	WVALTD	☐	Additional Value Days (Customer)
81	VALDTD	WBRK	VALDTD		☐	WVALDD	☐	Fixed Value Date (Customer)
82	KIDNO	WBRK	KIDNO		☐	KIDNO	☐	Payment Reference
83	WDTYP	WBRK	WDTYP		☐	DOCTYPE	☐	Agency Business: Document Category
84	WKURS_P1	WBRK	WKURS_P1		☐	WKURS_P1	☐	Agency business: Exchange rate of vendor payment currency
85	WKURS_P2	WBRK	WKURS_P2		☐	WKURS_P2	☐	Agency business: Exchange rate of customer payment currency
86	WPYCUR_P1	WBRK	WPYCUR_P1		☐	WPYCUR_P1	☐	Currency for automatic payment (vendor-side)
87	WPYCUR_P2	WBRK	WPYCUR_P2		☐	WPYCUR_P2	☐	Currency for automatic payment (customer-side)
88	ESTATUS	WBRK	ESTATUS		☐	WSTATE	☐	Agency business: Application status
89	KURST	WBRK	KURST		☐	KURST	☐	Exchange Rate Type
90	VKBUR	WBRK	VKBUR		☐	VKBUR	☐	Sales office
91	VKGRP	WBRK	VKGRP		☐	VKGRP	☐	Sales group
92	EXP_CLASS	WBRK	EXP_CLASS		☐	WB2_EXPENSE_CLASS	☐	GT Expenses: Expense Class
93	EXP_CALC_TYPE	WBRK	EXP_CALC_TYPE		☐	WB2_EXPENSE_CALC_TYPE	☐	GT Expenses: Calculation Type
94	SETTLE_DOC	WBRK	SETTLE_DOC		☐	WLF_EXP_SETTLE_DOC	☐	Global Trade Expenses: Settlement Document
95	DOC_SETTLED	WBRK	DOC_SETTLED		☐	WB2_EXP_DOCUMENT_SETTLED	☐	GT Expenses: Document Settled
96	WBELN_LF_I	WBRL	WBELN_LF		☐	WBELN_LF	☐	Agency Business: Document Number
97	NETWR_I	WBRL	NETWR		☐	NETWR_RL	☐	Agency business: New value of item in a list
98	MWSBP_I	WBRL	MWSBP		☐	MWSBPK	☐	Tax amount in document currency
99	NAVNW_I	WBRL	NAVNW		☐	NAVNW	☐	Non-deductible input tax
100	KWERT_RL_I	WBRL	KWERT_RL		☐	WKWERT_RL	☐	Value of the Remuneration List Condition of a Document
101	MWSBP_RL_I	WBRL	MWSBP_RL		☐	WMWSBP_RL	☐	Tax of Remuneration List Conditions
102	LIFRE_I	WBRL	LIFRE		☐	LIFRE	☐	Different Invoicing Party
103	LNRZB_I	WBRL	LNRZB		☐	W_LIFZE	☐	Agency business: Payee
104	KUNRE_I	WBRL	KUNRE		☐	KUNRE	☐	Bill-to party
105	KUNRG_I	WBRL	KUNRG		☐	KUNRG	☐	Payer
106	LFTYP_I	WBRL	LFTYP		☐	WFTYP	☐	Agency business: Billing category
107	LOGSYS_I	WBRL	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