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
Materials Management :: Invoice Verification
1	ERP EHP7	6.0	RBDRSEG	124	1	Batch IV: Invoice Document Items	Invoice Verification

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	RBLNR	Document Number of an Invoice Document	nvarchar	10	0	Allow NULL?
3	RJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
4	RBLGP	Document Item in Invoice Document	nvarchar	6	0	Allow NULL?
5	BPMNG	Quantity in Purchase Order Price Unit	decimal	13	3
6	BPREM	Invoice receipt quantity in order price unit	decimal	13	3
7	BPRME	Order Price Unit (Purchasing)	nvarchar	3	0	Allow NULL?
8	BPUMN	Denominator for Conv. of Order Price Unit into Order Unit	decimal	5	0
9	BPUMZ	Numerator for Conversion of Order Price Unit into Order Unit	decimal	5	0
10	BPWEM	Goods Receipt Quantity in Purchase Order Price Unit	decimal	13	3
11	BSMNG	Quantity Ordered Against this Purchase Requisition	decimal	13	3
12	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
13	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
14	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
15	DMBTR	Amount in Local Currency	decimal	13	2
16	EBELN	Purchase Order Number	nvarchar	10	0	Allow NULL?
17	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
18	EINDT	Item Delivery Date	nvarchar	8	0	Allow NULL?
19	EREKZ	Final Invoice Indicator	char	1	0	Allow NULL?
20	FRBNR	Number of Bill of Lading at Time of Goods Receipt	nvarchar	16	0	Allow NULL?
21	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
22	HSWAE	Local currency key	nvarchar	5	0	Allow NULL?
23	LFBNR	Document No. of a Reference Document	nvarchar	10	0	Allow NULL?
24	LFGJA	Fiscal Year of Current Period	nvarchar	4	0	Allow NULL?
25	LFPOS	Item of a Reference Document	nvarchar	4	0	Allow NULL?
26	KNTTP	Account Assignment Category	char	1	0	Allow NULL?
27	KSCHL	Condition Type	nvarchar	4	0	Allow NULL?
28	MATNR	Material Number	nvarchar	18	0	Allow NULL?
29	MEINS	Purchase Order Unit of Measure	nvarchar	3	0	Allow NULL?
30	MENGE	Quantity	decimal	13	3
31	MEPRF	Price Determination (Pricing) Date Control	char	1	0	Allow NULL?
32	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
33	NETPR	Net price	decimal	11	2
34	NETWR	Net order value in document currency	decimal	13	2
35	PSTYP	Item Category in Purchasing Document	char	1	0	Allow NULL?
36	REFWR	Invoice value in foreign currency	decimal	13	2
37	REMNG	Quantity invoiced	decimal	13	3
38	RETPO	Returns Item	char	1	0	Allow NULL?
39	SCHPR	Indicator: Estimated Price	char	1	0	Allow NULL?
40	SELKZ	Selection flag	char	1	0	Allow NULL?
41	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
42	SPGRC	Block.reason: quality	char	1	0	Allow NULL?
43	SPGRG	Blocking reason: order price quantity	char	1	0	Allow NULL?
44	SPGRM	Blocking reason: quantity	char	1	0	Allow NULL?
45	SPGRP	Blocking reason: price	char	1	0	Allow NULL?
46	SPGRQ	Manual Blocking Reason	char	1	0	Allow NULL?
47	SPGRS	Blocking Reason: Item Amount	char	1	0	Allow NULL?
48	SPGRT	Blocking Reason: Date	char	1	0	Allow NULL?
49	SPGRV	Blocking reason: project budget	char	1	0	Allow NULL?
50	STUNR	Step number	nvarchar	3	0	Allow NULL?
51	TBTKZ	Indicator: subsequent debit/credit	char	1	0	Allow NULL?
52	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
53	TXZ01	Short Text	nvarchar	40	0	Allow NULL?
54	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
55	WEBRE	Indicator: GR-Based Invoice Verification	char	1	0	Allow NULL?
56	WEMNG	Quantity of Goods Received	decimal	13	3
57	WEPOS	Goods Receipt Indicator	char	1	0	Allow NULL?
58	WERKS	Plant	nvarchar	4	0	Allow NULL?
59	WRBTR	Amount in document currency	decimal	13	2
60	WMWST	Tax amount in document currency	decimal	13	2
61	XBLNR	Number of External Delivery Note	nvarchar	16	0	Allow NULL?
62	XEKBE	Indicator: update purchase order history	char	1	0	Allow NULL?
63	XEKBZ	Indicator: Update Purchase Order Delivery Costs	char	1	0	Allow NULL?
64	ZAEHK	Condition counter	nvarchar	2	0	Allow NULL?
65	ZEKKN	Sequential Number of Account Assignment	nvarchar	2	0	Allow NULL?
66	LSMNG	Quantity in Unit of Measure from Delivery Note	decimal	13	3
67	LSMEH	Unit of Measure From Delivery Note	nvarchar	3	0	Allow NULL?
68	BASME	Base unit of measure	nvarchar	3	0	Allow NULL?
69	XUBNKR	Indicates: Not relevant for unplanned delivery costs?	char	1	0	Allow NULL?
70	GRICD	Activity Code for Gross Income Tax	nvarchar	2	0	Allow NULL?
71	GRIRG	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
72	GITYP	Distribution Type for Employment Tax	nvarchar	2	0	Allow NULL?
73	MBLNR	Number of Material Document	nvarchar	10	0	Allow NULL?
74	MJAHR	Material Document Year	nvarchar	4	0	Allow NULL?
75	MBLPO	Item in Material Document	nvarchar	4	0	Allow NULL?
76	KNUMVK	Number of the document condition	nvarchar	10	0	Allow NULL?
77	KNUMV	Number of the document condition	nvarchar	10	0	Allow NULL?
78	KNUMVR	Number of the document condition	nvarchar	10	0	Allow NULL?
79	SATNR	Cross-Plant Configurable Material	nvarchar	18	0	Allow NULL?
80	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	Allow NULL?
81	IDNLF	Material Number Used by Vendor	nvarchar	35	0	Allow NULL?
82	AKTNR	Promotion	nvarchar	10	0	Allow NULL?
83	UPVOR	Subitems Exist	char	1	0	Allow NULL?
84	UPTYP	Subitem Category, Purchasing Document	char	1	0	Allow NULL?
85	UEBPO	Higher-Level Item in Purchasing Documents	nvarchar	5	0	Allow NULL?
86	SRVPOS	Service number	nvarchar	18	0	Allow NULL?
87	PACKNO	Package Number of Service	nvarchar	10	0	Allow NULL?
88	INTROW	Line Number of Service	nvarchar	10	0	Allow NULL?
89	LEBRE	Indicator for Service-Based Invoice Verification	char	1	0	Allow NULL?
90	BEKKN	Number of PO Account Assignment	nvarchar	2	0	Allow NULL?
91	PLN_PACKNO	Source package number	nvarchar	10	0	Allow NULL?
92	PLN_INTROW	Entry: Planned package line	nvarchar	10	0	Allow NULL?
93	LIEFFN	Vendor error (exclusive of tax)	decimal	13	2
94	RBWWR	Invoice amount in document currency of vendor invoice	decimal	13	2
95	RBMNG	Qty invoiced in vendor invoice in PO order units	decimal	13	3
96	BPRBM	Qty invoiced in vendor invoice in PO price units	decimal	13	3
97	KZMEK	Correction indicator	char	1	0	Allow NULL?
98	MENGEALT	Quantity	decimal	13	3
99	BPMNGALT	Quantity in Purchase Order Price Unit	decimal	13	3
100	WRBTRALT	Amount in document currency	decimal	13	2
101	XUPDA	Select	char	1	0	Allow NULL?
102	EFKOR	Type of correction to own error	char	1	0	Allow NULL?
103	LFKOR	Type of vendor error	char	1	0	Allow NULL?
104	OK	Indicator: invoice item processed	char	1	0	Allow NULL?
105	COMPLAINT_REASON	Complaints Reason in an Invoice	nvarchar	2	0	Allow NULL?
106	WEUNB	Goods Receipt, Non-Valuated	char	1	0	Allow NULL?
107	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
108	REWWR	Invoice Amount in Foreign Currency	decimal	13	2
109	WEREC	Clearing Indicator for GR/IR Posting for External Services	char	1	0	Allow NULL?
110	KZBWS	Valuation of Special Stock	char	1	0	Allow NULL?
111	XSKRL	Indicator: Line item not liable to cash discount?	char	1	0	Allow NULL?
112	VRTKZ	Distribution indicator for multiple account assignment	char	1	0	Allow NULL?
113	RETTP	Retention Indicator	char	1	0	Allow NULL?
114	RETAMT_FC	Retention Amount in Document Currency	decimal	13	2
115	RETPC	Retention in Percent	decimal	5	2
116	RETDUEDT	Due Date for Retention	nvarchar	8	0	Allow NULL?
117	XRETTAXNET	Tax Reduction for Retention	char	1	0	Allow NULL?
118	XDINV	Indicator for Differential Invoicing	char	1	0	Allow NULL?
119	INV_ITM_ORIGIN	Origin of an Invoice Item	char	1	0	Allow NULL?
120	INVREL	Grouping Characteristic for Invoice Verification	nvarchar	6	0	Allow NULL?
121	DIFF_AMOUNT	Difference Amount (in Document Currency)	decimal	13	2
122	CHARG	Batch Number	nvarchar	10	0	Allow NULL?
123	XCPRF	Checkbox for Commodity Repricing in Invoice Verification	char	1	0	Allow NULL?
124	XHISTMA	Update Multiple Account Assignment EKBE_MA, EKBZ_MA	char	1	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

124 COLUMNS | 1 INDEXES | ERP 6.0 | RBDRSEG TABLE

TOP ERP 6.0 | RBDRSEG COLUMNS

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

124 COLUMNS | 1 INDEXES | ERP 6.0 | RBDRSEG TABLE

TOPERP 6.0 | RBDRSEG COLUMNS

TOPERP 6.0 | RBDRSEG INDEXES

TOP ERP 6.0 | RBDRSEG COLUMNS

TOP ERP 6.0 | RBDRSEG INDEXES