	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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

40 columns | ERP 6.0 | BRTWR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000185000	PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item	31	BRTWR		decimal	15	0
TOPAgency Business Global Trade
2	WBRK	Agency business: Header	35	BRTWR	Agenncy Business: Gross value in document currency	decimal	15	2
3	WBRP	Agency business: Item	28	BRTWR	Gross value of the item in document currency	decimal	15	2
4	WLFD_IVRHDR	Agency Bus.: DB table for Invoice Request Header	10	BRTWR	Agenncy Business: Gross value in document currency	decimal	15	2
5	WLFD_IVRITM	Agency Bus.: DB table for Invoice Request Item	10	BRTWR	Gross value of the item in document currency	decimal	15	2
TOPBasic Functions
6	FDLF	Cash Management Line Items for Agency Business	9	BRTWR	Agenncy Business: Gross value in document currency	decimal	15	2
7	FDLF2	Cash Management Line Items for Agency Business (As of 604)	10	BRTWR	Agenncy Business: Gross value in document currency	decimal	15	2
TOPBilling
8	VBRP	Billing Document: Item Data	152	BRTWR	Gross value of the billing item in document currency	decimal	15	2
TOPContract Accounts Receivable and Payable
9	FKK_JLRK_SHORT	Header Data for IS-M/SD Service Settlement - Extracts	18	BRTWR	IS-M/SD: Gross Value of Billing Document in Doc. Currency	nvarchar	17	0
10	FKK_JLRPCM_SHORT	Item Data for IS-M/SD Commission Settlement - Extracts	13	BRTWR	IS-M/SD: Gross Value of Item in Document Currency	nvarchar	17	0
11	FKK_JLRPHD_SHORT	Item Data for IS-M/SD Home Delivery Settlement - Extracts	9	BRTWR	IS-M/SD: Gross Value of Item in Document Currency	nvarchar	17	0
TOPContract Handling
12	S462	IS-BEV-CH: Sales in BUn	28	BRTWR	Gross value of the billing item in document currency	decimal	15	2
13	S463	IS-BEV-CH: Sales in Stat. UoM	28	BRTWR	Gross value of the billing item in document currency	decimal	15	2
TOPData Collection
14	S270	Do not use!	26	BRTWR	Gross order value in order currency	decimal	13	2
15	S270BIW1	Do not use!	26	BRTWR	Gross order value in order currency	decimal	13	2
16	S270BIW2	Do not use!	26	BRTWR	Gross order value in order currency	decimal	13	2
17	S272	Do not use!	35	BRTWR	Gross value of the billing item in document currency	decimal	15	2
18	S272BIW1	Do not use!	35	BRTWR	Gross value of the billing item in document currency	decimal	15	2
19	S272BIW2	Do not use!	35	BRTWR	Gross value of the billing item in document currency	decimal	15	2
20	S275	Transfer BW: Einkaufsdaten	21	BRTWR	Bruto bestelwaarde in bestelvaluta	decimal	13	2
21	S275BIW1	S275BIW1 * Transfer to BW: Purchasing Data	21	BRTWR	Gross order value in order currency	decimal	13	2
22	S275BIW2	S275BIW2 * Transfer to BW: Purchasing Data	21	BRTWR	Gross order value in order currency	decimal	13	2
TOPDownstream
23	S414BIW1	S414BIW1 * SSR DTF statistics	22	BRTWR	SSR PC: Gross value	decimal	13	2
24	S414BIW2	S414BIW2 * SSR DTF statistics	22	BRTWR	SSR PC: Gross value	decimal	13	2
TOPExternal Services
25	ESLL	Lines of Service Package	22	BRTWR	Gross Price	decimal	11	2
26	ESVC	Vendor confirmation for service lines	16	BRTWR	Gross Price	decimal	11	2
TOPPeriodical Sales and Distribution
27	JLRK	IS-M/SD: Settlement Header Data	21	BRTWR	IS-M: Gross Value in Document Currency	decimal	15	2
28	JLRP	IS-M/SD: Item Data for Settlement	12	BRTWR	IS-M: Gross Value in Document Currency	decimal	15	2
29	JLSK	IS-M/SD: Header for Settlement in Collective Processing	17	BRTWR	IS-M: Gross Value in Document Currency	decimal	15	2
30	JLSS	IS-M/SD: Settlements in Collective Processing	5	BRTWR	IS-M: Gross Value in Document Currency	decimal	15	2
TOPPurchasing
31	EKPO	Purchasing Document Item	28	BRTWR	Gross order value in PO currency	decimal	13	2
32	WDFR_POS	Perishables Planninng Item	49	BRTWR	Gross order value in PO currency	decimal	13	2
TOPPurchasing Information System
33	MCEKS	R/2 PURCHIS Data (Status: Last Data Transmission)	20	BRTWR	Gross order value in base unit of measure	decimal	15	2
TOPService Station Retailing
34	OIRADBT	Document base table	29	BRTWR	SSR PC: Gross value	decimal	13	2
35	OIREUPLKXXXX	SSR PC: Template for generated DTF tables (header)	23	BRTWR	SSR PC: Gross value	decimal	13	2
36	OIREUPLPXXXX	SSR PC: DTF table for item information	10	BRTWR	SSR PC: Gross value	decimal	13	2
37	OIRE_RECON_ADM	Administration data for the reconciliation files	6	BRTWR	SSR PC: Total Value (of Upload)	decimal	13	2
38	OIRE_RECON_AGG	Aggregated reconciliation data	8	BRTWR	SSR PC: Gross value	decimal	13	2
39	OIRE_RECON_DET	Detailed reconciliation data	9	BRTWR	SSR PC: Gross value	decimal	13	2
40	S414	SSR DTF statistics	22	BRTWR	SSR PC: Gross value	decimal	13	2

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

40 columns | ERP 6.0 | BRTWR