| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZSAWT | Summary table | 111 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
2 | ZSEMBPST | Summary table | 107 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
3 | ZSPLITT | Summentabelle | 111 | QSPRED | Verteilungsschlüssel für Mengen | nvarchar | 4 | 0 | | |
4 | ZZ001T | Summary Table | 118 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
5 | ZZLINET | Summary table | 96 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
6 | ZZSL01T | Summary table | 120 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
7 | ZZSPECT | Summary table | 93 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPBasic Functions |
8 | FILCT | FI-LC: Global totals table with 2 object tables | 120 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
9 | GGREFT | Example for Global FI-SL Summary Table | 113 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
10 | GLFUNCT | Totals Table for Cost of Sales Accounting | 94 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
11 | GLREFT | Example for Local FI-SL Summary Table | 111 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
12 | GLTO1 | FI-SL Table with Objects, Structure Corresponds to GLT1 | 118 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
13 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 126 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
14 | GLTO3 | FISL Table with Objects, Amounts and Quantities in Format P9 | 118 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
15 | T820 | Planning Parameters | 10 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPCollectionsDisbursements |
16 | GLISDET | Summary Table for Insurance (DE) | 106 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
17 | GRISDET | Summary Table for Insurance (DE) - Rollup | 106 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPConsolidation |
18 | ECMCT | SAP Cons.: Totals Table | 103 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPCost Center Accounting |
19 | TKA51 | CO Planner Profile: Basic Configurations | 6 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPCost Element Accounting |
20 | COFIT | Totals Records for Reconciliation Ledger | 107 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPFinancial Services Localization |
21 | /CEEIS/RUT | Totals Table | 122 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPFlexible Real Estate Management |
22 | VIPRLEDTAGRT | Summentabelle Ledger 7A Mandate | 84 | QSPRED | Verteilungsschlüssel für Mengen | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Accounting |
23 | GLFLEXT | Flexible G/L: Totals | 121 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPGrantee Management |
24 | GMAVCT | Summary table | 94 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
25 | GMIT | Summary table | 76 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
26 | JVPSC01T | Summary table | 105 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
27 | JVT1 | JV Summary Table | 86 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
28 | JVTO1 | JV Summary Table with Objects | 101 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
29 | JVTO2 | JV Billing FI-SL Summary Table | 71 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPLocalization |
30 | J_3RFTAXRT | Tax Accounting: Summary table | 89 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
31 | J_3RFTAXRVT | Tax Accounting: Summary table | 89 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPProfit Center Accounting |
32 | GLPCT | EC-PCA: Totals Table | 100 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPProfitability Analysis |
33 | GLTPC | Profit Center Accounting | 84 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPRegulatory reporting for insurance companies |
34 | ISSRFLDET | Summary table | 145 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
35 | /BEV3/CHFIT | Totals table | 109 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
36 | /BEV3/CHVGRT | Totals table | 111 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPRetail Ledger |
37 | PCRRETAILT | Totals Table | 110 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPSpecial Purpose Ledger |
38 | /CCIS/PBU18T | PBU18: Summary table x | 124 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
39 | OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger | 125 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
40 | OIHSLT | TDP (excise duty) special ledger summary table | 92 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |
TOPTransfer to Financial Accounting |
41 | TRACTSLT | Totals Table | 103 | QSPRED | Distribution key for quantities | nvarchar | 4 | 0 | | |