SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

334 columns | Print definition?ERP 6.0  | RYEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/GL4ACalculation Version Assignment6RYEARFrom Fiscal Yearnvarchar40
2/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items112RYEARnvarchar40
3/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact112RYEARnvarchar40
4/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances5RYEARnvarchar40
5/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items157RYEARnvarchar40
6/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.5RYEARnvarchar40
7/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs5RYEARnvarchar40
8/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)5RYEARnvarchar40
9/CCEE/SIFI_RFASDSI EC Sales List - reported data - deliveries4RYEARFiscal Yearnvarchar40
10/CCEE/SIFI_RFASLSI EC Sales List - reported data4RYEARFiscal Yearnvarchar40
11/SAPF15/FMITF15 Summentabelle Haushaltsmanagement3RYEARGeschäftsjahrnvarchar40
12/SAPF15/FMITBF15 Summentabelle Haushaltsmanagement (Belegnummer)3RYEARGeschäftsjahrnvarchar40
13CNV_40305_POST_AAggregated amount to be reposted19RYEARFiscal Yearnvarchar40
14CNV_40305_SIM_PAAggregated amount to be reposted20RYEARFiscal Yearnvarchar40
15EPIDXB3RYEARnvarchar40
16EPIDXC3RYEARnvarchar40
17FAGLFLEXT_BAKGeneral Ledger: Totals2RYEARFiscal Yearnvarchar40
18FAGLFLEXT_DIFDelta Table: G/L Totals2RYEARFiscal Yearnvarchar40
19FMFGCONV1Status of conversion process3RYEARFiscal Yearnvarchar40
20GLIDXBLine-item index for FI-SL BUKRS3RYEARFiscal Yearnvarchar40
21GLIDXCLine Item Index for FI-SL Global Company3RYEARFiscal Yearnvarchar40
22GLPCA_CTProfit Center Documents113RYEARFiscal Yearnvarchar40
23GLPCA_T_CTProfit Center Documents129RYEARFiscal Yearnvarchar40
24GLPOS_N_CTNew General Ledger: Line Item with Currency Type225RYEARFiscal Yearnvarchar40
25GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type225RYEARFiscal Yearnvarchar40
26GLS2CLUS5RYEARnvarchar40
27GLS2IDXIndex table for FI-LC document cluster5RYEARFiscal Yearnvarchar40
28GLT0_BAKG/L Account Master Record Transaction Figures6RYEARFiscal Yearnvarchar40
29GLT0_DIFDelta Table: G/L Account Master Transaction Figures6RYEARFiscal Yearnvarchar40
30P08P_CLSCCLASS Interface Control Table (46C onwards)6RYEARCLASS Interface Control File Year End Run Year (YYYY)nvarchar40
31P08P_USSCUSS Interface Control Table (Contributions & Salary Changes)3RYEARUSS Interface Control File Run Yearnvarchar40
32P08P_USSC_CAREUSS Interface Control Table (Contributions & Salary Changes)3RYEARUSS Interface Control File Run Yearnvarchar40
33T5GPBSH_CONTROLHESA NISR Control table2RYEARYearnvarchar40
34T5GPBST_CONTROLTPS Control records3RYEARYearnvarchar40
35T7INPER1P2E: Policy Report Table4RYEARP2E: Yearnvarchar40
36T7NOEDG_BF_GRANTEDAG - Granted Bunnfradrag amount per year4RYEAREDAG - Reporting Yearnvarchar40
37T868Elimination of IC profit and loss4RYEARFiscal yearnvarchar40
38T884BAssignment valuation methods to company codes4RYEARFiscal Yearnvarchar40
39T895Local Fiscal Year-Dependent Version Parameters5RYEARFiscal Yearnvarchar40
40T895CGlobal Fiscal Year-Dependent Version Parameters5RYEARFiscal Yearnvarchar40
41T8PSA_RUII_HISTPSA Rollup II History (for produc split by volume)14RYEARFiscal Yearnvarchar40
42TSTGCConsolidation test data5RYEARFiscal yearnvarchar40
43ZSAWAActual line item table6RYEARFiscal Yearnvarchar40
44ZSAWPPlan line items table6RYEARFiscal Yearnvarchar40
45ZSAWTSummary table5RYEARFiscal Yearnvarchar40
46ZSEMBPSAActual line item table6RYEARFiscal Yearnvarchar40
47ZSEMBPSPPlan line items table6RYEARFiscal Yearnvarchar40
48ZSEMBPSTSummary table5RYEARFiscal Yearnvarchar40
49ZSPLITAIsteinzelposten-Tabelle6RYEARGeschäftsjahrnvarchar40
50ZSPLITPPlaneinzelposten-Tabelle6RYEARGeschäftsjahrnvarchar40
51ZSPLITTSummentabelle5RYEARGeschäftsjahrnvarchar40
52ZZ001AActual Line Item Table6RYEARFiscal Yearnvarchar40
53ZZ001PPlan Line Items Table6RYEARFiscal Yearnvarchar40
54ZZ001TSummary Table5RYEARFiscal Yearnvarchar40
55ZZLINEAActual line item table6RYEARFiscal Yearnvarchar40
56ZZLINEPPlan line items table6RYEARFiscal Yearnvarchar40
57ZZLINETSummary table5RYEARFiscal Yearnvarchar40
58ZZSL01AActual line item table6RYEARFiscal Yearnvarchar40
59ZZSL01PPlan line items table6RYEARFiscal Yearnvarchar40
60ZZSL01TSummary table5RYEARFiscal Yearnvarchar40
61ZZSPECAActual line item table6RYEARFiscal Yearnvarchar40
62ZZSPECPPlan line item table6RYEARFiscal Yearnvarchar40
63ZZSPECTSummary table5RYEARFiscal Yearnvarchar40
TOPAvailability Control
64FMAVCAActual line item table6RYEARFiscal Yearnvarchar40
65FMAVCPPlan line items table6RYEARFiscal Yearnvarchar40
66FMAVCTAVC Summary Table (BCS)5RYEARFiscal Yearnvarchar40
TOPBasic Functions
67ARC_IDX_ITArchive index table for FI-SL line items3RYEARFiscal Yearnvarchar40
68FILCAFI-LC: Actual journal entry table with 2 object tables6RYEARFiscal Yearnvarchar40
69FILCPFI-LC: Plan line items for object table6RYEARFiscal Yearnvarchar40
70FILCTFI-LC: Global totals table with 2 object tables5RYEARFiscal Yearnvarchar40
71GGREFAExample for Global FI-SL Line Items (Actual)6RYEARFiscal Yearnvarchar40
72GGREFPExample for Global FI-SL Line Items (Plan)6RYEARFiscal Yearnvarchar40
73GGREFTExample for Global FI-SL Summary Table5RYEARFiscal Yearnvarchar40
74GLFUNCAActual Line Items Table for Cost of Sales Accounting6RYEARFiscal Yearnvarchar40
75GLFUNCPPlan Line Items Table for Cost of Sales Accounting6RYEARFiscal Yearnvarchar40
76GLFUNCTTotals Table for Cost of Sales Accounting5RYEARFiscal Yearnvarchar40
77GLFUNCURollup line item tables with function area for IDES6RYEARFiscal Yearnvarchar40
78GLFUNCVRollup plan line items table with function area for IDES6RYEARFiscal Yearnvarchar40
79GLIDXAIndex to Find FI-SL Documents Based on AWKEY7RYEARFiscal yearnvarchar40
80GLP0Local Logical General Ledger Plan Line Items6RYEARFiscal Yearnvarchar40
81GLPO1Plan Line Items for Object Table5RYEARFiscal Yearnvarchar40
82GLPO2Plan Line Items for Object Table Global5RYEARFiscal Yearnvarchar40
83GLPO3Plan Line Items for Object Table5RYEARFiscal Yearnvarchar40
84GLREFAExample for Local FI-SL Line Items (Actual)6RYEARFiscal Yearnvarchar40
85GLREFPExample for Local FI-SL Line Items (Plan)6RYEARFiscal Yearnvarchar40
86GLREFTExample for Local FI-SL Summary Table5RYEARFiscal Yearnvarchar40
87GLREFUExample for FI-SL Rollup Line Items (Actual)6RYEARFiscal Yearnvarchar40
88GLREFVExample for Rollup FI-SL Line Items (Plan)6RYEARFiscal Yearnvarchar40
89GLSO1FI-SL Line Item Table with Objects for GLTO15RYEARFiscal Yearnvarchar40
90GLSO2FI-SL Table with Objects, Structure corresponds to GLS25RYEARFiscal Yearnvarchar40
91GLSO3FI-SL LI Table with Objects for GLTO35RYEARFiscal Yearnvarchar40
92GLT0G/L account master record transaction figures6RYEARFiscal Yearnvarchar40
93GLT3Summary Data Preparations for Consolidation6RYEARFiscal Yearnvarchar40
94GLTO1FI-SL Table with Objects, Structure Corresponds to GLT15RYEARFiscal Yearnvarchar40
95GLTO2FI-SL Table with Objects, Structure Corresponds to GLT25RYEARFiscal Yearnvarchar40
96GLTO3FISL Table with Objects, Amounts and Quantities in Format P95RYEARFiscal Yearnvarchar40
97T807RFI-SL Rollup: History of Executions12RYEARFiscal Yearnvarchar40
98T850DAssignment of business segment3RYEARFiscal yearnvarchar40
99T850STax rates3RYEARFiscal yearnvarchar40
100T851Changes in Investments6RYEARFiscal yearnvarchar40
101T852GSubgroup companies3RYEARFiscal yearnvarchar40
102T852USubgroup companies3RYEARFiscal yearnvarchar40
103T853Company status5RYEARFiscal yearnvarchar40
104T853KSubgroup status5RYEARFiscal yearnvarchar40
105T863XSelections for reporting3RYEARFiscal yearnvarchar40
106T863YINDX datasets3RYEARFiscal yearnvarchar40
107T863ZSelection: Document status3RYEARFiscal yearnvarchar40
108T864Reclassifications2RYEARFiscal yearnvarchar40
109T865Intercompany Elimination2RYEAR"From" yearnvarchar40
110T866Elimination of IC profit/loss: FS items4RYEAR"From" yearnvarchar40
111T868BElimination of IC profit/loss: Inventory management co.s3RYEARFiscal yearnvarchar40
112T868LElimination of IC profit/loss: Vendor data7RYEAR"From" yearnvarchar40
113T870Consolidation method assignment5RYEAR"From" yearnvarchar40
114T871Changes in investee equity5RYEARFiscal yearnvarchar40
115T872Equity Holdings Adjustments6RYEARFiscal yearnvarchar40
116T873Hidden reserves5RYEARFiscal yearnvarchar40
117T875Asset transfers within the group8RYEARFiscal yearnvarchar40
118T875CChanges in depreciation5RYEARFiscal yearnvarchar40
119T875DAsset transfers32RYEARYear of the asset transfernvarchar40
120T875EChange in depreciation of asset transfers6RYEARFiscal yearnvarchar40
121T880BValuation methods4RYEARFiscal Yearnvarchar40
122T884HHistorical currency translation5RYEARFiscal yearnvarchar40
TOPBasic Settings
123T895PCAEC-PCA: Fiscal-Year Dependent Version Parameters5RYEARFiscal yearnvarchar40
TOPBudgeting
124FMBDAActual line item table6RYEARFiscal Yearnvarchar40
125FMBDPFM Budget change line items table6RYEARFiscal Yearnvarchar40
126FMBDTFM budget totals table5RYEARFiscal Yearnvarchar40
127FMRBAActual line item table6RYEARFiscal Yearnvarchar40
128FMRBPPlan line items table6RYEARFiscal Yearnvarchar40
129FMRBTSummary table5RYEARFiscal Yearnvarchar40
TOPClaims Management
130ICLCCEVPAYClaim Bundle - Payment Sum5RYEARNumber of Claims Reported in Fiscal Yearnvarchar40
131ICLCCEVRESClaim Bundle - Reserve Sum4RYEARNumber of Claims Reported in Fiscal Yearnvarchar40
132ICSCCEVPAYClaim Bundle - Payment Sum5RYEARNumber of Claims Reported in Fiscal Yearnvarchar40
133ICSCCEVRESClaim Bundle - Reserve Sum4RYEARNumber of Claims Reported in Fiscal Yearnvarchar40
TOPCollectionsDisbursements
134GLISDEAActual Line Item Tables for Insurance (DE)6RYEARFiscal Yearnvarchar40
135GLISDEPPlan Line Item Table for Insurance (DE)6RYEARFiscal Yearnvarchar40
136GLISDETSummary Table for Insurance (DE)5RYEARFiscal Yearnvarchar40
137GRISDEAActual Line Item Table for Insurance (DE) - Rollup6RYEARFiscal Yearnvarchar40
138GRISDEPPlan Line Item Table for Insurance (DE) - Rollup6RYEARFiscal Yearnvarchar40
139GRISDETSummary Table for Insurance (DE) - Rollup5RYEARFiscal Yearnvarchar40
TOPConsolidation
140ECMCASAP Cons.: Journal Entry Table (Actual)6RYEARFiscal Yearnvarchar40
141ECMCTSAP Cons.: Totals Table5RYEARFiscal Yearnvarchar40
142TF080List Directory of MCDX6RYEARFiscal yearnvarchar40
143TF154Dimensions year- and period-dependent3RYEAREffective from fiscal yearnvarchar40
144TF155Dimensions: Assign Task Groups4RYEAREffective from fiscal yearnvarchar40
145TF163Consolidation Units, Version/Period-Based Attributes5RYEAREffective from fiscal yearnvarchar40
146TF164Consolidation Unit Year-Dependent4RYEAREffective from fiscal yearnvarchar40
147TF167Consolidation Units Version- and Period-Dependent5RYEAREffective from fiscal yearnvarchar40
148TF169Version/Period-Dependent Cons. Units: Tax Rates5RYEAREffective from fiscal yearnvarchar40
149TF183AConsolidation Groups - Restricted Task Groups4RYEAREffective from fiscal yearnvarchar40
150TF184Consolidation Groups, Version- and Year-Dependent5RYEAREffective from fiscal yearnvarchar40
151TF187Consolidation Group Set Assignments5RYEARFiscal yearnvarchar40
152TF188Consolidation Group Assignment of Task Group5RYEAREffective from fiscal yearnvarchar40
153TF189Assignment of CG/CU, Version- and Period-Dependent6RYEAREffective from fiscal yearnvarchar40
154TF192Hierarchies, Period-Dependent4RYEAREffective from fiscal yearnvarchar40
155TF250Periods, Opened/Closed5RYEARFiscal yearnvarchar40
156TF260Overall Status of CG/CU - Data Monitor5RYEARFiscal yearnvarchar40
157TF261CG/CU: Detail Status of Tasks - Data Monitor5RYEARFiscal yearnvarchar40
158TF262History of Data Entry Layouts4RYEARFiscal yearnvarchar40
159TF270CG/CU Overall Status of Consolidation Monitor5RYEARFiscal yearnvarchar40
160TF271CG/CU: Detail Status of Tasks - Consolidation Monitor5RYEARFiscal yearnvarchar40
161TF280User-Defined Tasks4RYEAREffective from fiscal yearnvarchar40
162TF362Download: Selection Parameters for Downloading Fin. Data8RYEARFiscal yearnvarchar40
163TF425Exchange Rate Indicators: ER Type Assignments4RYEAREffective from fiscal yearnvarchar40
164TF543Consolidation Tasks: Assignments of Methods and Doc.Types5RYEAREffective from fiscal yearnvarchar40
165TF544Tasks: Task Group Exceptions6RYEAREffective from fiscal yearnvarchar40
166TF545Consolidation Tasks: Exceptions for Cons Units6RYEAREffective from fiscal yearnvarchar40
167TF562Assignment of Method/Doc. Type to Task in Reclassification5RYEAREffective from fiscal yearnvarchar40
168TF570Tasks for Manual Posting - Document Type Assignments5RYEAREffective from fiscal yearnvarchar40
169TF575Tasks for CG Changes: Document Type Assignments5RYEAREffective from fiscal yearnvarchar40
170TF585Inventory Data5RYEARFiscal yearnvarchar40
171TF586Supplier Data4RYEAREffective from fiscal yearnvarchar40
172TF595Elimination of IU Profit/Loss in Inventory: Tasks5RYEAREffective from fiscal yearnvarchar40
173TF599Global Settings for Elim. of IU P/L in Inventory3RYEAREffective from fiscal yearnvarchar40
174TF615C/I Tasks: Assignment of Document Types5RYEAREffective from fiscal yearnvarchar40
175TF616C/I Activities/Acctg Techniques: Document Type Assignments6RYEAREffective from fiscal yearnvarchar40
176TF620Changes in Investments7RYEARFiscal yearnvarchar40
177TF625Group Shares8RYEAREffective from fiscal yearnvarchar40
178TF630Changes in Investee Equity7RYEARFiscal yearnvarchar40
179TF643Fair Value Adjustments: Version/Date-Sensitive7RYEAREffective from fiscal yearnvarchar40
180TF645Reporting Fair Value Adjustment Data7RYEARFiscal yearnvarchar40
181TF650C/I Activity Numbers7RYEARFiscal yearnvarchar40
182TF651Activity Numbers - Sequence7RYEARFiscal yearnvarchar40
183TF652Activity Numbers - Sequence - Sort Status6RYEARFiscal yearnvarchar40
184TF660Equity Holdings Adjustments7RYEARFiscal yearnvarchar40
185TF661Equity Holdings Adjustments by Upper Unit7RYEARFiscal yearnvarchar40
186TFMIG10Migration: Processing Options6RYEARFiscal yearnvarchar40
TOPCost Element Accounting
187COFIPSingle plan items for reconciliation ledger6RYEARFiscal Yearnvarchar40
188COFISActual line items for reconciliation ledger6RYEARFiscal Yearnvarchar40
189COFITTotals Records for Reconciliation Ledger5RYEARFiscal Yearnvarchar40
TOPData Collection
190CF709Consolidation Basic22RYEAREffective from fiscal yearnvarchar40
191CF710IDES FPI13RYEAREffective from fiscal yearnvarchar40
192KCK710Comments for FPI17RYEAREffective from fiscal yearnvarchar40
TOPData Retention Tool
193TXW_S_COFIRetrieve COFIS from archive9RYEARFiscal Yearnvarchar40
194TXW_S_GLT0Retrieve archived GLT0 data6RYEARFiscal Yearnvarchar40
TOPFinancial Accounting
195FBICRC001AICRC: Open Items GL Accounts: Documents6RYEARFiscal Yearnvarchar40
196FBICRC001PNot in use6RYEARFiscal Yearnvarchar40
197FBICRC001TICRC: Open Items GL Accounts: Totals5RYEARFiscal Yearnvarchar40
198FBICRC002AICRC: GL Accounts: Documents6RYEARFiscal Yearnvarchar40
199FBICRC002PNot in use6RYEARFiscal Yearnvarchar40
200FBICRC002TICRC: GL Accounts: Totals5RYEARFiscal Yearnvarchar40
201FBICRC003AICRC: Open Items Customers/Vendors: Documents6RYEARFiscal Yearnvarchar40
202FBICRC003PNot in use6RYEARFiscal Yearnvarchar40
203FBICRC003TICRC: Open Items Customers/Vendors: Totals5RYEARFiscal Yearnvarchar40
204FBICRC01020Not in use2RYEARFiscal Yearnvarchar40
205FBICRC01021Not in use2RYEARFiscal Yearnvarchar40
206FBICRC01025Not in use2RYEARFiscal Yearnvarchar40
207FBICRC01026Not in use3RYEARFiscal Yearnvarchar40
208FBICRC01027Reconciliation: Current Status per Company2RYEARFiscal Yearnvarchar40
209FBICRC01028Reconciliation Process 003: Lock Table for Company Pairs3RYEARFiscal Yearnvarchar40
210FBICRC01040IC Reconciliation: Current Status per Company4RYEARFiscal Yearnvarchar40
211FBICRC01045IC Reconciliation: Lock Table for Company Pairs4RYEARFiscal Yearnvarchar40
212FBICRC01050Differences per Company Pair and Display Category4RYEARFiscal Yearnvarchar40
TOPFinancial Services Localization
213/CEEIS/RUAActual line item table6RYEARFiscal Yearnvarchar40
214/CEEIS/RUPPlan line items table6RYEARFiscal Yearnvarchar40
215/CEEIS/RUTTotals Table5RYEARFiscal Yearnvarchar40
TOPFlexible Real Estate Management
216VIPRLEDTAGRAIsteinzelposten-Tabelle6RYEARGeschäftsjahrnvarchar40
217VIPRLEDTAGRPPlaneinzelposten-Tabelle6RYEARGeschäftsjahrnvarchar40
218VIPRLEDTAGRTSummentabelle Ledger 7A Mandate5RYEARGeschäftsjahrnvarchar40
TOPFund Accounting
219FMCCAVCAActual line item table6RYEARFiscal Yearnvarchar40
220FMCCAVCPPlan line items table6RYEARFiscal Yearnvarchar40
221FMCCAVCTTotals Table5RYEARFiscal Yearnvarchar40
222FMGLFLEXAGeneral Ledger: Actual Line Items2RYEARFiscal Yearnvarchar40
223FMGLFLEXPGeneral Ledger: Plan Line Items2RYEARFiscal Yearnvarchar40
224FMGLFLEXTGeneral Ledger Public Sector: Total2RYEARFiscal Yearnvarchar40
225PSGLFLEXAGeneral Ledger: Actual Line Items2RYEARFiscal Yearnvarchar40
226PSGLFLEXPGeneral Ledger: Plan Line Items2RYEARFiscal Yearnvarchar40
227PSGLFLEXTGeneral Ledger Public Sector: Total2RYEARFiscal Yearnvarchar40
TOPFunds Management
228FMCCFDFiscal Year Change Documents (FM)4RYEARClosing Operations in FM: Receiver Fiscal Yearnvarchar40
229FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 6006RYEARFiscal Yearnvarchar40
230FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 6006RYEARFiscal Yearnvarchar40
231FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 6006RYEARFiscal Yearnvarchar40
232FMFG_SAV_GLIDXASaved GLIDXA data for docs excluded from SL Repost for 6007RYEARFiscal yearnvarchar40
233FMFG_YBA_AVCFMFG: Year of Budget Authority - AVC4RYEARFiscal Yearnvarchar40
234FMFG_YBA_DELTAFMFG: Year of Budget Authority - Timestamp3RYEARFiscal Yearnvarchar40
235FMIAActual Line Item Table for Funds Management6RYEARFiscal Yearnvarchar40
236FMIPPlan Line Items Table for Funds Management6RYEARFiscal Yearnvarchar40
237FMITTotals Table for Funds Management5RYEARFiscal Yearnvarchar40
238FMSPLITAActual line item table6RYEARFiscal Yearnvarchar40
239FMSPLITPPlan line items table6RYEARFiscal Yearnvarchar40
240FMSPLITTSummary table5RYEARFiscal Yearnvarchar40
241FMUSFGAActual line item table for US Federal Government.6RYEARFiscal Yearnvarchar40
242FMUSFGFACTS1A4Actual line item table6RYEARFiscal Yearnvarchar40
243FMUSFGFACTS1PPlan line items table6RYEARFiscal Yearnvarchar40
244FMUSFGFACTS1TSummary table5RYEARFiscal Yearnvarchar40
245FMUSFGFACTS2AActual line item table6RYEARFiscal Yearnvarchar40
246FMUSFGFACTS2PPlan line items table6RYEARFiscal Yearnvarchar40
247FMUSFGFACTS2TSummary table5RYEARFiscal Yearnvarchar40
248FMUSFGPPlan line items table6RYEARFiscal Yearnvarchar40
249FMUSFGTSummary table for US Federal Government5RYEARFiscal Yearnvarchar40
TOPGeneral Ledger Accounting
250FAGLFLEXAGeneral Ledger: Actual Line Items2RYEARFiscal Yearnvarchar40
251FAGLFLEXPGeneral Ledger: Plan Line Items2RYEARFiscal Yearnvarchar40
252FAGLFLEXTGeneral Ledger: Totals2RYEARFiscal Yearnvarchar40
253FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records6RYEARFiscal yearnvarchar40
254FAGL_EXTRDocuments for Summary Document Transfer5RYEARFiscal Yearnvarchar40
255FAGL_EXTR_HISTTransfer History for Summary Documents11RYEARFiscal Yearnvarchar40
256FAGL_MIG_TOTALSLog Table for Building Balances in New G/L4RYEARFiscal Yearnvarchar40
257FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis4RYEARFiscal yearnvarchar40
258FAGL_RSNAPSHOTReorganization: Snapshot9RYEARFiscal Yearnvarchar40
259GLFLEXAFlexible general ledger: Actual line items2RYEARFiscal Yearnvarchar40
260GLFLEXPFlexible G/L: Plan line items2RYEARFiscal Yearnvarchar40
261GLFLEXTFlexible G/L: Totals2RYEARFiscal Yearnvarchar40
TOPGeneral Ledger Reorganization
262FAGL_R_BLNCEReorganization: Balances to Be Transferred10RYEARFiscal Yearnvarchar40
263FAGL_R_BLNCE_VALReorganization: Balances to Be Transferred - Values10RYEARFiscal Yearnvarchar40
TOPGrantee Management
264GMAVCAActual line item table6RYEARFiscal Yearnvarchar40
265GMAVCPPlan line items table6RYEARFiscal Yearnvarchar40
266GMAVCTSummary table5RYEARFiscal Yearnvarchar40
267GMIAActual Line Item Table6RYEARFiscal Yearnvarchar40
268GMIPPlan line items table6RYEARFiscal Yearnvarchar40
269GMITSummary table5RYEARFiscal Yearnvarchar40
TOPIreland
270T7IEEEHECS: Return Data2RYEAREHECS: Yearnvarchar40
TOPJoint Venture und Production Sharing Accounting
271ARC_IDB_ITArchive-Indextable for JV_BILLING3RYEARFiscal Yearnvarchar40
272ARC_IDJ_ITArchive-Indextable for JV_OBJECT3RYEARFiscal Yearnvarchar40
273JVGLFLEXAGeneral Ledger: Actual Line Items2RYEARFiscal Yearnvarchar40
274JVGLFLEXPGeneral Ledger: Plan Line Items2RYEARFiscal Yearnvarchar40
275JVGLFLEXTGeneral Ledger: Totals2RYEARFiscal Yearnvarchar40
276JVPO1JVA: Plan Line Items6RYEARFiscal Yearnvarchar40
277JVPSC01AActual line item table6RYEARFiscal Yearnvarchar40
278JVPSC01PPlan line item table6RYEARFiscal Yearnvarchar40
279JVPSC01TSummary table5RYEARFiscal Yearnvarchar40
280JVSO1JV LI Table with Objects for JVTO16RYEARFiscal Yearnvarchar40
281JVSO2JV Billing FI-SL Line Item6RYEARFiscal Yearnvarchar40
282JVT1JV Summary Table6RYEARFiscal Yearnvarchar40
283JVTO1JV Summary Table with Objects5RYEARFiscal Yearnvarchar40
284JVTO2JV Billing FI-SL Summary Table5RYEARFiscal Yearnvarchar40
285T8JIXJV index table4RYEARFiscal Yearnvarchar40
286T8JTPMJoint Venture Production Month Summary Data4RYEARFiscal yearnvarchar40
287T8JVBADocuments included in Bank Account Switching4RYEARFiscal Yearnvarchar40
288T8J_JVECJVA equity change document relationship4RYEARFiscal Yearnvarchar40
289T8PSA_PREPOSTPreliminary Posting5RYEARFiscal Yearnvarchar40
TOPLocalization
290J_1IEXCHDRExcise invoice header detail24RYEARReference year 1nvarchar40
291J_3RFTAXRATax Accounting: Actual line item table6RYEARFiscal Yearnvarchar40
292J_3RFTAXRPTax Accounting: Plan line item table6RYEARFiscal Yearnvarchar40
293J_3RFTAXRTTax Accounting: Summary table5RYEARFiscal Yearnvarchar40
294J_3RFTAXRVATax Accounting: Actual line item table6RYEARFiscal Yearnvarchar40
295J_3RFTAXRVPTax Accounting: Plan line item table6RYEARFiscal Yearnvarchar40
296J_3RFTAXRVTTax Accounting: Summary table5RYEARFiscal Yearnvarchar40
TOPPhilippines
297T7PHRSReceipt number and Issue dates-Company Grouping.5RYEARCalendar yearnvarchar40
TOPProfit Center Accounting
298ARC_IPC_ITArchive index table for FI-SL line items3RYEARFiscal Yearnvarchar40
299GLPCAEC-PCA: Actual Line Items6RYEARFiscal Yearnvarchar40
300GLPCPEC-PCA: Plan Line Items6RYEARFiscal Yearnvarchar40
301GLPCTEC-PCA: Totals Table5RYEARFiscal Yearnvarchar40
302T8APP_GLPCMEC-PCA: Plan Costs from Material Costing for Rep. Material5RYEARFiscal Yearnvarchar40
303T8A_ALLOCPostprocessing of Allocations for BS Accts in Profit Centers3RYEARFiscal Yearnvarchar40
TOPProfitability Analysis
304GLTPCProfit Center Accounting6RYEARFiscal Yearnvarchar40
TOPRegulatory reporting for insurance companies
305ISSRFLDEAActual line item table6RYEARFiscal Yearnvarchar40
306ISSRFLDEPPlan line items table6RYEARFiscal Yearnvarchar40
307ISSRFLDETSummary table5RYEARFiscal Yearnvarchar40
TOPRemaining Beverage - Obsolete Objects
308/BEV3/CHFIAActual line item table6RYEARFiscal Yearnvarchar40
309/BEV3/CHFIPPlan Line Items Table6RYEARFiscal Yearnvarchar40
310/BEV3/CHFITTotals table5RYEARFiscal Yearnvarchar40
311/BEV3/CHVGRAActual line item table6RYEARFiscal Yearnvarchar40
312/BEV3/CHVGRPPlan Line Items Table6RYEARFiscal Yearnvarchar40
313/BEV3/CHVGRTTotals table5RYEARFiscal Yearnvarchar40
TOPRetail Ledger
314PCRRETAILAActual line item table6RYEARFiscal Yearnvarchar40
315PCRRETAILPPlan line items table6RYEARFiscal Yearnvarchar40
316PCRRETAILTTotals Table5RYEARFiscal Yearnvarchar40
TOPSpecial Purpose Ledger
317/CCIS/PBU18APBU18: Actual line item table6RYEARFiscal Yearnvarchar40
318/CCIS/PBU18PPBU18: Plan line item table6RYEARFiscal Yearnvarchar40
319/CCIS/PBU18TPBU18: Summary table x5RYEARFiscal Yearnvarchar40
320/CCIS/PROFTAXAActual Line Items Table for General Ledger2RYEARFiscal Yearnvarchar40
321/CCIS/PROFTAXPPlan Line Items Table for General Ledger2RYEARFiscal Yearnvarchar40
322/CCIS/PROFTAXTTotals Table for General Ledger2RYEARFiscal Yearnvarchar40
TOPTariffs, Duties and Permits
323OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger6RYEARFiscal Yearnvarchar40
324OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger6RYEARFiscal Yearnvarchar40
325OIHEDTSummary table, IS-OIL Excise Duty Special Ledger5RYEARFiscal Yearnvarchar40
326OIHSLATDP (excise duty) special ledger actual line item table6RYEARFiscal Yearnvarchar40
327OIHSLTTDP (excise duty) special ledger summary table5RYEARFiscal Yearnvarchar40
TOPTransfer to Financial Accounting
328TRACTSLAActual Line Item Table6RYEARFiscal Yearnvarchar40
329TRACTSLPPlan Line Items Table6RYEARFiscal Yearnvarchar40
330TRACTSLTTotals Table5RYEARFiscal Yearnvarchar40
TOPUnited Kingdom
331PAGB_ASHEASHE Return Data2RYEARYearnvarchar40
332T5G_ASHE_CONTROLASHE Control Table2RYEARYearnvarchar40
TOPUSA
333T5U0EEqual Employment Opportunity Record3RYEAREvaluation yearnvarchar40
334T5UEEOEqual Employment Opportunity Record3RYEAREvaluation yearnvarchar40