SAP ABAP View V_WBRC_WBRK (Database View of WBRC and WBRK)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-AB (Application Component) Agency Business (Global Trade)
     ⤷ WZRE_ADD_ON (Package) Agency Business (Add-Ons)

Basic Data

View Type	D	Database View
Database View	V_WBRC_WBRK
Short Description	Database View of WBRC and WBRK
Root table	WBRC	Agency Business: Complaints

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	WBRC	*		☐		☐
2	MANDT	WBRC	MANDT		☐	MANDT	☐	Client
3	CLAIMNUMBER	WBRC	CLAIMNUMBER		☐	CLAIMNUMBER	☐	AB-CWB: Complaints Number
4	CLAIMREASON	WBRC	CLAIMREASON		☐	CLAIMREASON	☐	AB-CWB: Complaints Reason
5	WBELN	WBRC	WBELN		☐	WLF_CWB_WBELN	☐	AB-CWB: Document to Which the Complaint Refers
6	POSNR	WBRC	POSNR		☐	WLF_CWB_POSNR	☐	AB-CWB: Document Item to Which the Complaint Refers
7	AB_DOCUMENT	WBRC	AB_DOCUMENT		☐	WLF_AB_DOCUMENT	☐	AB-CWB: Complaints Document Is Agency Document
8	ERDAT	WBRC	ERDAT		☐	ERDAT	☐	Date on which the record was created
9	ERZET	WBRC	ERZET		☐	ERZET	☐	Entry time
10	ERNAM	WBRC	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
11	AEDAT	WBRC	AEDAT		☐	AEDAT	☐	Last Changed On
12	CLAIMSTATUS	WBRC	CLAIMSTATUS		☐	CLAIMSTATUS	☐	AB-CWB: Complaints Status
13	CLOSED	WBRC	CLOSED		☐	WLF_CWB_CLOSED	☐	AB-CWB: Complaint Closed on
14	BLOCKED	WBRC	BLOCKED		☐	WLF_CWB_BLOCKED	☐	AB-CWB: Complaint Is Locked
15	*	WBRK	*		☐		☐
16	-	WBRK	MANDT		☐	MANDT	☐	Client
17	-	WBRK	WBELN		☐	WBELN_AG	☐	Agency Business: Document Number
18	LFART	WBRK	LFART		☐	WFART	☐	Agency business: Billing document type
19	LFTYP	WBRK	LFTYP		☐	WFTYP	☐	Agency business: Billing category
20	WRART	WBRK	WRART		☐	WRART	☐	Agency business: Payment type
21	WBTYP	WBRK	WBTYP		☐	WBTYP	☐	Settlement request: Payment type
22	WRTYP	WBRK	WRTYP		☐	WRTYP	☐	Entry category: payment
23	ABART	WBRK	ABART		☐	NAFKT	☐	Settlement Type
24	KALSM	WBRK	KALSM		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
25	KALSMD	WBRK	KALSMD		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
26	WFDAT	WBRK	WFDAT		☐	WFDAT	☐	Agency business: Posting date
27	RFBSK	WBRK	RFBSK		☐	WFBSK	☐	Status for transfer to accounting
28	LIFRE	WBRK	LIFRE		☐	LIFRE	☐	Different Invoicing Party
29	LNRZB	WBRK	LNRZB		☐	W_LIFZE	☐	Agency business: Payee
30	KUNRE	WBRK	KUNRE		☐	KUNRE	☐	Bill-to party
31	KUNRG	WBRK	KUNRG		☐	KUNRG	☐	Payer
32	EKORG	WBRK	EKORG		☐	EKORG	☐	Purchasing organization
33	VKORG	WBRK	VKORG		☐	VKORG	☐	Sales Organization
34	VTWEG	WBRK	VTWEG		☐	VTWEG	☐	Distribution Channel
35	SPART	WBRK	SPART		☐	SPART	☐	Division
36	BUKRS	WBRK	BUKRS		☐	BUKRS	☐	Company Code
37	-	WBRK	ERZET		☐	ERZET	☐	Entry time
38	-	WBRK	ERDAT		☐	ERDAT	☐	Date on which the record was created
39	-	WBRK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
40	-	WBRK	AEDAT		☐	AEDAT	☐	Last Changed On
41	BLDAT	WBRK	BLDAT		☐	BLDAT	☐	Document Date in Document
42	XBLNR	WBRK	XBLNR		☐	XBLNR1	☐	Reference Document Number
43	ZUONR	WBRK	ZUONR		☐	DZUONR	☐	Assignment number
44	WAERL	WBRK	WAERL		☐	WAERL	☐	Currency of Agency Document
45	WSTWAE	WBRK	WSTWAE		☐	WSTWAE	☐	Agency Business: Statistics Currency
46	WKURS	WBRK	WKURS		☐	WKURS	☐	Exchange Rate
47	STCUR	WBRK	STCUR		☐	STCUR	☐	Exchange rate for statistics
48	KUFIX	WBRK	KUFIX		☐	WKUFIX	☐	Indicator: Fixing of exchange rate
49	WKURS_DAT	WBRK	WKURS_DAT		☐	WWERT_D	☐	Translation date
50	BRTWR	WBRK	BRTWR		☐	BRTWR_LF	☐	Agenncy Business: Gross value in document currency
51	ZTERM	WBRK	ZTERM		☐	DZTERM	☐	Terms of payment key
52	ZBD1T	WBRK	ZBD1T		☐	DZBDET	☐	Cash (Prompt Payment) Discount Days
53	ZBD1P	WBRK	ZBD1P		☐	DZBD1P	☐	Cash discount percentage 1
54	ZBD2T	WBRK	ZBD2T		☐	DZBD2T	☐	Cash discount days 2
55	ZBD2P	WBRK	ZBD2P		☐	DZBD2P	☐	Cash Discount Percentage 2
56	ZBD3T	WBRK	ZBD3T		☐	DZBD3T	☐	Net Payment Terms Period
57	ZLSCH	WBRK	ZLSCH		☐	DZLSCH	☐	Payment method
58	NETWR	WBRK	NETWR		☐	NETWR_LF	☐	Agency Business: Net value in document currency
59	NETWRD	WBRK	NETWRD		☐	NETWRD_LF	☐	Agency value: Net Value in Document Currency (Customer-Side)
60	BRTWRD	WBRK	BRTWRD		☐	BRTWRD_LF	☐	Agency Business: Gross Value of Doc.Currency (Customr-Side)
61	ZTERMD	WBRK	ZTERMD		☐	WZTERMD	☐	Terms of Payment Key for Customer
62	ZBD1TD	WBRK	ZBD1TD		☐	WZBD1TD	☐	Cash Discount Period for Customer
63	ZBD1PD	WBRK	ZBD1PD		☐	WZBD1PD	☐	Cash discount percentage 1 customer
64	ZBD2TD	WBRK	ZBD2TD		☐	WZBD2TD	☐	Cash discount period 2 customer
65	ZBD2PD	WBRK	ZBD2PD		☐	WZBD2PD	☐	Cash Discount Percentage 2 Customer
66	ZBD3TD	WBRK	ZBD3TD		☐	WZBD3TD	☐	Deadline for Customer Net Condition
67	ZLSCHD	WBRK	ZLSCHD		☐	SCHZW_BSEGD	☐	Customer payment method
68	GSKTOD	WBRK	GSKTOD		☐	SKFBP	☐	Amount eligible for cash discount in document currency
69	GSKTO	WBRK	GSKTO		☐	SKFBP	☐	Amount eligible for cash discount in document currency
70	FKSTO	WBRK	FKSTO		☐	FKSTO	☐	Billing document is cancelled
71	KAPPL	WBRK	KAPPL		☐	KAPPL	☐	Application
72	KNUMV	WBRK	KNUMV		☐	KNUMV	☐	Number of the document condition
73	KNUMVD	WBRK	KNUMVD		☐	KNUMV	☐	Number of the document condition
74	STAFO	WBRK	STAFO		☐	STAFO	☐	Update group for statistics update
75	LFAKS	WBRK	LFAKS		☐	LFAKS	☐	Agency business: cancelled (reversed) document
76	KNUMA	WBRK	KNUMA		☐	KNUMA	☐	Agreement (various conditions grouped together)
77	LFART_RL	WBRK	LFART_RL		☐	WFART_RL	☐	Remuneration List Type, Vendor Billing Document
78	WFDAT_RL	WBRK	WFDAT_RL		☐	WFDAT_RL	☐	Agency Business: Posting Date for the Remuneration List
79	WBELN_RL	WBRK	WBELN_RL		☐	WBELN_RL	☐	Agency Business: Document Number of Remuneration List
80	EKGRP	WBRK	EKGRP		☐	EKGRP	☐	Purchasing group
81	VALTG	WBRK	VALTG		☐	WVALTG	☐	Additional value days
82	VALDT	WBRK	VALDT		☐	WVALDT	☐	Fixed Value Date
83	MWSBK	WBRK	MWSBK		☐	MWSBP	☐	Tax amount in document currency
84	MWSBKD	WBRK	MWSBKD		☐	MWSBPD	☐	Tax amount in document currency (customer-side)
85	NAVNK	WBRK	NAVNK		☐	NAVNW	☐	Non-deductible input tax
86	LOGSYS	WBRK	LOGSYS		☐	LOGSYS	☐	Logical system
87	DIEKZ	WBRK	DIEKZ		☐	DIEKZ	☐	Service indicator (foreign payment)
88	LANDL	WBRK	LANDL		☐	LANDL	☐	Supplying Country
89	LZBKZ	WBRK	LZBKZ		☐	LZBKZ	☐	State central bank indicator
90	KKBER	WBRK	KKBER		☐	KKBER	☐	Credit control area
91	LFGRU	WBRK	LFGRU		☐	WFGRU	☐	Agency business: Reason for activity
92	VALTGD	WBRK	VALTGD		☐	WVALTD	☐	Additional Value Days (Customer)
93	VALDTD	WBRK	VALDTD		☐	WVALDD	☐	Fixed Value Date (Customer)
94	KIDNO	WBRK	KIDNO		☐	KIDNO	☐	Payment Reference
95	WDTYP	WBRK	WDTYP		☐	DOCTYPE	☐	Agency Business: Document Category
96	WKURS_P1	WBRK	WKURS_P1		☐	WKURS_P1	☐	Agency business: Exchange rate of vendor payment currency
97	WKURS_P2	WBRK	WKURS_P2		☐	WKURS_P2	☐	Agency business: Exchange rate of customer payment currency
98	WPYCUR_P1	WBRK	WPYCUR_P1		☐	WPYCUR_P1	☐	Currency for automatic payment (vendor-side)
99	WPYCUR_P2	WBRK	WPYCUR_P2		☐	WPYCUR_P2	☐	Currency for automatic payment (customer-side)
100	ESTATUS	WBRK	ESTATUS		☐	WSTATE	☐	Agency business: Application status
101	KURST	WBRK	KURST		☐	KURST	☐	Exchange Rate Type
102	VKBUR	WBRK	VKBUR		☐	VKBUR	☐	Sales office
103	VKGRP	WBRK	VKGRP		☐	VKGRP	☐	Sales group
104	SETTLE_DOC	WBRK	SETTLE_DOC		☐	WLF_EXP_SETTLE_DOC	☐	Global Trade Expenses: Settlement Document
105	FKSTO_PART	WBRK	FKSTO_PART		☐	WLF_FKSTO_PART	☐	Partial Reversal
106	POST_PARTY	WBRK	POST_PARTY		☐	WLF_POST_PARTY	☐	Posting Partner
107	CPDK_ADDR	WBRK	CPDK_ADDR		☐	WLF_CPDK_ADDR	☐	Agency Business: Address of One-Time Customer
108	FKSTO_PARTY	WBRK	FKSTO_PARTY		☐	WLF_FKSTO_PARTY	☐	Cancelled Partner
109	CONTRACT	WBRK	CONTRACT		☐	WCONTRACT	☐	Referencing Contract Number
110	CONTRACT_TYPE	WBRK	CONTRACT_TYPE		☐	WCONTRACT_TYPE	☐	Contract Type for Contract Number
111	COLLECTION_TYPE	WBRK	COLLECTION_TYPE		☐	WCOLLECTION	☐	Document Summarization Attribute
112	CMWAE	WBRK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
113	CTLPC	WBRK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
114	CM_AMOUNT	WBRK	CM_AMOUNT		☐	AMTBL_CM	☐	Released credit value of the document
115	SETTLE_CATEGORY	WBRK	SETTLE_CATEGORY		☐	WSETTLE_CATEGORY	☐	Settlement Attributes
116	IDOBJ_TYPE_V	WBRK	IDOBJ_TYPE_V		☐	WLF_IDOBJ_TYPE_VENDOR	☐	AB: Identification Object Type Vendor
117	IDOBJ_VENDOR	WBRK	IDOBJ_VENDOR		☐	WLF_IDOBJ_VENDOR	☐	AB: Identification Object Vendor
118	IDOBJ_TYPE_C	WBRK	IDOBJ_TYPE_C		☐	WLF_IDOBJ_TYPE_CUSTOMER	☐	AB: Identification Object Type Customer
119	IDOBJ_CUSTOMER	WBRK	IDOBJ_CUSTOMER		☐	WLF_IDOBJ_CUSTOMER	☐	AB: Identification Object Customer
120	POSTING_RULE_K	WBRK	POSTING_RULE_K		☐	WLF_POSTING_RULE_K	☐	AB: Creditor Posting Rule
121	POSTING_RULE_D	WBRK	POSTING_RULE_D		☐	WLF_POSTING_RULE_D	☐	AB: Debtor Posting Rule
122	POSTING_RULE_A	WBRK	POSTING_RULE_A		☐	WLF_POSTING_RULE_A	☐	AB: Special Posting Rule for Provisions with Settlements
123	VKONT	WBRK	VKONT		☐	CORR_VKONT_KK	☐	Contract Account Number
124	WT_ACTIVE	WBRK	WT_ACTIVE		☐	WLF_WITHHOLDING_TAX_ACTIVE	☐	AB: Extended Withholding Tax Active
125	BUKRS_DEB	WBRK	BUKRS_DEB		☐	WLF_BUKRS_CUSTOMER_REGU	☐	AB: Company Code - Customer
126	SETTL_PARTY	WBRK	SETTL_PARTY		☐	WLF_SETTLEMENT_PARTY	☐	AB: Settlement Partner
127	SETTL_STATUS_V	WBRK	SETTL_STATUS_V		☐	WLF_SETTLEMENT_STATUS_V	☐	AB: Settlement Status - Vendor
128	SETTL_STATUS_C	WBRK	SETTL_STATUS_C		☐	WLF_SETTLEMENT_STATUS_C	☐	AB: Settlement Status - Customer
129	SETTL_DOCTYPE_V	WBRK	SETTL_DOCTYPE_V		☐	WLF_SETTLEMENT_DOCTYPE_V	☐	AB: Settlement Document Type - Vendor
130	SETTL_DOCTYPE_C	WBRK	SETTL_DOCTYPE_C		☐	WLF_SETTLEMENT_DOCTYPE_C	☐	AB: Settlement Document Type - Customer
131	SETTL_METHOD	WBRK	SETTL_METHOD		☐	WLF_SETTLEMENT_METHOD	☐	AB: Settlement Procedure
132	SETTL_BLOCK_V	WBRK	SETTL_BLOCK_V		☐	WLF_SETTLEMENT_BLOCK_V	☐	AB: Settlement Block - Vendor
133	SETTL_BLOCK_C	WBRK	SETTL_BLOCK_C		☐	WLF_SETTLEMENT_BLOCK_C	☐	AB: Settlement Block - Customer
134	CPDL_ADDR	WBRK	CPDL_ADDR		☐	WLF_CPDL_ADDR	☐	Agency Business: Address - One-Time Vendor
135	MONAT	WBRK	MONAT		☐	MONAT	☐	Fiscal period
136	SERVCONF_ID	WBRK	SERVCONF_ID		☐	FSL_SERVCONF_ID	☐	FSL: Service Confirmation ID
137	COUNTER	WBRK	COUNTER		☐	FSL_COUNTER	☐	FSL: Counter Reading
138	COUNTER_UNIT	WBRK	COUNTER_UNIT		☐	FSL_UNIT	☐	FSL: Unit of Measurement
139	EXP_CLASS	WBRK	EXP_CLASS		☐	WB2_EXPENSE_CLASS	☐	GT Expenses: Expense Class
140	EXP_CALC_TYPE	WBRK	EXP_CALC_TYPE		☐	WB2_EXPENSE_CALC_TYPE	☐	GT Expenses: Calculation Type
141	DOC_SETTLED	WBRK	DOC_SETTLED		☐	WB2_EXP_DOCUMENT_SETTLED	☐	GT Expenses: Document Settled
142	REF_VALUE_REF	WBRK	REF_VALUE_REF		☐	WB2_EXPENSE_REF_VALUE_REF	☐	Ref. Field for GT Expenses Ref. Value (Currency, %, Unit)
143	REF_VALUE	WBRK	REF_VALUE		☐	WB2_EXPENSE_REFERENCE_VALUE	☐	Global Trade Reference Value for Expenses
144	POST_TYPE	WBRK	POST_TYPE		☐	WB2_EXPENSE_POSTING_TYPE	☐	GT Expenses: Posting Type of Expenses
145	TEW_TYPE	WBRK	TEW_TYPE		☐	WB2_TEW_TYPE	☐	Trading Execution Workbench Type
146	STEP	WBRK	STEP		☐	WB2_STEP	☐	Business Process Step
147	PARTNER_EXP	WBRK	PARTNER_EXP		☐	PRQ_PARNO	☐	Business Partner
148	STEP_FROM	WBRK	STEP_FROM		☐	WB2_STEP	☐	Business Process Step
149	STEP_TEW	WBRK	STEP_TEW		☐	WB2_STEP	☐	Business Process Step
150	MODE	WBRK	MODE		☐	WB2_MODE	☐	Mode of the Step of a Business Process
151	PARTNER_EXP_TYPE	WBRK	PARTNER_EXP_TYPE		☐	WB2_PARTNER_EXP_TYPE	☐	Classificationm of Partner for Expense Documents
152	IV_CHECK_TYPE_H	WBRK	IV_CHECK_TYPE_H		☐	WLF_IV_CHECK_TYPE_HEAD	☐	Type of Check (Header)
153	IV_ACCR	WBRK	IV_ACCR		☐	WLF_IV_ACCRUAL	☐	Accrual
154	RRLCG	WBRK	RRLCG		☐	RRLCG	☐	AB-RRLE: Condition Type Group
155	RRLPA	WBRK	RRLPA		☐	RRLPA	☐	AB-RRLE: Remuneration List Partner
156	CORR_DOCUMENT	WBRK	CORR_DOCUMENT		☐	WLF_CORR_DOCUMENT	☐	AB: Adjustment Document
157	INCOMP_REASON	WBRK	INCOMP_REASON		☐	WLF_INCOMPLETENESS_REASON	☐	Incompleteness Reason
158	LIFNR_FI	WBRK	LIFNR_FI		☐	WLF_LIFNR_FI	☐	Alternative Creditor
159	DISTRIB_INCOMP	WBRK	DISTRIB_INCOMP		☐	WLF_DISTRIBUTION_INCOMPLETE	☐	Distribution Incomplete
160	RFBSK_COMB_SETT	WBRK	RFBSK_COMB_SETT		☐	WLF_RFBSK_COMBINED_SETTLEMENT	☐	Posting Status for Combined Settlement
161	NO_TEXT_H	WBRK	NO_TEXT_H		☐	WLF_NO_TEXT	☐	No Texts Exist
162	INTRASTAT_REL	WBRK	INTRASTAT_REL		☐	WLF_INTRASTAT_RELEVANT	☐	Document is Relevant for Intrastat Declarations
163	LANDTX	WBRK	LANDTX		☐	WLF_D_LANDTX	☐	Tax Departure Country
164	LAND1TX	WBRK	LAND1TX		☐	WLF_D_LAND1TX	☐	Tax Destination Country
165	XEGDR	WBRK	XEGDR		☐	XEGDR	☐	Indicator: Triangular deal within the EU ?
166	STCEG	WBRK	STCEG		☐	LIEFRUINR	☐	Vendor VAT registration number
167	STCEGD	WBRK	STCEGD		☐	KUNDEUINR	☐	Customer VAT registration number
168	INTRASTAT_FLOW_D	WBRK	INTRASTAT_FLOW_D		☐	WLF_INTRASTAT_FLOW_DOC	☐	Type of Goods Flow for Intrastat Declarations
169	INCO1	WBRK	INCO1		☐	INCO1	☐	Incoterms (part 1)
170	INCO2	WBRK	INCO2		☐	INCO2	☐	Incoterms (part 2)
171	WKURS_DEB	WBRK	WKURS_DEB		☐	WLF_WKURS_CUSTOMER	☐	Deviating Exchange Rate in Customer Company Code
172	SETTLEMENT_DATE	WBRK	SETTLEMENT_DATE		☐	WLF_SETTLEMENT_DATE	☐	Settlement Date
173	PROCESS_TYPE	WBRK	PROCESS_TYPE		☐	WLF_PROCESS_TYPE	☐	Process Category
174	BANK_DATA	WBRK	BANK_DATA		☐	WLF_BANK_DATA	☐	Agency Document: Bank Data Was Entered for Document
175	COLL_STATUS	WBRK	COLL_STATUS		☐	WLF_COLLECTION_STATUS	☐	AB: Status for Collection of Settlement Requests
176	IS_COLLECTION	WBRK	IS_COLLECTION		☐	WLF_IS_COLLECTION	☐	AD: Document Is Collective Document
177	COLL_BLOCK	WBRK	COLL_BLOCK		☐	WLF_COLLECTION_BLOCK	☐	AB: Block for Collection of Settlement Requests
178	REF_SETTL_DATE	WBRK	REF_SETTL_DATE		☐	WLF_REFERENCE_SETTLEMENT_DATE	☐	AD: Reference Settlement Date
179	USE_CASE	WBRK	USE_CASE		☐	WLF_USE_CASE_TYPE	☐	Use Case Type
180	USE_CASE_GUID	WBRK	USE_CASE_GUID		☐	WLF_USE_CASE_GUID	☐	AB: GUID for Use Case
181	INVOICE_ID	WBRK	INVOICE_ID		☐	WLF_BTD_ID	☐	BusinessTransactionDocumentID
182	SCHEME_ID	WBRK	SCHEME_ID		☐	WLF_SCHEME_ID	☐	AB: Identifier for the ID Scheme
183	SCHEME_A_ID	WBRK	SCHEME_A_ID		☐	WLF_SCHEME_A_ID	☐	AB: ID of the Organization that Maintains the ID Scheme
184	AGENCY_ID_CODE	WBRK	AGENCY_ID_CODE		☐	WLF_AGENCY_ID_CODE	☐	AB: Agency of Standard ID for Invoice Document
185	ITCUP	WBRK	ITCUP		☐	ITCUP	☐	CUP number for Vendor
186	ITCIG	WBRK	ITCIG		☐	ITCUG	☐	CIG Number for Vendor
187	MNDID	WBRK	MNDID		☐	SEPA_MNDID	☐	Unique Referene to Mandate per Payment Recipient

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	200