| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GLT0_BAK | G/L Account Master Record Transaction Figures | 46 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
2 | ZSAWT | Summary table | 110 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
3 | ZSEMBPST | Summary table | 106 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
4 | ZSPLITT | Summentabelle | 110 | CSPRED | Verteilungsschlüssel für Währungsbeträge | nvarchar | 4 | 0 | | |
5 | ZZ001T | Summary Table | 117 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
6 | ZZLINET | Summary table | 95 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
7 | ZZSL01T | Summary table | 119 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
8 | ZZSPECT | Summary table | 92 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPAvailability Control |
9 | FMAVCT | AVC Summary Table (BCS) | 77 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPBasic Functions |
10 | FILCT | FI-LC: Global totals table with 2 object tables | 119 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
11 | GGREFT | Example for Global FI-SL Summary Table | 112 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
12 | GLFUNCT | Totals Table for Cost of Sales Accounting | 93 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
13 | GLREFT | Example for Local FI-SL Summary Table | 110 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
14 | GLT0 | G/L account master record transaction figures | 46 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
15 | GLT3 | Summary Data Preparations for Consolidation | 68 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
16 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 117 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
17 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 125 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
18 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 117 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
19 | T820 | Planning Parameters | 9 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPBudgeting |
20 | FMBDT | FM budget totals table | 78 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
21 | FMRBT | Summary table | 76 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
22 | GLISDET | Summary Table for Insurance (DE) | 105 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
23 | GRISDET | Summary Table for Insurance (DE) - Rollup | 105 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPConsolidation |
24 | ECMCT | SAP Cons.: Totals Table | 102 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPCost Center Accounting |
25 | TKA51 | CO Planner Profile: Basic Configurations | 5 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPCost Element Accounting |
26 | COFIT | Totals Records for Reconciliation Ledger | 106 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPData Retention Tool |
27 | TXW_S_GLT0 | Retrieve archived GLT0 data | 46 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
28 | FBICRC001T | ICRC: Open Items GL Accounts: Totals | 36 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
29 | FBICRC002T | ICRC: GL Accounts: Totals | 36 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
30 | FBICRC003T | ICRC: Open Items Customers/Vendors: Totals | 37 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPFinancial Services Localization |
31 | /CEEIS/RUT | Totals Table | 121 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
32 | VIPRLEDTAGRT | Summentabelle Ledger 7A Mandate | 83 | CSPRED | Verteilungsschlüssel für Währungsbeträge | nvarchar | 4 | 0 | | |
TOPFund Accounting |
33 | FMCCAVCT | Totals Table | 74 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPFunds Management |
34 | FMIT | Totals Table for Funds Management | 64 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
35 | FMSPLITT | Summary table | 67 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
36 | FMUSFGFACTS1T | Summary table | 63 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
37 | FMUSFGFACTS2T | Summary table | 67 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
38 | FMUSFGT | Summary table for US Federal Government | 63 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Accounting |
39 | GLFLEXT | Flexible G/L: Totals | 120 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPGrantee Management |
40 | GMAVCT | Summary table | 93 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
41 | GMIT | Summary table | 75 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
42 | JVPSC01T | Summary table | 104 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
43 | JVT1 | JV Summary Table | 85 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
44 | JVTO1 | JV Summary Table with Objects | 100 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
45 | JVTO2 | JV Billing FI-SL Summary Table | 70 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPLocalization |
46 | J_3RFTAXRT | Tax Accounting: Summary table | 88 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
47 | J_3RFTAXRVT | Tax Accounting: Summary table | 88 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPProfit Center Accounting |
48 | GLPCT | EC-PCA: Totals Table | 99 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPProfitability Analysis |
49 | GLTPC | Profit Center Accounting | 83 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPRegulatory reporting for insurance companies |
50 | ISSRFLDET | Summary table | 144 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
51 | /BEV3/CHFIT | Totals table | 108 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
52 | /BEV3/CHVGRT | Totals table | 110 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPRetail Ledger |
53 | PCRRETAILT | Totals Table | 109 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPSpecial Purpose Ledger |
54 | /CCIS/PBU18T | PBU18: Summary table x | 123 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
55 | OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger | 124 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
56 | OIHSLT | TDP (excise duty) special ledger summary table | 91 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |
TOPTransfer to Financial Accounting |
57 | TRACTSLT | Totals Table | 102 | CSPRED | Distribution key for currency amounts | nvarchar | 4 | 0 | | |