	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

172 COLUMNS | 7 INDEXES | ERP 6.0 | WBRK TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General :: Agency Business Global Trade
1	ERP EHP7	6.0	WBRK	172	7	Agency business: Header	Agency Business Global Trade

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, WBELN, LFART, LFTYP, WRART, WBTYP, WRTYP, ABART, KALSM, KALSMD, WFDAT, RFBSK, LIFRE, LNRZB, KUNRE, KUNRG, EKORG, VKORG, VTWEG, SPART, BUKRS, ERZET, ERDAT, ERNAM, AEDAT, BLDAT, XBLNR, ZUONR, WAERL, WSTWAE, WKURS, STCUR, KUFIX, WKURS_DAT, BRTWR, ZTERM, ZBD1T, ZBD1P, ZBD2T, ZBD2P, ZBD3T, ZLSCH, NETWR, NETWRD, BRTWRD, ZTERMD, ZBD1TD, ZBD1PD, ZBD2TD, ZBD2PD, ZBD3TD, ZLSCHD, GSKTOD, GSKTO, FKSTO, KAPPL, KNUMV, KNUMVD, STAFO, LFAKS, KNUMA, LFART_RL, WFDAT_RL, WBELN_RL, EKGRP, VALTG, VALDT, MWSBK, MWSBKD, NAVNK, LOGSYS, DIEKZ, LANDL, LZBKZ, KKBER, LFGRU, VALTGD, VALDTD, KIDNO, WDTYP, WKURS_P1, WKURS_P2, WPYCUR_P1, WPYCUR_P2, ESTATUS, KURST, VKBUR, VKGRP, SETTLE_DOC, FKSTO_PART, POST_PARTY, CPDK_ADDR, FKSTO_PARTY, CONTRACT, CONTRACT_TYPE, COLLECTION_TYPE, CMWAE, CTLPC, CM_AMOUNT, SETTLE_CATEGORY, IDOBJ_TYPE_V, IDOBJ_VENDOR, IDOBJ_TYPE_C, IDOBJ_CUSTOMER, POSTING_RULE_K, POSTING_RULE_D, POSTING_RULE_A, VKONT, WT_ACTIVE, BUKRS_DEB, SETTL_PARTY, SETTL_STATUS_V, SETTL_STATUS_C, SETTL_DOCTYPE_V, SETTL_DOCTYPE_C, SETTL_METHOD, SETTL_BLOCK_V, SETTL_BLOCK_C, CPDL_ADDR, MONAT, SERVCONF_ID, COUNTER, COUNTER_UNIT, EXP_CLASS, EXP_CALC_TYPE, DOC_SETTLED, REF_VALUE_REF, REF_VALUE, POST_TYPE, TEW_TYPE, STEP, PARTNER_EXP, STEP_FROM, STEP_TEW, MODE, PARTNER_EXP_TYPE, IV_CHECK_TYPE_H, IV_ACCR, RRLCG, RRLPA, CORR_DOCUMENT, INCOMP_REASON, LIFNR_FI, DISTRIB_INCOMP, RFBSK_COMB_SETT, NO_TEXT_H, INTRASTAT_REL, LANDTX, LAND1TX, XEGDR, STCEG, STCEGD, INTRASTAT_FLOW_D, INCO1, INCO2, WKURS_DEB, SETTLEMENT_DATE, PROCESS_TYPE, BANK_DATA, COLL_STATUS, IS_COLLECTION, COLL_BLOCK, REF_SETTL_DATE, USE_CASE, USE_CASE_GUID, INVOICE_ID, SCHEME_ID, SCHEME_A_ID, AGENCY_ID_CODE, ITCUP, ITCIG, MNDID FROM WBRK

TOP ERP 6.0 | WBRK COLUMNS

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

TOP ERP 6.0 | WBRK INDEXES

Name	Primary	Unique	Type	Columns
WBRK~0	Yes	Yes	CLUSTERED	MANDT, WBELN
WBRK~001	No	No	NONCLUSTERED	MANDT, WFDAT, RFBSK
WBRK~002	No	No	NONCLUSTERED	MANDT, LIFRE
WBRK~003	No	No	NONCLUSTERED	MANDT, EKORG, EKGRP
WBRK~004	No	No	NONCLUSTERED	MANDT, KUNRG
WBRK~005	No	No	NONCLUSTERED	MANDT, VKORG
WBRK~007	No	No	NONCLUSTERED	MANDT, BUKRS, XBLNR

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

172 COLUMNS | 7 INDEXES | ERP 6.0 | WBRK TABLE

TOP ERP 6.0 | WBRK COLUMNS

TOP ERP 6.0 | WBRK INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

172 COLUMNS | 7 INDEXES | ERP 6.0 | WBRK TABLE

TOPERP 6.0 | WBRK COLUMNS

TOPERP 6.0 | WBRK INDEXES

TOP ERP 6.0 | WBRK COLUMNS

TOP ERP 6.0 | WBRK INDEXES