	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

165 COLUMNS | 1 INDEXES | ERP 6.0 | WBRP TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General :: Agency Business Global Trade
1	ERP EHP7	6.0	WBRP	165	1	Agency business: Item	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, POSNR, MATNR, MATKL, WERKS, MWSKZ, MWSK2, PRSDT, MENGE, NETPR, PEINH, WFKME, UMREZ, UMREN, FPRME, FPUMZ, FPUMN, MEINS, NTGEW, BRGEW, GEWEI, VOLUM, VOLEH, STAFO, MTART, NETWR, BRTWR, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, BONBA, EFFWR, ERNAM, ERDAT, ERZET, KOWRR, SKTOF, SKFBP, NETWRD, BRTWRD, KZWI1D, KZWI2D, KZWI3D, KZWI4D, KZWI5D, KZWI6D, BONBAD, SKFBPD, EFFWRD, MWSBPD, WBELNV, POSNRV, LFTYPV, GJAHRV, AKTNR, LFGRU, ARKTX, INFNR, IDNLF, MWSBP, TXJCD, EBONF, BONUS, EBON2, EBON3, LTSNR, EKKOL, PUNEI, ANZPU, KOLIF, NAVNW, BWTAR, BWTTY, GSBER, PAOBJNR, KOSTL, PRCTR, KOKRS, CHARG, WUVPRS, WBELN_V, POSNR_V, FTYPV_V, ITEMCAT, MATBF, MWERT_IM, MWERT_PR, MWERT_UM, CONTRACT, CONTRACT_TYPE, CONTRACT_ITEM, IDNLF_TYPE, ITEM_STATUS, ITEM_CANCELED, GUID_REF, BEMOT, AUFNR, SETTL_STATUS_I_V, SETTL_STATUS_I_C, SETTL_BLOCK_I_V, SETTL_BLOCK_I_C, SETTL_ITEM_REL, CUOBJ, FBUDA, J_1BNBM, J_1BMATUSE, J_1BMATORG, J_1BOWNPRO, J_1BINDUST, J_1BCFOP, J_1BTXSDC, J_1BTAXLW1, J_1BTAXLW2, J_1BTAXLW3, J_1BTAXLW4, J_1BTAXLW5, SAKTO, SERVCONF_ITEM, STATUS, IV_CHECK_TYPE_I, REFSITE, GJAHR, POSNR_MAIN, POSNR_SUB_EXIST, DISTRIB_STATUS, NO_TEXT_I, CWM_MENGE, CWM_MEINS, CWM_UOM_TYPE, REF_NUMBER, REF_ITEM_NUMBER, REF_TYPE, ITEM_INTRA_REL, GRWRT, GRWRTD, POSTING_RULE_K_I, POSTING_RULE_D_I, WEIGHT_VOLUME, PS_PSP_PNR, INCO1_P, INCO2_P, KOKRSD, PRCTRD, KOSTLD, PAOBJNRD, AUFNRD, PS_PSP_PNRD, GSBERD, COLL_STATUS_I, COLL_BLOCK_I, COLL_REL, CUSTOMER, INVC_ITEM_ID, REFERENCE_ID, REF_ITEM_ID, SCHEME_ID, SCHEME_A_ID, AGENCY_ID_CODE, REF_NUMBER_2, REF_ITEM_NUM_2, REF_TYPE_2 FROM WBRP

