	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

69 columns | ERP 6.0 | SOUR2_FROM

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	FMATGREC30010002	Derivation Rule:Derivation using original CO transaction and	4	SOUR2_FROM	Value Type	nvarchar	2	0
2	K9REC38000057	Derivation rule:commodity risk plan exposure	4	SOUR2_FROM	Fixed/Floating Indicator	nvarchar	1	0
3	K9REC38000059	Derivation rule:commodity mgmt derivation transfered exposu	4	SOUR2_FROM	Fixed/Floating Indicator	nvarchar	1	0
4	K9REC38000060	Derivation rule:commodity mgmt derivation manual exp.	4	SOUR2_FROM	Value of a free attribute (Char4)	nvarchar	4	0
5	K9REC38000061	Derivation rule:Commodities	4	SOUR2_FROM	Valuation Class	nvarchar	4	0
6	K9REC38000062	Derivation rule:Commodities	4	SOUR2_FROM	Valuation Class	nvarchar	4	0
7	K9REC38000074	Derivation rule:SAP Transaction Type < 360T SpotIndicator	4	SOUR2_FROM	Product Type	nvarchar	3	0
TOPAvailability Control
8	K9RKI48050003	Derivation rule:Derivation using original CO transaction and	4	SOUR2_FROM	Value Type	nvarchar	2	0
TOPFunctions for U.S. Federal Government
9	FMFGBLDRVAREAMR	Derivation rule:Set Miscellaneous Receipts - Actuals (MIR)	4	SOUR2_FROM	Value Type	nvarchar	2	0
TOPFunds Management
10	FMDERIVE002	Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/	4	SOUR2_FROM	Cost Center	nvarchar	10	0
11	FMDERIVE004	Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F	4	SOUR2_FROM	Cost Element	nvarchar	10	0
12	FMDERIVE006	Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/	4	SOUR2_FROM	Cost Element	nvarchar	10	0
13	FMDERIVE008	Profit Ctr/CE to Commit Item/Funds Center/Fund/Function	4	SOUR2_FROM	Cost Element	nvarchar	10	0
TOPGeneral Application Functions
14	FMFMOAID38000042	Derivation rule:Cost Center to all	4	SOUR2_FROM	Cost Center	nvarchar	10	0
TOPProfitability Analysis
15	ACEDTF7300086	Derivation rule:Accrual Types, Acc. Principle, Process in A	4	SOUR2_FROM	Accounting Principle	nvarchar	4	0
16	ACEDTF7300087	Derivation rule:Posting Rule to GL Accounts	4	SOUR2_FROM	Characteristics Combination	nvarchar	4	0
17	ACEID38000034	Règle dérivat.:Document Type FR	4	SOUR2_FROM	Type de régularisat.	nvarchar	6	0
18	ACEID38000035	Règle dérivat.:Comptes FR	4	SOUR2_FROM	Type de régularisat.	nvarchar	6	0
19	ACEID38000036	Ableitungsregel:Document type	4	SOUR2_FROM	Abgrenzungsart	nvarchar	6	0
20	ACEID38000040	Ableitungsregel:Accounts for other accrual types (costs)	4	SOUR2_FROM	Abgrenzungsart	nvarchar	6	0
21	ACEID38000041	Ableitungsregel:Document type for accrual type INSURA	4	SOUR2_FROM	Abgrenzungsart	nvarchar	6	0
22	ACEID38000042	Ableitungsregel:Accounts for accrual type INSURA	4	SOUR2_FROM	Abgrenzungsart	nvarchar	6	0
23	ACEID38000056	Derivation rule:OR Accruals IPM HT - Account Determination	4	SOUR2_FROM	Transaction in Accrual Engine	nvarchar	1	0
24	FILADTF7300081	Derivation rule:Derivation of Classification	4	SOUR2_FROM	Classification of Financing Type	nvarchar	2	0
25	FILADTF7300082	Derivation rule:Derivation of Useful Life	4	SOUR2_FROM	Accounting Principle	nvarchar	4	0
26	FOTPDTF7300088	Derivation rule:One Time Postings Acc.Princ. 01	4	SOUR2_FROM	Account Determination Rule	nvarchar	12	0
27	FOTPDTF7300089	Derivation rule:One Time Postings Acc.Princ. 60	4	SOUR2_FROM	Account Determination Rule	nvarchar	12	0
28	K9RALR1000001SAP	Derivation Rule: Strategic Business Unit from Customer Group	4	SOUR2_FROM	Business field	nvarchar	2	0
29	K9RID34000007	Derivation rule:	4	SOUR2_FROM	Record Type	nvarchar	1	0
30	K9RID34000022	Derivation rule:	4	SOUR2_FROM	Record Type	nvarchar	1	0
31	K9RID34000025	Derivation rule:Template determination for sales processes	4	SOUR2_FROM	Division	nvarchar	2	0
32	K9RID34000026	Derivation rule:Template determination for sales processes	4	SOUR2_FROM	Division	nvarchar	2	0
33	K9RID34000028	Derivation rule:AC610 Derive Profit Center 1016	4	SOUR2_FROM	Company Code	nvarchar	4	0
34	K9RID34000029	Derivation rule:	4	SOUR2_FROM	Sales Organization	nvarchar	4	0
35	K9RID35000004	Ableitungsregel:Prod.Kat. + Branche -> SGE	4	SOUR2_FROM	Branchenschlüssel	nvarchar	4	0
36	K9RID35020004	Ableitungsregel:Prod.Kat. + Branche -> SGE	4	SOUR2_FROM	Branchenschlüssel	nvarchar	4	0
37	K9RID35030004	Ableitungsregel:Prod.Kat. + Branche -> SGE	4	SOUR2_FROM	Branchenschlüssel	nvarchar	4	0
38	K9RID35050004	Ableitungsregel:Prod.Kat. + Branche -> SGE	4	SOUR2_FROM	Branchenschlüssel	nvarchar	4	0
39	K9RID35070004	Ableitungsregel:Prod.Kat. + Branche -> SGE	4	SOUR2_FROM	Branchenschlüssel	nvarchar	4	0
40	K9RID35080004	Ableitungsregel:Prod.Kat. + Branche -> SGE	4	SOUR2_FROM	Branchenschlüssel	nvarchar	4	0
41	K9RID35130004	Derivation rule:Prod.Cat. + Industry -> SBU	4	SOUR2_FROM	Industry key	nvarchar	4	0
42	K9RID35160004	Ableitungsregel:Prod.Kat. + Branche -> SGE	4	SOUR2_FROM	Branchenschlüssel	nvarchar	4	0
43	K9RID35290005	Reglas derivac.:Categoría Prod + Ramo -> SBU	4	SOUR2_FROM	Clave de ramo industrial	nvarchar	4	0
44	K9RID38000004	Derivation Rule: Product Category + Industry -> SBU	4	SOUR2_FROM	Industry key	nvarchar	4	0
45	K9RID38000006	Derivation Rule: Assignment to plant	4	SOUR2_FROM	Record Type	nvarchar	1	0
46	K9RID38000012	Derivation Rule: Procedure Determination for Sales Processes	4	SOUR2_FROM	Division	nvarchar	2	0
47	K9RID38000016	Ableitungsregel:T-Ableitungsregel Umwertung Nr 1	4	SOUR2_FROM	Segment	nvarchar	8	0
48	K9RID38000017	Ableitungsregel:T-Ableitungsregel Verteilung Nr 1	4	SOUR2_FROM	Segment	nvarchar	8	0
49	K9RID38000018	Ableitungsregel:T-Ableitungsregel Prognose Nr 1	4	SOUR2_FROM	Segment	nvarchar	8	0
50	K9RID38000021	Derivation Rule: IDES Standard Derivation	4	SOUR2_FROM	Value Field Name	nvarchar	30	0
51	K9RID38000022	Ableitungsregel:Umwertung 3	4	SOUR2_FROM	Sparte	nvarchar	8	0
52	K9RID38000023	Derivation Rule: Access to Cost Estimate for Transfer Prices	4	SOUR2_FROM	Record Type	nvarchar	1	0
53	K9RID38000026	Derivation Rule: Assignment at Material Type / Plant Level	4	SOUR2_FROM	Record Type	nvarchar	1	0
54	K9RID38000028	Derivation Rule: Access to Material Type Level	4	SOUR2_FROM	Record Type	nvarchar	1	0
55	K9RID38000030	Derivation Rule: Access to Cost Estimate for Transfer Prices	4	SOUR2_FROM	Record Type	nvarchar	1	0
56	K9RID38000032	Ableitungsregel:Konto/Buchungskreis/Geschäftsbereich	4	SOUR2_FROM	Buchungskreis	nvarchar	4	0
57	K9RID38000044	Ableitungsregel:Foreign Exchange	4	SOUR2_FROM	Finanzgeschäftsart	nvarchar	3	0
58	K9RID38000053	Ableitungsregel:Prod.Kat. + Branche -> SGE	4	SOUR2_FROM	Branchenschlüssel	nvarchar	4	0
59	K9RIDT8000034	Ableitungsregel:Verkaufsorganisation aus Land und Region	4	SOUR2_FROM	Region (Bundesstaat, Bundesland, Provinz, Grafschaft)	nvarchar	3	0
60	K9RIDT8000050	Ableitungsregel:	4	SOUR2_FROM	Bewertungsklasse	nvarchar	4	0
61	K9RIDT8000052	Ableitungsregel:KontRef BB 002: 1000; P.typ; B.kl.	4	SOUR2_FROM	Bewertungsklasse	nvarchar	4	0
62	K9RIDT8000053	Ableitungsregel:KontRef BB 001: 1000; P.typ; B.kl.	4	SOUR2_FROM	Bewertungsklasse	nvarchar	4	0
63	K9RIDT8000054	Ableitungsregel:KontRef BB 003: Produkttyp; Bew.kl.	4	SOUR2_FROM	Bewertungsklasse	nvarchar	4	0
64	K9RIDT8000055	Ableitungsregel:KontRef BB 001: Produkttyp; Bew.kl.	4	SOUR2_FROM	Bewertungsklasse	nvarchar	4	0
65	K9RIDT8000056	Ableitungsregel:KontRef BB 002: Produkttyp; Bew.kl.	4	SOUR2_FROM	Bewertungsklasse	nvarchar	4	0
66	K9RIDT8000057	Ableitungsregel:KontRef BB 003: Produkttyp; Bew.kl.	4	SOUR2_FROM	Bewertungsklasse	nvarchar	4	0
67	K9RP991000002SAP	Derivation Rule: Strategic Business Unit from Customer Group	4	SOUR2_FROM	Distribution Channel	nvarchar	2	0
TOPRental Accounting
68	ACESLN0000003	Ableitungsregel:Konten	4	SOUR2_FROM	Operatie in Accrual Engine	nvarchar	1	0
69	ACESLN1000002	Derivation Rule: Accounts	4	SOUR2_FROM	Transaction in Accrual Engine	nvarchar	1	0

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

69 columns | ERP 6.0 | SOUR2_FROM