	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

152 columns | ERP 6.0 | TARGET1

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/OEE/MPH_KPITARG	Plant Hierarchy KPI Target Details	8	TARGET1	OEE KPI Target	decimal	31	14
2	FMATGREC30010001	Derivation Rule:Derive activity group from value type only	5	TARGET1	Activity Group for AVC	nvarchar	2	0
3	FMATGREC30010002	Derivation Rule:Derivation using original CO transaction and	7	TARGET1	Activity Group for AVC	nvarchar	2	0
4	K9REC38000057	Derivation rule:commodity risk plan exposure	7	TARGET1	Exposure Position Type	nvarchar	5	0
5	K9REC38000058	Derivation rule:Valuation Rule	5	TARGET1	Valuation Rule	nvarchar	8	0
6	K9REC38000059	Derivation rule:commodity mgmt derivation transfered exposu	7	TARGET1	Exposure Position Type	nvarchar	5	0
7	K9REC38000060	Derivation rule:commodity mgmt derivation manual exp.	7	TARGET1	Exposure Position Type	nvarchar	5	0
8	K9REC38000061	Derivation rule:Commodities	7	TARGET1	Account Assignment Reference of Position Management	nvarchar	12	0
9	K9REC38000062	Derivation rule:Commodities	7	TARGET1	Account Assignment Reference of Position Management	nvarchar	12	0
10	K9REC38000065	Derivation rule:CM: Valuation Rule	5	TARGET1	Valuation Rule	nvarchar	8	0
11	K9REC38000066	Derivation rule:CM: Valuation Rule Exposures	5	TARGET1	Valuation Rule	nvarchar	8	0
12	K9REC38000073	Derivation rule:Master: Requester ID --> Partner	5	TARGET1	Business Partner Number	nvarchar	10	0
13	K9REC38000074	Derivation rule:SAP Transaction Type < 360T SpotIndicator	7	TARGET1	Financial Transaction Type	nvarchar	3	0
14	K9REC38000075	Derivation rule:	5	TARGET1	Trader	nvarchar	12	0
TOPAvailability Control
15	K9RKI48050002	Derivation rule:Derive act. group from value type only	5	TARGET1	Activity Group for AVC	nvarchar	2	0
16	K9RKI48050003	Derivation rule:Derivation using original CO transaction and	7	TARGET1	Activity Group for AVC	nvarchar	2	0
TOPFunctions for U.S. Federal Government
17	FMFGBLDRVAREAEAA	Derivation rule:Set Expended Appropriations - Actuals (EAA)	5	TARGET1	EAA (Expended Approp - Actual)	nvarchar	1	0
18	FMFGBLDRVAREAMR	Derivation rule:Set Miscellaneous Receipts - Actuals (MIR)	7	TARGET1	MIR (Miscellaneous Receipts - Actuals)	nvarchar	1	0
TOPFunds Management
19	FMDERIVE002	Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/	9	TARGET1	Commitment Item	nvarchar	24	0
20	FMDERIVE004	Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F	7	TARGET1	Commitment Item	nvarchar	24	0
21	FMDERIVE005	Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func	5	TARGET1	Commitment Item	nvarchar	24	0
22	FMDERIVE006	Derivation rule:WBS Element/CE to Commitment Item/Funds Ctr/	7	TARGET1	Commitment Item	nvarchar	24	0
23	FMDERIVE008	Profit Ctr/CE to Commit Item/Funds Center/Fund/Function	7	TARGET1	Commitment Item	nvarchar	24	0
24	FMDERIVE009	Derivation rule:Profit Center to Commitment Item/Funds Ctr/F	5	TARGET1	Commitment Item	nvarchar	24	0
25	FMDT_CHANGEDOC	Empty table for change document on DRULE derivation tables	4	TARGET1	Target value from Derivation table	nvarchar	60	0
TOPGeneral Application Functions
26	FMFMOAID38000003	Derivation rule:	5	TARGET1	Fund	nvarchar	10	0
27	FMFMOAID38000004	Derivation rule:	5	TARGET1	Funds Center	nvarchar	16	0
28	FMFMOAID38000016	Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func	5	TARGET1	Commitment Item	nvarchar	24	0
29	FMFMOAID38000042	Derivation rule:Cost Center to all	7	TARGET1	Financial Management Area	nvarchar	4	0
30	KX9RABA0000108	Ableitungsregel:df	6	TARGET1	Flag	nvarchar	1	0
TOPProfitability Analysis
31	ACEDTF7300085	Derivation rule:Determine Document type	5	TARGET1	Document Type	nvarchar	2	0
32	ACEDTF7300086	Derivation rule:Accrual Types, Acc. Principle, Process in A	9	TARGET1	Characteristics Combination	nvarchar	4	0
33	ACEDTF7300087	Derivation rule:Posting Rule to GL Accounts	7	TARGET1	Target account	nvarchar	10	0
34	ACEID38000034	Règle dérivat.:Document Type FR	7	TARGET1	Type de pièce	nvarchar	2	0
35	ACEID38000035	Règle dérivat.:Comptes FR	7	TARGET1	Compte source	nvarchar	10	0
36	ACEID38000036	Ableitungsregel:Document type	7	TARGET1	Belegart	nvarchar	2	0
37	ACEID38000040	Ableitungsregel:Accounts for other accrual types (costs)	11	TARGET1	Zielkonto	nvarchar	10	0
38	ACEID38000041	Ableitungsregel:Document type for accrual type INSURA	7	TARGET1	Belegart	nvarchar	2	0
39	ACEID38000042	Ableitungsregel:Accounts for accrual type INSURA	7	TARGET1	Zielkonto	nvarchar	10	0
40	ACEID38000055	Derivation rule:OR Accruals IPM HT - Document Type	5	TARGET1	Document Type	nvarchar	2	0
41	ACEID38000056	Derivation rule:OR Accruals IPM HT - Account Determination	7	TARGET1	Start Account	nvarchar	10	0
42	FILADTF7300081	Derivation rule:Derivation of Classification	11	TARGET1	Checking Rule in Financing Classification	nvarchar	7	0
43	FILADTF7300082	Derivation rule:Derivation of Useful Life	9	TARGET1	Original useful life in periods	nvarchar	3	0
44	FILADTF7300091	Ableitungsregel:Valueid's bestimmen	5	TARGET1	Prüfregel in der Klassifikation Finanzierung	nvarchar	7	0
45	FOTPDTF7300088	Derivation rule:One Time Postings Acc.Princ. 01	9	TARGET1	G/L Account	nvarchar	10	0
46	FOTPDTF7300089	Derivation rule:One Time Postings Acc.Princ. 60	9	TARGET1	G/L Account	nvarchar	10	0
47	K9RALR0000472SAP	Derivation Rule: Destination from Flight Segment	5	TARGET1	Destination	nvarchar	5	0
48	K9RALR0000473SAP	Derivation Rule: Departure Location from Flight Segment	5	TARGET1	Departure Location	nvarchar	5	0
49	K9RALR0000474SAP	Derivation Rule: Rotation from Flight Number	5	TARGET1	Rotation	nvarchar	5	0
50	K9RALR0000475SAP	Derivation Rule: Region from Destination	5	TARGET1	Zone	nvarchar	5	0
51	K9RALR0000476SAP	Derivation Rule: Flight Type from Flight Number	5	TARGET1	Flight Type	nvarchar	4	0
52	K9RALR1000001SAP	Derivation Rule: Strategic Business Unit from Customer Group	7	TARGET1	Strategic Business Unit	nvarchar	2	0
53	K9RID34000007	Derivation rule:	13	TARGET1	First costing key (CO-PA)	nvarchar	3	0
54	K9RID34000008	Derivation rule:Derivation: State from Dstrct.	5	TARGET1	Area	nvarchar	4	0
55	K9RID34000020	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
56	K9RID34000022	Derivation rule:	11	TARGET1	First costing key (CO-PA)	nvarchar	3	0
57	K9RID34000025	Derivation rule:Template determination for sales processes	7	TARGET1	Template	nvarchar	10	0
58	K9RID34000026	Derivation rule:Template determination for sales processes	7	TARGET1	Template	nvarchar	10	0
59	K9RID34000027	Derivation rule:ac420 template determination	5	TARGET1	Template	nvarchar	10	0
60	K9RID34000028	Derivation rule:AC610 Derive Profit Center 1016	9	TARGET1	Profit Center	nvarchar	10	0
61	K9RID34000029	Derivation rule:	9	TARGET1	Revaluation Key	nvarchar	3	0
62	K9RID35000001	Ableitungsregel:Empfangsland --> Intern.Region	5	TARGET1	Empfängerregion	nvarchar	3	0
63	K9RID35000002	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
64	K9RID35000003	Ableitungsregel:Debitor --> Intercompany Kennz	5	TARGET1	Intercompany Kennzeichen	nvarchar	1	0
65	K9RID35000004	Ableitungsregel:Prod.Kat. + Branche -> SGE	7	TARGET1	Strategische Geschäftseinheit	nvarchar	8	0
66	K9RID35020001	Ableitungsregel:Empfangsland --> Intern.Region	5	TARGET1	Empfängerregion	nvarchar	3	0
67	K9RID35020002	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
68	K9RID35020003	Ableitungsregel:Debitor --> Intercompany Kennz	5	TARGET1	Intercompany Kennzeichen	nvarchar	1	0
69	K9RID35020004	Ableitungsregel:Prod.Kat. + Branche -> SGE	7	TARGET1	Strategische Geschäftseinheit	nvarchar	8	0
70	K9RID35030001	Ableitungsregel:Empfangsland --> Intern.Region	5	TARGET1	Empfängerregion	nvarchar	3	0
71	K9RID35030002	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
72	K9RID35030003	Ableitungsregel:Debitor --> Intercompany Kennz	5	TARGET1	Intercompany Kennzeichen	nvarchar	1	0
73	K9RID35030004	Ableitungsregel:Prod.Kat. + Branche -> SGE	7	TARGET1	Strategische Geschäftseinheit	nvarchar	8	0
74	K9RID35030005	Ableitungsregel:Ableitung Gebiet von Bezirk	5	TARGET1	Gebiet	nvarchar	4	0
75	K9RID35050001	Ableitungsregel:Empfangsland --> Intern.Region	5	TARGET1	Empfängerregion	nvarchar	3	0
76	K9RID35050002	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
77	K9RID35050003	Ableitungsregel:Debitor --> Intercompany Kennz	5	TARGET1	Intercompany Kennzeichen	nvarchar	1	0
78	K9RID35050004	Ableitungsregel:Prod.Kat. + Branche -> SGE	7	TARGET1	Strategische Geschäftseinheit	nvarchar	8	0
79	K9RID35070001	Ableitungsregel:Empfangsland --> Intern.Region	5	TARGET1	Empfängerregion	nvarchar	3	0
80	K9RID35070002	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
81	K9RID35070003	Ableitungsregel:Debitor --> Intercompany Kennz	5	TARGET1	Intercompany Kennzeichen	nvarchar	1	0
82	K9RID35070004	Ableitungsregel:Prod.Kat. + Branche -> SGE	7	TARGET1	Strategische Geschäftseinheit	nvarchar	8	0
83	K9RID35080001	Ableitungsregel:Empfangsland --> Intern.Region	5	TARGET1	Empfängerregion	nvarchar	3	0
84	K9RID35080002	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
85	K9RID35080003	Ableitungsregel:Debitor --> Intercompany Kennz	5	TARGET1	Intercompany Kennzeichen	nvarchar	1	0
86	K9RID35080004	Ableitungsregel:Prod.Kat. + Branche -> SGE	7	TARGET1	Strategische Geschäftseinheit	nvarchar	8	0
87	K9RID35120001	Derivation rule:Derivation: State from Dstrct.	5	TARGET1	Area	nvarchar	4	0
88	K9RID35130001	Derivation rule:Country Ship-to --> Intern.Reg	5	TARGET1	Intern.Region Ship-t	nvarchar	3	0
89	K9RID35130002	Derivation rule:Prd.Hierarchy -> Prd. Category	5	TARGET1	Product category	nvarchar	8	0
90	K9RID35130003	Derivation rule:Customer --> Intercompany ind.	5	TARGET1	Intercompany ind.	nvarchar	1	0
91	K9RID35130004	Derivation rule:Prod.Cat. + Industry -> SBU	7	TARGET1	Strategic Bus.Unit	nvarchar	8	0
92	K9RID35160001	Ableitungsregel:Empfangsland --> Intern.Region	5	TARGET1	Empfängerregion	nvarchar	3	0
93	K9RID35160002	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
94	K9RID35160003	Ableitungsregel:Debitor --> Intercompany Kennz	5	TARGET1	Intercompany Kennzeichen	nvarchar	1	0
95	K9RID35160004	Ableitungsregel:Prod.Kat. + Branche -> SGE	7	TARGET1	Strategische Geschäftseinheit	nvarchar	8	0
96	K9RID35250001	Derivation rule:Derivation: State from Dstrct.	5	TARGET1	Area	nvarchar	4	0
97	K9RID35290001	Derivation rule:Derivation: State from Dstrct.	5	TARGET1	Area	nvarchar	4	0
98	K9RID35290002	Reglas derivac.:País destino --> Reg.intern.	5	TARGET1	Región receptora	nvarchar	3	0
99	K9RID35290003	Reglas derivac.:Jerarquía prod.-> Categ.prod.	5	TARGET1	Categoría de productos	nvarchar	8	0
100	K9RID35290004	Reglas derivac.:Deudor --> Ind.multisociedades	5	TARGET1	Indicador multisociedades	nvarchar	1	0
101	K9RID35290005	Reglas derivac.:Categoría Prod + Ramo -> SBU	7	TARGET1	Unidad estratégica de negocio	nvarchar	8	0
102	K9RID35370001	Regra derivação:Derivação de área de distrito	5	TARGET1	Área	nvarchar	4	0
103	K9RID38000001	Derivation Rule: Ship-to country --> Intern.region	5	TARGET1	Intern.Region Ship-t	nvarchar	3	0
104	K9RID38000002	Derivation Rule: Product Hierarchy -> Product Category	5	TARGET1	Product category	nvarchar	8	0
105	K9RID38000003	Derivation Rule: Customer -> Intercompany Flag	5	TARGET1	Intercompany ind.	nvarchar	1	0
106	K9RID38000004	Derivation Rule: Product Category + Industry -> SBU	7	TARGET1	Strategic Bus.Unit	nvarchar	8	0
107	K9RID38000006	Derivation Rule: Assignment to plant	13	TARGET1	First costing key (CO-PA)	nvarchar	3	0
108	K9RID38000012	Derivation Rule: Procedure Determination for Sales Processes	7	TARGET1	Template	nvarchar	10	0
109	K9RID38000016	Ableitungsregel:T-Ableitungsregel Umwertung Nr 1	13	TARGET1	Umwertungsreihe	nvarchar	3	0
110	K9RID38000017	Ableitungsregel:T-Ableitungsregel Verteilung Nr 1	13	TARGET1	Verteilungsschlüssel	nvarchar	4	0
111	K9RID38000018	Ableitungsregel:T-Ableitungsregel Prognose Nr 1	13	TARGET1	Profil für Prognose mit Funktionsbaustein PROGNOSE_DIALOG	nvarchar	4	0
112	K9RID38000019	Ableitungsregel:IDES- Matnummer -> Rep. Materialnummer	5	TARGET1	Repräsentatives Material für die Profit-Center-Rechnung	nvarchar	18	0
113	K9RID38000020	Derivation Rule: Product Hierarchy -> Product Category	5	TARGET1	Product category	nvarchar	8	0
114	K9RID38000021	Derivation Rule: IDES Standard Derivation	7	TARGET1	Account Number	nvarchar	10	0
115	K9RID38000022	Ableitungsregel:Umwertung 3	7	TARGET1	Umwertungsreihe	nvarchar	3	0
116	K9RID38000023	Derivation Rule: Access to Cost Estimate for Transfer Prices	11	TARGET1	First costing key (CO-PA)	nvarchar	3	0
117	K9RID38000024	Ableitungsregel:Ableitung Gebiet von Bezirk	5	TARGET1	Gebiet	nvarchar	4	0
118	K9RID38000025	Derivation Rule: Unit of Measure from Material Group	5	TARGET1	Base Unit of Measure	nvarchar	3	0
119	K9RID38000026	Derivation Rule: Assignment at Material Type / Plant Level	13	TARGET1	First costing key (CO-PA)	nvarchar	3	0
120	K9RID38000028	Derivation Rule: Access to Material Type Level	11	TARGET1	First costing key (CO-PA)	nvarchar	3	0
121	K9RID38000030	Derivation Rule: Access to Cost Estimate for Transfer Prices	11	TARGET1	First costing key (CO-PA)	nvarchar	3	0
122	K9RID38000031	Ableitungsregel:PartnerPrCtr aus Kundennummer	5	TARGET1	Partnerprofitcenter	nvarchar	10	0
123	K9RID38000032	Ableitungsregel:Konto/Buchungskreis/Geschäftsbereich	9	TARGET1	Profitcenter	nvarchar	10	0
124	K9RID38000033	Derivation rule:AC420 TEMPLATE DETERMINATION	5	TARGET1	Template	nvarchar	10	0
125	K9RID38000043	Ableitungsregel:	5	TARGET1	Ausfallrisikoregel	nvarchar	10	0
126	K9RID38000044	Ableitungsregel:Foreign Exchange	7	TARGET1	Ausfallrisikoregel	nvarchar	10	0
127	K9RID38000045	Ableitungsregel:Loans	5	TARGET1	Ausfallrisikoregel	nvarchar	10	0
128	K9RID38000046	Ableitungsregel:Money Market	5	TARGET1	Ausfallrisikoregel	nvarchar	10	0
129	K9RID38000047	Ableitungsregel:Depot-Gattungsbestand	5	TARGET1	Ausfallrisikoregel	nvarchar	10	0
130	K9RID38000048	Ableitungsregel:Risikoträger	5	TARGET1	Ausfallrisikoregel	nvarchar	10	0
131	K9RID38000049	Ableitungsregel:INT/EXT Kennzeichen	5	TARGET1	INT/EXT Kennzeichen	nvarchar	3	0
132	K9RID38000050	Ableitungsregel:Debitor --> Intercompany Kennz	5	TARGET1	Intercompany Kennzeichen	nvarchar	1	0
133	K9RID38000051	Ableitungsregel:Empfangsland --> Intern.Region	5	TARGET1	Empfängerregion	nvarchar	3	0
134	K9RID38000052	Ableitungsregel:PrdHierarchie -> PrdKategorie	5	TARGET1	Produktkategorie	nvarchar	8	0
135	K9RID38000053	Ableitungsregel:Prod.Kat. + Branche -> SGE	7	TARGET1	Strategische Geschäftseinheit	nvarchar	8	0
136	K9RID38000054	Ableitungsregel:Mengeneinheit aus Warengruppe	5	TARGET1	Basismengeneinheit	nvarchar	3	0
137	K9RIDT8000032	Ableitungsregel:Warenhauptgruppe aus Warengruppe	5	TARGET1	Warenhauptgruppe	nvarchar	2	0
138	K9RIDT8000033	Ableitungsregel:Verkaufsorganisation aus Land	5	TARGET1	Verkaufsorganisation	nvarchar	4	0
139	K9RIDT8000034	Ableitungsregel:Verkaufsorganisation aus Land und Region	7	TARGET1	Verkaufsorganisation	nvarchar	4	0
140	K9RIDT8000050	Ableitungsregel:	7	TARGET1	Kontierungsreferenz der Bestandsführung	nvarchar	12	0
141	K9RIDT8000052	Ableitungsregel:KontRef BB 002: 1000; P.typ; B.kl.	7	TARGET1	Kontierungsreferenz der Bestandsführung	nvarchar	12	0
142	K9RIDT8000053	Ableitungsregel:KontRef BB 001: 1000; P.typ; B.kl.	7	TARGET1	Kontierungsreferenz der Bestandsführung	nvarchar	12	0
143	K9RIDT8000054	Ableitungsregel:KontRef BB 003: Produkttyp; Bew.kl.	7	TARGET1	Kontierungsreferenz der Bestandsführung	nvarchar	12	0
144	K9RIDT8000055	Ableitungsregel:KontRef BB 001: Produkttyp; Bew.kl.	7	TARGET1	Kontierungsreferenz der Bestandsführung	nvarchar	12	0
145	K9RIDT8000056	Ableitungsregel:KontRef BB 002: Produkttyp; Bew.kl.	7	TARGET1	Kontierungsreferenz der Bestandsführung	nvarchar	12	0
146	K9RIDT8000057	Ableitungsregel:KontRef BB 003: Produkttyp; Bew.kl.	7	TARGET1	Kontierungsreferenz der Bestandsführung	nvarchar	12	0
147	K9RP000000019SAP	Derivation Rule: Main Product Group from Material Group	5	TARGET1	Main Material Group	nvarchar	2	0
148	K9RP991000002SAP	Derivation Rule: Strategic Business Unit from Customer Group	7	TARGET1	Sales Group	nvarchar	3	0
TOPRental Accounting
149	ACESLN0000002	Ableitungsregel:Belegart	5	TARGET1	Doc.soort	nvarchar	2	0
150	ACESLN0000003	Ableitungsregel:Konten	9	TARGET1	Startrekening	nvarchar	10	0
151	ACESLN1000001	Derivation Rule: Document Type	5	TARGET1	Document Type	nvarchar	2	0
152	ACESLN1000002	Derivation Rule: Accounts	9	TARGET1	Start Account	nvarchar	10	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

152 columns | ERP 6.0 | TARGET1