TOP ERP 6.0 | WBRP 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	WBRK	WBELN_AG	Allow NULL?
3	POSNR	Agency business: Document item	nvarchar	6	0	NUMC	(N'000000')	No		WPOSNR_LF	Allow NULL?
4	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
5	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
6	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
7	MWSKZ	Agency business: Tax code (input tax)	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ_LF	Allow NULL?
8	MWSK2	Agency business: Tax code (output tax)	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ_RB	Allow NULL?
9	PRSDT	Date for pricing and exchange rate	nvarchar	8	0	DATS	(N'00000000')	Yes		PRSDT	Allow NULL?
10	MENGE	Vendor billing document: actual quantity billed	decimal	13	3	QUAN	((0))	Yes		WFIMG
11	NETPR	Vendor billing document: net price in document currency	decimal	11	2	CURR	((0))	Yes		WNETPR
12	PEINH	Price Unit of Vendor Billing Document Item	decimal	5	0	DEC	((0))	Yes		WEINH
13	WFKME	Vendor billing document: unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	WFKME	Allow NULL?
14	UMREZ	Numerator converting qty in vendor bill.doc. to base unit	decimal	5	0	DEC	((0))	Yes		UMWFZ
15	UMREN	Factor for converting qty in vendor bill. doc. to base unit	decimal	5	0	DEC	((0))	Yes		UMWFN
16	FPRME	Billing price unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	WFPRME	Allow NULL?
17	FPUMZ	Vendor billing doc.: numerator for converting BPUn to PBUn	decimal	5	0	DEC	((0))	Yes		WPUMZ
18	FPUMN	Vendor billing doc.: denominator for converting BPUn to PBUn	decimal	5	0	DEC	((0))	Yes		WPUMN
19	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
20	NTGEW	Net Weight	decimal	15	3	QUAN	((0))	Yes		WLF_NTGEW_15
21	BRGEW	Gross Weight	decimal	15	3	QUAN	((0))	Yes		WLF_BRGEW_15
22	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	GEWEI	Allow NULL?
23	VOLUM	Volume	decimal	15	3	QUAN	((0))	Yes		WLF_VOLUM_15
24	VOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VOLEH	Allow NULL?
25	STAFO	Update group for statistics update	nvarchar	6	0	CHAR	(N' ')	Yes	TMCB	STAFO	Allow NULL?
26	MTART	Material Type	nvarchar	4	0	CHAR	(N' ')	Yes	T134	MTART	Allow NULL?
27	NETWR	Net value of the item in document currency	decimal	15	2	CURR	((0))	Yes		NETWR_LFP
28	BRTWR	Gross value of the item in document currency	decimal	15	2	CURR	((0))	Yes		BRTWR_LFP
29	KZWI1	Subtotal 1 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI1
30	KZWI2	Subtotal 2 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI2
31	KZWI3	Subtotal 3 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI3
32	KZWI4	Subtotal 4 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI4
33	KZWI5	Subtotal 5 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI5
34	KZWI6	Subtotal 6 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI6
35	BONBA	Rebate basis 1	decimal	13	2	CURR	((0))	Yes		BONBA
36	EFFWR	Effective Value of Item	decimal	13	2	CURR	((0))	Yes		WLF_EFFWR
37	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
38	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
39	ERZET	Entry time	nvarchar	6	0	TIMS	(N'000000')	Yes		ERZET	Allow NULL?
40	KOWRR	Statistical Values	char	1	0	CHAR	(N' ')	Yes		WKOWRR	Allow NULL?
41	SKTOF	Cash discount indicator	char	1	0	CHAR	(N' ')	Yes		SKTOF	Allow NULL?
42	SKFBP	Amount eligible for cash discount in document currency	decimal	13	2	CURR	((0))	Yes		SKFBP
43	NETWRD	Net value of the item in document currency (customer-side)	decimal	15	2	CURR	((0))	Yes		NETWRD_LFP
44	BRTWRD	Gross value of item in document currency (customer-side)	decimal	15	2	CURR	((0))	Yes		BRTWRD_LFP
45	KZWI1D	Subtotal 1 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI1
46	KZWI2D	Subtotal 2 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI2
47	KZWI3D	Subtotal 3 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI3
48	KZWI4D	Subtotal 4 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI4
49	KZWI5D	Subtotal 5 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI5
50	KZWI6D	Subtotal 6 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI6
51	BONBAD	Rebate basis 1	decimal	13	2	CURR	((0))	Yes		BONBA
52	SKFBPD	Amount qualifying for cash discount in doc. currency (cust.)	decimal	13	2	CURR	((0))	Yes		SKFBPD
53	EFFWRD	Effective value of the item (customer-side)	decimal	13	2	CURR	((0))	Yes		EFFWRD
54	MWSBPD	Tax amount in document currency (customer-side)	decimal	13	2	CURR	((0))	Yes		MWSBPD
55	WBELNV	Agency business: Document number of the reference document	nvarchar	10	0	CHAR	(N' ')	Yes		WBELNV	Allow NULL?
56	POSNRV	Item number of the reference document item	nvarchar	6	0	NUMC	(N'000000')	Yes		WPOSNRV	Allow NULL?
57	LFTYPV	Agency Business: Document Category of Preceding Document	nvarchar	2	0	CHAR	(N' ')	Yes		WFTYPV	Allow NULL?
58	GJAHRV	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
59	AKTNR	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	WAKH	WAKTION	Allow NULL?
60	LFGRU	Agency business: Reason for activity	nvarchar	3	0	CHAR	(N' ')	Yes	TMLFG	WFGRU	Allow NULL?
61	ARKTX	Short Text	nvarchar	40	0	CHAR	(N' ')	Yes		TXZ01	Allow NULL?
62	INFNR	Number of Purchasing Info Record	nvarchar	10	0	CHAR	(N' ')	Yes	EINA	INFNR	Allow NULL?
63	IDNLF	Material Number Used by Vendor	nvarchar	35	0	CHAR	(N' ')	Yes		IDNLF	Allow NULL?
64	MWSBP	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		MWSBP
65	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	TTXJ	TXJCD	Allow NULL?
66	EBONF	Item Relevant to Subsequent (Period-End Rebate) Settlement	char	1	0	CHAR	(N' ')	Yes		EBONY	Allow NULL?
67	BONUS	Settlement Group 1 (Purchasing)	nvarchar	2	0	CHAR	(N' ')	Yes		EBONU	Allow NULL?
68	EBON2	Settlement Group 2 (Rebate Settlement, Purchasing)	nvarchar	2	0	CHAR	(N' ')	Yes		EBON2	Allow NULL?
69	EBON3	Settlement Group 3 (Rebate Settlement, Purchasing)	nvarchar	2	0	CHAR	(N' ')	Yes		EBON3	Allow NULL?
70	LTSNR	Vendor Subrange	nvarchar	6	0	CHAR	(N' ')	Yes	WYT1	LTSNR	Allow NULL?
71	EKKOL	Condition Group with Vendor	nvarchar	4	0	CHAR	(N' ')	Yes		EKKOG	Allow NULL?
72	PUNEI	Points unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	PUNEI	Allow NULL?
73	ANZPU	Number of Points	decimal	13	3	QUAN	((0))	Yes		ANZPU
74	KOLIF	Prior Vendor	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	KOLIF	Allow NULL?
75	NAVNW	Non-deductible input tax	decimal	13	2	CURR	((0))	Yes		NAVNW
76	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
77	BWTTY	Valuation Category	char	1	0	CHAR	(N' ')	Yes	T149C	BWTTY_D	Allow NULL?
78	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
79	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
80	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
81	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	PRCTR	Allow NULL?
82	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
83	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCH1	CHARG_D	Allow NULL?
84	WUVPRS	Agency business: Item incomplete re. price determination	char	1	0	CHAR	(N' ')	Yes		WUVPRS	Allow NULL?
85	WBELN_V	Triggering document of the agency document	nvarchar	10	0	CHAR	(N' ')	Yes		WBELN_V	Allow NULL?
86	POSNR_V	Triggering item in the agency document	nvarchar	6	0	NUMC	(N'000000')	Yes		POSNR_V	Allow NULL?
87	FTYPV_V	Agency Business: Document Category of Triggering Document	nvarchar	2	0	CHAR	(N' ')	Yes		WFTYP_V	Allow NULL?
88	ITEMCAT	Agency Business: Item Category	char	1	0	CHAR	(N' ')	Yes		WSHKZG	Allow NULL?
89	MATBF	Material in Respect of Which Stock is Managed	nvarchar	18	0	CHAR	(N' ')	Yes	*	MATBF	Allow NULL?
90	MWERT_IM	Net Value in Document Currency	decimal	15	2	CURR	((0))	Yes		NETWR
91	MWERT_PR	Net Value in Document Currency	decimal	15	2	CURR	((0))	Yes		NETWR
92	MWERT_UM	Net Value in Document Currency	decimal	15	2	CURR	((0))	Yes		NETWR
93	CONTRACT	Referencing Contract Number	nvarchar	10	0	CHAR	(N' ')	Yes		WCONTRACT	Allow NULL?
94	CONTRACT_TYPE	Contract Type for Contract Number	char	1	0	CHAR	(N' ')	Yes		WCONTRACT_TYPE	Allow NULL?
95	CONTRACT_ITEM	Referencing Contract Item Number	nvarchar	6	0	NUMC	(N'000000')	Yes		WCONTRACT_ITEM	Allow NULL?
96	IDNLF_TYPE	AB: Article Number Type - Vendor	nvarchar	4	0	CHAR	(N' ')	Yes	TMVMT	WLF_IDNLF_TYPE	Allow NULL?
97	ITEM_STATUS	Agency Business: Item Status	char	1	0	CHAR	(N' ')	Yes		WLF_ITEM_STATUS	Allow NULL?
98	ITEM_CANCELED	Item Was Canceled	char	1	0	CHAR	(N' ')	Yes		WLF_ITEM_CANCELED	Allow NULL?
99	GUID_REF	AB: GUID of Reference Document	varbinary	16	0	RAW		Yes		WLF_GUID_REFERENCE
100	BEMOT	Accounting Indicator	nvarchar	2	0	CHAR	(N' ')	Yes	TBMOT	BEMOT	Allow NULL?
101	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
102	SETTL_STATUS_I_V	AB: Settlement Status - Item - Vendor	char	1	0	CHAR	(N' ')	Yes		WLF_SETTLEMENT_STATUS_ITEM_V	Allow NULL?
103	SETTL_STATUS_I_C	AB: Settlement Status - Item - Customer	char	1	0	CHAR	(N' ')	Yes		WLF_SETTLEMENT_STATUS_ITEM_C	Allow NULL?
104	SETTL_BLOCK_I_V	AB: Settlement Block - Item - Vendor	nvarchar	2	0	CHAR	(N' ')	Yes	TMSB	WLF_SETTLEMENT_BLOCK_ITEM_V	Allow NULL?
105	SETTL_BLOCK_I_C	AB: Settlement Block - Item - Customer	nvarchar	2	0	CHAR	(N' ')	Yes	TMSB	WLF_SETTLEMENT_BLOCK_ITEM_C	Allow NULL?
106	SETTL_ITEM_REL	AB: Item Settlement Relevance	char	1	0	CHAR	(N' ')	Yes		WLF_SETTLEMENT_ITEM_RELEVANCE	Allow NULL?
107	CUOBJ	Configuration	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ_VA	Allow NULL?
108	FBUDA	Date on which services rendered	nvarchar	8	0	DATS	(N'00000000')	Yes		FBUDA	Allow NULL?
109	J_1BNBM	Brazilian NCM Code	nvarchar	16	0	CHAR	(N' ')	Yes	T604F	J_1BNBMCO1	Allow NULL?
110	J_1BMATUSE	Usage of the material	char	1	0	CHAR	(N' ')	Yes		J_1BMATUSE	Allow NULL?
111	J_1BMATORG	Origin of the material	char	1	0	CHAR	(N' ')	Yes		J_1BMATORG	Allow NULL?
112	J_1BOWNPRO	Produced in-house	char	1	0	CHAR	(N' ')	Yes		J_1BOWNPRO	Allow NULL?
113	J_1BINDUST	Material CFOP category	nvarchar	2	0	CHAR	(N' ')	Yes		J_1BINDUS3	Allow NULL?
114	J_1BCFOP	CFOP Code and Extension	nvarchar	10	0	CHAR	(N' ')	Yes	J_1BAG	J_1BCFOP	Allow NULL?
115	J_1BTXSDC	SD tax code	nvarchar	2	0	CHAR	(N' ')	Yes	J_1BTXSDC	J_1BTXSDC_	Allow NULL?
116	J_1BTAXLW1	Tax law: ICMS	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL1	J_1BTAXLW1	Allow NULL?
117	J_1BTAXLW2	Tax law: IPI	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL2	J_1BTAXLW2	Allow NULL?
118	J_1BTAXLW3	ISS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL3	J_1BTAXLW3	Allow NULL?
119	J_1BTAXLW4	COFINS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL4A	J_1BTAXLW4	Allow NULL?
120	J_1BTAXLW5	PIS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL5	J_1BTAXLW5	Allow NULL?
121	SAKTO	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	SAKNR	Allow NULL?
122	SERVCONF_ITEM	FSL: Service Confirmation Item	nvarchar	10	0	NUMC	(N'0000000000')	Yes		FSL_SERVCONF_ITEM	Allow NULL?
123	STATUS	FSL: User Status for Item	nvarchar	4	0	CHAR	(N' ')	Yes	FSL_STAT_CUST	FSL_STATUS	Allow NULL?
124	IV_CHECK_TYPE_I	Type of Check (Item)	char	1	0	CHAR	(N' ')	Yes		WLF_IV_CHECK_TYPE_ITEM	Allow NULL?
125	REFSITE	Reference Site For Purchasing	nvarchar	4	0	CHAR	(N' ')	Yes		WREFSITE	Allow NULL?
126	GJAHR	CCS: Fiscal Year of Settlement	nvarchar	4	0	NUMC	(N'0000')	Yes		WB2_CCS_GJAHR	Allow NULL?
127	POSNR_MAIN	Main Item for Item	nvarchar	6	0	NUMC	(N'000000')	Yes	*	WLF_POSNR_MAIN	Allow NULL?
128	POSNR_SUB_EXIST	Subitems Exist	char	1	0	CHAR	(N' ')	Yes		WLF_POSNR_SUB_EXIST	Allow NULL?
129	DISTRIB_STATUS	AB: Status Distribution of Item	char	1	0	CHAR	(N' ')	Yes		WLF_DISTRIBUTION_STATUS	Allow NULL?
130	NO_TEXT_I	No Texts Exist	char	1	0	CHAR	(N' ')	Yes		WLF_NO_TEXT	Allow NULL?
131	CWM_MENGE	Quantity in Parallel Unit of Measure	decimal	13	3	QUAN	((0))	Yes		WLF_CWM_MENGE
132	CWM_MEINS	AB: Parallel Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	WLF_CWM_MEINS	Allow NULL?
133	CWM_UOM_TYPE	AB: Type of the Parallel Unit of Measure	char	1	0	CHAR	(N' ')	Yes		WLF_CWM_UOM_TYPE	Allow NULL?
134	REF_NUMBER	Reference Document for Agency Document	nvarchar	32	0	CHAR	(N' ')	Yes		WLF_REF_NUMBER	Allow NULL?
135	REF_ITEM_NUMBER	Reference Document Item for Agency Document	nvarchar	10	0	NUMC	(N'0000000000')	Yes		WLF_REF_ITEM_NUMBER	Allow NULL?
136	REF_TYPE	Reference Document Category	nvarchar	2	0	CHAR	(N' ')	Yes		WLF_REF_TYPE	Allow NULL?
137	ITEM_INTRA_REL	Document Item is Relevant for Intrastat Declarations	char	1	0	CHAR	(N' ')	Yes		WLF_ITEM_INTRASTAT_RELEVANT	Allow NULL?
138	GRWRT	Statistical value for foreign trade	decimal	13	2	CURR	((0))	Yes		GRWRT
139	GRWRTD	Statistical Value for Foreign Trade (Customer-Side)	decimal	13	2	CURR	((0))	Yes		GRWRTD
140	POSTING_RULE_K_I	AB: Creditor Posting Rule - Item	nvarchar	2	0	CHAR	(N' ')	Yes	TMPR	WLF_POSTING_RULE_K_ITEM	Allow NULL?
141	POSTING_RULE_D_I	AB: Debtor Posting Rule - Item	nvarchar	2	0	CHAR	(N' ')	Yes	TMPR	WLF_POSTING_RULE_D_ITEM	Allow NULL?
142	WEIGHT_VOLUME	Level on which You Enter Weight and Volume	char	1	0	CHAR	(N' ')	Yes		WLF_WEIGHT_VOLUME_LEVEL	Allow NULL?
143	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_PNR	Allow NULL?
144	INCO1_P	Incoterms (Part 1)	nvarchar	3	0	CHAR	(N' ')	Yes	TINC	INCO1	Allow NULL?
145	INCO2_P	Incoterms (Part 2)	nvarchar	28	0	CHAR	(N' ')	Yes		INCO2	Allow NULL?
146	KOKRSD	Customer Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	WLF_KOKRS_CUSTOMER	Allow NULL?
147	PRCTRD	Customer Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	WLF_PRCTR_CUSTOMER	Allow NULL?
148	KOSTLD	Customer Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	WLF_KOSTL_CUSTOMER	Allow NULL?
149	PAOBJNRD	Customer Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		WLF_PAOBJNR_CUSTOMER	Allow NULL?
150	AUFNRD	Customer Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	WLF_AUFNR_CUSTOMER	Allow NULL?
151	PS_PSP_PNRD	Customer Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	WLF_PS_PSP_PNR_CUSTOMER	Allow NULL?
152	GSBERD	Customer Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	WLF_GSBER_CUSTOMER	Allow NULL?
153	COLL_STATUS_I	AB: Status for Collection of Settlement Request Item	char	1	0	CHAR	(N' ')	Yes		WLF_COLLECTION_STATUS_ITEM	Allow NULL?
154	COLL_BLOCK_I	AB: Block Item for Collection of Settlement Requests	nvarchar	2	0	CHAR	(N' ')	Yes	TMSB	WLF_COLLECTION_BLOCK_ITEM	Allow NULL?
155	COLL_REL	AB: Relevance for Collection of Settlement Requests	char	1	0	CHAR	(N' ')	Yes		WLF_COLLECTION_RELEVANCE	Allow NULL?
156	CUSTOMER	Customer	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	WLF_CUSTOMER	Allow NULL?
157	INVC_ITEM_ID	BusinessTransactionDocumentItemID	nvarchar	10	0	CHAR	(N' ')	Yes		WLF_BTD_ITEM_ID	Allow NULL?
158	REFERENCE_ID	BusinessTransactionDocumentID	nvarchar	35	0	CHAR	(N' ')	Yes		WLF_REF_ID	Allow NULL?
159	REF_ITEM_ID	BusinessTransactionDocumentItemID	nvarchar	10	0	CHAR	(N' ')	Yes		WLF_REF_ITEM_ID	Allow NULL?
160	SCHEME_ID	AB: Identifier for the ID Scheme	nvarchar	60	0	CHAR	(N' ')	Yes		WLF_SCHEME_ID	Allow NULL?
161	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?
162	AGENCY_ID_CODE	AB: Agency of Standard ID for Invoice Document	nvarchar	3	0	CHAR	(N' ')	Yes		WLF_AGENCY_ID_CODE	Allow NULL?
163	REF_NUMBER_2	Additional Reference Document for Agency Document	nvarchar	32	0	CHAR	(N' ')	Yes		WLF_REF_NUMBER_2	Allow NULL?
164	REF_ITEM_NUM_2	Additional Reference Document Item for Agency Document	nvarchar	10	0	NUMC	(N'0000000000')	Yes		WLF_REF_ITEM_NUMBER_2	Allow NULL?
165	REF_TYPE_2	Additional Reference Document Category	nvarchar	2	0	CHAR	(N' ')	Yes		WLF_REF_TYPE_2	Allow NULL?

TOP ERP 6.0 | WBRP INDEXES

Name	Primary	Unique	Type	Columns
WBRP~0	Yes	Yes	CLUSTERED	MANDT, WBELN, POSNR

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

165 COLUMNS | 1 INDEXES | ERP 6.0 | WBRP TABLE

TOP ERP 6.0 | WBRP COLUMNS

TOP ERP 6.0 | WBRP 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

165 COLUMNS | 1 INDEXES | ERP 6.0 | WBRP TABLE

TOPERP 6.0 | WBRP COLUMNS

TOPERP 6.0 | WBRP INDEXES

TOP ERP 6.0 | WBRP COLUMNS

TOP ERP 6.0 | WBRP INDEXES