SAP ABAP View WB2_V_WBRK_WBRP (Data Selection from Agency Documents)

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_WBRP
Short Description	Data Selection from Agency Documents
Root table	WBRK	Agency business: Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WBRK	WBRK
2	WBRP
3	WBGT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WBRP	MANDT	JL	EQ				0	0
2	WBRK	MANDT	JR	EQ			AND	0	0
3	WBRP	WBELN	JL	EQ				0	0
4	WBRK	WBELN	JR	EQ			AND	0	0
5	WBGT	MANDT	JL	EQ				0	0
6	WBRK	MANDT	JR	EQ			AND	0	0
7	WBGT	VBELN	JL	EQ				0	0
8	WBRK	WBELN	JR	EQ			AND	0	0
9	WBGT	DOC_TYPE		EQ	'F'		OR	0	0
10	WBGT	DOC_TYPE		EQ	'J'		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	WBRK	MANDT		☐	MANDT	☐	Client
2	WBELN	WBRK	WBELN		☐	WBELN_AG	☐	Agency Business: Document Number
3	MANDT_I	WBRP	MANDT		☐	MANDT	☐	Client
4	WBELN_I	WBRP	WBELN		☐	WBELN_AG	☐	Agency Business: Document Number
5	POSNR_I	WBRP	POSNR		☐	WPOSNR_LF	☐	Agency business: Document 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	LFART	WBRK	LFART		☐	WFART	☐	Agency business: Billing document type
13	LFTYP	WBRK	LFTYP		☐	WFTYP	☐	Agency business: Billing category
14	WRART	WBRK	WRART		☐	WRART	☐	Agency business: Payment type
15	WBTYP	WBRK	WBTYP		☐	WBTYP	☐	Settlement request: Payment type
16	WRTYP	WBRK	WRTYP		☐	WRTYP	☐	Entry category: payment
17	ABART	WBRK	ABART		☐	NAFKT	☐	Settlement Type
18	KALSM	WBRK	KALSM		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
19	KALSMD	WBRK	KALSMD		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
20	WFDAT	WBRK	WFDAT		☐	WFDAT	☐	Agency business: Posting date
21	RFBSK	WBRK	RFBSK		☐	WFBSK	☐	Status for transfer to accounting
22	LIFRE	WBRK	LIFRE		☐	LIFRE	☐	Different Invoicing Party
23	LNRZB	WBRK	LNRZB		☐	W_LIFZE	☐	Agency business: Payee
24	KUNRE	WBRK	KUNRE		☐	KUNRE	☐	Bill-to party
25	KUNRG	WBRK	KUNRG		☐	KUNRG	☐	Payer
26	EKORG	WBRK	EKORG		☐	EKORG	☐	Purchasing organization
27	VKORG	WBRK	VKORG		☐	VKORG	☐	Sales Organization
28	VTWEG	WBRK	VTWEG		☐	VTWEG	☐	Distribution Channel
29	SPART	WBRK	SPART		☐	SPART	☐	Division
30	BUKRS	WBRK	BUKRS		☐	BUKRS	☐	Company Code
31	ERZET	WBRK	ERZET		☐	ERZET	☐	Entry time
32	ERDAT	WBRK	ERDAT		☐	ERDAT	☐	Date on which the record was created
33	ERNAM	WBRK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
34	AEDAT	WBRK	AEDAT		☐	AEDAT	☐	Last Changed On
35	BLDAT	WBRK	BLDAT		☐	BLDAT	☐	Document Date in Document
36	XBLNR	WBRK	XBLNR		☐	XBLNR1	☐	Reference Document Number
37	ZUONR	WBRK	ZUONR		☐	DZUONR	☐	Assignment number
38	WAERL	WBRK	WAERL		☐	WAERL	☐	Currency of Agency Document
39	WSTWAE	WBRK	WSTWAE		☐	WSTWAE	☐	Agency Business: Statistics Currency
40	WKURS	WBRK	WKURS		☐	WKURS	☐	Exchange Rate
41	STCUR	WBRK	STCUR		☐	STCUR	☐	Exchange rate for statistics
42	KUFIX	WBRK	KUFIX		☐	WKUFIX	☐	Indicator: Fixing of exchange rate
43	WKURS_DAT	WBRK	WKURS_DAT		☐	WWERT_D	☐	Translation date
44	BRTWR	WBRK	BRTWR		☐	BRTWR_LF	☐	Agenncy Business: Gross value in document currency
45	ZTERM	WBRK	ZTERM		☐	DZTERM	☐	Terms of payment key
46	ZBD1T	WBRK	ZBD1T		☐	DZBDET	☐	Cash (Prompt Payment) Discount Days
47	ZBD1P	WBRK	ZBD1P		☐	DZBD1P	☐	Cash discount percentage 1
48	ZBD2T	WBRK	ZBD2T		☐	DZBD2T	☐	Cash discount days 2
49	ZBD2P	WBRK	ZBD2P		☐	DZBD2P	☐	Cash Discount Percentage 2
50	ZBD3T	WBRK	ZBD3T		☐	DZBD3T	☐	Net Payment Terms Period
51	ZLSCH	WBRK	ZLSCH		☐	DZLSCH	☐	Payment method
52	NETWR	WBRK	NETWR		☐	NETWR_LF	☐	Agency Business: Net value in document currency
53	NETWRD	WBRK	NETWRD		☐	NETWRD_LF	☐	Agency value: Net Value in Document Currency (Customer-Side)
54	BRTWRD	WBRK	BRTWRD		☐	BRTWRD_LF	☐	Agency Business: Gross Value of Doc.Currency (Customr-Side)
55	ZTERMD	WBRK	ZTERMD		☐	WZTERMD	☐	Terms of Payment Key for Customer
56	ZBD1TD	WBRK	ZBD1TD		☐	WZBD1TD	☐	Cash Discount Period for Customer
57	ZBD1PD	WBRK	ZBD1PD		☐	WZBD1PD	☐	Cash discount percentage 1 customer
58	ZBD2TD	WBRK	ZBD2TD		☐	WZBD2TD	☐	Cash discount period 2 customer
59	ZBD2PD	WBRK	ZBD2PD		☐	WZBD2PD	☐	Cash Discount Percentage 2 Customer
60	ZBD3TD	WBRK	ZBD3TD		☐	WZBD3TD	☐	Deadline for Customer Net Condition
61	ZLSCHD	WBRK	ZLSCHD		☐	SCHZW_BSEGD	☐	Customer payment method
62	GSKTOD	WBRK	GSKTOD		☐	SKFBP	☐	Amount eligible for cash discount in document currency
63	GSKTO	WBRK	GSKTO		☐	SKFBP	☐	Amount eligible for cash discount in document currency
64	FKSTO	WBRK	FKSTO		☐	FKSTO	☐	Billing document is cancelled
65	KAPPL	WBRK	KAPPL		☐	KAPPL	☐	Application
66	KNUMV	WBRK	KNUMV		☐	KNUMV	☐	Number of the document condition
67	KNUMVD	WBRK	KNUMVD		☐	KNUMV	☐	Number of the document condition
68	STAFO	WBRK	STAFO		☐	STAFO	☐	Update group for statistics update
69	LFAKS	WBRK	LFAKS		☐	LFAKS	☐	Agency business: cancelled (reversed) document
70	KNUMA	WBRK	KNUMA		☐	KNUMA	☐	Agreement (various conditions grouped together)
71	LFART_RL	WBRK	LFART_RL		☐	WFART_RL	☐	Remuneration List Type, Vendor Billing Document
72	WFDAT_RL	WBRK	WFDAT_RL		☐	WFDAT_RL	☐	Agency Business: Posting Date for the Remuneration List
73	WBELN_RL	WBRK	WBELN_RL		☐	WBELN_RL	☐	Agency Business: Document Number of Remuneration List
74	EKGRP	WBRK	EKGRP		☐	EKGRP	☐	Purchasing group
75	VALTG	WBRK	VALTG		☐	WVALTG	☐	Additional value days
76	VALDT	WBRK	VALDT		☐	WVALDT	☐	Fixed Value Date
77	MWSBK	WBRK	MWSBK		☐	MWSBP	☐	Tax amount in document currency
78	MWSBKD	WBRK	MWSBKD		☐	MWSBPD	☐	Tax amount in document currency (customer-side)
79	NAVNK	WBRK	NAVNK		☐	NAVNW	☐	Non-deductible input tax
80	LOGSYS	WBRK	LOGSYS		☐	LOGSYS	☐	Logical system
81	DIEKZ	WBRK	DIEKZ		☐	DIEKZ	☐	Service indicator (foreign payment)
82	LANDL	WBRK	LANDL		☐	LANDL	☐	Supplying Country
83	LZBKZ	WBRK	LZBKZ		☐	LZBKZ	☐	State central bank indicator
84	KKBER	WBRK	KKBER		☐	KKBER	☐	Credit control area
85	LFGRU	WBRK	LFGRU		☐	WFGRU	☐	Agency business: Reason for activity
86	VALTGD	WBRK	VALTGD		☐	WVALTD	☐	Additional Value Days (Customer)
87	VALDTD	WBRK	VALDTD		☐	WVALDD	☐	Fixed Value Date (Customer)
88	KIDNO	WBRK	KIDNO		☐	KIDNO	☐	Payment Reference
89	WDTYP	WBRK	WDTYP		☐	DOCTYPE	☐	Agency Business: Document Category
90	WKURS_P1	WBRK	WKURS_P1		☐	WKURS_P1	☐	Agency business: Exchange rate of vendor payment currency
91	WKURS_P2	WBRK	WKURS_P2		☐	WKURS_P2	☐	Agency business: Exchange rate of customer payment currency
92	WPYCUR_P1	WBRK	WPYCUR_P1		☐	WPYCUR_P1	☐	Currency for automatic payment (vendor-side)
93	WPYCUR_P2	WBRK	WPYCUR_P2		☐	WPYCUR_P2	☐	Currency for automatic payment (customer-side)
94	ESTATUS	WBRK	ESTATUS		☐	WSTATE	☐	Agency business: Application status
95	KURST	WBRK	KURST		☐	KURST	☐	Exchange Rate Type
96	VKBUR	WBRK	VKBUR		☐	VKBUR	☐	Sales office
97	VKGRP	WBRK	VKGRP		☐	VKGRP	☐	Sales group
98	EXP_CLASS	WBRK	EXP_CLASS		☐	WB2_EXPENSE_CLASS	☐	GT Expenses: Expense Class
99	EXP_CALC_TYPE	WBRK	EXP_CALC_TYPE		☐	WB2_EXPENSE_CALC_TYPE	☐	GT Expenses: Calculation Type
100	SETTLE_DOC	WBRK	SETTLE_DOC		☐	WLF_EXP_SETTLE_DOC	☐	Global Trade Expenses: Settlement Document
101	DOC_SETTLED	WBRK	DOC_SETTLED		☐	WB2_EXP_DOCUMENT_SETTLED	☐	GT Expenses: Document Settled
102	MATNR_I	WBRP	MATNR		☐	MATNR	☐	Material Number
103	MATKL_I	WBRP	MATKL		☐	MATKL	☐	Material Group
104	WERKS_I	WBRP	WERKS		☐	WERKS_D	☐	Plant
105	MWSKZ_I	WBRP	MWSKZ		☐	MWSKZ_LF	☐	Agency business: Tax code (input tax)
106	MWSK2_I	WBRP	MWSK2		☐	MWSKZ_RB	☐	Agency business: Tax code (output tax)
107	PRSDT_I	WBRP	PRSDT		☐	PRSDT	☐	Date for pricing and exchange rate
108	MENGE_I	WBRP	MENGE		☐	WFIMG	☐	Vendor billing document: actual quantity billed
109	NETPR_I	WBRP	NETPR		☐	WNETPR	☐	Vendor billing document: net price in document currency
110	PEINH_I	WBRP	PEINH		☐	WEINH	☐	Price Unit of Vendor Billing Document Item
111	WFKME_I	WBRP	WFKME		☐	WFKME	☐	Vendor billing document: unit of measure
112	UMREZ_I	WBRP	UMREZ		☐	UMWFZ	☐	Numerator converting qty in vendor bill.doc. to base unit
113	UMREN_I	WBRP	UMREN		☐	UMWFN	☐	Factor for converting qty in vendor bill. doc. to base unit
114	FPRME_I	WBRP	FPRME		☐	WFPRME	☐	Billing price unit
115	FPUMZ_I	WBRP	FPUMZ		☐	WPUMZ	☐	Vendor billing doc.: numerator for converting BPUn to PBUn
116	FPUMN_I	WBRP	FPUMN		☐	WPUMN	☐	Vendor billing doc.: denominator for converting BPUn to PBUn
117	MEINS_I	WBRP	MEINS		☐	MEINS	☐	Base Unit of Measure
118	NTGEW_I	WBRP	NTGEW		☐	WLF_NTGEW_15	☐	Net Weight
119	BRGEW_I	WBRP	BRGEW		☐	WLF_BRGEW_15	☐	Gross Weight
120	GEWEI_I	WBRP	GEWEI		☐	GEWEI	☐	Weight Unit
121	VOLUM_I	WBRP	VOLUM		☐	WLF_VOLUM_15	☐	Volume
122	VOLEH_I	WBRP	VOLEH		☐	VOLEH	☐	Volume unit
123	STAFO_I	WBRP	STAFO		☐	STAFO	☐	Update group for statistics update
124	MTART_I	WBRP	MTART		☐	MTART	☐	Material type
125	NETWR_I	WBRP	NETWR		☐	NETWR_LFP	☐	Net value of the item in document currency
126	BRTWR_I	WBRP	BRTWR		☐	BRTWR_LFP	☐	Gross value of the item in document currency
127	KZWI1_I	WBRP	KZWI1		☐	KZWI1	☐	Subtotal 1 from pricing procedure for condition
128	KZWI2_I	WBRP	KZWI2		☐	KZWI2	☐	Subtotal 2 from pricing procedure for condition
129	KZWI3_I	WBRP	KZWI3		☐	KZWI3	☐	Subtotal 3 from pricing procedure for condition
130	KZWI4_I	WBRP	KZWI4		☐	KZWI4	☐	Subtotal 4 from pricing procedure for condition
131	KZWI5_I	WBRP	KZWI5		☐	KZWI5	☐	Subtotal 5 from pricing procedure for condition
132	KZWI6_I	WBRP	KZWI6		☐	KZWI6	☐	Subtotal 6 from pricing procedure for condition
133	BONBA_I	WBRP	BONBA		☐	BONBA	☐	Rebate basis 1
134	EFFWR_I	WBRP	EFFWR		☐	WLF_EFFWR	☐	Effective Value of Item
135	ERNAM_I	WBRP	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
136	ERDAT_I	WBRP	ERDAT		☐	ERDAT	☐	Date on which the record was created
137	ERZET_I	WBRP	ERZET		☐	ERZET	☐	Entry time
138	KOWRR_I	WBRP	KOWRR		☐	WKOWRR	☐	Statistical Values
139	SKTOF_I	WBRP	SKTOF		☐	SKTOF	☐	Cash discount indicator
140	SKFBP_I	WBRP	SKFBP		☐	SKFBP	☐	Amount eligible for cash discount in document currency
141	NETWRD_I	WBRP	NETWRD		☐	NETWRD_LFP	☐	Net value of the item in document currency (customer-side)
142	BRTWRD_I	WBRP	BRTWRD		☐	BRTWRD_LFP	☐	Gross value of item in document currency (customer-side)
143	KZWI1D_I	WBRP	KZWI1D		☐	KZWI1	☐	Subtotal 1 from pricing procedure for condition
144	KZWI2D_I	WBRP	KZWI2D		☐	KZWI2	☐	Subtotal 2 from pricing procedure for condition
145	KZWI3D_I	WBRP	KZWI3D		☐	KZWI3	☐	Subtotal 3 from pricing procedure for condition
146	KZWI4D_I	WBRP	KZWI4D		☐	KZWI4	☐	Subtotal 4 from pricing procedure for condition
147	KZWI5D_I	WBRP	KZWI5D		☐	KZWI5	☐	Subtotal 5 from pricing procedure for condition
148	KZWI6D_I	WBRP	KZWI6D		☐	KZWI6	☐	Subtotal 6 from pricing procedure for condition
149	BONBAD_I	WBRP	BONBAD		☐	BONBA	☐	Rebate basis 1
150	SKFBPD_I	WBRP	SKFBPD		☐	SKFBPD	☐	Amount qualifying for cash discount in doc. currency (cust.)
151	EFFWRD_I	WBRP	EFFWRD		☐	EFFWRD	☐	Effective value of the item (customer-side)
152	MWSBPD_I	WBRP	MWSBPD		☐	MWSBPD	☐	Tax amount in document currency (customer-side)
153	WBELNV_I	WBRP	WBELNV		☐	WBELNV	☐	Agency business: Document number of the reference document
154	POSNRV_I	WBRP	POSNRV		☐	WPOSNRV	☐	Item number of the reference document item
155	LFTYPV_I	WBRP	LFTYPV		☐	WFTYPV	☐	Agency Business: Document Category of Preceding Document
156	AKTNR_I	WBRP	AKTNR		☐	WAKTION	☐	Promotion
157	LFGRU_I	WBRP	LFGRU		☐	WFGRU	☐	Agency business: Reason for activity
158	ARKTX_I	WBRP	ARKTX		☐	TXZ01	☐	Short Text
159	INFNR_I	WBRP	INFNR		☐	INFNR	☐	Number of purchasing info record
160	IDNLF_I	WBRP	IDNLF		☐	IDNLF	☐	Material Number Used by Vendor
161	MWSBP_I	WBRP	MWSBP		☐	MWSBP	☐	Tax amount in document currency
162	TXJCD_I	WBRP	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
163	EBONF_I	WBRP	EBONF		☐	EBONY	☐	Item Relevant to Subsequent (Period-End Rebate) Settlement
164	BONUS_I	WBRP	BONUS		☐	EBONU	☐	Settlement Group 1 (Purchasing)
165	EBON2_I	WBRP	EBON2		☐	EBON2	☐	Settlement Group 2 (Rebate Settlement, Purchasing)
166	EBON3_I	WBRP	EBON3		☐	EBON3	☐	Settlement Group 3 (Rebate Settlement, Purchasing)
167	LTSNR_I	WBRP	LTSNR		☐	LTSNR	☐	Vendor Subrange
168	EKKOL_I	WBRP	EKKOL		☐	EKKOG	☐	Condition Group with Vendor
169	PUNEI_I	WBRP	PUNEI		☐	PUNEI	☐	Points unit
170	ANZPU_I	WBRP	ANZPU		☐	ANZPU	☐	Number of Points
171	KOLIF_I	WBRP	KOLIF		☐	KOLIF	☐	Prior Vendor
172	NAVNW_I	WBRP	NAVNW		☐	NAVNW	☐	Non-deductible input tax
173	BWTAR_I	WBRP	BWTAR		☐	BWTAR_D	☐	Valuation type
174	BWTTY_I	WBRP	BWTTY		☐	BWTTY_D	☐	Valuation Category
175	GSBER_I	WBRP	GSBER		☐	GSBER	☐	Business Area
176	PAOBJNR_I	WBRP	PAOBJNR		☐	RKEOBJNR	☐	Profitability Segment Number (CO-PA)
177	KOSTL_I	WBRP	KOSTL		☐	KOSTL	☐	Cost Center
178	PRCTR_I	WBRP	PRCTR		☐	PRCTR	☐	Profit Center
179	KOKRS_I	WBRP	KOKRS		☐	KOKRS	☐	Controlling Area
180	CHARG_I	WBRP	CHARG		☐	CHARG_D	☐	Batch Number
181	WUVPRS_I	WBRP	WUVPRS		☐	WUVPRS	☐	Agency business: Item incomplete re. price determination
182	WBELN_V_I	WBRP	WBELN_V		☐	WBELN_V	☐	Triggering document of the agency document
183	POSNR_V_I	WBRP	POSNR_V		☐	POSNR_V	☐	Triggering item in the agency document
184	FTYPV_V_I	WBRP	FTYPV_V		☐	WFTYP_V	☐	Agency Business: Document Category of Triggering Document
185	ITEMCAT_I	WBRP	ITEMCAT		☐	WSHKZG	☐	Agency Business: Item Category
186	TKONN_W	WBGT	TKONN		☐	TKONN	☐	Trading Contract: Trading Contract Number
187	TPOSN_W	WBGT	TPOSN		☐	TPOSN	☐	Trading Contract: Item Number
188	TPOSN_SUB_W	WBGT	TPOSN_SUB		☐	TPOSN_SUB	☐	Trading Contract: Sub-Item Number
189	ERNAM_W	WBGT	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
190	ERDAT_W	WBGT	ERDAT		☐	ERDAT	☐	Date on which the record was created
191	TEW_TYPE_W	WBGT	TEW_TYPE		☐	WB2_TEW_TYPE	☐	Trading Execution Workbench Type
192	SCENARIO_W	WBGT	SCENARIO		☐	WB2_BUSINESS_SCENARIO	☐	Business Scenario
193	TKONN_EX_W	WBGT	TKONN_EX		☐	TKONN_EX	☐	Trading Contract: External Document Number
194	COMPLETE_W	WBGT	COMPLETE		☐	WB2_DOCUMENT_COMPLETE_2	☐	Global Trade: Item Closed
195	ERROR_TEW_W	WBGT	ERROR_TEW		☐	WB2B_ERROR_TEW	☐	Global Trade: Error in Follow-On Document Creation
196	BUSINESS_STEP_W	WBGT	BUSINESS_STEP		☐	WB2_STEP	☐	Business Process Step
197	MASTER_STEP_W	WBGT	MASTER_STEP		☐	WB2_MASTER_STEP	☐	Main Step
198	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