SAP ABAP Table WB2_V_WBRK_WBRL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	WB2_V_WBRK_WBRL	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WBELN	☑	WBELN_AG	WBELN	CHAR	10	0	Agency Business: Document Number
3	MANDT_I	☑	MANDT	MANDT	CLNT	3	0	Client	T000
4	WBELN_I	☑	WBELN_RL	WBELN	CHAR	10	0	Agency Business: Document Number of Remuneration List	WBRK
5	POSNR_I	☑	WPOSNR_RL	WPOSNR_RL	NUMC	6	0	Agency business: Item in list
6	MANDT_W	☑	MANDT	MANDT	CLNT	3	0	Client	T000
7	DOC_TYPE_W	☑	WB2_DOC_TYPE	WB2_DOC_TYPE	CHAR	2	0	Document Type
8	VBELN_W	☑	WB2_DOCUMENT_NUMBER	VBELN	CHAR	10	0	General Document Number
9	POSNR_W	☑	WB2_DOCUMENT_ITEM	POSNR	NUMC	6	0	Item Number of a Document
10	POSNR_SUB_W	☑	WB2_SUB_ITEM	TPOSN	NUMC	6	0	Sub-Item Number of a Document
11	GJAHR_W	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
12	LFART	☐	WFART	WFART	CHAR	4	0	Agency business: Billing document type	TMFK
13	LFTYP	☐	WFTYP	WFTYP	CHAR	2	0	Agency business: Billing category
14	WRART	☐	WRART	WRART	CHAR	4	0	Agency business: Payment type	TMZR
15	WBTYP	☐	WBTYP	WBTYP	CHAR	1	0	Settlement request: Payment type
16	WRTYP	☐	WRTYP	WRTYP	CHAR	1	0	Entry category: payment
17	ABART	☐	NAFKT	NAFKT	CHAR	1	0	Settlement Type
18	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
19	KALSMD	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
20	WFDAT	☐	WFDAT	DATUM	DATS	8	0	Agency business: Posting date
21	RFBSK	☐	WFBSK	WFBSK	CHAR	1	0	Status for transfer to accounting
22	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	LFA1
23	LNRZB	☐	W_LIFZE	LIFNR	CHAR	10	0	Agency business: Payee	LFA1
24	KUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	KNA1
25	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
26	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
27	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
28	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
29	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
30	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
31	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
32	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
33	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
34	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
35	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
36	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
37	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
38	WAERL	☐	WAERL	WAERS	CUKY	5	0	Currency of Agency Document	TCURC
39	WSTWAE	☐	WSTWAE	WAERS	CUKY	5	0	Agency Business: Statistics Currency	TCURC
40	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
41	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
42	KUFIX	☐	WKUFIX	XFELD	CHAR	1	0	Indicator: Fixing of exchange rate
43	WKURS_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
44	BRTWR	☐	BRTWR_LF	WERTV8	CURR	15	2	Agenncy Business: Gross value in document currency
45	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
46	ZBD1T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
47	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
48	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
49	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
50	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
51	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
52	NETWR	☐	NETWR_LF	WERTV8	CURR	15	2	Agency Business: Net value in document currency
53	NETWRD	☐	NETWRD_LF	WERTV8	CURR	15	2	Agency value: Net Value in Document Currency (Customer-Side)
54	BRTWRD	☐	BRTWRD_LF	WERTV8	CURR	15	2	Agency Business: Gross Value of Doc.Currency (Customr-Side)
55	ZTERMD	☐	WZTERMD	ZTERM	CHAR	4	0	Terms of Payment Key for Customer
56	ZBD1TD	☐	WZBD1TD	ZBDXT	DEC	3	0	Cash Discount Period for Customer
57	ZBD1PD	☐	WZBD1PD	PRZ23	DEC	5	3	Cash discount percentage 1 customer
58	ZBD2TD	☐	WZBD2TD	ZBDXT	DEC	3	0	Cash discount period 2 customer
59	ZBD2PD	☐	WZBD2PD	PRZ23	DEC	5	3	Cash Discount Percentage 2 Customer
60	ZBD3TD	☐	WZBD3TD	ZBDXT	DEC	3	0	Deadline for Customer Net Condition
61	ZLSCHD	☐	SCHZW_BSEGD	ZLSCH	CHAR	1	0	Customer payment method	T042Z
62	GSKTOD	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
63	GSKTO	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
64	FKSTO	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
65	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
66	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
67	KNUMVD	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
68	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
69	LFAKS	☐	LFAKS	WBELN	CHAR	10	0	Agency business: cancelled (reversed) document	WBRK
70	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
71	LFART_RL	☐	WFART_RL	WFART	CHAR	4	0	Remuneration List Type, Vendor Billing Document
72	WFDAT_RL	☐	WFDAT_RL	DATUM	DATS	8	0	Agency Business: Posting Date for the Remuneration List
73	WBELN_RL	☐	WBELN_RL	WBELN	CHAR	10	0	Agency Business: Document Number of Remuneration List	WBRK
74	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
75	VALTG	☐	WVALTG	TAGE2	NUMC	2	0	Additional value days
76	VALDT	☐	WVALDT	DATUM	DATS	8	0	Fixed Value Date
77	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
78	MWSBKD	☐	MWSBPD	WERTV7	CURR	13	2	Tax amount in document currency (customer-side)
79	NAVNK	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
80	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
81	DIEKZ	☐	DIEKZ	DIEKZ	CHAR	1	0	Service indicator (foreign payment)
82	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
83	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	T015L
84	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
85	LFGRU	☐	WFGRU	WFGRU	CHAR	3	0	Agency business: Reason for activity	TMLFG
86	VALTGD	☐	WVALTD	TAGE2	NUMC	2	0	Additional Value Days (Customer)
87	VALDTD	☐	WVALDD	DATUM	DATS	8	0	Fixed Value Date (Customer)
88	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
89	WDTYP	☐	DOCTYPE	DOCTYPE	CHAR	1	0	Agency Business: Document Category
90	WKURS_P1	☐	WKURS_P1	KURSP	DEC	9	5	Agency business: Exchange rate of vendor payment currency
91	WKURS_P2	☐	WKURS_P2	KURSP	DEC	9	5	Agency business: Exchange rate of customer payment currency
92	WPYCUR_P1	☐	WPYCUR_P1	WAERS	CUKY	5	0	Currency for automatic payment (vendor-side)	TCURC
93	WPYCUR_P2	☐	WPYCUR_P2	WAERS	CUKY	5	0	Currency for automatic payment (customer-side)	TCURC
94	ESTATUS	☐	WSTATE	WSTATE	CHAR	4	0	Agency business: Application status	TMPA2
95	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
96	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
97	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
98	EXP_CLASS	☐	WB2_EXPENSE_CLASS	WB2_EXPENSE_CLASS	CHAR	3	0	GT Expenses: Expense Class	TWBEXCLASS
99	EXP_CALC_TYPE	☐	WB2_EXPENSE_CALC_TYPE	WB2_EXPENSE_CALC_TYPE	CHAR	1	0	GT Expenses: Calculation Type
100	SETTLE_DOC	☐	WLF_EXP_SETTLE_DOC	WBELN	CHAR	10	0	Global Trade Expenses: Settlement Document
101	DOC_SETTLED	☐	WB2_EXP_DOCUMENT_SETTLED	WB2_EXP_DOCUMENT_SETTLED	CHAR	1	0	GT Expenses: Document Settled
102	WBELN_LF_I	☐	WBELN_LF	WBELN	CHAR	10	0	Agency Business: Document Number	WBRK
103	NETWR_I	☐	NETWR_RL	WERTV8	CURR	15	2	Agency business: New value of item in a list
104	MWSBP_I	☐	MWSBPK	WERTV7	CURR	13	2	Tax amount in document currency
105	NAVNW_I	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
106	KWERT_RL_I	☐	WKWERT_RL	WERTV7	CURR	13	2	Value of the Remuneration List Condition of a Document
107	MWSBP_RL_I	☐	WMWSBP_RL	WERTV7	CURR	13	2	Tax of Remuneration List Conditions
108	LIFRE_I	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	LFA1
109	LNRZB_I	☐	W_LIFZE	LIFNR	CHAR	10	0	Agency business: Payee	LFA1
110	KUNRE_I	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	KNA1
111	KUNRG_I	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
112	LFTYP_I	☐	WFTYP	WFTYP	CHAR	2	0	Agency business: Billing category
113	LOGSYS_I	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system
114	TKONN_W	☐	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	WBHK
115	TPOSN_W	☐	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number	WBHI
116	TPOSN_SUB_W	☐	TPOSN_SUB	TPOSN	NUMC	6	0	Trading Contract: Sub-Item Number	WBHI
117	ERNAM_W	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
118	ERDAT_W	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
119	TEW_TYPE_W	☐	WB2_TEW_TYPE	WB2_TEW_TYPE	CHAR	4	0	Trading Execution Workbench Type	TEWTYPE
120	SCENARIO_W	☐	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario	TEWSCENARIO
121	TKONN_EX_W	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
122	COMPLETE_W	☐	WB2_DOCUMENT_COMPLETE_2	WB2_DOCUMENT_COMPLETE_2	CHAR	1	0	Global Trade: Item Closed
123	ERROR_TEW_W	☐	WB2B_ERROR_TEW	WB2B_ERROR_TEW	CHAR	1	0	Global Trade: Error in Follow-On Document Creation
124	BUSINESS_STEP_W	☐	WB2_STEP	WB2_STEP	CHAR	4	0	Business Process Step	TEWSTEP
125	MASTER_STEP_W	☐	WB2_MASTER_STEP	WB2_STEP	CHAR	4	0	Main Step
126	PRE_STEP_W	☐	WB2_PRE_STEP	WB2_STEP	CHAR	4	0	Previous Step of Business Process

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WB2_V_WBRK_WBRL	BUKRS	T001	BUKRS	KEY	1	CN
2	WB2_V_WBRK_WBRL	BUSINESS_STEP_W	TEWSTEP	STEP	KEY	1	CN
3	WB2_V_WBRK_WBRL	EKGRP	T024	EKGRP	KEY	1	CN
4	WB2_V_WBRK_WBRL	EKORG	T024E	EKORG	KEY	C	CN
5	WB2_V_WBRK_WBRL	ESTATUS	TMPA2	ESTATUS	KEY	1	CN
6	WB2_V_WBRK_WBRL	EXP_CLASS	TWBEXCLASS	EXP_CLASS	REF	1	CN
7	WB2_V_WBRK_WBRL	KALSM	T683	KALSM	REF	1	CN
8	WB2_V_WBRK_WBRL	KALSMD	T683	KALSM	REF	1	CN
9	WB2_V_WBRK_WBRL	KAPPL	T681A	KAPPL	KEY	1	CN
10	WB2_V_WBRK_WBRL	KKBER	T014	KKBER	KEY	1	CN
11	WB2_V_WBRK_WBRL	KNUMA	KONA	KNUMA	KEY	1	CN
12	WB2_V_WBRK_WBRL	KUNRE	KNA1	KUNNR	KEY	C	CN
13	WB2_V_WBRK_WBRL	KUNRE_I	KNA1	KUNNR	KEY	C	CN
14	WB2_V_WBRK_WBRL	KUNRG	KNA1	KUNNR	KEY	C	CN
15	WB2_V_WBRK_WBRL	KUNRG_I	KNA1	KUNNR	KEY	C	CN
16	WB2_V_WBRK_WBRL	KURST	TCURV	KURST	KEY	1	CN
17	WB2_V_WBRK_WBRL	LANDL	T005	LAND1	KEY	1	CN
18	WB2_V_WBRK_WBRL	LFAKS	WBRK	WBELN	KEY	1	CN
19	WB2_V_WBRK_WBRL	LFART	TMFK	LFART	REF	1	CN
20	WB2_V_WBRK_WBRL	LFGRU	TMLFG	LFGRU	KEY	1	CN
21	WB2_V_WBRK_WBRL	LIFRE	LFA1	LIFNR	KEY	C	CN
22	WB2_V_WBRK_WBRL	LIFRE_I	LFA1	LIFNR		1	CN
23	WB2_V_WBRK_WBRL	LNRZB	LFA1	LIFNR	KEY	C	CN
24	WB2_V_WBRK_WBRL	LNRZB_I	LFA1	LIFNR	KEY	C	CN
25	WB2_V_WBRK_WBRL	LOGSYS	TBDLS	LOGSYS	KEY	1	CN
26	WB2_V_WBRK_WBRL	LZBKZ	T015L	LZBKZ	KEY	1	CN
27	WB2_V_WBRK_WBRL	MANDT	T000	MANDT	KEY	1	CN
28	WB2_V_WBRK_WBRL	MANDT_I	T000	MANDT
29	WB2_V_WBRK_WBRL	MANDT_W	T000	MANDT
30	WB2_V_WBRK_WBRL	SCENARIO_W	TEWSCENARIO	SCENARIO	REF	1	CN
31	WB2_V_WBRK_WBRL	SPART	TSPA	SPART	KEY	C	CN
32	WB2_V_WBRK_WBRL	STAFO	TMCB	STAFO	KEY	1	CN
33	WB2_V_WBRK_WBRL	TEW_TYPE_W	TEWTYPE	TEW_TYPE	REF	1	CN
34	WB2_V_WBRK_WBRL	TKONN_W	WBHK	TKONN
35	WB2_V_WBRK_WBRL	TPOSN_SUB_W	WBHI	TPOSN_SUB
36	WB2_V_WBRK_WBRL	TPOSN_W	WBHI	TPOSN
37	WB2_V_WBRK_WBRL	VKBUR	TVBUR	VKBUR	REF	C	CN
38	WB2_V_WBRK_WBRL	VKGRP	TVKGR	VKGRP	REF	C	CN
39	WB2_V_WBRK_WBRL	VKORG	TVKO	VKORG	KEY	C	CN
40	WB2_V_WBRK_WBRL	VTWEG	TVTW	VTWEG	KEY	C	CN
41	WB2_V_WBRK_WBRL	WAERL	TCURC	WAERS	KEY	1	CN
42	WB2_V_WBRK_WBRL	WBELN_I	WBRK	WBELN		1	CN
43	WB2_V_WBRK_WBRL	WBELN_LF_I	WBRK	WBELN		1	CN
44	WB2_V_WBRK_WBRL	WBELN_RL	WBRK	WBELN	KEY	1	CN
45	WB2_V_WBRK_WBRL	WPYCUR_P1	TCURC	WAERS	KEY	1	CN
46	WB2_V_WBRK_WBRL	WPYCUR_P2	TCURC	WAERS	KEY	1	CN
47	WB2_V_WBRK_WBRL	WRART	TMZR	WRART	KEY	C	CN
48	WB2_V_WBRK_WBRL	WSTWAE	TCURC	WAERS		1	CN
49	WB2_V_WBRK_WBRL	ZLSCH	T042Z	ZLSCH	KEY	1	CN
50	WB2_V_WBRK_WBRL	ZLSCHD	T042Z	ZLSCH	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in