	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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	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

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

334 columns | ERP 6.0 | RYEAR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/GL4A	Calculation Version Assignment	6	RYEAR	From Fiscal Year	nvarchar	4	0
2	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	112	RYEAR		nvarchar	4	0
3	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	112	RYEAR		nvarchar	4	0
4	/BIC/B0000171000	PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances	5	RYEAR		nvarchar	4	0
5	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	157	RYEAR		nvarchar	4	0
6	/BIC/B0000173000	PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.	5	RYEAR		nvarchar	4	0
7	/BIC/B0000174000	PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs	5	RYEAR		nvarchar	4	0
8	/BIC/B0000175000	PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)	5	RYEAR		nvarchar	4	0
9	/CCEE/SIFI_RFASD	SI EC Sales List - reported data - deliveries	4	RYEAR	Fiscal Year	nvarchar	4	0
10	/CCEE/SIFI_RFASL	SI EC Sales List - reported data	4	RYEAR	Fiscal Year	nvarchar	4	0
11	/SAPF15/FMIT	F15 Summentabelle Haushaltsmanagement	3	RYEAR	Geschäftsjahr	nvarchar	4	0
12	/SAPF15/FMITB	F15 Summentabelle Haushaltsmanagement (Belegnummer)	3	RYEAR	Geschäftsjahr	nvarchar	4	0
13	CNV_40305_POST_A	Aggregated amount to be reposted	19	RYEAR	Fiscal Year	nvarchar	4	0
14	CNV_40305_SIM_PA	Aggregated amount to be reposted	20	RYEAR	Fiscal Year	nvarchar	4	0
15	EPIDXB		3	RYEAR		nvarchar	4	0
16	EPIDXC		3	RYEAR		nvarchar	4	0
17	FAGLFLEXT_BAK	General Ledger: Totals	2	RYEAR	Fiscal Year	nvarchar	4	0
18	FAGLFLEXT_DIF	Delta Table: G/L Totals	2	RYEAR	Fiscal Year	nvarchar	4	0
19	FMFGCONV1	Status of conversion process	3	RYEAR	Fiscal Year	nvarchar	4	0
20	GLIDXB	Line-item index for FI-SL BUKRS	3	RYEAR	Fiscal Year	nvarchar	4	0
21	GLIDXC	Line Item Index for FI-SL Global Company	3	RYEAR	Fiscal Year	nvarchar	4	0
22	GLPCA_CT	Profit Center Documents	113	RYEAR	Fiscal Year	nvarchar	4	0
23	GLPCA_T_CT	Profit Center Documents	129	RYEAR	Fiscal Year	nvarchar	4	0
24	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	225	RYEAR	Fiscal Year	nvarchar	4	0
25	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	225	RYEAR	Fiscal Year	nvarchar	4	0
26	GLS2CLUS		5	RYEAR		nvarchar	4	0
27	GLS2IDX	Index table for FI-LC document cluster	5	RYEAR	Fiscal Year	nvarchar	4	0
28	GLT0_BAK	G/L Account Master Record Transaction Figures	6	RYEAR	Fiscal Year	nvarchar	4	0
29	GLT0_DIF	Delta Table: G/L Account Master Transaction Figures	6	RYEAR	Fiscal Year	nvarchar	4	0
30	P08P_CLSC	CLASS Interface Control Table (46C onwards)	6	RYEAR	CLASS Interface Control File Year End Run Year (YYYY)	nvarchar	4	0
31	P08P_USSC	USS Interface Control Table (Contributions & Salary Changes)	3	RYEAR	USS Interface Control File Run Year	nvarchar	4	0
32	P08P_USSC_CARE	USS Interface Control Table (Contributions & Salary Changes)	3	RYEAR	USS Interface Control File Run Year	nvarchar	4	0
33	T5GPBSH_CONTROL	HESA NISR Control table	2	RYEAR	Year	nvarchar	4	0
34	T5GPBST_CONTROL	TPS Control records	3	RYEAR	Year	nvarchar	4	0
35	T7INPER1	P2E: Policy Report Table	4	RYEAR	P2E: Year	nvarchar	4	0
36	T7NOEDG_BF_GRANT	EDAG - Granted Bunnfradrag amount per year	4	RYEAR	EDAG - Reporting Year	nvarchar	4	0
37	T868	Elimination of IC profit and loss	4	RYEAR	Fiscal year	nvarchar	4	0
38	T884B	Assignment valuation methods to company codes	4	RYEAR	Fiscal Year	nvarchar	4	0
39	T895	Local Fiscal Year-Dependent Version Parameters	5	RYEAR	Fiscal Year	nvarchar	4	0
40	T895C	Global Fiscal Year-Dependent Version Parameters	5	RYEAR	Fiscal Year	nvarchar	4	0
41	T8PSA_RUII_HIST	PSA Rollup II History (for produc split by volume)	14	RYEAR	Fiscal Year	nvarchar	4	0
42	TSTGC	Consolidation test data	5	RYEAR	Fiscal year	nvarchar	4	0
43	ZSAWA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
44	ZSAWP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
45	ZSAWT	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
46	ZSEMBPSA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
47	ZSEMBPSP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
48	ZSEMBPST	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
49	ZSPLITA	Isteinzelposten-Tabelle	6	RYEAR	Geschäftsjahr	nvarchar	4	0
50	ZSPLITP	Planeinzelposten-Tabelle	6	RYEAR	Geschäftsjahr	nvarchar	4	0
51	ZSPLITT	Summentabelle	5	RYEAR	Geschäftsjahr	nvarchar	4	0
52	ZZ001A	Actual Line Item Table	6	RYEAR	Fiscal Year	nvarchar	4	0
53	ZZ001P	Plan Line Items Table	6	RYEAR	Fiscal Year	nvarchar	4	0
54	ZZ001T	Summary Table	5	RYEAR	Fiscal Year	nvarchar	4	0
55	ZZLINEA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
56	ZZLINEP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
57	ZZLINET	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
58	ZZSL01A	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
59	ZZSL01P	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
60	ZZSL01T	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
61	ZZSPECA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
62	ZZSPECP	Plan line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
63	ZZSPECT	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPAvailability Control
64	FMAVCA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
65	FMAVCP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
66	FMAVCT	AVC Summary Table (BCS)	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPBasic Functions
67	ARC_IDX_IT	Archive index table for FI-SL line items	3	RYEAR	Fiscal Year	nvarchar	4	0
68	FILCA	FI-LC: Actual journal entry table with 2 object tables	6	RYEAR	Fiscal Year	nvarchar	4	0
69	FILCP	FI-LC: Plan line items for object table	6	RYEAR	Fiscal Year	nvarchar	4	0
70	FILCT	FI-LC: Global totals table with 2 object tables	5	RYEAR	Fiscal Year	nvarchar	4	0
71	GGREFA	Example for Global FI-SL Line Items (Actual)	6	RYEAR	Fiscal Year	nvarchar	4	0
72	GGREFP	Example for Global FI-SL Line Items (Plan)	6	RYEAR	Fiscal Year	nvarchar	4	0
73	GGREFT	Example for Global FI-SL Summary Table	5	RYEAR	Fiscal Year	nvarchar	4	0
74	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	6	RYEAR	Fiscal Year	nvarchar	4	0
75	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	6	RYEAR	Fiscal Year	nvarchar	4	0
76	GLFUNCT	Totals Table for Cost of Sales Accounting	5	RYEAR	Fiscal Year	nvarchar	4	0
77	GLFUNCU	Rollup line item tables with function area for IDES	6	RYEAR	Fiscal Year	nvarchar	4	0
78	GLFUNCV	Rollup plan line items table with function area for IDES	6	RYEAR	Fiscal Year	nvarchar	4	0
79	GLIDXA	Index to Find FI-SL Documents Based on AWKEY	7	RYEAR	Fiscal year	nvarchar	4	0
80	GLP0	Local Logical General Ledger Plan Line Items	6	RYEAR	Fiscal Year	nvarchar	4	0
81	GLPO1	Plan Line Items for Object Table	5	RYEAR	Fiscal Year	nvarchar	4	0
82	GLPO2	Plan Line Items for Object Table Global	5	RYEAR	Fiscal Year	nvarchar	4	0
83	GLPO3	Plan Line Items for Object Table	5	RYEAR	Fiscal Year	nvarchar	4	0
84	GLREFA	Example for Local FI-SL Line Items (Actual)	6	RYEAR	Fiscal Year	nvarchar	4	0
85	GLREFP	Example for Local FI-SL Line Items (Plan)	6	RYEAR	Fiscal Year	nvarchar	4	0
86	GLREFT	Example for Local FI-SL Summary Table	5	RYEAR	Fiscal Year	nvarchar	4	0
87	GLREFU	Example for FI-SL Rollup Line Items (Actual)	6	RYEAR	Fiscal Year	nvarchar	4	0
88	GLREFV	Example for Rollup FI-SL Line Items (Plan)	6	RYEAR	Fiscal Year	nvarchar	4	0
89	GLSO1	FI-SL Line Item Table with Objects for GLTO1	5	RYEAR	Fiscal Year	nvarchar	4	0
90	GLSO2	FI-SL Table with Objects, Structure corresponds to GLS2	5	RYEAR	Fiscal Year	nvarchar	4	0
91	GLSO3	FI-SL LI Table with Objects for GLTO3	5	RYEAR	Fiscal Year	nvarchar	4	0
92	GLT0	G/L account master record transaction figures	6	RYEAR	Fiscal Year	nvarchar	4	0
93	GLT3	Summary Data Preparations for Consolidation	6	RYEAR	Fiscal Year	nvarchar	4	0
94	GLTO1	FI-SL Table with Objects, Structure Corresponds to GLT1	5	RYEAR	Fiscal Year	nvarchar	4	0
95	GLTO2	FI-SL Table with Objects, Structure Corresponds to GLT2	5	RYEAR	Fiscal Year	nvarchar	4	0
96	GLTO3	FISL Table with Objects, Amounts and Quantities in Format P9	5	RYEAR	Fiscal Year	nvarchar	4	0
97	T807R	FI-SL Rollup: History of Executions	12	RYEAR	Fiscal Year	nvarchar	4	0
98	T850D	Assignment of business segment	3	RYEAR	Fiscal year	nvarchar	4	0
99	T850S	Tax rates	3	RYEAR	Fiscal year	nvarchar	4	0
100	T851	Changes in Investments	6	RYEAR	Fiscal year	nvarchar	4	0
101	T852G	Subgroup companies	3	RYEAR	Fiscal year	nvarchar	4	0
102	T852U	Subgroup companies	3	RYEAR	Fiscal year	nvarchar	4	0
103	T853	Company status	5	RYEAR	Fiscal year	nvarchar	4	0
104	T853K	Subgroup status	5	RYEAR	Fiscal year	nvarchar	4	0
105	T863X	Selections for reporting	3	RYEAR	Fiscal year	nvarchar	4	0
106	T863Y	INDX datasets	3	RYEAR	Fiscal year	nvarchar	4	0
107	T863Z	Selection: Document status	3	RYEAR	Fiscal year	nvarchar	4	0
108	T864	Reclassifications	2	RYEAR	Fiscal year	nvarchar	4	0
109	T865	Intercompany Elimination	2	RYEAR	"From" year	nvarchar	4	0
110	T866	Elimination of IC profit/loss: FS items	4	RYEAR	"From" year	nvarchar	4	0
111	T868B	Elimination of IC profit/loss: Inventory management co.s	3	RYEAR	Fiscal year	nvarchar	4	0
112	T868L	Elimination of IC profit/loss: Vendor data	7	RYEAR	"From" year	nvarchar	4	0
113	T870	Consolidation method assignment	5	RYEAR	"From" year	nvarchar	4	0
114	T871	Changes in investee equity	5	RYEAR	Fiscal year	nvarchar	4	0
115	T872	Equity Holdings Adjustments	6	RYEAR	Fiscal year	nvarchar	4	0
116	T873	Hidden reserves	5	RYEAR	Fiscal year	nvarchar	4	0
117	T875	Asset transfers within the group	8	RYEAR	Fiscal year	nvarchar	4	0
118	T875C	Changes in depreciation	5	RYEAR	Fiscal year	nvarchar	4	0
119	T875D	Asset transfers	32	RYEAR	Year of the asset transfer	nvarchar	4	0
120	T875E	Change in depreciation of asset transfers	6	RYEAR	Fiscal year	nvarchar	4	0
121	T880B	Valuation methods	4	RYEAR	Fiscal Year	nvarchar	4	0
122	T884H	Historical currency translation	5	RYEAR	Fiscal year	nvarchar	4	0
TOPBasic Settings
123	T895PCA	EC-PCA: Fiscal-Year Dependent Version Parameters	5	RYEAR	Fiscal year	nvarchar	4	0
TOPBudgeting
124	FMBDA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
125	FMBDP	FM Budget change line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
126	FMBDT	FM budget totals table	5	RYEAR	Fiscal Year	nvarchar	4	0
127	FMRBA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
128	FMRBP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
129	FMRBT	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPClaims Management
130	ICLCCEVPAY	Claim Bundle - Payment Sum	5	RYEAR	Number of Claims Reported in Fiscal Year	nvarchar	4	0
131	ICLCCEVRES	Claim Bundle - Reserve Sum	4	RYEAR	Number of Claims Reported in Fiscal Year	nvarchar	4	0
132	ICSCCEVPAY	Claim Bundle - Payment Sum	5	RYEAR	Number of Claims Reported in Fiscal Year	nvarchar	4	0
133	ICSCCEVRES	Claim Bundle - Reserve Sum	4	RYEAR	Number of Claims Reported in Fiscal Year	nvarchar	4	0
TOPCollectionsDisbursements
134	GLISDEA	Actual Line Item Tables for Insurance (DE)	6	RYEAR	Fiscal Year	nvarchar	4	0
135	GLISDEP	Plan Line Item Table for Insurance (DE)	6	RYEAR	Fiscal Year	nvarchar	4	0
136	GLISDET	Summary Table for Insurance (DE)	5	RYEAR	Fiscal Year	nvarchar	4	0
137	GRISDEA	Actual Line Item Table for Insurance (DE) - Rollup	6	RYEAR	Fiscal Year	nvarchar	4	0
138	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	6	RYEAR	Fiscal Year	nvarchar	4	0
139	GRISDET	Summary Table for Insurance (DE) - Rollup	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPConsolidation
140	ECMCA	SAP Cons.: Journal Entry Table (Actual)	6	RYEAR	Fiscal Year	nvarchar	4	0
141	ECMCT	SAP Cons.: Totals Table	5	RYEAR	Fiscal Year	nvarchar	4	0
142	TF080	List Directory of MCDX	6	RYEAR	Fiscal year	nvarchar	4	0
143	TF154	Dimensions year- and period-dependent	3	RYEAR	Effective from fiscal year	nvarchar	4	0
144	TF155	Dimensions: Assign Task Groups	4	RYEAR	Effective from fiscal year	nvarchar	4	0
145	TF163	Consolidation Units, Version/Period-Based Attributes	5	RYEAR	Effective from fiscal year	nvarchar	4	0
146	TF164	Consolidation Unit Year-Dependent	4	RYEAR	Effective from fiscal year	nvarchar	4	0
147	TF167	Consolidation Units Version- and Period-Dependent	5	RYEAR	Effective from fiscal year	nvarchar	4	0
148	TF169	Version/Period-Dependent Cons. Units: Tax Rates	5	RYEAR	Effective from fiscal year	nvarchar	4	0
149	TF183A	Consolidation Groups - Restricted Task Groups	4	RYEAR	Effective from fiscal year	nvarchar	4	0
150	TF184	Consolidation Groups, Version- and Year-Dependent	5	RYEAR	Effective from fiscal year	nvarchar	4	0
151	TF187	Consolidation Group Set Assignments	5	RYEAR	Fiscal year	nvarchar	4	0
152	TF188	Consolidation Group Assignment of Task Group	5	RYEAR	Effective from fiscal year	nvarchar	4	0
153	TF189	Assignment of CG/CU, Version- and Period-Dependent	6	RYEAR	Effective from fiscal year	nvarchar	4	0
154	TF192	Hierarchies, Period-Dependent	4	RYEAR	Effective from fiscal year	nvarchar	4	0
155	TF250	Periods, Opened/Closed	5	RYEAR	Fiscal year	nvarchar	4	0
156	TF260	Overall Status of CG/CU - Data Monitor	5	RYEAR	Fiscal year	nvarchar	4	0
157	TF261	CG/CU: Detail Status of Tasks - Data Monitor	5	RYEAR	Fiscal year	nvarchar	4	0
158	TF262	History of Data Entry Layouts	4	RYEAR	Fiscal year	nvarchar	4	0
159	TF270	CG/CU Overall Status of Consolidation Monitor	5	RYEAR	Fiscal year	nvarchar	4	0
160	TF271	CG/CU: Detail Status of Tasks - Consolidation Monitor	5	RYEAR	Fiscal year	nvarchar	4	0
161	TF280	User-Defined Tasks	4	RYEAR	Effective from fiscal year	nvarchar	4	0
162	TF362	Download: Selection Parameters for Downloading Fin. Data	8	RYEAR	Fiscal year	nvarchar	4	0
163	TF425	Exchange Rate Indicators: ER Type Assignments	4	RYEAR	Effective from fiscal year	nvarchar	4	0
164	TF543	Consolidation Tasks: Assignments of Methods and Doc.Types	5	RYEAR	Effective from fiscal year	nvarchar	4	0
165	TF544	Tasks: Task Group Exceptions	6	RYEAR	Effective from fiscal year	nvarchar	4	0
166	TF545	Consolidation Tasks: Exceptions for Cons Units	6	RYEAR	Effective from fiscal year	nvarchar	4	0
167	TF562	Assignment of Method/Doc. Type to Task in Reclassification	5	RYEAR	Effective from fiscal year	nvarchar	4	0
168	TF570	Tasks for Manual Posting - Document Type Assignments	5	RYEAR	Effective from fiscal year	nvarchar	4	0
169	TF575	Tasks for CG Changes: Document Type Assignments	5	RYEAR	Effective from fiscal year	nvarchar	4	0
170	TF585	Inventory Data	5	RYEAR	Fiscal year	nvarchar	4	0
171	TF586	Supplier Data	4	RYEAR	Effective from fiscal year	nvarchar	4	0
172	TF595	Elimination of IU Profit/Loss in Inventory: Tasks	5	RYEAR	Effective from fiscal year	nvarchar	4	0
173	TF599	Global Settings for Elim. of IU P/L in Inventory	3	RYEAR	Effective from fiscal year	nvarchar	4	0
174	TF615	C/I Tasks: Assignment of Document Types	5	RYEAR	Effective from fiscal year	nvarchar	4	0
175	TF616	C/I Activities/Acctg Techniques: Document Type Assignments	6	RYEAR	Effective from fiscal year	nvarchar	4	0
176	TF620	Changes in Investments	7	RYEAR	Fiscal year	nvarchar	4	0
177	TF625	Group Shares	8	RYEAR	Effective from fiscal year	nvarchar	4	0
178	TF630	Changes in Investee Equity	7	RYEAR	Fiscal year	nvarchar	4	0
179	TF643	Fair Value Adjustments: Version/Date-Sensitive	7	RYEAR	Effective from fiscal year	nvarchar	4	0
180	TF645	Reporting Fair Value Adjustment Data	7	RYEAR	Fiscal year	nvarchar	4	0
181	TF650	C/I Activity Numbers	7	RYEAR	Fiscal year	nvarchar	4	0
182	TF651	Activity Numbers - Sequence	7	RYEAR	Fiscal year	nvarchar	4	0
183	TF652	Activity Numbers - Sequence - Sort Status	6	RYEAR	Fiscal year	nvarchar	4	0
184	TF660	Equity Holdings Adjustments	7	RYEAR	Fiscal year	nvarchar	4	0
185	TF661	Equity Holdings Adjustments by Upper Unit	7	RYEAR	Fiscal year	nvarchar	4	0
186	TFMIG10	Migration: Processing Options	6	RYEAR	Fiscal year	nvarchar	4	0
TOPCost Element Accounting
187	COFIP	Single plan items for reconciliation ledger	6	RYEAR	Fiscal Year	nvarchar	4	0
188	COFIS	Actual line items for reconciliation ledger	6	RYEAR	Fiscal Year	nvarchar	4	0
189	COFIT	Totals Records for Reconciliation Ledger	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPData Collection
190	CF709	Consolidation Basic	22	RYEAR	Effective from fiscal year	nvarchar	4	0
191	CF710	IDES FPI	13	RYEAR	Effective from fiscal year	nvarchar	4	0
192	KCK710	Comments for FPI	17	RYEAR	Effective from fiscal year	nvarchar	4	0
TOPData Retention Tool
193	TXW_S_COFI	Retrieve COFIS from archive	9	RYEAR	Fiscal Year	nvarchar	4	0
194	TXW_S_GLT0	Retrieve archived GLT0 data	6	RYEAR	Fiscal Year	nvarchar	4	0
TOPFinancial Accounting
195	FBICRC001A	ICRC: Open Items GL Accounts: Documents	6	RYEAR	Fiscal Year	nvarchar	4	0
196	FBICRC001P	Not in use	6	RYEAR	Fiscal Year	nvarchar	4	0
197	FBICRC001T	ICRC: Open Items GL Accounts: Totals	5	RYEAR	Fiscal Year	nvarchar	4	0
198	FBICRC002A	ICRC: GL Accounts: Documents	6	RYEAR	Fiscal Year	nvarchar	4	0
199	FBICRC002P	Not in use	6	RYEAR	Fiscal Year	nvarchar	4	0
200	FBICRC002T	ICRC: GL Accounts: Totals	5	RYEAR	Fiscal Year	nvarchar	4	0
201	FBICRC003A	ICRC: Open Items Customers/Vendors: Documents	6	RYEAR	Fiscal Year	nvarchar	4	0
202	FBICRC003P	Not in use	6	RYEAR	Fiscal Year	nvarchar	4	0
203	FBICRC003T	ICRC: Open Items Customers/Vendors: Totals	5	RYEAR	Fiscal Year	nvarchar	4	0
204	FBICRC01020	Not in use	2	RYEAR	Fiscal Year	nvarchar	4	0
205	FBICRC01021	Not in use	2	RYEAR	Fiscal Year	nvarchar	4	0
206	FBICRC01025	Not in use	2	RYEAR	Fiscal Year	nvarchar	4	0
207	FBICRC01026	Not in use	3	RYEAR	Fiscal Year	nvarchar	4	0
208	FBICRC01027	Reconciliation: Current Status per Company	2	RYEAR	Fiscal Year	nvarchar	4	0
209	FBICRC01028	Reconciliation Process 003: Lock Table for Company Pairs	3	RYEAR	Fiscal Year	nvarchar	4	0
210	FBICRC01040	IC Reconciliation: Current Status per Company	4	RYEAR	Fiscal Year	nvarchar	4	0
211	FBICRC01045	IC Reconciliation: Lock Table for Company Pairs	4	RYEAR	Fiscal Year	nvarchar	4	0
212	FBICRC01050	Differences per Company Pair and Display Category	4	RYEAR	Fiscal Year	nvarchar	4	0
TOPFinancial Services Localization
213	/CEEIS/RUA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
214	/CEEIS/RUP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
215	/CEEIS/RUT	Totals Table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPFlexible Real Estate Management
216	VIPRLEDTAGRA	Isteinzelposten-Tabelle	6	RYEAR	Geschäftsjahr	nvarchar	4	0
217	VIPRLEDTAGRP	Planeinzelposten-Tabelle	6	RYEAR	Geschäftsjahr	nvarchar	4	0
218	VIPRLEDTAGRT	Summentabelle Ledger 7A Mandate	5	RYEAR	Geschäftsjahr	nvarchar	4	0
TOPFund Accounting
219	FMCCAVCA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
220	FMCCAVCP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
221	FMCCAVCT	Totals Table	5	RYEAR	Fiscal Year	nvarchar	4	0
222	FMGLFLEXA	General Ledger: Actual Line Items	2	RYEAR	Fiscal Year	nvarchar	4	0
223	FMGLFLEXP	General Ledger: Plan Line Items	2	RYEAR	Fiscal Year	nvarchar	4	0
224	FMGLFLEXT	General Ledger Public Sector: Total	2	RYEAR	Fiscal Year	nvarchar	4	0
225	PSGLFLEXA	General Ledger: Actual Line Items	2	RYEAR	Fiscal Year	nvarchar	4	0
226	PSGLFLEXP	General Ledger: Plan Line Items	2	RYEAR	Fiscal Year	nvarchar	4	0
227	PSGLFLEXT	General Ledger Public Sector: Total	2	RYEAR	Fiscal Year	nvarchar	4	0
TOPFunds Management
228	FMCCFD	Fiscal Year Change Documents (FM)	4	RYEAR	Closing Operations in FM: Receiver Fiscal Year	nvarchar	4	0
229	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	6	RYEAR	Fiscal Year	nvarchar	4	0
230	FMFG_SAV_FACTS2A	Saved FACTS2A data for docs excluded from SL Repost for 600	6	RYEAR	Fiscal Year	nvarchar	4	0
231	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	6	RYEAR	Fiscal Year	nvarchar	4	0
232	FMFG_SAV_GLIDXA	Saved GLIDXA data for docs excluded from SL Repost for 600	7	RYEAR	Fiscal year	nvarchar	4	0
233	FMFG_YBA_AVC	FMFG: Year of Budget Authority - AVC	4	RYEAR	Fiscal Year	nvarchar	4	0
234	FMFG_YBA_DELTA	FMFG: Year of Budget Authority - Timestamp	3	RYEAR	Fiscal Year	nvarchar	4	0
235	FMIA	Actual Line Item Table for Funds Management	6	RYEAR	Fiscal Year	nvarchar	4	0
236	FMIP	Plan Line Items Table for Funds Management	6	RYEAR	Fiscal Year	nvarchar	4	0
237	FMIT	Totals Table for Funds Management	5	RYEAR	Fiscal Year	nvarchar	4	0
238	FMSPLITA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
239	FMSPLITP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
240	FMSPLITT	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
241	FMUSFGA	Actual line item table for US Federal Government.	6	RYEAR	Fiscal Year	nvarchar	4	0
242	FMUSFGFACTS1A	4Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
243	FMUSFGFACTS1P	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
244	FMUSFGFACTS1T	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
245	FMUSFGFACTS2A	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
246	FMUSFGFACTS2P	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
247	FMUSFGFACTS2T	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
248	FMUSFGP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
249	FMUSFGT	Summary table for US Federal Government	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPGeneral Ledger Accounting
250	FAGLFLEXA	General Ledger: Actual Line Items	2	RYEAR	Fiscal Year	nvarchar	4	0
251	FAGLFLEXP	General Ledger: Plan Line Items	2	RYEAR	Fiscal Year	nvarchar	4	0
252	FAGLFLEXT	General Ledger: Totals	2	RYEAR	Fiscal Year	nvarchar	4	0
253	FAGL_BW_LOG_TOTL	FI-GL: Log for BW Extraction: Totals Records	6	RYEAR	Fiscal year	nvarchar	4	0
254	FAGL_EXTR	Documents for Summary Document Transfer	5	RYEAR	Fiscal Year	nvarchar	4	0
255	FAGL_EXTR_HIST	Transfer History for Summary Documents	11	RYEAR	Fiscal Year	nvarchar	4	0
256	FAGL_MIG_TOTALS	Log Table for Building Balances in New G/L	4	RYEAR	Fiscal Year	nvarchar	4	0
257	FAGL_QUEUE_LOG	Log of Delta Queue for Error Analysis	4	RYEAR	Fiscal year	nvarchar	4	0
258	FAGL_RSNAPSHOT	Reorganization: Snapshot	9	RYEAR	Fiscal Year	nvarchar	4	0
259	GLFLEXA	Flexible general ledger: Actual line items	2	RYEAR	Fiscal Year	nvarchar	4	0
260	GLFLEXP	Flexible G/L: Plan line items	2	RYEAR	Fiscal Year	nvarchar	4	0
261	GLFLEXT	Flexible G/L: Totals	2	RYEAR	Fiscal Year	nvarchar	4	0
TOPGeneral Ledger Reorganization
262	FAGL_R_BLNCE	Reorganization: Balances to Be Transferred	10	RYEAR	Fiscal Year	nvarchar	4	0
263	FAGL_R_BLNCE_VAL	Reorganization: Balances to Be Transferred - Values	10	RYEAR	Fiscal Year	nvarchar	4	0
TOPGrantee Management
264	GMAVCA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
265	GMAVCP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
266	GMAVCT	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
267	GMIA	Actual Line Item Table	6	RYEAR	Fiscal Year	nvarchar	4	0
268	GMIP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
269	GMIT	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPIreland
270	T7IEE	EHECS: Return Data	2	RYEAR	EHECS: Year	nvarchar	4	0
TOPJoint Venture und Production Sharing Accounting
271	ARC_IDB_IT	Archive-Indextable for JV_BILLING	3	RYEAR	Fiscal Year	nvarchar	4	0
272	ARC_IDJ_IT	Archive-Indextable for JV_OBJECT	3	RYEAR	Fiscal Year	nvarchar	4	0
273	JVGLFLEXA	General Ledger: Actual Line Items	2	RYEAR	Fiscal Year	nvarchar	4	0
274	JVGLFLEXP	General Ledger: Plan Line Items	2	RYEAR	Fiscal Year	nvarchar	4	0
275	JVGLFLEXT	General Ledger: Totals	2	RYEAR	Fiscal Year	nvarchar	4	0
276	JVPO1	JVA: Plan Line Items	6	RYEAR	Fiscal Year	nvarchar	4	0
277	JVPSC01A	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
278	JVPSC01P	Plan line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
279	JVPSC01T	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
280	JVSO1	JV LI Table with Objects for JVTO1	6	RYEAR	Fiscal Year	nvarchar	4	0
281	JVSO2	JV Billing FI-SL Line Item	6	RYEAR	Fiscal Year	nvarchar	4	0
282	JVT1	JV Summary Table	6	RYEAR	Fiscal Year	nvarchar	4	0
283	JVTO1	JV Summary Table with Objects	5	RYEAR	Fiscal Year	nvarchar	4	0
284	JVTO2	JV Billing FI-SL Summary Table	5	RYEAR	Fiscal Year	nvarchar	4	0
285	T8JIX	JV index table	4	RYEAR	Fiscal Year	nvarchar	4	0
286	T8JTPM	Joint Venture Production Month Summary Data	4	RYEAR	Fiscal year	nvarchar	4	0
287	T8JVBA	Documents included in Bank Account Switching	4	RYEAR	Fiscal Year	nvarchar	4	0
288	T8J_JVEC	JVA equity change document relationship	4	RYEAR	Fiscal Year	nvarchar	4	0
289	T8PSA_PREPOST	Preliminary Posting	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPLocalization
290	J_1IEXCHDR	Excise invoice header detail	24	RYEAR	Reference year 1	nvarchar	4	0
291	J_3RFTAXRA	Tax Accounting: Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
292	J_3RFTAXRP	Tax Accounting: Plan line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
293	J_3RFTAXRT	Tax Accounting: Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
294	J_3RFTAXRVA	Tax Accounting: Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
295	J_3RFTAXRVP	Tax Accounting: Plan line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
296	J_3RFTAXRVT	Tax Accounting: Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPPhilippines
297	T7PHRS	Receipt number and Issue dates-Company Grouping.	5	RYEAR	Calendar year	nvarchar	4	0
TOPProfit Center Accounting
298	ARC_IPC_IT	Archive index table for FI-SL line items	3	RYEAR	Fiscal Year	nvarchar	4	0
299	GLPCA	EC-PCA: Actual Line Items	6	RYEAR	Fiscal Year	nvarchar	4	0
300	GLPCP	EC-PCA: Plan Line Items	6	RYEAR	Fiscal Year	nvarchar	4	0
301	GLPCT	EC-PCA: Totals Table	5	RYEAR	Fiscal Year	nvarchar	4	0
302	T8APP_GLPCM	EC-PCA: Plan Costs from Material Costing for Rep. Material	5	RYEAR	Fiscal Year	nvarchar	4	0
303	T8A_ALLOC	Postprocessing of Allocations for BS Accts in Profit Centers	3	RYEAR	Fiscal Year	nvarchar	4	0
TOPProfitability Analysis
304	GLTPC	Profit Center Accounting	6	RYEAR	Fiscal Year	nvarchar	4	0
TOPRegulatory reporting for insurance companies
305	ISSRFLDEA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
306	ISSRFLDEP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
307	ISSRFLDET	Summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPRemaining Beverage - Obsolete Objects
308	/BEV3/CHFIA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
309	/BEV3/CHFIP	Plan Line Items Table	6	RYEAR	Fiscal Year	nvarchar	4	0
310	/BEV3/CHFIT	Totals table	5	RYEAR	Fiscal Year	nvarchar	4	0
311	/BEV3/CHVGRA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
312	/BEV3/CHVGRP	Plan Line Items Table	6	RYEAR	Fiscal Year	nvarchar	4	0
313	/BEV3/CHVGRT	Totals table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPRetail Ledger
314	PCRRETAILA	Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
315	PCRRETAILP	Plan line items table	6	RYEAR	Fiscal Year	nvarchar	4	0
316	PCRRETAILT	Totals Table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPSpecial Purpose Ledger
317	/CCIS/PBU18A	PBU18: Actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
318	/CCIS/PBU18P	PBU18: Plan line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
319	/CCIS/PBU18T	PBU18: Summary table x	5	RYEAR	Fiscal Year	nvarchar	4	0
320	/CCIS/PROFTAXA	Actual Line Items Table for General Ledger	2	RYEAR	Fiscal Year	nvarchar	4	0
321	/CCIS/PROFTAXP	Plan Line Items Table for General Ledger	2	RYEAR	Fiscal Year	nvarchar	4	0
322	/CCIS/PROFTAXT	Totals Table for General Ledger	2	RYEAR	Fiscal Year	nvarchar	4	0
TOPTariffs, Duties and Permits
323	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	6	RYEAR	Fiscal Year	nvarchar	4	0
324	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	6	RYEAR	Fiscal Year	nvarchar	4	0
325	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	5	RYEAR	Fiscal Year	nvarchar	4	0
326	OIHSLA	TDP (excise duty) special ledger actual line item table	6	RYEAR	Fiscal Year	nvarchar	4	0
327	OIHSLT	TDP (excise duty) special ledger summary table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPTransfer to Financial Accounting
328	TRACTSLA	Actual Line Item Table	6	RYEAR	Fiscal Year	nvarchar	4	0
329	TRACTSLP	Plan Line Items Table	6	RYEAR	Fiscal Year	nvarchar	4	0
330	TRACTSLT	Totals Table	5	RYEAR	Fiscal Year	nvarchar	4	0
TOPUnited Kingdom
331	PAGB_ASHE	ASHE Return Data	2	RYEAR	Year	nvarchar	4	0
332	T5G_ASHE_CONTROL	ASHE Control Table	2	RYEAR	Year	nvarchar	4	0
TOPUSA
333	T5U0E	Equal Employment Opportunity Record	3	RYEAR	Evaluation year	nvarchar	4	0
334	T5UEEO	Equal Employment Opportunity Record	3	RYEAR	Evaluation year	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

334 columns | ERP 6.0 | RYEAR