ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

	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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	WBELN	Agency Business: Document Number	nvarchar	10	0	Allow NULL?
3	POSNR	Agency business: Document item	nvarchar	6	0	Allow NULL?
4	MATNR	Material Number	nvarchar	18	0	Allow NULL?
5	MATKL	Material Group	nvarchar	9	0	Allow NULL?
6	WERKS	Plant	nvarchar	4	0	Allow NULL?
7	MWSKZ	Agency business: Tax code (input tax)	nvarchar	2	0	Allow NULL?
8	MWSK2	Agency business: Tax code (output tax)	nvarchar	2	0	Allow NULL?
9	PRSDT	Date for pricing and exchange rate	nvarchar	8	0	Allow NULL?
10	MENGE	Vendor billing document: actual quantity billed	decimal	13	3
11	NETPR	Vendor billing document: net price in document currency	decimal	11	2
12	PEINH	Price Unit of Vendor Billing Document Item	decimal	5	0
13	WFKME	Vendor billing document: unit of measure	nvarchar	3	0	Allow NULL?
14	UMREZ	Numerator converting qty in vendor bill.doc. to base unit	decimal	5	0
15	UMREN	Factor for converting qty in vendor bill. doc. to base unit	decimal	5	0
16	FPRME	Billing price unit	nvarchar	3	0	Allow NULL?
17	FPUMZ	Vendor billing doc.: numerator for converting BPUn to PBUn	decimal	5	0
18	FPUMN	Vendor billing doc.: denominator for converting BPUn to PBUn	decimal	5	0
19	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
20	NTGEW	Net Weight	decimal	15	3
21	BRGEW	Gross Weight	decimal	15	3
22	GEWEI	Weight Unit	nvarchar	3	0	Allow NULL?
23	VOLUM	Volume	decimal	15	3
24	VOLEH	Volume unit	nvarchar	3	0	Allow NULL?
25	STAFO	Update group for statistics update	nvarchar	6	0	Allow NULL?
26	MTART	Material Type	nvarchar	4	0	Allow NULL?
27	NETWR	Net value of the item in document currency	decimal	15	2
28	BRTWR	Gross value of the item in document currency	decimal	15	2
29	KZWI1	Subtotal 1 from pricing procedure for condition	decimal	13	2
30	KZWI2	Subtotal 2 from pricing procedure for condition	decimal	13	2
31	KZWI3	Subtotal 3 from pricing procedure for condition	decimal	13	2
32	KZWI4	Subtotal 4 from pricing procedure for condition	decimal	13	2
33	KZWI5	Subtotal 5 from pricing procedure for condition	decimal	13	2
34	KZWI6	Subtotal 6 from pricing procedure for condition	decimal	13	2
35	BONBA	Rebate basis 1	decimal	13	2
36	EFFWR	Effective Value of Item	decimal	13	2
37	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
38	ERDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
39	ERZET	Entry time	nvarchar	6	0	Allow NULL?
40	KOWRR	Statistical Values	char	1	0	Allow NULL?
41	SKTOF	Cash discount indicator	char	1	0	Allow NULL?
42	SKFBP	Amount eligible for cash discount in document currency	decimal	13	2
43	NETWRD	Net value of the item in document currency (customer-side)	decimal	15	2
44	BRTWRD	Gross value of item in document currency (customer-side)	decimal	15	2
45	KZWI1D	Subtotal 1 from pricing procedure for condition	decimal	13	2
46	KZWI2D	Subtotal 2 from pricing procedure for condition	decimal	13	2
47	KZWI3D	Subtotal 3 from pricing procedure for condition	decimal	13	2
48	KZWI4D	Subtotal 4 from pricing procedure for condition	decimal	13	2
49	KZWI5D	Subtotal 5 from pricing procedure for condition	decimal	13	2
50	KZWI6D	Subtotal 6 from pricing procedure for condition	decimal	13	2
51	BONBAD	Rebate basis 1	decimal	13	2
52	SKFBPD	Amount qualifying for cash discount in doc. currency (cust.)	decimal	13	2
53	EFFWRD	Effective value of the item (customer-side)	decimal	13	2
54	MWSBPD	Tax amount in document currency (customer-side)	decimal	13	2
55	WBELNV	Agency business: Document number of the reference document	nvarchar	10	0	Allow NULL?
56	POSNRV	Item number of the reference document item	nvarchar	6	0	Allow NULL?
57	LFTYPV	Agency Business: Document Category of Preceding Document	nvarchar	2	0	Allow NULL?
58	GJAHRV	Fiscal Year	nvarchar	4	0	Allow NULL?
59	AKTNR	Promotion	nvarchar	10	0	Allow NULL?
60	LFGRU	Agency business: Reason for activity	nvarchar	3	0	Allow NULL?
61	ARKTX	Short Text	nvarchar	40	0	Allow NULL?
62	INFNR	Number of Purchasing Info Record	nvarchar	10	0	Allow NULL?
63	IDNLF	Material Number Used by Vendor	nvarchar	35	0	Allow NULL?
64	MWSBP	Tax amount in document currency	decimal	13	2
65	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
66	EBONF	Item Relevant to Subsequent (Period-End Rebate) Settlement	char	1	0	Allow NULL?
67	BONUS	Settlement Group 1 (Purchasing)	nvarchar	2	0	Allow NULL?
68	EBON2	Settlement Group 2 (Rebate Settlement, Purchasing)	nvarchar	2	0	Allow NULL?
69	EBON3	Settlement Group 3 (Rebate Settlement, Purchasing)	nvarchar	2	0	Allow NULL?
70	LTSNR	Vendor Subrange	nvarchar	6	0	Allow NULL?
71	EKKOL	Condition Group with Vendor	nvarchar	4	0	Allow NULL?
72	PUNEI	Points unit	nvarchar	3	0	Allow NULL?
73	ANZPU	Number of Points	decimal	13	3
74	KOLIF	Prior Vendor	nvarchar	10	0	Allow NULL?
75	NAVNW	Non-deductible input tax	decimal	13	2
76	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
77	BWTTY	Valuation Category	char	1	0	Allow NULL?
78	GSBER	Business Area	nvarchar	4	0	Allow NULL?
79	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
80	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
81	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
82	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
83	CHARG	Batch Number	nvarchar	10	0	Allow NULL?
84	WUVPRS	Agency business: Item incomplete re. price determination	char	1	0	Allow NULL?
85	WBELN_V	Triggering document of the agency document	nvarchar	10	0	Allow NULL?
86	POSNR_V	Triggering item in the agency document	nvarchar	6	0	Allow NULL?
87	FTYPV_V	Agency Business: Document Category of Triggering Document	nvarchar	2	0	Allow NULL?
88	ITEMCAT	Agency Business: Item Category	char	1	0	Allow NULL?
89	MATBF	Material in Respect of Which Stock is Managed	nvarchar	18	0	Allow NULL?
90	MWERT_IM	Net Value in Document Currency	decimal	15	2
91	MWERT_PR	Net Value in Document Currency	decimal	15	2
92	MWERT_UM	Net Value in Document Currency	decimal	15	2
93	CONTRACT	Referencing Contract Number	nvarchar	10	0	Allow NULL?
94	CONTRACT_TYPE	Contract Type for Contract Number	char	1	0	Allow NULL?
95	CONTRACT_ITEM	Referencing Contract Item Number	nvarchar	6	0	Allow NULL?
96	IDNLF_TYPE	AB: Article Number Type - Vendor	nvarchar	4	0	Allow NULL?
97	ITEM_STATUS	Agency Business: Item Status	char	1	0	Allow NULL?
98	ITEM_CANCELED	Item Was Canceled	char	1	0	Allow NULL?
99	GUID_REF	AB: GUID of Reference Document	varbinary	16	0
100	BEMOT	Accounting Indicator	nvarchar	2	0	Allow NULL?
101	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
102	SETTL_STATUS_I_V	AB: Settlement Status - Item - Vendor	char	1	0	Allow NULL?
103	SETTL_STATUS_I_C	AB: Settlement Status - Item - Customer	char	1	0	Allow NULL?
104	SETTL_BLOCK_I_V	AB: Settlement Block - Item - Vendor	nvarchar	2	0	Allow NULL?
105	SETTL_BLOCK_I_C	AB: Settlement Block - Item - Customer	nvarchar	2	0	Allow NULL?
106	SETTL_ITEM_REL	AB: Item Settlement Relevance	char	1	0	Allow NULL?
107	CUOBJ	Configuration	nvarchar	18	0	Allow NULL?
108	FBUDA	Date on which services rendered	nvarchar	8	0	Allow NULL?
109	J_1BNBM	Brazilian NCM Code	nvarchar	16	0	Allow NULL?
110	J_1BMATUSE	Usage of the material	char	1	0	Allow NULL?
111	J_1BMATORG	Origin of the material	char	1	0	Allow NULL?
112	J_1BOWNPRO	Produced in-house	char	1	0	Allow NULL?
113	J_1BINDUST	Material CFOP category	nvarchar	2	0	Allow NULL?
114	J_1BCFOP	CFOP Code and Extension	nvarchar	10	0	Allow NULL?
115	J_1BTXSDC	SD tax code	nvarchar	2	0	Allow NULL?
116	J_1BTAXLW1	Tax law: ICMS	nvarchar	3	0	Allow NULL?
117	J_1BTAXLW2	Tax law: IPI	nvarchar	3	0	Allow NULL?
118	J_1BTAXLW3	ISS Tax Law	nvarchar	3	0	Allow NULL?
119	J_1BTAXLW4	COFINS Tax Law	nvarchar	3	0	Allow NULL?
120	J_1BTAXLW5	PIS Tax Law	nvarchar	3	0	Allow NULL?
121	SAKTO	G/L Account Number	nvarchar	10	0	Allow NULL?
122	SERVCONF_ITEM	FSL: Service Confirmation Item	nvarchar	10	0	Allow NULL?
123	STATUS	FSL: User Status for Item	nvarchar	4	0	Allow NULL?
124	IV_CHECK_TYPE_I	Type of Check (Item)	char	1	0	Allow NULL?
125	REFSITE	Reference Site For Purchasing	nvarchar	4	0	Allow NULL?
126	GJAHR	CCS: Fiscal Year of Settlement	nvarchar	4	0	Allow NULL?
127	POSNR_MAIN	Main Item for Item	nvarchar	6	0	Allow NULL?
128	POSNR_SUB_EXIST	Subitems Exist	char	1	0	Allow NULL?
129	DISTRIB_STATUS	AB: Status Distribution of Item	char	1	0	Allow NULL?
130	NO_TEXT_I	No Texts Exist	char	1	0	Allow NULL?
131	CWM_MENGE	Quantity in Parallel Unit of Measure	decimal	13	3
132	CWM_MEINS	AB: Parallel Unit of Measure	nvarchar	3	0	Allow NULL?
133	CWM_UOM_TYPE	AB: Type of the Parallel Unit of Measure	char	1	0	Allow NULL?
134	REF_NUMBER	Reference Document for Agency Document	nvarchar	32	0	Allow NULL?
135	REF_ITEM_NUMBER	Reference Document Item for Agency Document	nvarchar	10	0	Allow NULL?
136	REF_TYPE	Reference Document Category	nvarchar	2	0	Allow NULL?
137	ITEM_INTRA_REL	Document Item is Relevant for Intrastat Declarations	char	1	0	Allow NULL?
138	GRWRT	Statistical value for foreign trade	decimal	13	2
139	GRWRTD	Statistical Value for Foreign Trade (Customer-Side)	decimal	13	2
140	POSTING_RULE_K_I	AB: Creditor Posting Rule - Item	nvarchar	2	0	Allow NULL?
141	POSTING_RULE_D_I	AB: Debtor Posting Rule - Item	nvarchar	2	0	Allow NULL?
142	WEIGHT_VOLUME	Level on which You Enter Weight and Volume	char	1	0	Allow NULL?
143	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
144	INCO1_P	Incoterms (Part 1)	nvarchar	3	0	Allow NULL?
145	INCO2_P	Incoterms (Part 2)	nvarchar	28	0	Allow NULL?
146	KOKRSD	Customer Controlling Area	nvarchar	4	0	Allow NULL?
147	PRCTRD	Customer Profit Center	nvarchar	10	0	Allow NULL?
148	KOSTLD	Customer Cost Center	nvarchar	10	0	Allow NULL?
149	PAOBJNRD	Customer Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
150	AUFNRD	Customer Order Number	nvarchar	12	0	Allow NULL?
151	PS_PSP_PNRD	Customer Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
152	GSBERD	Customer Business Area	nvarchar	4	0	Allow NULL?
153	COLL_STATUS_I	AB: Status for Collection of Settlement Request Item	char	1	0	Allow NULL?
154	COLL_BLOCK_I	AB: Block Item for Collection of Settlement Requests	nvarchar	2	0	Allow NULL?
155	COLL_REL	AB: Relevance for Collection of Settlement Requests	char	1	0	Allow NULL?
156	CUSTOMER	Customer	nvarchar	10	0	Allow NULL?
157	INVC_ITEM_ID	BusinessTransactionDocumentItemID	nvarchar	10	0	Allow NULL?
158	REFERENCE_ID	BusinessTransactionDocumentID	nvarchar	35	0	Allow NULL?
159	REF_ITEM_ID	BusinessTransactionDocumentItemID	nvarchar	10	0	Allow NULL?
160	SCHEME_ID	AB: Identifier for the ID Scheme	nvarchar	60	0	Allow NULL?
161	SCHEME_A_ID	AB: ID of the Organization that Maintains the ID Scheme	nvarchar	60	0	Allow NULL?
162	AGENCY_ID_CODE	AB: Agency of Standard ID for Invoice Document	nvarchar	3	0	Allow NULL?
163	REF_NUMBER_2	Additional Reference Document for Agency Document	nvarchar	32	0	Allow NULL?
164	REF_ITEM_NUM_2	Additional Reference Document Item for Agency Document	nvarchar	10	0	Allow NULL?
165	REF_TYPE_2	Additional Reference Document Category	nvarchar	2	0	Allow NULL?

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