SAP ABAP Table WB2_V_VBRK_VBRL (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20130529
SAP Release Created in