	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

156 columns | ERP 6.0 | FM_AREA

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/OPT/AT_APPR_HIS	Approval History for Level Based Approvals	74	FM_AREA	Financial Management Area	nvarchar	4	0
2	/OPT/AT_LBA_LOG	Approval History for Level Based Approvals	75	FM_AREA	Financial Management Area	nvarchar	4	0
3	BBP_PCACC	Procurement Card: Accounting Data	7	FM_AREA	Financial Management Area	nvarchar	4	0
4	BBP_PCMAS	Procurement Card Master Data	24	FM_AREA	Financial Management Area	nvarchar	4	0
5	BBP_PCMOD	Procurement Card: Modified Statement Data	9	FM_AREA	Financial Management Area	nvarchar	4	0
6	CNFM_FMBL	Extension table for table FMBL (localization PSM China)	2	FM_AREA	Financial Management Area	nvarchar	4	0
7	CNFM_FMHBL	Extension table for table FMHBL (localization PSM China)	2	FM_AREA	Financial Management Area	nvarchar	4	0
8	FMBCS_FMBL_CD	Empty table for change documents on FMBL incl. local. fields	2	FM_AREA	Financial Management Area	nvarchar	4	0
9	FMPEP_ADM_SV	Session Variants administration	2	FM_AREA	Financial Management Area	nvarchar	4	0
10	FMPEP_VARIANTHT	Session Variant Text	3	FM_AREA	Financial Management Area	nvarchar	4	0
TOPActual Update and Commitment Update
11	GMREVBDGTFM1	Defult settings for GM revaluation of currency	3	FM_AREA	Financial Management Area	nvarchar	4	0
TOPAvailability Control
12	FMAVCACTCD	Activation of Change Documents for FMAVCT Records	2	FM_AREA	Financial Management Area	nvarchar	4	0
13	FMAVCBUDFILTB	AVC filter settings for FM budget values: valid budget types	2	FM_AREA	Financial Management Area	nvarchar	4	0
14	FMAVCBUDFILTH	AVC filter settings for FM budget values: header entries	2	FM_AREA	Financial Management Area	nvarchar	4	0
15	FMAVCLDGRACT	Activation of availability ledger for Funds Management	2	FM_AREA	Financial Management Area	nvarchar	4	0
16	FMAVCLDGRATT	Attributes of Availability Control Ledger (Funds Management)	2	FM_AREA	Financial Management Area	nvarchar	4	0
17	FMAVCLDGRGAT	Year-Independent Attributes of Control Ledger (FM)	2	FM_AREA	Financial Management Area	nvarchar	4	0
18	FMAVCUPDFILTH	AVC Filter Settings for FM Posting Data: Header Entries	2	FM_AREA	Financial Management Area	nvarchar	4	0
19	FMAVCUPDFILTV	AVC Filter Settings for Posting Data: Excluded Value Types	2	FM_AREA	Financial Management Area	nvarchar	4	0
20	FMAVC_RBE_SET	AVC Ledger Settings for RBE	2	FM_AREA	Financial Management Area	nvarchar	4	0
TOPBudget Control System
21	FMBASIDX	Index table for budget structure and AVC	2	FM_AREA	Financial Management Area	nvarchar	4	0
TOPBudgeting
22	FMACTIVPER	Activate Period Control Budgeting	2	FM_AREA	Financial Management Area	nvarchar	4	0
23	FMBCSA	Budget Control System activation settings	2	FM_AREA	Financial Management Area	nvarchar	4	0
24	FMBCSA_USER	User specific Budget Control System activation settings	2	FM_AREA	Financial Management Area	nvarchar	4	0
25	FMBH	Funds management budget header (entry documents)	2	FM_AREA	Financial Management Area	nvarchar	4	0
26	FMBL	Funds management budget document lines (entry documents)	2	FM_AREA	Financial Management Area	nvarchar	4	0
27	FMBSCDACT	Activation of Change Documents for Budget Structure	2	FM_AREA	Financial Management Area	nvarchar	4	0
28	FMBS_BO	Budget Addresses	2	FM_AREA	Financial Management Area	nvarchar	4	0
29	FMBS_BS	Budget structures	2	FM_AREA	Financial Management Area	nvarchar	4	0
30	FMBS_BS_T	Texts for Budget Structures	2	FM_AREA	Financial Management Area	nvarchar	4	0
31	FMBS_CONTROL	Budget structure settings on FM area and fiscal year level	2	FM_AREA	Financial Management Area	nvarchar	4	0
32	FMBS_CONTROL_LDR	BS settings FM area, fisc. year and posting ledger	2	FM_AREA	Financial Management Area	nvarchar	4	0
33	FMBS_HIE_ACT	Activation of Hierarchical Budget Structure	2	FM_AREA	Financial Management Area	nvarchar	4	0
34	FMBS_VERS_ASS	Budget Addresses settings on the version level	2	FM_AREA	Financial Management Area	nvarchar	4	0
35	FMBTGDEF	Budget Group content definition	2	FM_AREA	Financial Management Area	nvarchar	4	0
36	FMBTGROUP	Budget Type Group definition	2	FM_AREA	Financial Management Area	nvarchar	4	0
37	FMBTGROUPT	Text for Budget Type Group	2	FM_AREA	Financial Management Area	nvarchar	4	0
38	FMBUDCAT	Budget category activation	2	FM_AREA	Financial Management Area	nvarchar	4	0
39	FMBUDTXT	Budget texts register	3	FM_AREA	Financial Management Area	nvarchar	4	0
40	FMBUDTXT_KEY	Budget Text Key Customizing	3	FM_AREA	Financial Management Area	nvarchar	4	0
41	FMBUDTYPE	Budget type definition	2	FM_AREA	Financial Management Area	nvarchar	4	0
42	FMBUDTYPET	Texts for Budget Types	2	FM_AREA	Financial Management Area	nvarchar	4	0
43	FMBUMANAGER	Management of budgeting enironment in FM	2	FM_AREA	Financial Management Area	nvarchar	4	0
44	FMBUSTATUS	Status and budget addresses settings on the version level	2	FM_AREA	Financial Management Area	nvarchar	4	0
45	FMBWUD	User Documents	3	FM_AREA	Financial Management Area	nvarchar	4	0
46	FMCCFBDGT_CNTRL	Customizing settings: creation of budget during ccf	2	FM_AREA	Financial Management Area	nvarchar	4	0
47	FMCCFBDGT_CUST	Customizing settings: creation of budget during ccf	2	FM_AREA	Financial Management Area	nvarchar	4	0
48	FMCC_CUST_LIB	FM - Consistency checks - Assignment of libraries	2	FM_AREA	Financial Management Area	nvarchar	4	0
49	FMCEACT	Activation of Cover Elibility	2	FM_AREA	Financial Management Area	nvarchar	4	0
50	FMCECDACT	Activation of Change Documents for Cover Elibility	2	FM_AREA	Financial Management Area	nvarchar	4	0
51	FMCECGADDRS	Cover Groups: Assigned Budget Addresses	2	FM_AREA	Financial Management Area	nvarchar	4	0
52	FMCECVGRP	Cover Groups	2	FM_AREA	Financial Management Area	nvarchar	4	0
53	FMCECVGRPT	Texts for Cover Groups	2	FM_AREA	Financial Management Area	nvarchar	4	0
54	FMCONSUM_FTYPE	Consumable budget type for Fund Type	2	FM_AREA	Financial Management Area	nvarchar	4	0
55	FMCONSUM_FUND	Consumable budget type for Fund	2	FM_AREA	Financial Management Area	nvarchar	4	0
56	FMCUPRPCDACT	Activation of Change History for Preposted Documents	2	FM_AREA	Financial Management Area	nvarchar	4	0
57	FMCUPRPCOM	Assignment of Field Profiles for Preposted Budget Documents	2	FM_AREA	Financial Management Area	nvarchar	4	0
58	FMDIMSTATE	Definition of state for account assignment element	2	FM_AREA	Financial Management Area	nvarchar	4	0
59	FMDISTA	Distribution Activation	2	FM_AREA	Financial Management Area	nvarchar	4	0
60	FMDISTC	Distribution Checks	2	FM_AREA	Financial Management Area	nvarchar	4	0
61	FMDISTCK	Distribution Checks	2	FM_AREA	Financial Management Area	nvarchar	4	0
62	FMEDFORMS_WD	Assignment of Forms for Entry document	2	FM_AREA	Financial Management Area	nvarchar	4	0
63	FMFSVA	Assignment of Field Status Variant	2	FM_AREA	Financial Management Area	nvarchar	4	0
64	FMHBH	Funds management budget header (held documents)	2	FM_AREA	Financial Management Area	nvarchar	4	0
65	FMHBL	Funds management budget document lines (held documents)	2	FM_AREA	Financial Management Area	nvarchar	4	0
66	FMHIEHEADERS	Hierarchy Nodes: Constant Parts ("Headers")	2	FM_AREA	Financial Management Area	nvarchar	4	0
67	FMHIEIDS	Hierarchy IDs	2	FM_AREA	Financial Management Area	nvarchar	4	0
68	FMHIEIDST	Texts for Hierarchy IDs	2	FM_AREA	Financial Management Area	nvarchar	4	0
69	FMHIENODES	Hierarchy Nodes (Without Constant Part)	2	FM_AREA	Financial Management Area	nvarchar	4	0
70	FMHIESETTINGS	Settings for Budget Hierarchies	2	FM_AREA	Financial Management Area	nvarchar	4	0
71	FMHIE_CHGCHK_FLG	Activate Checks for Hierarchy Change	2	FM_AREA	Financial Management Area	nvarchar	4	0
72	FMMAACT	Activation of Multi-annual Budgeting	2	FM_AREA	Financial Management Area	nvarchar	4	0
73	FMMACGPERC	Percentage per cover group (Multi-annual budgeting)	2	FM_AREA	Financial Management Area	nvarchar	4	0
74	FMMAPERC	Standard percentage set for multi-annual budgeting	2	FM_AREA	Financial Management Area	nvarchar	4	0
75	FMMIGDOC	Migrated Documents	6	FM_AREA	Financial Management Area	nvarchar	4	0
76	FMMIGOV	Overview of Migration Status	2	FM_AREA	Financial Management Area	nvarchar	4	0
77	FMMIGPAR	Partially Migrated Documents	6	FM_AREA	Financial Management Area	nvarchar	4	0
78	FMOPENPER	Control Budgeting Periods	2	FM_AREA	Financial Management Area	nvarchar	4	0
79	FMOPENPER_FUND	Control Budgeting Periods per Fund	2	FM_AREA	Financial Management Area	nvarchar	4	0
80	FMORGFAV	BCS : Organizer Favorites	4	FM_AREA	Financial Management Area	nvarchar	4	0
81	FMPEP_VARIANTH	Session variants (header part) for transaction FMPEP	2	FM_AREA	Financial Management Area	nvarchar	4	0
82	FMPEP_VARIANTL	Session variants (line part) for transaction FMPEP	2	FM_AREA	Financial Management Area	nvarchar	4	0
83	FMPROFILE	Profile for BCS budgeting	2	FM_AREA	Financial Management Area	nvarchar	4	0
84	FMPTCOMB	Allowed combinations (process / budget type)	2	FM_AREA	Financial Management Area	nvarchar	4	0
85	FMPTCOMBA	Allowed combinations (process / budget type) for status	2	FM_AREA	Financial Management Area	nvarchar	4	0
86	FMPTCOMBAG	Allowed combinations process / budget type group for status	2	FM_AREA	Financial Management Area	nvarchar	4	0
87	FMPTCOMBG	Allowed Combinations Process/Budget Type Using BT Groups	2	FM_AREA	Financial Management Area	nvarchar	4	0
88	FMRBACT	RIB Customizing Settings	2	FM_AREA	Financial Management Area	nvarchar	4	0
89	FMRBACTCD	Activation of Change Documents for FMRBT Records	2	FM_AREA	Financial Management Area	nvarchar	4	0
90	FMRBBOBJECTS	Master Data For Revenue Increasing the Budget: RIB Objects	2	FM_AREA	Financial Management Area	nvarchar	4	0
91	FMRBBRECS	Master Data For RIB: Budget Receivers per RIB Object	2	FM_AREA	Financial Management Area	nvarchar	4	0
92	FMRBCDACT	Activation of Change Documents for Cover Elibility	2	FM_AREA	Financial Management Area	nvarchar	4	0
93	FMRELSTATE	Definition of release scenario	2	FM_AREA	Financial Management Area	nvarchar	4	0
94	FMREL_FTYPE	Consumable budget type for Fund Type	2	FM_AREA	Financial Management Area	nvarchar	4	0
95	FMREL_FUND	Release settings for Fund	2	FM_AREA	Financial Management Area	nvarchar	4	0
96	FMREV_STGRD_ACT	Activation of the Reversal Reason for Budget Documents	2	FM_AREA	Financial Management Area	nvarchar	4	0
97	FMREV_STGRD_DEF	Allowed Reversal Reasons for Budget Documents	2	FM_AREA	Financial Management Area	nvarchar	4	0
98	FMROLLUP_FTYPE	Preclosing Rollup: Transfer Rules for Fund Type	2	FM_AREA	Financial Management Area	nvarchar	4	0
99	FMROLLUP_FUND	Preclosing Rollup: Transfer Rules for Fund	2	FM_AREA	Financial Management Area	nvarchar	4	0
100	FMSTATDEF	Budgeting status definition	2	FM_AREA	Financial Management Area	nvarchar	4	0
101	FMSTATDEFT	Texts for Budgeting Status	2	FM_AREA	Financial Management Area	nvarchar	4	0
TOPBudgeting and Availability Control
102	GMBDGTFM	FM defaults for Interface with GM Budget	3	FM_AREA	Financial Management Area	nvarchar	4	0
103	GMBDGTFYDLINE	GM Budgeting Fiscal Year Distribution Lines	15	FM_AREA	Financial Management Area	nvarchar	4	0
104	GMFMRECS	GM RIB: FM Receivers (obsolete)	6	FM_AREA	Financial Management Area	nvarchar	4	0
105	GMFMRECS1	GM RIB: FM Budget Receivers	3	FM_AREA	Financial Management Area	nvarchar	4	0
106	GMHBDGTFYDLINE	GM Budgeting Fiscal Year Distribution Lines	16	FM_AREA	Financial Management Area	nvarchar	4	0
107	GMRBFMREC	GM RIB: FM Budget Receivers	4	FM_AREA	Financial Management Area	nvarchar	4	0
TOPFunctions for U.S. Federal Government
108	FMFG_BUTYPE	Budgetary ledger Attributes of the budget type	6	FM_AREA	Financial Management Area	nvarchar	4	0
109	FMFG_FUND_ADJ	Customizing for adjustment on fund level	2	FM_AREA	Financial Management Area	nvarchar	4	0
TOPFunds Management
110	BPREP_HRFPM_BCS	Variants of Budget Creation for PBC	3	FM_AREA	Financial Management Area	nvarchar	4	0
111	FMBLEXTACB	Activation of BL Ext for Value Type - Budgets	2	FM_AREA	Financial Management Area	nvarchar	4	0
112	FMBLEXTACC	Activation of BL Ext for Value Type - Commitments / Actuals	2	FM_AREA	Financial Management Area	nvarchar	4	0
113	FMBLEXTACT	Activation of BL Ext for Budget Category	2	FM_AREA	Financial Management Area	nvarchar	4	0
114	FMBLEXTBU	Substitute BL Doc Types for Budget Docs	2	FM_AREA	Financial Management Area	nvarchar	4	0
115	FMBLEXTEA	Substitute BL Doc Types for Earmarked Funds	2	FM_AREA	Financial Management Area	nvarchar	4	0
116	FMBLEXTFA	Substitute BL Doc Types	2	FM_AREA	Financial Management Area	nvarchar	4	0
117	FMBLEXTFLA	Selection of fields to be moved in FI for BL Ext - Fields	2	FM_AREA	Financial Management Area	nvarchar	4	0
118	FMBLEXTFMA	Selection of fields to be moved in FI for BL Ext - FM Areas	2	FM_AREA	Financial Management Area	nvarchar	4	0
119	FMBLEXTIN	Substitute BL Doc Types for Invoices	2	FM_AREA	Financial Management Area	nvarchar	4	0
120	FMBLPSTNG	FM BL posting customizing for GL line-items collection	2	FM_AREA	Financial Management Area	nvarchar	4	0
121	FMBPCLOSE_FTYPE	Preclosing Rollup: Transfer Rules for Fund Type	2	FM_AREA	Financial Management Area	nvarchar	4	0
122	FMBPCLOSE_FUND	Preclosing Rollup: Transfer Rules for Fund	2	FM_AREA	Financial Management Area	nvarchar	4	0
123	FMBUDACL	Rules for Closing Residual Ledger Accounts	3	FM_AREA	Financial Management Area	nvarchar	4	0
124	FMBUDBCS	Budgetary ledger account derivation: BCS	3	FM_AREA	Financial Management Area	nvarchar	4	0
125	FMBUDDIS	Budgetary ledger account derivation: Budgeting (old)	3	FM_AREA	Financial Management Area	nvarchar	4	0
126	FMBUDRES	Budgetary ledger account derivation: Revenue/Statistical	3	FM_AREA	Financial Management Area	nvarchar	4	0
127	FMBUDREV	Revenue/Statistical Postings & Open items/actuals Resource	3	FM_AREA	Financial Management Area	nvarchar	4	0
128	FMBUDSTA	Budgetary ledger account derivation: Open items/Actuals bdgt	3	FM_AREA	Financial Management Area	nvarchar	4	0
129	FMCLOSEOUT	Rules for Closing out Obligations	2	FM_AREA	Financial Management Area	nvarchar	4	0
130	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	54	FM_AREA	Financial Management Area	nvarchar	4	0
131	FMFG_SAV_FACTS2A	Saved FACTS2A data for docs excluded from SL Repost for 600	58	FM_AREA	Financial Management Area	nvarchar	4	0
132	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	78	FM_AREA	Financial Management Area	nvarchar	4	0
133	FMFG_YBA_AVC	FMFG: Year of Budget Authority - AVC	2	FM_AREA	Financial Management Area	nvarchar	4	0
134	FMFUNDTYPE	FM Fund Types	2	FM_AREA	Financial Management Area	nvarchar	4	0
135	FMFUNDTYPET	FM Fund Types Texts	2	FM_AREA	Financial Management Area	nvarchar	4	0
136	FMIUR	Open Interval Rules for updating FM	2	FM_AREA	Financial Management Area	nvarchar	4	0
137	FMUD	Override FM Update Date	2	FM_AREA	Financial Management Area	nvarchar	4	0
138	FMUSFGA	Actual line item table for US Federal Government.	78	FM_AREA	Financial Management Area	nvarchar	4	0
139	FMUSFGFACTS1A	4Actual line item table	54	FM_AREA	Financial Management Area	nvarchar	4	0
140	FMUSFGFACTS1T	Summary table	64	FM_AREA	Financial Management Area	nvarchar	4	0
141	FMUSFGFACTS2A	Actual line item table	58	FM_AREA	Financial Management Area	nvarchar	4	0
142	FMUSFGFACTS2T	Summary table	68	FM_AREA	Financial Management Area	nvarchar	4	0
143	FMUSFGT	Summary table for US Federal Government	65	FM_AREA	Financial Management Area	nvarchar	4	0
144	TBPAS_FTYPE	Budget Subtypes for Availability Control for Each Fund Type	2	FM_AREA	Financial Management Area	nvarchar	4	0
145	TBPAS_FUND	Budget Subtypes for Availability Control Per Fund	2	FM_AREA	Financial Management Area	nvarchar	4	0
146	TBPBWRET20	FM Plan Data Transfer Header Transfer	3	FM_AREA	Financial Management Area	nvarchar	4	0
TOPGrantee Management
147	GMIA	Actual Line Item Table	53	FM_AREA	Financial Management Area	nvarchar	4	0
TOPMaster Data
148	FMMEASURE_FGC	Field group criteria (Funded Program) using FM Area	2	FM_AREA	Financial Management Area	nvarchar	4	0
149	GMFUNDRECOVER_O	Fund recovery for outgoing grants	4	FM_AREA	Financial Management Area	nvarchar	4	0
150	GMGFUND	Grant specific fund details	3	FM_AREA	Financial Management Area	nvarchar	4	0
151	GMGRCOSTSHARE	Cost sharing master data	3	FM_AREA	Financial Management Area	nvarchar	4	0
152	GMGRSPONSOREDOBJ	Grant sponsored objects	5	FM_AREA	Financial Management Area	nvarchar	4	0
153	GMSPCLASS_FMBA	Sponsored Class Master Data - Budget Allowed Object	3	FM_AREA	Financial Management Area	nvarchar	4	0
154	GMSPCLASS_FMBT	Sponsored Class Master Data - Budget Transfer Object	3	FM_AREA	Financial Management Area	nvarchar	4	0
155	GMSPPROGRAM_FMBA	Sponsored Program Master Data - Budget Allowed Object	3	FM_AREA	Financial Management Area	nvarchar	4	0
156	GMSPPROGRAM_FMBT	Sponsored Program Master Data - Budget Transfer Objects	3	FM_AREA	Financial Management Area	nvarchar	4	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

156 columns | ERP 6.0 | FM_AREA